trees

420 rows where qSpecies_id = 116 sorted by Location descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▲ Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
85163 136748 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 165 Marina Blvd 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6002698.42353 2121575.97678 37.8055949413272 -122.434937570523 (37.8055949413272, -122.434937570523) 13 9 1 57 17
71242 136740 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1920 Beach St 8 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6000976.88542 2121020.42839 37.8039716578185 -122.44085530385 (37.8039716578185, -122.44085530385) 13 9 1 57 17
127274 143059 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 440 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010738.656 2120349.8129 37.8026814253217 -122.407026593467 (37.8026814253217, -122.407026593467) 3 1 10 308 23
120819 16366 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1306X Montgomery St 9 Median : Cutout Tree DPW 1     8 8   6011454.04278 2119896.37482 37.8014764015683 -122.404519042813 (37.8014764015683, -122.404519042813) 3 1 10 308 23
183428 136750 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1124 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 5ft   6007528.1043 2119564.51843 37.8003450211571 -122.418081047713 (37.8003450211571, -122.418081047713) 5 1 1 28858 32
112010 136751 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1142 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   6007453.51921 2119553.70533 37.8003111329029 -122.41833837522 (37.8003111329029, -122.41833837522) 5 1 1 28858 32
26740 87392 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3322 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.29419 37.8002813140837 -122.436061950612 (37.8002813140837, -122.436061950612) 13 9 1 57 17
168165 87391 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3322 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.436053318908 (37.800247665053, -122.436053318908) 13 9 1 57 17
114110 66988 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1445 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/1992 12:00:00 AM 12   Permit Number 30339 6006117.71616 2118619.27503 37.7976701397196 -122.422894339811 (37.7976701397196, -122.422894339811) 13 9 10 28858 32
47804 136746 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2908 Broderick St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6000043.09421 2118605.60705 37.7972879782152 -122.443913133705 (37.7972879782152, -122.443913133705) 13 9 1 57 17
156301 136745 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2908 Broderick St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6000044.84961 2118592.59728 37.7972523569702 -122.443906124388 (37.7972523569702, -122.443906124388) 13 9 1 57 17
145163 136744 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2906 Broderick St 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6000047.06944 2118581.72583 37.7972226334754 -122.443897661751 (37.7972226334754, -122.443897661751) 13 9 1 57 17
124321 136743 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2900 Broderick St 4 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6000050.87786 2118557.23395 37.7971556025074 -122.44388272313 (37.7971556025074, -122.44388272313) 13 9 1 57 17
8935 136742 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2900 Broderick St 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6000053.33945 2118542.13589 37.7971142876507 -122.443873120143 (37.7971142876507, -122.443873120143) 13 9 1 57 17
21140 136741 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2900 Broderick St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6000055.17715 2118534.11341 37.7970923648718 -122.443866184587 (37.7970923648718, -122.443866184587) 13 9 1 57 17
158744 136747 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2859 Filbert St 4 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5999233.55999 2118349.36625 37.7965381990226 -122.446695870812 (37.7965381990226, -122.446695870812) 13 9 1 57 17
4227 109316 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
38676 109314 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
43466 109317 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
161164 109315 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
82601 63573 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1500@Polk Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 6   Permit Number 49344 6006306.38676 2118003.57118 37.7959902160323 -122.422197721351 (37.7959902160323, -122.422197721351) 13 9 10 28858 32
162973 84928 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1500@Polk Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2007 12:00:00 AM 6   Permit Number 49344 6006295.34378 2118001.00844 37.7959825565137 -122.422235750095 (37.7959825565137, -122.422235750095) 13 9 10 28858 32
166698 136749 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1360 Jones St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6008500.72583 2117239.96883 37.7940170782903 -122.414550796777 (37.7940170782903, -122.414550796777) 5 1 10 28857 21
40270 52600 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1360WASHINGTON Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2006 12:00:00 AM 9   Permit Number 48694 6008503.01401 2117214.59757 37.793947543601 -122.41454108323 (37.793947543601, -122.41454108323) 5 1 10 28857 21
123376 113776 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1710 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000070.198 2114878.1306 37.7870548531015 -122.443551447546 (37.7870548531015, -122.443551447546) 13 6 1 29490 27
47194 250756 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2900 Lake St 1 : Tree Private 2     6 Width 0ft   5986048.1037 2114785.2005 37.7859900201618 -122.492057248563 (37.7859900201618, -122.492057248563) 11 6 1 55 33
102004 124330 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 130 Palm Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995934.00049 2113471.95009 37.7829570979054 -122.457759890544 (37.7829570979054, -122.457759890544) 11 6 1 54 31
123424 67713 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 557 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1992 12:00:00 AM     Permit Number 31325 6014732.24235944 2112894.33120186 37.7824330740175 -122.392684800601 (37.7824330740175, -122.392684800601) 6 2 9 28856 6
136184 43754 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 367 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 14   Permit Number 43390 5991197.85001 2112958.02747 37.781272787853 -122.474107339564 (37.781272787853, -122.474107339564) 11 6 2 54 26
37911 117703 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4001 Clement St 7 Sidewalk: Property side : Yard Tree Private 2     10 Width 7ft   5983084.79003 2113081.26685 37.7811378565893 -122.502183200126 (37.7811378565893, -122.502183200126) 11 6 2 55 26
172875 117708 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4001 Clement St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 7ft   5983029.04687 2113077.74857 37.7811249212832 -122.502375780065 (37.7811249212832, -122.502375780065) 11 6 2 55 26
108310 63197 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 472 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1986 12:00:00 AM 14   Permit Number 23738 5984415.83341 2112620.01213 37.7799494956437 -122.497544458973 (37.7799494956437, -122.497544458973) 11 6 2 55 26
136147 119965 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 518 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5987217.06494 2112373.1551 37.7794354929176 -122.487835733288 (37.7794354929176, -122.487835733288) 11 6 2 55 26
28105 63543 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1715 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1994 12:00:00 AM     Permit Number 33376 6001376.18344652 2111778.57795299 37.7786186676026 -122.438810841545 (37.7786186676026, -122.438810841545) 15 5 11 29490 41
193666 50830 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 621 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM 9   Permit Number 47349 6000535.8217 2111139.1847 37.7768152106013 -122.441672069607 (37.7768152106013, -122.441672069607) 15 5 11 29492 16
164294 123216 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 654 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5993193.61084 2111027.91211 37.7760886204879 -122.467062678343 (37.7760886204879, -122.467062678343) 11 6 2 54 11
111572 57900 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1324 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/1977 12:00:00 AM 5   Permit Number 16856 6001502.5818 2110462.7186 37.7750128394498 -122.438279288937 (37.7750128394498, -122.438279288937) 15 5 11 29492 10
123985 141332 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1324 HAYES ST 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 0ft   6001489.2623 2110460.5875 37.7750062304087 -122.438325211171 (37.7750062304087, -122.438325211171) 15 5 11 29492 10
179353 197990 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 155 Grace St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008384.45392 2110216.9376 37.774726996282 -122.414455930021 (37.774726996282, -122.414455930021) 8 2 9 28853 34
34894 253483 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
35262 253489 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
36333 253491 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
50722 253485 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
61025 253495 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
84993 253492 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
85377 253490 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
93105 253487 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
95654 253488 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
105665 253493 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
159122 253486 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
169973 253496 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 14 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
181014 253484 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
190324 253494 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
26688 88372 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 45 Sheridan St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306 2109414 37.7725740445577 -122.411211370961 (37.7725740445577, -122.411211370961) 8 2 9 28853 34
91808 88373 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 45 Sheridan St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306 2109414 37.7725740445577 -122.411211370961 (37.7725740445577, -122.411211370961) 8 2 9 28853 34
157496 51920 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 45 Sheridan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009316.82358159 2109402.74774996 37.7725437555109 -122.411173135945 (37.7725437555109, -122.411173135945) 8 2 9 28853 34
189828 38219 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 118 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2000 12:00:00 AM     Permit Number 40340 6000363.19569215 2109305.86913973 37.7717715527779 -122.44213760158 (37.7717715527779, -122.44213760158) 15 5 11 29492 9
164560 62050 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008120 2108416 37.7697671862008 -122.415243219817 (37.7697671862008, -122.415243219817) 8 2 9 28853 19
110485 44261 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
129342 44264 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
146756 44262 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
166497 44263 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.7696567724968 -122.426413224583 (37.7696567724968, -122.426413224583) 7 4 5 28852 10
81429 39859 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.414839630355 (37.7696326766808, -122.414839630355) 8 4 9 28853 19
116024 39860 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.414839630355 (37.7696326766808, -122.414839630355) 8 4 9 28853 19
157346 39861 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 70 13th St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.414839630355 (37.7696326766808, -122.414839630355) 8 4 9 28853 19
112628 83941 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 60 13th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3X3 Permit Number 50121 6008302.41836553 2108360.42350377 37.7696248364946 -122.414608304259 (37.7696248364946, -122.414608304259) 8 4 9 28853 19
187547 241178 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 1 Front Yard : Yard Tree Private 2   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.38967 2108410.10559 37.7695635954031 -122.426742541533 (37.7695635954031, -122.426742541533) 7 9 5 28862 10
50237 241179 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 2 Front Yard : Yard Tree Private 2   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481) 7 9 5 28862 10
84384 241181 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 4 Front Yard : Yard Tree Private 2   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.30529 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397) 7 9 5 28862 10
20099 241180 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 300 Duboce Ave 3 Front Yard : Yard Tree Private 2   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767) 7 9 5 28862 10
40644 247521 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1101 Waller St 2 Side Yard : Yard Tree Private 2     5     6000007.86979 2108477.01107 37.7694754609529 -122.443307149811 (37.7694754609529, -122.443307149811) 15 5 11 29492 9
91219 108286 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1 HENRY ADAMS ST 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   6011517.4 2108140.5 37.7692010762684 -122.403472255644 (37.7692010762684, -122.403472255644) 8 2 8 28853 20
129119 108282 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1 HENRY ADAMS ST 7 Sidewalk: Property side : Cutout Tree Private 2     10 3x3   6011517.4 2108140.5 37.7692010762684 -122.403472255644 (37.7692010762684, -122.403472255644) 8 2 8 28853 20
28989 247209 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 800 Duboce Ave 5 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6001860.51527 2108286.6653 37.7690582897368 -122.436885307832 (37.7690582897368, -122.436885307832) 15 5 5 29492 9
129198 247212 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 800 Duboce Ave 11 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   6001824.51541 2108284.91798 37.7690514458872 -122.437009703838 (37.7690514458872, -122.437009703838) 15 5 5 29492 9
20297 246216 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 725 Buena Vista Ave West 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999835.3063 2107870.2944 37.7677997276311 -122.443860441452 (37.7677997276311, -122.443860441452) 15 5 11 29492 9
30420 52305 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 715 Buena Vista Ave West 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896) 15 5 5 29492 9
53968 52306 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 715 Buena Vista Ave West 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896) 15 5 5 29492 9
14508 246217 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 725 Buena Vista Ave West 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999828.0384 2107849.3991 37.7677419398126 -122.443884078726 (37.7677419398126, -122.443884078726) 15 5 11 29492 9
130826 115632 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 55x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6012114 2107494 37.7674592382642 -122.40136319642 (37.7674592382642, -122.40136319642) 14 3 8 28856 20
27954 197989 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 28 15th St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6012209.71616 2107476.11774 37.7674154774686 -122.401030868501 (37.7674154774686, -122.401030868501) 14 3 8 28856 20
193495 197988 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 82 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6012221.12319 2107462.35445 37.7673783228879 -122.40099044576 (37.7673783228879, -122.40099044576) 14 3 8 28856 20
181143 82360 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 415-421 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498) 8 4 7 28853 19
190785 80165 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 415-421 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498) 8 4 7 28853 19
49594 241189 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 415 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007440.26209 2107242.97401 37.7665081073951 -122.41751127324 (37.7665081073951, -122.41751127324) 8 4 7 28853 19
161154 241188 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 419 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6007442.12211 2107229.45736 37.7664710984984 -122.417503881697 (37.7664710984984, -122.417503881697) 8 4 7 28853 19
156863 115612 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345) 14 3 8 28853 20
127178 115617 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031) 14 3 8 28856 20
141375 115616 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031) 14 3 8 28856 20
86595 60204 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/1982 12:00:00 AM 8 4x4 Permit Number 19750 6012229.2906 2107053.9352 37.7662573509097 -122.400933496957 (37.7662573509097, -122.400933496957) 14 3 8 28853 20
144098 115615 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1400 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4   6012069.0366 2107045.8512 37.766226213653 -122.401487220087 (37.766226213653, -122.401487220087) 14 3 8 28853 20
103122 241199 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 24 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998508.2304 2107266.01278 37.7660647371231 -122.448407097228 (37.7660647371231, -122.448407097228) 15 5 11 29492 9
99590 241201 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 26 Carl St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5998490.81522 2107264.49374 37.7660595705173 -122.448467223189 (37.7660595705173, -122.448467223189) 15 5 11 29492 9
75935 241200 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 26 Carl St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5998502.5017 2107263.12139 37.7660564705643 -122.448426703328 (37.7660564705643, -122.448426703328) 15 5 11 29492 9
58738 241224 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 44 Museum Way 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000710.17183 2106760.2697 37.7648017391332 -122.440754760547 (37.7648017391332, -122.440754760547) 15 5 5 28862 3
30821 108222 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
60510 34081 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 SHOTWELL ST 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
106666 108225 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
114315 108221 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19
158584 108224 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007737.2 2106597 37.7647511168143 -122.416438454623 (37.7647511168143, -122.416438454623) 8 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);