Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
136903 | 136903 | 181233 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6011973.9880099995 | 2087758.6255 | 37.7132622770132 | -122.400461065249 | (37.7132622770132, -122.400461065249) | |||
45676 | 45676 | 181228 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6012082.02881 | 2087884.13753 | 37.7136129325747 | -122.400096445907 | (37.7136129325747, -122.400096445907) | |||
36034 | 36034 | 187450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5098 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000319.4478 | 2089309.2863 | 37.7168632117114 | -122.440854224757 | (37.7168632117114, -122.440854224757) | |||
137927 | 137927 | 187461 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4900 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000966.6486 | 2090329.2095 | 37.719700529984706 | -122.438690214146 | (37.7197005299847, -122.438690214146) | |||
137624 | 137624 | 217466 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 380 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5992234.1227 | 2090402.1103 | 37.7194000456453 | -122.46888047296801 | (37.7194000456453, -122.468880472968) | |||
130918 | 130918 | 217435 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 4ft | 5997833.6645599995 | 2094705.98375 | 37.7315393941237 | -122.449835025492 | (37.7315393941237, -122.449835025492) | |||
175583 | 175583 | 217479 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 158 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6001063.19964 | 2095410.8280900002 | 37.7336589855795 | -122.43872040954099 | (37.7336589855795, -122.438720409541) | |||
25192 | 25192 | 203195 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012994.723999999 | 2096005.499 | 37.735963390387 | -122.39751105148999 | (37.735963390387, -122.39751105149) | ||||
174501 | 174501 | 217477 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994377.24851 | 2101823.40778 | 37.750883697139 | -122.462300455497 | (37.750883697139, -122.462300455497) | |||
29817 | 29817 | 245984 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2755 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007074.8359 | 2102333.0826 | 37.7530061148801 | -122.418427042538 | (37.7530061148801, -122.418427042538) | |||
25608 | 25608 | 246285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6006870.1021 | 2106021.3241 | 37.763121645518204 | -122.419396683437 | (37.7631216455182, -122.419396683437) | |||
40665 | 40665 | 244841 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006736.38106 | 2107369.27612 | 37.766815272626296 | -122.41995484006901 | (37.7668152726263, -122.419954840069) | |||
156768 | 156768 | 244838 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006733.9569 | 2107435.91089 | 37.7669980994089 | -122.41996795397101 | (37.7669980994089, -122.419967953971) | |||
44421 | 44421 | 199463 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015595.21944 | 2107438.50948 | 37.7675004876899 | -122.38931814851999 | (37.7675004876899, -122.38931814852) | |||
23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
23753 | 23753 | 199483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.38972250619801 | (37.7716855044225, -122.389722506198) | |||
167263 | 167263 | 199478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015495.305819999 | 2109230.7911799997 | 37.7724161604052 | -122.38978894091801 | (37.7724161604052, -122.389788940918) | |||
27658 | 27658 | 246312 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1601 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007098.251 | 2109393.5574 | 37.7723938509682 | -122.418846769596 | (37.7723938509682, -122.418846769596) | |||
132921 | 132921 | 199473 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | |||
1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
156933 | 156933 | 62745 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 121 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1986 12:00:00 AM | 13 | Permit Number 23093 | 6009715.48574 | 2111589.25493 | 37.7785697418509 | -122.409948497336 | (37.7785697418509, -122.409948497336) |
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");