Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26065 | 26065 | 129543 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 508 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010622.60945 | 2115940.55933 | 37.7905681917229 | -122.407117191424 | (37.7905681917229, -122.407117191424) | |||
33785 | 33785 | 129500 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2144 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002804.8844800005 | 2118207.36125 | 37.7963516481611 | -122.434328161126 | (37.7963516481611, -122.434328161126) | |||
42762 | 42762 | 226645 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3626 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6005580.70423 | 2101999.04422 | 37.752004698476206 | -122.42357029633301 | (37.7520046984762, -122.423570296333) | |||
52191 | 52191 | 177033 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 681 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008991.36209 | 2090994.1931599998 | 37.7219796888926 | -122.410998479192 | (37.7219796888926, -122.410998479192) | |||
70389 | 70389 | 129503 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2656 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000257.59997 | 2118546.4747099997 | 37.797137849879896 | -122.44316664242099 | (37.7971378498799, -122.443166642421) | |||
134630 | 134630 | 226651 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1210 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997784.115230001 | 2106211.6118400004 | 37.7631281925414 | -122.450835621062 | (37.7631281925414, -122.450835621062) | |||
169044 | 169044 | 129539 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010703.940330001 | 2115907.6638700003 | 37.7904824197785 | -122.406833470599 | (37.7904824197785, -122.406833470599) | |||
170738 | 170738 | 249913 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 356 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011242.070719999 | 2120420.51237 | 37.802903706599295 | -122.40528949653601 | (37.8029037065993, -122.405289496536) | |||
170844 | 170844 | 129512 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3223 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002763.64169 | 2119722.26517 | 37.8005088389808 | -122.43457924465 | (37.8005088389808, -122.43457924465) | |||
173094 | 173094 | 191419 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 574 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011201.13816 | 2105680.19927 | 37.762427976796296 | -122.404392995652 | (37.7624279767963, -122.404392995652) |
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");