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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50078 | 50078 | 7238 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.43198684768801 | (37.7794031644909, -122.431986847688) | |||
| 50412 | 50412 | 111774 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 215 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5998260.0 | 2109886.0 | 37.773244358342296 | -122.449454468346 | (37.7732443583423, -122.449454468346) | |||
| 51254 | 51254 | 120965 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 51257 | 51257 | 15154 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 8 | 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) | |||
| 51311 | 51311 | 110985 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 51508 | 51508 | 7237 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | |||
| 54782 | 54782 | 17106 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.771608801349394 | -122.448553894841 | (37.7716088013494, -122.448553894841) | |||
| 55718 | 55718 | 95037 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 58674 | 58674 | 102786 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | ||
| 58954 | 58954 | 11429 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016007.44377 | 2096780.4211400002 | 37.738258459777605 | -122.38714881562599 | (37.7382584597776, -122.387148815626) | |||
| 58966 | 58966 | 110983 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 62742 | 62742 | 100053 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 63413 | 63413 | 16731 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | |||
| 65719 | 65719 | 99967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 66011 | 66011 | 108152 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 66021 | 66021 | 485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010468.2249 | 2102315.4128099997 | 37.7531480416193 | -122.40669074837099 | (37.7531480416193, -122.406690748371) | |||
| 71075 | 71075 | 106808 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.44879640789101 | (37.7757692329232, -122.448796407891) | |||
| 72158 | 72158 | 116028 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006937.0 | 2117734.0 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | ||||
| 72207 | 72207 | 101715 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 76139 | 76139 | 94058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5993648.0 | 2105942.0 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | |||
| 77331 | 77331 | 106090 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 615 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012797.6 | 2118350.4 | 37.7973065196251 | -122.399761086072 | (37.7973065196251, -122.399761086072) | |||||
| 77387 | 77387 | 109858 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2455 03RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 5x8 | 6015836.2 | 2104173.0 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | |||
| 77413 | 77413 | 94294 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 77420 | 77420 | 110696 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 77456 | 77456 | 18007 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6001006.540695201 | 2114902.0443839002 | 37.7871738702805 | -122.44031363373699 | (37.7871738702805, -122.440313633737) | |||
| 77463 | 77463 | 21815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 77535 | 77535 | 111597 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 77611 | 77611 | 102625 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1865X Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 17346 | 6010349.4 | 2120908.5 | 37.804193651889 | -122.408413053021 | (37.804193651889, -122.408413053021) | ||
| 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) | |||
| 77711 | 77711 | 484 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.40670053704201 | (37.7532507356841, -122.406700537042) | |||
| 77740 | 77740 | 1442 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | |||
| 77761 | 77761 | 22671 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003752.72615 | 2112639.8215900003 | 37.7811183481869 | -122.43065094190099 | (37.7811183481869, -122.430650941901) | |||
| 77860 | 77860 | 102602 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | |||
| 77911 | 77911 | 16945 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 602 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004026.09211 | 2110141.24132 | 37.7742733469863 | -122.429526989132 | (37.7742733469863, -122.429526989132) | |||
| 77916 | 77916 | 11109 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2022 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6007225.09879 | 2119363.63368 | 37.7997763833106 | -122.419115312272 | (37.7997763833106, -122.419115312272) | |||
| 78039 | 78039 | 7891 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | |||
| 78051 | 78051 | 18469 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6010532.642999999 | 2102160.24981 | 37.752725602318705 | -122.406457044136 | (37.7527256023187, -122.406457044136) | |||
| 78183 | 78183 | 575 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.752454954328606 | -122.41222072226999 | (37.7524549543286, -122.41222072227) | |||
| 78196 | 78196 | 122714 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011188.0 | 2117923.0 | 37.7960431220576 | -122.40530062831999 | (37.7960431220576, -122.40530062832) | ||||
| 78224 | 78224 | 7218 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 78246 | 78246 | 23492 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005839.2618 | 2119053.8946700003 | 37.798847779282106 | -122.423888789861 | (37.7988477792821, -122.423888789861) | |||
| 78264 | 78264 | 525 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009855.900330001 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | |||
| 78296 | 78296 | 93145 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1152 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991985.0 | 2113459.0 | 37.7826938870859 | -122.47142072749399 | (37.7826938870859, -122.471420727494) | |||||
| 78404 | 78404 | 108604 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 625 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008310.7 | 2114660.6 | 37.7869240847944 | -122.41502565223101 | (37.7869240847944, -122.415025652231) | |||
| 78415 | 78415 | 116510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||||
| 78427 | 78427 | 111811 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 78448 | 78448 | 102504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | ||||
| 78462 | 78462 | 108945 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 78647 | 78647 | 9661 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006079.1393099995 | 2110176.8838400003 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | |||
| 78686 | 78686 | 22716 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 78720 | 78720 | 102621 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 78758 | 78758 | 12942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | |||
| 78813 | 78813 | 111595 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 398X BRYANT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014483.0 | 2113360.0 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | ||||
| 78830 | 78830 | 17674 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1015X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002359.74374 | 2112046.46454 | 37.7794101245475 | -122.435427501131 | (37.7794101245475, -122.435427501131) | |||
| 78842 | 78842 | 120144 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 78900 | 78900 | 9577 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | |||
| 78901 | 78901 | 23814 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 78920 | 78920 | 23703 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
| 78939 | 78939 | 8182 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | |||
| 78954 | 78954 | 113001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 78965 | 78965 | 11046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007462.427490001 | 2117742.7343900003 | 37.795339161156605 | -122.41817908492399 | (37.7953391611566, -122.418179084924) | |||
| 79034 | 79034 | 16939 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 79069 | 79069 | 44125 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.40233912369301 | (37.796490448112, -122.402339123693) | ||||
| 79104 | 79104 | 116602 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x9 | 6005124.0 | 2106632.0 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | |||
| 79132 | 79132 | 109603 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.41588590510901 | (37.758675396701, -122.415885905109) | ||||
| 79144 | 79144 | 16393 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.785180307755105 | -122.42217541209699 | (37.7851803077551, -122.422175412097) | |||
| 79174 | 79174 | 108979 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3298 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6001385.1 | 2119659.6 | 37.800258423921 | -122.43934505130699 | (37.800258423921, -122.439345051307) | |||
| 79278 | 79278 | 7198 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003395.6816300005 | 2111577.87165 | 37.778182264409295 | -122.431810290332 | (37.7781822644093, -122.431810290332) | |||
| 79284 | 79284 | 97611 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 349 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009106.7 | 2109348.6 | 37.7723832922197 | -122.41189615048799 | (37.7723832922197, -122.411896150488) | ||||
| 79378 | 79378 | 20244 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | |||
| 79382 | 79382 | 22281 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
| 79385 | 79385 | 110987 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 79478 | 79478 | 22719 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 79496 | 79496 | 96947 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6x6 | 6007389.0 | 2101516.0 | 37.750780272338 | -122.41728270280899 | (37.750780272338, -122.417282702809) | |||
| 79524 | 79524 | 112827 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6011274.0 | 2118052.0 | 37.796402132688605 | -122.405012137355 | (37.7964021326886, -122.405012137355) | |||
| 79549 | 79549 | 18364 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.40728647423201 | (37.7619322307219, -122.407286474232) | |||
| 79552 | 79552 | 14994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 79580 | 79580 | 19375 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011348.292859999 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | |||
| 79589 | 79589 | 11091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.41884176477899 | (37.7984523847496, -122.418841764779) | |||
| 79596 | 79596 | 117399 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 79646 | 79646 | 117205 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | |||||
| 79647 | 79647 | 107630 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001495.0 | 2119755.0 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | |||
| 79798 | 79798 | 115056 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 79832 | 79832 | 665 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 79837 | 79837 | 21956 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x9 | 6015841.2226599995 | 2104083.6923599998 | 37.758302516993105 | -122.38823308755899 | (37.7583025169931, -122.388233087559) | |||
| 79860 | 79860 | 101758 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45X 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.41790686002899 | (37.7750397101602, -122.417906860029) | |||
| 79863 | 79863 | 7185 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.43157522738599 | (37.7773563593355, -122.431575227386) | |||
| 79876 | 79876 | 120964 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 79879 | 79879 | 110363 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1899x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011823.0 | 2106021.0 | 37.7633984709679 | -122.40226615501801 | (37.7633984709679, -122.402266155018) | ||||
| 79945 | 79945 | 113775 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6000121.0 | 2114885.0 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | |||
| 79990 | 79990 | 111430 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999200.0 | 2114887.0 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | ||||
| 80014 | 80014 | 13200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.43658729566201 | (37.7999076905723, -122.436587295662) | |||
| 80115 | 80115 | 7156 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | |||
| 80118 | 80118 | 15251 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1450X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007694.41094 | 2110207.30516 | 37.774661758829104 | -122.416842252889 | (37.7746617588291, -122.416842252889) | |||
| 80162 | 80162 | 110730 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
| 80196 | 80196 | 120531 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 80256 | 80256 | 668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 80323 | 80323 | 4626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010254.831619999 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | |||
| 80353 | 80353 | 18304 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.768310067349894 | -122.407895847634 | (37.7683100673499, -122.407895847634) |
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");