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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
3242 | 3242 | 253354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3244 | 3244 | 253350 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3245 | 3245 | 138485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | 2 | Width 0ft | Permit Number 47204 | 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) | |||
5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
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) | |||
6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
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) | ||
10200 | 10200 | 122374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
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) | ||
11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
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) | ||
12065 | 12065 | 108545 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) |
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) | ||||
14002 | 14002 | 44086 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013734.19002 | 2112474.65205 | 37.7812252500735 | -122.396108228707 | (37.7812252500735, -122.396108228707) | |
15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
19427 | 19427 | 51055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748001 | (37.746973143605, -122.47319139748) | |||
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) | ||||
19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
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) | |||
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) | |||
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) | |||
27593 | 27593 | 82193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49858 | 5989080.382 | 2102109.5053 | 37.7513628201965 | -122.48063824575 | (37.7513628201965, -122.48063824575) | |
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) | |||
30525 | 30525 | 36338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.45733685578699 | (37.7264778306363, -122.457336855787) | ||
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) | |||
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) | |||
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) | |||
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) | |||
41743 | 41743 | 99624 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768786 | 5998532.9 | 2110322.2 | 37.7744576589045 | -122.448541895436 | (37.7744576589045, -122.448541895436) | |
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) | |||
46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
48718 | 48718 | 97494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988382.76278 | 2111930.5362 | 37.778288112363796 | -122.483770678777 | (37.7782881123638, -122.483770678777) | |
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) | |||
49418 | 49418 | 104126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1330 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 8x6 | Permit Number 770527 | 6001460.4923 | 2110454.7269 | 37.774988502255 | -122.438424312648 | (37.774988502255, -122.438424312648) | ||
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) | |||
51315 | 51315 | 34818 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
51735 | 51735 | 88092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51095 | 5984042.9711 | 2104115.7287 | 37.756577293333294 | -122.49820607925 | (37.7565772933333, -122.49820607925) | |
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) | |||
53597 | 53597 | 42437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
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) | |||
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) | |||
56224 | 56224 | 50964 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47459 | 5996570.7873 | 2113602.9801 | 37.783353433045995 | -122.455566358041 | (37.783353433046, -122.455566358041) | ||
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) | |||
57315 | 57315 | 92291 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2541 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52737 | 5989837.8157 | 2098042.3571 | 37.7402394868641 | -122.47772171282601 | (37.7402394868641, -122.477721712826) |
58289 | 58289 | 95775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.6643199995 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) |
58952 | 58952 | 36362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.45722008615101 | (37.7283834402433, -122.457220086151) |
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");