Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1791 | 1791 | 251711 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 25675 | 25675 | 240946 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004126.6518 | 2097259.6464 | 37.7389092249709 | -122.42826087863199 | (37.7389092249709, -122.428260878632) | |||
| 42363 | 42363 | 240915 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 315 Lexington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006533.583380001 | 2104305.2413 | 37.7583907231708 | -122.420438775123 | (37.7583907231708, -122.420438775123) | |||
| 48334 | 48334 | 197414 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1110 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014981.739440001 | 2109803.00942 | 37.7739588520651 | -122.391605444662 | (37.7739588520651, -122.391605444662) | |||
| 48402 | 48402 | 240890 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008720.4908300005 | 2101064.55739 | 37.749615532544 | -122.412646362752 | (37.749615532544, -122.412646362752) | |||
| 63145 | 63145 | 197385 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015094.6551 | 2108827.79856 | 37.7712874060154 | -122.391146668097 | (37.7712874060154, -122.391146668097) | |||
| 63712 | 63712 | 197401 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015056.142469999 | 2109498.92263 | 37.7731280268706 | -122.391326808588 | (37.7731280268706, -122.391326808588) | |||
| 66327 | 66327 | 240908 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 725 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009319.31515 | 2104845.25039 | 37.76003005686479 | -122.410842580843 | (37.7600300568648, -122.410842580843) | |||
| 71098 | 71098 | 240926 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009479.18585 | 2101981.64475 | 37.752176202776 | -122.410087494765 | (37.752176202776, -122.410087494765) | |||
| 72200 | 72200 | 197422 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015001.02116 | 2109469.2789 | 37.7730435724386 | -122.39151540903099 | (37.7730435724386, -122.391515409031) | |||
| 72493 | 72493 | 197408 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015042.21783 | 2109774.95767 | 37.773885184987996 | -122.391394276636 | (37.773885184988, -122.391394276636) | |||
| 103276 | 103276 | 94983 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54004 | 6008557.0 | 2113884.0 | 37.784805566420005 | -122.414118544888 | (37.78480556642, -122.414118544888) | ||
| 126401 | 126401 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
| 129742 | 129742 | 240935 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2500 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001976.89611 | 2105831.81092 | 37.7623244756286 | -122.43630704373001 | (37.7623244756286, -122.43630704373) | |||
| 133157 | 133157 | 240928 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3380 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007637.32467 | 2104441.25017 | 37.75882630980679 | -122.416631173298 | (37.7588263098068, -122.416631173298) | |||
| 134173 | 134173 | 38980 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 300x San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2001 12:00:00 AM | 6 | 3x3 | Permit Number 40762 | 6010859.20416 | 2106814.33172 | 37.765522934268205 | -122.40565551069099 | (37.7655229342682, -122.405655510691) |
| 134685 | 134685 | 197394 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1255 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015074.87374 | 2109163.38918 | 37.7722077659022 | -122.391238555416 | (37.7722077659022, -122.391238555416) | |||
| 134957 | 134957 | 197436 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015031.80159 | 2108941.72055 | 37.7715967224486 | -122.391372048095 | (37.7715967224486, -122.391372048095) | |||
| 163397 | 163397 | 240513 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009217.99202 | 2106783.58967 | 37.765346611393205 | -122.411329944146 | (37.7653466113932, -122.411329944146) | |||
| 163979 | 163979 | 36875 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000811.564809999 | 2116611.03172 | 37.791855202492705 | -122.44111086330099 | (37.7918552024927, -122.441110863301) | |
| 168717 | 168717 | 197444 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013653.6839 | 2108052.2415 | 37.7690778293104 | -122.396076725459 | (37.7690778293104, -122.396076725459) | |||
| 177644 | 177644 | 96393 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 800 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767136 | 6015446.34816 | 2105205.82612 | 37.761361768441205 | -122.389677121926 | (37.7613617684412, -122.389677121926) |
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");