420 rows where qSpecies_id = 116 sorted by rowid descending

View and edit SQL

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)
150208 101279 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2301 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5988600.1162 2106446.7223 37.7632437243179 -122.482616832407 (37.7632437243179, -122.482616832407) 1 8 3 56 35
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
149347 101281 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2049 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5989322.9543 2106470.5284 37.7633511157788 -122.480118545713 (37.7633511157788, -122.480118545713) 1 8 3 56 35
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
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
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
145354 199656 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1395 Donner Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6015030.8215 2090912.727 37.7220928214053 -122.390115718832 (37.7220928214053, -122.390115718832) 10 3 8 58 1
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
145108 28414 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 600X Monterey Blvd 3 Median : Cutout Tree DPW 1   02/02/2003 12:00:00 AM 12 5   5998107.3609693 2094732.8027768 37.7316286888145 -122.448890739326 (37.7316286888145, -122.448890739326) 9 7 4 59 40
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
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
143055 49075 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1970 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093) 9 8 4 59 40
142699 52313 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400HOFFMAN 24th St 3 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
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
142362 52312 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 4400HOFFMAN 24th St 2 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
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
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
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
141092 101260 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1900 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5989805.9135 2106546.133 37.7635867556905 -122.478453694684 (37.7635867556905, -122.478453694684) 1 8 3 56 35
140476 258418 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1839 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5990060 2106509 37.7634995462716 -122.477572184802 (37.7634995462716, -122.477572184802) 1 8 3 56 35
139845 107411 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 3634 20th St 2 Sidewalk: Curb side : Pot Tree Private 2       3x3   6006068 2104353 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883) 2 4 5 28859 19
138796 241213 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2801 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009032.16938 2106352.76347 37.7641532379917 -122.411942216073 (37.7641532379917, -122.411942216073) 8 4 7 28859 19
137988 56678 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2400 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5988274.3719 2106490.5517 37.7633451115211 -122.483746674042 (37.7633451115211, -122.483746674042) 1 8 3 56 35
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
137609 179961 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 299 Lathrop Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012198.83214 2086842.9214 37.7107604718955 -122.399619668515 (37.7107604718955, -122.399619668515) 10 3 8 309 1
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
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
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
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
135749 100964 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2425 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5988206.1929 2106434.2769 37.7631866273281 -122.483978353246 (37.7631866273281, -122.483978353246) 1 8 3 56 35
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
132359 215424 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 15 Fairfield Way 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993760.13704 2092800.2871 37.7260729055276 -122.463779620842 (37.7260729055276, -122.463779620842) 9 8 4 59 40
130983 94950 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
130970 197985 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 669 Mississippi St 2 : Tree Private 2     9 Width 3ft   6014155.898 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116) 10 3 8 28856 29
130858 241218 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4130 Cesar Chavez St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6003089.92025 2100398.1705 37.7474681682179 -122.432069476034 (37.7474681682179, -122.432069476034) 2 4 5 63 22
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
130674 101284 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2034 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5989388.4992 2106533.1127 37.7635267635243 -122.479896429915 (37.7635267635243, -122.479896429915) 1 8 3 56 35
130221 241187 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 45 Hoff St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6006570.58835 2106391.73918 37.7641218444722 -122.420458896575 (37.7641218444722, -122.420458896575) 8 4 7 28859 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
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
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
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
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
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
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
128873 215423 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 15 Fairfield Way 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993769.4086 2092813.96021 37.7261109828263 -122.46374856184 (37.7261109828263, -122.46374856184) 9 8 4 59 40
128857 181647 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1810 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5990056.3621 2106554.5578 37.763624424605 -122.477588097139 (37.763624424605, -122.477588097139) 1 8 3 56 35
127993 241196 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 285 Mullen Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010370.46966 2100029.81656 37.7468668275408 -122.406867732983 (37.7468668275408, -122.406867732983) 2 7 7 28859 2
127894 97338 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1917 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5989797.6411 2106487.0994 37.7634241851075 -122.478477988866 (37.7634241851075, -122.478477988866) 1 8 3 56 35
127663 258439 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2341 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988410 2106416 37.7631483069578 -122.483272121252 (37.7631483069578, -122.483272121252) 1 8 3 56 35
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
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
125141 182441 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1529 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5985572.6922 2104787.172 37.7585104674539 -122.492965288536 (37.7585104674539, -122.492965288536) 1 8 3 56 35
124668 181320 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2126 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5989173 2106514 37.7634617628894 -122.480640365287 (37.7634617628894, -122.480640365287) 1 8 3 56 35
124610 197995 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 881 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6014417.48937 2089293.51791 37.717612756412 -122.392122692435 (37.717612756412, -122.392122692435) 10 3 8 58 1
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
124283 246465 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 220 Duncan St 1 : Tree Private 2     10 Width 3ft   6005035.80445 2099919.28541 37.7462633887397 -122.425306657892 (37.7462633887397, -122.425306657892) 2 7 5 63 22
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
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
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
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
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
121022 241220 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2800 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009102.18096 2106403.85246 37.7642974442959 -122.411703675409 (37.7642974442959, -122.411703675409) 8 4 7 28859 19
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
120616 179966 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 716 Peru Ave 4 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6005255.40982 2092462.48384 37.725801087223 -122.424017104714 (37.725801087223, -122.424017104714) 9 7 6 309 5
119624 182028 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2219 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5988830 2106432 37.7632166722568 -122.481820671399 (37.7632166722568, -122.481820671399) 1 8 3 56 35
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
118475 100963 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2495 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5988177 2106369 37.763005695226 -122.484074533324 (37.763005695226, -122.484074533324) 1 8 3 56 35
117606 215439 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 217 Staples Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5998709.41817 2093777.72882 37.729040692553 -122.44674062198 (37.729040692553, -122.44674062198) 9 7 4 28861 40
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
116325 258433 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2555 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987757 2106384 37.7630224196739 -122.485528252067 (37.7630224196739, -122.485528252067) 1 8 3 56 35
116314 258437 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2435 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988177 2106369 37.763005695226 -122.484074533324 (37.763005695226, -122.484074533324) 1 8 3 56 35
116276 258428 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2154 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989006 2106545 37.7635371731016 -122.481220228107 (37.7635371731016, -122.481220228107) 1 8 3 56 35
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
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
115769 258422 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1916 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989767 2106571 37.7636527745423 -122.478590101352 (37.7636527745423, -122.478590101352) 1 8 3 56 35
115633 16314 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 758X Monterey Blvd 6 Median : Cutout Tree DPW 1   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.452476180169 (37.7316364140758, -122.452476180169) 9 7 4 59 40
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
114591 258438 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 2425 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988206.1929 2106434.2769 37.7631866273281 -122.483978353246 (37.7631866273281, -122.483978353246) 1 8 3 56 35
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
114123 36797 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1350 Donner Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015213.5435 2090847.5562 37.7219240080036 -122.389479539312 (37.7219240080036, -122.389479539312) 10 3 8 58 1
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
114053 181367 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 4019 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5982046.1498 2105540.3564 37.7603716302877 -122.505217265817 (37.7603716302877, -122.505217265817) 1 8 3 56 35
113741 117606 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 420 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.435214539817 (37.7622721434766, -122.435214539817) 15 4 5 28862 3
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
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
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
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
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
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
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
111371 255520 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 77 Belgrave Ave   Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 781419 5998149.61527 2104897.27011 37.7595402565853 -122.449476776674 (37.7595402565853, -122.449476776674) 15 5 11 28862 12
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
110955 49074 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 1970 Ocean Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093) 9 8 4 59 40
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
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
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
109574 215417 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 286 Orizaba Ave 2 Sidewalk: Curb side : Pot Tree Private 2     12     5994025.97554 2088461.57938 37.7141751725286 -122.462546063947 (37.7141751725286, -122.462546063947) 9 8 6 28861 24
109219 241183 DPW Maintained 1 Trachycarpus fortunei :: Windmill Palm 116 1720 Dolores St 5 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6005264.11037 2098316.58265 37.7418756279601 -122.424403226839 (37.7418756279601, -122.424403226839) 2 7 5 63 7
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

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