Data source: data.sfgov.org
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) |
JSON shape: default, array, newline-delimited
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");