Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51983 | 51983 | 203178 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6015363.87101 | 2102334.663 | 37.75347359354279 | -122.38976182994 | (37.7534735935428, -122.38976182994) | ||||
| 174438 | 174438 | 203177 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6015358.55131 | 2102374.09965 | 37.7535815832452 | -122.38978298111401 | (37.7535815832452, -122.389782981114) | ||||
| 178669 | 178669 | 243943 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 671 Church St | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6004315.82343 | 2105235.1157 | 37.7608187101375 | -122.428175041065 | (37.7608187101375, -122.428175041065) | |||
| 32721 | 32721 | 217463 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996525.6642 | 2088997.67416 | 37.7157908018682 | -122.45394491554701 | (37.7157908018682, -122.453944915547) | |||
| 179057 | 179057 | 217462 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996487.36469 | 2088998.4739599999 | 37.7157908018916 | -122.454077353311 | (37.7157908018916, -122.454077353311) | |||
| 52430 | 52430 | 217461 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5996430.050430001 | 2088999.1612900002 | 37.7157894025409 | -122.454275506331 | (37.7157894025409, -122.454275506331) | |||
| 50630 | 50630 | 217460 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 5996389.15784 | 2088998.26407 | 37.715784593857606 | -122.454416784407 | (37.7157845938576, -122.454416784407) | |||
| 165812 | 165812 | 217459 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996291.57105 | 2089000.5851900002 | 37.715785369974796 | -122.45475425500099 | (37.7157853699748, -122.454754255001) | |||
| 38378 | 38378 | 203183 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015658.44629 | 2106386.7571400004 | 37.7646161091615 | -122.38902601186001 | (37.7646161091615, -122.38902601186) | |||
| 170196 | 170196 | 217458 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 5996270.87292 | 2089001.5829099999 | 37.7157869222056 | -122.454825868913 | (37.7157869222056, -122.454825868913) | |||
| 61712 | 61712 | 203182 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015656.28581 | 2106435.78787 | 37.7647506171774 | -122.38903690803998 | (37.7647506171774, -122.38903690804) | |||
| 43216 | 43216 | 203186 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 25th St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014234.68411 | 2101965.33677 | 37.752396820871894 | -122.393640982742 | (37.7523968208719, -122.393640982742) | ||||
| 153721 | 153721 | 203181 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015653.76081 | 2106475.1848299997 | 37.7648586527362 | -122.389048392363 | (37.7648586527362, -122.389048392363) | |||
| 44059 | 44059 | 199443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 625 King St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6012254.773469999 | 2108757.11148 | 37.7709353106325 | -122.400965034535 | (37.7709353106325, -122.400965034535) | |||
| 16634 | 16634 | 21880 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015651.4577 | 2106526.92513 | 37.765000592730395 | -122.389059971145 | (37.7650005927304, -122.389059971145) | ||
| 157503 | 157503 | 199466 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015602.95639 | 2107310.9230400003 | 37.7671505920487 | -122.38928247692499 | (37.7671505920487, -122.389282476925) | |||
| 14750 | 14750 | 21878 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015649.24797 | 2106571.51851 | 37.765122914002205 | -122.389070727941 | (37.7651229140022, -122.389070727941) | ||
| 33501 | 33501 | 199465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015601.020959999 | 2107350.5744 | 37.7672593587506 | -122.389291940488 | (37.7672593587506, -122.389291940488) | |||
| 71109 | 71109 | 199442 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013442.0065 | 2107543.23317 | 37.7676684261738 | -122.396773220723 | (37.7676684261738, -122.396773220723) | |||
| 27968 | 27968 | 199441 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013426.97714 | 2107527.99953 | 37.767625761459705 | -122.39682413764 | (37.7676257614597, -122.39682413764) | |||
| 14545 | 14545 | 21876 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 3 | 3X3 | 6015645.96934 | 2106615.37755 | 37.7652431596794 | -122.389085130597 | (37.7652431596794, -122.389085130597) | ||
| 27550 | 27550 | 217457 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996170.11239 | 2089001.42717 | 37.7157807141869 | -122.455174130483 | (37.7157807141869, -122.455174130483) | |||
| 39215 | 39215 | 199440 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013418.56487 | 2107519.66805 | 37.767602416836 | -122.396852650636 | (37.767602416836, -122.396852650636) | |||
| 56235 | 56235 | 199464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015598.48485 | 2107402.1848299997 | 37.7674009291493 | -122.389304316962 | (37.7674009291493, -122.389304316962) | |||
| 130553 | 130553 | 181234 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6011952.76833 | 2087732.27923 | 37.7131887520264 | -122.40053255865601 | (37.7131887520264, -122.400532558656) | |||
| 52123 | 52123 | 244847 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 6006653.79898 | 2103383.59728 | 37.7558668756582 | -122.41995761356002 | (37.7558668756582, -122.41995761356) | |||
| 68422 | 68422 | 199439 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013405.93741 | 2107506.73149 | 37.7675661930534 | -122.396895420613 | (37.7675661930534, -122.396895420613) | |||
| 136903 | 136903 | 181233 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6011973.9880099995 | 2087758.6255 | 37.7132622770132 | -122.400461065249 | (37.7132622770132, -122.400461065249) | |||
| 15554 | 15554 | 21874 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015644.57338 | 2106657.85439 | 37.7653597144938 | -122.38909292500901 | (37.7653597144938, -122.389092925009) | ||
| 44421 | 44421 | 199463 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015595.21944 | 2107438.50948 | 37.7675004876899 | -122.38931814851999 | (37.7675004876899, -122.38931814852) | |||
| 155690 | 155690 | 199438 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013354.61019 | 2107458.2254 | 37.767430148995295 | -122.39706955454099 | (37.7674301489953, -122.397069554541) | |||
| 159892 | 159892 | 181232 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6011994.15316 | 2087783.96312 | 37.713332973598 | -122.400393145741 | (37.713332973598, -122.400393145741) | |||
| 24790 | 24790 | 199437 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013340.81155 | 2107445.60575 | 37.7673947300992 | -122.397116397514 | (37.7673947300992, -122.397116397514) | |||
| 62268 | 62268 | 181231 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012012.90847 | 2087803.8646200001 | 37.713388665025 | -122.40032971745 | (37.713388665025, -122.40032971745) | |||
| 104622 | 104622 | 27693 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 174465 | 174465 | 217456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996127.26791 | 2089002.03978 | 37.715779938072295 | -122.455322264126 | (37.7157799380723, -122.455322264126) | |||
| 13825 | 13825 | 21872 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.38910651286601 | (37.7655055845439, -122.389106512866) | ||
| 28387 | 28387 | 199462 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015592.103080001 | 2107492.64638 | 37.7676489630463 | -122.389332708559 | (37.7676489630463, -122.389332708559) | |||
| 40752 | 40752 | 181255 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011058.3910300005 | 2087059.24952 | 37.71129082818 | -122.403576524557 | (37.71129082818, -122.403576524557) | |||
| 111730 | 111730 | 27692 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 148463 | 148463 | 181230 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 6012037.58461 | 2087834.57577 | 37.713474367712294 | -122.400246583207 | (37.7134743677123, -122.400246583207) | |||
| 160884 | 160884 | 217455 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 5996102.296490001 | 2089002.27895 | 37.7157791619582 | -122.455408593627 | (37.7157791619582, -122.455408593627) | |||
| 174835 | 174835 | 199436 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013326.10031 | 2107431.53826 | 37.767355284933 | -122.39716629548599 | (37.767355284933, -122.397166295486) | |||
| 33738 | 33738 | 181254 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011072.17285 | 2087082.1734200001 | 37.711354542437 | -122.403530502643 | (37.711354542437, -122.403530502643) | |||
| 60777 | 60777 | 181229 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012059.81705 | 2087859.8714700001 | 37.713545064337296 | -122.400171515023 | (37.7135450643373, -122.400171515023) | |||
| 80227 | 80227 | 6116 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 161570 | 161570 | 203212 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013314.65603 | 2107418.8705599997 | 37.7673198651342 | -122.397204991541 | (37.7673198651342, -122.397204991541) | |||
| 16399 | 16399 | 21870 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015638.72465 | 2106753.7729 | 37.765622761707604 | -122.38911985249399 | (37.7656227617076, -122.389119852494) | ||
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 35626 | 35626 | 199488 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015518.167640001 | 2108801.30732 | 37.7712381600557 | -122.38967985676099 | (37.7712381600557, -122.389679856761) | |||
| 45676 | 45676 | 181228 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6012082.02881 | 2087884.13753 | 37.7136129325747 | -122.400096445907 | (37.7136129325747, -122.400096445907) | |||
| 64149 | 64149 | 203211 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013299.1332 | 2107408.33786 | 37.767290080493204 | -122.39725794451 | (37.7672900804932, -122.39725794451) | |||
| 87834 | 87834 | 27695 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 148566 | 148566 | 181253 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011090.2657 | 2087112.4680700002 | 37.7114387360727 | -122.403470098762 | (37.7114387360727, -122.403470098762) | |||
| 184842 | 184842 | 203176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015380.59839 | 2102345.27771 | 37.753503666864205 | -122.38970472391199 | (37.7535036668642, -122.389704723912) | ||||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 25192 | 25192 | 203195 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012994.723999999 | 2096005.499 | 37.735963390387 | -122.39751105148999 | (37.735963390387, -122.39751105149) | ||||
| 42329 | 42329 | 181252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011104.47177 | 2087135.7976799998 | 37.711503587981205 | -122.403422638862 | (37.7115035879812, -122.403422638862) | |||
| 43387 | 43387 | 247655 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 11 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.769063227919105 | -122.43811744198601 | (37.7690632279191, -122.438117441986) | |||
| 79565 | 79565 | 84717 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 127634 | 127634 | 27696 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 152407 | 152407 | 203210 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013290.0727699995 | 2107397.08786 | 37.7672586860712 | -122.397288494465 | (37.7672586860712, -122.397288494465) | |||
| 165843 | 165843 | 181227 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012100.147000001 | 2087910.54687 | 37.713686457546395 | -122.400035676032 | (37.7136864575464, -122.400035676032) | |||
| 168723 | 168723 | 217830 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991664.0561 | 2094598.0007200001 | 37.730887969306 | -122.471156491586 | (37.730887969306, -122.471156491586) | ||||
| 173007 | 173007 | 199449 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015644.40714 | 2108197.8403 | 37.769588171184296 | -122.3892010406 | (37.7695881711843, -122.3892010406) | |||
| 175922 | 175922 | 199480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015500.51903 | 2109136.7123 | 37.7721581296349 | -122.389764335453 | (37.7721581296349, -122.389764335453) | |||
| 180976 | 180976 | 217454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996047.542640001 | 2089003.42322 | 37.7157791619486 | -122.45559792969601 | (37.7157791619486, -122.455597929696) | |||
| 16861 | 16861 | 21868 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015630.42851 | 2106799.74819 | 37.7657485399863 | -122.38915175774599 | (37.7657485399863, -122.389151757746) | ||
| 24106 | 24106 | 246790 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 175 Brewster St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010136.6415 | 2098750.10917 | 37.74333994367979 | -122.40758608083901 | (37.7433399436798, -122.407586080839) | ||||
| 31002 | 31002 | 203209 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013274.2221800005 | 2107384.36901 | 37.767222880462796 | -122.39734242771401 | (37.7672228804628, -122.397342427714) | |||
| 36914 | 36914 | 247654 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | |||
| 41733 | 41733 | 203194 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012994.12431 | 2096000.54159 | 37.7359497449792 | -122.3975127773 | (37.7359497449792, -122.3975127773) | ||||
| 44505 | 44505 | 181226 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012120.3534699995 | 2087937.9432299999 | 37.713762809074 | -122.39996775739901 | (37.713762809074, -122.399967757399) | |||
| 48782 | 48782 | 181251 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011120.84177 | 2087163.22682 | 37.7115798172183 | -122.40336798793999 | (37.7115798172183, -122.40336798794) | |||
| 65873 | 65873 | 199487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015516.37079 | 2108841.48357 | 37.7713483755645 | -122.38968887873399 | (37.7713483755645, -122.389688878734) | |||
| 79235 | 79235 | 6115 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 123620 | 123620 | 84716 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 137725 | 137725 | 217829 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Ocean Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991671.86156 | 2094594.4240599999 | 37.7308786001697 | -122.471129246615 | (37.7308786001697, -122.471129246615) | ||||
| 141877 | 141877 | 28584 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1150 Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 3X3 | 5996037.5543 | 2091961.1786900002 | 37.72389988729329 | -122.455846143025 | (37.7238998872933, -122.455846143025) | ||
| 153835 | 153835 | 217441 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 4ft | 5997030.67735 | 2094719.72249 | 37.731531141041295 | -122.45261208429 | (37.7315311410413, -122.45261208429) | |||
| 157429 | 157429 | 217475 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Castenada Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994402.7024 | 2101793.398 | 37.75080276354671 | -122.462210258014 | (37.7508027635467, -122.462210258014) | |||
| 163853 | 163853 | 247589 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 800 Tompkins Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008947.19059 | 2096447.5550400002 | 37.7369509800105 | -122.411536266603 | (37.7369509800105, -122.411536266603) | ||||
| 169980 | 169980 | 203189 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 889 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6011337.056059999 | 2104206.57613 | 37.758389331013205 | -122.403819204816 | (37.7583893310132, -122.403819204816) | ||||
| 184860 | 184860 | 181218 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 765 Delano Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 5998962.78764 | 2090178.0255900002 | 37.719171212271796 | -122.445605954547 | (37.7191712122718, -122.445605954547) | |||
| 1933 | 1933 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 15167 | 15167 | 21867 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/2008 12:00:00 AM | 3 | 3X3 | 6015621.91024 | 2106888.57721 | 37.765991972979606 | -122.389187423983 | (37.7659919729796, -122.389187423983) | ||
| 18812 | 18812 | 25066 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005105.419480001 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | |||
| 21404 | 21404 | 15067 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | |||
| 27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
| 32681 | 32681 | 181225 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012142.64872 | 2087966.32727 | 37.713841988985 | -122.399892688298 | (37.713841988985, -122.399892688298) | |||
| 33231 | 33231 | 181999 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2474 30th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5987078.0557 | 2098396.6732 | 37.7410517986936 | -122.487289748097 | (37.7410517986936, -122.487289748097) | |||
| 35882 | 35882 | 181250 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011135.05622 | 2087186.9706 | 37.7116458067799 | -122.403320528015 | (37.7116458067799, -122.403320528015) | |||
| 40806 | 40806 | 217440 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997608.12096 | 2094709.9328599998 | 37.731537330169 | -122.450615054238 | (37.731537330169, -122.450615054238) | |||
| 44790 | 44790 | 244846 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6006641.954969999 | 2103569.5656 | 37.75637683445171 | -122.42001177073901 | (37.7563768344517, -122.420011770739) | |||
| 69037 | 69037 | 203208 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013261.211019999 | 2107370.66012 | 37.7671845144907 | -122.397386470235 | (37.7671845144907, -122.397386470235) | |||
| 81310 | 81310 | 84715 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
| 123108 | 123108 | 6114 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 131078 | 131078 | 199486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015515.33955 | 2108860.86593 | 37.771401538077704 | -122.389693799846 | (37.7714015380777, -122.389693799846) | |||
| 146688 | 146688 | 244823 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3700 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6005752.797 | 2100569.1543099997 | 37.74808826157621 | -122.422873560084 | (37.7480882615762, -122.422873560084) | |||
| 148816 | 148816 | 199461 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015597.30963 | 2109009.9155099997 | 37.7718153404253 | -122.389420669423 | (37.7718153404253, -122.389420669423) |
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");