Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
3 3 119263 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Lakeshore Dr 1 Median : Yard 3 Tree 1 DPW 2       10x30            
1098 1098 251438 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2501X Santiago St 1 Median : Yard 3 Tree 1 DPW 2                    
22823 22823 251110 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 5 Median : Yard 3 Tree 1 DPW 2                    
22825 22825 251109 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 3 Median : Yard 3 Tree 1 DPW 2                    
22828 22828 251115 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 19 Median : Yard 3 Tree 1 DPW 2                    
22831 22831 251116 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 20 Median : Yard 3 Tree 1 DPW 2                    
22832 22832 251108 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 2 Median : Yard 3 Tree 1 DPW 2                    
22833 22833 251113 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 15 Median : Yard 3 Tree 1 DPW 2                    
22838 22838 251111 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 7 Median : Yard 3 Tree 1 DPW 2                    
22839 22839 251114 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 16 Median : Yard 3 Tree 1 DPW 2                    
22840 22840 251107 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1700X Quesada Ave 1 Median : Yard 3 Tree 1 DPW 2                    
95665 95665 106062 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 140X CANYON DR 2 Median : Yard 3 Tree 1 DPW 2     30     6002713.0 2086188.2 37.708429419739794 -122.432358106226 (37.7084294197398, -122.432358106226)
108704 108704 106057 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 140X CANYON DR 1 Median : Yard 3 Tree 1 DPW 2     18     6002713.0 2086188.2 37.708429419739794 -122.432358106226 (37.7084294197398, -122.432358106226)
11659 11659 106061 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 12X Canyon Dr 1 Median : Yard 3 Tree 1 DPW 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
10408 10408 106060 DPW Maintained 3 Calocedrus decurrens :: Incense Cedar 177 12X Canyon Dr 3 Median : Yard 3 Tree 1 DPW 2     24     6003183.55845 2086355.5239400002 37.7089155261884 -122.430743733243 (37.7089155261884, -122.430743733243)
57966 57966 188747 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 15 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6014639.494109999 2086953.6057 37.7112001369439 -122.391191848221 (37.7112001369439, -122.391191848221)
71605 71605 188746 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 14 Median : Yard 3 Tree 1 DPW 2     19 Width 8ft   6014613.42303 2086955.91765 37.7112050382485 -122.391282118582 (37.7112050382485, -122.391282118582)
133838 133838 188745 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 13 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014589.916680001 2086958.4326 37.711210639227 -122.39136353872101 (37.711210639227, -122.391363538721)
37820 37820 188744 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 12 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6014566.93251 2086961.4469700002 37.7112176404424 -122.391443188965 (37.7112176404424, -122.391443188965)
32164 32164 188743 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 11 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014538.0462 2086963.8159 37.711222541749 -122.391543193559 (37.711222541749, -122.391543193559)
63133 63133 188742 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 10 Median : Yard 3 Tree 1 DPW 2     16 Width 8ft   6014513.510980001 2086966.09658 37.7112274421761 -122.391628153428 (37.7112274421761, -122.391628153428)
168939 168939 188741 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 9 Median : Yard 3 Tree 1 DPW 2     19 Width 8ft   6014489.73327 2086967.85233 37.7112309432358 -122.39171045846399 (37.7112309432358, -122.391710458464)
178538 178538 188740 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 8 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6014461.35341 2086969.95596 37.711235143968 -122.391808694124 (37.711235143968, -122.391808694124)
186731 186731 188739 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 7 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014439.36233 2086971.4204900002 37.7112379444543 -122.39188480373801 (37.7112379444543, -122.391884803738)
149419 149419 188738 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 6 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014415.87146 2086974.70005 37.7112456453465 -122.39196622388799 (37.7112456453465, -122.391966223888)
71411 71411 188737 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 5 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014387.73209 2086976.03412 37.7112477461551 -122.39206357459899 (37.7112477461551, -122.392063574599)
65570 65570 188736 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 4 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014364.73249 2086978.28388 37.7112526465696 -122.39214322484 (37.7112526465696, -122.39214322484)
75165 75165 188735 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 3 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014342.21925 2086979.24909 37.711254046810495 -122.39222110431601 (37.7112540468105, -122.392221104316)
174612 174612 188734 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 2 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6014314.36158 2086981.8522700001 37.71125964778079 -122.39231757011801 (37.7112596477808, -122.392317570118)
56907 56907 187701 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 10 Median : Yard 3 Tree 1 DPW 2     24 Width 8ft   6014160.4254 2086993.65928 37.7112835184788 -122.392850441814 (37.7112835184788, -122.392850441814)
30017 30017 187699 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 8 Median : Yard 3 Tree 1 DPW 2     24 Width 8ft   6014113.89856 2087000.13929 37.7112987269205 -122.393011704639 (37.7112987269205, -122.393011704639)
153767 153767 187700 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 9 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014134.283869999 2086999.7269 37.7112987269389 -122.392941218475 (37.7112987269389, -122.392941218475)
157079 157079 187711 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 2 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   6013709.84578 2087009.9917799998 37.711303326954706 -122.394408912955 (37.7113033269547, -122.394408912955)
170303 170303 188764 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 7 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014090.1968 2087004.6185400002 37.711309709434 -122.393093937756 (37.711309709434, -122.393093937756)
173558 173558 188762 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 5 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6014035.24999 2087007.2689599998 37.71131393444921 -122.39328403465299 (37.7113139344492, -122.393284034653)
137789 137789 188763 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 6 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014060.27429 2087007.0702 37.711314778934295 -122.39319752976601 (37.7113147789343, -122.393197529766)
147853 147853 188761 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 4 Median : Yard 3 Tree 1 DPW 2     23 Width 8ft   6013991.40971 2087009.0790099998 37.7113164687655 -122.39343568552 (37.7113164687655, -122.39343568552)
29957 29957 187712 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 3 Median : Yard 3 Tree 1 DPW 2     10 Width 8ft   6013733.01886 2087017.8562099999 37.7113262093072 -122.39432937061301 (37.7113262093072, -122.394329370613)
166786 166786 188760 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 2 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6013911.80932 2087014.9974599998 37.7113282966477 -122.393711220721 (37.7113282966477, -122.393711220721)
152573 152573 187713 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 4 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6013756.4546300005 2087023.9293400003 37.71134418764721 -122.394248794959 (37.7113441876472, -122.394248794959)
148081 148081 178035 DPW Maintained 3 Olea europaea :: Olive Tree 41 1378x Geneva Ave 3 Median : Yard 3 Tree 1 DPW 2     6     6002505.07902 2087811.4607 37.7128747474362 -122.433192611453 (37.7128747474362, -122.433192611453)
188176 188176 178034 DPW Maintained 3 Olea europaea :: Olive Tree 41 1378x Geneva Ave 2 Median : Yard 3 Tree 1 DPW 2     7     6002495.00651 2087816.3446 37.7128875861582 -122.433227774048 (37.7128875861582, -122.433227774048)
136110 136110 178033 DPW Maintained 3 Olea europaea :: Olive Tree 41 1378x Geneva Ave 1 Median : Yard 3 Tree 1 DPW 2     6     6002471.97564 2087830.38013 37.712924818104 -122.433308378475 (37.712924818104, -122.433308378475)
177514 177514 177792 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 290x Rolph St 1 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6001464.09036 2088085.72956 37.7135687209947 -122.43681022251499 (37.7135687209947, -122.436810222515)
157761 157761 116545 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 1 Median : Yard 3 Tree 1 DPW 2     2 3x3   6001537.057630001 2088100.5912 37.7136136745151 -122.436559085032 (37.7136136745151, -122.436559085032)
146422 146422 116546 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 2 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001545.434780001 2088113.86518 37.7136505979649 -122.43653108014401 (37.7136505979649, -122.436531080144)
30642 30642 176917 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 9 Median : Yard 3 Tree 1 DPW 2     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224)
64250 64250 116547 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 3 Median : Yard 3 Tree 1 DPW 2     4 3x3   6001554.67745 2088129.8106 37.7136949057732 -122.436500274771 (37.7136949057732, -122.436500274771)
27784 27784 177494 DPW Maintained 3 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 1002x Naples St 8 Median : Yard 3 Tree 1 DPW 2     1     6001533.96245 2088133.73568 37.7137045060241 -122.43657215399901 (37.7137045060241, -122.436572153999)
59010 59010 116551 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 7 Median : Yard 3 Tree 1 DPW 2     4 3x3   6001523.56178 2088140.13665 37.713721490625 -122.43660856033199 (37.713721490625, -122.436608560332)
187703 187703 187521 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 100x Mary Teresa St 1 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
137930 137930 116541 DPW Maintained 3 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 1041x Naples St 4 Median : Yard 3 Tree 1 DPW 2     1 3x3   6001548.78537 2088145.26253 37.7137369985308 -122.436521745206 (37.7137369985308, -122.436521745206)
158984 158984 116549 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 5 Median : Yard 3 Tree 1 DPW 2     4 3x3   6001562.82912 2088145.2407900002 37.713737736870705 -122.43647320339599 (37.7137377368707, -122.436473203396)
151872 151872 116550 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 6 Median : Yard 3 Tree 1 DPW 2     5 3x3   6001534.78323 2088160.3445099997 37.7137776146169 -122.43657122050399 (37.7137776146169, -122.436571220504)
51471 51471 116543 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 6 Median : Yard 3 Tree 1 DPW 2     5 3x3   6001574.8493099995 2088164.89401 37.713792383287796 -122.43643306305 (37.7137923832878, -122.43643306305)
51303 51303 116542 DPW Maintained 3 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 1002x Naples St 5 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001553.5279 2088171.08536 37.7138081717955 -122.436507200445 (37.7138081717955, -122.436507200445)
156295 156295 116548 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 4 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001544.87474 2088178.1549900002 37.713827091712396 -122.436537614614 (37.7138270917124, -122.436537614614)
23771 23771 116544 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 7 Median : Yard 3 Tree 1 DPW 2     5 3x3   6001586.02621 2088182.95127 37.713842599620904 -122.436395723209 (37.7138425996209, -122.436395723209)
44260 44260 116540 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 3 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001555.506159999 2088195.95431 37.713876568835396 -122.43650214175399 (37.7138765688354, -122.436502141754)
24383 24383 116552 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 8 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838)
158635 158635 116539 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 2 Median : Yard 3 Tree 1 DPW 2     3 3x3   6001567.487380001 2088213.7256900002 37.7139260459311 -122.436462001442 (37.7139260459311, -122.436462001442)
171144 171144 176918 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1041x Naples St 9 Median : Yard 3 Tree 1 DPW 2     4     6001604.803669999 2088215.9120200002 37.713934169489704 -122.43633317895599 (37.7139341694897, -122.436333178956)
11046 11046 116538 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 1 Median : Yard 3 Tree 1 DPW 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
110134 110134 117310 Permitted Site 1 Tree(s) :: 17 126X Juan Bautista Cir 1 Median : Yard 3 Tree 1 Private 1   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777998 5989282.4 2089642.3 37.7171428191075 -122.479027821944 (37.7171428191075, -122.479027821944)
89670 89670 114428 Undocumented 2 Pinus radiata :: Monterey Pine 3 34x HIGUERA AVE 2 Median : Yard 3 Tree 1 Private 1     56     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
109545 109545 111090 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 28x HIGUERA AVE 1 Median : Yard 3 Tree 1 Private 1   06/04/2015 12:00:00 AM 3   Permit Number 777485 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
85176 85176 104920 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 1 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
101258 101258 104921 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 2 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
111624 111624 104922 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 3 Median : Yard 3 Tree 1 Private 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
128606 128606 104928 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 3 Median : Yard 3 Tree 1 Private 1     12     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
143894 143894 104927 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 2 Median : Yard 3 Tree 1 Private 1     10     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
144760 144760 104926 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 1 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
82353 82353 109678 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 7 Median : Yard 3 Tree 1 DPW 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
83234 83234 109676 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 5 Median : Yard 3 Tree 1 DPW 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
109683 109683 109675 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 4 Median : Yard 3 Tree 1 DPW 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
110858 110858 104466 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 1 Median : Yard 3 Tree 1 DPW 2     50     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
141517 141517 109677 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 6 Median : Yard 3 Tree 1 DPW 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
146161 146161 109674 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 3 Median : Yard 3 Tree 1 DPW 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
54386 54386 211064 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 300x Miramar Ave 3 Median : Yard 3 Tree 1 DPW 2     35     5995363.79151 2092232.49572 37.724606167023396 -122.458194844436 (37.7246061670234, -122.458194844436)
109029 109029 108973 Property Tree 7 Pinus radiata :: Monterey Pine 3 3485X SAN BRUNO AVE 1 Median : Yard 3 Tree 1 DPW for City Agency 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
3898 3898 212122 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     3     5995365.2918 2092257.6675200001 37.724675368963105 -122.45819147914699 (37.7246753689631, -122.458191479147)
55770 55770 212123 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 5 Median : Yard 3 Tree 1 DPW 2     5     5995365.84941 2092284.31295 37.724748562969395 -122.458191479165 (37.7247485629694, -122.458191479165)
23869 23869 212124 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 6 Median : Yard 3 Tree 1 DPW 2     5     5995365.62659 2092320.18392 37.72484704325171 -122.45819484441999 (37.7248470432517, -122.45819484442)
68934 68934 212125 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 7 Median : Yard 3 Tree 1 DPW 2     5     5995367.349909999 2092356.01382 37.7249455225917 -122.45819147917 (37.7249455225917, -122.45819147917)
81264 81264 99456 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 400X Miramar Ave 6 Median : Yard 3 Tree 1 Private 1   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
127178 127178 108238 Undocumented 2 Tree(s) :: 17 764x JUNIPERO SERRA BLVD 1 Median : Yard 3 Tree 1 Private 1           5991289.6 2092496.8 37.7250969308873 -122.47229792145599 (37.7250969308873, -122.472297921456)
56164 56164 211065 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 400x Miramar Ave 1 Median : Yard 3 Tree 1 DPW 2     25     5995367.472159999 2092431.62053 37.7251531275117 -122.458196526171 (37.7251531275117, -122.458196526171)
183025 183025 212126 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 400x Miramar Ave 2 Median : Yard 3 Tree 1 DPW 2     7     5995367.13793 2092485.42648 37.725300846538 -122.458201574057 (37.725300846538, -122.458201574057)
60832 60832 212127 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 400x Miramar Ave 3 Median : Yard 3 Tree 1 DPW 2     7     5995366.60081 2092506.27853 37.7253580704006 -122.45820493932699 (37.7253580704006, -122.458204939327)
23986 23986 204965 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 400x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     15     5995367.63483 2092532.42925 37.725429933419 -122.458203256674 (37.725429933419, -122.458203256674)
49497 49497 215224 DPW Maintained 3 Syzygium paniculatum :: Brush Cherry 198 400x Miramar Ave 5 Median : Yard 3 Tree 1 DPW 2     29     5995369.41897 2092571.1657099999 37.7255363969609 -122.45819989143101 (37.7255363969609, -122.458199891431)
148876 148876 209172 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 600x Faxon Ave 2 Median : Yard 3 Tree 1 DPW 2     31     5994902.7257 2092594.45065 37.725573503888 -122.45981488494199 (37.725573503888, -122.459814884942)
76146 76146 212128 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 400x Miramar Ave 6 Median : Yard 3 Tree 1 DPW 2     4     5995370.49354 2092599.25425 37.7256135830958 -122.458198208781 (37.7256135830958, -122.458198208781)
167933 167933 209105 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 600x Faxon Ave 1 Median : Yard 3 Tree 1 DPW 2     31     5994942.183230001 2092612.57817 37.7256255467665 -122.459679796903 (37.7256255467665, -122.459679796903)
69390 69390 212050 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 600x Faxon Ave 3 Median : Yard 3 Tree 1 DPW 2     18     5994919.39436 2092637.6704099998 37.7256931335128 -122.45976039233999 (37.7256931335128, -122.45976039234)
123989 123989 215225 DPW Maintained 3 Syzygium paniculatum :: Brush Cherry 198 500x Miramar Ave 1 Median : Yard 3 Tree 1 DPW 2     39     5995372.41973 2092668.0374099999 37.7258025558202 -122.458196526156 (37.7258025558202, -122.458196526156)
63844 63844 211066 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 500x Miramar Ave 2 Median : Yard 3 Tree 1 DPW 2     36     5995372.70371 2092704.8662900003 37.7259036953978 -122.45819820880199 (37.7259036953978, -122.458198208802)
53859 53859 212129 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 500x Miramar Ave 3 Median : Yard 3 Tree 1 DPW 2     28     5995370.8895 2092734.46918 37.7259848735758 -122.45820662195601 (37.7259848735758, -122.458206621956)
135183 135183 204966 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 500x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     9     5995372.18711 2092773.2155 37.726091336224606 -122.458204939301 (37.7260913362246, -122.458204939301)
131258 131258 211067 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 500x Miramar Ave 5 Median : Yard 3 Tree 1 DPW 2     39     5995372.66361 2092795.985 37.7261538831809 -122.458204939322 (37.7261538831809, -122.458204939322)

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