Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83618 | 83618 | 693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 83639 | 83639 | 66275 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | ||
| 83739 | 83739 | 7183 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 857 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.777459984774396 | -122.43166416476002 | (37.7774599847744, -122.43166416476) | |||
| 83775 | 83775 | 55163 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1328 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1993 12:00:00 AM | Permit Number 31912 | 6002514.24849197 | 2101716.89965545 | 37.751056432832996 | -122.43415436705601 | (37.751056432833, -122.434154367056) | |||
| 83805 | 83805 | 24453 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 83892 | 83892 | 9617 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002921.99888 | 2111973.13636 | 37.7792406996886 | -122.433477183837 | (37.7792406996886, -122.433477183837) | |||
| 84017 | 84017 | 6816 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 84072 | 84072 | 49260 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 84293 | 84293 | 111114 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2085 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5997903.58032533 | 2109906.22418863 | 37.773279493542795 | -122.45068882440701 | (37.7732794935428, -122.450688824407) | ||||
| 84598 | 84598 | 95554 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1333@ Larkin Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007121.0 | 2115358.0 | 37.7887720478953 | -122.419191239667 | (37.7887720478953, -122.419191239667) | |||||
| 84824 | 84824 | 106999 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 Loyola Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998469.2817 | 2110801.2236 | 37.7757692966762 | -122.448796472896 | (37.7757692966762, -122.448796472896) | |||||
| 84916 | 84916 | 44061 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 84958 | 84958 | 50566 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 85222 | 85222 | 504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | |||
| 85495 | 85495 | 49269 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 85575 | 85575 | 63094 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2780 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1986 12:00:00 AM | 3x3 | Permit Number 23579 | 6001505.6405737 | 2115674.07424093 | 37.789322069479 | -122.438642199545 | (37.789322069479, -122.438642199545) | ||
| 85758 | 85758 | 21814 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 85759 | 85759 | 17049 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1209 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001136.98076 | 2109644.95458 | 37.772746663924295 | -122.439485345621 | (37.7727466639243, -122.439485345621) | |||
| 85835 | 85835 | 15158 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 85850 | 85850 | 9615 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002927.21435 | 2111923.58629 | 37.77910494348671 | -122.43345559949101 | (37.7791049434867, -122.433455599491) | |||
| 85878 | 85878 | 92850 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3150 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Permit Number 53071 | 5999589.0 | 2116381.0 | 37.7911538835614 | -122.44532437717501 | (37.7911538835614, -122.445324377175) | |||
| 86004 | 86004 | 21810 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2627 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6008310.29957 | 2121825.65474 | 37.806597526846 | -122.415534509856 | (37.806597526846, -122.415534509856) | |||
| 86274 | 86274 | 21818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2693 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008270.977530001 | 2122039.96134 | 37.80718374817771 | -122.415685775277 | (37.8071837481777, -122.415685775277) | |||
| 86351 | 86351 | 46223 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1888 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | |||
| 86422 | 86422 | 52076 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | Permit Number 48272 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 86513 | 86513 | 50374 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2727 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.795056658547395 | -122.43854412401001 | (37.7950566585474, -122.43854412401) | ||||
| 86610 | 86610 | 20161 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 86652 | 86652 | 110988 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 86670 | 86670 | 59066 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1658 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1980 12:00:00 AM | Permit Number 18361 | 6003975.177671 | 2098610.37486855 | 37.7426094440159 | -122.428880876877 | (37.7426094440159, -122.428880876877) | |||
| 86675 | 86675 | 121337 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5995656.55399656 | 2107084.69972772 | 37.765403444810204 | -122.45825728758899 | (37.7654034448102, -122.458257287589) | ||||
| 86725 | 86725 | 15165 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 86731 | 86731 | 100705 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 86735 | 86735 | 32649 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 86827 | 86827 | 20091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2075X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.45345917871401 | (37.7709958615587, -122.453459178714) | |||
| 87064 | 87064 | 58078 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4624 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1977 12:00:00 AM | Permit Number 17049 | 6000401.0 | 2105218.0 | 37.7605494356876 | -122.44171341046699 | (37.7605494356876, -122.441713410467) | |||
| 87077 | 87077 | 108943 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 87132 | 87132 | 20160 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 87165 | 87165 | 40350 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 Tehama St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011468.97735143 | 2112560.39183232 | 37.781334376632294 | -122.40395082417601 | (37.7813343766323, -122.403950824176) | ||
| 87388 | 87388 | 488 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | |||
| 87402 | 87402 | 32646 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 87450 | 87450 | 102505 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 290X Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x7 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | ||||
| 87520 | 87520 | 6801 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1385 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016634.4993322 | 2097405.4643513 | 37.7400094064471 | -122.38502428222701 | (37.7400094064471, -122.385024282227) | |||
| 87592 | 87592 | 48702 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 87651 | 87651 | 15152 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 87672 | 87672 | 107653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 87696 | 87696 | 22711 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 87733 | 87733 | 109596 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3332 21ST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6006085.3 | 2103802.1 | 37.7569839418566 | -122.421953398845 | (37.7569839418566, -122.421953398845) | |||
| 87941 | 87941 | 44245 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | |||
| 88003 | 88003 | 7190 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 896 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5X5 | 6003496.10413 | 2111301.12929 | 37.7774280906657 | -122.431443131507 | (37.7774280906657, -122.431443131507) | |||
| 88029 | 88029 | 5481 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 88161 | 88161 | 86905 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775.0 | 2106383.0 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | ||
| 88264 | 88264 | 45334 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 946 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44166 | 6002468.75387281 | 2109900.46778234 | 37.7735239435411 | -122.43489687663099 | (37.7735239435411, -122.434896876631) | ||||
| 88334 | 88334 | 28383 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 286 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6006047.68288 | 2107930.23885 | 37.7683167183705 | -122.422376798825 | (37.7683167183705, -122.422376798825) | ||||
| 88349 | 88349 | 59060 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4437 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1992 12:00:00 AM | 14 | 2x2 | Permit Number 30882 | 6000423.21385776 | 2102243.23045707 | 37.75238271007429 | -122.441423120737 | (37.7523827100743, -122.441423120737) | |
| 88384 | 88384 | 22722 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 88655 | 88655 | 56688 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1865X Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 17346 | 6002930.0 | 2119911.0 | 37.801036497901 | -122.43401707700701 | (37.801036497901, -122.434017077007) | ||
| 88656 | 88656 | 12996 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 340 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010677.76597 | 2120690.6320599997 | 37.8036138232581 | -122.407261344489 | (37.8036138232581, -122.407261344489) | |||
| 88745 | 88745 | 21736 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1980 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003117.217019999 | 2114500.6400200003 | 37.786191663102706 | -122.432982468773 | (37.7861916631027, -122.432982468773) | |||
| 89318 | 89318 | 110998 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 89324 | 89324 | 57802 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.753239209170204 | -122.44075659160102 | (37.7532392091702, -122.440756591601) | |
| 89466 | 89466 | 49274 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 89692 | 89692 | 24451 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 89861 | 89861 | 32647 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 90447 | 90447 | 106522 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 90460 | 90460 | 94216 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1X Tehama St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | ||
| 90591 | 90591 | 24452 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 90806 | 90806 | 4728 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 90830 | 90830 | 48449 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1971 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | Permit Number 45821 | 6004348.70626507 | 2107156.39257844 | 37.7660959373339 | -122.428198241647 | (37.7660959373339, -122.428198241647) | |||
| 90900 | 90900 | 96407 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||||
| 91086 | 91086 | 61476 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1942 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1984 12:00:00 AM | 20 | 4x3 | Permit Number 21419 | 6004543.5 | 2107230.3 | 37.766309889023795 | -122.427529754413 | (37.7663098890238, -122.427529754413) | |
| 91195 | 91195 | 48704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 91289 | 91289 | 40353 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | ||
| 91294 | 91294 | 106105 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 744x MONTGOMERY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011751.6 | 2117873.5 | 37.7959387009634 | -122.40334696666599 | (37.7959387009634, -122.403346966666) | |||||
| 91358 | 91358 | 106526 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 91527 | 91527 | 111115 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2085 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5997903.58032533 | 2109906.22418863 | 37.773279493542795 | -122.45068882440701 | (37.7732794935428, -122.450688824407) | ||||
| 91816 | 91816 | 694 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 91977 | 91977 | 55728 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2158 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1973 12:00:00 AM | 15 | 4x4 | Permit Number 11754 | 6003183.89247133 | 2107143.93253238 | 37.7659957501376 | -122.432226208659 | (37.7659957501376, -122.432226208659) | |
| 91993 | 91993 | 20162 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 92050 | 92050 | 13211 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2190 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6001897.52108 | 2119466.2299099998 | 37.7997566277665 | -122.437558020868 | (37.7997566277665, -122.437558020868) | |||
| 92066 | 92066 | 49276 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 92230 | 92230 | 18160 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6005423.38609 | 2114511.38367 | 37.7863517006932 | -122.42500448695 | (37.7863517006932, -122.42500448695) | |||
| 92260 | 92260 | 96411 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2012 12:00:00 AM | Permit Number 768662 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||
| 92282 | 92282 | 9941 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 5x6 | Resulted descion 9/7/16 -DE | 6010050.959969999 | 2119172.47111 | 37.7994102279433 | -122.40932324608299 | (37.7994102279433, -122.409323246083) | |
| 92293 | 92293 | 106915 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772728 | 5995876.045419999 | 2115884.62189 | 37.7895783172049 | -122.458135060161 | (37.7895783172049, -122.458135060161) | ||||
| 92336 | 92336 | 108326 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 86 11TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | ||||
| 92438 | 92438 | 33008 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1311 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 6x4 | Permit Number 37302 | 5994224.05093468 | 2106581.50911401 | 37.7639393951455 | -122.463175433011 | (37.7639393951455, -122.463175433011) | ||
| 92746 | 92746 | 57298 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | 5x5 | Permit Number 16120 | 6006015.66145192 | 2106707.62529636 | 37.764957905287105 | -122.422400676647 | (37.7649579052871, -122.422400676647) | |
| 92780 | 92780 | 41199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 92844 | 92844 | 15169 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 92899 | 92899 | 51836 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.40515074482401 | (37.7961377205174, -122.405150744824) | |||
| 92991 | 92991 | 21583 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1499 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005557.61202 | 2114792.21407 | 37.7871303723087 | -122.42456008266599 | (37.7871303723087, -122.424560082666) | |||
| 93063 | 93063 | 51761 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 Tehama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 48028 | 6011451.43524212 | 2112543.5849209 | 37.781287248695996 | -122.404010328515 | (37.781287248696, -122.404010328515) | ||
| 93269 | 93269 | 107652 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 93385 | 93385 | 98591 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2375 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 9808 | 6002830.0 | 2116793.0 | 37.7924696026791 | -122.434140096981 | (37.7924696026791, -122.434140096981) | |||
| 93429 | 93429 | 594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008579.288380001 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | |||
| 93474 | 93474 | 108328 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 86 11TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | ||||
| 93596 | 93596 | 21812 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2631 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6008221.30715 | 2121822.90168 | 37.806584965078 | -122.415842290697 | (37.806584965078, -122.415842290697) | |||
| 93660 | 93660 | 48875 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 650 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | Permit Number 46082 | 6002579.05689486 | 2108874.6714316 | 37.770713622438706 | -122.43444196581801 | (37.7707136224387, -122.434441965818) | |||
| 93914 | 93914 | 93042 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110X Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000798.7 | 2105708.1 | 37.761917781818205 | -122.44037310060301 | (37.7619177818182, -122.440373100603) | |||
| 93983 | 93983 | 41198 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");