Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, qCaretaker
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1296 | 1296 | 231177 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6008330.40398 | 2100615.02413 | 37.7483593136265 | -122.41396350442 | (37.7483593136265, -122.41396350442) | |||
1308 | 1308 | 231174 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3092 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6009165.99895 | 2100621.73745 | 37.7484246412851 | -122.411074499805 | (37.7484246412851, -122.411074499805) | |||
4743 | 4743 | 148019 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 605 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:12:00 PM | 3 | Width 3ft | 6002175.19846 | 2088993.45658 | 37.7161015284444 | -122.43441724168301 | (37.7161015284444, -122.434417241683) | |
23399 | 23399 | 248028 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 415 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010000.45294 | 2098632.85848 | 37.7430103745335 | -122.408048720871 | (37.7430103745335, -122.408048720871) | |||
27036 | 27036 | 231200 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3399 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007140.13481 | 2100524.8991799997 | 37.7480449295337 | -122.418073048237 | (37.7480449295337, -122.418073048237) | |||
27980 | 27980 | 192754 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1195 Fairfax Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017744.167219999 | 2096569.5580900002 | 37.7377754928445 | -122.381129364447 | (37.7377754928445, -122.381129364447) | |||
28778 | 28778 | 231191 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3415 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006945.26425 | 2100523.93824 | 37.7480313210083 | -122.418746836492 | (37.7480313210083, -122.418746836492) | |||
32437 | 32437 | 231199 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3636 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005923.7545 | 2100590.88969 | 37.7481575867153 | -122.422283938475 | (37.7481575867153, -122.422283938475) | |||
42934 | 42934 | 192765 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1101 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017733.36726 | 2096290.7725799999 | 37.7370094071445 | -122.381147327493 | (37.7370094071445, -122.381147327493) | |||
46523 | 46523 | 192762 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1151 Fairfax Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017784.77544 | 2096401.4066 | 37.7373160238005 | -122.380977273785 | (37.7373160238005, -122.380977273785) | |||
54248 | 54248 | 130425 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012127.88855 | 2118699.30676 | 37.7982271771027 | -122.402103014136 | (37.7982271771027, -122.402103014136) | |||
61814 | 61814 | 192768 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1101 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017764.14104 | 2096144.7820599999 | 37.736610244861005 | -122.381030780757 | (37.736610244861, -122.381030780757) | |||
67276 | 67276 | 192760 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1151 Fairfax Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017794.54346 | 2096459.61932 | 37.7374764035002 | -122.38094754671002 | (37.7374764035002, -122.38094754671) | |||
69231 | 69231 | 192786 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1190 Fairfax Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017834.847490001 | 2096507.59848 | 37.737610369220704 | -122.380811529649 | (37.7376103692207, -122.380811529649) | |||
70120 | 70120 | 231143 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2857 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010376.44019 | 2100661.4980599997 | 37.7486016206723 | -122.406891600982 | (37.7486016206723, -122.406891600982) | |||
72915 | 72915 | 208528 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2574 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991762.28899 | 2097924.21103 | 37.7400265849559 | -122.471059114781 | (37.7400265849559, -122.471059114781) | |||
73243 | 73243 | 192759 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1151 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017794.14245 | 2096468.18892 | 37.7374999117835 | -122.380949528801 | (37.7374999117835, -122.380949528801) | |||
73257 | 73257 | 192778 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1190 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017805.41834 | 2096342.2173900001 | 37.7371546413706 | -122.380901787387 | (37.7371546413706, -122.380901787387) | |||
76446 | 76446 | 231198 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3636 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005940.89889 | 2100590.84766 | 37.748158438366794 | -122.42222465067199 | (37.7481584383668, -122.422224650672) | |||
130082 | 130082 | 130424 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012129.23244 | 2118685.48448 | 37.7981892994573 | -122.40209739158999 | (37.7981892994573, -122.40209739159) | |||
151153 | 151153 | 130426 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012124.42235 | 2118721.37553 | 37.7982875791671 | -122.40211656062401 | (37.7982875791671, -122.402116560624) | |||
151393 | 151393 | 192769 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1101 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017765.0269 | 2096131.82631 | 37.736574719840796 | -122.38102681746 | (37.7365747198408, -122.38102681746) | |||
153238 | 153238 | 231179 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3298 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007865.21134 | 2100614.7853099997 | 37.7483325201375 | -122.415572117257 | (37.7483325201375, -122.415572117257) | |||
154870 | 154870 | 192764 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1151 Fairfax Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017749.0379099995 | 2096343.9059099997 | 37.737156165722105 | -122.38109683956499 | (37.7371561657221, -122.381096839565) | |||
158241 | 158241 | 248029 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 415 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010002.39099 | 2098647.04811 | 37.7430494446815 | -122.40804302006599 | (37.7430494446815, -122.408043020066) | |||
161142 | 161142 | 192761 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1151 Fairfax Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017790.5398699995 | 2096422.0287099998 | 37.7373729661834 | -122.380958776542 | (37.7373729661834, -122.380958776542) | |||
161321 | 161321 | 192771 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1101 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017777.64619 | 2096075.2558099998 | 37.7364200850155 | -122.38097925499201 | (37.7364200850155, -122.380979254992) | |||
162214 | 162214 | 229202 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 409 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002413.31573 | 2101482.56842 | 37.7504072857819 | -122.434486649535 | (37.7504072857819, -122.434486649535) | |||
162712 | 162712 | 192746 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 599 Keith St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017608.70475 | 2096636.8224 | 37.737952708754705 | -122.381602405133 | (37.7379527087547, -122.381602405133) | |||
172199 | 172199 | 231148 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3183 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008529.37485 | 2100533.17504 | 37.7481457471424 | -122.41326967835899 | (37.7481457471424, -122.413269678359) | |||
172988 | 172988 | 231150 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3125 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008959.306369999 | 2100530.99521 | 37.748163890068895 | -122.411782830119 | (37.7481638900689, -122.411782830119) |
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");