Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 18983 | 18983 | 11186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | |||
| 146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
| 79671 | 79671 | 115684 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 103534 | 103534 | 115686 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 115299 | 115299 | 115687 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 143683 | 143683 | 115685 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 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 | |||||||||
| 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) | ||
| 110833 | 110833 | 16607 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 107 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6002880.641859099 | 2107642.9841193003 | 37.7673488254303 | -122.433310753696 | (37.7673488254303, -122.433310753696) | |||
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 54864 | 54864 | 178902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.721497357285706 | -122.401224985361 | (37.7214973572857, -122.401224985361) | |||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 14606 | 14606 | 15049 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | ||
| 12090 | 12090 | 85962 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | ||
| 12727 | 12727 | 85961 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988024.0524 | 2107011.4158 | 37.7647606871244 | -122.484650646191 | (37.7647606871244, -122.484650646191) | ||
| 119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
| 171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
| 11815 | 11815 | 85960 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988027.116 | 2106908.7855 | 37.764479070899 | -122.48463252131201 | (37.764479070899, -122.484632521312) | ||
| 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) | ||
| 12156 | 12156 | 86038 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1261 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987366.2761 | 2106684.0781 | 37.7638235791025 | -122.486901653076 | (37.7638235791025, -122.486901653076) | ||
| 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) | ||
| 80506 | 80506 | 27758 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 83929 | 83929 | 27750 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 118003 | 118003 | 27753 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 126737 | 126737 | 27754 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 96146 | 96146 | 29251 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.750187626613496 | -122.39046013782401 | (37.7501876266135, -122.390460137824) | ||
| 124164 | 124164 | 27720 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 06:49:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.750187626613496 | -122.39046013782401 | (37.7501876266135, -122.390460137824) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12281 | 12281 | 86371 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.0325 | 2106399.6463 | 37.7630795369037 | -122.48468884389999 | (37.7630795369037, -122.4846888439) | ||
| 18986 | 18986 | 10211 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1311 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1991 12:00:00 AM | 12 | 2X2 | 6005852.922730001 | 2101311.29856 | 37.7501316687427 | -122.422580057332 | (37.7501316687427, -122.422580057332) | ||
| 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) | ||
| 12042 | 12042 | 85957 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1330 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988048.1907 | 2106230.8219999997 | 37.762618796080105 | -122.484509899399 | (37.7626187960801, -122.484509899399) | ||
| 13165 | 13165 | 86375 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1335 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988007.6079 | 2106189.1571 | 37.7625020323163 | -122.48464720252399 | (37.7625020323163, -122.484647202524) | ||
| 79165 | 79165 | 91895 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1342 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991627.501572 | 2106598.137501 | 37.7638351306782 | -122.472157247242 | (37.7638351306782, -122.472157247242) | ||
| 12387 | 12387 | 85955 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1346 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988066.5882 | 2106122.0602 | 37.7623212372231 | -122.48443829226002 | (37.7623212372231, -122.48443829226) | ||
| 12273 | 12273 | 86377 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1347 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2007 12:00:00 AM | 3 | 3x3 | 5988009.7723 | 2106116.6492 | 37.7623030714917 | -122.484634397827 | (37.7623030714917, -122.484634397827) | ||
| 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) | ||
| 11850 | 11850 | 85953 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1374 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988058.4716 | 2105953.2359 | 37.76185721916121 | -122.48445398099899 | (37.7618572191612, -122.484453980999) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 46253 | 46253 | 27745 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1399 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.852606599 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | ||
| 104005 | 104005 | 27743 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1399 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6014867.852606599 | 2101105.5872465 | 37.7500712934283 | -122.391391267014 | (37.7500712934283, -122.391391267014) | ||
| 184636 | 184636 | 199678 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1400x Underwood Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6015628.2568 | 2092949.4044 | 37.72771825330071 | -122.388192580507 | (37.7277182533007, -122.388192580507) | |||
| 12099 | 12099 | 93471 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1409 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988822.3083 | 2098962.9504 | 37.7427082090524 | -122.48130028623699 | (37.7427082090524, -122.481300286237) | ||
| 12024 | 12024 | 85950 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1426 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988070.6928 | 2105585.8941 | 37.760849310406705 | -122.484384769961 | (37.7608493104067, -122.484384769961) | ||
| 58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
| 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) | ||
| 12361 | 12361 | 86380 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1435 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988029.9401 | 2105512.7054 | 37.7606459810936 | -122.48452034532801 | (37.7606459810936, -122.484520345328) | ||
| 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) | ||
| 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) | ||
| 12728 | 12728 | 86382 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1453 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988035.346 | 2105390.8629 | 37.7603117495754 | -122.484492711924 | (37.7603117495754, -122.484492711924) | ||
| 11760 | 11760 | 86383 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1465 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988037.0094 | 2105333.0605 | 37.7601531367846 | -122.48448271934299 | (37.7601531367846, -122.484482719343) | ||
| 11639 | 11639 | 86384 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1469 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988038.2569 | 2105288.5651 | 37.7600310371708 | -122.484475141227 | (37.7600310371708, -122.484475141227) | ||
| 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) | ||
| 11832 | 11832 | 85947 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1490 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988084.4157 | 2105183.7722 | 37.7597459921782 | -122.484307816387 | (37.7597459921782, -122.484307816387) | ||
| 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) | |||
| 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) | ||
| 12452 | 12452 | 93469 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1501X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988527.5163 | 2098956.0844 | 37.742672213494394 | -122.482319077312 | (37.7426722134944, -122.482319077312) | ||
| 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) | ||
| 12138 | 12138 | 86309 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1503 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988357.631 | 2105031.2185 | 37.7593430258366 | -122.483351727957 | (37.7593430258366, -122.483351727957) | ||
| 12276 | 12276 | 85945 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1506 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988089.5183 | 2105016.1614 | 37.759286075581 | -122.48427787656401 | (37.759286075581, -122.484277876564) | ||
| 88617 | 88617 | 115688 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 96639 | 96639 | 111917 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 111648 | 111648 | 119720 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 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) | ||
| 12592 | 12592 | 93411 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1532 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2009 12:00:00 AM | 3 | 3x3 | 5988415.4987 | 2099015.9851 | 37.7428301684871 | -122.482710785873 | (37.7428301684871, -122.482710785873) | ||
| 13091 | 13091 | 86495 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1534 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987787.3318 | 2104833.8728 | 37.7587679608906 | -122.485309594748 | (37.7587679608906, -122.485309594748) | ||
| 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) | ||
| 12408 | 12408 | 85941 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1546 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988098.2611 | 2104771.8486 | 37.758615768012795 | -122.48422972260799 | (37.7586157680128, -122.484229722608) | ||
| 11751 | 11751 | 86389 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1547 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988054.2021 | 2104771.6176 | 37.7586125683242 | -122.484382079778 | (37.7586125683242, -122.484382079778) | ||
| 11992 | 11992 | 85939 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1558 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988101.6611 | 2104690.7347 | 37.75839324920911 | -122.48421201536199 | (37.7583932492091, -122.484212015362) | ||
| 12732 | 12732 | 86390 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1571 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988060.297 | 2104609.2316 | 37.75816705532 | -122.484349091388 | (37.75816705532, -122.484349091388) | ||
| 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) | ||
| 12910 | 12910 | 26795 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.712320301990204 | -122.40679292443501 | (37.7123203019902, -122.406792924435) | ||
| 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) | ||
| 11937 | 11937 | 86393 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1595 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988065.0859 | 2104499.9584 | 37.7578672995837 | -122.48432451533002 | (37.7578672995837, -122.48432451533) | ||
| 11981 | 11981 | 86394 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1595 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988065.5212 | 2104481.6737 | 37.7578171200991 | -122.48432166889401 | (37.7578171200991, -122.484321668894) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 26263 | 26263 | 23904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6003550.0996 | 2114363.7178 | 37.7858402532263 | -122.43147503127199 | (37.7858402532263, -122.431475031272) | |||
| 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) | ||
| 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) |
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");