Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26151 | 26151 | 197034 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1777 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6013492.1426 | 2093105.4939599999 | 37.728028255576504 | -122.395588146293 | (37.7280282555765, -122.395588146293) | |||
27893 | 27893 | 217747 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 625 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5996570.53056 | 2107292.29818 | 37.7660259340648 | -122.455111074526 | (37.7660259340648, -122.455111074526) | |||
29865 | 29865 | 197031 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1950 Donner Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011564.47329 | 2093570.84173 | 37.729198590121 | -122.40228490112301 | (37.729198590121, -122.402284901123) | |||
33973 | 33973 | 239178 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 370 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006302.56864 | 2107899.15692 | 37.7682457495759 | -122.421492964039 | (37.7682457495759, -122.421492964039) | |||
38302 | 38302 | 239222 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2830 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010232.06115 | 2101082.77231 | 37.749750267174 | -122.407420559713 | (37.749750267174, -122.407420559713) | |||
38308 | 38308 | 197032 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2425 Mendell St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6013410.89228 | 2092904.9423599998 | 37.727473061829706 | -122.395854985916 | (37.7274730618297, -122.395854985916) | |||
46484 | 46484 | 239176 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1748 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005773.30835 | 2107281.9684900003 | 37.7665212410869 | -122.42327974697201 | (37.7665212410869, -122.423279746972) | |||
50307 | 50307 | 239175 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1742 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005792.615730001 | 2107282.2581599997 | 37.7665231260736 | -122.42321298670099 | (37.7665231260736, -122.423212986701) | |||
53022 | 53022 | 239177 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1778 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005631.82803 | 2107273.89376 | 37.7664910841327 | -122.42376852849199 | (37.7664910841327, -122.423768528492) | |||
53477 | 53477 | 239185 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 483 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007463.11739 | 2106828.6922 | 37.765371872436106 | -122.41740285818199 | (37.7653718724361, -122.417402858182) | |||
56551 | 56551 | 239228 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 819 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009935.7806 | 2104272.5292700003 | 37.7584920407792 | -122.408670110163 | (37.7584920407792, -122.408670110163) | |||
57531 | 57531 | 239159 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1400 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010593.731000001 | 2101386.95157 | 37.750605713091105 | -122.40619131239201 | (37.7506057130911, -122.406191312392) | |||
57803 | 57803 | 239223 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2850 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010195.06778 | 2101081.2894 | 37.749744124791896 | -122.407548380357 | (37.7497441247919, -122.407548380357) | |||
63559 | 63559 | 136188 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 3598 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002648.6286 | 2120880.08452 | 37.8036813773578 | -122.435060090577 | (37.8036813773578, -122.435060090577) | |||
63852 | 63852 | 239189 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005983.85034 | 2108958.2836700003 | 37.7711358828561 | -122.422670655046 | (37.7711358828561, -122.422670655046) | ||||
69212 | 69212 | 239226 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2851 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010136.754380001 | 2101030.89604 | 37.749602491463705 | -122.407746478521 | (37.7496024914637, -122.407746478521) | |||
101758 | 101758 | 116523 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2486 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5995798.0 | 2110374.0 | 37.7744431335528 | -122.458006125331 | (37.7744431335528, -122.458006125331) | |||
131578 | 131578 | 114201 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 310 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6012278.4302 | 2106502.4698 | 37.7647458912325 | -122.40072478603001 | (37.7647458912325, -122.40072478603) | |||
132976 | 132976 | 197029 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1601 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015115.28126 | 2096786.0121099998 | 37.738224366070106 | -122.390233889493 | (37.7382243660701, -122.390233889493) | |||
137308 | 137308 | 239142 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 N Off Ramp | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6005875.43102 | 2109171.08438 | 37.771714065081795 | -122.42306080971399 | (37.7717140650818, -122.423060809714) | |||
149452 | 149452 | 197024 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2 Waterloo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010624.95454 | 2097233.34103 | 37.7392025469594 | -122.405790793937 | (37.7392025469594, -122.405790793937) | |||
154336 | 154336 | 239174 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1714 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005940.64905 | 2107290.54233 | 37.7665542255162 | -122.422701553932 | (37.7665542255162, -122.422701553932) | |||
154682 | 154682 | 197033 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 2421 Mendell St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6013404.921569999 | 2092933.78448 | 37.7275519242636 | -122.395877647031 | (37.7275519242636, -122.395877647031) | |||
157838 | 157838 | 197037 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 176 Maddux Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012326.10159 | 2094826.6531599998 | 37.732689273593294 | -122.399740013104 | (37.7326892735933, -122.399740013104) | |||
158469 | 158469 | 197035 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1751 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6013551.1098 | 2093063.74117 | 37.7279168907351 | -122.39538136964799 | (37.7279168907351, -122.395381369648) | |||
163838 | 163838 | 239218 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 10ft | 6005833.18575 | 2109028.0269 | 37.771318879598105 | -122.423196768328 | (37.7713188795981, -122.423196768328) | |||
176100 | 176100 | 239229 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 391 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004228.5151 | 2106643.84143 | 37.764681793855 | -122.42857742022899 | (37.764681793855, -122.428577420229) |
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");