Data source: data.sfgov.org
This data as json, CSV (advanced)
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) | ||
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) | ||
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) | |||
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) | |||
42328 | 42328 | 115970 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30TH AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 0 | 3x3 | 5986686.0 | 2104596.0 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | |||
48933 | 48933 | 115967 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4 | 3x3 | 5986812.8086 | 2104676.4366 | 37.758278863742106 | -122.488668327875 | (37.7582788637421, -122.488668327875) | |||
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) | ||
79730 | 79730 | 99039 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 200X Bartlett St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
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) | |||
95487 | 95487 | 115964 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5986686.0 | 2104596.0 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | |||
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) | ||
105713 | 105713 | 40250 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3351X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41415 | 6006702.84210434 | 2102592.14346256 | 37.7536964884672 | -122.419731851285 | (37.7536964884672, -122.419731851285) |
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) | ||
119065 | 119065 | 98218 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
120505 | 120505 | 98220 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
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) | |||
160302 | 160302 | 115965 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | 3x3 | 5986811.649 | 2104744.2782 | 37.758465070521105 | -122.488677324697 | (37.7584650705211, -122.488677324697) | |||
164886 | 164886 | 115968 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986813.3885 | 2104648.6042 | 37.7582024774349 | -122.48866427663799 | (37.7582024774349, -122.488664276638) | |||
166151 | 166151 | 115971 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4 | 3x3 | 5986813.9683 | 2104572.6448 | 37.757993947556 | -122.48865668838499 | (37.757993947556, -122.488656688385) | |||
168456 | 168456 | 115973 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30TH AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 0 | 3x3 | 5986686.0 | 2104596.0 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | |||
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) | |||
175061 | 175061 | 115966 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986811.649 | 2104717.0256 | 37.7583902423484 | -122.488675321582 | (37.7583902423484, -122.488675321582) | |||
177652 | 177652 | 115972 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5986817.4474 | 2104547.1317 | 37.757924098588795 | -122.488642781125 | (37.7579240985888, -122.488642781125) | |||
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");