Street_Tree_List

Data source: data.sfgov.org

970 rows where qSpecies = 75 sorted by Longitude

View and edit SQL

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
130131 118484 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 8349 Geary Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     5981049.15965 2112307.0389 37.7788922504996 -122.50916782963499 (37.7788922504996, -122.509167829635)
43226 118483 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 8349 Geary Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     5981073.18846 2112308.0171 37.7788963529663 -122.50908477858499 (37.7788963529663, -122.509084778585)
44144 184617 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1758 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5981057.9764 2103098.1394 37.753607806054 -122.508453540189 (37.753607806054, -122.508453540189)
79563 109279 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4205 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773691 5981200.9 2104121.0 37.7564247125175 -122.508035196592 (37.7564247125175, -122.508035196592)
128537 109280 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4205 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773691 5981200.9 2104121.0 37.7564247125175 -122.508035196592 (37.7564247125175, -122.508035196592)
142429 109281 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 4205 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773691 5981200.9 2104121.0 37.7564247125175 -122.508035196592 (37.7564247125175, -122.508035196592)
133518 68285 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1894 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 9   Permit Number 32094 5981358.7272 2102199.6882 37.7511586335316 -122.50734684264 (37.7511586335316, -122.50734684264)
177484 184517 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4046 Ortega St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5981383.432 2102173.6297 37.751088539403206 -122.507259479265 (37.7510885394032, -122.507259479265)
186434 184516 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4044 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5981414.9052 2102173.2913 37.75108946399121 -122.50715061850599 (37.7510894639912, -122.507150618506)
174670 184444 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2131 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5981678.0282 2100560.0346 37.7466754073158 -122.50612112236 (37.7466754073158, -122.50612112236)
119689 46396 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2363 46th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM     Permit Number 44628 5982038.69993379 2099019.08157606 37.7424656032555 -122.504759817001 (37.7424656032555, -122.504759817001)
131560 183162 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2401 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5982053.1688 2098706.8368 37.7416091165514 -122.50468665850401 (37.7416091165514, -122.504686658504)
39669 118709 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4201 Balboa St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5982467.72104 2110969.09723 37.7753021852736 -122.504161410758 (37.7753021852736, -122.504161410758)
66563 184459 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2170 45th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 0ft   5982352.1644 2100338.7067 37.746107363854705 -122.503773678611 (37.7461073638547, -122.503773678611)
35759 117922 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 683 41st Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   5983174.6969099995 2111166.71748 37.775886344567496 -122.501730482451 (37.7758863445675, -122.501730482451)
158682 65148 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 7330 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM 17   Permit Number 27125 5984217.18812 2112512.23092 37.7796419140825 -122.498223688652 (37.7796419140825, -122.498223688652)
148908 118014 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 472 37th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 6ft   5984415.81444 2112632.82053 37.779984662684704 -122.49754547051 (37.7799846626847, -122.49754547051)
50210 182350 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1501 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 0ft   5985255.7552 2104953.475 37.7589485494212 -122.49407363959699 (37.7589485494212, -122.494073639597)
41031 182386 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1538 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5985306.5492 2104723.6759 37.758320556835606 -122.493881037718 (37.7583205568356, -122.493881037718)
154136 119374 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 866 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5986063.1424 2109995.79652 37.7728405660437 -122.49165253211099 (37.7728405660437, -122.491652532111)
161830 115081 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1546 33RD AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3   5985952.0 2104698.0 37.7582878007794 -122.491646926351 (37.7582878007794, -122.491646926351)
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)
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)
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)
93045 6109 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 3 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
101360 6110 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 4 Median : Cutout 11 Tree 1 DPW 2     18 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
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)
106348 6113 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 7 Median : Cutout 11 Tree 1 DPW 2     18 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
110321 6112 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 6 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
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)
112905 6111 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 5 Median : Cutout 11 Tree 1 DPW 2     18 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
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)
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)
128687 6108 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 2 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
145369 6107 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 600X El Camino Del Mar 1 Median : Cutout 11 Tree 1 DPW 2     24 15-HOA   5986691.2678849995 2115146.1691739 37.787018710699 -122.48985866316099 (37.787018710699, -122.489858663161)
38749 181998 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2476 30th Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   5987077.3789 2098389.2279 37.7410313164056 -122.48729154146099 (37.7410313164056, -122.487291541461)
157013 181997 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2478 30th Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5987077.3789 2098383.8132 37.741016449074294 -122.487291143841 (37.7410164490743, -122.487291143841)
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)
53731 181995 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2482 30th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   5987079.071 2098350.9862 37.7409264135054 -122.487282882666 (37.7409264135054, -122.487282882666)
63268 181996 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2480 30th Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   5987079.7478 2098357.7547 37.740945037480294 -122.487281039603 (37.7409450374803, -122.487281039603)
51895 181992 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2490 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   5987079.071 2098310.7141 37.7408158369886 -122.487279925369 (37.7408158369886, -122.487279925369)
46093 181993 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2488 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5987080.4247 2098320.1899 37.7408419339653 -122.487275940676 (37.7408419339653, -122.487275940676)
59002 181991 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2492 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 0ft   5987080.0862 2098302.9304 37.740794524211104 -122.48727584365601 (37.7407945242111, -122.487275843656)
162871 183526 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2550 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5987093.1088 2097910.6765 37.739718258195296 -122.487202013829 (37.7397182581953, -122.487202013829)
68162 181989 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2850 Ulloa St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   5987109.8673 2098288.0398 37.7407553751877 -122.48717177975 (37.7407553751877, -122.48717177975)
27240 73535 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2207 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1995 12:00:00 AM 18     5987582.0279 2100272.2966 37.7462311393003 -122.485684839892 (37.7462311393003, -122.485684839892)
36738 181277 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988402.74919 2089827.8491900002 37.7176011677477 -122.482081905481 (37.7176011677477, -122.482081905481)
168519 181276 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988413.87941 2089827.13064 37.7175998421416 -122.482043381217 (37.7175998421416, -122.482043381217)
156730 181275 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988424.04089 2089826.4329400002 37.7175985174299 -122.482008206935 (37.7175985174299, -122.482008206935)
13185 98922 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2507 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 6x6   5989831.2863 2098268.2421 37.7408593296697 -122.47776079641599 (37.7408593296697, -122.477760796416)
85176 104920 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 1 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
101258 104921 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 2 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
111624 104922 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 3 Median : Yard 3 Tree 1 Private 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
128606 104928 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 3 Median : Yard 3 Tree 1 Private 1     12     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
143894 104927 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 2 Median : Yard 3 Tree 1 Private 1     10     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
144760 104926 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 1 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
20499 31376 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 634 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/2004 12:00:00 AM 18 3x3 Permit Number 34978 5991167.871719999 2099111.64976 37.7432525889424 -122.47320092310301 (37.7432525889424, -122.473200923103)
173091 217428 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991492.83801 2105186.64815 37.7599517618807 -122.47252009133601 (37.7599517618807, -122.472520091336)
18617 48631 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1501 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/30/2002 12:00:00 AM     Permit Number 45927 5991498.56479756 2105191.60606182 37.759965706466296 -122.472500646803 (37.7599657064663, -122.472500646803)
96328 48632 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1501 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/30/2002 12:00:00 AM     Permit Number 45927 5991498.56479756 2105191.60606182 37.759965706466296 -122.472500646803 (37.7599657064663, -122.472500646803)
140194 48630 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1501 15th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/30/2002 12:00:00 AM     Permit Number 45927 5991498.56479756 2105191.60606182 37.759965706466296 -122.472500646803 (37.7599657064663, -122.472500646803)
153758 217429 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   5991520.38705 2105187.01956 37.7599543762085 -122.472424840551 (37.7599543762085, -122.472424840551)
35169 217430 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   5991534.38297 2105188.62915 37.7599596057689 -122.47237655325 (37.7599596057689, -122.47237655325)
33282 217464 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 127 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5991405.11003 2090040.73714 37.7183598726973 -122.471719713607 (37.7183598726973, -122.471719713607)
123379 28428 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2499 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5991618.4954 2094538.91045 37.730723086818706 -122.471309697155 (37.7307230868187, -122.471309697155)
143075 28429 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2499 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5991627.582769999 2094536.0068700002 37.7307156399791 -122.471278069527 (37.7307156399791, -122.471278069527)
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)
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)
130520 181272 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4061 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   5991602.94551 2088924.16966 37.7153054953149 -122.47095459108299 (37.7153054953149, -122.470954591083)
161568 217470 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 870 Judah St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5991963.05013 2105942.50613 37.7620543534437 -122.47094893346501 (37.7620543534437, -122.470948933465)
165440 217469 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 870 Judah St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5991984.27655 2105943.70129 37.7620588626465 -122.470875607232 (37.7620588626465, -122.470875607232)
62292 217468 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 870 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5992024.3496199995 2105944.9682299998 37.76206465879179 -122.47073710353999 (37.7620646587918, -122.47073710354)
21746 28469 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2400X Ocean Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 16 3x3   5991803.10743 2094513.5211900002 37.7306640516002 -122.47066962200199 (37.7306640516002, -122.470669622002)
183675 217467 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 870 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5992049.56384 2105945.3755799998 37.762067235345796 -122.47064992776801 (37.7620672353458, -122.470649927768)
84014 99843 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 810 Judah St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 44828 5992070.0 2105943.0 37.762061894358794 -122.47057907460301 (37.7620618943588, -122.470579074603)
124863 99842 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 810 Judah St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 44828 5992070.0 2105943.0 37.762061894358794 -122.47057907460301 (37.7620618943588, -122.470579074603)
142378 99841 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 810 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 44828 5992070.0 2105943.0 37.762061894358794 -122.47057907460301 (37.7620618943588, -122.470579074603)
142737 99840 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 810 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 44828 5992070.0 2105943.0 37.762061894358794 -122.47057907460301 (37.7620618943588, -122.470579074603)
126547 28430 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2439 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5991842.51952 2094406.3714 37.730372124061 -122.47052556873001 (37.730372124061, -122.47052556873)
121147 28431 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2439 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5991850.14781 2094403.3644599998 37.7303643088426 -122.470498978 (37.7303643088426, -122.470498978)
20637 28466 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2400X Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5991883.040519999 2094469.1856200001 37.7305469391855 -122.470390056066 (37.7305469391855, -122.470390056066)
19337 28465 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2400X Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 20 3X3   5991890.46795 2094463.9111900001 37.7305328863621 -122.470363994616 (37.7305328863621, -122.470363994616)
94338 28432 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2425 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5991942.44608 2094354.15031 37.730234515527 -122.47017631066002 (37.730234515527, -122.47017631066)
2846 253262 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2425 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
2856 253264 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2425 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
88489 28433 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2425 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5991953.12175 2094350.44875 37.730224969150896 -122.470139134356 (37.7302249691509, -122.470139134356)
85633 28464 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2400X Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5991972.677497401 2094408.8386932998 37.7303864239 -122.470075778183 (37.7303864239, -122.470075778183)
110383 28467 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2400X Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 20 3X3   5991972.677497401 2094408.8386932998 37.7303864239 -122.470075778183 (37.7303864239, -122.470075778183)
118576 28468 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2400X Ocean Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 17 3X3   5991972.677497401 2094408.8386932998 37.7303864239 -122.470075778183 (37.7303864239, -122.470075778183)
67120 217465 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 270 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5991973.319019999 2090312.5132 37.719138962561395 -122.469775446797 (37.7191389625614, -122.469775446797)
92472 28425 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2390X Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5992110.499009999 2094330.64063 37.7301796779751 -122.469593623835 (37.7301796779751, -122.469593623835)
144404 28424 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2390X Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2003 12:00:00 AM 12 3X3   5992122.7651 2094324.99132 37.730164875296296 -122.469550807661 (37.7301648752963, -122.469550807661)
120677 28435 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2383 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5992163.8663800005 2094231.44033 37.7299103829045 -122.469401909547 (37.7299103829045, -122.469401909547)
96358 28436 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2383 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5992168.55554 2094228.20045 37.729901757986 -122.46938546297702 (37.729901757986, -122.469385462977)
137624 217466 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 380 Ralston St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5992234.1227 2090402.1103 37.7194000456453 -122.46888047296801 (37.7194000456453, -122.468880472968)
108922 28439 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2325 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5992364.67777 2094097.6153099998 37.729554535492 -122.46869795321999 (37.729554535492, -122.46869795322)
84329 28440 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2325 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5992376.3743900005 2094089.82777 37.7295338285402 -122.46865695076099 (37.7295338285402, -122.468656950761)
103267 28470 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2295 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5992499.15443 2093893.9061599998 37.729002968377294 -122.46821824463301 (37.7290029683773, -122.468218244633)
108531 28471 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2295 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2003 12:00:00 AM 12 3X3   5992502.64875 2093884.6455400002 37.728977742823794 -122.46820549121 (37.7289777428238, -122.46820549121)
128400 28421 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2230 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/28/2012 12:00:00 AM 12 3x3   5992633.17801 2093727.0114099998 37.728552456339706 -122.467742785837 (37.7285524563397, -122.467742785837)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 653.592ms · Data source: data.sfgov.org