Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) |
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 69173 | 69173 | 247371 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 485 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002156.5991 | 2110137.258 | 37.774156382291295 | -122.435993611299 | (37.7741563822913, -122.435993611299) | |||
| 69989 | 69989 | 92394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 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 52799 | 5985787.8059 | 2099633.6824 | 37.7443729686632 | -122.491841945332 | (37.7443729686632, -122.491841945332) |
| 70235 | 70235 | 79414 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2635 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52810 | 5984897.7294 | 2097238.629 | 37.7377447344094 | -122.49474305383 | (37.7377447344094, -122.49474305383) |
| 70764 | 70764 | 143340 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1796 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004433.9519 | 2118779.1956 | 37.798014090515 | -122.42873202906 | (37.798014090515, -122.42873202906) | |||
| 71704 | 71704 | 238004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 569 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003031.46134 | 2095960.14105 | 37.735279051283705 | -122.431954769317 | (37.7352790512837, -122.431954769317) | |||
| 71955 | 71955 | 34634 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1334 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2006 12:00:00 AM | 2 | Permit Number 48747 | 5988049.813999999 | 2106208.6368 | 37.762557976115104 | -122.48450265773701 | (37.7625579761151, -122.484502657737) | |
| 74048 | 74048 | 182548 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986518.7594 | 2105601.9213 | 37.760802826429796 | -122.489753326371 | (37.7608028264298, -122.489753326371) | |||
| 75849 | 75849 | 135904 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1488 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006436.02999 | 2118364.9643599996 | 37.7969898223834 | -122.421774812465 | (37.7969898223834, -122.421774812465) | |||
| 75953 | 75953 | 182379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1539 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989606.4529 | 2104860.602 | 37.758947159826704 | -122.47902026167401 | (37.7589471598267, -122.479020261674) | |||
| 76643 | 76643 | 184445 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2143 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983233.2456 | 2100550.728 | 37.746741282577894 | -122.500742738194 | (37.7467412825779, -122.500742738194) | |||
| 77365 | 77365 | 183602 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2647 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988930.4288 | 2097323.4764 | 37.7382129263906 | -122.48080643881 | (37.7382129263906, -122.48080643881) | |||
| 82183 | 82183 | 91186 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 291 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 2 | 6x9 | Permit Number 52039 | 6005173.0 | 2109884.0 | 37.773631895587705 | -122.42554131115601 | (37.7736318955877, -122.425541311156) | |
| 106345 | 106345 | 39515 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 62 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 2 | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.75383437046089 | -122.428843949963 | (37.7538343704609, -122.428843949963) | |
| 123423 | 123423 | 114660 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1603 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6004469.8992 | 2114403.3025 | 37.786001031208 | -122.428295602978 | (37.786001031208, -122.428295602978) | |||
| 130060 | 130060 | 138271 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004488.6249 | 2114080.7087 | 37.785116328832295 | -122.428207818239 | (37.7851163288323, -122.428207818239) | |||
| 130981 | 130981 | 60585 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1528 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52120 | 6000398.084 | 2111000.4318 | 37.7764263816825 | -122.442138581922 | (37.7764263816825, -122.442138581922) | |
| 132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
| 134091 | 134091 | 31134 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 154 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | Permit Number 34849 | 6000371.52521 | 2094373.11197 | 37.730770284917895 | -122.441037301429 | (37.7307702849179, -122.441037301429) | |
| 134465 | 134465 | 66973 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 154 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1994 12:00:00 AM | 2 | Permit Number 30316 | 5997837.7074 | 2109963.7906 | 37.773433785241 | -122.450920838457 | (37.773433785241, -122.450920838457) | |
| 135632 | 135632 | 183177 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2450 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983968.3342 | 2098473.4815 | 37.741080860242896 | -122.498047537544 | (37.7410808602429, -122.498047537544) | |||
| 135868 | 135868 | 51044 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1842 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 2 | Permit Number 47517 | 5990031.9781 | 2102811.2855 | 37.7533449836368 | -122.477398836512 | (37.7533449836368, -122.477398836512) | ||
| 135959 | 135959 | 95525 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986606.408 | 2107060.1496 | 37.764811835149295 | -122.489557426261 | (37.7648118351493, -122.489557426261) |
| 136125 | 136125 | 183176 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2446 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983967.9959 | 2098507.985 | 37.7411755776416 | -122.498051254673 | (37.7411755776416, -122.498051254673) | |||
| 136725 | 136725 | 92333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2182 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52765 | 5986695.3951 | 2100425.9019 | 37.7466011963621 | -122.488761954977 | (37.7466011963621, -122.488761954977) |
| 136915 | 136915 | 95445 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2201 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767307 | 5985726.3556 | 2100198.6842 | 37.7459207192562 | -122.492096016775 | (37.7459207192562, -122.492096016775) |
| 137598 | 137598 | 138244 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2760 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999379.987000001 | 2113979.7781 | 37.7845488238542 | -122.44587478074499 | (37.7845488238542, -122.445874780745) | |||
| 138713 | 138713 | 178892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 334 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002432.46703 | 2091647.79412 | 37.723404349001605 | -122.43371759969901 | (37.7234043490016, -122.433717599699) | |||
| 141940 | 141940 | 66596 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1166 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 2 | Permit Number 29789 | 6008318.17747093 | 2115921.39203862 | 37.79038633277379 | -122.415089057915 | (37.7903863327738, -122.415089057915) | |
| 146368 | 146368 | 178879 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 683 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002292.149780001 | 2089824.9266099997 | 37.718391198782 | -122.434072405644 | (37.718391198782, -122.434072405644) | |||
| 146393 | 146393 | 81679 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1942 Vicente St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52863 | 5986874.2463 | 2097598.6809 | 37.738848836056 | -122.487935819213 | (37.738848836056, -122.487935819213) |
| 147047 | 147047 | 92304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52751 | 5989091.9697 | 2101683.9526 | 37.7501950388707 | -122.480567026206 | (37.7501950388707, -122.480567026206) |
| 147223 | 147223 | 135894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007011.71695 | 2115552.58868 | 37.7893001854156 | -122.419583155654 | (37.7893001854156, -122.419583155654) | |||
| 147675 | 147675 | 244992 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005441.5895 | 2109754.3822 | 37.773291168852204 | -122.42460299610501 | (37.7732911688522, -122.424602996105) | |||
| 148597 | 148597 | 181637 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1291 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987994.5653 | 2106518.5606 | 37.763405724610294 | -122.484716476416 | (37.7634057246103, -122.484716476416) | |||
| 149345 | 149345 | 92403 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1545 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52803 | 5985264.691000001 | 2104708.4468 | 37.7582762928221 | -122.494024677293 | (37.7582762928221, -122.494024677293) |
| 151451 | 151451 | 95446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.49209381774901 | (37.7458386996409, -122.492093817749) |
| 153169 | 153169 | 214417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994480.563080001 | 2091128.3543599998 | 37.7215236696771 | -122.461168031889 | (37.7215236696771, -122.461168031889) | |||
| 153200 | 153200 | 183419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989183.8607 | 2096995.3104 | 37.73732659489539 | -122.479906199072 | (37.7373265948954, -122.479906199072) | |||
| 153885 | 153885 | 246222 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1381 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999537.3225 | 2107899.6688 | 37.7678633807549 | -122.444893240119 | (37.7678633807549, -122.444893240119) | |||
| 155831 | 155831 | 178936 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 275 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003706.73664 | 2092066.2006299999 | 37.7246254242075 | -122.429342507659 | (37.7246254242075, -122.429342507659) | |||
| 155917 | 155917 | 247314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 303 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003237.761 | 2109364.6049 | 37.7720962280958 | -122.432198493214 | (37.7720962280958, -122.432198493214) | |||
| 156144 | 156144 | 183594 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2635 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988927.7716 | 2097397.2142 | 37.738415236787 | -122.48082102296999 | (37.738415236787, -122.48082102297) | |||
| 156664 | 156664 | 51809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | 2 | 3x3 | Permit Number 48055 | 6015110.437000001 | 2092946.715 | 37.7276821641004 | -122.389982519172 | (37.7276821641004, -122.389982519172) | |
| 157657 | 157657 | 178938 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 721 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004184.355719999 | 2091630.4786 | 37.7234560564279 | -122.427660409419 | (37.7234560564279, -122.427660409419) | |||
| 157970 | 157970 | 139052 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1460 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999718.3592 | 2113910.6775 | 37.7843784065192 | -122.44469916326901 | (37.7843784065192, -122.444699163269) | |||
| 158425 | 158425 | 245019 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000585.055 | 2109242.4773 | 37.7716101359109 | -122.441365628321 | (37.7716101359109, -122.441365628321) | |||
| 158689 | 158689 | 70671 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 73 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 2 | 6010033.5172 | 2110899.92735 | 37.7766948289379 | -122.408799654802 | (37.7766948289379, -122.408799654802) | ||
| 160892 | 160892 | 92303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1583 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52748 | 5988994.8845 | 2104576.1068 | 37.758130478678105 | -122.481114495747 | (37.7581304786781, -122.481114495747) |
| 161721 | 161721 | 50963 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 2 | Permit Number 47459 | 5996572.8178 | 2113583.69 | 37.7833005840711 | -122.455557938638 | (37.7833005840711, -122.455557938638) |
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");