Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7017 | 7017 | 140266 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 59 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5997743.5871 | 2110318.4881 | 37.774402304363704 | -122.451271998235 | (37.7744023043637, -122.451271998235) | ||||
32134 | 32134 | 181715 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1230 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989574.6124 | 2106958.9518 | 37.764706813333795 | -122.47928388503401 | (37.7647068133338, -122.479283885034) | |||
49289 | 49289 | 181689 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1388 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986201.0625 | 2105790.5738 | 37.7613022595741 | -122.490865965424 | (37.7613022595741, -122.490865965424) | |||
71542 | 71542 | 182034 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1322 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989910.492000001 | 2106348.2383 | 37.7630494610028 | -122.478077525469 | (37.7630494610028, -122.478077525469) | |||
153318 | 153318 | 181688 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1390 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986203.626 | 2105763.6574 | 37.7612285043454 | -122.490855118834 | (37.7612285043454, -122.490855118834) | |||
187895 | 187895 | 140929 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 186 COLLINS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998139.9646 | 2113291.8858 | 37.7825891696903 | -122.450115219222 | (37.7825891696903, -122.450115219222) | |||
31637 | 31637 | 140695 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 47 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997734.2541 | 2110377.9427 | 37.7745650169292 | -122.45130857152 | (37.7745650169292, -122.45130857152) | |||
63897 | 63897 | 182928 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2639 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982729.5047 | 2097148.5736 | 37.737370314683204 | -122.50223286634501 | (37.7373703146832, -122.502232866345) | |||
71212 | 71212 | 183611 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1922 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986017.7787 | 2102119.0416 | 37.7512105314609 | -122.49122963690701 | (37.7512105314609, -122.491229636907) | |||
149475 | 149475 | 184486 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1835 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984093.5138 | 2102639.4673 | 37.7525268533295 | -122.497922277622 | (37.7525268533295, -122.497922277622) | |||
154002 | 154002 | 183927 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1595 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988608.557999999 | 2101004.688 | 37.748301852225204 | -122.48218891491501 | (37.7483018522252, -122.482188914915) | |||
1411 | 1411 | 183698 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1341 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983051.8246 | 2105805.0517 | 37.761157531744104 | -122.501758745065 | (37.7611575317441, -122.501758745065) | |||
4301 | 4301 | 139643 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1100 DIVISADERO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:46:00 AM | 3 | Width 0ft | 6001420.8793 | 2112266.7216 | 37.779961529168204 | -122.43869120897 | (37.7799615291682, -122.43869120897) | ||
4646 | 4646 | 160597 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 766 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:25:00 PM | 3 | Width 0ft | 6002414.55284 | 2089084.1537799998 | 37.716364146664205 | -122.433596398053 | (37.7163641466642, -122.433596398053) | |
4650 | 4650 | 160596 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 762 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:30:00 PM | 3 | Width 0ft | 6002428.15191 | 2089106.63112 | 37.71642663607071 | -122.43355099850599 | (37.7164266360707, -122.433550998506) | |
4744 | 4744 | 161281 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 587 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:04:00 PM | 3 | Width 0ft | 6002852.8609 | 2090206.41919 | 37.719470499446395 | -122.432161491969 | (37.7194704994464, -122.432161491969) | |
4749 | 4749 | 161284 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 567 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:30:00 PM | 3 | Width 0ft | 6002918.80865 | 2090311.02788 | 37.7197614706043 | -122.43194100068199 | (37.7197614706043, -122.431941000682) | |
4766 | 4766 | 161282 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 579 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:28:00 PM | 3 | Width 0ft | 6002876.7147 | 2090246.5176400002 | 37.7195819533337 | -122.432081900155 | (37.7195819533337, -122.432081900155) | |
4780 | 4780 | 161285 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 523 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 03:51:00 PM | 3 | Width 0ft | 6003073.26111 | 2090557.89007 | 37.7204480544147 | -122.431424726881 | (37.7204480544147, -122.431424726881) | ||
4828 | 4828 | 161283 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 571 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:40:00 PM | 3 | Width 0ft | 6002905.32345 | 2090290.85572 | 37.719705317820896 | -122.431986174531 | (37.7197053178209, -122.431986174531) | |
161113 | 161113 | 184268 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3939 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982564.7762 | 2104878.5059 | 37.758584879204705 | -122.503374600179 | (37.7585848792047, -122.503374600179) | |||
185882 | 185882 | 184267 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3941 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982547.9704 | 2104879.117 | 37.7585855691435 | -122.503432766509 | (37.7585855691435, -122.503432766509) | |||
37799 | 37799 | 183676 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3710 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984252.2399 | 2106352.1361 | 37.7627301098016 | -122.497647481121 | (37.7627301098016, -122.497647481121) | |||
147145 | 147145 | 184269 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3937 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982579.7486 | 2104879.117 | 37.7585874372759 | -122.503322864965 | (37.7585874372759, -122.503322864965) | |||
1397 | 1397 | 183688 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1341 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5983045.4855 | 2105994.3027 | 37.7616767889617 | -122.501794671486 | (37.7616767889617, -122.501794671486) | |||
25508 | 25508 | 183929 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1595 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988670.0771 | 2101007.2301 | 37.7483124102266 | -122.481976372217 | (37.7483124102266, -122.481976372217) | |||
51483 | 51483 | 183925 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2116 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988539.921 | 2100941.6436 | 37.7481247565163 | -122.48242163832701 | (37.7481247565163, -122.482421638327) | |||
51679 | 51679 | 183928 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1595 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988643.6391 | 2101005.1964 | 37.7483052885878 | -122.482067644083 | (37.7483052885878, -122.482067644083) | |||
163995 | 163995 | 182854 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2808 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5985288.5437 | 2103000.9327 | 37.753589326126104 | -122.493816355988 | (37.7535893261261, -122.493816355988) | |||
163563 | 163563 | 182459 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599 30th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986820.9264 | 2104460.1554 | 37.7576854884853 | -122.488624356735 | (37.7576854884853, -122.488624356735) | |||
179735 | 179735 | 250198 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 201 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011825.11075 | 2119776.45008 | 37.8011678477679 | -122.40322653269199 | (37.8011678477679, -122.403226532692) | |||
61680 | 61680 | 182853 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2806 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985300.7799 | 2103002.6013 | 37.7535946235281 | -122.49377416408899 | (37.7535946235281, -122.493774164089) | |||
150142 | 150142 | 183639 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1471 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5982147.0943 | 2105086.2067 | 37.759130603641296 | -122.504834498787 | (37.7591306036413, -122.504834498787) | |||
161416 | 161416 | 141614 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 639 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001061.0575 | 2110935.8536 | 37.77628682660821 | -122.439840543521 | (37.7762868266082, -122.439840543521) | |||
162397 | 162397 | 244371 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 677 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004168.0770000005 | 2110433.1732 | 37.77508295847571 | -122.429056656274 | (37.7750829584757, -122.429056656274) | |||
126315 | 126315 | 183700 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1341 42nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5983053.8914 | 2105774.5663 | 37.7610739488783 | -122.501749341463 | (37.7610739488783, -122.501749341463) | |||
131395 | 131395 | 183037 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2523 43rd Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5983009.062000001 | 2097931.9719 | 37.7395377337872 | -122.50132425344299 | (37.7395377337872, -122.501324253443) |
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");