Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25122 | 25122 | 206533 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.45831551006201 | (37.7288857636427, -122.458315510062) | |||
25180 | 25180 | 126376 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 122 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001336.2876 | 2121154.5777 | 37.8043604581295 | -122.43962119477399 | (37.8043604581295, -122.439621194774) | |||
32853 | 32853 | 206501 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993462.44278 | 2104571.8221299998 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | |||
33049 | 33049 | 206535 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | |||
35567 | 35567 | 206696 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000774.6257 | 2094855.9884099998 | 37.7321191034008 | -122.439678327791 | (37.7321191034008, -122.439678327791) | |||
36423 | 36423 | 206512 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.47424148188401 | (37.7579850830548, -122.474241481884) | |||
50270 | 50270 | 206508 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | |||
53148 | 53148 | 206498 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | |||
55765 | 55765 | 206510 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.757981610781606 | -122.474340288587 | (37.7579816107816, -122.474340288587) | |||
73447 | 73447 | 206502 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | |||
73810 | 73810 | 223029 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997728.707169999 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | |||
75402 | 75402 | 206548 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993741.1056699995 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | |||
76521 | 76521 | 223030 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.759506423000204 | -122.450164233094 | (37.7595064230002, -122.450164233094) | |||
77159 | 77159 | 176073 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155267999 | (37.7169766182659, -122.43531155268) | |||
119103 | 119103 | 206513 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | |||
126746 | 126746 | 206518 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | |||
153105 | 153105 | 206509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.75798161076639 | -122.47438420248501 | (37.7579816107664, -122.474384202485) | |||
155564 | 155564 | 223055 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | |||
157581 | 157581 | 206499 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993488.07663 | 2104571.6485200003 | 37.7583784177465 | -122.46557490416001 | (37.7583784177465, -122.46557490416) | |||
160435 | 160435 | 206511 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.757983346478795 | -122.474289787164 | (37.7579833464788, -122.474289787164) | |||
171652 | 171652 | 206516 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991047.261080001 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | |||
171923 | 171923 | 206534 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.45831259717501 | (37.7288535085691, -122.458312597175) | |||
171944 | 171944 | 206514 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.47415145883801 | (37.7579954981234, -122.474151458838) | |||
174299 | 174299 | 126377 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 122 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001345.97363 | 2121147.25207 | 37.8043408951819 | -122.439587150049 | (37.8043408951819, -122.439587150049) | |||
176247 | 176247 | 206515 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.47405704351601 | (37.7579963659675, -122.474057043516) | |||
181904 | 181904 | 206517 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991060.290580001 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | |||
185239 | 185239 | 206500 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993474.546519999 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | |||
185534 | 185534 | 176074 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) |
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");