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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1177 | 1177 | 251471 | DPW Maintained 3 | Brugmansia spp :: Angel trumpet 137 | 2423 Market St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
12633 | 12633 | 1288 | DPW Maintained 3 | Brugmansia spp :: Angel trumpet 137 | 3958 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5992343.3701 | 2087389.3259 | 37.711133979215205 | -122.46828378898701 | (37.7111339792152, -122.468283788987) | |||
20782 | 20782 | 5368 | DPW Maintained 3 | Brugmansia spp :: Angel trumpet 137 | 254 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004803.994630001 | 2106877.36791 | 37.76535555244661 | -122.42660361788 | (37.7653555524466, -122.42660361788) | |||
24286 | 24286 | 249978 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 13 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6011650.66928 | 2120187.96882 | 37.8022880343123 | -122.403859153579 | (37.8022880343123, -122.403859153579) | |||
24993 | 24993 | 205648 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 146 Forest Hill Path | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994467.18853 | 2101084.43805 | 37.7488598520055 | -122.461935856854 | (37.7488598520055, -122.461935856854) | |||
29424 | 29424 | 175583 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 662 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6001642.89616 | 2093267.5366599998 | 37.727806960324 | -122.43656287568899 | (37.727806960324, -122.436562875689) | |||
31705 | 31705 | 249964 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 265 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011637.77879 | 2120097.34238 | 37.802038476045496 | -122.403897380163 | (37.8020384760455, -122.403897380163) | |||
36357 | 36357 | 188842 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1689 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6014873.05165 | 2097305.05057 | 37.739636100214895 | -122.391107675301 | (37.7396361002149, -122.391107675301) | |||
39398 | 39398 | 54018 | Permitted Site 1 | Brugmansia spp :: Angel trumpet 137 | 850 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 7 | Permit Number 9737 | 5985129.09281 | 2110070.9602900003 | 37.772992311936704 | -122.494889012959 | (37.7729923119367, -122.494889012959) | ||
39571 | 39571 | 175574 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 262 Taber Pl | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6009969.129269999 | 2086111.4112900002 | 37.708627351035794 | -122.407274531388 | (37.7086273510358, -122.407274531388) | |||
41718 | 41718 | 220739 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 112 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006641.651869999 | 2105417.60595 | 37.761451107091396 | -122.420143969269 | (37.7614511070914, -122.420143969269) | |||
43804 | 43804 | 175578 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 120 Farragut Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5997343.094880001 | 2087383.57073 | 37.7114056806055 | -122.451003186346 | (37.7114056806055, -122.451003186346) | |||
57354 | 57354 | 205640 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1215 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995031.70006 | 2092006.18046 | 37.7239656716754 | -122.459326452373 | (37.7239656716754, -122.459326452373) | |||
60638 | 60638 | 72777 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 545 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1998 12:00:00 AM | 2 | 6001963.48566 | 2090308.61683 | 37.7197006458587 | -122.43524303694099 | (37.7197006458587, -122.435243036941) | ||
61165 | 61165 | 205645 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 263 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991925.81935 | 2090233.9868299998 | 37.718920602690396 | -122.469933919041 | (37.7189206026904, -122.469933919041) | |||
62781 | 62781 | 249850 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6011479.212780001 | 2120408.00843 | 37.8028826291885 | -122.40446797753401 | (37.8028826291885, -122.404467977534) | |||
65085 | 65085 | 220745 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 846 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007942.06069 | 2102996.56552 | 37.7548766699288 | -122.415474972491 | (37.7548766699288, -122.415474972491) | |||
69587 | 69587 | 175572 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1785 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5997902.91361 | 2088443.5284099998 | 37.7143481157506 | -122.449144629432 | (37.7143481157506, -122.449144629432) | |||
71628 | 71628 | 220734 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 180 Elsie St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6006948.49697 | 2098161.8012099997 | 37.741545605554 | -122.418568179892 | (37.741545605554, -122.418568179892) | |||
72103 | 72103 | 205646 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 515 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5992711.01905 | 2090597.79132 | 37.7199648792589 | -122.467246253725 | (37.7199648792589, -122.467246253725) | |||
72397 | 72397 | 205644 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 273 Minerva St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5994319.24056 | 2089002.7011099998 | 37.7156778488284 | -122.461571642214 | (37.7156778488284, -122.461571642214) | ||||
74183 | 74183 | 220747 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 804 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007928.36679 | 2103202.3547 | 37.7554409504533 | -122.41553689892 | (37.7554409504533, -122.41553689892) | |||
134667 | 134667 | 220737 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 98 Crescent Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6005788.78972 | 2095836.9730000002 | 37.7350967901794 | -122.422412909327 | (37.7350967901794, -122.422412909327) | |||
136563 | 136563 | 220754 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002223.13887 | 2104142.86102 | 37.7577010159989 | -122.43533456543899 | (37.7577010159989, -122.435334565439) | |||
138164 | 138164 | 220752 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 3348 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007230.490259999 | 2105595.2598599996 | 37.7619720636839 | -122.41812001174299 | (37.7619720636839, -122.418120011743) | |||
152498 | 152498 | 220735 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1201 Vermont St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011463.995709999 | 2101889.5444900002 | 37.7520343634986 | -122.40321720042601 | (37.7520343634986, -122.403217200426) | |||
152623 | 152623 | 175580 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 151 Elliot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6008987.85777 | 2088562.90463 | 37.7153036804931 | -122.410838966457 | (37.7153036804931, -122.410838966457) | |||
157417 | 157417 | 175573 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 256 Taber Pl | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009978.06824 | 2086136.62452 | 37.7086970817661 | -122.40724541316901 | (37.7086970817661, -122.407245413169) | |||
164235 | 164235 | 220756 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 101 Alpine Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6001697.30135 | 2108238.12942 | 37.768915744503104 | -122.437446377774 | (37.7689157445031, -122.437446377774) | |||
169459 | 169459 | 249955 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011505.97031 | 2120064.83328 | 37.801941849301 | -122.404351213161 | (37.801941849301, -122.404351213161) | |||
172762 | 172762 | 65181 | Permitted Site 1 | Brugmansia spp :: Angel trumpet 137 | 1354 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | Permit Number 32892 | 6006547.3784 | 2118725.4243400004 | 37.7979858332305 | -122.42141513132 | (37.7979858332305, -122.42141513132) | |
175169 | 175169 | 249972 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 222 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011689.8424 | 2120121.99827 | 37.802109083637 | -122.403718950166 | (37.802109083637, -122.403718950166) | |||
176250 | 176250 | 205641 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1209 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5995031.09016 | 2091955.7206700002 | 37.7238270861355 | -122.459324908228 | (37.7238270861355, -122.459324908228) | |||
176591 | 176591 | 30748 | Permitted Site 1 | Brugmansia spp :: Angel trumpet 137 | 2 Ardenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 34631 | 5991297.28016 | 2096393.9158400001 | 37.7357978773698 | -122.47255536813 | (37.7357978773698, -122.47255536813) | |||
179356 | 179356 | 188841 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 998 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011857.52585 | 2103846.79049 | 37.7574305017281 | -122.401993886805 | (37.7574305017281, -122.401993886805) | |||
183508 | 183508 | 220760 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 66 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6001879.64589 | 2106238.56129 | 37.7634357867453 | -122.43667251202 | (37.7634357867453, -122.43667251202) | |||
184330 | 184330 | 125729 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 21 Golden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6008205.85765 | 2116548.7373200003 | 37.792102556547604 | -122.415522112249 | (37.7921025565476, -122.415522112249) | |||
185025 | 185025 | 113310 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 775 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010835.4889 | 2091114.0302900001 | 37.7224119768082 | -122.40463219374399 | (37.7224119768082, -122.404632193744) |
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");