Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44937 | 44937 | 222679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | |||
52605 | 52605 | 204713 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5991184.777919999 | 2105315.94504 | 37.7602889411076 | -122.473594943052 | (37.7602889411076, -122.473594943052) | |||
56499 | 56499 | 222681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2318 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6011232.98207 | 2103716.09635 | 37.7570367677534 | -122.404144621787 | (37.7570367677534, -122.404144621787) | ||||
63474 | 63474 | 175799 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1500 San Jose Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6001536.44317 | 2094235.33238 | 37.7304582561421 | -122.43700014314 | (37.7304582561421, -122.43700014314) | |||
69867 | 69867 | 222678 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6005045.75661 | 2104048.66592 | 37.7576022713581 | -122.425566082603 | (37.7576022713581, -122.425566082603) | |||
115834 | 115834 | 246707 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1 Bonview St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6007720.78655 | 2099148.69396 | 37.744298842209 | -122.415967729029 | (37.744298842209, -122.415967729029) | ||||
128258 | 128258 | 204719 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 110 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993903.71897 | 2099982.29966 | 37.7458012037543 | -122.46380433331001 | (37.7458012037543, -122.46380433331) | |||
129702 | 129702 | 204734 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994953.56479 | 2099867.13318 | 37.7455454275919 | -122.460165799529 | (37.7455454275919, -122.460165799529) | |||
130324 | 130324 | 123045 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 568 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991929.81513 | 2111594.03006 | 37.777569997766705 | -122.47147570428301 | (37.7775699977667, -122.471475704283) | |||
171726 | 171726 | 204714 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991182.79274 | 2105342.1880099997 | 37.7603608823676 | -122.473603723127 | (37.7603608823676, -122.473603723127) | |||
178842 | 178842 | 204733 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 80 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994927.12974 | 2099849.55804 | 37.745495650106605 | -122.460255934077 | (37.7454956501066, -122.460255934077) | |||
179565 | 179565 | 222694 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 427 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6003122.71421 | 2099186.4838799997 | 37.7441430185014 | -122.431869572034 | (37.7441430185014, -122.431869572034) |
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");