trees
361 rows where PlotSize = "3x3" and qSpecies_id = 6 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9840 | 256599 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 10365 | 256095 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | ||||
| 10786 | 95722 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
| 16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
| 16319 | 258436 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002636 | 2104802 | 37.7595342910111 | -122.433953838093 | (37.7595342910111, -122.433953838093) | 2 | 4 | 5 | 28862 | 3 | ||||
| 16338 | 261024 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 751 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989703 | 2110237 | 37.773714894321 | -122.479079631213 | (37.773714894321, -122.479079631213) | 11 | 6 | 2 | 55 | 26 | |||
| 17128 | 39895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50795 | 6001095.73329197 | 2104700.06064199 | 37.7591668603211 | -122.439273525739 | (37.7591668603211, -122.439273525739) | 2 | 4 | 5 | 28862 | 3 | ||
| 18289 | 88190 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1118 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631 | 2110372 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | 8 | 2 | 9 | 28853 | 34 | |||
| 19897 | 102064 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52559 | 6007929.8 | 2098099.2 | 37.7414289135067 | -122.415170728099 | (37.7414289135067, -122.415170728099) | 2 | 7 | 7 | 28859 | 2 | |
| 20319 | 106193 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638004 | -122.499011481047 | (37.742177638004, -122.499011481047) | 1 | 8 | 3 | 29491 | 35 | ||||
| 23031 | 88096 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.499127022602 | (37.7534794912156, -122.499127022602) | 1 | 8 | 3 | 56 | 35 | |||
| 23899 | 95684 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 334 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767433 | 6006626.2 | 2092405.9 | 37.72572301772 | -122.419274361386 | (37.72572301772, -122.419274361386) | 9 | 7 | 7 | 309 | 5 | |
| 24082 | 88257 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
| 24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 28853 | 88712 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51654 | 6004166 | 2109783 | 37.7732976245409 | -122.429017475211 | (37.7732976245409, -122.429017475211) | 7 | 9 | 11 | 29492 | 10 | ||
| 29256 | 256605 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 29381 | 94673 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53809 | 5997706.3 | 2095032.9 | 37.7324297402139 | -122.450298904109 | (37.7324297402139, -122.450298904109) | 9 | 7 | 4 | 59 | 40 | |
| 29816 | 95998 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
| 31525 | 251509 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 31876 | 88495 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 27 Reddy St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659 | 2094063 | 37.7306666521666 | -122.395078350002 | (37.7306666521666, -122.395078350002) | 10 | 3 | 8 | 58 | 1 | |||
| 32904 | 256600 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 32912 | 94410 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.437511336741 | (37.7694955715896, -122.437511336741) | 15 | 5 | 5 | 29492 | 9 | ||
| 32952 | 37416 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51465 | 6001976.15825924 | 2100785.18555 | 37.7484676127991 | -122.435948474317 | (37.7484676127991, -122.435948474317) | 2 | 4 | 5 | 28862 | 22 | ||
| 41225 | 82433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.407911712216 | (37.745350741274, -122.407911712216) | 2 | 7 | 7 | 28859 | 2 | ||
| 42678 | 87855 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2537 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2008 12:00:00 AM | 3x3 | Permit Number 50783 | 6006632 | 2119882 | 37.8011662683494 | -122.421204486113 | (37.8011662683494, -122.421204486113) | 5 | 9 | 1 | 28858 | 32 | ||
| 47337 | 83396 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50820 | 6002600.50899636 | 2105341.51117361 | 37.7610136443426 | -122.43411515125 | (37.7610136443426, -122.43411515125) | 15 | 4 | 5 | 28862 | 3 | ||
| 51502 | 94694 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
| 51877 | 256607 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 54999 | 101252 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992716.9 | 2106688.9 | 37.7641473244126 | -122.468395985577 | (37.7641473244126, -122.468395985577) | 11 | 8 | 11 | 56 | 12 | ||||
| 55354 | 92858 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
| 58225 | 88206 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 187 Beaumont Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51211 | 5996832.5 | 2111680.5 | 37.7780898241501 | -122.454522014682 | (37.7780898241501, -122.454522014682) | 15 | 6 | 2 | 54 | 16 | |||
| 59014 | 95404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | 2 | 7 | 5 | 63 | 22 | |
| 60630 | 81333 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53535 | 5993364.90659405 | 2104537.49939321 | 37.7582775482109 | -122.46599839572 | (37.7582775482109, -122.46599839572) | 1 | 8 | 4 | 56 | 12 | ||
| 61590 | 256576 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 66000 | 88139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 523 Teresita Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51168 | 5998937.5 | 2097522.9 | 37.7393370734625 | -122.446221422912 | (37.7393370734625, -122.446221422912) | 9 | 7 | 4 | 59 | 40 | |||
| 68875 | 88095 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.499127022602 | (37.7534794912156, -122.499127022602) | 1 | 8 | 3 | 56 | 35 | |||
| 70541 | 256574 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 77162 | 102385 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 78293 | 116736 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 79056 | 94672 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.450213143469 | (37.732430335747, -122.450213143469) | 9 | 7 | 4 | 59 | 40 | |
| 79736 | 251742 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
| 80064 | 83344 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4443-4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50816 | 6001265.82005399 | 2105215.83153824 | 37.7605927188575 | -122.43872224382 | (37.7605927188575, -122.43872224382) | 2 | 4 | 5 | 28862 | 3 | ||
| 84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 86000 | 37052 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 156 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49822 | 6005524.96145532 | 2099948.44891125 | 37.7463710884027 | -122.423617283508 | (37.7463710884027, -122.423617283508) | 2 | 7 | 5 | 28859 | 22 | ||
| 86722 | 94695 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
| 87404 | 88256 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
| 88149 | 88094 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1474 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51098 | 5983765.2 | 2105129.7 | 37.7593450832678 | -122.499241618892 | (37.7593450832678, -122.499241618892) | 1 | 8 | 3 | 56 | 35 | |||
| 89162 | 88397 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.7817097621118 | -122.487138517946 | (37.7817097621118, -122.487138517946) | 11 | 6 | 2 | 55 | 26 | ||
| 92562 | 256604 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 98805 | 254526 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |||
| 103037 | 251507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 104233 | 102092 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 108409 | 88108 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1935 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51112 | 5981615.2 | 2101901.1 | 37.7503538981052 | -122.50643780728 | (37.7503538981052, -122.50643780728) | 1 | 8 | 3 | 29491 | 35 | |||
| 108745 | 92226 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||
| 108856 | 88244 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4330 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51231 | 6000585 | 2105809 | 37.7621826583789 | -122.441119442302 | (37.7621826583789, -122.441119442302) | 15 | 5 | 5 | 28862 | 3 | |||
| 109198 | 94671 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
| 111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 111712 | 253162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004481 | 2091226 | 37.7223622223708 | -122.426606175157 | (37.7223622223708, -122.426606175157) | 9 | 7 | 6 | 28861 | 5 | ||||
| 114382 | 102384 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 117364 | 88527 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1501 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51477 | 5994255.6 | 2105256.2 | 37.7603022580943 | -122.462970154312 | (37.7603022580943, -122.462970154312) | 1 | 5 | 4 | 56 | 12 | |||
| 119754 | 116735 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 120895 | 88732 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1732 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51666 | 6003104.1 | 2114241.2 | 37.7854785624412 | -122.433009307654 | (37.7854785624412, -122.433009307654) | 13 | 9 | 11 | 29490 | 13 | ||
| 120971 | 95999 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 121056 | 251749 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 601 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002875 | 2087693 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | 9 | 7 | 6 | 28861 | 5 | |||||
| 122458 | 87640 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | 10 | 3 | 8 | 58 | 1 | |||
| 125722 | 82079 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1648 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50227 | 6009276.07844564 | 2099765.78028808 | 37.7460805446245 | -122.410633408071 | (37.7460805446245, -122.410633408071) | 2 | 7 | 7 | 28859 | 2 | ||
| 126325 | 92859 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
| 131156 | 251508 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 132614 | 251506 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 134136 | 84680 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | 9 | 8 | 4 | 28861 | 24 | ||
| 134706 | 256601 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 134804 | 82755 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50226 | 6009275.52393785 | 2099776.98643755 | 37.746111283151 | -122.410636116717 | (37.746111283151, -122.410636116717) | 2 | 7 | 7 | 28859 | 2 | ||
| 136198 | 255789 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2240 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003983 | 2116665 | 37.7921835181407 | -122.430141547967 | (37.7921835181407, -122.430141547967) | 13 | 9 | 1 | 29490 | 27 | ||||
| 137235 | 88480 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51432 | 6014837 | 2096254 | 37.7367481304458 | -122.391158879645 | (37.7367481304458, -122.391158879645) | 10 | 3 | 8 | 58 | 1 | ||
| 139732 | 88255 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51240 | 5998220 | 2108137 | 37.7684397634087 | -122.44946678759 | (37.7684397634087, -122.44946678759) | 15 | 5 | 11 | 29492 | 9 | |||
| 141188 | 83302 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2366 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50740 | 5982401.73888916 | 2099005.47811571 | 37.7424496018256 | -122.503503550435 | (37.7424496018256, -122.503503550435) | 1 | 8 | 3 | 29491 | 35 | ||
| 142495 | 88724 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1009 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
| 144492 | 116789 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 530 CRESCENT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007719 | 2095661 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | 2 | 7 | 7 | 28859 | 2 | ||||
| 146035 | 84332 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 804 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51851 | 5986981.94009984 | 2110441.32651783 | 37.7741175201244 | -122.488507097746 | (37.7741175201244, -122.488507097746) | 11 | 6 | 2 | 55 | 26 | ||
| 148992 | 94654 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689 | 2095884 | 37.7351072400417 | -122.429675988088 | (37.7351072400417, -122.429675988088) | 2 | 7 | 5 | 63 | 7 | |
| 149039 | 83301 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2194 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
| 149723 | 254437 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:04:00 PM | 3x3 | 5981264 | 2105479 | 37.7601571100533 | -122.507917756824 | (37.7601571100533, -122.507917756824) | 1 | 8 | 3 | 56 | 35 | ||
| 152474 | 94162 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1750 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53533 | 5993469.4 | 2103573.4 | 37.7556364086322 | -122.465566975178 | (37.7556364086322, -122.465566975178) | 1 | 8 | 4 | 56 | 12 | ||
| 155024 | 83961 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50859 | 5997460.19616594 | 2106774.33360384 | 37.7646547355545 | -122.451996543237 | (37.7646547355545, -122.451996543237) | 15 | 5 | 11 | 29492 | 9 | ||
| 158967 | 79726 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50955 | 6008416.19534554 | 2114892.53002417 | 37.7875668360064 | -122.414677080613 | (37.7875668360064, -122.414677080613) | 5 | 1 | 10 | 28858 | 21 | ||
| 159117 | 51978 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50788 | 6003031.54377055 | 2104930.91129788 | 37.7599106895436 | -122.432595060758 | (37.7599106895436, -122.432595060758) | 2 | 4 | 5 | 28862 | 3 | ||
| 160238 | 256575 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 163948 | 42105 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51455 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 | ||
| 164870 | 87861 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | 2 | 4 | 5 | 28862 | 3 | ||
| 165167 | 95901 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767603 | 5989092 | 2103686.6 | 37.7556937768723 | -122.480713514054 | (37.7556937768723, -122.480713514054) | 1 | 8 | 3 | 56 | 35 | |
| 166093 | 88438 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421 | 2117567 | 37.7949666840821 | -122.411389656386 | (37.7949666840821, -122.411389656386) | 3 | 1 | 10 | 28857 | 4 | |||
| 167721 | 102093 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 167767 | 88087 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1254 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51087 | 5984334.6 | 2106629.9 | 37.7634975987144 | -122.497383137852 | (37.7634975987144, -122.497383137852) | 1 | 8 | 3 | 56 | 35 | |||
| 167882 | 94679 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 218 Roanoke St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547 | 2096007 | 37.7354369283878 | -122.430175705062 | (37.7354369283878, -122.430175705062) | 2 | 7 | 5 | 63 | 7 | |
| 169137 | 98848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795X 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 3x3 | Permit Number 768753 | 5986486.2 | 2103095 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | 1 | 8 | 3 | 56 | 35 | ||
| 173908 | 251743 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 Cordova St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001773 | 2087479 | 37.7119203272299 | -122.43569914015 | (37.7119203272299, -122.43569914015) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );