Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 158 | 158 | 21682 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:00:00 AM | 3 | 4x4 | 6003825.2217 | 2114604.0634 | 37.7865157709252 | -122.43054034167 | (37.7865157709252, -122.43054034167) | ||
| 343 | 343 | 244298 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.42408895277501 | (37.7753793775331, -122.424088952775) | |||
| 368 | 368 | 18096 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.786481285230295 | -122.44577068023099 | (37.7864812852303, -122.445770680231) | ||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 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) | ||
| 5542 | 5542 | 8104 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 780 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004088.9733 | 2111516.0342 | 37.7780517500412 | -122.429407531137 | (37.7780517500412, -122.429407531137) | ||
| 6475 | 6475 | 23884 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1750X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003258.4682 | 2113929.8349 | 37.7846323872704 | -122.432452992684 | (37.7846323872704, -122.432452992684) | |||
| 9027 | 9027 | 21627 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1615 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/14/2010 12:00:00 AM | 6 | 4X4 | Permit Number 53778 | 6004639.3671 | 2114660.2794 | 37.7867162131248 | -122.42772760613701 | (37.7867162131248, -122.427727606137) |
| 9842 | 9842 | 12410 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1610X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 7 | 4X4 | 6004460.5933 | 2114341.7023 | 37.78583136591 | -122.42832340690398 | (37.78583136591, -122.428323406904) | ||
| 10132 | 10132 | 18098 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3016 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/31/2017 11:58:00 AM | 3 | 5999364.6601 | 2114676.4418 | 37.7864608055495 | -122.445977930803 | (37.7864608055495, -122.445977930803) | |||
| 10293 | 10293 | 86369 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | ||
| 10326 | 10326 | 86251 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2230 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988566.0868 | 2100132.7531 | 37.7459052793749 | -122.48227190373699 | (37.7459052793749, -122.482271903737) | ||
| 10332 | 10332 | 86580 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2539 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987975.8922 | 2098002.1559 | 37.740020874126394 | -122.484156469463 | (37.7400208741264, -122.484156469463) | ||
| 10336 | 10336 | 86256 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1754 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988460.2167 | 2103365.3979 | 37.75477510171329 | -122.482874855725 | (37.7547751017133, -122.482874855725) | ||
| 10350 | 10350 | 86577 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2519 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987971.7931 | 2098127.9672 | 37.740366080244 | -122.484179866453 | (37.740366080244, -122.484179866453) | ||
| 10357 | 10357 | 85931 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1686 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988131.3934 | 2103830.0344 | 37.756031730146 | -122.48404607344901 | (37.756031730146, -122.484046073449) | ||
| 10374 | 10374 | 85990 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2234 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987638.7841 | 2100062.768 | 37.7456591364178 | -122.485473213008 | (37.7456591364178, -122.485473213008) | ||
| 10379 | 10379 | 86560 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.48501883929899 | (37.7522790893532, -122.485018839299) | ||
| 10407 | 10407 | 85987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2286 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987649.8793 | 2099748.6884 | 37.744797403731106 | -122.485411804387 | (37.7447974037311, -122.485411804387) | ||
| 10410 | 10410 | 86450 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | ||
| 10421 | 10421 | 86100 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2628 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097431.8111 | 37.738512846904996 | -122.48066793928899 | (37.738512846905, -122.480667939289) | ||
| 10444 | 10444 | 86261 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1726 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988455.289 | 2103558.6714 | 37.7553054920736 | -122.482906060899 | (37.7553054920736, -122.482906060899) | ||
| 10450 | 10450 | 86208 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2447 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988885.905 | 2098662.6727 | 37.741887422325 | -122.48105840788601 | (37.741887422325, -122.481058407886) | ||
| 10452 | 10452 | 86308 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1503 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988358.1168 | 2105058.904 | 37.7594190709864 | -122.48335207735599 | (37.7594190709864, -122.483352077356) | ||
| 10454 | 10454 | 86246 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2292X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988581.0227 | 2099729.0585 | 37.744797709288605 | -122.48219068753401 | (37.7447977092886, -122.482190687534) | ||
| 10462 | 10462 | 86574 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2435 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987950.8455 | 2098721.8965 | 37.74199563410829 | -122.484295842204 | (37.7419956341083, -122.484295842204) | ||
| 10467 | 10467 | 86008 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1726 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987525.9378 | 2103513.8062 | 37.7551281853344 | -122.48611670118099 | (37.7551281853344, -122.486116701181) | ||
| 10469 | 10469 | 86571 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2401X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098914.797 | 37.7425250909553 | -122.484321687901 | (37.7425250909553, -122.484321687901) | ||
| 10486 | 10486 | 86247 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2290 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988579.3157 | 2099752.9558 | 37.744863225687105 | -122.482198340398 | (37.7448632256871, -122.482198340398) | ||
| 10487 | 10487 | 86204 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2427 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988880.8286 | 2098804.4715 | 37.7422764696275 | -122.48108634060499 | (37.7422764696275, -122.481086340605) | ||
| 10493 | 10493 | 86399 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1639 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988077.0028 | 2104128.4671 | 37.75684797893629 | -122.484256057823 | (37.7568479789363, -122.484256057823) | ||
| 10502 | 10502 | 86009 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987523.9067 | 2103537.3673 | 37.755192759360106 | -122.486125454711 | (37.7551927593601, -122.486125454711) | ||
| 10514 | 10514 | 86262 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988454.7415 | 2103581.1196 | 37.7553670969368 | -122.48290959942499 | (37.7553670969368, -122.482909599425) | ||
| 10519 | 10519 | 86446 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.742094952584296 | -122.484139283552 | (37.7420949525843, -122.484139283552) | ||
| 10546 | 10546 | 86231 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988617.0288 | 2098793.8112 | 37.7422318603031 | -122.481997687782 | (37.7422318603031, -122.481997687782) | ||
| 10547 | 10547 | 85949 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1430 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988070.6928 | 2105557.2008 | 37.760770526422206 | -122.484382665437 | (37.7607705264222, -122.484382665437) | ||
| 10586 | 10586 | 85951 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988061.1772 | 2105842.3097 | 37.7615528036389 | -122.484436487246 | (37.7615528036389, -122.484436487246) | ||
| 10610 | 10610 | 86583 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2567 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987981.2526 | 2097846.7049 | 37.7395943585814 | -122.48412653866998 | (37.7395943585814, -122.48412653867) | ||
| 10612 | 10612 | 93470 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1445 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988675.4994 | 2098958.5529 | 37.7426875982526 | -122.48180758126699 | (37.7426875982526, -122.481807581267) | ||
| 10616 | 10616 | 86106 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2576 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988959.241 | 2097817.0609999998 | 37.7395698560466 | -122.480742946483 | (37.7395698560466, -122.480742946483) | ||
| 10619 | 10619 | 86004 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1774 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.4685 | 2103215.2309 | 37.7543088755282 | -122.486065283877 | (37.7543088755282, -122.486065283877) | ||
| 10664 | 10664 | 85932 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1666 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988126.3838 | 2103953.8446 | 37.7563713878607 | -122.48407247701599 | (37.7563713878607, -122.484072477016) | ||
| 10700 | 10700 | 86253 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2206 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988562.6729 | 2100280.8313 | 37.746311664404395 | -122.482294555654 | (37.7463116644044, -122.482294555654) | ||
| 10702 | 10702 | 86368 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1235 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987981.927999999 | 2106870.8736 | 37.764372343527704 | -122.48478603091999 | (37.7643723435277, -122.48478603092) | ||
| 10703 | 10703 | 86119 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2462 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988932.9456 | 2098582.1283 | 37.7416690029042 | -122.480889862999 | (37.7416690029042, -122.480889862999) | ||
| 10712 | 10712 | 85954 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1370 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988057.3894 | 2105986.2433 | 37.7619477854522 | -122.484460144927 | (37.7619477854522, -122.484460144927) | ||
| 10713 | 10713 | 86573 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2423 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098798.3799 | 37.742205440307295 | -122.48431315163401 | (37.7422054403073, -122.484313151634) | ||
| 10736 | 10736 | 86002 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1824 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987543.255 | 2102835.2262 | 37.7532659973414 | -122.486007006329 | (37.7532659973414, -122.486007006329) | ||
| 10737 | 10737 | 85944 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1530 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988094.8611 | 2104879.1908 | 37.758910302597705 | -122.48424935350799 | (37.7589103025977, -122.484249353508) | ||
| 10738 | 10738 | 86398 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1631 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988074.1402 | 2104179.9951 | 37.75698929420739 | -122.484269736563 | (37.7569892942074, -122.484269736563) | ||
| 10754 | 10754 | 86066 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1959 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.0381 | 2101952.375 | 37.7508412720312 | -122.48598099746 | (37.7508412720312, -122.48598099746) | ||
| 10767 | 10767 | 86061 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1877 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987508.8564 | 2102515.9989 | 37.752387480581206 | -122.48610253041201 | (37.7523874805812, -122.486102530412) | ||
| 10772 | 10772 | 86206 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2439 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988884.8897 | 2098711.7439 | 37.742022099983295 | -122.481065510643 | (37.7420220999833, -122.481065510643) | ||
| 10775 | 10775 | 93460 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987430.6912 | 2098918.5196 | 37.7425052083655 | -122.486108776631 | (37.7425052083655, -122.486108776631) | ||
| 10806 | 10806 | 86097 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2646 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988975.9803 | 2097328.4213 | 37.7382291513586 | -122.480649308029 | (37.7382291513586, -122.480649308029) | ||
| 10823 | 10823 | 86395 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1609 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988071.9932 | 2104313.1089 | 37.7573546636623 | -122.48428692393 | (37.7573546636623, -122.48428692393) | ||
| 10825 | 10825 | 85998 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1848 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987552.182999999 | 2102681.5677 | 37.752844612846395 | -122.485964853879 | (37.7528446128464, -122.485964853879) | ||
| 10828 | 10828 | 85935 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1622 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988119.2271 | 2104230.0917 | 37.7571294710464 | -122.484117484634 | (37.7571294710464, -122.484117484634) | ||
| 10833 | 10833 | 86195 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2319 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988854.4439 | 2099524.1394 | 37.7442509550914 | -122.481230257133 | (37.7442509550914, -122.481230257133) | ||
| 10928 | 10928 | 86448 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | ||
| 10941 | 10941 | 86400 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1659 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988082.0125 | 2104007.5196 | 37.7565161814967 | -122.48422986283899 | (37.7565161814967, -122.484229862839) | ||
| 10948 | 10948 | 85997 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1852 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987552.7911 | 2102660.2851 | 37.7527862120032 | -122.485961188927 | (37.7527862120032, -122.485961188927) | ||
| 10961 | 10961 | 86453 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2330 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987973.3506 | 2099428.6905 | 37.74393761420671 | -122.48426985180201 | (37.7439376142067, -122.484269851802) | ||
| 10971 | 10971 | 86194 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2315 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988852.7525 | 2099552.2157 | 37.7443279469011 | -122.481238161111 | (37.7443279469011, -122.481238161111) | ||
| 10972 | 10972 | 86435 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2578 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988030.7572 | 2097759.3623 | 37.739357420836704 | -122.483948972283 | (37.7393574208367, -122.483948972283) | ||
| 10979 | 10979 | 86252 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2226 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988566.5136 | 2100155.797 | 37.745968576662996 | -122.48227211596901 | (37.745968576663, -122.482272115969) | ||
| 10992 | 10992 | 86196 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2323 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988857.15 | 2099475.7669 | 37.7441182942376 | -122.48121735867399 | (37.7441182942376, -122.481217358674) | ||
| 11018 | 11018 | 86445 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | ||
| 11053 | 11053 | 86001 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1828 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987544.5696 | 2102809.3725 | 37.753195086669294 | -122.486000562627 | (37.7531950866693, -122.486000562627) | ||
| 11068 | 11068 | 86516 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1303 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.5588 | 2106373.6447 | 37.762990173852 | -122.48575382789801 | (37.762990173852, -122.485753827898) | ||
| 11069 | 11069 | 86218 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2639 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988928.7681 | 2097372.6349 | 37.738347806336 | -122.4808157786 | (37.738347806336, -122.4808157786) | ||
| 11120 | 11120 | 86325 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2227 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988524.6932 | 2100155.797 | 37.7459661439862 | -122.48241672353201 | (37.7459661439862, -122.482416723532) | ||
| 11122 | 11122 | 85996 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1872 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987556.1355 | 2102525.9006 | 37.7524174232854 | -122.48593976036699 | (37.7524174232854, -122.485939760367) | ||
| 11133 | 11133 | 86259 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1742 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988458.5741 | 2103455.1907 | 37.755021553038205 | -122.482887116617 | (37.7550215530382, -122.482887116617) | ||
| 11141 | 11141 | 86005 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1770 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987533.6561 | 2103240.4169 | 37.754377982127295 | -122.486069942013 | (37.7543779821273, -122.486069942013) | ||
| 11145 | 11145 | 86328 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988528.9606 | 2100030.7626 | 37.7456230807951 | -122.482392807934 | (37.7456230807951, -122.482392807934) | ||
| 11155 | 11155 | 86207 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2443 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988885.2281 | 2098689.4081 | 37.7419607913912 | -122.481062705501 | (37.7419607913912, -122.481062705501) | ||
| 11157 | 11157 | 86388 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1543 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988055.0728 | 2104801.2215 | 37.7586939032987 | -122.48438123978599 | (37.7586939032987, -122.484381239786) | ||
| 11171 | 11171 | 86212 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2475 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988890.6429 | 2098502.9376 | 37.741449106920705 | -122.48103033287902 | (37.7414491069207, -122.481030332879) | ||
| 11216 | 11216 | 86260 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1730 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988456.9316 | 2103534.0331 | 37.755237937503296 | -122.482898574742 | (37.7552379375033, -122.482898574742) | ||
| 11235 | 11235 | 86215 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2611 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988923.4537 | 2097544.6896 | 37.7388199149273 | -122.480846746123 | (37.7388199149273, -122.480846746123) | ||
| 11238 | 11238 | 86381 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1449 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988033.2668 | 2105434.5266 | 37.760431517128296 | -122.48450310552299 | (37.7604315171283, -122.484503105523) | ||
| 11254 | 11254 | 93464 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1709 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987892.9754 | 2098932.7333 | 37.7425711665628 | -122.484511397018 | (37.7425711665628, -122.484511397018) | ||
| 11267 | 11267 | 85948 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1478 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2006 12:00:00 AM | 3 | 3x3 | 5988082.7523 | 2105259.0401 | 37.7599525605076 | -122.484319089498 | (37.7599525605076, -122.484319089498) | ||
| 11283 | 11283 | 86391 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1575 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988062.4738 | 2104583.9812 | 37.7580978513193 | -122.484339711268 | (37.7580978513193, -122.484339711268) | ||
| 11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
| 11307 | 11307 | 86072 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2135 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987571.2196 | 2100754.5787 | 37.747554727515 | -122.48575760396002 | (37.747554727515, -122.48575760396) | ||
| 11389 | 11389 | 86396 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1615 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988073.4245 | 2104292.3546 | 37.75729776131279 | -122.48428045190599 | (37.7572977613128, -122.484280451906) | ||
| 11391 | 11391 | 86258 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1746 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988459.1216 | 2103429.4574 | 37.754950928168995 | -122.48288333738 | (37.754950928169, -122.48288333738) | ||
| 11392 | 11392 | 85993 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1886 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.1996 | 2102449.1312 | 37.7522066972052 | -122.485930446138 | (37.7522066972052, -122.485930446138) | ||
| 11398 | 11398 | 86374 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988004.3613 | 2106238.9386 | 37.762638529629506 | -122.48466208303199 | (37.7626385296295, -122.484662083032) | ||
| 11411 | 11411 | 93457 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5987093.9615 | 2098905.6596 | 37.74245026783021 | -122.487272128606 | (37.7424502678302, -122.487272128606) | ||
| 11438 | 11438 | 86379 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1375 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988016.2656 | 2105945.6605 | 37.7618339613784 | -122.484599397348 | (37.7618339613784, -122.484599397348) | ||
| 11498 | 11498 | 85995 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1876 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.1996 | 2102499.9054 | 37.7523461094806 | -122.485934172676 | (37.7523461094806, -122.485934172676) | ||
| 11499 | 11499 | 86104 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2586 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988961.2103 | 2097747.6421 | 37.73937936427271 | -122.48073105683399 | (37.7393793642727, -122.480731056834) | ||
| 11518 | 11518 | 86451 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2358 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987978.4269 | 2099245.2659 | 37.743434274314396 | -122.484238850005 | (37.7434342743144, -122.484238850005) | ||
| 11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
| 11547 | 11547 | 85938 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1590 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988108.9468 | 2104468.7646 | 37.7577842036766 | -122.484170540261 | (37.7577842036766, -122.484170540261) | ||
| 11573 | 11573 | 86006 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1766 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.8436 | 2103268.4464 | 37.7544548962014 | -122.48607480922199 | (37.7544548962014, -122.486074809222) | ||
| 11594 | 11594 | 86068 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1975 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.2192 | 2101849.8619 | 37.7505599257071 | -122.485965931252 | (37.7505599257071, -122.485965931252) |
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");