Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4919 | 4919 | 253715 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 2959 21st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 12905 | 12905 | 19974 | DPW Maintained 3 | Pseudotsuga menziesii :: Douglas Fir 231 | 100 STAIRWAY45 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 32963 | 32963 | 54014 | Permitted Site 1 | Pseudotsuga menziesii :: Douglas Fir 231 | 827 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 5 | Permit Number 9733 | 5985075.0699 | 2110207.5990400002 | 37.7733643204852 | -122.495085959599 | (37.7733643204852, -122.495085959599) | ||
| 38588 | 38588 | 213735 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 796 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5994920.082140001 | 2093287.4258299998 | 37.727477244559395 | -122.459805058973 | (37.7274772445594, -122.459805058973) | |||
| 49395 | 49395 | 239032 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 216 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6003139.46623 | 2096400.72966 | 37.7364949292989 | -122.43161280209401 | (37.7364949292989, -122.431612802094) | ||||
| 57697 | 57697 | 213736 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 796 Faxon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 10ft | 5994920.91292 | 2093300.2751799999 | 37.7275125735434 | -122.459803117335 | (37.7275125735434, -122.459803117335) | |||
| 61259 | 61259 | 213738 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 369 Kensington Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 5994050.28786 | 2099129.1340799998 | 37.743467070939204 | -122.46323562633002 | (37.7434670709392, -122.46323562633) | |||
| 62406 | 62406 | 179179 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 976 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6005365.19598 | 2092163.67204 | 37.7249868131864 | -122.423616346115 | (37.7249868131864, -122.423616346115) | |||
| 63406 | 63406 | 213737 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 369 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5994037.02485 | 2099136.46348 | 37.743486431552206 | -122.463282017871 | (37.7434864315522, -122.463282017871) | |||
| 68443 | 68443 | 179178 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 976 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005358.471390001 | 2092159.7928099998 | 37.72497578208579 | -122.423639316619 | (37.7249757820858, -122.423639316619) | |||
| 69913 | 69913 | 136058 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 21 Golden Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008208.515430001 | 2116527.95866 | 37.792045652840294 | -122.41551144451401 | (37.7920456528403, -122.415511444514) | |||
| 74339 | 74339 | 91119 | Permitted Site 1 | Pseudotsuga menziesii :: Douglas Fir 231 | 215 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2009 12:00:00 AM | 21 | 3x3 | Permit Number 52008 | 6005656.43695 | 2092668.8268900001 | 37.7263902933611 | -122.42264543805099 | (37.7263902933611, -122.422645438051) | |
| 76076 | 76076 | 187376 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 2200 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985079.353999999 | 2100006.8087 | 37.745356039048296 | -122.49431908582599 | (37.7453560390483, -122.494319085826) | |||
| 77671 | 77671 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 231 | 276 Yerba Buena Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5995080.66446 | 2095640.15746 | 37.733946507354396 | -122.459420244296 | (37.7339465073544, -122.459420244296) | ||||
| 87679 | 87679 | 107117 | DPW Maintained 3 | Pseudotsuga menziesii :: Douglas Fir 231 | 300X LIBERTY ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6004270.1 | 2103982.4 | 37.757376462852704 | -122.42824389606199 | (37.7573764628527, -122.428243896062) | ||||
| 92199 | 92199 | 213739 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 2 Cranleigh Dr | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 5991374.70721 | 2095782.5759700001 | 37.7341237740781 | -122.472243125326 | (37.7341237740781, -122.472243125326) | |||
| 102208 | 102208 | 110843 | Property Tree 7 | Pseudotsuga menziesii :: Douglas Fir 231 | 2037 TURK BLVD | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) | |||||
| 109233 | 109233 | 104397 | Property Tree 7 | Pseudotsuga menziesii :: Douglas Fir 231 | 350 Collingwood St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002086.0 | 2103822.0 | 37.756812219827296 | -122.43578589078301 | (37.7568122198273, -122.435785890783) | |||||
| 116430 | 116430 | 179175 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 7 Still St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6003197.84966 | 2094653.8635900002 | 37.7317017415451 | -122.43128628975501 | (37.7317017415451, -122.431286289755) | ||||
| 129896 | 129896 | 213742 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 27 Gennessee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5997408.73172 | 2093713.8859700002 | 37.728791007485 | -122.45123257102101 | (37.728791007485, -122.451232571021) | |||
| 165497 | 165497 | 185792 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 1975 32nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5986293.4379 | 2101811.9436 | 37.7503834266815 | -122.490253802528 | (37.7503834266815, -122.490253802528) | |||
| 169994 | 169994 | 179174 | DPW Maintained 3 | Pseudotsuga menziesii :: Douglas Fir 231 | 12x Canyon Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003147.35342 | 2086364.11434 | 37.7089370622714 | -122.43086947554899 | (37.7089370622714, -122.430869475549) | |||
| 178164 | 178164 | 91118 | Permitted Site 1 | Pseudotsuga menziesii :: Douglas Fir 231 | 215 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2009 12:00:00 AM | 53 | 3x3 | Permit Number 52008 | 6005659.93455 | 2092656.02169 | 37.726355330411 | -122.422632437432 | (37.726355330411, -122.422632437432) | |
| 180801 | 180801 | 179176 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 166 Otsego Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6000550.04717 | 2092274.06845 | 37.7250169611399 | -122.44026965183399 | (37.7250169611399, -122.440269651834) | |||
| 182065 | 182065 | 213740 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 517 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 10ft | 5998026.25225 | 2095230.6317200002 | 37.7329909700415 | -122.449206999211 | (37.7329909700415, -122.449206999211) | |||
| 184179 | 184179 | 213741 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 517 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 5998035.51426 | 2095230.8036599997 | 37.732991971907396 | -122.449174990551 | (37.7329919719074, -122.449174990551) | |||
| 187150 | 187150 | 179177 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 339 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998184.66474 | 2089122.35364 | 37.7162281250991 | -122.448219641639 | (37.7162281250991, -122.448219641639) | |||
| 187225 | 187225 | 239031 | Undocumented 2 | Pseudotsuga menziesii :: Douglas Fir 231 | 216 Bemis St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | 6003136.63858 | 2096397.3424200001 | 37.7364854684375 | -122.43162233671801 | (37.7364854684375, -122.431622336718) |
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");