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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 118129 | 118129 | 2453 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1801X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 0 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.786521075947796 | -122.430070036959 | (37.7865210759478, -122.430070036959) | ||
| 106288 | 106288 | 2454 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1801X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 6 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.786521075947796 | -122.430070036959 | (37.7865210759478, -122.430070036959) | ||
| 103494 | 103494 | 2455 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1801X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 18 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.786521075947796 | -122.430070036959 | (37.7865210759478, -122.430070036959) | ||
| 123464 | 123464 | 4023 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 121773 | 121773 | 4025 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/2015 03:01:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 119406 | 119406 | 4026 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 125081 | 125081 | 4027 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 143514 | 143514 | 4029 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 107830 | 107830 | 4033 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 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) | ||
| 141683 | 141683 | 8518 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2099X Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | ||
| 102392 | 102392 | 8520 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3x3 | 6001704.2218086 | 2113592.1733887 | 37.7836169980639 | -122.437805961293 | (37.7836169980639, -122.437805961293) | ||
| 19795 | 19795 | 9378 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001091.814301901 | 2097867.0769738997 | 37.740404899832896 | -122.438797433034 | (37.7404048998329, -122.438797433034) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 141416 | 141416 | 11200 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 186 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 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) | ||
| 103342 | 103342 | 12426 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1701X Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 4X4 | 6004430.116669999 | 2114714.4618599997 | 37.786853145727704 | -122.428455426283 | (37.7868531457277, -122.428455426283) | ||
| 143081 | 143081 | 13118 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1633 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004565.4050748 | 2119750.0667864 | 37.800687292153896 | -122.428346396238 | (37.8006872921539, -122.428346396238) | |||
| 101182 | 101182 | 13415 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 430 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 5 | 5999619.6561933 | 2097087.2734828999 | 37.7381798806191 | -122.443831547884 | (37.7381798806191, -122.443831547884) | |||
| 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) | ||
| 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) | |||
| 127780 | 127780 | 16687 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 500 Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 2 | 5992496.9362665005 | 2103468.0481268 | 37.755291002769496 | -122.468922364571 | (37.7552910027695, -122.468922364571) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 114696 | 114696 | 18784 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 345X Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2014 12:00:00 AM | 3 | 3x3 | 6000292.8158924 | 2106925.3125911 | 37.7652311289718 | -122.442210131131 | (37.7652311289718, -122.442210131131) | ||
| 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) |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 112336 | 112336 | 24168 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 12012 | 12012 | 85885 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2594 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988342.102999999 | 2097683.778 | 37.7391680067391 | -122.482866951392 | (37.7391680067391, -122.482866951392) | ||
| 11868 | 11868 | 85927 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103551.0636 | 37.7552665558176 | -122.483977844866 | (37.7552665558176, -122.483977844866) | ||
| 13172 | 13172 | 85930 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1696 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988134.2561 | 2103800.6921 | 37.7559513307755 | -122.484034021792 | (37.7559513307755, -122.484034021792) | ||
| 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) | ||
| 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) | ||
| 11792 | 11792 | 85933 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1638 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988122.0898 | 2104149.2214 | 37.7569075897464 | -122.484101654102 | (37.7569075897464, -122.484101654102) | ||
| 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) | ||
| 12379 | 12379 | 85936 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1618 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988118.5115 | 2104260.1496 | 37.7572119602441 | -122.484122163635 | (37.7572119602441, -122.484122163635) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13012 | 13012 | 85989 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2250 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.6248 | 2099959.0705 | 37.7453746344244 | -122.48545232432 | (37.7453746344244, -122.48545232432) | ||
| 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) | ||
| 12115 | 12115 | 85992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2206 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987631.9563 | 2100247.5457 | 37.746166089002706 | -122.48551037976499 | (37.7461660890027, -122.485510379765) | ||
| 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) | ||
| 12048 | 12048 | 85994 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1886 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.5036 | 2102469.8058 | 37.7522634818033 | -122.485930912268 | (37.7522634818033, -122.485930912268) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13043 | 13043 | 85999 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1844 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987550.0547 | 2102710.7553 | 37.7529246300957 | -122.485974356105 | (37.7529246300957, -122.485974356105) | ||
| 12321 | 12321 | 86000 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1832 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987545.0078 | 2102782.6424 | 37.7531217185644 | -122.485997085337 | (37.7531217185644, -122.485997085337) | ||
| 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) | ||
| 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) | ||
| 12786 | 12786 | 86003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1786 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987537.7183 | 2103137.642 | 37.7540960267794 | -122.486048350317 | (37.7540960267794, -122.486048350317) | ||
| 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) | ||
| 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) |
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");