Street_Tree_List

Data source: data.sfgov.org

1,636 rows where qSpecies = 1 sorted by Latitude

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
595 119606 Significant Tree 6 Myoporum laetum :: Myoporum 1 299x Avalon Ave 2 Front Yard : Yard 7 Tree 1 Private 1                    
11201 19747 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 10ST            
11842 19713 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
12182 19712 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
13008 19766 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY16 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30ST            
14337 19746 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3            
14544 19711 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
15820 19764 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY16 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30ST            
16592 19752 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 10ST            
48697 177826 Undocumented 2 Myoporum laetum :: Myoporum 1 89 Belle Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   5991639.3875 2086487.5926299999 37.708617351468895 -122.47065126593999 (37.7086173514689, -122.47065126594)
156268 177815 Undocumented 2 Myoporum laetum :: Myoporum 1 520 Carter St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6005230.32972 2086303.80615 37.708889269593705 -122.42366611910299 (37.7088892695937, -122.423666119103)
60266 177814 Undocumented 2 Myoporum laetum :: Myoporum 1 520 Carter St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6005234.109619999 2086313.99971 37.70891747232 -122.423653779491 (37.70891747232, -122.423653779491)
168635 177817 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 3 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6009184.18934 2086265.3806200002 37.7090061571804 -122.409998257729 (37.7090061571804, -122.409998257729)
180452 177816 Undocumented 2 Myoporum laetum :: Myoporum 1 60 Tomaso Ct 1 Front Yard : Yard 7 Tree 1 Private 1     15 Width 3ft   6009147.33252 2086269.1354099999 37.7090144012735 -122.41012590570601 (37.7090144012735, -122.410125905706)
164474 177818 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 5 Side Yard : Yard 17 Tree 1 Private 1     16 Width 3ft   6009189.876619999 2086285.53025 37.7090618027185 -122.409980023068 (37.7090618027185, -122.409980023068)
182795 177819 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 6 Side Yard : Yard 17 Tree 1 Private 1     16 Width 3ft   6009193.28856 2086304.97531 37.709115386123 -122.40996960262501 (37.709115386123, -122.409969602625)
70080 44059 Permitted Site 1 Myoporum laetum :: Myoporum 1 257 Santos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/19/2000 12:00:00 AM 6 3x3 Permit Number 43586 6006396.21431 2086366.5390599999 37.7091272643882 -122.419641098064 (37.7091272643882, -122.419641098064)
42963 113115 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
81845 113126 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
82974 113119 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
88545 113118 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
94966 113130 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
95231 113127 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
100041 113128 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
109788 113131 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
109839 113123 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
120329 113129 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
138402 113117 Undocumented 2 Myoporum laetum :: Myoporum 1 1x TOMASO CT 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
48879 177820 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 11 Side Yard : Yard 17 Tree 1 Private 1     16 Width 3ft   6009221.96633 2086380.57337 37.7093245702546 -122.409875820418 (37.7093245702546, -122.409875820418)
59246 177825 Undocumented 2 Myoporum laetum :: Myoporum 1 253 Wilson St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5994242.183759999 2086709.3481 37.709376408063 -122.461671802408 (37.709376408063, -122.461671802408)
45423 177824 Undocumented 2 Myoporum laetum :: Myoporum 1 253 Wilson St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5994231.54615 2086719.8133200002 37.7094045307537 -122.461709325737 (37.7094045307537, -122.461709325737)
119320 177821 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 14 Side Yard : Yard 17 Tree 1 Private 1     14 Width 3ft   6009239.86768 2086426.74333 37.7094523468075 -122.40981720709101 (37.7094523468075, -122.409817207091)
162173 177805 Undocumented 2 Myoporum laetum :: Myoporum 1 62 Tomaso Ct 9 Front Yard : Yard 7 Tree 1 Private 1     25 Width 8ft   6009236.846480001 2086428.13607 37.709456001673296 -122.409827747151 (37.7094560016733, -122.409827747151)
45261 177822 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 15 Side Yard : Yard 17 Tree 1 Private 1     19 Width 3ft   6009243.51838 2086439.4286099998 37.7094873825954 -122.40980548443899 (37.7094873825954, -122.409805484439)
35294 177823 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Tomaso Ct 16 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6009246.7312 2086449.12039 37.7095141743011 -122.409795064007 (37.7095141743011, -122.409795064007)
178554 177808 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Melra Ct 1 : 4 Tree 1 Private 1     22 Width 4ft   6008994.91617 2086485.2732900002 37.709599327506794 -122.410667934296 (37.7095993275068, -122.410667934296)
38897 177806 Undocumented 2 Myoporum laetum :: Myoporum 1 62 Tomaso Ct 10 Front Yard : Yard 7 Tree 1 Private 1     25 Width 8ft   6009249.93875 2086480.54598 37.709600642326606 -122.409786194885 (37.7096006423266, -122.409786194885)
168632 177803 Undocumented 2 Myoporum laetum :: Myoporum 1 670 Brunswick St 8 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     18     5998734.37003 2086718.8653400003 37.70966010280571 -122.44614681761499 (37.7096601028057, -122.446146817615)
167044 177804 Undocumented 2 Myoporum laetum :: Myoporum 1 670 Brunswick St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     18     5998746.52485 2086721.86687 37.709669038459 -122.446105024329 (37.709669038459, -122.446105024329)
184202 177807 Undocumented 2 Myoporum laetum :: Myoporum 1 62 Tomaso Ct 12 Front Yard : Yard 7 Tree 1 Private 1     19 Width 8ft   6009274.965480001 2086528.64182 37.7097341062031 -122.409703090337 (37.7097341062031, -122.409703090337)
13219 24279 DPW Maintained 3 Myoporum laetum :: Myoporum 1 350X Winding Way 17 Median : Cutout 11 Tree 1 DPW 2     6 8   6000809.6312 2086798.35513 37.709996659695 -122.43898005820299 (37.709996659695, -122.438980058203)
91950 99573 Undocumented 2 Myoporum laetum :: Myoporum 1 650X Brunswick St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
114172 99563 Undocumented 2 Myoporum laetum :: Myoporum 1 650X Brunswick St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
142439 99565 Undocumented 2 Myoporum laetum :: Myoporum 1 650X Brunswick St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
91621 110056 Permitted Site 1 Myoporum laetum :: Myoporum 1 490 Jamestown Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6016119.9 2086810.2 37.7108884169699 -122.38606516043899 (37.7108884169699, -122.386065160439)
92083 38475 Permitted Site 1 Myoporum laetum :: Myoporum 1 162 Concord St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/21/1998 12:00:00 AM     Permit Number 40476 5999822.84916102 2087316.82231241 37.7113640595721 -122.44242775396002 (37.7113640595721, -122.44242775396)
84555 2254 DPW Maintained 3 Myoporum laetum :: Myoporum 1 410X Brotherhood Way 7 Median : Cutout 11 Tree 1 DPW 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
98286 30056 DPW Maintained 3 Myoporum laetum :: Myoporum 1 410X Brotherhood Way 8 Median : Cutout 11 Tree 1 DPW 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
69320 117547 Undocumented 2 Myoporum laetum :: Myoporum 1 55X Kempton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 1x1   5992325.947930001 2087664.2532799998 37.7118878575155 -122.46836399230301 (37.7118878575155, -122.468363992303)
34540 177827 Undocumented 2 Myoporum laetum :: Myoporum 1 10 Brotherhood Way 5 : 4 Tree 1 Private 1     22 Width 0ft   5993584.63921 2087685.0546799998 37.712017594599295 -122.46401514608 (37.7120175945993, -122.46401514608)
70361 177828 Undocumented 2 Myoporum laetum :: Myoporum 1 10 Brotherhood Way 6 : 4 Tree 1 Private 1     20 Width 0ft   5993567.2586900005 2087687.58972 37.712023553524205 -122.464075401566 (37.7120235535242, -122.464075401566)
34033 177850 Undocumented 2 Myoporum laetum :: Myoporum 1 1260 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     33 Width 6ft   6001426.1792 2087609.14768 37.7122579779848 -122.43690715954399 (37.7122579779848, -122.436907159544)
69526 177851 Undocumented 2 Myoporum laetum :: Myoporum 1 1260 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     32 Width 6ft   6001405.83426 2087613.5591099998 37.712268934433 -122.436977793197 (37.712268934433, -122.436977793197)
176868 95004 Permitted Site 1 Myoporum laetum :: Myoporum 1 220 Leland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3x3   6009838.7213 2087613.1663 37.7127435660796 -122.40783106419701 (37.7127435660796, -122.407831064197)
11349 104508 Undocumented 2 Myoporum laetum :: Myoporum 1 80 Dichiera Ct 1 Sidewalk: Curb side : Hanging Pot 15 Tree 1 Private 1     14     5998566.299869999 2087993.98473 37.7131516918716 -122.446819386407 (37.7131516918716, -122.446819386407)
29851 210532 Undocumented 2 Myoporum laetum :: Myoporum 1 47 Ralston St 5 Back Yard : Yard 13 Tree 1 Private 1     3     5992170.38695 2088246.7586700001 37.7134782905637 -122.46894401367099 (37.7134782905637, -122.468944013671)
38627 210531 Undocumented 2 Myoporum laetum :: Myoporum 1 47 Ralston St 1 Back Yard : Yard 13 Tree 1 Private 1     5     5992169.14182 2088256.46113 37.7135048592377 -122.46894902289 (37.7135048592377, -122.46894902289)
140493 115828 Undocumented 2 Myoporum laetum :: Myoporum 1 65 CHUMASERO DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3   5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
180343 177809 Undocumented 2 Myoporum laetum :: Myoporum 1 968 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6002194.0253 2088207.5246700002 37.7139446016244 -122.434296011252 (37.7139446016244, -122.434296011252)
70849 210524 Undocumented 2 Myoporum laetum :: Myoporum 1 178 Bright St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5993764.0633 2088383.57286 37.71394589845 -122.463445669308 (37.71394589845, -122.463445669308)
93028 115827 Significant Tree 6 Myoporum laetum :: Myoporum 1 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
169470 177813 Undocumented 2 Myoporum laetum :: Myoporum 1 2059 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6012293.6892 2088070.36863 37.714136085289795 -122.39937793255899 (37.7141360852898, -122.399377932559)
178603 210523 Undocumented 2 Myoporum laetum :: Myoporum 1 296 Lobos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5994101.23211 2088733.3492 37.7149257215239 -122.46230564910499 (37.7149257215239, -122.462305649105)
117072 1782 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2001X Bay Shore Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6012442.836211099 2088493.8744970001 37.7153072596479 -122.398892125343 (37.7153072596479, -122.398892125343)
27203 210530 Undocumented 2 Myoporum laetum :: Myoporum 1 717 Sargent St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 6ft   5992156.75064 2089178.54268 37.7160359561589 -122.46905891645399 (37.7160359561589, -122.469058916454)
77956 45719 Permitted Site 1 Myoporum laetum :: Myoporum 1 227 Sargent St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1969 12:00:00 AM     Permit Number 44389 5993425.80357844 2089157.89359185 37.7160525030782 -122.464671006022 (37.7160525030782, -122.464671006022)
149784 210526 Undocumented 2 Myoporum laetum :: Myoporum 1 347 Victoria St 1 : 4 Tree 1 Private 1     14 Width 3ft   5993225.43115 2089502.49868 37.7169871520095 -122.46538860062999 (37.7169871520095, -122.46538860063)
27011 210522 Undocumented 2 Myoporum laetum :: Myoporum 1 800 Capitol Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5995082.26055 2089674.2189 37.717565568077504 -122.45898290776 (37.7175655680775, -122.45898290776)
172858 187572 Undocumented 2 Myoporum laetum :: Myoporum 1 73 Bishop St 3 Side Yard : Yard 17 Tree 1 Private 1     27     6010864.17104 2089487.4487 37.7179473203875 -122.404418609237 (37.7179473203875, -122.404418609237)
168751 177810 Undocumented 2 Myoporum laetum :: Myoporum 1 692 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   6000973.24291 2089845.4061900002 37.718372490187996 -122.43863277238998 (37.718372490188, -122.43863277239)
64218 210519 Undocumented 2 Myoporum laetum :: Myoporum 1 18 Jules Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 2ft   5994459.7170400005 2090063.2375400001 37.71859791423471 -122.46116292374799 (37.7185979142347, -122.461162923748)
131567 210520 Undocumented 2 Myoporum laetum :: Myoporum 1 26 Jules Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 2ft   5994461.338819999 2090107.6206900002 37.7187198730971 -122.461160533344 (37.7187198730971, -122.461160533344)
165450 210521 Undocumented 2 Myoporum laetum :: Myoporum 1 30 Jules Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 2ft   5994459.04992 2090130.39375 37.718782270758 -122.461170094923 (37.718782270758, -122.461170094923)
39873 210528 Undocumented 2 Myoporum laetum :: Myoporum 1 466 Bright St 1 : 4 Tree 1 Private 1     17 Width 3ft   5993789.40568 2090279.07412 37.719151951468504 -122.46349555378299 (37.7191519514685, -122.463495553783)
69329 177812 Undocumented 2 Myoporum laetum :: Myoporum 1 585 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6003096.80853 2090089.51847 37.719163344097204 -122.43130991494101 (37.7191633440972, -122.431309914941)
178015 210527 Undocumented 2 Myoporum laetum :: Myoporum 1 491 Bright St 1 : 4 Tree 1 Private 1     15 Width 3ft   5993759.26647 2090422.7728900001 37.7195447771444 -122.463610156198 (37.7195447771444, -122.463610156198)
177255 210529 Undocumented 2 Myoporum laetum :: Myoporum 1 233 Garfield St 1 : 4 Tree 1 Private 1     15 Width 3ft   5993351.020380001 2090459.95557 37.7196233401215 -122.465024001983 (37.7196233401215, -122.465024001983)
102326 104898 Significant Tree 6 Myoporum laetum :: Myoporum 1 310 Gonzalez Dr 1 Front Yard : Yard 7 Tree 1 Private 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
118620 104908 Significant Tree 6 Myoporum laetum :: Myoporum 1 500 Gonzalez Dr 1 Front Yard : Yard 7 Tree 1 Private 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
65349 177811 Undocumented 2 Myoporum laetum :: Myoporum 1 533 Lisbon St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6002001.20972 2090373.7008099998 37.7198814941283 -122.435117291057 (37.7198814941283, -122.435117291057)
30894 200231 Undocumented 2 Myoporum laetum :: Myoporum 1 1079 Ingerson Ave 5 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   6013732.1076 2090145.865 37.719915054156296 -122.39455141525299 (37.7199150541563, -122.394551415253)
138059 200229 Undocumented 2 Myoporum laetum :: Myoporum 1 1079 Ingerson Ave 3 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   6013701.2545 2090170.6816 37.719981480300795 -122.39465980145201 (37.7199814803008, -122.394659801452)
146495 200214 Undocumented 2 Myoporum laetum :: Myoporum 1 1159 Hollister Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6014019.4134 2090279.6631 37.720298405471794 -122.39356765042601 (37.7202984054718, -122.393567650426)
83716 15788 DPW Maintained 3 Myoporum laetum :: Myoporum 1 4840 Mission St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001135.36791 2090627.3686 37.7205288045244 -122.438128360054 (37.7205288045244, -122.438128360054)
110475 15781 DPW Maintained 3 Myoporum laetum :: Myoporum 1 4840 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/03/2000 12:00:00 AM 12 3X3   6001135.36791 2090627.3686 37.7205288045244 -122.438128360054 (37.7205288045244, -122.438128360054)
18962 29617 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900X Junipero Serra Blvd 26 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991168.23882 2090896.94142 37.7206970910675 -122.472600860348 (37.7206970910675, -122.472600860348)
20519 29614 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900X Junipero Serra Blvd 24 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991166.98096 2090921.81223 37.720765307364395 -122.47260702069599 (37.7207653073644, -122.472607020696)
61646 210518 Undocumented 2 Myoporum laetum :: Myoporum 1 142 Jules Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5994473.91746 2090866.03275 37.7208030150215 -122.461171998782 (37.7208030150215, -122.461171998782)
17169 29607 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900X Junipero Serra Blvd 16 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991176.48666 2091034.59302 37.7210755258009 -122.472582381082 (37.7210755258009, -122.472582381082)
59099 210525 Undocumented 2 Myoporum laetum :: Myoporum 1 489 Vernon St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5992458.06658 2091088.62387 37.7212979802935 -122.46815630197901 (37.7212979802935, -122.468156301979)
80679 94196 Permitted Site 1 Myoporum laetum :: Myoporum 1 355 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
107866 112769 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111205 112771 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
111811 112770 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
112482 112773 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
115212 112774 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
121815 112772 Significant Tree 6 Myoporum laetum :: Myoporum 1 1X HOWTH ST 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
84871 31201 Permitted Site 1 Myoporum laetum :: Myoporum 1 257 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/1969 12:00:00 AM     Permit Number 34892 5995623.87772067 2091687.20373025 37.723123866844894 -122.457256336737 (37.7231238668449, -122.457256336737)
117949 98373 Undocumented 2 Myoporum laetum :: Myoporum 1 701@ de Soto Urbano Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5993201.0 2091808.0 37.7233160913053 -122.46564044909799 (37.7233160913053, -122.465640449098)
99055 98374 Undocumented 2 Myoporum laetum :: Myoporum 1 106 De Soto St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5993231.0 2091825.0 37.7233644995117 -122.465537980019 (37.7233644995117, -122.465537980019)

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