Street_Tree_List

Data source: data.sfgov.org

970 rows where qSpecies = 75 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189141 199474 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1000 03rd St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6015480.23631 2109482.55519 37.7731066131226 -122.389858657266 (37.7731066131226, -122.389858657266)
189103 96941 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 108 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23     5995926.85193 2113670.95774 37.7835031091294 -122.457799026544 (37.7835031091294, -122.457799026544)
189056 246366 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1940 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079)
188996 181266 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 271 Leland Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6009541.56007 2087669.1100400002 37.712880535479 -122.40886209741001 (37.712880535479, -122.40886209741)
188775 246732 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 101 Ripley St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 8ft   6008546.25114 2099104.34804 37.7442234529633 -122.41311030320101 (37.7442234529633, -122.413110303201)
188646 100874 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 995 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17     6010596.8170300005 2112015.71985 37.7797900696951 -122.40692968637501 (37.7797900696951, -122.406929686375)
188510 187454 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4627 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6002041.9803 2091923.5259999998 37.7241392814968 -122.435087149779 (37.7241392814968, -122.435087149779)
188330 243923 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Bartlett St 2 Median : Yard 3 Tree 1 DPW 2     12 Width 10ft   6006672.06961 2103729.13284 37.7568166658685 -122.419918946309 (37.7568166658685, -122.419918946309)
187703 187521 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 100x Mary Teresa St 1 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
187338 243937 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 77 Montezuma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6007851.00528 2099783.60145 37.7460494768943 -122.415562401881 (37.7460494768943, -122.415562401881)
186914 202176 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 100 Kalmanovitz St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 2ft   6013132.98284 2093010.28184 37.7277468379346 -122.396823108819 (37.7277468379346, -122.396823108819)
186788 203185 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 10 Arkansas St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 4ft   6012813.13968 2106962.381 37.76603851379279 -122.398907634804 (37.7660385137928, -122.398907634804)
186684 246417 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3060 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6007096.0283 2100661.8303 37.7484184288497 -122.418235274082 (37.7484184288497, -122.418235274082)
186670 217476 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2 Castenada Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994389.54518 2101808.84982 37.7508444327326 -122.46225687706101 (37.7508444327326, -122.462256877061)
186449 52601 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 1360WASHINGTON Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/03/2006 12:00:00 AM 12   Permit Number 48694 6008501.73087 2117208.37484 37.7939303854283 -122.414545082491 (37.7939303854283, -122.414545082491)
186434 184516 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4044 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5981414.9052 2102173.2913 37.75108946399121 -122.50715061850599 (37.7510894639912, -122.507150618506)
185654 243921 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 755 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6009331.41321 2104703.53182 37.759641608198706 -122.41079073042101 (37.7596416081987, -122.410790730421)
185563 244862 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 109 Prospect Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006939.89705 2098843.30943 37.7434163905501 -122.418646232936 (37.7434163905501, -122.418646232936)
185545 246414 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3034 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6007105.5565 2100722.8112 37.7485864049341 -122.41820664850701 (37.7485864049341, -122.418206648507)
185076 244824 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 773 Dolores St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 7ft   6005057.02214 2103838.7107 37.757026420139 -122.42551217995701 (37.757026420139, -122.425512179957)
184973 62210 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 280 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/1985 12:00:00 AM 18   Permit Number 22332 6000793.821959999 2093620.4443599998 37.7287276772231 -122.439523423176 (37.7287276772231, -122.439523423176)
184866 199501 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1012 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6010462.04247 2111980.9380099997 37.7796870244685 -122.40739348023199 (37.7796870244685, -122.407393480232)
184860 181218 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 765 Delano Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 10ft   5998962.78764 2090178.0255900002 37.719171212271796 -122.445605954547 (37.7191712122718, -122.445605954547)
184842 203176 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1301 Minnesota St 12 Front Yard : Yard 7 Tree 1 Private 1     12     6015380.59839 2102345.27771 37.753503666864205 -122.38970472391199 (37.7535036668642, -122.389704723912)
184841 199445 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1515 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6015653.75387 2108031.46585 37.769131861479394 -122.38915709163 (37.7691318614794, -122.38915709163)
184709 243934 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4220 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 3ft   6002371.598130001 2100644.4982 37.748103774890204 -122.434570994281 (37.7481037748902, -122.434570994281)
184524 199454 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1401 03rd St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6015626.42459 2108505.26742 37.7704313017932 -122.38928471262 (37.7704313017932, -122.38928471262)
184081 244828 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3032 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6007106.122 2100726.18303 37.7485956950473 -122.418204932034 (37.7485956950473, -122.418204932034)
183952 199492 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 281 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 5ft   6010946.44549 2111612.84065 37.778703415264296 -122.40569177677901 (37.7787034152643, -122.405691776779)
183936 244866 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 140 Highland Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 1ft   6005707.387519999 2096634.20508 37.737281219162504 -122.422750984277 (37.7372812191625, -122.422750984277)
183818 124559 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 90 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5995921.75191 2113853.09729 37.7840029226817 -122.45782985493 (37.7840029226817, -122.45782985493)
183675 217467 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 870 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5992049.56384 2105945.3755799998 37.762067235345796 -122.47064992776801 (37.7620672353458, -122.470649927768)
183629 244832 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3048 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6007100.0993800005 2100660.4969599997 37.748414996954395 -122.418221101822 (37.7484149969544, -122.418221101822)
183212 181247 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200x Bay Shore Blvd 6 Median : Cutout 11 Tree 1 DPW 2     14 Width 6ft   6011190.75371 2087265.8089 37.7118653915605 -122.40313356348899 (37.7118653915605, -122.403133563489)
183191 181262 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 271 Leland Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 3ft   6009462.97914 2087698.55594 37.7129569859491 -122.409135776392 (37.7129569859491, -122.409135776392)
182881 187524 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 65 Megan Dr 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6012544.21435 2087950.6846900003 37.7138214169992 -122.398503622458 (37.7138214169992, -122.398503622458)
181886 49328 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 650 05th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/21/2003 12:00:00 AM 19   Permit Number 46321 6013181.12431 2110489.32106 37.775743196927294 -122.397882269155 (37.7757431969273, -122.397882269155)
181853 201499 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1038 Innes Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6018416.79538 2095102.4725900001 37.7337842710237 -122.37870189547701 (37.7337842710237, -122.378701895477)
181637 181239 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 80 Blanken Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6011624.41356 2087381.7363 37.7122079136246 -122.40164284814699 (37.7122079136246, -122.401642848147)
181473 218224 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 399 Claremont Blvd 3 Side Yard : Yard 17 Tree 1 Private 1     22     5993477.431469999 2097858.26435 37.7399445640996 -122.465124117182 (37.7399445640996, -122.465124117182)
181166 33557 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 2400 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/1996 12:00:00 AM 12   Permit Number 37664 5996239.10441 2110423.85984 37.774605369516394 -122.456483876805 (37.7746053695164, -122.456483876805)
181125 244851 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 300 San Carlos St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6006698.01585 2104283.50079 37.7583402936957 -122.41986855098801 (37.7583402936957, -122.419868550988)
180976 217454 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Minerva St 11 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   5996047.542640001 2089003.42322 37.7157791619486 -122.45559792969601 (37.7157791619486, -122.455597929696)
180549 181282 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 239 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6004063.89485 2092132.64778 37.724828087333606 -122.428112590334 (37.7248280873336, -122.428112590334)
180435 187439 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4620 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6002001.2284 2091970.7345 37.7242665912846 -122.435231397877 (37.7242665912846, -122.435231397877)
180281 202175 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 100 Kalmanovitz St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 2ft   6013138.4392099995 2093044.77183 37.7278418441173 -122.396806662905 (37.7278418441173, -122.396806662905)
179815 217437 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 601x Monterey Blvd 6 Median : Cutout 11 Tree 1 DPW 2     12 Width 4ft   5997794.81955 2094706.79322 37.7315393941054 -122.449969377904 (37.7315393941054, -122.449969377904)
179057 217462 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Minerva St 48 Median : Cutout 11 Tree 1 DPW 2     16 Width 0ft   5996487.36469 2088998.4739599999 37.7157908018916 -122.454077353311 (37.7157908018916, -122.454077353311)
178946 243918 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1205 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   6009252.506630001 2102069.1473 37.752403757340005 -122.410877568955 (37.75240375734, -122.410877568955)
178669 243943 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 671 Church St 56 Front Yard : Yard 7 Tree 1 Private 1     19 Width 3ft   6004315.82343 2105235.1157 37.7608187101375 -122.428175041065 (37.7608187101375, -122.428175041065)
177866 187457 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4787 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6001508.6333 2091075.8490000002 37.721781452274705 -122.43687019188101 (37.7217814522747, -122.436870191881)
177566 203179 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1800 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6015617.1468 2107140.95711 37.7666846892774 -122.38922152448099 (37.7666846892774, -122.389221524481)
177521 199484 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1300 03rd St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6015511.156140001 2108923.75767 37.7715739929801 -122.38971266400401 (37.7715739929801, -122.389712664004)
177484 184517 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4046 Ortega St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5981383.432 2102173.6297 37.751088539403206 -122.507259479265 (37.7510885394032, -122.507259479265)
176643 181263 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 271 Leland Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 3ft   6009475.51838 2087694.07697 37.7129453900797 -122.40909212061199 (37.7129453900797, -122.409092120612)
175922 199480 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1240 03rd St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6015500.51903 2109136.7123 37.7721581296349 -122.389764335453 (37.7721581296349, -122.389764335453)
175756 181248 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2200x Bay Shore Blvd 7 Median : Cutout 11 Tree 1 DPW 2     15 Width 6ft   6011168.55226 2087238.084 37.7117880246642 -122.403208349279 (37.7117880246642, -122.403208349279)
175604 203184 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 10 Arkansas St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6012812.5292 2106977.67983 37.766080486952795 -122.398910820196 (37.7660804869528, -122.398910820196)
175583 217479 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 158 Burnside Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 5ft   6001063.19964 2095410.8280900002 37.7336589855795 -122.43872040954099 (37.7336589855795, -122.438720409541)
175090 187522 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 65 Megan Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6012564.1625 2087957.56317 37.713841415230604 -122.398435156171 (37.7138414152306, -122.398435156171)
174910 181219 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 519 Lisbon St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 6ft   6002044.02941 2090439.9964599998 37.720065958565 -122.434974017336 (37.720065958565, -122.434974017336)
174904 217433 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 501x Monterey Blvd 5 Median : Cutout 11 Tree 1 DPW 2     16 Width 4ft   5998496.43118 2094696.04115 37.731549992634605 -122.447543007012 (37.7315499926346, -122.447543007012)
174835 199436 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 189 Hubbell St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6013326.10031 2107431.53826 37.767355284933 -122.39716629548599 (37.767355284933, -122.397166295486)
174670 184444 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2131 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5981678.0282 2100560.0346 37.7466754073158 -122.50612112236 (37.7466754073158, -122.50612112236)
174574 244852 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 300 San Carlos St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6006699.21469 2104263.78376 37.758286222839395 -122.419863005767 (37.7582862228394, -122.419863005767)
174544 246364 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1940 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6006759.3529 2107084.7818 37.766035412442704 -122.419855194529 (37.7660354124427, -122.419855194529)
174501 217477 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5994377.24851 2101823.40778 37.750883697139 -122.462300455497 (37.750883697139, -122.462300455497)
174465 217456 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Minerva St 15 Median : Cutout 11 Tree 1 DPW 2     20 Width 0ft   5996127.26791 2089002.03978 37.715779938072295 -122.455322264126 (37.7157799380723, -122.455322264126)
174438 203177 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1301 Minnesota St 61 Front Yard : Yard 7 Tree 1 Private 1     17     6015358.55131 2102374.09965 37.7535815832452 -122.38978298111401 (37.7535815832452, -122.389782981114)
173858 246344 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1800 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6006725.8095 2107628.1183 37.7675253965504 -122.420009776033 (37.7675253965504, -122.420009776033)
173828 199451 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1455 03rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 5ft   6015633.06498 2108386.39567 37.77010527416 -122.389253441416 (37.77010527416, -122.389253441416)
173440 247055 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 500 28th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20     6002656.51125 2099493.5306599997 37.7449596577675 -122.433503535865 (37.7449596577675, -122.433503535865)
173091 217428 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1113 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991492.83801 2105186.64815 37.7599517618807 -122.47252009133601 (37.7599517618807, -122.472520091336)
173007 199449 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1515 03rd St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6015644.40714 2108197.8403 37.769588171184296 -122.3892010406 (37.7695881711843, -122.3892010406)
172474 244816 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 150x Dolores St 4 Median : Yard 3 Tree 1 DPW 2     15     6004817.336069999 2107374.8750299998 37.766722342083 -122.42659290246701 (37.766722342083, -122.426592902467)
172077 243922 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Bartlett St 3 Median : Yard 3 Tree 1 DPW 2     12 Width 10ft   6006671.30131 2103734.09431 37.756830245634 -122.419921955443 (37.756830245634, -122.419921955443)
171883 187455 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 4779 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6001879.4074 2091666.3162 37.7234238086089 -122.435630746292 (37.7234238086089, -122.435630746292)
171385 244815 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 451 Florida St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 9ft   6009251.4171400005 2106274.41145 37.7639503995181 -122.411178363391 (37.7639503995181, -122.411178363391)
171005 203191 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 242 Texas St 1 : 4 Tree 1 Private 1     20 Width 3ft   6013713.77325 2105932.1269099996 37.7632598065236 -122.395720307939 (37.7632598065236, -122.395720307939)
170710 247119 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2301 Castro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     6002742.76916 2098847.9819 37.7431920249995 -122.43315915579201 (37.7431920249995, -122.433159155792)
170196 217458 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Minerva St 27 Median : Cutout 11 Tree 1 DPW 2     22 Width 0ft   5996270.87292 2089001.5829099999 37.7157869222056 -122.454825868913 (37.7157869222056, -122.454825868913)
170194 67454 Permitted Site 1 Washingtonia robusta :: Mexican Fan Palm 75 18 Rossi Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/18/1992 12:00:00 AM 24   Permit Number 30963 5996314.7251699995 2112137.62024 37.7793152462196 -122.456346235157 (37.7793152462196, -122.456346235157)
170054 243935 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 293 Bemis St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6002891.579 2096165.14853 37.7358340238094 -122.432453031508 (37.7358340238094, -122.432453031508)
169980 203189 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 889 Vermont St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     6011337.056059999 2104206.57613 37.758389331013205 -122.403819204816 (37.7583893310132, -122.403819204816)
169757 244829 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3038 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6007106.51614 2100714.99964 37.748565010173294 -122.418202776331 (37.7485650101733, -122.418202776331)
169617 244822 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3700 Cesar Chavez St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6005751.99744 2100574.03456 37.7481016165112 -122.42287667172899 (37.7481016165112, -122.422876671729)
168793 244848 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 300 San Carlos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6006695.182 2104327.73391 37.7584615879395 -122.41988149046499 (37.7584615879395, -122.419881490465)
168723 217830 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2400 Ocean Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     5991664.0561 2094598.0007200001 37.730887969306 -122.471156491586 (37.730887969306, -122.471156491586)
168704 199467 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1050 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6015455.2503 2109935.9180799997 37.774350061636795 -122.389976763437 (37.7743500616368, -122.389976763437)
168665 217474 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2007 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   5993457.007669999 2101818.8487299997 37.750818147353705 -122.46548237740299 (37.7508181473537, -122.465482377403)
168519 181276 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988413.87941 2089827.13064 37.7175998421416 -122.482043381217 (37.7175998421416, -122.482043381217)
168088 244811 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 199 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6005366.54273 2099017.13442 37.743804967825206 -122.424098857596 (37.7438049678252, -122.424098857596)
167968 203187 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2209 25th St 1 Front Yard : Yard 7 Tree 1 Private 1     18     6012122.25902 2101859.12536 37.7519875798856 -122.400938678078 (37.7519875798856, -122.400938678078)
167542 181237 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2100x Bay Shore Blvd 6 Median : Cutout 11 Tree 1 DPW 2     14 Width 6ft   6011709.60443 2087494.2224299998 37.712521531527294 -122.40135630166 (37.7125215315273, -122.40135630166)
167534 199452 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1401 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 5ft   6015631.41317 2108425.60277 37.7702128366907 -122.38926189323799 (37.7702128366907, -122.389261893238)
167263 199478 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1240 03rd St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   6015495.305819999 2109230.7911799997 37.7724161604052 -122.38978894091801 (37.7724161604052, -122.389788940918)
166880 243917 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1205 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6009254.00297 2102050.79541 37.7523534510568 -122.410871098321 (37.7523534510568, -122.410871098321)
166180 244836 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1880 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6006731.22327 2107487.4499 37.7671394593552 -122.419981066981 (37.7671394593552, -122.419981066981)
165973 245406 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 3158 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6006782.0924 2100045.1278 37.7467074273685 -122.419277118857 (37.7467074273685, -122.419277118857)
165843 181227 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 2000x Bay Shore Blvd 11 Median : Cutout 11 Tree 1 DPW 2     14 Width 5ft   6012100.147000001 2087910.54687 37.713686457546395 -122.400035676032 (37.7136864575464, -122.400035676032)

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