Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1872 | 1872 | 177039 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 178 Seville St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001177.23506 | 2087434.66895 | 37.711764745717 | -122.437755094333 | (37.711764745717, -122.437755094333) | |||
| 34739 | 34739 | 129549 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.78954630017979 | -122.40205298038401 | (37.7895463001798, -122.402052980384) | |||
| 34865 | 34865 | 129550 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012076.26306 | 2115552.15036 | 37.7895829547447 | -122.40206028827 | (37.7895829547447, -122.40206028827) | |||
| 43164 | 43164 | 53852 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 566 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 7 | Permit Number 9560 | 6010756.69045 | 2115915.59968 | 37.7905071610361 | -122.406651517078 | (37.7905071610361, -122.406651517078) | ||
| 52039 | 52039 | 226655 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 232 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999888.11878 | 2105582.8714799997 | 37.761522046538204 | -122.44351343721901 | (37.7615220465382, -122.443513437219) | |||
| 53054 | 53054 | 129531 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 84 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008275.2008 | 2119135.29153 | 37.7992084921309 | -122.415465384822 | (37.7992084921309, -122.415465384822) | ||||
| 54940 | 54940 | 55616 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 407 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1973 12:00:00 AM | 7 | Permit Number 11594 | 5998117.038919999 | 2115073.6250299998 | 37.787480044827596 | -122.450323009314 | (37.7874800448276, -122.450323009314) | ||
| 56461 | 56461 | 120189 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 224 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5987764.6245099995 | 2114428.11322 | 37.785109748738996 | -122.486092406972 | (37.785109748739, -122.486092406972) | |||
| 59980 | 59980 | 129511 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3223 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002767.09508 | 2119707.46883 | 37.8004684081385 | -122.43456623596799 | (37.8004684081385, -122.434566235968) | |||
| 64936 | 64936 | 129534 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 580 North Point St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6007527.54685 | 2121657.26711 | 37.8060911485403 | -122.41823143323099 | (37.8060911485403, -122.418231433231) | |||
| 75729 | 75729 | 129524 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1109 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006507.139280001 | 2120407.78108 | 37.802602889666794 | -122.421673924708 | (37.8026028896668, -122.421673924708) | |||
| 130118 | 130118 | 121971 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 106 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991185.189040001 | 2114684.00966 | 37.7860111230721 | -122.474277122949 | (37.7860111230721, -122.474277122949) | |||
| 163369 | 163369 | 129540 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010689.62141 | 2115905.1759099998 | 37.7904747872294 | -122.406882837979 | (37.7904747872294, -122.406882837979) | |||
| 169559 | 169559 | 191421 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 785 Rhode Island St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6011879.919919999 | 2104709.23521 | 37.7597998340098 | -122.40197706591002 | (37.7597998340098, -122.40197706591) | |||
| 186716 | 186716 | 129538 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010716.07014 | 2115909.27019 | 37.7904875090489 | -122.406791615267 | (37.7904875090489, -122.406791615267) |
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");