Street_Tree_List

Data source: data.sfgov.org

99,669 rows where qLegalStatus = 2 sorted by Longitude

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
1493 103663 Undocumented 2 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
1620 251543 Undocumented 2 Pinus radiata :: Monterey Pine 3 0X Bay Shore Blvd Off Ramp   Side Yard : Yard 17 Tree 1 Private 1                    
3007 253279 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 201X Laguna Honda Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2       10x10 ROW IS 10' tree is street tree          
3239 100549 Undocumented 2 Acer spp :: Maple 158 290X Tehama St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x4            
3537 102838 Undocumented 2 Pinus radiata :: Monterey Pine 3 1101X Portola Dr 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
3610 115725 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 250X Octavia St 2 Side Yard : Yard 17 Tree 1 Dept of Real Estate 5                    
4085 101532 Undocumented 2 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
4222 253622 Undocumented 2 Pittosporum spp :: Pittosporum spp 128 300x Naglee Ave   Unaccepted Street : Yard 14 Tree 1 Private 1                    
5598 103666 Undocumented 2 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
6680 112268 Undocumented 2 Ficus nitida :: Laurel Fig 43 1X Geary St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
6704 112269 Undocumented 2 Ficus nitida :: Laurel Fig 43 1X Geary St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
7764 103662 Undocumented 2 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 Undocumented 2 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9596 102839 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1101X Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
9694 173632 Undocumented 2 Pinus radiata :: Monterey Pine 3 3300X Market St 1 Side Yard : Yard 17 Tree 1 Private 1                    
10149 173884 Undocumented 2 Maytenus boaria :: Mayten 22 100X Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2017 12:00:00 AM 3 3x3            
10201 173901 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 4201x Lincoln Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       5x5            
10204 173902 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
10665 103665 Undocumented 2 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10892 112910 Undocumented 2 Tree(s) :: 17 1899X Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
10955 109923 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 214 state st 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
10998 112267 Undocumented 2 Ficus nitida :: Laurel Fig 43 1X Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
11273 102842 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1101X Portola Dr 8 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
11415 103667 Undocumented 2 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11778 108180 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
12636 99746 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4250 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
15743 115724 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 250x Octavia St 1 Side Yard : Yard 17 Tree 1 Dept of Real Estate 5                    
16111 102843 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101X Portola Dr 10 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
16481 112908 Undocumented 2 Tree(s) :: 17 1899X Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
16653 100543 Undocumented 2 Acer spp :: Maple 158 290X Tehama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x4            
16896 100001 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 501X 01st St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1         Address is 100 1st Street          
17073 112909 Undocumented 2 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
18528 120131 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 799x Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
20185 120130 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 799x Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
185502 122532 Undocumented 2 Pinus radiata :: Monterey Pine 3 1900X Castro St 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
63455 118676 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4825 Balboa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5980559.76523 2110909.18852 37.7750253031785 -122.510756894567 (37.7750253031785, -122.510756894567)
185367 118675 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4825 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5980581.14799 2110910.44383 37.77503001151079 -122.51068302162099 (37.7750300115108, -122.510683021621)
149104 118674 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4825 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5980614.91009 2110910.7476 37.7750328375051 -122.51056625589199 (37.7750328375051, -122.510566255892)
9874 118902 Undocumented 2 Myoporum laetum :: Myoporum 1 7300 Fulton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 3x3 Permit Number 779332 5980610.1556400005 2109606.19987 37.771450653513206 -122.510485742594 (37.7714506535132, -122.510485742594)
9861 118901 Undocumented 2 Myoporum laetum :: Myoporum 1 7300 Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 3x3 Permit Number 779332 5980648.88475 2109606.3629099997 37.7714533859213 -122.510351791198 (37.7714533859213, -122.510351791198)
40796 118904 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 701 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980709.06279 2110874.30302 37.774938325765 -122.51023785876801 (37.774938325765, -122.510237858768)
179481 118905 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 759 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5980723.1377 2110591.1502 37.774161701946795 -122.51016812974 (37.7741617019468, -122.51016812974)
72083 118906 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 763 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5980722.84871 2110577.69802 37.774124749182604 -122.510168129734 (37.7741247491826, -122.510168129734)
53142 118907 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 767 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980723.00275 2110520.89615 37.7739687970878 -122.510163375859 (37.7739687970878, -122.510163375859)
179917 118910 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 779 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5980721.87491 2110457.7346200002 37.773795307624795 -122.51016258355699 (37.7737953076248, -122.510162583557)
178793 118909 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 775 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5980722.52384 2110466.61703 37.773819734381206 -122.510160998907 (37.7738197343812, -122.510160998907)
156610 118908 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 771 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980724.52574 2110506.4926400003 37.7739293391312 -122.51015703733499 (37.7739293391312, -122.510157037335)
26156 118911 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 783 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5980723.51809 2110427.58911 37.7737126338651 -122.510154659499 (37.7737126338651, -122.510154659499)
183739 118912 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 787 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5980724.35298 2110402.4794799997 37.7736437394687 -122.510149905624 (37.7736437394687, -122.510149905624)
31879 118913 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 791 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980726.27409 2110374.60886 37.7735673282771 -122.51014118926001 (37.7735673282771, -122.51014118926)
54840 118914 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 795 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5980726.65599 2110349.7369999997 37.7734990600053 -122.51013802000601 (37.7734990600053, -122.510138020006)
88588 118899 Undocumented 2 Myoporum laetum :: Myoporum 1 7300 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 4ft   5980716.90165 2109609.13106 37.771464998604 -122.510116727255 (37.771464998604, -122.510116727255)
87073 118915 Undocumented 2 Myoporum laetum :: Myoporum 1 825 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 4ft   5980733.09837 2110116.47079 37.772858959689 -122.510098401613 (37.772858959689, -122.510098401613)
154737 79125 Undocumented 2 Myoporum laetum :: Myoporum 1 825-875 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   11 4x4   5980734.99741 2110066.24575 37.772721168522295 -122.51008810063601 (37.7727211685223, -122.510088100636)
54534 118916 Undocumented 2 Myoporum laetum :: Myoporum 1 825 La Playa 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 4x4   5980736.9232 2110038.6027900004 37.772645382677105 -122.510079385172 (37.7726453826771, -122.510079385172)
46531 119167 Undocumented 2 Myoporum laetum :: Myoporum 1 716 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980755.1675 2110858.13796 37.7748966607872 -122.510077174438 (37.7748966607872, -122.510077174438)
148637 119168 Undocumented 2 Myoporum laetum :: Myoporum 1 716 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980756.29412 2110846.59632 37.77486503730329 -122.510072419645 (37.7748650373033, -122.510072419645)
9873 118917 Undocumented 2 Myoporum laetum :: Myoporum 1 855 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 4x4   5980738.79777 2109987.23765 37.772504459681 -122.510069084185 (37.772504459681, -122.510069084185)
160807 119174 Undocumented 2 Myoporum laetum :: Myoporum 1 738 La Playa 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   5980754.24139 2110680.27075 37.7744082353086 -122.51006716089898 (37.7744082353086, -122.510067160899)
62939 118918 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 855 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5980739.80677 2109948.8930200003 37.7723992361183 -122.51006274477301 (37.7723992361183, -122.510062744773)
77096 118919 Undocumented 2 Myoporum laetum :: Myoporum 1 855 La Playa 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5980739.30228 2109925.40839 37.772334724474504 -122.510062744769 (37.7723347244745, -122.510062744769)
137577 119173 Undocumented 2 Myoporum laetum :: Myoporum 1 738 La Playa 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5980756.1033 2110688.30545 37.774430406044296 -122.510061317362 (37.7744304060443, -122.510061317362)
56572 119176 Undocumented 2 Myoporum laetum :: Myoporum 1 742 La Playa 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 8ft   5980756.08521 2110656.0073 37.7743417237871 -122.51005897992701 (37.7743417237871, -122.510058979927)
9867 118924 Undocumented 2 Juniperus chinensis :: Juniper 19 855 La Playa 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 Width 4ft   5980738.40206 2109808.86226 37.772014669966396 -122.510057198601 (37.7720146699664, -122.510057198601)
154259 119175 Undocumented 2 Myoporum laetum :: Myoporum 1 742 La Playa 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   5980756.90149 2110662.55033 37.7743597371632 -122.510056642513 (37.7743597371632, -122.510056642513)
147649 118920 Undocumented 2 Myoporum laetum :: Myoporum 1 855 La Playa 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5980740.60981 2109900.97244 37.772267707662294 -122.510056406253 (37.7722677076623, -122.510056406253)
36377 119170 Undocumented 2 Myoporum laetum :: Myoporum 1 728 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980760.8194 2110774.16468 37.774666428317104 -122.51005138377701 (37.7746664283171, -122.510051383777)
185679 118921 Undocumented 2 Myoporum laetum :: Myoporum 1 855 La Playa 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5980742.3657 2109876.07038 37.77219943749321 -122.510048482225 (37.7721994374932, -122.510048482225)
167806 119171 Undocumented 2 Myoporum laetum :: Myoporum 1 734 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5980760.66584 2110719.83278 37.774517239898294 -122.510047877677 (37.7745172398983, -122.510047877677)
150114 119172 Undocumented 2 Myoporum laetum :: Myoporum 1 734 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5980761.412719999 2110715.27486 37.7745047692475 -122.510044955434 (37.7745047692475, -122.510044955434)
137573 118923 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 855 La Playa 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5980744.20111 2109822.88075 37.7720535026603 -122.51003818124599 (37.7720535026603, -122.510038181246)
173330 118925 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 855 La Playa 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   5980744.81689 2109798.23147 37.7719858593014 -122.51003421969601 (37.7719858593014, -122.510034219696)
38712 119177 Undocumented 2 Myoporum laetum :: Myoporum 1 750 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5980764.81035 2110613.93297 37.7742267147145 -122.51002567219601 (37.7742267147145, -122.510025672196)
57301 83542 Undocumented 2 Myoporum laetum :: Myoporum 1 875 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   19     5980747.696719999 2109761.67142 37.7718856460039 -122.51002154176399 (37.7718856460039, -122.510021541764)
187547 119178 Undocumented 2 Myoporum laetum :: Myoporum 1 756 La Playa 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5980765.96509 2110596.91774 37.7741800640196 -122.510020413475 (37.7741800640196, -122.510020413475)
65922 119179 Undocumented 2 Myoporum laetum :: Myoporum 1 756 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5980765.91375 2110586.65735 37.7741518889865 -122.51001982865499 (37.7741518889865, -122.510019828655)
72413 119180 Undocumented 2 Myoporum laetum :: Myoporum 1 756 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5980766.807680001 2110581.0869 37.774136646898704 -122.510016322531 (37.7741366468987, -122.510016322531)
49842 118926 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 875 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5980750.36595 2109715.30711 37.7717585006639 -122.510008863841 (37.7717585006639, -122.510008863841)
166801 118927 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 875 La Playa 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5980750.45803 2109699.47585 37.7717150381052 -122.510007369019 (37.7717150381052, -122.510007369019)
63478 118928 Undocumented 2 Myoporum laetum :: Myoporum 1 875 La Playa 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5980750.0793699995 2109680.6397599997 37.7716632974006 -122.51000727921999 (37.7716632974006, -122.51000727922)
74443 119182 Undocumented 2 Myoporum laetum :: Myoporum 1 770 La Playa 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5980768.60163 2110516.49212 37.7739593944882 -122.510005317294 (37.7739593944882, -122.510005317294)
137746 118929 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 875 La Playa 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   5980750.23602 2109645.2788 37.7715662158284 -122.510004109936 (37.7715662158284, -122.510004109936)
60866 119183 Undocumented 2 Myoporum laetum :: Myoporum 1 770 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5980769.13154 2110513.52409 37.773951276407296 -122.510003263739 (37.7739512764073, -122.510003263739)
43202 118930 Undocumented 2 Juniperus chinensis :: Juniper 19 875 La Playa 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   5980751.65283 2109636.5801 37.7715424153171 -122.509998562861 (37.7715424153171, -122.509998562861)
41476 118681 Undocumented 2 Myoporum laetum :: Myoporum 1 4749 Balboa St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   5980787.4165900005 2110915.9594099997 37.775057323510104 -122.50996991648199 (37.7750573235101, -122.509969916482)
149703 119185 Undocumented 2 Myoporum laetum :: Myoporum 1 780 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5980776.33193 2110309.65746 37.773391943392895 -122.50996320873999 (37.7733919433929, -122.50996320874)
76432 119184 Undocumented 2 Myoporum laetum :: Myoporum 1 780 La Playa 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5980778.38631 2110329.2751 37.773445928821 -122.50995756013201 (37.773445928821, -122.509957560132)
47780 119186 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980784.52951 2110103.8461599997 37.7728273296306 -122.509919560521 (37.7728273296306, -122.509919560521)
146979 119187 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5980787.15849 2110067.27485 37.7727270706244 -122.50990774946501 (37.7727270706244, -122.509907749465)
22884 119188 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5980787.759319999 2110046.86087 37.7726710552755 -122.509904154395 (37.7726710552755, -122.509904154395)
179305 119189 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5980788.77167 2110011.06332 37.7725728254374 -122.509897992863 (37.7725728254374, -122.509897992863)
188136 119190 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980791.5999300005 2109976.85312 37.7724790610914 -122.50988566798999 (37.7724790610914, -122.50988566799)
171674 119191 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5980791.6714 2109938.71016 37.772374335952 -122.50988258676901 (37.772374335952, -122.509882586769)
130398 119192 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5980793.72014 2109909.69069 37.7722947778463 -122.509873343995 (37.7722947778463, -122.509873343995)
158125 119193 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5980794.10985 2109865.62761 37.7721738165622 -122.509868722143 (37.7721738165622, -122.509868722143)
63129 118680 Undocumented 2 Myoporum laetum :: Myoporum 1 4749 Balboa St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5980818.27434 2110917.35455 37.7750629740894 -122.50986327837299 (37.7750629740894, -122.509863278373)
76300 119239 Undocumented 2 Myoporum laetum :: Myoporum 1 4750 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5980810.57035 2110294.5133599997 37.773352381464 -122.50984365016899 (37.773352381464, -122.509843650169)
33856 119195 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5980799.52647 2109772.2275400003 37.771917686863205 -122.50984304652201 (37.7719176868632, -122.509843046522)

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