Street_Tree_List

Data source: data.sfgov.org

104 rows where qCaretaker = 6

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, qSiteInfo, PlantType, qCareAssistant, PlantDate, DBH, PlotSize

SiteOrder

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
249 251254 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 09th Ave 1 unknown : Cutout 12 Tree 1 MTA 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
901 224716 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 5 Front Yard : Cutout 8 Tree 1 MTA 6     13 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
903 225889 Property Tree 7 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 3255x 24th St 7 Back Yard : Cutout 16 Tree 1 MTA 6     18 Width 8ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
905 224715 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 4 Front Yard : Cutout 8 Tree 1 MTA 6     12 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
914 225888 Property Tree 7 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 3255x 24th St 1 Front Yard : Cutout 8 Tree 1 MTA 6     32 6x6   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
916 224714 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 3 Front Yard : Cutout 8 Tree 1 MTA 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
928 224422 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 2 Front Yard : Cutout 8 Tree 1 MTA 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
966 251417 Private 5 Eucalyptus globulus :: Blue Gum 103 418 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
1380 251512 Property Tree 7 Callistemon viminalis :: Weeping Bottlebrush 20 4116x 18th St 1 Back Yard : Yard 13 Tree 1 MTA 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
3474 106212 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 5 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     12 3x5   6010752.41967 2115858.63176 37.790350501826204 -122.406662277468 (37.7903505018262, -122.406662277468)
3799 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 3 401 Ocean Ave 2 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
3801 177109 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 401 Ocean Ave 16 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     6 Width 5ft   5998958.08532 2091518.52367 37.72285164275971 -122.445718558684 (37.7228516427597, -122.445718558684)
3803 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 3 401 Ocean Ave 1 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
3805 177105 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 401 Ocean Ave 12 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     4 Width 5ft   5998924.5969 2091518.7811599998 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179)
3806 177110 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 401 Ocean Ave 17 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     6 Width 5ft   5998978.57855 2091518.5364400002 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081)
3808 177108 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 401 Ocean Ave 15 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369563999 (37.7228504376851, -122.44574369564)
3811 177743 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 2 401 Ocean Ave 4 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
3818 178337 Significant Tree 6 Pinus radiata :: Monterey Pine 3 401 Ocean Ave 3 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
3826 177104 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 401 Ocean Ave 11 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     4 Width 5ft   5998921.0818300005 2091519.29315 37.722851642780796 -122.44584652679501 (37.7228516427808, -122.445846526795)
3827 177106 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 401 Ocean Ave 13 Sidewalk: Property side : Yard 9 Tree 1 MTA 6     7 Width 5ft   5998933.177730001 2091518.16383 37.7228492325857 -122.44580463279199 (37.7228492325857, -122.445804632792)
6211 106217 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     10 3x5   6010670.9358 2115847.8332700003 37.790316292506795 -122.40694344599301 (37.7903162925068, -122.406943445993)
6302 106216 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     10 3x5   6010698.10573 2115852.22595 37.7903298740626 -122.406849749212 (37.7903298740626, -122.406849749212)
6705 106209 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 585X Bush St 7 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     16 3x16   6010847.77195 2115873.69146 37.7903971865333 -122.406333425049 (37.7903971865333, -122.406333425049)
7182 106215 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     14 3x5   6010717.90235 2115854.24398 37.79033652277371 -122.406781396238 (37.7903365227737, -122.406781396238)
9684 173630 Significant Tree 6 Myoporum laetum :: Myoporum 1 2699x OCEAN AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
19060 116350 Undocumented 2 Privet :: 262 4051X 24TH ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
28447 116579 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
58682 116625 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 6 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
69379 122419 Undocumented 2 Pinus radiata :: Monterey Pine 3 2200 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
78249 116605 Undocumented 2 Ficus Spp. :: 253 1325x 08TH AVE 2 Front Yard : Yard 7 Tree 1 MTA 6           5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
79581 117011 Undocumented 2 Maytenus boaria :: Mayten 22 457X CASTRO ST 1 Back Yard : Cutout 16 Tree 1 MTA 6 Private 3   27 3x6   6002348.0 2105584.0 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888)
80719 116576 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 40 2500x OCEAN AVE 1 Sidewalk: Property side : Yard 9 Tree 1 MTA 6 DPW 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
81716 116348 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4051X 24TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
82760 120597 Significant Tree 6 Pinus radiata :: Monterey Pine 3 499x Ocean Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84141 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 3 499x Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84743 116631 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 12 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
86385 26671 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 495X Geneva Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
86909 120542 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2450 California St 1 Front Yard : Yard 7 Tree 1 MTA 6 DPW for City Agency 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
89093 116527 DPW Maintained 3 Olea europaea :: Olive Tree 41 5732 GEARY BLVD 1 Sidewalk: Curb side : Yard 2 Tree 1 MTA 6 DPW for City Agency 2     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
91468 91762 Permitted Site 1 Pistacia chinensis :: Chinese Pistache 150 1940 Harrison St   Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   03/07/2007 12:00:00 AM 3 3x3   6008660.813755 2107281.610975 37.7666827970273 -122.413292321769 (37.7666827970273, -122.413292321769)
91855 122410 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
91870 122411 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
93939 116353 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4051X 24TH ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
94007 112375 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 36 801 ULLOA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
96632 116628 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 9 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
96972 120593 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 2 499x Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     34 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
97915 121201 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 423 18th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
98882 116352 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4051X 24TH ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
98906 116629 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 10 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
99827 122418 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
100355 116620 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 1 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
101689 120996 Undocumented 2 Ficus nitida :: Laurel Fig 43 352 SUTTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x5   6010871.2 2115571.1 37.789567653219 -122.40623103688499 (37.789567653219, -122.406231036885)
102100 106226 Undocumented 2 Ficus nitida :: Laurel Fig 43 350 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     22 3x5   6010879.0 2115572.0 37.7895705607022 -122.406204113006 (37.7895705607022, -122.406204113006)
102914 112377 Property Tree 7 Eucalyptus sideroxylon :: Red Ironbark 36 801 ULLOA ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
103031 120596 Significant Tree 6 Pinus radiata :: Monterey Pine 3 499x Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     36 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
105748 120595 Significant Tree 6 Pinus radiata :: Monterey Pine 3 499x Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
106006 25403 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 495X Geneva Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   06/28/1996 12:00:00 AM 6 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
107199 112376 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 36 801 ULLOA ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
107936 118318 Property Tree 7 Maytenus boaria :: Mayten 22 20 Norton St 1 Front Yard : Yard 7 Tree 1 MTA 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
108277 25405 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 495X Geneva Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   06/28/1996 12:00:00 AM 12 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
109274 116606 Undocumented 2 Ficus Spp. :: 253 1325x 08TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
109707 26670 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 495X Geneva Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
109913 122413 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
110472 25404 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 495X Geneva Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   01/04/2002 12:00:00 AM 8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
110638 122414 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
111008 116626 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 5732X GEARY BLVD 7 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
111158 27436 Permitted Site 1 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1690X Indiana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
111773 91829 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1941 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.41312959117799 (37.7664314036014, -122.413129591178)
112319 122417 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
112371 106224 Undocumented 2 Ficus nitida :: Laurel Fig 43 340 SUTTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     24 3x5   6010923.2 2115578.3 37.789590331237704 -122.406051628897 (37.7895903312377, -122.406051628897)
112472 116609 Undocumented 2 Ficus Spp. :: 253 1325x 08TH AVE 4 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
112873 122416 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
113027 27442 Permitted Site 1 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1690X Indiana St 7 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
113343 116624 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 5 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113455 116607 Undocumented 2 Ficus Spp. :: 253 1325x 08TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
114895 116578 Significant Tree 6 Myoporum laetum :: Myoporum 1 2699x OCEAN AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
116737 122415 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
117760 116608 Undocumented 2 Ficus Spp. :: 253 1325x 08TH AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
118230 120598 Significant Tree 6 Pinus radiata :: Monterey Pine 3 499x Ocean Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
118684 27439 Permitted Site 1 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1690X Indiana St 4 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
118730 27437 Permitted Site 1 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1690X Indiana St 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
119101 116621 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 2 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
120634 116580 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 3 Sidewalk: Property side : Cutout 5 Landscaping 2 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
121491 116351 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4051X 24TH ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
121613 116354 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4051X 24TH ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
122201 91827 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1941 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.41312959117799 (37.7664314036014, -122.413129591178)
122326 122412 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
122423 116604 Undocumented 2 Ficus Spp. :: 253 1325x 08TH AVE 1 Front Yard : Yard 7 Tree 1 MTA 6           5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
122767 106225 Undocumented 2 Ficus nitida :: Laurel Fig 43 340 SUTTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     22 3x5   6010923.2 2115578.3 37.789590331237704 -122.406051628897 (37.7895903312377, -122.406051628897)
123257 116622 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 3 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124160 116349 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4051X 24TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
124339 116630 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 11 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124657 121200 Undocumented 2 Corymbia citriodora :: Lemon Scented Gum 301 423 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
125790 116627 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 8 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
125935 26669 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 495X Geneva Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
126456 116577 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
126965 91828 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1941 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.41312959117799 (37.7664314036014, -122.413129591178)
127092 116522 DPW Maintained 3 Myoporum laetum :: Myoporum 1 324 08TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW for City Agency 2   8 3x3   5993416.0 2113304.0 37.7823509768718 -122.466458848407 (37.7823509768718, -122.466458848407)
127587 25401 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 495X Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6   06/28/1996 12:00:00 AM 8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
128572 26672 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 495X Geneva Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)

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