175 rows where SiteOrder = 1 and qSpecies_id = 116 sorted by Zip Codes

View and edit SQL

SiteOrder

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)
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
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
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
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
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
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
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
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
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
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
61309 67821 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 669 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1993 12:00:00 AM     Permit Number 31477 6014155.20534869 2104021.00071857 37.7580368157249 -122.394059730987 (37.7580368157249, -122.394059730987) 10 3 8 28856 29
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
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
129318 197986 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 498 Mississippi St 1 : Tree Private 2     10 Width 3ft   6014051.93568 2104880.86729 37.7603920825505 -122.394477092339 (37.7603920825505, -122.394477092339) 10 3 8 28856 29
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
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
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
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
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
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
7744 225194 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 778605 6007219.63733 2103836.19178 37.7571414587344 -122.418032839538 (37.7571414587344, -122.418032839538) 2 4 7 28859 19
8894 63236 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 3634 20th St 1 Sidewalk: Curb side : Pot Tree Private 2 FUF 01/13/1987 12:00:00 AM 12   Permit Number 23784 6006063.67565171 2104362.69748074 37.7585219924343 -122.422068008351 (37.7585219924343, -122.422068008351) 2 4 5 28859 19
12705 66435 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 154 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2016 12:00:00 AM 3   Permit Number 776442 6005832.64379623 2096619.46427693 37.7372478105316 -122.422316867971 (37.7372478105316, -122.422316867971) 2 7 7 28859 2
13706 225187 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
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
29945 241206 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2387 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008217.68506 2104568.2265 37.759207580982 -122.414632997525 (37.759207580982, -122.414632997525) 2 4 7 28859 19
34621 241182 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1362 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009519.86871 2101254.76714 37.7501826387226 -122.409895500292 (37.7501826387226, -122.409895500292) 2 4 7 28859 19
36520 241186 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 45 Hoff St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6006573.70754 2106363.42565 37.7640442779462 -122.420446098324 (37.7640442779462, -122.420446098324) 8 4 7 28859 19
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
68364 241215 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2801 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008984.20306 2106349.91543 37.7641427267158 -122.412107917041 (37.7641427267158, -122.412107917041) 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
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
87387 241193 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 699 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6010149.76354 2105082.07302 37.7607268479899 -122.407987146983 (37.7607268479899, -122.407987146983) 10 4 8 28859 19
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
100358 4167 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3781 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/04/1993 12:00:00 AM 12 3X3   6005338.8489102 2100470.98597 37.7477953482432 -122.424297997893 (37.7477953482432, -122.424297997893) 2 4 5 28859 22
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
110288 241190 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2858 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010222.30692 2101664.86224 37.7513480117 -122.407495323966 (37.7513480117, -122.407495323966) 2 4 7 28859 19
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
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
129179 241191 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 3630 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006057.85457 2104359.21039 37.7585120893797 -122.422087892569 (37.7585120893797, -122.422087892569) 2 4 5 28859 19
129697 98644 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 2391 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008222 2104509 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143) 2 4 7 28859 19
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
142402 99104 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 3644 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006000.9 2104423 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469) 2 4 5 28859 19
147565 47560 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45422 6007250.69827751 2103936.71356757 37.7574192165742 -122.41793254418 (37.7574192165742, -122.41793254418) 2 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
152787 241202 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 154 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005836.15299 2096624.27881 37.7372612281114 -122.42230507703 (37.7372612281114, -122.42230507703) 2 7 7 28859 2
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
169340 255617 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 350 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006699 2104069 37.7577513796565 -122.419849926759 (37.7577513796565, -122.419849926759) 2 4 7 28859 19
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
176157 63531 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 645 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1987 12:00:00 AM     Permit Number 24143 6007924.14567941 2104175.72058203 37.7581133535123 -122.415620410353 (37.7581133535123, -122.415620410353) 2 4 7 28859 19
178255 241205 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2389 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6008219.00846 2104543.89441 37.7591408449879 -122.414626698671 (37.7591408449879, -122.414626698671) 2 4 7 28859 19
181127 241203 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2399 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008221.76709 2104500.66986 37.7590223152579 -122.414614099173 (37.7590223152579, -122.414614099173) 2 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
190621 63542 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 2389 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1987 12:00:00 AM     Permit Number 24157 6008220.8181992 2104530.13411616 37.7591031640479 -122.414619465951 (37.7591031640479, -122.414619465951) 2 4 7 28859 19
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
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
2544 49162 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 804 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.459789497745 (37.7277062535492, -122.459789497745) 9 7 4 28861 40
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
48118 179956 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 78 Sala Ter 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 6ft   5998852.53516 2088480.84158 37.7145048379104 -122.44586505734 (37.7145048379104, -122.44586505734) 9 7 6 28861 25
51525 161041 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 200 Munich St 1 Sidewalk: Property side : Cutout Tree Private 2   01/05/2018 12:00:00 AM 3 Width 0ft Permit Number 781115 6004713.602 2091215.63937 37.722346921643 -122.425801386648 (37.722346921643, -122.425801386648) 9 7 6 28861 5
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
110970 65602 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 114 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1990 12:00:00 AM 13   Permit Number 28504 6004165.03379 2093741.91359 37.729252495484 -122.427877581308 (37.729252495484, -122.427877581308) 9 7 6 28861 5
117066 179963 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 85 South Hill Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255) 9 7 6 28861 5
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
155667 47386 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 400 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2002 12:00:00 AM     Permit Number 45302 5998534.7421818 2087640.83447452 37.7121802187249 -122.446903063491 (37.7121802187249, -122.446903063491) 9 7 6 28861 25
171280 215416 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 286 Orizaba Ave 1 Sidewalk: Curb side : Pot Tree Private 2     12     5994027.68196 2088444.22736 37.7141276262766 -122.462538908049 (37.7141276262766, -122.462538908049) 9 8 6 28861 24
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
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
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
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
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
91363 241216 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 6 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6000321.631 2101619.05614 37.7506630907493 -122.441729618453 (37.7506630907493, -122.441729618453) 2 4 5 28862 22
111657 241225 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4049 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6001920.58101 2105839.72544 37.7623430070574 -122.436502382779 (37.7623430070574, -122.436502382779) 15 5 5 28862 3
133818 52311 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400HOFFMAN 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281) 2 4 5 28862 22
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
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
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
4646 215421 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2085 09th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993516.19097 2101401.96684 37.7496769094628 -122.465247440321 (37.7496769094628, -122.465247440321) 1 8 4 29491 40
24867 215411 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1939 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5991245.12391 2102202.13663 37.7517427376545 -122.473159145982 (37.7517427376545, -122.473159145982) 1 8 4 29491 12
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
142119 183595 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2639 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5989548.2713 2097387.6993 37.7384251583472 -122.478674965089 (37.7384251583472, -122.478674965089) 1 8 3 29491 35
60671 103568 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 223 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5997125.5 2106655.6 37.7643095465843 -122.453145590268 (37.7643095465843, -122.453145590268) 15 5 11 29492 12
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
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
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
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
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
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
33886 179953 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 240 Peabody St 1 : Tree Private 2     17 Width 3ft   6009701.77248 2086128.1297 37.7086582895102 -122.408199733244 (37.7086582895102, -122.408199733244) 9 7 8 309 39
144411 179957 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 162 Tunnel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011927.16714 2087557.34531 37.7127069906044 -122.400608764476 (37.7127069906044, -122.400608764476) 10 3 8 309 1
147492 254374 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 343 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/2018 12:00:00 AM 3 3x3 Permit Number 781359 6010747.56272 2091896.11912 37.7245545163839 -122.404991175416 (37.7245545163839, -122.404991175416) 10 3 7 309 28
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
174362 179954 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 40 Tomaso Ct 1 : Tree Private 2     23 Width 2ft   6009197.20014 2086405.9588 37.709392885454 -122.409963207553 (37.709392885454, -122.409963207553) 9 7 8 309 39
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
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
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
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
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

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