Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110779 | 110779 | 98279 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 501 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
92410 | 92410 | 98278 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
28294 | 28294 | 188658 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | ||||
26454 | 26454 | 188657 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6016750.167669999 | 2099204.87087 | 37.744956608177205 | -122.38474966268801 | (37.7449566081772, -122.384749662688) | ||||
56563 | 56563 | 188656 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 122 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016757.253769999 | 2099196.6677 | 37.7449344758533 | -122.384724588679 | (37.7449344758533, -122.384724588679) | ||||
164803 | 164803 | 241007 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1100 San Jose Ave | 73 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 2ft | 6004615.67946 | 2096502.52979 | 37.7368580125759 | -122.42651615071999 | (37.7368580125759, -122.42651615072) | |||
130560 | 130560 | 234016 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1101 San Jose Ave | 69 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6005055.13591 | 2096635.21867 | 37.7372471798214 | -122.425006192598 | (37.7372471798214, -122.425006192598) | |||
133988 | 133988 | 221178 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1101 San Jose Ave | 68 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005051.84205 | 2096632.8627099998 | 37.7372405248233 | -122.425017413417 | (37.7372405248233, -122.425017413417) | |||
45515 | 45515 | 222982 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1101 San Jose Ave | 67 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6005045.200569999 | 2096625.52578 | 37.7372200041006 | -122.425039854206 | (37.7372200041006, -122.425039854206) | |||
183497 | 183497 | 222981 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1101 San Jose Ave | 65 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005028.12161 | 2096593.96399 | 37.737132377752104 | -122.42509665898899 | (37.7371323777521, -122.425096658989) | |||
25022 | 25022 | 231947 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.73712794050989 | -122.42510507394199 | (37.7371279405099, -122.425105073942) | |||
151559 | 151559 | 221674 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1101 San Jose Ave | 63 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6005018.976419999 | 2096583.24508 | 37.7371024294214 | -122.425127515618 | (37.7371024294214, -122.425127515618) | |||
136117 | 136117 | 233516 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1101 San Jose Ave | 62 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 6005012.256 | 2096572.07245 | 37.737071372249 | -122.425149956418 | (37.737071372249, -122.425149956418) | |||
149828 | 149828 | 223773 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 310 Liberty St | 62 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003724.02134 | 2103929.75159 | 37.757200989348604 | -122.430128695891 | (37.7572009893486, -122.430128695891) | |||
65253 | 65253 | 225977 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6003712.20285 | 2103924.7270400003 | 37.7571865237503 | -122.43016921035499 | (37.7571865237503, -122.430169210355) | |||
24730 | 24730 | 222027 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 310 Liberty St | 60 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003716.8909599995 | 2103932.15667 | 37.7572071892775 | -122.430153527076 | (37.7572071892775, -122.430153527076) | |||
32401 | 32401 | 220372 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 310 Liberty St | 59 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003720.16644 | 2103926.0681 | 37.7571906570269 | -122.43014176485501 | (37.7571906570269, -122.430141764855) | |||
160613 | 160613 | 234868 | Undocumented 2 | Populus alba :: White Poplar 408 | 310 Liberty St | 58 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6003726.802759999 | 2103918.02855 | 37.7571689581965 | -122.430118240383 | (37.7571689581965, -122.430118240383) | |||
41425 | 41425 | 245695 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 310 Liberty St | 57 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6003740.43231 | 2103919.2524200003 | 37.757173090583294 | -122.43007119145399 | (37.7571730905833, -122.430071191454) | |||
149954 | 149954 | 228522 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 56 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003800.93288 | 2103921.01523 | 37.757181357156 | -122.429862082891 | (37.757181357156, -122.429862082891) | |||
188345 | 188345 | 228521 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 55 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003807.77119 | 2103922.75586 | 37.757186523762 | -122.429838557529 | (37.757186523762, -122.429838557529) | |||
178443 | 178443 | 221251 | Undocumented 2 | Betula pendula :: European White Birch 146 | 310 Liberty St | 54 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003815.34133 | 2103923.3524 | 37.757188590405995 | -122.429812419609 | (37.757188590406, -122.429812419609) | |||
74060 | 74060 | 223873 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 310 Liberty St | 53 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003827.49895 | 2103926.48833 | 37.757197889383 | -122.429770597528 | (37.757197889383, -122.429770597528) | |||
61277 | 61277 | 229249 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 310 Liberty St | 52 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003824.40718 | 2103923.16543 | 37.757188590409704 | -122.429781053062 | (37.7571885904097, -122.429781053062) | |||
49171 | 49171 | 245694 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 310 Liberty St | 51 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003830.82876 | 2103923.03299 | 37.75718859039571 | -122.42975883531099 | (37.7571885903957, -122.429758835311) | |||
152838 | 152838 | 237644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 310 Liberty St | 50 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6003839.23208 | 2103927.37536 | 37.757200989362104 | -122.42973008309099 | (37.7572009893621, -122.429730083091) | |||
178413 | 178413 | 230790 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 310 Liberty St | 49 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003847.77286 | 2103920.04922 | 37.7571813571443 | -122.42970002326 | (37.7571813571443, -122.42970002326) | |||
30625 | 30625 | 240316 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 48 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003835.66179 | 2103919.1699900003 | 37.75717825719121 | -122.429741845306 | (37.7571782571912, -122.429741845306) | |||
168373 | 168373 | 135089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 47 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010261.39064 | 2122348.4681700002 | 37.8081425174406 | -122.40881927081499 | (37.8081425174406, -122.408819270815) | |||
185288 | 185288 | 240315 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 47 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003842.5075900005 | 2103921.28681 | 37.757184457125895 | -122.429718320863 | (37.7571844571259, -122.429718320863) | |||
160693 | 160693 | 240314 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 46 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003848.60579 | 2103923.79505 | 37.75719168946971 | -122.42969740982299 | (37.7571916894697, -122.429697409823) | |||
29517 | 29517 | 135087 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010278.59779 | 2122338.55223 | 37.8081162545339 | -122.408759020708 | (37.8081162545339, -122.408759020708) | |||
170223 | 170223 | 223772 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 310 Liberty St | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 6003858.111380001 | 2103926.6096799998 | 37.7571999560244 | -122.429664736557 | (37.7571999560244, -122.429664736557) | |||
1103 | 1103 | 211013 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.47222310103399 | (37.727880584217, -122.472223101034) | |||
26044 | 26044 | 236017 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 310 Liberty St | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6003872.48103 | 2103927.0660200003 | 37.757202022681106 | -122.429615073291 | (37.7572020226811, -122.429615073291) | |||
188670 | 188670 | 194430 | Undocumented 2 | Pinus coulteri :: Coulter pine 435 | 800 Vermont St | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 5ft | 6011313.02989 | 2104102.06211 | 37.7581010164682 | -122.403894943896 | (37.7581010164682, -122.403894943896) | |||
154861 | 154861 | 240313 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 43 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6003879.74355 | 2103931.05559 | 37.757213388313296 | -122.42959024121001 | (37.7572133883133, -122.42959024121) | |||
176854 | 176854 | 191389 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.758149144577104 | -122.403906816767 | (37.7581491445771, -122.403906816767) | |||
28380 | 28380 | 234484 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 310 Liberty St | 42 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6003878.87158 | 2103925.4289 | 37.7571978893843 | -122.42959285554 | (37.7571978893843, -122.42959285554) | |||
34960 | 34960 | 135084 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 42 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010314.2182599995 | 2122318.99449 | 37.8080645489009 | -122.40863436569201 | (37.8080645489009, -122.408634365692) | |||
48027 | 48027 | 194435 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 800 Vermont St | 41 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 60 | 6011302.64565 | 2104147.13964 | 37.7582242092014 | -122.40393402935301 | (37.7582242092014, -122.403934029353) | ||||
171481 | 171481 | 224441 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 310 Liberty St | 41 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003891.83885 | 2103931.1825 | 37.757214421627395 | -122.42954842002399 | (37.7572144216274, -122.429548420024) | |||
64424 | 64424 | 135082 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010330.81932 | 2122308.7922400003 | 37.8080374658197 | -122.408576193042 | (37.8080374658197, -122.408576193042) | |||
158404 | 158404 | 240312 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6003905.5772400005 | 2103937.67287 | 37.7572330205097 | -122.42950137019699 | (37.7572330205097, -122.429501370197) | |||
172179 | 172179 | 191388 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6011282.56063 | 2104153.62595 | 37.7582408970175 | -122.40400394893 | (37.7582408970175, -122.40400394893) | |||
161702 | 161702 | 240311 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 310 Liberty St | 39 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6003913.51755 | 2103937.88547 | 37.757234053829 | -122.42947392468001 | (37.757234053829, -122.42947392468) | |||
177045 | 177045 | 191387 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 39 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6011279.1597 | 2104155.2145599998 | 37.7582450689735 | -122.40401582268801 | (37.7582450689735, -122.404015822688) | |||
51372 | 51372 | 240081 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 310 Liberty St | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003924.401980001 | 2103934.2743599997 | 37.757224754829004 | -122.429436024577 | (37.757224754829, -122.429436024577) | |||
133811 | 133811 | 135080 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010349.21464 | 2122298.25404 | 37.8080095607584 | -122.408511787199 | (37.8080095607584, -122.408511787199) | |||
147326 | 147326 | 191386 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6011275.5914199995 | 2104157.94605 | 37.758252369672604 | -122.40402835564899 | (37.7582523696726, -122.404028355649) | |||
69239 | 69239 | 191385 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | |||
185459 | 185459 | 241144 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 37 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003932.042169999 | 2103938.25616 | 37.7572361204712 | -122.42940988577699 | (37.7572361204712, -122.429409885777) | |||
73434 | 73434 | 135078 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 36 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010369.3857 | 2122286.4841400003 | 37.80797837316371 | -122.408441149043 | (37.8079783731637, -122.408441149043) | |||
146635 | 146635 | 199581 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 800 Vermont St | 36 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6011269.47396 | 2104166.61707 | 37.7582758365713 | -122.40405012282801 | (37.7582758365713, -122.404050122828) | |||
181639 | 181639 | 241143 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 36 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003940.3524 | 2103938.08481 | 37.7572361204768 | -122.429381133551 | (37.7572361204768, -122.429381133551) | |||
33343 | 33343 | 227094 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6009153.630890001 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | ||||
149568 | 149568 | 241142 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003936.5751 | 2103938.16269 | 37.757236120462 | -122.429394202477 | (37.757236120462, -122.429394202477) | |||
164118 | 164118 | 191384 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6011268.81564 | 2104171.75859 | 37.7582899172605 | -122.40405276143 | (37.7582899172605, -122.40405276143) | |||
33678 | 33678 | 135076 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010384.52328 | 2122278.10501 | 37.807956213866 | -122.408388169972 | (37.807956213866, -122.408388169972) | |||
133585 | 133585 | 213649 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999480.38992 | 2096117.32238 | 37.735508679678 | -122.44424337825001 | (37.735508679678, -122.44424337825) | |||
153695 | 153695 | 245823 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 100 Alemany Blvd | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6009152.02942 | 2095785.20865 | 37.7351438076288 | -122.41078128123999 | (37.7351438076288, -122.41078128124) | ||||
168497 | 168497 | 241141 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 310 Liberty St | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003944.5154 | 2103938.3753 | 37.7572371537833 | -122.429366756993 | (37.7572371537833, -122.429366756993) | |||
169449 | 169449 | 191383 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6011269.17641 | 2104180.10815 | 37.7583128634534 | -122.404052101317 | (37.7583128634534, -122.404052101317) | |||
133843 | 133843 | 213648 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999490.37481 | 2096123.0943099998 | 37.735525097687294 | -122.44420927146002 | (37.7355250976873, -122.44420927146) | |||
136406 | 136406 | 191382 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6011269.0108900005 | 2104184.59965 | 37.758325186865896 | -122.404052989848 | (37.7583251868659, -122.404052989848) | |||
137152 | 137152 | 245822 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 100 Alemany Blvd | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6009164.14819 | 2095772.28813 | 37.735109010158794 | -122.41073846992501 | (37.7351090101588, -122.410738469925) | ||||
160938 | 160938 | 228520 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6003938.215559999 | 2103926.08687 | 37.757203055998396 | -122.429387668006 | (37.7572030559984, -122.429387668006) | |||
33991 | 33991 | 211989 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 751 Junipero Serra Blvd | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991413.9184 | 2093039.12628 | 37.7265932181855 | -122.47190767821002 | (37.7265932181855, -122.47190767821) | |||
49096 | 49096 | 212850 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 3ft | 5999489.821880001 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | |||
61053 | 61053 | 135074 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010403.22449 | 2122267.85965 | 37.807929129896294 | -122.408322726326 | (37.8079291298963, -122.408322726326) | |||
173683 | 173683 | 191381 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6011271.17001 | 2104191.3624299997 | 37.7583438765916 | -122.40404599854601 | (37.7583438765916, -122.404045998546) | |||
182535 | 182535 | 245821 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 100 Alemany Blvd | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6009177.83151 | 2095781.65672 | 37.7351355014861 | -122.41069182297899 | (37.7351355014861, -122.410691822979) | ||||
184832 | 184832 | 223851 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 310 Liberty St | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003941.73153 | 2103931.6590400003 | 37.7572185549154 | -122.429375905766 | (37.7572185549154, -122.429375905766) | |||
33605 | 33605 | 227093 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009184.481319999 | 2095791.0539799999 | 37.7351616771725 | -122.41066949551201 | (37.7351616771725, -122.410669495512) | |||
62995 | 62995 | 194429 | Undocumented 2 | Pinus coulteri :: Coulter pine 435 | 800 Vermont St | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6011307.95664 | 2104238.22353 | 37.7584746020401 | -122.40392207106599 | (37.7584746020401, -122.403922071066) | ||||
134608 | 134608 | 213647 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5999489.23346 | 2096109.45083 | 37.7354875707953 | -122.444212237426 | (37.7354875707953, -122.444212237426) | |||
147406 | 147406 | 212283 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 751 Junipero Serra Blvd | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5991413.76911 | 2093002.29122 | 37.726492069641 | -122.47190551083 | (37.726492069641, -122.47190551083) | |||
54367 | 54367 | 213646 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999502.91716 | 2096107.4577900001 | 37.735482879036105 | -122.444164784704 | (37.7354828790361, -122.444164784704) | |||
62281 | 62281 | 135072 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010421.04395 | 2122258.5290599996 | 37.8079045082466 | -122.408260398818 | (37.8079045082466, -122.408260398818) | |||
75964 | 75964 | 229301 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 7ft | 6004947.77286 | 2104335.41432 | 37.75838407807579 | -122.42592536178002 | (37.7583840780758, -122.42592536178) | |||
159831 | 159831 | 212282 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 751 Junipero Serra Blvd | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991411.32325 | 2092975.49462 | 37.7264183513201 | -122.471912013829 | (37.7264183513201, -122.471912013829) | |||
163339 | 163339 | 135128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 7ft | 6009778.15443 | 2122482.07693 | 37.808482294798104 | -122.410501083081 | (37.8084822947981, -122.410501083081) | |||
170082 | 170082 | 191380 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6011289.9844 | 2104226.0484599997 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | ||||
171469 | 171469 | 227092 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6009197.49082 | 2095788.0482299998 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | |||
181241 | 181241 | 228519 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6003946.927 | 2103927.0362400003 | 37.7572061559445 | -122.42935760817 | (37.7572061559445, -122.42935760817) | |||
31171 | 31171 | 229300 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 6ft | 6004946.7397 | 2104361.09729 | 37.7584545390754 | -122.425930763098 | (37.7584545390754, -122.425930763098) | |||
42680 | 42680 | 213645 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5999496.4154900005 | 2096104.17607 | 37.7354734972877 | -122.444187027608 | (37.7354734972877, -122.444187027608) | |||
62104 | 62104 | 215587 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 5991411.41096 | 2092949.8935 | 37.7263480620905 | -122.47190984556002 | (37.7263480620905, -122.47190984556) | |||
69674 | 69674 | 222762 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 310 Liberty St | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003941.63846 | 2103927.1452900004 | 37.7572061559584 | -122.429375905767 | (37.7572061559584, -122.429375905767) | |||
171127 | 171127 | 227091 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6009293.034440001 | 2095834.7354700002 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | |||
186287 | 186287 | 191379 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011295.7098900005 | 2104243.81406 | 37.758489268176 | -122.403964819445 | (37.758489268176, -122.403964819445) | ||||
31717 | 31717 | 135070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010442.39712 | 2122245.83866 | 37.8078708592274 | -122.4081856049 | (37.8078708592274, -122.4081856049) | |||
47889 | 47889 | 135126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6009794.33207 | 2122480.55113 | 37.808479012257706 | -122.410444987853 | (37.8084790122577, -122.410444987853) | |||
153053 | 153053 | 205075 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 751 Junipero Serra Blvd | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991410.23162 | 2092923.6944900001 | 37.72627605788671 | -122.471912013823 | (37.7262760578867, -122.471912013823) | |||
154417 | 154417 | 191378 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011285.84337 | 2104240.2990099997 | 37.7584790653842 | -122.40399869511002 | (37.7584790653842, -122.40399869511) | ||||
162027 | 162027 | 250287 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6008296.47872 | 2112132.36375 | 37.779981358185296 | -122.414895849576 | (37.7799813581853, -122.414895849576) | |||
175268 | 175268 | 213644 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5999501.838169999 | 2096096.8027 | 37.7354535611166 | -122.44416774976001 | (37.7354535611166, -122.44416774976) | |||
2721 | 2721 | 175371 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993471.88559 | 2087712.01586 | 37.712085124705204 | -122.464406808033 | (37.7120851247052, -122.464406808033) | |||
25478 | 25478 | 213643 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999510.3328 | 2096092.78198 | 37.73544300577971 | -122.44413809190901 | (37.7354430057797, -122.444138091909) | |||
39563 | 39563 | 250286 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008300.87263 | 2112112.7782 | 37.7799278278445 | -122.414879262463 | (37.7799278278445, -122.414879262463) |
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");