Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000 | 2000 | 237999 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | |
| 2513 | 2513 | 138183 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003936.4381 | 2114774.6580000003 | 37.7869904804487 | -122.43016773530199 | (37.7869904804487, -122.430167735302) | ||
| 2541 | 2541 | 138182 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003933.6106 | 2114790.6807 | 37.7870343146011 | -122.43017866131201 | (37.7870343146011, -122.430178661312) | ||
| 2544 | 2544 | 138181 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003932.1968 | 2114801.9909 | 37.7870652894849 | -122.43018435992599 | (37.7870652894849, -122.430184359926) | ||
| 2550 | 2550 | 138186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6003941.622 | 2114719.9923 | 37.786840675810396 | -122.43014589889499 | (37.7868406758104, -122.430145898895) | |||
| 3226 | 3226 | 138479 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | 2 | Width 0ft | Permit Number 47204 | 6004045.5542 | 2114285.9086 | 37.7856546769882 | -122.429755345095 | (37.7856546769882, -122.429755345095) | |
| 3245 | 3245 | 138485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | 2 | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | |
| 5466 | 5466 | 21688 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1881 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 2 | 4x4 | 6003696.9634 | 2114537.7544 | 37.7863264365495 | -122.430979349218 | (37.7863264365495, -122.430979349218) | ||
| 10559 | 10559 | 26794 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 186 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 2 | 3x3 | 6010044.3489 | 2087538.0893 | 37.7125489295627 | -122.407115057358 | (37.7125489295627, -122.407115057358) | ||
| 23661 | 23661 | 142764 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.801741456909596 | -122.40695573845899 | (37.8017414569096, -122.406955738459) | |||
| 24060 | 24060 | 182205 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988079.8655 | 2104054.0379 | 37.756643783163206 | -122.484240699303 | (37.7566437831632, -122.484240699303) | |||
| 24350 | 24350 | 214468 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5997445.526980001 | 2095470.2100900002 | 37.7336155617911 | -122.451231980178 | (37.7336155617911, -122.451231980178) | |||
| 24819 | 24819 | 65946 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 556 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 2 | Permit Number 28967 | 6007598.7781 | 2113267.2525 | 37.783058259910895 | -122.417389964837 | (37.7830582599109, -122.417389964837) | |
| 24995 | 24995 | 181628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1290 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988037.8386 | 2106538.091 | 37.7634618698416 | -122.48456824258498 | (37.7634618698416, -122.484568242585) | |||
| 25020 | 25020 | 182555 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986616.8854 | 2105696.0047 | 37.761066882292 | -122.489420874881 | (37.761066882292, -122.489420874881) | |||
| 25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
| 25957 | 25957 | 247414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 971 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001933.8006 | 2109433.5045 | 37.772211390909 | -122.436713922993 | (37.772211390909, -122.436713922993) | |||
| 26050 | 26050 | 110340 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 564 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x4 | 6005097.2691 | 2111307.8756 | 37.7775372317236 | -122.42590465122801 | (37.7775372317236, -122.425904651228) | |||
| 26520 | 26520 | 45041 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1874 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 2 | Permit Number 43928 | 5988487.5162 | 2102559.2618 | 37.752563256460206 | -122.48272137554702 | (37.7525632564602, -122.482721375547) | |
| 27485 | 27485 | 139129 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1580 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003642.6576 | 2114125.3602 | 37.785191028716795 | -122.431137787396 | (37.7851910287168, -122.431137787396) | |||
| 27579 | 27579 | 237973 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 47 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005397.275719999 | 2103411.57149 | 37.7558728147995 | -122.42430507393601 | (37.7558728147995, -122.424305073936) | |||
| 27593 | 27593 | 82193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49858 | 5989080.382 | 2102109.5053 | 37.7513628201965 | -122.48063824575 | (37.7513628201965, -122.48063824575) | |
| 28653 | 28653 | 140315 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2112 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997699.8421 | 2109926.1659 | 37.7733225841329 | -122.45139501771901 | (37.7733225841329, -122.451395017719) | |||
| 29059 | 29059 | 214419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 479 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5992969.97647 | 2090349.4269700001 | 37.7192978763685 | -122.466333093823 | (37.7192978763685, -122.466333093823) | |||
| 30442 | 30442 | 142001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 762 FULTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004249.2696 | 2111539.4607 | 37.7781251474871 | -122.42885467932301 | (37.7781251474871, -122.428854679323) | |||
| 31626 | 31626 | 106986 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003814.6942 | 2114193.6153 | 37.7853881873399 | -122.430547466156 | (37.7853881873399, -122.430547466156) | |||
| 32270 | 32270 | 183579 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2610 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988968.1029 | 2097542.0935 | 37.7388153818785 | -122.480692181856 | (37.7388153818785, -122.480692181856) | |||
| 33475 | 33475 | 37204 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1575 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 2 | Permit Number 39771 | 5986202.8143 | 2104523.3582 | 37.75782293745029 | -122.49076666265499 | (37.7578229374503, -122.490766662655) | |
| 36214 | 36214 | 139413 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004104.3504 | 2114027.1131 | 37.7849474186562 | -122.429533464104 | (37.7849474186562, -122.429533464104) | |||
| 37082 | 37082 | 182550 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986517.6568 | 2105641.9803 | 37.760912753017394 | -122.48976008582899 | (37.7609127530174, -122.489760085829) | |||
| 37893 | 37893 | 138796 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1821 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000490.0431 | 2114976.5028 | 37.7873488929161 | -122.44210594501499 | (37.7873488929161, -122.442105945015) | |||
| 38266 | 38266 | 214432 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1493 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994264.26348 | 2105375.95517 | 37.7606315737945 | -122.462948880198 | (37.7606315737945, -122.462948880198) | |||
| 38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
| 39866 | 39866 | 182572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2212 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989118.5154 | 2098355.8518 | 37.7410584915124 | -122.48023167480301 | (37.7410584915124, -122.480231674803) | |||
| 41047 | 41047 | 139143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004425.4721 | 2114070.1832 | 37.7850838549959 | -122.428425556733 | (37.7850838549959, -122.428425556733) | |||
| 41505 | 41505 | 92486 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2416 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52857 | 5988503.8268 | 2098336.0957 | 37.7409685091415 | -122.48235557195801 | (37.7409685091415, -122.482355571958) |
| 42720 | 42720 | 94722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 172 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53857 | 5998128.6274 | 2113392.2279 | 37.7828640340497 | -122.450161675731 | (37.7828640340497, -122.450161675731) |
| 42734 | 42734 | 178927 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 169 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000613.31177 | 2092308.08767 | 37.7251139719271 | -122.440053391844 | (37.7251139719271, -122.440053391844) | |||
| 42824 | 42824 | 139130 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1580 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003638.5353 | 2114149.4067 | 37.7852568207566 | -122.43115376623501 | (37.7852568207566, -122.431153766235) | |||
| 43762 | 43762 | 137653 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 822 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000014.8214 | 2111796.2307 | 37.7785895928112 | -122.44352156987499 | (37.7785895928112, -122.443521569875) | |||
| 43907 | 43907 | 139147 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004351.7938 | 2114062.4276 | 37.785058390527794 | -122.428679907469 | (37.7850583905278, -122.428679907469) | |||
| 44205 | 44205 | 178924 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000939.255030001 | 2093544.2007900001 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | |||
| 44471 | 44471 | 182556 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986624.9706 | 2105696.7397 | 37.7610693723866 | -122.48939296609501 | (37.7610693723866, -122.489392966095) | |||
| 45174 | 45174 | 184179 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1607 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981558.7987 | 2104123.9871 | 37.7564539963073 | -122.50679770031401 | (37.7564539963073, -122.506797700314) | |||
| 47048 | 47048 | 247783 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 274 30th St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004785.28168 | 2098443.27058 | 37.7421964332069 | -122.42606787825198 | (37.7421964332069, -122.426067878252) | |||
| 48917 | 48917 | 238000 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4222 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002358.11456 | 2100643.50025 | 37.7481002693112 | -122.43461754857799 | (37.7481002693112, -122.434617548578) | |||
| 49526 | 49526 | 244925 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 223 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005441.8933 | 2110105.3671 | 37.77425490559 | -122.424626917474 | (37.77425490559, -122.424626917474) | |||
| 49823 | 49823 | 140314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2112 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997724.0097 | 2109929.7362 | 37.7733337710941 | -122.451311676612 | (37.7733337710941, -122.451311676612) | |||
| 50354 | 50354 | 95524 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767316 | 5987892.7113 | 2105115.9895 | 37.75954871508429 | -122.484965845966 | (37.7595487150843, -122.484965845966) |
| 50603 | 50603 | 43244 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 148 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52907 | 6010526.7074 | 2094001.3390799998 | 37.7303226617554 | -122.405902877341 | (37.7303226617554, -122.405902877341) | |
| 50827 | 50827 | 247304 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 247 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002738.4372 | 2109472.2087 | 37.772363358196394 | -122.433933385595 | (37.7723633581964, -122.433933385595) | |||
| 51079 | 51079 | 182554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986607.6975 | 2105696.3722 | 37.7610673549786 | -122.489452678447 | (37.7610673549786, -122.489452678447) | |||
| 51429 | 51429 | 69307 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1522 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 2 | Permit Number 33386 | 5986858.656 | 2104872.1171 | 37.758818824109 | -122.48852415134701 | (37.758818824109, -122.488524151347) | |
| 51735 | 51735 | 88092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51095 | 5984042.9711 | 2104115.7287 | 37.756577293333294 | -122.49820607925 | (37.7565772933333, -122.49820607925) | |
| 51937 | 51937 | 185812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1915 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989026.5354 | 2101700.9269 | 37.7502378427058 | -122.480794541981 | (37.7502378427058, -122.480794541981) | |||
| 52167 | 52167 | 214406 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993802.78615 | 2096495.7432 | 37.736222176613104 | -122.463900308969 | (37.7362221766131, -122.463900308969) | ||||
| 52419 | 52419 | 139419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1675 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004207.4112 | 2114251.7374 | 37.785570015468295 | -122.42919292902201 | (37.7855700154683, -122.429192929022) | |||
| 52490 | 52490 | 246224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1382 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999585.4723 | 2107870.9 | 37.767787136682294 | -122.444724628037 | (37.7677871366823, -122.444724628037) | |||
| 52716 | 52716 | 92396 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.3792 | 2099657.153 | 37.7444373876676 | -122.491845148303 | (37.7444373876676, -122.491845148303) |
| 52851 | 52851 | 142766 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 730 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6007514.5827 | 2113866.0765 | 37.7846977477095 | -122.417723705816 | (37.7846977477095, -122.417723705816) | |||
| 53425 | 53425 | 214415 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995229.56815 | 2091906.8040099998 | 37.7237041820879 | -122.458635267605 | (37.7237041820879, -122.458635267605) | |||
| 54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
| 54862 | 54862 | 183412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985653.7417 | 2097035.0769 | 37.7372300576086 | -122.492114208587 | (37.7372300576086, -122.492114208587) | |||
| 55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
| 55503 | 55503 | 178889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 487 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003437.2188 | 2090630.2109400001 | 37.720667252470996 | -122.430171799494 | (37.720667252471, -122.430171799494) | |||
| 56529 | 56529 | 244325 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 463 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003635.8441 | 2109959.3175 | 37.773751725465296 | -122.430863941782 | (37.7737517254653, -122.430863941782) | |||
| 57208 | 57208 | 52827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 750WASHINGTON Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 48852 | 6011323.0636 | 2117546.9613 | 37.7950181606921 | -122.40480679182501 | (37.7950181606921, -122.404806791825) | |
| 57263 | 57263 | 65499 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.48374245837299 | (37.7446414773793, -122.483742458373) | |
| 57315 | 57315 | 92291 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2541 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52737 | 5989837.8157 | 2098042.3571 | 37.7402394868641 | -122.47772171282601 | (37.7402394868641, -122.477721712826) |
| 58079 | 58079 | 178920 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5993797.37837 | 2086767.25523 | 37.7095097928145 | -122.463213309645 | (37.7095097928145, -122.463213309645) | ||||
| 58689 | 58689 | 53262 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 2 | Permit Number 6152 | 5987525.5316 | 2103414.2811 | 37.7548548926849 | -122.486110800407 | (37.7548548926849, -122.486110800407) | ||
| 59335 | 59335 | 139409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004207.1311 | 2114038.5263 | 37.7849845753314 | -122.42917868992501 | (37.7849845753314, -122.429178689925) | |||
| 60303 | 60303 | 244983 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | |||
| 60519 | 60519 | 92488 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2432 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52859 | 5988420.575 | 2098331.0194 | 37.740949727843706 | -122.482643050711 | (37.7409497278437, -122.482643050711) |
| 60558 | 60558 | 72752 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 2 | 5988097.7754 | 2104798.077 | 37.758687755802995 | -122.484233325891 | (37.758687755803, -122.484233325891) | ||
| 60645 | 60645 | 185813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1913 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989045.9651 | 2101702.9368 | 37.750244490673 | -122.480727500746 | (37.750244490673, -122.480727500746) | |||
| 60771 | 60771 | 178944 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 202 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004727.85531 | 2094036.3293599999 | 37.7300927194874 | -122.425952806385 | (37.7300927194874, -122.425952806385) | |||
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 61952 | 61952 | 44806 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 2 | Permit Number 43901 | 5987417.062999999 | 2106562.4256 | 37.7634925157287 | -122.486717065387 | (37.7634925157287, -122.486717065387) | |
| 62539 | 62539 | 183257 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981497.12 | 2105917.3408 | 37.7613744008584 | -122.50714403834999 | (37.7613744008584, -122.50714403835) | |||
| 62988 | 62988 | 92393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2223 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52798 | 5985729.7695 | 2100081.3311 | 37.745598698912204 | -122.49207557319401 | (37.7455986989122, -122.492075573194) |
| 63020 | 63020 | 178940 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004061.97855 | 2093834.65882 | 37.729501322606 | -122.428240459522 | (37.729501322606, -122.428240459522) | |||
| 63440 | 63440 | 183376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988932.0896 | 2097296.9043 | 37.738140062837296 | -122.480798751822 | (37.7381400628373, -122.480798751822) | |||
| 63491 | 63491 | 182127 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2636 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987775.8815 | 2098311.0525 | 37.7408573756578 | -122.484870670835 | (37.7408573756578, -122.484870670835) | |||
| 63868 | 63868 | 183586 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2618 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988349.8428 | 2097449.4724 | 37.738525115109994 | -122.482823024231 | (37.73852511511, -122.482823024231) | |||
| 63894 | 63894 | 178877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 812 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002023.11476 | 2088969.20619 | 37.71602630823671 | -122.434941181287 | (37.7160263082367, -122.434941181287) | |||
| 64489 | 64489 | 178947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 33 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005285.02544 | 2093071.08332 | 37.727473839721206 | -122.42395798417101 | (37.7274738397212, -122.423957984171) | ||||
| 64942 | 64942 | 178939 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004063.80175 | 2093818.77342 | 37.72945780800921 | -122.42823302485701 | (37.7294578080092, -122.428233024857) | |||
| 65283 | 65283 | 139134 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1825 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003440.8714 | 2114149.8668 | 37.7852468810092 | -122.43183765526001 | (37.7852468810092, -122.43183765526) | |||
| 66160 | 66160 | 214405 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993807.85396 | 2096495.9519200001 | 37.73622304175571 | -122.46388280274701 | (37.7362230417557, -122.463882802747) | ||||
| 66305 | 66305 | 54661 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.71094938168571 | -122.399245788885 | (37.7109493816857, -122.399245788885) | ||
| 66440 | 66440 | 182858 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1826 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986304.0542 | 2102796.2301 | 37.7530866298604 | -122.49028948878201 | (37.7530866298604, -122.490289488782) | |||
| 66712 | 66712 | 137904 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1715 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004837.4134 | 2115278.925 | 37.7884260599365 | -122.427086493089 | (37.7884260599365, -122.427086493089) | |||
| 67319 | 67319 | 214469 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 519 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997971.240119999 | 2095245.6025 | 37.7330289295305 | -122.44939826792499 | (37.7330289295305, -122.449398267925) | |||
| 67347 | 67347 | 92397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985786.098999999 | 2099670.3819 | 37.7444736358369 | -122.491850548624 | (37.7444736358369, -122.491850548624) |
| 68046 | 68046 | 71314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 530 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2012 12:00:00 AM | 2 | Permit Number 769252 | 6003477.6405 | 2090266.5364299999 | 37.7196709718096 | -122.43000614527399 | (37.7196709718096, -122.430006145274) | |
| 68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
| 68270 | 68270 | 140310 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 155 COLE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997792.3931 | 2109979.17 | 37.7734734188761 | -122.45107869561501 | (37.7734734188761, -122.451078695615) | |||
| 68678 | 68678 | 217554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 258 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5994397.0077 | 2088113.6647 | 37.7132412415717 | -122.461238438183 | (37.7132412415717, -122.461238438183) | |||
| 68892 | 68892 | 248602 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997486.7154 | 2107468.2888 | 37.7665616787282 | -122.451954890142 | (37.7665616787282, -122.451954890142) |
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");