Street_Tree_List

Data source: data.sfgov.org

5,183 rows where qSiteInfo = 4 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
45218 45218 250986 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 185 Seal Rock Dr 1 : 4 Tree 1 Private 1     16 Width 3ft   5980980.82201 2112923.78682 37.7805816277787 -122.50945005058 (37.7805816277787, -122.50945005058)
180522 180522 250985 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 169 Seal Rock Dr 1 : 4 Tree 1 Private 1     5 Width 3ft   5981053.81587 2112927.8042099997 37.7805969621145 -122.509197833038 (37.7805969621145, -122.509197833038)
155380 155380 250984 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 165 Seal Rock Dr 1 : 4 Tree 1 Private 1     9 Width 3ft   5981096.44332 2112928.00583 37.7806000288029 -122.509050381992 (37.7806000288029, -122.509050381992)
133469 133469 250983 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 145 Seal Rock Dr 1 : 4 Tree 1 Private 1     1 Width 3ft   5981179.0028800005 2112933.49353 37.780619963167204 -122.508765181767 (37.7806199631672, -122.508765181767)
59532 59532 250982 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 145 Seal Rock Dr 2 : 4 Tree 1 Private 1     6 Width 3ft   5981196.97714 2112934.78303 37.7806245632172 -122.50870309708901 (37.7806245632172, -122.508703097089)
47958 47958 251007 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 500 Point Lobos Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5981218.41729 2112709.81742 37.7800081381925 -122.508612220583 (37.7800081381925, -122.508612220583)
75539 75539 250981 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 127 Seal Rock Dr 1 : 4 Tree 1 Private 1     13 Width 3ft   5981262.02701 2112934.50357 37.7806276298976 -122.508478041756 (37.7806276298976, -122.508478041756)
136329 136329 250980 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 121 Seal Rock Dr 1 : 4 Tree 1 Private 1     15 Width 3ft   5981282.80421 2112935.7329599997 37.78063222994071 -122.50840625605301 (37.7806322299407, -122.508406256053)
41132 41132 250987 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 50 Alta Mar Way 1 : 4 Tree 1 Private 1     8 Width 3ft   5981462.395930001 2112758.2483099997 37.7801554921306 -122.507771798739 (37.7801554921306, -122.507771798739)
133178 133178 250979 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 66 Seal Rock Dr 1 : 4 Tree 1 Private 1     12 Width 3ft   5981557.10695 2112990.7206099997 37.7807993716359 -122.50746140943998 (37.7807993716359, -122.50746140944)
43413 43413 251006 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 348 Point Lobos Ave 1 : 4 Tree 1 Private 1     2 Width 4ft   5981660.38525 2112713.01394 37.780042954548705 -122.50708351880199 (37.7800429545487, -122.507083518802)
164237 164237 250978 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 16 Seal Rock Dr 1 : 4 Tree 1 Private 1     9 Width 3ft   5981781.21701 2113006.5772 37.7808561080562 -122.506687293694 (37.7808561080562, -122.506687293694)
183897 183897 250977 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 9 Seal Rock Dr 1 : 4 Tree 1 Private 1     13 Width 3ft   5981824.31886 2112976.6120700003 37.7807763705706 -122.50653596298099 (37.7807763705706, -122.506535962981)
27292 27292 250990 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5981922.57195 2112909.00953 37.7805965385427 -122.50619104959299 (37.7805965385427, -122.506191049593)
150340 150340 250991 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 2 : 4 Tree 1 Private 1     7 Width 3ft   5981922.93947 2112926.15087 37.7806436252297 -122.506191049582 (37.7806436252297, -122.506191049582)
68979 68979 250993 Undocumented 2 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 426 45th Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   5981924.15637 2112875.82054 37.7805055046607 -122.50618310676799 (37.7805055046607, -122.506183106768)
166285 166285 251003 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 250 Point Lobos Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   5981957.64195 2112675.6435700003 37.7799578490271 -122.506052420011 (37.7799578490271, -122.506052420011)
26381 26381 251002 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 250 Point Lobos Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5981992.43445 2112670.6708 37.7799462432625 -122.50593169049299 (37.7799462432625, -122.505931690493)
38391 38391 251001 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 232 Point Lobos Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5982033.34511 2112665.09757 37.7799333487875 -122.505789751407 (37.7799333487875, -122.505789751407)
48322 48322 251000 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 226 Point Lobos Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5982074.747269999 2112660.45291 37.7799230326473 -122.505646180935 (37.7799230326473, -122.505646180935)
186216 186216 250997 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 415 44th Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5982186.75835 2112941.64621 37.7807016980586 -122.505279538125 (37.7807016980586, -122.505279538125)
30707 30707 250995 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 453 44th Ave 2 : 4 Tree 1 Private 1     5 Width 3ft   5982194.00965 2112744.27477 37.780160200984604 -122.505239820464 (37.7801602009846, -122.505239820464)
56917 56917 250996 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 453 44th Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   5982195.03644 2112765.4035099996 37.780218274692004 -122.505237834779 (37.780218274692, -122.505237834779)
156500 156500 250994 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 463 44th Ave 1 : 4 Tree 1 Private 1     10 Width 3ft   5982196.352080001 2112719.64417 37.780092710449296 -122.505229891073 (37.7800927104493, -122.505229891073)
36295 36295 176117 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 1 : 4 Tree 1 Private 1     27 Width 0ft   5982122.73417 2092919.02565 37.725721454959896 -122.50401753028099 (37.7257214549599, -122.504017530281)
175790 175790 176118 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 2 : 4 Tree 1 Private 1     9 Width 0ft   5982159.440219999 2092886.81947 37.7256351838922 -122.50388825816201 (37.7256351838922, -122.503888258162)
67613 67613 176119 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 3 : 4 Tree 1 Private 1     6 Width 0ft   5982177.8802 2092874.78727 37.7256032309891 -122.503823622987 (37.7256032309891, -122.503823622987)
161409 161409 175229 Undocumented 2 Albizia julibrissin :: Mimosa Silk Tree 126 3500 Great Hwy 4 : 4 Tree 1 Private 1     6 Width 0ft   5982196.22083 2092858.10261 37.725558497802 -122.50375898690201 (37.725558497802, -122.503758986902)
60682 60682 176120 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 5 : 4 Tree 1 Private 1     7 Width 0ft   5982240.010290001 2092829.2357299998 37.725481811732294 -122.503605476233 (37.7254818117323, -122.503605476233)
178283 178283 175230 Undocumented 2 Albizia julibrissin :: Mimosa Silk Tree 126 3500 Great Hwy 6 : 4 Tree 1 Private 1     15 Width 0ft   5982256.13934 2092818.4167900002 37.7254530540961 -122.503548919661 (37.7254530540961, -122.503548919661)
35078 35078 175231 Undocumented 2 Albizia julibrissin :: Mimosa Silk Tree 126 3500 Great Hwy 7 : 4 Tree 1 Private 1     6 Width 0ft   5982272.29331 2092808.76139 37.725427492666505 -122.503492363109 (37.7254274926665, -122.503492363109)
43979 43979 176121 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 8 : 4 Tree 1 Private 1     6 Width 0ft   5982310.611330001 2092790.70938 37.7253801793381 -122.503358567347 (37.7253801793381, -122.503358567347)
128242 128242 176122 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 9 : 4 Tree 1 Private 1     3 Width 0ft   5982330.17471 2092783.08412 37.7253603924579 -122.50329037535101 (37.7253603924579, -122.503290375351)
40949 40949 176127 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 14 : 4 Tree 1 Private 1     2 Width 0ft   5982331.987919999 2092758.60697 37.7252932913503 -122.503282295839 (37.7252932913503, -122.503282295839)
181416 181416 176125 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 12 : 4 Tree 1 Private 1     2 Width 0ft   5982332.21205 2092769.0757400002 37.7253220489632 -122.50328229583499 (37.7253220489632, -122.503282295835)
56038 56038 176126 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 13 : 4 Tree 1 Private 1     1 Width 0ft   5982340.21435 2092760.75831 37.725299681933706 -122.503254017558 (37.7252996819337, -122.503254017558)
71232 71232 176123 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 10 : 4 Tree 1 Private 1     3 Width 0ft   5982341.65637 2092773.52846 37.725334830110995 -122.50324997780199 (37.725334830111, -122.503249977802)
180144 180144 176124 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 11 : 4 Tree 1 Private 1     4 Width 0ft   5982349.65867 2092765.21103 37.7253124630738 -122.50322169953002 (37.7253124630738, -122.50322169953)
62596 62596 176132 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 19 : 4 Tree 1 Private 1     12 Width 0ft   5982350.51369 2092704.1298099998 37.725144800663706 -122.503214223478 (37.7251448006637, -122.503214223478)
174595 174595 176128 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 15 : 4 Tree 1 Private 1     3 Width 0ft   5982352.93882 2092754.66757 37.7252837063712 -122.503209580278 (37.7252837063712, -122.503209580278)
56205 56205 176129 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 16 : 4 Tree 1 Private 1     3 Width 0ft   5982362.20883 2092750.97792 37.7252741204858 -122.50317726223899 (37.7252741204858, -122.503177262239)
178699 178699 176116 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Skyline Blvd 2 : 4 Tree 1 Private 1     9 Width 0ft   5982365.02042 2092827.7229400002 37.725485007020296 -122.503173222486 (37.7254850070203, -122.503173222486)
182865 182865 175232 Undocumented 2 Albizia julibrissin :: Mimosa Silk Tree 126 3500 Great Hwy 20 : 4 Tree 1 Private 1     5 Width 0ft   5982361.978019999 2092682.2058599999 37.7250852772585 -122.503172970672 (37.7250852772585, -122.503172970672)
70287 70287 176130 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 17 : 4 Tree 1 Private 1     4 Width 0ft   5982367.53322 2092746.8712900002 37.7252631577515 -122.503158552743 (37.7252631577515, -122.503158552743)
47558 47558 176131 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 18 : 4 Tree 1 Private 1     8 Width 0ft   5982371.75936 2092747.6193099997 37.72526546002779 -122.503143998992 (37.7252654600278, -122.503143998992)
119121 119121 176115 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Skyline Blvd 1 : 4 Tree 1 Private 1     8 Width 0ft   5982387.31367 2092831.90061 37.7254977881756 -122.503096467121 (37.7254977881756, -122.503096467121)
182925 182925 250695 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 880 El Camino Del Mar 3 : 4 Tree 1 Private 1     6 Width 4ft   5985648.066930001 2115011.43689 37.786587807629296 -122.49345792196002 (37.7865878076293, -122.49345792196)
75343 75343 250694 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 880 El Camino Del Mar 2 : 4 Tree 1 Private 1     6 Width 4ft   5985651.502 2115013.05675 37.786592456228796 -122.49344615702101 (37.7865924562288, -122.493446157021)
150745 150745 250693 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 880 El Camino Del Mar 1 : 4 Tree 1 Private 1     5 Width 4ft   5985657.4589 2115013.3530200003 37.7865936181467 -122.493425569734 (37.7865936181467, -122.493425569734)
156291 156291 250976 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 7010 California St 5 : 4 Tree 1 Private 1     2 Width 4ft   5985685.129819999 2113916.728 37.783584222178995 -122.49324901662399 (37.783584222179, -122.493249016624)
160175 160175 250975 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 7010 California St 4 : 4 Tree 1 Private 1     2 Width 4ft   5985704.58491 2113917.1556700002 37.7835865343301 -122.49318174196699 (37.7835865343301, -122.493181741967)
70752 70752 250974 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 7010 California St 3 : 4 Tree 1 Private 1     2 Width 4ft   5985720.677490001 2113918.49675 37.78359115774511 -122.493126167444 (37.7835911577451, -122.493126167444)
63635 63635 250692 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 850 El Camino Del Mar 3 : 4 Tree 1 Private 1     5 Width 4ft   5985754.9302 2115039.63583 37.7866714841451 -122.49309028449801 (37.7866714841451, -122.493090284498)
33448 33448 250973 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 7010 California St 2 : 4 Tree 1 Private 1     2 Width 4ft   5985735.07087 2113919.4528200002 37.7835946246316 -122.493076443038 (37.7835946246316, -122.493076443038)
38838 38838 250972 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 7010 California St 1 : 4 Tree 1 Private 1     3 Width 4ft   5985754.51701 2113919.45983 37.78359578115 -122.493009168333 (37.78359578115, -122.493009168333)
56642 56642 250691 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 850 El Camino Del Mar 2 : 4 Tree 1 Private 1     5 Width 4ft   5985780.23123 2115050.10184 37.786701700454394 -122.49300352150401 (37.7867017004544, -122.493003521504)
159556 159556 250690 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 850 El Camino Del Mar 1 : 4 Tree 1 Private 1     4 Width 4ft   5985788.39353 2115054.1604299997 37.786713321507705 -122.492975581372 (37.7867133215077, -122.492975581372)
56426 56426 250971 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 7002 California St 1 : 4 Tree 1 Private 1     10 Width 4ft   5985825.16294 2113921.74383 37.783606183626105 -122.492764932276 (37.7836061836261, -122.492764932276)
171666 171666 250762 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 231 32nd Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   5985862.1127 2114339.7343200003 37.7847560253059 -122.492667897222 (37.7847560253059, -122.492667897222)
134419 134419 250765 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 233 32nd Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5985862.4280199995 2114310.4019 37.784675505401204 -122.49266464526 (37.7846755054012, -122.49266464526)
68219 68219 250767 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 233 32nd Ave 2 : 4 Tree 1 Private 1     1 Width 3ft   5985862.448919999 2114296.67471 37.784637815729106 -122.492663561601 (37.7846378157291, -122.492663561601)
42206 42206 250768 Undocumented 2 Maytenus boaria :: Mayten 22 243 32nd Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   5985861.97079 2114274.2224 37.78457614022079 -122.492663561571 (37.7845761402208, -122.492663561571)
60502 60502 250769 Undocumented 2 Maytenus boaria :: Mayten 22 243 32nd Ave 2 : 4 Tree 1 Private 1     2 Width 3ft   5985862.54385 2114271.7143599996 37.7845692873761 -122.49266139422501 (37.7845692873761, -122.492661394225)
69600 69600 250770 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 247 32nd Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5985863.4711 2114256.40781 37.7845273142332 -122.492657058592 (37.7845273142332, -122.492657058592)
52635 52635 250772 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 251 32nd Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   5985866.25825 2114225.46269 37.784442510848706 -122.492645136277 (37.7844425108487, -122.492645136277)
136118 136118 250773 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 259 32nd Ave 1 : 4 Tree 1 Private 1     14 Width 3ft   5985865.92055 2114194.89594 37.7843585636424 -122.492644052605 (37.7843585636424, -122.492644052605)
161174 161174 250774 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 261 32nd Ave 1 : 4 Tree 1 Private 1     30 Width 3ft   5985867.52173 2114167.09587 37.7842823263074 -122.49263646501998 (37.7842823263074, -122.49263646502)
45724 45724 250780 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 267 32nd Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   5985869.60841 2114147.39692 37.7842283606933 -122.49262779465401 (37.7842283606933, -122.492627794654)
49844 49844 250781 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 267 32nd Ave 2 : 4 Tree 1 Private 1     10 Width 3ft   5985871.01478 2114139.87947 37.784207802179296 -122.49262237534599 (37.7842078021793, -122.492622375346)
176726 176726 250782 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 271 32nd Ave 1 : 4 Tree 1 Private 1     15 Width 3ft   5985871.45629 2114116.47181 37.784143557323105 -122.492619123386 (37.7841435573231, -122.492619123386)
150150 150150 250783 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 273 32nd Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5985872.78396 2114090.54911 37.7840724587071 -122.492612620392 (37.7840724587071, -122.492612620392)
161089 161089 250788 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 281 32nd Ave 1 : 4 Tree 1 Private 1     10 Width 3ft   5985872.14911 2114023.45685 37.7838882056181 -122.492609873852 (37.7838882056181, -122.492609873852)
40407 40407 250787 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 277 32nd Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   5985873.31121 2114054.8468299997 37.7839744613866 -122.49260816604601 (37.7839744613866, -122.492608166046)
152382 152382 250789 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 285 32nd Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5985873.63674 2113998.18517 37.7838189038641 -122.492602865457 (37.7838189038641, -122.492602865457)
66286 66286 250757 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 206 32nd Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5985901.09635 2114492.32613 37.785177277657496 -122.492544270121 (37.7851772776575, -122.492544270121)
61799 61799 250759 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 220 32nd Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5985901.189119999 2114438.7345 37.785030135971 -122.49254000101601 (37.785030135971, -122.492540001016)
170118 170118 250758 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 214 32nd Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5985901.94322 2114466.62788 37.785106767213705 -122.49253944703699 (37.7851067672137, -122.492539447037)
147077 147077 250761 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 2 : 4 Tree 1 Private 1     6 Width 3ft   5985903.37202 2114379.41265 37.7848673829594 -122.49252807871001 (37.7848673829594, -122.49252807871)
73215 73215 250760 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5985903.61307 2114361.31306 37.7848177008131 -122.492525911365 (37.7848177008131, -122.492525911365)
135546 135546 250763 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 234 32nd Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   5985904.694069999 2114338.51574 37.7847551691681 -122.492520492032 (37.7847551691681, -122.492520492032)
173278 173278 250764 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 240 32nd Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   5985906.3948800005 2114315.3934 37.784691781350006 -122.492512904459 (37.78469178135, -122.492512904459)
131266 131266 250766 Undocumented 2 Olea europaea :: Olive Tree 41 242 32nd Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5985905.94434 2114279.52557 37.7845932723154 -122.49251182078699 (37.7845932723154, -122.492511820787)
34500 34500 250771 Undocumented 2 Maytenus boaria :: Mayten 22 244 32nd Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5985908.77802 2114250.7634799997 37.7845144656071 -122.49249989847401 (37.7845144656071, -122.492499898474)
158740 158740 250775 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 254 32nd Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5985910.66114 2114192.0713299997 37.7843534240234 -122.49248905984699 (37.7843534240234, -122.492489059847)
48618 48618 250784 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 266 32nd Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5985911.86598 2114116.23526 37.784145270524604 -122.49247930488501 (37.7841452705246, -122.492479304885)
134897 134897 250785 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 270 32nd Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5985911.734180001 2114095.33531 37.784087877591794 -122.492478221206 (37.7840878775918, -122.492478221206)
54070 54070 250786 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 276 32nd Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5985914.65421 2114070.62696 37.7840202063211 -122.49246629890101 (37.7840202063211, -122.492466298901)
63976 63976 250791 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 284 32nd Ave 2 : 4 Tree 1 Private 1     2 Width 3ft   5985916.223259999 2114026.60434 37.7838994246524 -122.492457627626 (37.7838994246524, -122.492457627626)
24071 24071 250790 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 284 32nd Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5985915.81821 2114007.58209 37.7838471713633 -122.49245762762101 (37.7838471713633, -122.492457627621)
64821 64821 250792 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 290 32nd Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5985918.61873 2113977.26033 37.7837640802965 -122.492445705309 (37.7837640802965, -122.492445705309)
29631 29631 250970 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6932 California St 1 : 4 Tree 1 Private 1     9 Width 4ft   5985996.4910699995 2113927.35673 37.7836316119485 -122.49217262437 (37.7836316119485, -122.49217262437)
158454 158454 250756 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Lake St 1 : 4 Tree 1 Private 1     6 Width 0ft   5986048.1037 2114785.2005 37.7859900201618 -122.492057248563 (37.7859900201618, -122.492057248563)
55403 55403 250969 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6924 California St 3 : 4 Tree 1 Private 1     8 Width 4ft   5986098.00978 2113930.24714 37.7836454821978 -122.49182162619199 (37.7836454821978, -122.491821626192)
150018 150018 250810 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Sea View Ter 1 : 4 Tree 1 Private 1     5 Width 3ft   5986123.508640001 2114127.60677 37.784188865162 -122.491747944716 (37.784188865162, -122.491747944716)
166606 166606 250811 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 55 Sea View Ter 2 : 4 Tree 1 Private 1     5 Width 3ft   5986145.66751 2114125.50365 37.784184385653894 -122.491671129117 (37.7841843856539, -122.491671129117)
55273 55273 250478 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 475 Seacliff Ave 1 : 4 Tree 1 Private 1     7 Width 2ft   5986370.30078 2115143.81022 37.78699348730329 -122.49096894838199 (37.7869934873033, -122.490968948382)
155594 155594 250479 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 475 Seacliff Ave 2 : 4 Tree 1 Private 1     7 Width 2ft   5986378.77885 2115146.97988 37.787002685577 -122.490939849906 (37.787002685577, -122.490939849906)
137660 137660 250480 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 475 Seacliff Ave 3 : 4 Tree 1 Private 1     7 Width 2ft   5986385.0033 2115149.63936 37.7870103513788 -122.490918510779 (37.7870103513788, -122.490918510779)
65183 65183 250481 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 475 Seacliff Ave 4 : 4 Tree 1 Private 1     7 Width 2ft   5986391.51376 2115152.57183 37.787018783437205 -122.490896202225 (37.7870187834372, -122.490896202225)
62944 62944 250482 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 475 Seacliff Ave 5 : 4 Tree 1 Private 1     7 Width 2ft   5986400.2603 2115155.17733 37.7870264483565 -122.49086613336901 (37.7870264483565, -122.490866133369)

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