Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18711 | 18711 | 10945 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1400X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016738.0241541 | 2096692.2434200002 | 37.738056771556394 | -122.384616664641 | (37.7380567715564, -122.384616664641) | ||
| 80081 | 80081 | 10889 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 1270X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 85341 | 85341 | 34028 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51549 | 6008501.61322181 | 2106845.55424255 | 37.7654765469809 | -122.413812123028 | (37.7654765469809, -122.413812123028) | ||
| 86405 | 86405 | 29569 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1175X Hudson Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2006 12:00:00 AM | 3 | 3x3 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 89322 | 89322 | 34026 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 2730 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51549 | 6008501.61322181 | 2106845.55424255 | 37.7654765469809 | -122.413812123028 | (37.7654765469809, -122.413812123028) | ||
| 90469 | 90469 | 95798 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 1106 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767540 | 6008629.6 | 2102091.1 | 37.752429086748705 | -122.413033242012 | (37.7524290867487, -122.413033242012) | |
| 92751 | 92751 | 10873 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1175X Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 93122 | 93122 | 10957 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1425X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016592.1339091 | 2096738.5714058997 | 37.7381759097054 | -122.385124311518 | (37.7381759097054, -122.385124311518) | ||
| 93316 | 93316 | 94575 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 3889 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53753 | 6004405.0 | 2104227.0 | 37.758055708680104 | -122.42779478633301 | (37.7580557086801, -122.427794786333) |
| 96214 | 96214 | 10796 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1139X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6017446.51401 | 2094936.4610099997 | 37.7332748977764 | -122.382044937386 | (37.7332748977764, -122.382044937386) | ||
| 97234 | 97234 | 95796 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 330 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767538 | 6006154.0 | 2101094.4 | 37.7495530959347 | -122.42152351035101 | (37.7495530959347, -122.421523510351) | |
| 104193 | 104193 | 41305 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 1387 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | Permit Number 41977 | 6006476.01966821 | 2101521.23564445 | 37.7507432410359 | -122.420440247305 | (37.7507432410359, -122.420440247305) | ||
| 104575 | 104575 | 96166 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 166 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767797 | 6005546.8 | 2096117.3 | 37.7358528516077 | -122.423269476417 | (37.7358528516077, -122.423269476417) | |
| 110469 | 110469 | 67677 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 1511 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2006 12:00:00 AM | Permit Number 31281 | 6016146.799714901 | 2097069.00450631 | 37.739058567252606 | -122.386687105419 | (37.7390585672526, -122.386687105419) | ||
| 112892 | 112892 | 10890 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 1270X Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 115014 | 115014 | 26892 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1591 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6015737.794696599 | 2097374.5847744 | 37.73987497603861 | -122.388122590187 | (37.7398749760386, -122.388122590187) | ||
| 119564 | 119564 | 96576 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 401x Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | ||||
| 129404 | 129404 | 95795 | Permitted Site 1 | Quercus coccinea :: Scarlet Oak 308 | 330 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767538 | 6006154.0 | 2101094.4 | 37.7495530959347 | -122.42152351035101 | (37.7495530959347, -122.421523510351) | |
| 139346 | 139346 | 10853 | DPW Maintained 3 | Quercus coccinea :: Scarlet Oak 308 | 1299X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) |
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");