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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2513 | 2513 | 138183 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003936.4381 | 2114774.6580000003 | 37.7869904804487 | -122.43016773530199 | (37.7869904804487, -122.430167735302) | ||
| 2613 | 2613 | 98090 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | ||
| 4504 | 4504 | 8092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004291.3267 | 2111546.8391 | 37.778147787093 | -122.428709714706 | (37.778147787093, -122.428709714706) | ||
| 5466 | 5466 | 21688 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1881 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 2 | 4x4 | 6003696.9634 | 2114537.7544 | 37.7863264365495 | -122.430979349218 | (37.7863264365495, -122.430979349218) | ||
| 6750 | 6750 | 21685 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 4x4 | 6003694.6838 | 2114582.3856 | 37.7864488534059 | -122.43099042257299 | (37.7864488534059, -122.430990422573) | ||
| 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) | |||
| 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) | |||
| 8560 | 8560 | 98097 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.789170503156704 | -122.420050723983 | (37.7891705031567, -122.420050723983) | |||
| 11039 | 11039 | 86373 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | ||
| 12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
| 32181 | 32181 | 214447 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.21414 | 2099688.46118 | 37.7449632937192 | -122.465648504685 | (37.7449632937192, -122.465648504685) | |||
| 33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
| 34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
| 37082 | 37082 | 182550 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986517.6568 | 2105641.9803 | 37.760912753017394 | -122.48976008582899 | (37.7609127530174, -122.489760085829) | |||
| 38483 | 38483 | 237995 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4120 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002335.689069999 | 2101815.5144 | 37.751317069626204 | -122.434778894126 | (37.7513170696262, -122.434778894126) | |||
| 38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
| 39866 | 39866 | 182572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2212 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989118.5154 | 2098355.8518 | 37.7410584915124 | -122.48023167480301 | (37.7410584915124, -122.480231674803) | |||
| 41047 | 41047 | 139143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004425.4721 | 2114070.1832 | 37.7850838549959 | -122.428425556733 | (37.7850838549959, -122.428425556733) | |||
| 42943 | 42943 | 178899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.39805643095801 | (37.7119992718279, -122.398056430958) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 44205 | 44205 | 178924 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000939.255030001 | 2093544.2007900001 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | |||
| 44471 | 44471 | 182556 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986624.9706 | 2105696.7397 | 37.7610693723866 | -122.48939296609501 | (37.7610693723866, -122.489392966095) | |||
| 45819 | 45819 | 244240 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.0678 | 2110158.7025 | 37.774407460347796 | -122.424256515939 | (37.7744074603478, -122.424256515939) | |||
| 46200 | 46200 | 214462 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 139 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000481.8425900005 | 2095189.9969400002 | 37.7330195442146 | -122.440714490676 | (37.7330195442146, -122.440714490676) | |||
| 46653 | 46653 | 244106 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1950 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997207.2964 | 2108819.9511 | 37.7702569879828 | -122.453018925124 | (37.7702569879828, -122.453018925124) | |||
| 46789 | 46789 | 244991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | |||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 52829 | 52829 | 135900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006826.338330001 | 2115526.46894 | 37.7892180233479 | -122.420222690545 | (37.7892180233479, -122.420222690545) | |||
| 54862 | 54862 | 183412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985653.7417 | 2097035.0769 | 37.7372300576086 | -122.492114208587 | (37.7372300576086, -122.492114208587) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
| 61631 | 61631 | 178909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993779.42986 | 2086768.12245 | 37.70951113998979 | -122.463275405145 | (37.7095111399898, -122.463275405145) | ||||
| 61894 | 61894 | 178932 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000025.30894 | 2091607.27425 | 37.7231562071699 | -122.44203576925501 | (37.7231562071699, -122.442035769255) | |||
| 63020 | 63020 | 178940 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004061.97855 | 2093834.65882 | 37.729501322606 | -122.428240459522 | (37.729501322606, -122.428240459522) | |||
| 64163 | 64163 | 196408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 22 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009625.06025 | 2110948.02453 | 37.776804005729204 | -122.41021603036002 | (37.7768040057292, -122.41021603036) | |||
| 65293 | 65293 | 119806 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6005545.0 | 2110174.0 | 37.7744491774234 | -122.42427513465401 | (37.7744491774234, -122.424275134654) | ||||
| 66227 | 66227 | 196412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | |||
| 70069 | 70069 | 118023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5984366.09559 | 2112727.46699 | 37.780241619998 | -122.49772445801202 | (37.780241619998, -122.497724458012) | |||
| 76848 | 76848 | 135910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011521.095380001 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | ||||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 77132 | 77132 | 244320 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005500.9462 | 2110499.2518 | 37.775339752374 | -122.424450664906 | (37.775339752374, -122.424450664906) | |||
| 77745 | 77745 | 109408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 185 BELGRAVE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 5997621.5 | 2104846.8 | 37.759371453278206 | -122.45129961243099 | (37.7593714532782, -122.451299612431) | ||
| 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) | ||
| 83985 | 83985 | 115105 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 92723 | 92723 | 107754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||||
| 94182 | 94182 | 117166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 96725 | 96725 | 109157 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2016 12:00:00 AM | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | |||
| 97850 | 97850 | 97824 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6002402.0 | 2104748.0 | 37.7593727378271 | -122.434759263601 | (37.7593727378271, -122.434759263601) | |||
| 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) | ||
| 107925 | 107925 | 119597 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005470.0 | 2110737.0 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | ||||
| 108079 | 108079 | 119843 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 109355 | 109355 | 119876 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 450X Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 110660 | 110660 | 99280 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001309.9 | 2109637.7 | 37.7727365843062 | -122.43888668006001 | (37.7727365843062, -122.43888668006) | |||||
| 112419 | 112419 | 110545 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2x LILY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6006369.0 | 2110405.0 | 37.775129941044604 | -122.421441165405 | (37.7751299410446, -122.421441165405) | ||||
| 112492 | 112492 | 119852 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 112820 | 112820 | 121653 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993098.0 | 2103247.0 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | ||||
| 115038 | 115038 | 116014 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 469 PACHECO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 5993702.0 | 2101802.0 | 37.7507860118971 | -122.464633955158 | (37.7507860118971, -122.464633955158) | ||||
| 118168 | 118168 | 135902 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | ||||
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 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) | ||
| 127506 | 127506 | 119859 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 131720 | 131720 | 238018 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) | |||
| 132824 | 132824 | 237988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005544.33972 | 2096386.4343299998 | 37.736591695453896 | -122.42329710838001 | (37.7365916954539, -122.42329710838) | |||
| 136440 | 136440 | 247321 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 216 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002799.395 | 2109324.8498 | 37.771962206126794 | -122.433711993285 | (37.7719622061268, -122.433711993285) | |||
| 137794 | 137794 | 142584 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.803972458794796 | -122.41319130359699 | (37.8039724587948, -122.413191303597) | |||
| 140278 | 140278 | 116700 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1X CARRIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002805.0 | 2095529.0 | 37.734082395521895 | -122.43270694044399 | (37.7340823955219, -122.432706940444) | ||||
| 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) | |||
| 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) | ||
| 143597 | 143597 | 119811 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 147197 | 147197 | 139395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 486 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005025.4278 | 2111110.8954 | 37.7769923120329 | -122.426139147688 | (37.7769923120329, -122.426139147688) | |||
| 149261 | 149261 | 142760 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | |||
| 150387 | 150387 | 196421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010097.257019999 | 2110794.49543 | 37.776408907491 | -122.408571719809 | (37.776408907491, -122.408571719809) | |||
| 151338 | 151338 | 182066 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988020.5944 | 2105839.0631 | 37.761541526107 | -122.48457660662399 | (37.761541526107, -122.484576606624) | |||
| 153974 | 153974 | 214453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994424.22111 | 2100746.43892 | 37.7479293180792 | -122.462059929142 | (37.7479293180792, -122.462059929142) | |||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 155982 | 155982 | 245875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001285.051 | 2109638.8769 | 37.772738401980604 | -122.438972719673 | (37.7727384019806, -122.438972719673) | |||
| 156919 | 156919 | 196387 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013895.88765 | 2112864.3036700003 | 37.782304139751794 | -122.39557613855301 | (37.7823041397518, -122.395576138553) | |||
| 157201 | 157201 | 139388 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.9106 | 2110887.2787 | 37.776408001399496 | -122.42430543018601 | (37.7764080013995, -122.424305430186) | |||
| 157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
| 158937 | 158937 | 214443 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991170.54389 | 2101147.50148 | 37.7488426659675 | -122.473340138153 | (37.7488426659675, -122.473340138153) | |||
| 160478 | 160478 | 138981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 431 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005467.783 | 2110751.9814 | 37.7760318136474 | -122.42458336578999 | (37.7760318136474, -122.42458336579) | |||
| 161927 | 161927 | 214476 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998285.21453 | 2093571.32939 | 37.7284497264529 | -122.448192264458 | (37.7284497264529, -122.448192264458) | ||||
| 162852 | 162852 | 140802 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 JORDAN AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5996233.7192 | 2113991.8267 | 37.7844017542187 | -122.45676060516199 | (37.7844017542187, -122.456760605162) | |||
| 165001 | 165001 | 139978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | |||
| 171955 | 171955 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6003967.5577300005 | 2094330.4049099998 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | ||||
| 172215 | 172215 | 135896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6006986.1238400005 | 2115548.09953 | 37.7892864176805 | -122.419671386337 | (37.7892864176805, -122.419671386337) | |||
| 173783 | 173783 | 214446 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 500 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993157.34712 | 2099454.9185599997 | 37.744310110719205 | -122.46634683724 | (37.7443101107192, -122.46634683724) | |||
| 177156 | 177156 | 196391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | |||
| 177236 | 177236 | 178894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000524.98993 | 2088394.3572900002 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | |||
| 178587 | 178587 | 183559 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1616 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987905.5766 | 2097633.8663 | 37.7390055533414 | -122.484372584152 | (37.7390055533414, -122.484372584152) | |||
| 179102 | 179102 | 196398 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011290.67787 | 2111282.0901599997 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | |||
| 179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
| 184353 | 184353 | 196416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010037.74833 | 2110859.1244200002 | 37.776583030628295 | -122.408782138683 | (37.7765830306283, -122.408782138683) | |||
| 184862 | 184862 | 196379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | |||
| 187913 | 187913 | 196376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012181.9653199995 | 2112407.5214 | 37.780954438148704 | -122.40147347253999 | (37.7809544381487, -122.40147347254) |
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");