Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
519 | 519 | 6766 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:39:00 PM | 3 | 3x3 | 6017299.75412 | 2096896.40625 | 37.7386484107882 | -122.38268866835199 | (37.7386484107882, -122.382688668352) | ||
1173 | 1173 | 190143 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1200 Fairfax Ave | 7 | : 4 | Tree 1 | DPW 2 | 03/18/2017 10:47:00 AM | 3 | Width 4ft | 6017523.521480001 | 2096815.65975 | 37.738439056714704 | -122.381909364434 | (37.7384390567147, -122.381909364434) | ||
1275 | 1275 | 4132 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x3 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | ||
1276 | 1276 | 229197 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3186 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 4x4 | 6008575.05448 | 2100617.97477 | 37.7483811527748 | -122.41311771451599 | (37.7483811527748, -122.413117714516) | |||
1278 | 1278 | 231178 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3298 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x6 | 6007881.72523 | 2100615.5936 | 37.7483356677609 | -122.41551506969101 | (37.7483356677609, -122.415515069691) | ||
1280 | 1280 | 231193 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x6 | 6007038.27508 | 2100609.92371 | 37.7482726540762 | -122.41843130396799 | (37.7482726540762, -122.418431303968) | ||
1281 | 1281 | 231175 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 4x4 | 6008989.553669999 | 2100618.8922900003 | 37.7484069327314 | -122.41168444520599 | (37.7484069327314, -122.411684445206) | ||
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) | |||
1302 | 1302 | 4080 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3X6 | 6008284.97439 | 2100614.30528 | 37.7483547882437 | -122.414120548517 | (37.7483547882437, -122.414120548517) | ||
1304 | 1304 | 231176 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008965.15097 | 2100617.87341 | 37.7484027661782 | -122.411768757547 | (37.7484027661782, -122.411768757547) | |||
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) | |||
17477 | 17477 | 4067 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3096 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6009129.76815 | 2100619.82183 | 37.7484173495801 | -122.411199650344 | (37.7484173495801, -122.411199650344) | ||
17922 | 17922 | 26420 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1492 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005205.18394 | 2099681.3110700003 | 37.7456195335093 | -122.424704037463 | (37.7456195335093, -122.424704037463) | |||
19317 | 19317 | 4117 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3425 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006587.39221 | 2100520.66079 | 37.7480021658686 | -122.419984113875 | (37.7480021658686, -122.419984113875) | ||
20218 | 20218 | 4065 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009147.76851 | 2100538.02687 | 37.748193768248704 | -122.411131628336 | (37.7481937682487, -122.411131628336) | |||
20537 | 20537 | 4114 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3405 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006963.52964 | 2100524.30588 | 37.7480333588561 | -122.418683701415 | (37.7480333588561, -122.418683701415) | |||
20947 | 20947 | 4116 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3425 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006570.52935 | 2100520.79948 | 37.7480015966124 | -122.420042434916 | (37.7480015966124, -122.420042434916) | ||
21510 | 21510 | 4053 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2934 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2016 12:00:00 AM | 1 | 3X3 | 6009951.6651099995 | 2100626.39211 | 37.74848144967 | -122.40835799863999 | (37.74848144967, -122.40835799864) | ||
21690 | 21690 | 4077 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008348.6867 | 2100615.53254 | 37.7483617364081 | -122.413900318962 | (37.7483617364081, -122.413900318962) | |||
21978 | 21978 | 4079 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3X3 | 6008309.37499 | 2100615.3209700002 | 37.7483589476023 | -122.414036243399 | (37.7483589476023, -122.414036243399) | ||
22240 | 22240 | 4066 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3075 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009164.81651 | 2100538.0301200002 | 37.7481947332136 | -122.41107267688999 | (37.7481947332136, -122.41107267689) | |||
23041 | 23041 | 6763 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 2 | 3x3 | 6017251.5649 | 2096932.76019 | 37.7387455690451 | -122.38285781466298 | (37.7387455690451, -122.382857814663) | ||
23101 | 23101 | 4130 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/27/1995 12:00:00 AM | 4 | 3x3 | 6006437.45796 | 2100604.55432 | 37.748224069995295 | -122.42050853554501 | (37.7482240699953, -122.420508535545) | ||
23301 | 23301 | 26453 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 401X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017690.9643 | 2096738.1132099999 | 37.7382353746521 | -122.381325031738 | (37.7382353746521, -122.381325031738) | ||
23347 | 23347 | 26555 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3795 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6005295.67635 | 2100471.79281 | 37.7477951257409 | -122.424447343969 | (37.7477951257409, -122.424447343969) | |||
24137 | 24137 | 231180 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6009829.19056 | 2100977.4251599996 | 37.7494384497445 | -122.408806277407 | (37.7494384497445, -122.408806277407) | |||
25576 | 25576 | 231188 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009844.761940001 | 2100681.8264599997 | 37.7486276731362 | -122.408731579718 | (37.7486276731362, -122.408731579718) | |||
37488 | 37488 | 231181 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009829.63299 | 2100960.5991599998 | 37.7493922740476 | -122.408803560533 | (37.7493922740476, -122.408803560533) | |||
61236 | 61236 | 231182 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009830.8123699995 | 2100941.41106 | 37.7493396538235 | -122.408798128636 | (37.7493396538235, -122.408798128636) | |||
64215 | 64215 | 231184 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009832.795080001 | 2100903.82499 | 37.7492365618324 | -122.40878862099599 | (37.7492365618324, -122.408788620996) | |||
79302 | 79302 | 4285 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
85607 | 85607 | 25976 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2065 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2016 12:00:00 AM | 3 | 2x3 | 6012647.581347 | 2097234.3690945 | 37.739318274919896 | -122.398797486611 | (37.7393182749199, -122.398797486611) | ||
88090 | 88090 | 4078 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008412.1891644 | 2100602.6212259 | 37.7483298510109 | -122.413679815119 | (37.7483298510109, -122.413679815119) | |||
98439 | 98439 | 4287 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/1998 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
107774 | 107774 | 116080 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2854 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010430.0 | 2100760.0 | 37.748875082227705 | -122.40671333173 | (37.7488750822277, -122.40671333173) | ||||
111755 | 111755 | 109373 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2936 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2016 12:00:00 AM | 1 | 3X3 | 6009926.0 | 2100644.0 | 37.7485283598064 | -122.40844799036199 | (37.7485283598064, -122.408447990362) | ||
113366 | 113366 | 4172 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3795 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/2014 08:17:00 AM | 3 | 4X4 | 6005296.67379 | 2100472.2695 | 37.7477964909484 | -122.424443928769 | (37.7477964909484, -122.424443928769) | ||
113772 | 113772 | 122738 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3280x Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007827.0 | 2100671.0 | 37.7484847250957 | -122.41570823124901 | (37.7484847250957, -122.415708231249) | ||||
115049 | 115049 | 108819 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2015 12:00:00 AM | 3 | 3x3 | 6010441.0 | 2100764.0 | 37.7488866808005 | -122.40667557539301 | (37.7488866808005, -122.406675575393) | ||
118450 | 118450 | 122734 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3203 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008384.0 | 2100540.0 | 37.7481563241105 | -122.41377286403 | (37.7481563241105, -122.41377286403) | ||||
146201 | 146201 | 4286 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
147681 | 147681 | 231189 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009846.38998 | 2100665.3670200002 | 37.7485825703299 | -122.40872478893499 | (37.7485825703299, -122.408724788935) | |||
154689 | 154689 | 231183 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2800x Bryant St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009832.36063 | 2100921.04222 | 37.7492838122089 | -122.408791337857 | (37.7492838122089, -122.408791337857) | |||
169291 | 169291 | 231186 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009842.69971 | 2100715.50345 | 37.748720027217296 | -122.408741086441 | (37.7487200272173, -122.408741086441) | |||
175009 | 175009 | 231185 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009841.33523 | 2100729.29077 | 37.74875780773171 | -122.408746777365 | (37.7487578077317, -122.408746777365) | |||
187731 | 187731 | 231187 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009843.90305 | 2100697.4884 | 37.748670629262904 | -122.408735654529 | (37.7486706292629, -122.408735654529) |
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");