trees

420 rows where qSpecies_id = 116 sorted by PlantDate 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)
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
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
129962 34076 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2851X 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
163325 34077 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2851X 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
183562 34085 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2851X 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
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
78460 67800 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4318 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31444 6001831.31402978 2100620.67337741 37.7480076719463 -122.436437569325 (37.7480076719463, -122.436437569325) 2 4 5 28862 22
88237 67807 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 6 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31458 6000311.37446381 2101639.91617819 37.7507197829758 -122.441766583241 (37.7507197829758, -122.441766583241) 2 4 5 28862 22
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
175473 48927 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1362 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/2002 12:00:00 AM     Permit Number 46117 6009515.72884218 2101239.2044667 37.7501396750607 -122.409908717805 (37.7501396750607, -122.409908717805) 2 4 7 28859 19
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
191550 71944 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1342 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1995 12:00:00 AM   3x3 Permit Number 50253 6008035.06455956 2100432.68279191 37.7478420534954 -122.414971880187 (37.7478420534954, -122.414971880187) 2 7 7 28859 2
25842 110182 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 339 ELSIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 776744 6006513.8 2097161.9 37.7387756178582 -122.420000276005 (37.7387756178582, -122.420000276005) 2 7 7 28859 2
110492 4166 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3771 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/18/1999 12:00:00 AM 3 3X3   6005390.77926 2100476.44824 37.747813278574 -122.424118813557 (37.747813278574, -122.424118813557) 2 4 5 28859 22
112047 66205 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 285 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1990 12:00:00 AM     Permit Number 29289 6010420.85602386 2100006.0506029 37.746804390663 -122.406691826217 (37.746804390663, -122.406691826217) 2 7 7 28859 2
64512 100205 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 4085 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/2012 12:00:00 AM 12 3x4 Permit Number 769140 6003091 2104064 37.7575337303282 -122.432327515179 (37.7575337303282, -122.432327515179) 2 4 5 28862 3
74715 68587 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 104 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/24/1994 12:00:00 AM     Permit Number 32485 6003450.61209517 2097770.88653532 37.7402746975659 -122.430634780555 (37.7402746975659, -122.430634780555) 2 7 5 63 7
164100 621 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3151 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/23/1992 12:00:00 AM 18 3X3   6007979.07595 2102079.24238 37.7523599891254 -122.415282029241 (37.7523599891254, -122.415282029241) 2 4 7 28859 19
21711 35380 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 528 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/14/2015 12:00:00 AM 4   Permit Number 775347 6011191.99901 2105854.03053 37.7629047676749 -122.404436841188 (37.7629047676749, -122.404436841188) 8 3 8 28856 29
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
112460 85491 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400 24th St   Sidewalk: Curb side : Cutout Tree Private 2   09/05/2007 12:00:00 AM   3x3 Permit Number 52154 6000641 2101716 37.7509474670616 -122.440632169404 (37.7509474670616, -122.440632169404) 2 4 5 28862 22
163035 99249 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 435 Paul Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2012 12:00:00 AM   3x3 Permit Number 769233 6012286.9 2091380.6 37.7232249352354 -122.399633675727 (37.7232249352354, -122.399633675727) 10 3 8 58 1
40188 64622 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 350 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1988 12:00:00 AM     Permit Number 25527 6006698.09280064 2104074.24597744 37.7577657327882 -122.419853436478 (37.7577657327882, -122.419853436478) 2 4 7 28859 19
102201 40735 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 84 Putnam St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1999 12:00:00 AM     Permit Number 41714 6009129.35799057 2096983.96477733 37.7384340613324 -122.410944305546 (37.7384340613324, -122.410944305546) 10 7 7 28859 2
152907 50801 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 466 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/11/2004 12:00:00 AM     Permit Number 47598 5997189.59146779 2093842.28323419 37.7291310061031 -122.451999409113 (37.7291310061031, -122.451999409113) 9 7 4 28861 40
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
176061 34654 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2000 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505) 1 8 3 56 35
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
114997 49998 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1101X 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014225.48172 2105233.17299 37.7613690835438 -122.393901534339 (37.7613690835438, -122.393901534339) 10 3 8 28856 29
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
71574 51838 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 135 Morse St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM 8   Permit Number 48065 6000803.77084 2087905.29553 37.7130357386885 -122.43907959427 (37.7130357386885, -122.43907959427) 9 7 6 28861 5
193047 88286 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51287 6007754 2106536 37.7645845697556 -122.416376026653 (37.7645845697556, -122.416376026653) 8 4 7 28859 19
41299 82715 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1379 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 11 3x3 Permit Number 52465 6016442.9825 2093699.9014 37.7298240779238 -122.385428311894 (37.7298240779238, -122.385428311894) 10 3 8 58 1
51084 82685 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 35 Jennings Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52459 6012802.99497586 2089176.16957459 37.7172007679129 -122.397695078281 (37.7172007679129, -122.397695078281) 10 3 8 58 1
98290 82840 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1379 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 13 3x3 Permit Number 52465 6016423.5899 2093711.7525 37.729855545757 -122.385496180523 (37.729855545757, -122.385496180523) 10 3 8 58 1
11289 34055 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
13922 34080 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
34216 34084 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
45490 34052 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
45906 34053 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 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
64915 34083 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
97320 34082 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
102795 34050 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
109210 34079 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 240 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551069 (37.7627561815899, -122.41623551069) 8 4 7 28859 19
135898 34049 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
136772 34047 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
149786 34054 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
160298 34051 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
181206 34048 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Alabama St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571698 (37.7645360636147, -122.41223571698) 8 4 7 28859 19
79613 83166 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1089 Gilman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52361 6015096.6014 2089812.1317 37.719074451264 -122.389811494874 (37.719074451264, -122.389811494874) 10 3 8 58 1
88233 83362 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3325 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2008 12:00:00 AM 5 3x3 Permit Number 51120 5982822.4546 2100126.935 37.7455535383912 -122.502131834041 (37.7455535383912, -122.502131834041) 1 8 3 29491 35
96948 37726 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2858 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/01/1998 12:00:00 AM     Permit Number 40090 6010246.00158069 2101670.73784629 37.7513654710612 -122.407413798897 (37.7513654710612, -122.407413798897) 2 4 7 28859 19
69699 31970 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1350 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1995 12:00:00 AM     Permit Number 35371 6009512.01927897 2101306.3823382 37.7503239226813 -122.409926287411 (37.7503239226813, -122.409926287411) 2 4 7 28859 19
7183 42736 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
112826 42735 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
118808 42738 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
137854 42733 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
155074 42737 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
159508 42739 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2155 Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.7125908452343 -122.400920338197 (37.7125908452343, -122.400920338197) 10 3 8 309 1
20538 42308 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377) 9 7 4 28861 40
89456 42310 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377) 9 7 4 28861 40
116195 42309 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 249 Edna St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377) 9 7 4 28861 40
81340 41897 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2500 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42262 6001987.05760353 2105790.14936536 37.762210660505 -122.436268917311 (37.762210660505, -122.436268917311) 15 4 5 28862 3
24028 84127 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 88 Mill St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50980 6010360.09243836 2089687.02520781 37.7184671339256 -122.406175049692 (37.7184671339256, -122.406175049692) 10 7 8 309 39
142005 83791 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 369 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50933 6008828.16902132 2097088.78446754 37.7387049796432 -122.411993079981 (37.7387049796432, -122.411993079981) 10 7 7 28859 2
1282 65048 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1994 12:00:00 AM     Permit Number 27001 6008641.92550277 2097033.56507471 37.7385429081789 -122.412633121744 (37.7385429081789, -122.412633121744) 10 7 7 28859 2
180994 60926 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2000 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/1983 12:00:00 AM 13 3x3 Permit Number 20727 5989507.2134 2106536.1763 37.7635420716385 -122.479486064031 (37.7635420716385, -122.479486064031) 1 8 3 56 35
31308 44007 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2701X 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 3 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
48136 44006 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2701X 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 4 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
122148 44008 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2701X 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
123956 44009 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2701X 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 1 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
186706 44011 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 405X Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on Florida 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
68761 40438 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 400 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/10/1999 12:00:00 AM     Permit Number 41530 6007160.84774193 2097270.742449 37.7391109088923 -122.417770796303 (37.7391109088923, -122.417770796303) 2 7 7 28859 2
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
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
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
84020 106777 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1177 De Haro St 2 Sidewalk: Property side : Cutout Tree Private 2   06/03/2014 12:00:00 AM 5   Permit Number 773142 6012265.00001 2102937.69671 37.7549570630325 -122.400520812589 (37.7549570630325, -122.400520812589) 10 3 8 28856 29
164698 106781 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1177 De Haro St 2 Sidewalk: Property side : Cutout Tree Private 2   06/03/2014 12:00:00 AM     Permit Number 773142 6012276.4 2102941.5 37.7549681417933 -122.400481655091 (37.7549681417933, -122.400481655091) 10 3 8 28856 29
152027 85242 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4331 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2019 12:00:00 AM 3   Permit Number 784317 5981385.546 2104841.9152 37.7584150182243 -122.507450124372 (37.7584150182243, -122.507450124372) 1 8 3 56 35
187747 85241 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4331 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2019 12:00:00 AM 3   Permit Number 784317 5981367.2124 2104841.304 37.7584122600662 -122.507513483633 (37.7584122600662, -122.507513483633) 1 8 3 56 35
51891 36793 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1350 Donner Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015250.697 2090820.757 37.7218524825898 -122.389349237476 (37.7218524825898, -122.389349237476) 10 3 8 58 1
103389 36792 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1350 Donner Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015166.6448 2090882.8824 37.7220184063671 -122.389644123655 (37.7220184063671, -122.389644123655) 10 3 8 58 1

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)
);