Street_Tree_List

Data source: data.sfgov.org

357 rows where qSpecies = 31 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
24481 24481 117708 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4001 Clement St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5983029.04687 2113077.7485700003 37.7811249212832 -122.50237578006501 (37.7811249212832, -122.502375780065)
157611 157611 136748 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 165 Marina Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 7ft   6002698.42353 2121575.97678 37.80559494132721 -122.43493757052299 (37.8055949413272, -122.434937570523)
164340 164340 117703 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4001 Clement St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 7ft   5983084.790030001 2113081.26685 37.7811378565893 -122.502183200126 (37.7811378565893, -122.502183200126)
28350 28350 215435 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 271 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5999640.40097 2095213.2119999998 37.7330353327146 -122.443625232838 (37.7330353327146, -122.443625232838)
35762 35762 241219 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6003095.93223 2100399.3712299997 37.7474718059861 -122.432048772745 (37.7474718059861, -122.432048772745)
40655 40655 197995 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014417.48937 2089293.51791 37.717612756412 -122.392122692435 (37.717612756412, -122.392122692435)
42049 42049 197980 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6012727.8948800005 2104659.33214 37.759710101458204 -122.399040815374 (37.7597101014582, -122.399040815374)
44751 44751 197981 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6012726.35291 2104657.30852 37.759704459115795 -122.39904600628 (37.7597044591158, -122.39904600628)
49851 49851 197983 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1809 19th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012297.3164 2105130.82765 37.760980720296295 -122.400563103211 (37.7609807202963, -122.400563103211)
50962 50962 179971 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 160 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
59883 59883 179956 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   5998852.5351599995 2088480.84158 37.7145048379104 -122.44586505733999 (37.7145048379104, -122.44586505734)
64095 64095 179955 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   5998862.1125 2088471.1679599998 37.7144788232093 -122.445831259031 (37.7144788232093, -122.445831259031)
64723 64723 215414 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5997954.5929 2094069.3346400002 37.7297982247933 -122.449371101191 (37.7297982247933, -122.449371101191)
66969 66969 241217 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6003092.5802 2100398.11558 37.7474681682247 -122.432060274186 (37.7474681682247, -122.432060274186)
129978 129978 136740 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1920 Beach St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6000976.885419999 2121020.42839 37.8039716578185 -122.44085530385 (37.8039716578185, -122.44085530385)
135983 135983 241218 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6003089.92025 2100398.1705 37.7474681682179 -122.43206947603399 (37.7474681682179, -122.432069476034)
151710 151710 197982 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012729.113 2104654.63686 37.759697277132204 -122.39903627291001 (37.7596972771322, -122.39903627291)
158174 158174 241187 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 45 Hoff St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6006570.58835 2106391.73918 37.7641218444722 -122.420458896575 (37.7641218444722, -122.420458896575)
166118 166118 215413 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5997941.5079 2094069.28168 37.7297973308762 -122.44941633348999 (37.7297973308762, -122.44941633349)
170469 170469 197997 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6014474.56871 2089262.00767 37.717529404523795 -122.391923191299 (37.7175294045238, -122.391923191299)
173562 173562 241186 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 45 Hoff St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6006573.70754 2106363.42565 37.764044277946205 -122.42044609832399 (37.7640442779462, -122.420446098324)
178127 178127 197992 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014311.92 2089359.19845 37.717787240171795 -122.392492192366 (37.7177872401718, -122.392492192366)
178543 178543 197994 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6014370.9162 2089321.9827 37.717688329142604 -122.392285665748 (37.7176883291426, -122.392285665748)
182005 182005 197998 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014511.88744 2089238.1825599999 37.717466057201705 -122.391792531525 (37.7174660572017, -122.391792531525)
182308 182308 197996 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6014434.42252 2089286.69966 37.7175949749992 -122.392063685205 (37.7175949749992, -122.392063685205)
184240 184240 197993 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6014330.76175 2089346.27019 37.7177527880479 -122.392426160549 (37.7177527880479, -122.392426160549)
48849 48849 198000 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 828x Jamestown Ave 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   6014844.30096 2089001.4675099999 37.7168345316683 -122.390626989449 (37.7168345316683, -122.390626989449)
55123 55123 198002 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 860x Jamestown Ave 13 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   6014610.54339 2089241.6149400002 37.717480958049 -122.39145176041 (37.717480958049, -122.39145176041)
55655 55655 198001 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 860x Jamestown Ave 1 Median : Cutout 11 Tree 1 DPW 2     9 Width 5ft   6014795.93259 2089063.22643 37.7170014260431 -122.390798490171 (37.7170014260431, -122.390798490171)
132906 132906 198004 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 920x Jamestown Ave 12 Median : Cutout 11 Tree 1 DPW 2     10 Width 5ft   6014389.315880001 2089371.37328 37.7178249676301 -122.39222551819401 (37.7178249676301, -122.392225518194)
153492 153492 136750 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1124 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6007528.1043 2119564.5184299997 37.8003450211571 -122.41808104771299 (37.8003450211571, -122.418081047713)
162886 162886 197999 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 828 Jamestown Ave 1 : 4 Tree 1 Private 1     10 Width 5ft   6014890.34253 2088931.57147 37.7166451650195 -122.39046296391399 (37.7166451650195, -122.390462963914)
178207 178207 198003 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 920x Jamestown Ave 1 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   6014527.01214 2089285.60779 37.7175971171782 -122.391743566112 (37.7175971171782, -122.391743566112)
26722 26722 136742 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000053.33945 2118542.13589 37.79711428765071 -122.443873120143 (37.7971142876507, -122.443873120143)
27397 27397 241185 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3781 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
27899 27899 136747 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2859 Filbert St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5999233.55999 2118349.36625 37.796538199022606 -122.446695870812 (37.7965381990226, -122.446695870812)
35806 35806 136746 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000043.09421 2118605.60705 37.7972879782152 -122.44391313370501 (37.7972879782152, -122.443913133705)
37691 37691 136745 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000044.84961 2118592.59728 37.797252356970205 -122.44390612438801 (37.7972523569702, -122.443906124388)
39697 39697 241201 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 26 Carl St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998490.815219999 2107264.4937400003 37.7660595705173 -122.44846722318898 (37.7660595705173, -122.448467223189)
42490 42490 241188 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 419 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6007442.12211 2107229.45736 37.7664710984984 -122.417503881697 (37.7664710984984, -122.417503881697)
44646 44646 119965 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 518 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5987217.06494 2112373.1551 37.7794354929176 -122.48783573328801 (37.7794354929176, -122.487835733288)
51602 51602 197989 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 28 15th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6012209.71616 2107476.11774 37.7674154774686 -122.401030868501 (37.7674154774686, -122.401030868501)
51881 51881 197988 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 82 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6012221.12319 2107462.35445 37.7673783228879 -122.40099044576 (37.7673783228879, -122.40099044576)
66988 66988 179969 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 623 Goettingen St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6010613.39722 2091824.0219599998 37.7243490517445 -122.40544989510599 (37.7243490517445, -122.405449895106)
67671 67671 197984 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1177 De Haro St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   6012264.79545 2102939.83963 37.754962935614294 -122.40052167053999 (37.7549629356143, -122.40052167054)
70744 70744 179963 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255)
71330 71330 179970 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 307 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
73993 73993 241200 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 26 Carl St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5998502.5017 2107263.12139 37.7660564705643 -122.448426703328 (37.7660564705643, -122.448426703328)
109031 109031 136743 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   6000050.877859999 2118557.23395 37.7971556025074 -122.44388272313 (37.7971556025074, -122.44388272313)
149959 149959 197978 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1100 Mariposa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6013947.00765 2106209.45605 37.764034263084504 -122.394933045925 (37.7640342630845, -122.394933045925)
151347 151347 136741 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000055.17715 2118534.1134099998 37.797092364871794 -122.44386618458701 (37.7970923648718, -122.443866184587)
162849 162849 241205 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2389 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6008219.00846 2104543.8944099997 37.7591408449879 -122.414626698671 (37.7591408449879, -122.414626698671)
173632 173632 241206 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2387 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6008217.68506 2104568.2265 37.759207580982 -122.414632997525 (37.759207580982, -122.414632997525)
174334 174334 241198 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 106 Chattanooga St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6004702.81282 2102995.20065 37.754690319613296 -122.426677105059 (37.7546903196133, -122.426677105059)
175277 175277 241199 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 24 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5998508.2304 2107266.01278 37.7660647371231 -122.448407097228 (37.7660647371231, -122.448407097228)
178056 178056 136744 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2906 Broderick St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000047.06944 2118581.72583 37.7972226334754 -122.44389766175101 (37.7972226334754, -122.443897661751)
178574 178574 241189 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 415 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6007440.26209 2107242.97401 37.7665081073951 -122.41751127324 (37.7665081073951, -122.41751127324)
181600 181600 241204 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2399 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6008220.32471 2104519.20022 37.759073114347295 -122.414620398932 (37.7590731143473, -122.414620398932)
187402 187402 179964 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002952.82685 2087126.8782400002 37.7110204227269 -122.431596206017 (37.7110204227269, -122.431596206017)
188676 188676 241203 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2399 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6008221.76709 2104500.66986 37.759022315257894 -122.414614099173 (37.7590223152579, -122.414614099173)
76 76 241180 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 3 Front Yard : Yard 7 Tree 1 Private 1   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)
82 82 241178 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 1 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.3896699995 2108410.1055900003 37.769563595403106 -122.42674254153299 (37.7695635954031, -122.426742541533)
90 90 241179 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 2 Front Yard : Yard 7 Tree 1 Private 1   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)
91 91 241181 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 4 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.3052900005 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397)
23598 23598 179958 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6011915.65824 2087516.33041 37.7125937299935 -122.40064566366999 (37.7125937299935, -122.40064566367)
25124 25124 241190 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2858 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010222.306919999 2101664.86224 37.7513480117 -122.407495323966 (37.7513480117, -122.407495323966)
27219 27219 215426 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
28207 28207 179962 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 299 Lathrop Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6012155.6977 2086855.9290099998 37.710793783685006 -122.39976966465599 (37.710793783685, -122.399769664656)
29979 29979 241228 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 128 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003596.19295 2097670.1680900003 37.740006394279796 -122.43012423703699 (37.7400063942798, -122.430124237037)
31251 31251 241193 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010149.76354 2105082.07302 37.7607268479899 -122.40798714698299 (37.7607268479899, -122.407987146983)
32139 32139 215423 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993769.4086 2092813.96021 37.72611098282629 -122.46374856183998 (37.7261109828263, -122.46374856184)
33234 33234 215420 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2085 09th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
34328 34328 241212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009052.89196 2106353.81264 37.7641572813666 -122.411870616529 (37.7641572813666, -122.411870616529)
34372 34372 241223 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009004.56515 2106399.07167 37.7642788409211 -122.41204096432699 (37.7642788409211, -122.412040964327)
35031 35031 241196 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010370.46966 2100029.8165599997 37.7468668275408 -122.406867732983 (37.7468668275408, -122.406867732983)
37345 37345 197979 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012714.266419999 2104668.82572 37.759735409279706 -122.39908861614599 (37.7597354092797, -122.399088616146)
37469 37469 241216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 6 Fountain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6000321.631 2101619.05614 37.7506630907493 -122.44172961845301 (37.7506630907493, -122.441729618453)
39377 39377 241220 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009102.18096 2106403.8524599997 37.7642974442959 -122.41170367540899 (37.7642974442959, -122.411703675409)
47759 47759 241195 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010149.3192300005 2105113.8429400004 37.7608140561404 -122.407990924146 (37.7608140561404, -122.407990924146)
50744 50744 197985 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 669 Mississippi St 2 : 4 Tree 1 Private 1     9 Width 3ft   6014155.897999999 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116)
51116 51116 179953 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 240 Peabody St 1 : 4 Tree 1 Private 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
56645 56645 247209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6001860.515269999 2108286.6653 37.7690582897368 -122.436885307832 (37.7690582897368, -122.436885307832)
56686 56686 241210 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009103.79641 2106355.71742 37.764165367153204 -122.41169468665899 (37.7641653671532, -122.411694686659)
58250 58250 215427 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993797.5326 2092869.7349099999 37.726265747145604 -122.463655385788 (37.7262657471456, -122.463655385788)
59497 59497 215415 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 484 Faxon Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5994798.18805 2091784.9127099998 37.7233446951982 -122.460117638125 (37.7233446951982, -122.460117638125)
59765 59765 241209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6009128.3617 2106356.68814 37.76416941052621 -122.411609790669 (37.7641694105262, -122.411609790669)
60020 60020 241221 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009078.922 2106403.19833 37.764294343422996 -122.411784075669 (37.764294343423, -122.411784075669)
60023 60023 241192 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3630 20th St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6006049.00576 2104357.91631 37.7585080370469 -122.42211840383499 (37.7585080370469, -122.422118403835)
65029 65029 241191 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3630 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006057.8545699995 2104359.21039 37.7585120893797 -122.42208789256901 (37.7585120893797, -122.422087892569)
65216 65216 136751 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1142 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6007453.51921 2119553.70533 37.8003111329029 -122.41833837521999 (37.8003111329029, -122.41833837522)
68564 68564 241227 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 104 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003479.820730001 2097757.7557200002 37.7402402980644 -122.430532852122 (37.7402402980644, -122.430532852122)
69860 69860 241226 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 102 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6003452.26052 2097778.5444 37.740295817689294 -122.43062962727 (37.7402958176893, -122.43062962727)
72724 72724 247212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6001824.5154099995 2108284.91798 37.7690514458872 -122.437009703838 (37.7690514458872, -122.437009703838)
74241 74241 241197 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010385.48006 2100017.65971 37.7468342873856 -122.406814971529 (37.7468342873856, -122.406814971529)
76250 76250 215428 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5993651.19736 2093024.90181 37.7266833644367 -122.464172514845 (37.7266833644367, -122.464172514845)
122229 122229 123216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 654 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993193.61084 2111027.91211 37.7760886204879 -122.46706267834298 (37.7760886204879, -122.467062678343)
128240 128240 215433 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993594.89235 2092910.6701200001 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875)
130161 130161 215412 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1407 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5991770.8881 2105805.69837 37.7616676000029 -122.471603571552 (37.7616676000029, -122.471603571552)
131633 131633 241213 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009032.16938 2106352.76347 37.76415323799171 -122.411942216073 (37.7641532379917, -122.411942216073)
132120 132120 241214 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009008.65245 2106350.93983 37.764146911276704 -122.41202342575899 (37.7641469112767, -122.412023425759)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 109.668ms · Data source: data.sfgov.org