Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
67584 67584 176011 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 114 Gillette Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 3ft   6013066.75306 2086848.56663 37.7108243147535 -122.39662031080499 (37.7108243147535, -122.396620310805)
64858 64858 179339 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 340 Tocoloma Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   6012524.83653 2086861.1237299999 37.7108286189149 -122.398494192156 (37.7108286189149, -122.398494192156)
171876 171876 176267 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6000986.70381 2087103.4067099998 37.710844337262294 -122.43838990328899 (37.7108443372623, -122.438389903289)
59559 59559 176079 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1183 Munich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6001144.67239 2087111.03395 37.7108742640178 -122.437844474361 (37.7108742640178, -122.437844474361)
55233 55233 177086 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 114 Gillette Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6013074.44499 2086867.89295 37.7108778091238 -122.39659507942301 (37.7108778091238, -122.396595079423)
154901 154901 175733 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1183 Munich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6001131.654490001 2087116.6540599999 37.710888955334 -122.437889869445 (37.710888955334, -122.437889869445)
132805 132805 175905 Undocumented 2 Cordyline australis :: Dracena Palm 141 205 Nueva Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   6012845.81254 2086882.70524 37.7109057537785 -122.397386329935 (37.7109057537785, -122.397386329935)
186597 186597 176268 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Curtis St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6000987.65781 2087139.8501 37.7109444570035 -122.43838921531 (37.7109444570035, -122.43838921531)
70744 70744 179963 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255)
133830 133830 175909 Undocumented 2 Cordyline australis :: Dracena Palm 141 200 Nueva Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6012814.5616 2086915.18102 37.7109931858583 -122.397496617385 (37.7109931858583, -122.397496617385)
27081 27081 176269 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 273 Curtis St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6000993.66237 2087160.73145 37.711002134104795 -122.43836995721901 (37.7110021341048, -122.438369957219)
187402 187402 179964 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002952.82685 2087126.8782400002 37.7110204227269 -122.431596206017 (37.7110204227269, -122.431596206017)
132141 132141 175546 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 298 Cordova St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   6001847.622269999 2087157.43402 37.7110416161394 -122.435418236567 (37.7110416161394, -122.435418236567)
133501 133501 175075 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1082 Munich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   6001955.35702 2087155.69226 37.7110429516559 -122.435045755382 (37.7110429516559, -122.435045755382)
65781 65781 175630 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 75 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6002944.13194 2087144.13507 37.7110673133896 -122.43162748893101 (37.7110673133896, -122.431627488931)
155490 155490 175074 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1082 Munich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   6001979.9665 2087165.3446 37.711070852213396 -122.43496138907801 (37.7110708522134, -122.434961389078)
54282 54282 176180 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 314 Tocoloma Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012557.69703 2086963.50527 37.7111115690056 -122.398387796956 (37.7111115690056, -122.398387796956)
35933 35933 188732 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6014643.15959 2086929.06971 37.7111329692742 -122.391177465365 (37.7111329692742, -122.391177465365)
42001 42001 188730 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6014544.34623 2086934.52337 37.7111424598152 -122.39151937233 (37.7111424598152, -122.39151937233)
68720 68720 188729 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 3ft   6014522.262519999 2086936.6978200001 37.7111472046498 -122.391595851594 (37.7111472046498, -122.391595851594)
68152 68152 188728 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6014503.20591 2086938.3794099998 37.7111507641693 -122.39166183394501 (37.7111507641693, -122.391661833945)
25589 25589 178865 Undocumented 2 Prunus persica :: Peach 330 1260 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   6000973.92591 2087218.6697900002 37.711160097322995 -122.438442319358 (37.711160097323, -122.438442319358)
165358 165358 188727 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6014344.673219999 2086951.52191 37.7111780496084 -122.39221068478999 (37.7111780496084, -122.39221068479)
34628 34628 188726 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   6014282.88696 2086958.43171 37.7111935916762 -122.39242471805001 (37.7111935916762, -122.39242471805)
76054 76054 179588 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 71 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6002920.320730001 2087190.6404400002 37.711193657325204 -122.43171310439199 (37.7111936573252, -122.431713104392)
48950 48950 175604 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 243 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 2ft   6000875.03048 2087235.17223 37.711199783509 -122.43878530732201 (37.711199783509, -122.438785307322)
40250 40250 188750 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 150 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6014131.496280001 2086972.33958 37.7112233718385 -122.39294893824801 (37.7112233718385, -122.392948938248)
133144 133144 175605 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 243 Curtis St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 2ft   6000870.76223 2087251.30173 37.7112438287074 -122.438801214504 (37.7112438287074, -122.438801214504)
38609 38609 188748 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 150 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   6013906.67984 2086991.4991 37.7112634896854 -122.39372730596399 (37.7112634896854, -122.393727305964)
153046 153046 187709 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6013649.01686 2087002.29435 37.7112788096526 -122.39461861596399 (37.7112788096526, -122.394618615964)
170322 170322 188198 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6014615.61789 2086983.20072 37.711280074094205 -122.39127643847999 (37.7112800740942, -122.39127643848)
49729 49729 188199 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6014599.16354 2086984.8296400001 37.7112836335959 -122.39133342311399 (37.7112836335959, -122.391333423114)
132587 132587 192625 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 251 Executive Park Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6014580.9976699995 2086985.89577 37.7112855527657 -122.391396283929 (37.7112855527657, -122.391396283929)
57926 57926 175606 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 243 Curtis St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 2ft   6000866.493969999 2087267.4309 37.7112878729966 -122.43881712171499 (37.7112878729966, -122.438817121715)
159434 159434 192626 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 251 Executive Park Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6014541.1313 2086989.76137 37.7112939542297 -122.391534343345 (37.7112939542297, -122.391534343345)
60247 60247 188200 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6014523.7676099995 2086992.1522 37.711299555189 -122.39159452417101 (37.711299555189, -122.391594524171)
184907 184907 188201 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6014503.81395 2086993.06554 37.711300955448706 -122.39166355343399 (37.7113009554487, -122.391663553434)
130699 130699 192627 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 251 Executive Park Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6014487.44333 2086993.90645 37.711302355688204 -122.391720193647 (37.7113023556882, -122.391720193647)
29872 29872 192628 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 251 Executive Park Blvd 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6014467.5100300005 2086995.83932 37.7113065564365 -122.391789223787 (37.7113065564365, -122.391789223787)
61209 61209 187708 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6013663.58022 2087013.01188 37.7113090475516 -122.394569030961 (37.7113090475516, -122.394569030961)
70031 70031 192629 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 251 Executive Park Blvd 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6014450.387080001 2086997.4605599998 37.7113100574851 -122.39184851879999 (37.7113100574851, -122.3918485188)
170514 170514 192630 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 251 Executive Park Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6014430.72002 2086999.8980299998 37.7113156584728 -122.391916664016 (37.7113156584728, -122.391916664016)
150513 150513 188202 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6014410.24908 2087000.56675 37.711316358145794 -122.39198746407101 (37.7113163581458, -122.391987464071)
185082 185082 188203 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 251 Executive Park Blvd 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6014389.30237 2087003.03012 37.7113219591221 -122.39206003394399 (37.7113219591221, -122.392060033944)
151217 151217 187707 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6013680.06159 2087022.4997 37.7113360155142 -122.394512730686 (37.7113360155142, -122.394512730686)
27387 27387 187706 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6013695.628330001 2087031.1132200002 37.7113605319472 -122.394459530409 (37.7113605319472, -122.394459530409)
131541 131541 188752 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   6014065.713880001 2087031.5756700002 37.7113823683797 -122.393180442647 (37.7113823683797, -122.393180442647)
41902 41902 187705 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6013715.36859 2087039.19615 37.711383823464104 -122.394391868106 (37.7113838234641, -122.394391868106)
186948 186948 188753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   6014041.0419 2087033.9211099998 37.7113874378463 -122.393265880017 (37.7113874378463, -122.393265880017)
166674 166674 188754 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6014012.046130001 2087036.3540700001 37.7113925073379 -122.393366267763 (37.7113925073379, -122.393366267763)
76746 76746 188755 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6013963.90027 2087039.17424 37.71139757590579 -122.393532870747 (37.7113975759058, -122.393532870747)
30514 30514 188756 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6013935.51575 2087041.28736 37.711401800917 -122.393631123501 (37.711401800917, -122.393631123501)
26244 26244 187704 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   6013733.429690001 2087045.5271 37.7114022110065 -122.394329886826 (37.7114022110065, -122.394329886826)
71147 71147 188757 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   6013913.012159999 2087043.8965900003 37.711407714869 -122.393709084803 (37.711407714869, -122.393709084803)
46481 46481 188759 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6013862.38947 2087046.45952 37.711411938972894 -122.393884230478 (37.7114119389729, -122.393884230478)
181227 181227 188758 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6013886.48106 2087045.97193 37.711411938995205 -122.39380092898999 (37.7114119389952, -122.39380092899)
160893 160893 187703 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6013752.04605 2087049.7634299998 37.71141487796321 -122.39426583982099 (37.7114148779632, -122.394265839821)
132228 132228 187702 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6013770.9191 2087051.9111799998 37.7114218243198 -122.39420075947099 (37.7114218243198, -122.394200759471)
38995 38995 177874 Undocumented 2 Olea europaea :: Olive Tree 41 1222 Naples St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   6001049.49395 2087346.60283 37.711515671269495 -122.43819029695801 (37.7115156712695, -122.438190296958)
41894 41894 177321 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1222 Naples St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 8ft   6001045.82775 2087348.99146 37.71152202140421 -122.438203139287 (37.7115220214042, -122.438203139287)
171594 171594 177636 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 211 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 2ft   6000839.34654 2087353.43494 37.7115224764632 -122.438917109259 (37.7115224764632, -122.438917109259)
68190 68190 177637 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 211 Curtis St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   6000833.77764 2087370.24547 37.7115683175965 -122.43893756074301 (37.7115683175965, -122.438937560743)
65186 65186 175545 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 187 Seville St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6001219.37593 2087363.7539 37.7115724247979 -122.437604368864 (37.7115724247979, -122.437604368864)
4205 4205 251774 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 10:14:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4296 4296 251775 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 10:17:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4484 4484 251776 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/13/2017 12:12:00 PM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
3430 3430 180648 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508)
134460 134460 175544 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 187 Seville St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6001192.72242 2087375.86302 37.7116041582787 -122.437697356964 (37.7116041582787, -122.437697356964)
167361 167361 177638 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 211 Curtis St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   6000829.15381 2087385.0725599998 37.71160876641179 -122.438954603793 (37.7116087664118, -122.438954603793)
1878 1878 251764 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 187 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
4284 4284 175543 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 187 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:37:00 AM 3 Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
4249 4249 180650 Undocumented 2 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 178 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:41:00 AM 3 Width 7ft   6001253.45718 2087396.1433599999 37.7116632967974 -122.437488893205 (37.7116632967974, -122.437488893205)
185780 185780 176396 Undocumented 2 Ficus Spp. :: 253 1212 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 8ft   6001083.28996 2087401.5408299998 37.7116684409161 -122.438077422145 (37.7116684409161, -122.438077422145)
161194 161194 187408 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 50 Leland Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   6010703.7606 2087207.6456 37.7116784782683 -122.404812664008 (37.7116784782683, -122.404812664008)
4184 4184 180651 Undocumented 2 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 178 Seville St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:53:00 AM 3 Width 7ft   6001223.66869 2087409.71788 37.7116988757881 -122.43759282156601 (37.7116988757881, -122.437592821566)
4196 4196 251778 Undocumented 2 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 178 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 10:02:00 AM 3 Width 7ft   6001223.66869 2087409.71788 37.7116988757881 -122.43759282156601 (37.7116988757881, -122.437592821566)
4272 4272 251777 Undocumented 2 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 178 Seville St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:57:00 AM 3 Width 7ft   6001223.66869 2087409.71788 37.7116988757881 -122.43759282156601 (37.7116988757881, -122.437592821566)
4183 4183 180766 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1206 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 09:29:00 AM 3 Width 8ft   6001093.57723 2087421.33847 37.7117233858917 -122.438043283865 (37.7117233858917, -122.438043283865)
129572 129572 176401 Undocumented 2 Ficus Spp. :: 253 70 Seville St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6001944.11467 2087434.6478 37.7118082639075 -122.435104550352 (37.7118082639075, -122.435104550352)
174878 174878 187409 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 95 Leland Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   6010493.4269 2087269.1415 37.711835574702 -122.40554396620199 (37.711835574702, -122.405543966202)
178179 178179 204100 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993729.19042 2087617.8937400002 37.7118415163357 -122.46351066868 (37.7118415163357, -122.46351066868)
56647 56647 175274 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 19 Brunswick St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   6001024.26555 2087488.4047299998 37.7119035929554 -122.438287644984 (37.7119035929554, -122.438287644984)
68683 68683 176235 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 19 Brunswick St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6001042.78255 2087493.5862099999 37.711918873330205 -122.43822401612499 (37.7119188733302, -122.438224016125)
129925 129925 176236 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 19 Brunswick St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6001058.00654 2087498.50838 37.711933254377 -122.438171750223 (37.711933254377, -122.438171750223)
169310 169310 176391 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   6003898.25323 2087460.6657900002 37.711990473755606 -122.42835236038401 (37.7119904737556, -122.428352360384)
146365 146365 204101 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993659.00835 2087684.8091799999 37.712021206289 -122.46375808926099 (37.712021206289, -122.463758089261)
174511 174511 177879 Undocumented 2 Olea europaea :: Olive Tree 41 13 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002815.59518 2087508.97249 37.7120617908816 -122.432097779506 (37.7120617908816, -122.432097779506)
188007 188007 175344 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993634.16802 2087703.44428 37.7120709424008 -122.463845295648 (37.7120709424008, -122.463845295648)
2721 2721 175371 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2708 2708 175370 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
175356 175356 175345 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993607.01879 2087723.8804799998 37.7121254907785 -122.463940612974 (37.7121254907785, -122.463940612974)
2720 2720 175369 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 25 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
133709 133709 176392 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   6003793.19406 2087522.42519 37.712154106300396 -122.428719874622 (37.7121541063004, -122.428719874622)
2722 2722 175368 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
30613 30613 175346 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993589.7174 2087738.26685 37.712163995237105 -122.464001454798 (37.7121639952371, -122.464001454798)
75412 75412 176393 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   6003772.59409 2087534.0234400001 37.712184786677206 -122.42879190044901 (37.7121847866772, -122.428791900449)
2703 2703 175367 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
35642 35642 175347 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2 Brotherhood Way 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993550.997219999 2087766.5420799998 37.712239400706395 -122.464137333384 (37.7122394007064, -122.464137333384)
2705 2705 175366 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2702 2702 175365 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)

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