Street_Tree_List

Data source: data.sfgov.org

357 rows where qSpecies = 31 sorted by rowid descending

View and edit SQL

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
189124 179961 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 299 Lathrop Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6012198.832140001 2086842.9214 37.7107604718955 -122.399619668515 (37.7107604718955, -122.399619668515)
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)
188528 246216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 725 Buena Vista Ave West 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5999835.3063 2107870.2944 37.7677997276311 -122.443860441452 (37.7677997276311, -122.443860441452)
188473 215418 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10     5994025.68496 2088506.9373700002 37.7142996980529 -122.462550356439 (37.7142996980529, -122.462550356439)
188342 70057 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1799 Revere Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/18/1990 12:00:00 AM 12     6014037.2583099995 2095146.8497099997 37.7336637097057 -122.393846481427 (37.7336637097057, -122.393846481427)
188005 215430 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993628.724219999 2092981.5344200002 37.72656299287289 -122.464247056069 (37.7265629928729, -122.464247056069)
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)
186902 197986 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 498 Mississippi St 1 : 4 Tree 1 Private 1     10 Width 3ft   6014051.93568 2104880.86729 37.7603920825505 -122.394477092339 (37.7603920825505, -122.394477092339)
186537 182441 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1529 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5985572.6922 2104787.172 37.7585104674539 -122.492965288536 (37.7585104674539, -122.492965288536)
185878 50830 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 621 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/2004 12:00:00 AM 9   Permit Number 47349 6000535.8217 2111139.1847 37.7768152106013 -122.441672069607 (37.7768152106013, -122.441672069607)
185349 179968 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 675 Silver Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 2ft   6005852.39602 2093589.2328700002 37.7289285803821 -122.422033372066 (37.7289285803821, -122.422033372066)
185205 179966 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 716 Peru Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   6005255.40982 2092462.4838400001 37.725801087223 -122.424017104714 (37.725801087223, -122.424017104714)
184272 241184 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1720 Dolores St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6005265.18206 2098303.13157 37.7418387548635 -122.424398564767 (37.7418387548635, -122.424398564767)
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)
184005 197977 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1301 Minnesota St 73 Front Yard : Yard 7 Tree 1 Private 1     3     6015364.560269999 2102275.50149 37.7533111867689 -122.389755314382 (37.7533111867689, -122.389755314382)
183227 43754 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 367 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2000 12:00:00 AM 14   Permit Number 43390 5991197.85001 2112958.02747 37.781272787853 -122.474107339564 (37.781272787853, -122.474107339564)
182516 215434 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993586.39661 2092891.1654599998 37.7263124219742 -122.464386821508 (37.7263124219742, -122.464386821508)
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)
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)
181948 215424 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993760.13704 2092800.2871 37.7260729055276 -122.463779620842 (37.7260729055276, -122.463779620842)
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)
180078 241183 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1720 Dolores St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6005264.11037 2098316.58265 37.7418756279601 -122.424403226839 (37.7418756279601, -122.424403226839)
179138 36792 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015166.6448 2090882.8824 37.7220184063671 -122.38964412365499 (37.7220184063671, -122.389644123655)
178635 182656 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5985872.0635 2102330.847 37.7517835760889 -122.491749119446 (37.7517835760889, -122.491749119446)
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)
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)
178324 215437 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   5998668.44451 2093778.0926299999 37.729039350777 -122.44688229669701 (37.729039350777, -122.446882296697)
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)
178204 197987 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2 Bridgeview Dr 4 Front Yard : Yard 7 Tree 1 Private 1     9     6014076.35565 2095353.09382 37.734232186468894 -122.39372574026501 (37.7342321864689, -122.393725740265)
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)
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)
175537 136749 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1360 Jones St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6008500.72583 2117239.96883 37.794017078290295 -122.41455079677701 (37.7940170782903, -122.414550796777)
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)
174472 36791 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015186.7443 2090870.701 37.7219860731406 -122.389573793771 (37.7219860731406, -122.389573793771)
174371 179957 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6011927.1671400005 2087557.3453099998 37.7127069906044 -122.40060876447599 (37.7127069906044, -122.400608764476)
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)
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)
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)
173453 106777 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1177 De Haro St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/03/2014 12:00:00 AM 5   Permit Number 773142 6012265.00001 2102937.69671 37.7549570630325 -122.400520812589 (37.7549570630325, -122.400520812589)
172140 115615 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 4x4   6012069.0366 2107045.8512 37.766226213653 -122.40148722008699 (37.766226213653, -122.401487220087)
171952 241182 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1362 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009519.86871 2101254.76714 37.7501826387226 -122.409895500292 (37.7501826387226, -122.409895500292)
171456 35380 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 528 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/14/2015 12:00:00 AM 4   Permit Number 775347 6011191.999009999 2105854.03053 37.7629047676749 -122.40443684118799 (37.7629047676749, -122.404436841188)
170472 241215 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6008984.20306 2106349.91543 37.7641427267158 -122.412107917041 (37.7641427267158, -122.412107917041)
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)
168702 241202 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 154 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6005836.15299 2096624.2788099998 37.7372612281114 -122.42230507703 (37.7372612281114, -122.42230507703)
168300 215431 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993618.37614 2092959.3845099998 37.726501578172396 -122.464281221309 (37.7265015781724, -122.464281221309)
167445 215432 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993607.07382 2092934.5708400002 37.7264327944236 -122.464318491921 (37.7264327944236, -122.464318491921)
166782 36797 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015213.5435 2090847.5562 37.721924008003604 -122.389479539312 (37.7219240080036, -122.389479539312)
166443 241208 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009151.461180001 2106358.27771 37.7641750708383 -122.41153000822901 (37.7641750708383, -122.411530008229)
166430 179960 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6011897.9450900005 2087458.38855 37.7124336452757 -122.400702818282 (37.7124336452757, -122.400702818282)
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)
164853 215422 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993781.00975 2092831.61045 37.7261601145848 -122.46370973814 (37.7261601145848, -122.46370973814)
164851 247521 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1101 Waller St 2 Side Yard : Yard 17 Tree 1 Private 1     5     6000007.86979 2108477.01107 37.7694754609529 -122.443307149811 (37.7694754609529, -122.443307149811)
164545 82366 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 31 51 Princeton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
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)
163040 82715 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1379 Quesada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2009 12:00:00 AM 11 3x3 Permit Number 52465 6016442.9825 2093699.9014 37.7298240779238 -122.385428311894 (37.7298240779238, -122.385428311894)
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)
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)
162786 143059 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 440 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6010738.656 2120349.8129 37.8026814253217 -122.40702659346701 (37.8026814253217, -122.407026593467)
160919 241224 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 44 Museum Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000710.17183 2106760.2697 37.764801739133205 -122.44075476054701 (37.7648017391332, -122.440754760547)
160717 197991 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3419 Jennings St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013294.96544 2089742.68292 37.7187836844998 -122.396034235213 (37.7187836844998, -122.396034235213)
160212 63573 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1500@Polk Broadway 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 49344 6006306.38676 2118003.57118 37.795990216032294 -122.422197721351 (37.7959902160323, -122.422197721351)
160016 241207 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1142 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007609.4952 2103000.12596 37.754867747762795 -122.41662533218701 (37.7548677477628, -122.416625332187)
159970 124330 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 130 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995934.0004900005 2113471.95009 37.782957097905395 -122.457759890544 (37.7829570979054, -122.457759890544)
159781 197990 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 155 Grace St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6008384.453919999 2110216.9376 37.774726996282 -122.414455930021 (37.774726996282, -122.414455930021)
159390 246465 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 220 Duncan St 1 : 4 Tree 1 Private 1     10 Width 3ft   6005035.80445 2099919.28541 37.746263388739706 -122.425306657892 (37.7462633887397, -122.425306657892)
158454 250756 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Lake St 1 : 4 Tree 1 Private 1     6 Width 0ft   5986048.1037 2114785.2005 37.7859900201618 -122.492057248563 (37.7859900201618, -122.492057248563)
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)
157728 215438 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5998696.43814 2093778.97623 37.7290433761531 -122.44678558449101 (37.7290433761531, -122.446785584491)
157670 241194 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010150.13435 2105098.1288099997 37.7607709543248 -122.4079869968 (37.7607709543248, -122.4079869968)
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)
157293 60204 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/1982 12:00:00 AM 8 4x4 Permit Number 19750 6012229.2906 2107053.9352 37.766257350909704 -122.400933496957 (37.7662573509097, -122.400933496957)
156645 179959 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6011901.82986 2087473.4551099997 37.7124752317148 -122.400690449024 (37.7124752317148, -122.400690449024)
156017 63197 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 472 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1986 12:00:00 AM 14   Permit Number 23738 5984415.8334099995 2112620.0121299997 37.7799494956437 -122.49754445897301 (37.7799494956437, -122.497544458973)
153956 241211 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6009079.81613 2106354.44033 37.7641605153159 -122.411777537601 (37.7641605153159, -122.411777537601)
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)
152480 241225 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4049 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6001920.58101 2105839.72544 37.7623430070574 -122.43650238277901 (37.7623430070574, -122.436502382779)
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)
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)
150042 241222 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009029.52417 2106399.69099 37.7642819417697 -122.411954681586 (37.7642819417697, -122.411954681586)
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)
148653 215421 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2085 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993516.19097 2101401.9668400004 37.74967690946279 -122.46524744032101 (37.7496769094628, -122.465247440321)
147184 215439 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   5998709.4181699995 2093777.72882 37.729040692553 -122.44674062198 (37.729040692553, -122.44674062198)
146364 179967 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 716 Peru Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6005275.29843 2092450.03888 37.7257680389529 -122.423947466603 (37.7257680389529, -122.423947466603)
146236 63542 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2389 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/1987 12:00:00 AM     Permit Number 24157 6008220.818199201 2104530.13411616 37.7591031640479 -122.414619465951 (37.7591031640479, -122.414619465951)
145861 38219 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 118 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/2000 12:00:00 AM     Permit Number 40340 6000363.19569215 2109305.86913973 37.7717715527779 -122.44213760158001 (37.7717715527779, -122.44213760158)
145835 80165 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 415-421 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
145642 108223 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
145218 71944 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1342 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/1995 12:00:00 AM   3x3 Permit Number 50253 6008035.06455956 2100432.68279191 37.7478420534954 -122.414971880187 (37.7478420534954, -122.414971880187)
145082 88286 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51287 6007754.0 2106536.0 37.7645845697556 -122.416376026653 (37.7645845697556, -122.416376026653)
144031 16312 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 758X Monterey Blvd 4 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
143287 44011 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 405X Florida St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on Florida 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
142933 63531 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 645 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/10/1987 12:00:00 AM     Permit Number 24143 6007924.14567941 2104175.72058203 37.7581133535123 -122.41562041035299 (37.7581133535123, -122.415620410353)
142472 108226 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
142033 34048 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
141713 82360 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 415-421 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
141062 48927 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1362 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/25/2002 12:00:00 AM     Permit Number 46117 6009515.72884218 2101239.2044667 37.7501396750607 -122.40990871780501 (37.7501396750607, -122.409908717805)
140792 94868 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 31 51 Princeton St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
140788 34085 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2851X 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
139874 16201 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 500X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)

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 83.71ms · Data source: data.sfgov.org