Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 2427 | 2427 | 23895 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003532.7108 | 2114115.4269999997 | 37.7851575236987 | -122.431517459739 | (37.7851575236987, -122.431517459739) | ||
| 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 | |||||||||
| 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) | ||
| 2665 | 2665 | 21684 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2004 12:00:00 AM | 3 | 4x4 | 6003739.9244 | 2114585.2131 | 37.7864591803505 | -122.43083410335501 | (37.7864591803505, -122.430834103355) | ||
| 3194 | 3194 | 253362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3209 | 3209 | 253364 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3215 | 3215 | 253360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
| 3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
| 4166 | 4166 | 143128 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006467.2287 | 2117887.8753 | 37.795681615093 | -122.421632954779 | (37.795681615093, -122.421632954779) | |||
| 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) | |||
| 5333 | 5333 | 26937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1529 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002019.9705 | 2111862.8998 | 37.7788867994939 | -122.436589775324 | (37.7788867994939, -122.436589775324) | |||
| 5536 | 5536 | 8091 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004317.1512 | 2111553.1108 | 37.7781664691559 | -122.42862082556499 | (37.7781664691559, -122.428620825565) | ||
| 6354 | 6354 | 98096 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006843.26628 | 2115504.44745 | 37.789158511592 | -122.420162558272 | (37.789158511592, -122.420162558272) | |||
| 7387 | 7387 | 98089 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.789362361841505 | -122.41906838009899 | (37.7893623618415, -122.419068380099) | ||
| 7927 | 7927 | 13089 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | |||
| 8106 | 8106 | 114661 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1603 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | 3x3 | 6004477.5231 | 2114370.1159 | 37.7859103404926 | -122.42826686028299 | (37.7859103404926, -122.428266860283) | ||
| 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) | ||
| 10438 | 10438 | 95023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.711484695229295 | -122.404646681546 | (37.7114846952293, -122.404646681546) | |||
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 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) | ||
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
| 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) | ||
| 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) | ||
| 11165 | 11165 | 95019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485001 | (37.7116804891797, -122.40514245485) | |||
| 11444 | 11444 | 86329 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988529.8141 | 2100010.2791 | 37.7455668881622 | -122.48238835613998 | (37.7455668881622, -122.48238835614) | ||
| 11451 | 11451 | 94993 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.711794905553106 | -122.405106866024 | (37.7117949055531, -122.405106866024) | |||
| 11620 | 11620 | 86115 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2490X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988938.6988 | 2098392.9506 | 37.7411499047667 | -122.480856123487 | (37.7411499047667, -122.480856123487) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12106 | 12106 | 93458 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987115.9589 | 2098905.998 | 37.7424524797237 | -122.487196094011 | (37.7424524797237, -122.487196094011) | ||
| 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) | ||
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 12883 | 12883 | 26798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.71215348320929 | -122.406360290051 | (37.7121534832093, -122.406360290051) | |||
| 13038 | 13038 | 86102 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2602X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988967.6106 | 2097559.0789 | 37.7388619907591 | -122.480695127099 | (37.7388619907591, -122.480695127099) | ||
| 13104 | 13104 | 93461 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987454.3807 | 2098917.8428 | 37.7425047306499 | -122.48602681673599 | (37.7425047306499, -122.486026816736) | ||
| 13151 | 13151 | 86202 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2395X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.6808 | 2099096.9051 | 37.7430788257671 | -122.48114283650101 | (37.7430788257671, -122.481142836501) | ||
| 13302 | 13302 | 187656 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1548 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | ||||
| 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) | |||
| 19557 | 19557 | 119842 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 23946 | 23946 | 113286 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1626 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002122.0899 | 2114184.377 | 37.7852667906839 | -122.43640269829099 | (37.7852667906839, -122.436402698291) | |||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 24995 | 24995 | 181628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1290 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988037.8386 | 2106538.091 | 37.7634618698416 | -122.48456824258498 | (37.7634618698416, -122.484568242585) | |||
| 25020 | 25020 | 182555 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986616.8854 | 2105696.0047 | 37.761066882292 | -122.489420874881 | (37.761066882292, -122.489420874881) | |||
| 25716 | 25716 | 135893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001843.597519999 | 2121830.48703 | 37.806245186226505 | -122.437914052191 | (37.8062451862265, -122.437914052191) | ||||
| 25806 | 25806 | 214442 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991187.94391 | 2101152.05769 | 37.7488561836758 | -122.47328030175801 | (37.7488561836758, -122.473280301758) | |||
| 26149 | 26149 | 142789 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 625 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007523.6751 | 2113458.738 | 37.783579806807296 | -122.417663367701 | (37.7835798068073, -122.417663367701) | |||
| 27000 | 27000 | 214389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992333.20147 | 2097526.08875 | 37.7389664461405 | -122.469056185189 | (37.7389664461405, -122.469056185189) | |||
| 27002 | 27002 | 181705 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | |||
| 27558 | 27558 | 141133 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1901 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002295.7325 | 2113639.3231 | 37.7837800762345 | -122.435762938134 | (37.7837800762345, -122.435762938134) | |||
| 28653 | 28653 | 140315 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2112 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997699.8421 | 2109926.1659 | 37.7733225841329 | -122.45139501771901 | (37.7733225841329, -122.451395017719) | |||
| 30623 | 30623 | 182368 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986188.3183 | 2104920.5503 | 37.758912670790004 | -122.490846021107 | (37.75891267079, -122.490846021107) | |||
| 30964 | 30964 | 140965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 72 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997532.582 | 2113283.8483 | 37.7825323254485 | -122.45221591068399 | (37.7825323254485, -122.452215910684) | |||
| 32011 | 32011 | 245193 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 48 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000872.1204 | 2109220.0374 | 37.77156487066021 | -122.44037104524901 | (37.7715648706602, -122.440371045249) | |||
| 33113 | 33113 | 183374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2725 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985535.6187 | 2096728.138 | 37.736380379394 | -122.492500010635 | (37.736380379394, -122.492500010635) | |||
| 35260 | 35260 | 135914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | |||
| 35538 | 35538 | 196420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010086.24135 | 2110805.69337 | 37.776439037479896 | -122.408610616413 | (37.7764390374799, -122.408610616413) | |||
| 35756 | 35756 | 218355 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993521.424240001 | 2100014.7209799998 | 37.7458681870785 | -122.465128597612 | (37.7458681870785, -122.465128597612) | |||
| 37372 | 37372 | 101729 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 90 Rotteck St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003352.201090001 | 2094564.6464200001 | 37.731465517513 | -122.43074630169501 | (37.731465517513, -122.430746301695) | |||
| 37561 | 37561 | 135901 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008342.534990001 | 2119419.33537 | 37.7999921901354 | -122.415252502723 | (37.7999921901354, -122.415252502723) | ||||
| 37603 | 37603 | 196415 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.776598425219206 | -122.408805329496 | (37.7765984252192, -122.408805329496) | |||
| 41433 | 41433 | 139465 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 855 CENTRAL AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999527.6632 | 2111481.3292 | 37.77769715931579 | -122.445184184965 | (37.7776971593158, -122.445184184965) | |||
| 42071 | 42071 | 244906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 31 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000351.3383 | 2109052.958 | 37.7710764466514 | -122.442160459028 | (37.7710764466514, -122.442160459028) | |||
| 42824 | 42824 | 139130 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1580 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003638.5353 | 2114149.4067 | 37.7852568207566 | -122.43115376623501 | (37.7852568207566, -122.431153766235) | |||
| 43063 | 43063 | 185135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5985252.6176 | 2097020.7349 | 37.7371672218976 | -122.493500001953 | (37.7371672218976, -122.493500001953) | |||
| 43146 | 43146 | 118427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5981873.51616 | 2111696.39703 | 37.7772641742522 | -122.506270809551 | (37.7772641742522, -122.506270809551) | |||
| 44877 | 44877 | 238005 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 118 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002126.98293 | 2096665.47856 | 37.7371644277915 | -122.435132311514 | (37.7371644277915, -122.435132311514) | |||
| 45806 | 45806 | 238022 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1430 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999608.40723 | 2107632.1113400003 | 37.7671327917617 | -122.44462813427401 | (37.7671327917617, -122.444628134274) | |||
| 47048 | 47048 | 247783 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 274 30th St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004785.28168 | 2098443.27058 | 37.7421964332069 | -122.42606787825198 | (37.7421964332069, -122.426067878252) | |||
| 47858 | 47858 | 142823 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006601.0091 | 2116911.6099 | 37.79300857718 | -122.421100695716 | (37.79300857718, -122.421100695716) | |||
| 48637 | 48637 | 140842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 133 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996517.655 | 2113507.2067 | 37.783087415663 | -122.455743248453 | (37.783087415663, -122.455743248453) | |||
| 49180 | 49180 | 141238 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 31 PARKER AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996802.437000001 | 2114389.98 | 37.7855276158827 | -122.45482182649599 | (37.7855276158827, -122.454821826496) | |||
| 49365 | 49365 | 142583 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2234 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008971.4462 | 2120841.4199 | 37.80393220502779 | -122.41317683745301 | (37.8039322050278, -122.413176837453) | |||
| 49526 | 49526 | 244925 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 223 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005441.8933 | 2110105.3671 | 37.77425490559 | -122.424626917474 | (37.77425490559, -122.424626917474) | |||
| 50224 | 50224 | 139387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005553.2038 | 2110871.2264 | 37.77636405517521 | -122.424296355394 | (37.7763640551752, -122.424296355394) | |||
| 50271 | 50271 | 214466 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5997445.293769999 | 2095483.61327 | 37.7336523503619 | -122.451233752738 | (37.7336523503619, -122.451233752738) | |||
| 52851 | 52851 | 142766 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 730 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6007514.5827 | 2113866.0765 | 37.7846977477095 | -122.417723705816 | (37.7846977477095, -122.417723705816) | |||
| 53665 | 53665 | 244990 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 215 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005497.2001 | 2110113.2681 | 37.7742797231705 | -122.42443616312299 | (37.7742797231705, -122.424436163123) | |||
| 53806 | 53806 | 244105 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1950 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997257.6483 | 2108826.1419 | 37.770276871813 | -122.452845205966 | (37.770276871813, -122.452845205966) | |||
| 53825 | 53825 | 182065 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988018.43 | 2105853.6729 | 37.761581514586396 | -122.484585163984 | (37.7615815145864, -122.484585163984) | |||
| 54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
| 54310 | 54310 | 182541 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1587 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985582.1491 | 2104435.4669 | 37.7575453355233 | -122.492906676836 | (37.7575453355233, -122.492906676836) | |||
| 54846 | 54846 | 196390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.39543730389799 | (37.7824096464379, -122.395437303898) | |||
| 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) | |||
| 54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
| 55073 | 55073 | 214457 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001468.0488 | 2094911.62577 | 37.732311314613106 | -122.43728499800699 | (37.7323113146131, -122.437284998007) | |||
| 56504 | 56504 | 214451 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | |||
| 56960 | 56960 | 142263 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 585 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004612.4683 | 2110683.7571 | 37.7757961457109 | -122.427537264685 | (37.7757961457109, -122.427537264685) | |||
| 57293 | 57293 | 139421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1655 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004270.6386 | 2114261.9481 | 37.7856016305795 | -122.428974908892 | (37.7856016305795, -122.428974908892) | |||
| 60280 | 60280 | 218132 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Lopez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5993993.8202 | 2100664.7541 | 37.747680242765895 | -122.463542297865 | (37.7476802427659, -122.463542297865) | |||
| 60303 | 60303 | 244983 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | |||
| 60645 | 60645 | 185813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1913 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989045.9651 | 2101702.9368 | 37.750244490673 | -122.480727500746 | (37.750244490673, -122.480727500746) | |||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 62057 | 62057 | 214444 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992635.01675 | 2098889.7212400003 | 37.7427280701488 | -122.468111823327 | (37.7427280701488, -122.468111823327) | |||
| 63044 | 63044 | 196410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009614.35227 | 2111076.8827400003 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | |||
| 63491 | 63491 | 182127 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2636 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987775.8815 | 2098311.0525 | 37.7408573756578 | -122.484870670835 | (37.7408573756578, -122.484870670835) |
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");