Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106652 | 106652 | 49234 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 82491 | 82491 | 49240 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 126237 | 126237 | 6727 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 128824 | 128824 | 26153 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 86611 | 86611 | 6726 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 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) | |||
| 98036 | 98036 | 15168 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 22 | 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) | |||
| 100289 | 100289 | 15167 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 21 | 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) | |||
| 108670 | 108670 | 49236 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 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) | |||
| 106931 | 106931 | 110698 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996770.5 | 2111189.3 | 37.7767375616272 | -122.454700997037 | (37.7767375616272, -122.454700997037) | ||||
| 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) | |||
| 113171 | 113171 | 6722 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 123509 | 123509 | 49288 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 19 | 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) | |||
| 81656 | 81656 | 15164 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 18 | 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) | |||
| 86669 | 86669 | 23529 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005762.85494 | 2119704.71005 | 37.8006304387912 | -122.42419949344 | (37.8006304387912, -122.42419949344) | |||
| 119656 | 119656 | 49237 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 122890 | 122890 | 6721 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 125637 | 125637 | 110712 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 139935 | 139935 | 49251 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 18 | 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) | |||
| 86343 | 86343 | 23542 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6005753.45253 | 2119744.59142 | 37.8007394119615 | -122.424234867659 | (37.8007394119615, -122.424234867659) | |||
| 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) | |||||
| 106333 | 106333 | 15163 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 17 | 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) | |||
| 110491 | 110491 | 49263 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 17 | 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) | |||
| 83588 | 83588 | 6719 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 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) | |||
| 106524 | 106524 | 111799 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 108574 | 108574 | 49238 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 110157 | 110157 | 15162 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 16 | 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) | |||
| 122808 | 122808 | 23541 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6005750.94301 | 2119762.60418 | 37.800788728704504 | -122.42424483346001 | (37.8007887287045, -122.42424483346) | |||
| 127253 | 127253 | 110710 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 140077 | 140077 | 110997 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 97048 | 97048 | 20975 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 97841 | 97841 | 49277 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 15 | 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) | |||
| 98451 | 98451 | 15161 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 15 | 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) | |||
| 105149 | 105149 | 111798 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 114327 | 114327 | 110996 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 128732 | 128732 | 23540 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005743.06666 | 2119831.60651 | 37.8009777467475 | -122.424276999326 | (37.8009777467475, -122.424276999326) | |||
| 49591 | 49591 | 110708 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 79481 | 79481 | 49286 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 14 | 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) | |||
| 81572 | 81572 | 110995 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 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) | |||
| 89584 | 89584 | 23539 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6005738.98285 | 2119846.6704 | 37.8010188777475 | -122.42429220305901 | (37.8010188777475, -122.424292203059) | |||
| 95236 | 95236 | 20974 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 125027 | 125027 | 15160 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 14 | 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) | |||
| 128863 | 128863 | 111797 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 1042 | 1042 | 21994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015909.89309 | 2103367.8988900003 | 37.756340904732596 | -122.387945645479 | (37.7563409047326, -122.387945645479) | |||
| 83173 | 83173 | 26954 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002832.133120299 | 2114461.0177044 | 37.7860666959211 | -122.43396594987401 | (37.7860666959211, -122.433965949874) | |||
| 84691 | 84691 | 21808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 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) | |||
| 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) | ||
| 91879 | 91879 | 95040 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 100900 | 100900 | 49285 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 13 | 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) | |||
| 101069 | 101069 | 111796 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 105652 | 105652 | 98659 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.799195508176105 | -122.434821422435 | (37.7991955081761, -122.434821422435) | ||
| 111454 | 111454 | 48701 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 13 | 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) | |||
| 114275 | 114275 | 23538 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | 6005735.646240001 | 2119861.7143200003 | 37.8010599961041 | -122.424304819753 | (37.8010599961041, -122.424304819753) | |||
| 116641 | 116641 | 26425 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 555 Fulton St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005298.7673 | 2111637.29894 | 37.778453132965396 | -122.425231047872 | (37.7784531329654, -122.425231047872) | |||
| 127221 | 127221 | 23821 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 127603 | 127603 | 110994 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 144030 | 144030 | 15159 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | Private 3 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | ||
| 9938 | 9938 | 27712 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
| 72212 | 72212 | 40354 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 12 | 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) | ||
| 82000 | 82000 | 23820 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 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) | |||
| 90516 | 90516 | 20972 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 94842 | 94842 | 21807 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.806911549800795 | -122.414700989571 | (37.8069115498008, -122.414700989571) | ||
| 98047 | 98047 | 23537 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2750 Van Ness Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005731.47426 | 2119901.4558900003 | 37.801168880725704 | -122.424322084799 | (37.8011688807257, -122.424322084799) | |||
| 98461 | 98461 | 99974 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||||
| 100703 | 100703 | 48700 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 12 | 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) | |||
| 104986 | 104986 | 95041 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 127585 | 127585 | 111795 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 138285 | 138285 | 22712 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 138757 | 138757 | 101769 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 139965 | 139965 | 49259 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 12 | 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) | |||
| 141223 | 141223 | 110706 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 141802 | 141802 | 26424 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005277.15037 | 2111634.16402 | 37.7784433040001 | -122.42530560590299 | (37.7784433040001, -122.425305605903) | |||
| 144799 | 144799 | 101726 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 145035 | 145035 | 26953 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376002 | (37.7859892824562, -122.43461540376) | |||
| 145903 | 145903 | 110993 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 119 | 119 | 251215 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | ||||
| 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) | ||
| 96564 | 96564 | 101725 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 100767 | 100767 | 48699 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 11 | 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) | |||
| 103839 | 103839 | 113010 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 108162 | 108162 | 95039 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 112366 | 112366 | 49289 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 11 | 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) | |||
| 114536 | 114536 | 26952 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5x6 | 6002662.5790800005 | 2114440.54738 | 37.7860008659914 | -122.434551096425 | (37.7860008659914, -122.434551096425) | |||
| 116009 | 116009 | 110992 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 116140 | 116140 | 15157 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 11 | 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) | |||
| 117415 | 117415 | 6829 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 121947 | 121947 | 26423 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005252.46633 | 2111627.39845 | 37.7784233328254 | -122.42539051577101 | (37.7784233328254, -122.425390515771) | |||
| 122044 | 122044 | 111794 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 141253 | 141253 | 101768 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 143962 | 143962 | 27711 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
| 19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 77710 | 77710 | 6828 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 80976 | 80976 | 41195 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1996 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 95830 | 95830 | 26951 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 5x6 | 6002681.79801 | 2114441.89018 | 37.7860056439611 | -122.434484700269 | (37.7860056439611, -122.434484700269) | |||
| 99696 | 99696 | 113009 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) |
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");