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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19501 | 19501 | 117186 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 19551 | 19551 | 55849 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | ||
| 19675 | 19675 | 103628 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 19751 | 19751 | 96542 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 19843 | 19843 | 99594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
| 20082 | 20082 | 111807 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 20099 | 20099 | 615 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008105.608030001 | 2102127.9045700002 | 37.752500715042295 | -122.414847903135 | (37.7525007150423, -122.414847903135) | |||
| 20379 | 20379 | 9943 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 20384 | 20384 | 104821 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2173 15TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.43263651234301 | (37.7657807169148, -122.432636512343) | |||||
| 20651 | 20651 | 115057 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 20740 | 20740 | 16969 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 770 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003329.8686 | 2110020.1015 | 37.773901282351105 | -122.431926699871 | (37.7739012823511, -122.431926699871) | |||
| 20818 | 20818 | 603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008454.62539 | 2102106.73452 | 37.752462191692295 | -122.413639440921 | (37.7524621916923, -122.413639440921) | |||
| 20843 | 20843 | 111792 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 21788 | 21788 | 17003 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | |||
| 22869 | 22869 | 13081 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 650-654 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2017 12:08:00 PM | 3 | 3x3 | 6009251.0552 | 2120493.5635 | 37.8029927712959 | -122.412184629201 | (37.8029927712959, -122.412184629201) | ||
| 22938 | 22938 | 110472 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 477 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x10 | 6005542.0 | 2111298.0 | 37.77753523894629 | -122.424365474196 | (37.7775352389463, -122.424365474196) | ||
| 22981 | 22981 | 116011 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1448 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 6000920.0 | 2110390.8 | 37.7747822166773 | -122.44028940195601 | (37.7747822166773, -122.440289401956) | |||
| 27180 | 27180 | 21626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004833.69671 | 2114745.4452299997 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | |||
| 27184 | 27184 | 117402 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 28450 | 28450 | 104230 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.44870447955601 | (37.787869332154, -122.448704479556) | ||||
| 34299 | 34299 | 16935 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | |||
| 37389 | 37389 | 95036 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 7 | 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) | ||||
| 41076 | 41076 | 117048 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2183 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6002170.0 | 2114323.0 | 37.78565013631621 | -122.436246868292 | (37.7856501363162, -122.436246868292) | |||
| 42747 | 42747 | 115058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 43174 | 43174 | 117400 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 43364 | 43364 | 115743 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 28 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 44347 | 44347 | 224728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | Permit Number 771820 | 6009984.63313 | 2102660.33541 | 37.754068053508 | -122.40838743973801 | (37.754068053508, -122.408387439738) | ||
| 44578 | 44578 | 17305 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | |||
| 44837 | 44837 | 95043 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 9 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 46254 | 46254 | 23132 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | ||
| 49227 | 49227 | 15149 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 3 | 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) | |||
| 49233 | 49233 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 610 Brannan St | 1 | unknown : Cutout 12 | Tree 1 | Private 1 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.39955535858401 | (37.7766267904106, -122.399555358584) | ||||
| 49589 | 49589 | 104825 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45 Prosper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003350.0 | 2106266.0 | 37.763594576550496 | -122.431588992909 | (37.7635945765505, -122.431588992909) | |||
| 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) | ||||
| 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) | ||
| 58723 | 58723 | 116509 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||
| 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) | |||||
| 65794 | 65794 | 115992 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.47916224845301 | (37.7795296278249, -122.479162248453) | ||
| 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) | |||
| 66642 | 66642 | 4609 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | |
| 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) | |||||
| 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) | ||
| 76014 | 76014 | 9687 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 16 | 3x3 | 6006025.521509999 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | ||
| 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) | |||
| 77503 | 77503 | 23131 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010622.643569999 | 2118948.98987 | 37.7988286159864 | -122.407329246317 | (37.7988286159864, -122.407329246317) | ||
| 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) | |||
| 77880 | 77880 | 93215 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 499 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715.0 | 2118034.0 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | |||
| 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) | |||
| 78160 | 78160 | 44063 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 2 | 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) | |||
| 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) | |||||
| 78377 | 78377 | 48697 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 9 | 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) | |||
| 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) | |||||
| 78463 | 78463 | 115215 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778.0 | 2103691.0 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | |
| 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) | ||||
| 78845 | 78845 | 49235 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 8 | 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) |
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");