Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23535 | 23535 | 207712 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 579 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997579.44084 | 2094367.86788 | 37.730596459453395 | -122.450689553205 | (37.7305964594534, -122.450689553205) | ||||
27037 | 27037 | 207730 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 740 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5998158.00142 | 2095945.9651099998 | 37.7349626400957 | -122.44880301654 | (37.7349626400957, -122.44880301654) | |||
34006 | 34006 | 207717 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1180 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5995974.63238 | 2091762.70234 | 37.723351307004705 | -122.456049310222 | (37.7233513070047, -122.456049310222) | |||
35482 | 35482 | 207723 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 301 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5991929.884269999 | 2090544.1507700002 | 37.719772472009204 | -122.469942439216 | (37.7197724720092, -122.469942439216) | |||
71579 | 71579 | 248210 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 69 Fair Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007064.668 | 2099422.3589 | 37.7450133544796 | -122.418255851634 | (37.7450133544796, -122.418255851634) | |||
72600 | 72600 | 187568 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 138 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6010896.54149 | 2088103.23155 | 37.714148350239704 | -122.40420934958401 | (37.7141483502397, -122.404209349584) | |||
75558 | 75558 | 191687 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 800 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6015123.17396 | 2105339.16037 | 37.7617099499859 | -122.390804173874 | (37.7617099499859, -122.390804173874) | |||
135662 | 135662 | 191707 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2187 Revere Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6011937.92175 | 2096699.9343299998 | 37.7378112633764 | -122.401213644004 | (37.7378112633764, -122.401213644004) | ||||
157462 | 157462 | 207708 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 916 Ortega St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 1ft | 5991151.901959999 | 2102512.9309 | 37.7525906994144 | -122.473504184373 | (37.7525906994144, -122.473504184373) | |||
161021 | 161021 | 207707 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1254 18th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5990519.642630001 | 2106849.6628099997 | 37.7644615768749 | -122.476007325895 | (37.7644615768749, -122.476007325895) | |||
167274 | 167274 | 126570 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 94 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008053.53116 | 2119101.30283 | 37.7991027057905 | -122.41623003160299 | (37.7991027057905, -122.416230031603) | ||||
169472 | 169472 | 207719 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 126 Brighton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5996251.42646 | 2090752.11635 | 37.7205923605284 | -122.455019501973 | (37.7205923605284, -122.455019501973) | |||
172414 | 172414 | 249620 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2400 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 7ft | 5997953.57215 | 2111367.44178 | 37.7772944806811 | -122.45062126495199 | (37.7772944806811, -122.450621264952) | |||
179929 | 179929 | 207728 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 3802 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5990564.76109 | 2090542.95021 | 37.7196901687566 | -122.47466105158199 | (37.7196901687566, -122.474661051582) |
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");