Street_Tree_List

Data source: data.sfgov.org

994 rows where qSpecies = 39 sorted by TreeID descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID ▲ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4764 253679 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 94 Teresita Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
4669 253646 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4668 253644 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
1985 252841 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1763 Golden Gate Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
1574 251596 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 19th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1592 251595 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1567 251594 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1583 251593 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
669 251343 Property Tree 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 934 Brannan St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
56135 250989 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 401 45th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     5981864.98937 2112954.2603599997 37.7807173939441 -122.506393608376 (37.7807173939441, -122.506393608376)
25083 250988 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 401 45th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5981857.67732 2112961.27677 37.780736228431394 -122.50641942431999 (37.7807362284314, -122.50641942432)
176726 250782 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 271 32nd Ave 1 : 4 Tree 1 Private 1     15 Width 3ft   5985871.45629 2114116.47181 37.784143557323105 -122.492619123386 (37.7841435573231, -122.492619123386)
136621 249776 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 102 Pfeiffer St 7 Side Yard : Yard 17 Tree 1 Private 1     25 Width 0ft   6010370.54568 2121149.36884 37.804856202214204 -122.408356876268 (37.8048562022142, -122.408356876268)
73439 249465 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 3 Median : Yard 3 Tree 1 DPW 2     26     6006528.896380001 2113762.4002 37.78435756088879 -122.421126494805 (37.7843575608888, -122.421126494805)
35512 249464 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 2 Median : Yard 3 Tree 1 DPW 2     24     6006534.583819999 2113721.77463 37.7842463336479 -122.421103932595 (37.7842463336479, -122.421103932595)
37159 249463 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 1 Median : Yard 3 Tree 1 DPW 2     27     6006539.42856 2113694.50869 37.7841717411666 -122.421085234814 (37.7841717411666, -122.421085234814)
74888 248336 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1549 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5998153.3936 2108210.9771 37.7686390752497 -122.449702503746 (37.7686390752497, -122.449702503746)
23961 247944 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 21 Joy St 1 Front Yard : Yard 7 Tree 1 Private 1     23     6010317.99645 2098902.9194900002 37.7437696775404 -122.40696976733999 (37.7437696775404, -122.40696976734)
43726 247881 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 387 Mayflower St 2 Side Yard : Yard 17 Tree 1 Private 1     15     6009928.32781 2098399.30466 37.742365048010896 -122.4082816417 (37.7423650480109, -122.4082816417)
169612 247876 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 388 Mayflower St 5 Side Yard : Yard 17 Tree 1 Private 1     22     6009908.43883 2098395.0561 37.742352268652 -122.40835011248001 (37.742352268652, -122.40835011248)
54010 247872 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 388 Mayflower St 2 Side Yard : Yard 17 Tree 1 Private 1     23     6009895.64631 2098398.03188 37.7423597231243 -122.408394555183 (37.7423597231243, -122.408394555183)
175778 247211 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 800 Duboce Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6001837.76454 2108286.1140099997 37.769055482952105 -122.43696396161998 (37.7690554829521, -122.43696396162)
147984 247210 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 800 Duboce Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6001850.29311 2108285.87334 37.769055534222105 -122.4369206089 (37.7690555342221, -122.4369206089)
175917 247206 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 800 Duboce Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6001887.4156 2108287.94496 37.7690633322277 -122.436792352994 (37.7690633322277, -122.436792352994)
181686 246870 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3090x Market St 3 Median : Yard 3 Tree 1 DPW 2     11     5999943.44665 2105326.58667 37.7608215070397 -122.443303673043 (37.7608215070397, -122.443303673043)
155497 246721 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 75 Stoneman St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6007902.05533 2099361.90416 37.7448944596047 -122.41535602906299 (37.7448944596047, -122.415356029063)
77191 246720 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 75 Stoneman St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     6007960.82991 2099365.47292 37.744907561828796 -122.4151530494 (37.7449075618288, -122.4151530494)
162663 246718 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 75 Stoneman St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6007936.82718 2099363.37967 37.7449004652897 -122.41523589851101 (37.7449004652897, -122.415235898511)
178895 246717 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 75 Stoneman St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22     6007910.84481 2099371.86455 37.744922302618605 -122.415326341557 (37.7449223026186, -122.415326341557)
64580 246671 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 950 San Jose Ave 1 Front Yard : Yard 7 Tree 1 Private 1     16 Width 8ft   6005232.0889 2097709.97714 37.7402082183385 -122.424470809079 (37.7402082183385, -122.424470809079)
4251 246122 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1518 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft Permit Number 46036 5998379.9097 2108286.3815 37.768859073318 -122.448924438468 (37.768859073318, -122.448924438468)
178418 244114 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 418 Shrader St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5997491.8129 2108946.6394 37.770621142726796 -122.45204393067301 (37.7706211427268, -122.452043930673)
163163 244085 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 410 Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   5997479.7999 2109032.7566 37.770856910285794 -122.452091697935 (37.7708569102858, -122.452091697935)
158470 224328 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 543 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 2ft   6008731.92971 2096221.69985 37.7363187538921 -122.41226456365801 (37.7363187538921, -122.412264563658)
40457 224327 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 147 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5997757.791 2106766.0657599997 37.764649075606705 -122.450966650497 (37.7646490756067, -122.450966650497)
130617 224326 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 340 27th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6004274.78579 2100165.73235 37.746897051069396 -122.427955726976 (37.7468970510694, -122.427955726976)
134978 224325 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 340 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6004289.246169999 2100167.31574 37.7469022167612 -122.427905837108 (37.7469022167612, -122.427905837108)
65418 224324 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 315 27th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6004482.86307 2100136.1324299998 37.746827546062605 -122.42723410649499 (37.7468275460626, -122.427234106495)
70651 224323 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 315 27th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004466.1603 2100134.08188 37.7468209711249 -122.42729171706002 (37.7468209711249, -122.42729171706)
162984 224322 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 315 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   6004452.19377 2100131.46174 37.746812986947 -122.427339825387 (37.746812986947, -122.427339825387)
52465 224321 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4078 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003404.59391 2100412.31265 37.747524834522096 -122.430982364755 (37.7475248345221, -122.430982364755)
76607 224320 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1542 Church St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   6004542.762159999 2099919.4449299998 37.7462359594221 -122.427011550336 (37.7462359594221, -122.427011550336)
64742 224319 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 142 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010095.00353 2100177.86923 37.747257930111296 -122.40783071172899 (37.7472579301113, -122.407830711729)
50242 224318 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1664 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6009276.46755 2099693.85922 37.7458830870421 -122.410626984552 (37.7458830870421, -122.410626984552)
180563 224317 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3450 21st St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6005309.188709999 2103731.90158 37.7567473919951 -122.424632493717 (37.7567473919951, -122.424632493717)
184186 224316 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3450 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6005324.68635 2103732.49106 37.756749885805995 -122.424578939078 (37.756749885806, -122.424578939078)
62555 224315 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3450 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6005360.49945 2103736.03596 37.7567616417415 -122.424455336266 (37.7567616417415, -122.424455336266)
157908 224314 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Alemany Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52     6009840.407819999 2096670.2357599998 37.737612475420796 -122.40846370585699 (37.7376124754208, -122.408463705857)
25469 224313 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1300 San Jose Ave 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23     6003370.69781 2095579.24653 37.734252427487895 -122.43075473197099 (37.7342524274879, -122.430754731971)
51663 224312 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1300 San Jose Ave 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6003373.67876 2095579.3072 37.7342527629625 -122.43074443020599 (37.7342527629625, -122.430744430206)
69503 224311 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1300 San Jose Ave 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6003371.63665 2095581.9974099998 37.7342600339703 -122.430751682345 (37.7342600339703, -122.430751682345)
27826 224310 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 321 Fair Oaks St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 6ft   6005486.40879 2101775.92672 37.751386746407796 -122.423880520163 (37.7513867464078, -122.423880520163)
129774 224309 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 321 Fair Oaks St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 6ft   6005488.7539 2101747.55043 37.751308964059 -122.42387039293001 (37.751308964059, -122.42387039293)
36246 224308 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 321 Fair Oaks St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6005492.11509 2101727.90157 37.7512552025777 -122.42385737251499 (37.7512552025777, -122.423857372515)
146914 224307 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 321 Fair Oaks St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 6ft   6005495.07362 2101688.6812400003 37.751147679623706 -122.42384435305 (37.7511476796237, -122.42384435305)
140428 224306 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 321 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 6ft   6005495.439259999 2101665.7610299997 37.7510847666582 -122.423841459026 (37.7510847666582, -122.423841459026)
147381 224305 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 371 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6005498.30819 2101561.13741 37.7507976562932 -122.423824099413 (37.7507976562932, -122.423824099413)
184435 224304 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3750 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6005368.72152 2101395.0732400003 37.7503343660492 -122.424260412695 (37.7503343660492, -122.424260412695)
162828 224303 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3750 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6005452.8742 2101399.0795 37.7503501176724 -122.423969691544 (37.7503501176724, -122.423969691544)
45038 224302 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3750 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6005441.62305 2100815.29043 37.748746532027795 -122.423967089833 (37.7487465320278, -122.423967089833)
164275 224301 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3750 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6005487.3192 2100818.51609 37.7487579687029 -122.423809301967 (37.7487579687029, -122.423809301967)
165633 223977 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2x Gough St 2 Median : Yard 3 Tree 1 DPW 2     37     6006660.75895 2109243.9943 37.7719585430967 -122.42034948146002 (37.7719585430967, -122.42034948146)
184168 223976 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Gough St 1 : 4 Tree 1 Private 1     24     6006664.524230001 2109235.5502400002 37.771935569896996 -122.420335857614 (37.771935569897, -122.420335857614)
73343 223975 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 95 Brady St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   6006811.298780001 2109427.58873 37.7724711314687 -122.419841781785 (37.7724711314687, -122.419841781785)
47483 223974 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Miguel St 1 Front Yard : Yard 7 Tree 1 Private 1     41     6003823.8109 2097275.5293400004 37.7389356956285 -122.429309094259 (37.7389356956285, -122.429309094259)
35275 223973 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3977 22nd St 3 : 4 Tree 1 Private 1     15     6001912.30882 2102919.7297900002 37.754324934974704 -122.436322006668 (37.7543249349747, -122.436322006668)
177727 223972 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 50 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003884.37691 2108498.70054 37.7697553065857 -122.42990002078301 (37.7697553065857, -122.429900020783)
172379 223971 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 54 Potomac St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003133.19569 2108609.74103 37.7700176280312 -122.43250626595301 (37.7700176280312, -122.432506265953)
185731 223970 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 54 Potomac St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003137.39026 2108599.9240900003 37.7699909109802 -122.43249105572399 (37.7699909109802, -122.432491055724)
68951 223969 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4204 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6000982.45967 2105831.10535 37.762265985503 -122.439746368725 (37.762265985503, -122.439746368725)
56923 223968 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4202 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6000989.44709 2105832.50056 37.7622702141259 -122.43972230196002 (37.7622702141259, -122.43972230196)
52133 223967 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4200 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6001001.07931 2105834.184 37.7622754985255 -122.43968219128 (37.7622754985255, -122.43968219128)
173210 223966 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4200 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001010.78758 2105836.29251 37.7622818405443 -122.43964876527201 (37.7622818405443, -122.439648765272)
46740 223965 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 90 Douglass St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6001036.08116 2105860.9947200003 37.762351106343296 -122.439563055407 (37.7623511063433, -122.439563055407)
35740 223964 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 90 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001033.19206 2105884.60415 37.7624157676075 -122.439574740289 (37.7624157676075, -122.439574740289)
132814 223963 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 481 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004263.12887 2106107.76823 37.763211824102 -122.42841948849 (37.763211824102, -122.42841948849)
40220 223962 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 393 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6003123.78162 2104447.14367 37.7585876099598 -122.432241505563 (37.7585876099598, -122.432241505563)
67833 223961 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 650 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002363.39606 2104418.0666099996 37.7584646285442 -122.43486917976999 (37.7584646285442, -122.43486917977)
24482 223960 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 646 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002361.48335 2104431.90571 37.75850251878121 -122.434876784451 (37.7585025187812, -122.434876784451)
37598 223959 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 642 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002363.563630001 2104457.3204 37.7585724195079 -122.434871407414 (37.7585724195079, -122.434871407414)
148068 223958 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 98 Seward St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6000714.90104 2104629.8807900003 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054)
154740 223957 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 98 Seward St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 3ft   6000715.72405 2104622.0065599997 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927)
164392 223956 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4606 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 3ft   6000605.94176 2104670.77244 37.7590585579363 -122.440965353888 (37.7590585579363, -122.440965353888)
66345 223955 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 129 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6002052.94621 2105094.0299 37.7603030289758 -122.435991220721 (37.7603030289758, -122.435991220721)
180559 223954 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3729 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004037.10862 2105956.8889 37.7627847531447 -122.42919045839399 (37.7627847531447, -122.429190458394)
163422 223953 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 39 Prosper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6003345.45834 2106302.3511099997 37.7636941305 -122.431607296461 (37.7636941305, -122.431607296461)
69030 223952 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3815 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6003498.40089 2105933.65435 37.7626904457239 -122.43105199926599 (37.7626904457239, -122.431051999266)
36881 223951 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 340 Hill St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 3ft   6004063.3586099995 2103367.27048 37.7556757625498 -122.42891503560101 (37.7556757625498, -122.428915035601)
69020 223950 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 340 Hill St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 3ft   6004077.1812 2103371.12291 37.755687122789205 -122.428867507344 (37.7556871227892, -122.428867507344)
68198 223949 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 469 Hill St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6003292.05837 2103284.31935 37.7554043111867 -122.431576512661 (37.7554043111867, -122.431576512661)
31782 223948 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 469 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6003275.133640001 2103282.37568 37.755398015022 -122.43163490472601 (37.755398015022, -122.431634904726)
40152 223947 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4261 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001509.65338 2101728.3731 37.7510308684778 -122.437629173946 (37.7510308684778, -122.437629173946)
134073 223946 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4308 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     36 Width 3ft   6001874.6261 2101202.64201 37.749608080752296 -122.436329442272 (37.7496080807523, -122.436329442272)
51818 223945 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3354 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6007844.47095 2104456.83305 37.758880744855496 -122.415915866934 (37.7588807448555, -122.415915866934)
160661 223944 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3354 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6007819.44049 2104452.8286099997 37.758868342326295 -122.416002150588 (37.7588683423263, -122.416002150588)
133525 223943 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3278 22nd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6006530.705469999 2103216.87798 37.7554021671927 -122.420371478856 (37.7554021671927, -122.420371478856)
77187 223942 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3278 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6006627.65386 2103224.52704 37.7554286324359 -122.42003674400499 (37.7554286324359, -122.420036744005)
26861 223941 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2920 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 5ft   6008707.1886599995 2103338.13414 37.755857516419795 -122.412853084526 (37.7558575164198, -122.412853084526)

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