Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77716 | 77716 | 93966 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | |
97023 | 97023 | 93963 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
114071 | 114071 | 93964 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
114278 | 114278 | 93962 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
122080 | 122080 | 93965 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
128018 | 128018 | 93967 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
38378 | 38378 | 203183 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015658.44629 | 2106386.7571400004 | 37.7646161091615 | -122.38902601186001 | (37.7646161091615, -122.38902601186) | |||
40464 | 40464 | 199494 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010924.085580001 | 2111634.58421 | 37.7787618676114 | -122.405770660782 | (37.7787618676114, -122.405770660782) | |||
42499 | 42499 | 246350 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1917 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006813.4383 | 2107178.9472 | 37.7662970152725 | -122.419674805523 | (37.7662970152725, -122.419674805523) | |||
47352 | 47352 | 203175 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2338 Lane St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6013915.08418 | 2092868.40903 | 37.7274007851107 | -122.394109422506 | (37.7274007851107, -122.394109422506) | ||||
52123 | 52123 | 244847 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 6006653.79898 | 2103383.59728 | 37.7558668756582 | -122.41995761356002 | (37.7558668756582, -122.41995761356) | |||
61712 | 61712 | 203182 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015656.28581 | 2106435.78787 | 37.7647506171774 | -122.38903690803998 | (37.7647506171774, -122.38903690804) | |||
64107 | 64107 | 244844 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006630.92083 | 2103720.4372 | 37.7567904713264 | -122.420060637198 | (37.7567904713264, -122.420060637198) | |||
76881 | 76881 | 243925 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006679.07286 | 2103590.73607 | 37.7564370548525 | -122.41988490606501 | (37.7564370548525, -122.419884906065) | |||
133886 | 133886 | 244536 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2998 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006910.4744 | 2106757.6793 | 37.765145778241504 | -122.419309288071 | (37.7651457782415, -122.419309288071) | |||
134129 | 134129 | 244845 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6006641.10837 | 2103579.2022 | 37.756403246631606 | -122.42001538241999 | (37.7564032466316, -122.42001538242) | |||
135845 | 135845 | 243924 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006678.4863599995 | 2103600.0339099998 | 37.7564625515326 | -122.419887594147 | (37.7564625515326, -122.419887594147) | |||
143894 | 143894 | 104927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
148131 | 148131 | 244812 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 199 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005383.33309 | 2099017.5847400003 | 37.743807152283296 | -122.42404083244499 | (37.7438071522833, -122.424040832445) | |||
149340 | 149340 | 203180 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015618.5764 | 2107110.17004 | 37.7666002339304 | -122.38921442971399 | (37.7666002339304, -122.389214429714) | |||
156217 | 156217 | 181280 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6004524.91871 | 2092988.1896099998 | 37.727203289497794 | -122.42657977773999 | (37.7272032894978, -122.42657977774) | |||
156498 | 156498 | 245978 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2889 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007119.1949 | 2101563.056 | 37.7508942943071 | -122.418219050821 | (37.7508942943071, -122.418219050821) | |||
159285 | 159285 | 245977 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2853 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007107.4417 | 2101754.52 | 37.751419349330895 | -122.418273268019 | (37.7514193493309, -122.418273268019) | |||
162589 | 162589 | 246365 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1940 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006762.2381 | 2106995.3403 | 37.7657899896764 | -122.41983886795 | (37.7657899896764, -122.41983886795) | |||
168088 | 168088 | 244811 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 199 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005366.54273 | 2099017.13442 | 37.743804967825206 | -122.424098857596 | (37.7438049678252, -122.424098857596) | |||
177566 | 177566 | 203179 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015617.1468 | 2107140.95711 | 37.7666846892774 | -122.38922152448099 | (37.7666846892774, -122.389221524481) |
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");