Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH, PlotSize
qLegalStatus ✖
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) | ||
213 | 213 | 28640 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.782776612799296 | -122.430825656777 | (37.7827766127993, -122.430825656777) | ||
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) | ||
605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
853 | 853 | 244350 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 07:22:00 AM | 3 | Width 0ft | 6005619.219 | 2110418.7508 | 37.77512539438639 | -122.424035805431 | (37.7751253943864, -122.424035805431) | ||
2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
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 | |||||||||
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) | |||
4250 | 4250 | 139410 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 10:27:00 AM | 3 | Width 0ft | 6004177.291 | 2114035.4814 | 37.78497452552379 | -122.429281709952 | (37.7849745255238, -122.429281709952) | ||
4309 | 4309 | 1910 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 47 Beideman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001514.9606 | 2113070.1349 | 37.782172849750296 | -122.43842331734601 | (37.7821728497503, -122.438423317346) | |||
4331 | 4331 | 87404 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003683.0746 | 2113412.9921 | 37.783237334948105 | -122.43094709822701 | (37.7832373349481, -122.430947098227) | ||
4516 | 4516 | 28647 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.785885930849204 | -122.431484021877 | (37.7858859308492, -122.431484021877) | |||
5350 | 5350 | 28646 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003557.7645 | 2114374.9896 | 37.7858716371659 | -122.431449317827 | (37.7858716371659, -122.431449317827) | |||
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) | ||
5618 | 5618 | 87403 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | ||
5957 | 5957 | 28643 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.43088139933201 | (37.7829985565916, -122.430881399332) | |||
5993 | 5993 | 23902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003560.0188 | 2114334.411 | 37.7857603463241 | -122.431438620741 | (37.7857603463241, -122.431438620741) | |||
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) | |||
6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
6792 | 6792 | 23871 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1499X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003600.3539 | 2113692.9201 | 37.784001259600295 | -122.43125326646499 | (37.7840012596003, -122.431253266465) | |||
7067 | 7067 | 28641 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003709.2011 | 2113267.9212 | 37.7828404869024 | -122.43084635463 | (37.7828404869024, -122.43084635463) | |||
7475 | 7475 | 28644 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003694.7628 | 2113348.3634 | 37.7830605429851 | -122.430902047868 | (37.7830605429851, -122.430902047868) | ||
8518 | 8518 | 18226 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1675 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004172.0667 | 2114245.454 | 37.785550761919 | -122.42931476245899 | (37.785550761919, -122.429314762459) | |||
8595 | 8595 | 28648 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003548.747 | 2114394.8281 | 37.7859255976047 | -122.43148193261601 | (37.7859255976047, -122.431481932616) | ||
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) | ||
9845 | 9845 | 12411 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1610X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004443.6433 | 2114336.5232 | 37.785816186279504 | -122.42838167990801 | (37.7858161862795, -122.428381679908) | ||
9984 | 9984 | 106984 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 3 | 6003775.6189 | 2114189.0991 | 37.7853735733153 | -122.430682332536 | (37.7853735733153, -122.430682332536) | |||
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) | ||
10464 | 10464 | 86111 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2544 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988952.3483 | 2098011.286 | 37.7401027466921 | -122.48078099378901 | (37.7401027466921, -122.480780993789) | ||
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) | ||
10787 | 10787 | 86372 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.5736 | 2106373.6733 | 37.7630082536672 | -122.48468506709101 | (37.7630082536672, -122.484685067091) | ||
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) | ||
10873 | 10873 | 85952 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988060.095 | 2105875.8581 | 37.761644855373895 | -122.484442690808 | (37.7616448553739, -122.484442690808) | ||
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) | ||
11039 | 11039 | 86373 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | ||
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) |
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");