trees
1,381 rows where qSpecies_id = 54 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9445 | 32298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.7661430585802 | -122.40291664053 | (37.7661430585802, -122.40291664053) | 8 | 3 | 8 | 28853 | 20 | |
| 33065 | 15307 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.7714348870341 | -122.419572183108 | (37.7714348870341, -122.419572183108) | 8 | 2 | 9 | 28853 | 19 | ||
| 38615 | 98470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | 8 | 3 | 8 | 28853 | 20 | |||
| 39594 | 245462 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2886 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6007544.8329 | 2106792.8686 | 37.7652781065022 | -122.41711768386 | (37.7652781065022, -122.41711768386) | 8 | 4 | 7 | 28853 | 19 | |||
| 42174 | 15298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 6006986.0945 | 2109290.5977 | 37.7721048323796 | -122.419227425547 | (37.7721048323796, -122.419227425547) | 8 | 2 | 9 | 28853 | 19 | ||||
| 55406 | 98471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.402072026424 | (37.7661880408824, -122.402072026424) | 8 | 3 | 8 | 28853 | 20 | |||
| 64399 | 200832 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2000 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010535.924 | 2106957.4024 | 37.7658976908793 | -122.406783753376 | (37.7658976908793, -122.406783753376) | 8 | 4 | 8 | 28853 | 19 | |||
| 66866 | 98473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | 8 | 3 | 8 | 28853 | 20 | |||
| 70476 | 7391 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.7778930152772 | -122.40623154915 | (37.7778930152772, -122.40623154915) | 14 | 2 | 9 | 28853 | 34 | ||
| 70658 | 32296 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | 8 | 3 | 8 | 28853 | 20 | ||
| 79204 | 15302 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006948.3596 | 2109215.1279 | 37.7718954850631 | -122.419352599105 | (37.7718954850631, -122.419352599105) | 8 | 2 | 9 | 28853 | 19 | |||
| 79570 | 7389 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | 14 | 2 | 9 | 28853 | 34 | |||
| 83079 | 15282 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007118.1667 | 2109554.742 | 37.7728375468829 | -122.418789312367 | (37.7728375468829, -122.418789312367) | 8 | 2 | 9 | 28853 | 19 | |||
| 85272 | 98472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887 | -122.402121236301 | (37.766182021887, -122.402121236301) | 8 | 3 | 8 | 28853 | 20 | |||
| 91664 | 15300 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006966.3695 | 2109250.29 | 37.7719930461457 | -122.41929279621 | (37.7719930461457, -122.41929279621) | 8 | 2 | 9 | 28853 | 19 | |||
| 95032 | 7388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | 14 | 2 | 9 | 28853 | 34 | |||
| 106406 | 245439 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2940 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | 6007210.059 | 2106771.9452 | 37.7652018171161 | -122.418274106734 | (37.7652018171161, -122.418274106734) | 8 | 4 | 7 | 28853 | 19 | |||
| 112485 | 245461 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2886 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6007563.8542 | 2106794.7707 | 37.7652843992631 | -122.417052028294 | (37.7652843992631, -122.417052028294) | 8 | 4 | 7 | 28853 | 19 | |||
| 118043 | 98468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.401904660337 | (37.7662064164751, -122.401904660337) | 8 | 3 | 8 | 28853 | 20 | |||
| 125485 | 7384 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | 14 | 2 | 9 | 28853 | 34 | |||
| 141675 | 32294 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011626.7926 | 2107023.9767 | 37.7661414653506 | -122.403015326989 | (37.7661414653506, -122.403015326989) | 8 | 3 | 8 | 28853 | 20 | ||
| 147380 | 15299 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006975.8032 | 2109269.1574 | 37.7720453828325 | -122.419261502886 | (37.7720453828325, -122.419261502886) | 8 | 2 | 9 | 28853 | 19 | |||
| 148626 | 7390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.406286098573 | (37.7778494726714, -122.406286098573) | 14 | 2 | 9 | 28853 | 34 | |||
| 152768 | 15334 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | 8 | 4 | 7 | 28853 | 19 | ||
| 162894 | 15301 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006957.7934 | 2109234.853 | 37.7719501768124 | -122.419321366374 | (37.7719501768124, -122.419321366374) | 8 | 2 | 9 | 28853 | 19 | |||
| 167706 | 32297 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.7661110048054 | -122.403445656745 | (37.7661110048054, -122.403445656745) | 8 | 3 | 8 | 28853 | 20 | ||
| 175326 | 15326 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006681.5676 | 2108466.3283 | 37.7698244299152 | -122.420222300021 | (37.7698244299152, -122.420222300021) | 8 | 4 | 7 | 28853 | 19 | |||
| 187827 | 15319 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1680 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006779.4102 | 2108712.5677 | 37.7705060574636 | -122.419901340101 | (37.7705060574636, -122.419901340101) | 8 | 2 | 9 | 28853 | 19 | |||
| 189470 | 245460 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6007306.1163 | 2106778.6027 | 37.7652255036159 | -122.417942338761 | (37.7652255036159, -122.417942338761) | 8 | 4 | 7 | 28853 | 19 | |||
| 191040 | 254075 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010957 | 2108832 | 37.7710684598289 | -122.405459366064 | (37.7710684598289, -122.405459366064) | 14 | 2 | 9 | 28853 | 34 | ||||
| 2413 | 201183 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013416.1569 | 2113924.2034 | 37.7851876840649 | -122.397310155353 | (37.7851876840649, -122.397310155353) | 6 | 2 | 9 | 28855 | 6 | |||
| 34608 | 201185 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6013380.1682 | 2113890.2713 | 37.7850925106546 | -122.397432285471 | (37.7850925106546, -122.397432285471) | 6 | 2 | 9 | 28855 | 6 | |||
| 37283 | 201180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 608 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013469.6258 | 2113973.5593 | 37.785326180656 | -122.397128630227 | (37.785326180656, -122.397128630227) | 6 | 2 | 9 | 28855 | 6 | |||
| 74806 | 201182 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.7852310646842 | -122.397247203178 | (37.7852310646842, -122.397247203178) | 6 | 2 | 9 | 28855 | 6 | |||
| 134048 | 201184 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013400.7332 | 2113908.7797 | 37.7851444754357 | -122.397362434941 | (37.7851444754357, -122.397362434941) | 6 | 2 | 9 | 28855 | 6 | |||
| 147457 | 201181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 608 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013452.1456 | 2113958.1356 | 37.7852828576216 | -122.39718802493 | (37.7852828576216, -122.39718802493) | 6 | 2 | 9 | 28855 | 6 | |||
| 14187 | 201882 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | 6 | 2 | 9 | 28856 | 6 | |||
| 98202 | 110911 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6013393.5354 | 2113814.1809 | 37.7848843282601 | -122.397380700853 | (37.7848843282601, -122.397380700853) | 6 | 2 | 9 | 28856 | 6 | ||||
| 120865 | 110909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | 6 | 2 | 9 | 28856 | 6 | ||||
| 136076 | 110908 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6013338.0101 | 2113761.7403 | 37.7847372468928 | -122.397569122522 | (37.7847372468928, -122.397569122522) | 6 | 2 | 9 | 28856 | 6 | ||||
| 151202 | 110907 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6013321.5581 | 2113739.1188 | 37.7846742173914 | -122.397624454233 | (37.7846742173914, -122.397624454233) | 6 | 2 | 9 | 28856 | 6 | ||||
| 7836 | 72023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.407543551006 | (37.7919886256319, -122.407543551006) | 5 | 1 | 10 | 28857 | 21 | |||
| 22448 | 143498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.724 | 2117930.0991 | 37.7960642762572 | -122.405198277055 | (37.7960642762572, -122.405198277055) | 3 | 1 | 10 | 28857 | 4 | |||
| 30141 | 143475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010503.0699 | 2116501.51 | 37.7921017369748 | -122.407570359871 | (37.7921017369748, -122.407570359871) | 5 | 1 | 10 | 28857 | 21 | |||
| 32385 | 143482 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010529.9358 | 2116279.9602 | 37.7914949183295 | -122.407461776619 | (37.7914949183295, -122.407461776619) | 5 | 1 | 10 | 28857 | 21 | |||
| 39600 | 143497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.7960885666374 | -122.40520051379 | (37.7960885666374, -122.40520051379) | 3 | 1 | 10 | 28857 | 4 | |||
| 55085 | 143481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010890.3641 | 2116278.8196 | 37.7915119538645 | -122.40621461367 | (37.7915119538645, -122.40621461367) | 5 | 1 | 10 | 28857 | 6 | |||
| 78902 | 143556 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.7960354859857 | -122.404999078913 | (37.7960354859857, -122.404999078913) | 3 | 1 | 10 | 28857 | 4 | |||
| 89354 | 143480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010907.473 | 2116280.5305 | 37.7915176085666 | -122.406155537422 | (37.7915176085666, -122.406155537422) | 5 | 1 | 10 | 28857 | 6 | |||
| 109940 | 258056 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 120425 | 258058 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 137907 | 258057 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 170680 | 143496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | 3 | 1 | 10 | 28857 | 4 | |||
| 180082 | 143557 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | 3 | 1 | 10 | 28857 | 4 | |||
| 191059 | 258059 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 8801 | 138109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004876.0712 | 2114750.6655 | 37.7869777775164 | -122.426915105637 | (37.7869777775164, -122.426915105637) | 13 | 9 | 11 | 28858 | 27 | |||
| 13989 | 137919 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1963 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004551.2938 | 2115340.9969 | 37.788580310137 | -122.428080846949 | (37.788580310137, -122.428080846949) | 13 | 9 | 11 | 28858 | 27 | |||
| 23778 | 21585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | 13 | 9 | 11 | 28858 | 27 | |||
| 24167 | 31656 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | 13 | 9 | 11 | 28858 | 27 | |
| 24735 | 137798 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004365.9463 | 2115528.293 | 37.7890840898669 | -122.428735478435 | (37.7890840898669, -122.428735478435) | 13 | 9 | 11 | 28858 | 27 | |||
| 25242 | 142827 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | 13 | 9 | 10 | 28858 | 32 | |||
| 34952 | 21609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005037.9058 | 2114711.086 | 37.7868782513618 | -122.42635237507 | (37.7868782513618, -122.42635237507) | 13 | 9 | 11 | 28858 | 13 | ||
| 38247 | 21606 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | 13 | 9 | 11 | 28858 | 13 | |||
| 40612 | 6232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.426364020332 | (37.7832135118405, -122.426364020332) | 7 | 9 | 11 | 28858 | 41 | ||
| 47439 | 137799 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004356.41 | 2115593.3639 | 37.789262218427 | -122.42877311351 | (37.789262218427, -122.42877311351) | 13 | 9 | 11 | 28858 | 27 | |||
| 50824 | 21628 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/1994 12:00:00 AM | 6 | 4X4 | 6004654.6857 | 2114664.3643 | 37.7867282957499 | -122.427674898563 | (37.7867282957499, -122.427674898563) | 13 | 9 | 11 | 28858 | 13 | ||
| 51393 | 137896 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1832 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004416.1912 | 2115174.8872 | 37.7881165700494 | -122.428536436558 | (37.7881165700494, -122.428536436558) | 13 | 9 | 11 | 28858 | 27 | |||
| 58460 | 138112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6004508.5013 | 2114699.1479 | 37.7868155327596 | -122.428183141793 | (37.7868155327596, -122.428183141793) | 13 | 9 | 11 | 28858 | 27 | |||
| 59417 | 6235 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | 7 | 9 | 11 | 28858 | 41 | ||
| 63070 | 92953 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1338 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006789.4485 | 2115574.9476 | 37.7893490550841 | -122.420353767408 | (37.7893490550841, -122.420353767408) | 13 | 9 | 10 | 28858 | 21 | ||||
| 68181 | 21650 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1688 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004543.8112 | 2114703.7787 | 37.7868302455522 | -122.428061307883 | (37.7868302455522, -122.428061307883) | 13 | 9 | 11 | 28858 | 27 | |||
| 71416 | 138011 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1401 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005427.9087 | 2114512.7674 | 37.7863557555391 | -122.424988938346 | (37.7863557555391, -122.424988938346) | 13 | 9 | 11 | 28858 | 13 | |||
| 72034 | 92952 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1334 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006791.0528 | 2115558.9055 | 37.789305097845 | -122.420347077615 | (37.789305097845, -122.420347077615) | 13 | 9 | 10 | 28858 | 21 | ||||
| 76309 | 137800 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004352.4834 | 2115615.8021 | 37.7893236058288 | -122.42878829933 | (37.7893236058288, -122.42878829933) | 13 | 9 | 11 | 28858 | 27 | |||
| 81789 | 98493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1703 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6006578.8967 | 2116733.3834 | 37.7925179651008 | -122.421164544764 | (37.7925179651008, -122.421164544764) | 13 | 9 | 10 | 28858 | 32 | ||||
| 85092 | 138010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005424.6122 | 2114535.843 | 37.7864189291949 | -122.425001985822 | (37.7864189291949, -122.425001985822) | 13 | 9 | 11 | 28858 | 13 | |||
| 114186 | 138001 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1685 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004515.7645 | 2114645.0665 | 37.7866674497361 | -122.428154157217 | (37.7866674497361, -122.428154157217) | 13 | 9 | 11 | 28858 | 13 | |||
| 114973 | 21587 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005314.2609 | 2114809.1294 | 37.7871630716128 | -122.425403229176 | (37.7871630716128, -122.425403229176) | 13 | 9 | 11 | 28858 | 27 | |||
| 128466 | 6224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6005090.9413 | 2113387.3731 | 37.7832466624445 | -122.426074615309 | (37.7832466624445, -122.426074615309) | 7 | 9 | 11 | 28858 | 41 | |||
| 130807 | 21632 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1991 12:00:00 AM | 12 | 4X4 | 6004741.4911 | 2114677.6404 | 37.7867696583856 | -122.427375518495 | (37.7867696583856, -122.427375518495) | 13 | 9 | 11 | 28858 | 13 | ||
| 131718 | 6245 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | 7 | 9 | 11 | 28858 | 41 | ||
| 136758 | 6242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.7831383969133 | -122.426886998286 | (37.7831383969133, -122.426886998286) | 7 | 9 | 11 | 28858 | 41 | ||
| 149305 | 2590 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1712 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005179.844 | 2115138.5122 | 37.7880598792815 | -122.425891737823 | (37.7880598792815, -122.425891737823) | 13 | 9 | 11 | 28858 | 27 | |||
| 150365 | 21589 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | 13 | 9 | 11 | 28858 | 27 | |||
| 151305 | 31653 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.7870601003628 | -122.428333544653 | (37.7870601003628, -122.428333544653) | 13 | 9 | 11 | 28858 | 27 | ||
| 159445 | 58051 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.7917406740828 | -122.421003598405 | (37.7917406740828, -122.421003598405) | 13 | 9 | 10 | 28858 | 21 | ||
| 159684 | 142820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1754 POLK ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 0ft | 6006598.3556 | 2116937.7026 | 37.7930800716409 | -122.421111730561 | (37.7930800716409, -122.421111730561) | 13 | 9 | 10 | 28858 | 32 | |||
| 170781 | 21586 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | 13 | 9 | 11 | 28858 | 27 | |||
| 174365 | 21629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004674.0893 | 2114666.9174 | 37.7867364034737 | -122.427607948661 | (37.7867364034737, -122.427607948661) | 13 | 9 | 11 | 28858 | 13 | ||
| 182903 | 21608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.7868750020607 | -122.42646540299 | (37.7868750020607, -122.42646540299) | 13 | 9 | 11 | 28858 | 13 | ||
| 182991 | 21588 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.425473076473 | (37.7871523906748, -122.425473076473) | 13 | 9 | 11 | 28858 | 27 | |||
| 190740 | 21590 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.7871328144412 | -122.425600795702 | (37.7871328144412, -122.425600795702) | 13 | 9 | 11 | 28858 | 27 | |||
| 193191 | 138110 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6004839.6037 | 2114746.6136 | 37.7869645899648 | -122.427040986298 | (37.7869645899648, -122.427040986298) | 13 | 9 | 11 | 28858 | 27 | |||
| 831 | 245412 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | 2 | 4 | 7 | 28859 | 19 | |||
| 1544 | 245421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443998 | -122.409836678395 | (37.752691443998, -122.409836678395) | 2 | 4 | 7 | 28859 | 19 | |||
| 3102 | 245419 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009862.9212 | 2102186.0881 | 37.7527590594841 | -122.408774895147 | (37.7527590594841, -122.408774895147) | 2 | 4 | 7 | 28859 | 19 | |||
| 5046 | 245409 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | 2 | 4 | 7 | 28859 | 19 | |||
| 5364 | 245472 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | 10 | 4 | 7 | 28859 | 19 | |||
| 6070 | 519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | 2 | 4 | 7 | 28859 | 19 | |||
| 6605 | 528 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | 2 | 4 | 7 | 28859 | 19 |
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) );