Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlotSize, PermitNotes
PlantDate ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
63333 | 63333 | 118678 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4749 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5980862.87698 | 2110909.19366 | 37.77504319711021 | -122.50970838455 | (37.7750431971102, -122.50970838455) | |||
38458 | 38458 | 118677 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4749 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5980875.63021 | 2110909.60557 | 37.7750450801709 | -122.50966429974702 | (37.7750450801709, -122.509664299747) | |||
134641 | 134641 | 184184 | Undocumented 2 | :: 54 | 1642 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5980990.4302 | 2103889.7643 | 37.7557774014806 | -122.508745894794 | (37.7557774014806, -122.508745894794) | |||
158331 | 158331 | 184392 | Undocumented 2 | :: 54 | 2040 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5981213.3751 | 2101162.7638 | 37.748302968665705 | -122.50777253673 | (37.7483029686657, -122.50777253673) | |||
40221 | 40221 | 182926 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2646 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 5981556.704 | 2097178.5239 | 37.7373835743826 | -122.506289933268 | (37.7373835743826, -122.506289933268) | |||
169416 | 169416 | 183302 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4500 Irving St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5981770.8567 | 2106269.7 | 37.7623579967214 | -122.506223442565 | (37.7623579967214, -122.506223442565) | |||
33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
154869 | 154869 | 117819 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3936 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 1ft | 5983305.904569999 | 2111075.09338 | 37.775642477392395 | -122.501269829965 | (37.7756424773924, -122.501269829965) | |||
75864 | 75864 | 117818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3936 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 1ft | 5983313.54909 | 2111075.82361 | 37.775644931310396 | -122.501243440143 | (37.7756449313104, -122.501243440143) | |||
156512 | 156512 | 117781 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 563 40th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5983463.79311 | 2111964.41208 | 37.7780935589435 | -122.500789443294 | (37.7780935589435, -122.500789443294) | |||
77219 | 77219 | 118070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.51413 | 2113017.90855 | 37.7810780733056 | -122.49544393016599 | (37.7810780733056, -122.495443930166) | |||
158745 | 158745 | 118071 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.745180001 | 2113002.45389 | 37.7810356528066 | -122.49544199070401 | (37.7810356528066, -122.495441990704) | |||
167495 | 167495 | 182403 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1520 35th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 0ft | 5985303.3969 | 2104828.602 | 37.758608470378704 | -122.49389967209801 | (37.7586084703787, -122.493899672098) | |||
175275 | 175275 | 182213 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2730 Lawton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5985735.4613 | 2104364.4813 | 37.75735939305871 | -122.492371241702 | (37.7573593930587, -122.492371241702) | |||
43305 | 43305 | 250477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 330 Seacliff Ave | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5986717.515380001 | 2115494.0026 | 37.78797529338429 | -122.489793444531 | (37.7879752933843, -122.489793444531) | |||
134533 | 134533 | 181882 | Undocumented 2 | :: 54 | 2339 32nd Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5986377.6918 | 2099330.2097 | 37.7435741741127 | -122.48977995723999 | (37.7435741741127, -122.48977995724) | |||
136603 | 136603 | 119968 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 540 28th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5987220.74694 | 2112250.93523 | 37.7791001265755 | -122.487814013837 | (37.7791001265755, -122.487814013837) | |||
132766 | 132766 | 119970 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 542 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 3ft | 5987221.67588 | 2112220.77085 | 37.779017357921205 | -122.487808583512 | (37.7790173579212, -122.487808583512) | |||
49645 | 49645 | 119969 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 540 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5987222.6278800005 | 2112233.92491 | 37.7790535307721 | -122.48780625689501 | (37.7790535307721, -122.487806256895) | |||
164089 | 164089 | 119971 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 552 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 3ft | 5987224.33596 | 2112187.66675 | 37.77892661860329 | -122.487796948534 | (37.7789266186033, -122.487796948534) | |||
169948 | 169948 | 182141 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1414 25th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5988378.9203 | 2105649.8128 | 37.761042756843 | -122.48332344606001 | (37.761042756843, -122.48332344606) | |||
24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
175818 | 175818 | 182134 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1434 25th Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 5988383.0453 | 2105547.1446 | 37.7607610979396 | -122.483301653477 | (37.7607610979396, -122.483301653477) | |||
52034 | 52034 | 182133 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1434 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5988383.962 | 2105543.0196 | 37.760749825160204 | -122.48329818067499 | (37.7607498251602, -122.483298180675) | |||
188216 | 188216 | 182185 | Undocumented 2 | :: 54 | 1638 25th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5988431.9652 | 2104143.1815 | 37.756909042216 | -122.483029559375 | (37.756909042216, -122.483029559375) | |||
157884 | 157884 | 251043 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 5527 Geary Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 5989811.4148 | 2112601.8948 | 37.780214536371105 | -122.478877614898 | (37.7802145363711, -122.478877614898) | |||
152354 | 152354 | 218987 | Undocumented 2 | Fraxinus velutina :: Modesto Ash 405 | 1628 18th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 5990606.34235 | 2104296.88686 | 37.7574573626709 | -122.475521050754 | (37.7574573626709, -122.475521050754) | |||
40341 | 40341 | 218986 | Undocumented 2 | Fraxinus velutina :: Modesto Ash 405 | 1628 18th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 5990607.414890001 | 2104273.45371 | 37.757393083633 | -122.475515630561 | (37.757393083633, -122.475515630561) | |||
33419 | 33419 | 218015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990772.5777900005 | 2099709.35635 | 37.7448708407289 | -122.474611345145 | (37.7448708407289, -122.474611345145) | |||
75447 | 75447 | 218016 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990785.97144 | 2099709.33017 | 37.7448715449012 | -122.474565030958 | (37.7448715449012, -122.474565030958) | |||
155116 | 155116 | 218017 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990797.83143 | 2099709.8496 | 37.7448736582987 | -122.474524059638 | (37.7448736582987, -122.474524059638) | |||
154116 | 154116 | 218018 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.82418 | 2099712.3546 | 37.7448814050516 | -122.474472400799 | (37.7448814050516, -122.474472400799) | |||
154305 | 154305 | 218019 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990820.542769999 | 2099711.9352700002 | 37.744880700881794 | -122.474445681024 | (37.7448807008818, -122.474445681024) | |||
50974 | 50974 | 218020 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990823.88989 | 2099711.8646400003 | 37.7448807008746 | -122.474434102269 | (37.7448807008746, -122.474434102269) | |||
73699 | 73699 | 218021 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990833.9529 | 2099712.67814 | 37.744883517556 | -122.474399365956 | (37.744883517556, -122.474399365956) | |||
162250 | 162250 | 122264 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400 Balboa St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 5991175.02195 | 2111348.8824 | 37.7768531954343 | -122.474068870116 | (37.7768531954343, -122.474068870116) | |||
28203 | 28203 | 122263 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 5991199.98338 | 2111351.52204 | 37.7768618890602 | -122.473982714477 | (37.7768618890602, -122.473982714477) | |||
179302 | 179302 | 122262 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 5991232.29363 | 2111350.84044 | 37.7768618890585 | -122.47387089491501 | (37.7768618890585, -122.473870894915) | |||
188186 | 188186 | 218852 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1346 16th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 5991155.44082 | 2106257.8165599997 | 37.7628733705378 | -122.473765117276 | (37.7628733705378, -122.473765117276) | |||
182212 | 182212 | 217542 | Undocumented 2 | Yucca spp :: Yucca 402 | 1366 16th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 5991156.21032 | 2106109.4885 | 37.7624661458171 | -122.473751634653 | (37.7624661458171, -122.473751634653) | |||
67868 | 67868 | 206024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991156.52884 | 2106111.8053099997 | 37.7624725256075 | -122.473750702041 | (37.7624725256075, -122.473750702041) | |||
59914 | 59914 | 206025 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991157.5258599995 | 2106131.34791 | 37.76252624212071 | -122.473748679463 | (37.7625262421207, -122.473748679463) | |||
55172 | 55172 | 217543 | Undocumented 2 | Yucca spp :: Yucca 402 | 1366 16th Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5991159.18226 | 2106131.31297 | 37.762526242118795 | -122.47374294808701 | (37.7625262421188, -122.473742948087) | |||
70726 | 70726 | 207526 | Undocumented 2 | Dracaena draco :: Dragon Tree 361 | 1366 16th Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 4ft | 5991165.61053 | 2106115.5186099997 | 37.7624832473222 | -122.473719563019 | (37.7624832473222, -122.473719563019) | |||
50258 | 50258 | 205681 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5991402.87169 | 2104383.6674599997 | 37.7577417813829 | -122.472772688422 | (37.7577417813829, -122.472772688422) | ||||
183958 | 183958 | 205682 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5991412.37682 | 2104411.58455 | 37.757818984582705 | -122.47274185157801 | (37.7578189845827, -122.472741851578) | ||||
86115 | 86115 | 205683 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5991416.24805 | 2104429.61687 | 37.7578687206724 | -122.47272977815399 | (37.7578687206724, -122.472729778154) | ||||
148664 | 148664 | 205684 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5991419.75521 | 2104444.35599 | 37.757909393427205 | -122.472718723697 | (37.7579093934272, -122.472718723697) | ||||
187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
180357 | 180357 | 211093 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2088 15th Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 6ft | 5991644.9229 | 2101275.9651599997 | 37.749222851651 | -122.471709112392 | (37.749222851651, -122.471709112392) | |||
71741 | 71741 | 211060 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2088 15th Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 6ft | 5991645.7062 | 2101259.684 | 37.7491781931242 | -122.471705217417 | (37.7491781931242, -122.471705217417) | |||
57486 | 57486 | 205505 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2088 15th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5991647.261530001 | 2101306.76233 | 37.7493075480059 | -122.471703269501 | (37.7493075480059, -122.471703269501) | |||
76912 | 76912 | 205506 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2088 15th Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 6ft | 5991647.44658 | 2101288.81124 | 37.749258269671394 | -122.47170132158399 | (37.7492582696714, -122.471701321584) | |||
163971 | 163971 | 205504 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2088 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 6ft | 5991648.1199199995 | 2101320.76563 | 37.7493460471025 | -122.471701321557 | (37.7493460471025, -122.471701321557) | |||
34594 | 34594 | 211059 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2088 15th Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 6ft | 5991648.13538 | 2101268.0455099996 | 37.749201292209996 | -122.47169742662201 | (37.74920129221, -122.471697426622) | |||
174453 | 174453 | 203702 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 10ft | 5991651.27757 | 2101417.16458 | 37.7496109163211 | -122.47169742658899 | (37.7496109163211, -122.471697426589) | |||
176190 | 176190 | 211061 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2088 15th Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5991650.04455 | 2101251.74063 | 37.749156633693204 | -122.47168963668999 | (37.7491566336932, -122.47168963669) | |||
164564 | 164564 | 211062 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2088 15th Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 33 | Width 6ft | 5991653.15073 | 2101238.7756 | 37.7491212147934 | -122.47167795088998 | (37.7491212147934, -122.47167795089) | |||
176402 | 176402 | 210907 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 3ft | 5991740.69924 | 2105187.8933900003 | 37.7599695243799 | -122.47166295830499 | (37.7599695243799, -122.471662958305) | |||
76642 | 76642 | 179830 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 966 Randolph St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5991498.1765 | 2088667.9539299998 | 37.7145959293389 | -122.471298058377 | (37.7145959293389, -122.471298058377) | |||
60475 | 60475 | 179831 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 966 Randolph St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5991499.58423 | 2088662.2150700002 | 37.7145802532566 | -122.47129277485399 | (37.7145802532566, -122.471292774854) | |||
75602 | 75602 | 210344 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2222 15th Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 5ft | 5991737.50971 | 2099005.7982900003 | 37.7429949142736 | -122.47122357203399 | (37.7429949142736, -122.471223572034) | |||
43352 | 43352 | 211539 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2222 15th Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 5ft | 5991737.95589 | 2099026.97767 | 37.7430530932385 | -122.471223572022 | (37.7430530932385, -122.471223572022) | |||
155751 | 155751 | 211540 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2222 15th Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 5ft | 5991738.81904 | 2098988.7367 | 37.7429481432502 | -122.47121780198 | (37.7429481432502, -122.47121780198) | |||
150797 | 150797 | 214670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2250 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 5991762.46474 | 2100100.36567 | 37.7460017588674 | -122.47121701506398 | (37.7460017588674, -122.471217015064) | ||||
50421 | 50421 | 211541 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2222 15th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 5991738.93886 | 2098974.6083299997 | 37.742909357292596 | -122.471216358549 | (37.7429093572926, -122.471216358549) | |||
173908 | 173908 | 211094 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 Aerial Way | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 39 | Width 4ft | 5992285.42513 | 2102561.07483 | 37.752788467513206 | -122.46958780504801 | (37.7527884675132, -122.469587805048) | |||
130043 | 130043 | 211339 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 66 Aerial Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5992292.226009999 | 2102565.50209 | 37.7528010166768 | -122.469564608839 | (37.7528010166768, -122.469564608839) | |||
154212 | 154212 | 211095 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 Aerial Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 38 | Width 4ft | 5992315.3975 | 2102577.1661799997 | 37.7528343824016 | -122.469485327309 | (37.7528343824016, -122.469485327309) | |||
58150 | 58150 | 211299 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 212 Vernon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5992481.14355 | 2089300.95007 | 37.71639079536521 | -122.46794656929701 | (37.7163907953652, -122.467946569297) | |||
123984 | 123984 | 211058 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 447 Lawton St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5992805.57319 | 2104540.3462 | 37.7582530810297 | -122.467933005722 | (37.7582530810297, -122.467933005722) | |||
50595 | 50595 | 211057 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 447 Lawton St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5992810.26786 | 2104540.37946 | 37.7582534434534 | -122.467916772063 | (37.7582534434534, -122.467916772063) | |||
23569 | 23569 | 211718 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 5992705.448530001 | 2090061.4664900003 | 37.7184919399203 | -122.46722653339701 | (37.7184919399203, -122.467226533397) | |||
171576 | 171576 | 211717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5992705.603080001 | 2090068.8173099998 | 37.7185121324114 | -122.46722653337099 | (37.7185121324114, -122.467226533371) | |||
75798 | 75798 | 209607 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 488 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 5992758.831730001 | 2090447.2277099998 | 37.719554228122504 | -122.46707004236099 | (37.7195542281225, -122.467070042361) | |||
187861 | 187861 | 206442 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 488 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 5992758.93765 | 2090436.99405 | 37.719526135091 | -122.467068932605 | (37.719526135091, -122.467068932605) | |||
32493 | 32493 | 215383 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 270 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5992739.059780001 | 2088994.50565 | 37.7155642635536 | -122.467032825702 | (37.7155642635536, -122.467032825702) | |||
159117 | 159117 | 210296 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1620 10th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 5993107.6826599995 | 2104438.8623 | 37.7579918738475 | -122.46688081061701 | (37.7579918738475, -122.466880810617) | |||
23836 | 23836 | 204823 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1331 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | |||
181841 | 181841 | 211099 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 501 Saint Francis Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 46 | Width 10ft | 5993137.63738 | 2096084.35497 | 37.7350542531473 | -122.46617009617201 | (37.7350542531473, -122.466170096172) | |||
65175 | 65175 | 208929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 501 Saint Francis Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 6ft | 5993145.62708 | 2096072.03007 | 37.735020873007 | -122.466141577798 | (37.735020873007, -122.466141577798) | |||
148613 | 148613 | 211089 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1826 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 3ft | 5993465.35 | 2103031.19551 | 37.754147421393 | -122.465541593268 | (37.754147421393, -122.465541593268) | |||
1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
175036 | 175036 | 206722 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1754 08th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 5993756.8033300005 | 2103555.3829900003 | 37.755603511019395 | -122.46457174369199 | (37.7556035110194, -122.464571743692) | |||
162791 | 162791 | 206723 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1754 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5993756.651269999 | 2103543.92939 | 37.7555720536195 | -122.464571437933 | (37.7555720536195, -122.464571437933) | |||
132900 | 132900 | 203344 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 779 Head St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5993497.055240001 | 2090994.5846900002 | 37.721099722042496 | -122.464558015558 | (37.7210997220425, -122.464558015558) | |||
159985 | 159985 | 217535 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 385 Head St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 4ft | 5993463.79196 | 2088414.8734 | 37.714014537420795 | -122.464485782892 | (37.7140145374208, -122.464485782892) | |||
42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
177371 | 177371 | 208620 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 92 Allston Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 5993943.80464 | 2098648.69817 | 37.742141779624795 | -122.46356895556801 | (37.7421417796248, -122.463568955568) | |||
123744 | 123744 | 208884 | Undocumented 2 | Malus :: Crab Apple 235 | 450 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 5993793.0659300005 | 2090164.68597 | 37.7188380799952 | -122.46347460498001 | (37.7188380799952, -122.46347460498) | |||
176316 | 176316 | 210950 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 454 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 5993793.8030900005 | 2090199.81591 | 37.718934580840504 | -122.46347460496901 | (37.7189345808405, -122.463474604969) | |||
73783 | 73783 | 215385 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 522 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 5993803.26709 | 2090640.69025 | 37.7201456609819 | -122.46347386933701 | (37.7201456609819, -122.463473869337) | |||
186557 | 186557 | 207266 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 450 Bright St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5993794.13591 | 2090181.7036599999 | 37.7188848681307 | -122.463472140835 | (37.7188848681307, -122.463472140835) | |||
186143 | 186143 | 177480 | Undocumented 2 | Malus :: Crab Apple 235 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 5993810.32054 | 2086750.1830099998 | 37.7094636621006 | -122.46316734172501 | (37.7094636621006, -122.463167341725) | ||||
34597 | 34597 | 211298 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 401 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 5ft | 5993996.41913 | 2089243.4812200002 | 37.7163203865396 | -122.462704908526 | (37.7163203865396, -122.462704908526) | |||
31389 | 31389 | 211482 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 458 Orizaba Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 1ft | 5994045.41043 | 2089492.79513 | 37.7170077644759 | -122.46255364615699 | (37.7170077644759, -122.462553646157) | |||
188473 | 188473 | 215418 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 5994025.68496 | 2088506.9373700002 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | ||||
34503 | 34503 | 215417 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.46254606394699 | (37.7141751725286, -122.462546063947) |
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");