Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
| 53 | 53 | 251187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 68 | 68 | 251188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 79 | 79 | 251205 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4X4 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||||
| 88 | 88 | 251208 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4115 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982071.0 | 2104840.0 | 37.758450113202294 | -122.505079418654 | (37.7584501132023, -122.505079418654) | ||||
| 125 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 142 | 142 | 251241 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2305 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998495.0 | 2111363.0 | 37.777313260379 | -122.44874797929701 | (37.777313260379, -122.448747979297) | |||||
| 155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 162 | 162 | 251231 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 164 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989598.0 | 2090848.0 | 37.7204716934452 | -122.478025052476 | (37.7204716934452, -122.478025052476) | ||||
| 166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 171 | 171 | 251242 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2449 Golden Gate Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997716.0 | 2111278.0 | 37.7770352956542 | -122.451436646998 | (37.7770352956542, -122.451436646998) | |||||
| 174 | 174 | 251226 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13x2.5 | 6000262.0 | 2104839.0 | 37.7595008741196 | -122.442166940047 | (37.7595008741196, -122.442166940047) | ||||
| 185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
| 241 | 241 | 251257 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
| 249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
| 251 | 251 | 251258 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1748x Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5986101.0 | 2094852.0 | 37.7312620395563 | -122.490407299046 | (37.7312620395563, -122.490407299046) | ||||
| 253 | 253 | 251256 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 4091x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086783.0 | 37.70943116445179 | -122.470511668938 | (37.7094311644518, -122.470511668938) | ||||
| 257 | 257 | 251260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1163 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007684.87734 | 2102881.8281400003 | 37.754547168222295 | -122.41635626045701 | (37.7545471682223, -122.416356260457) | ||||
| 258 | 258 | 251259 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1050x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009753.0 | 2116795.0 | 37.7928655753561 | -122.410186352148 | (37.7928655753561, -122.410186352148) | ||||
| 328 | 328 | 251272 | Undocumented 2 | Acer negundo :: Box Elder 74 | 1301X 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993949.0 | 2106317.0 | 37.7631972735035 | -122.46410754142299 | (37.7631972735035, -122.464107541423) | ||||
| 339 | 339 | 251273 | Undocumented 2 | Acer negundo :: Box Elder 74 | 1301X 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993949.0 | 2106317.0 | 37.7631972735035 | -122.46410754142299 | (37.7631972735035, -122.464107541423) | ||||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 454 | 454 | 251309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2111 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | ||||
| 462 | 462 | 187628 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779889 | 6003236.0 | 2095183.0 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | |||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 545 | 545 | 251322 | Undocumented 2 | Betula spp :: Birch 95 | 828 Foerster St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 3ft | 5998302.82159 | 2096489.58159 | 37.7364635618398 | -122.448341458403 | (37.7364635618398, -122.448341458403) | ||||
| 549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 592 | 592 | 251331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 651 | 651 | 251359 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4050 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994421.0 | 2112898.0 | 37.7812941506761 | -122.462952553035 | (37.7812941506761, -122.462952553035) | ||||
| 655 | 655 | 251353 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | ||||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 697 | 697 | 251362 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1300X Stanyan St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | ||||
| 752 | 752 | 251380 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 780 | 780 | 251383 | Undocumented 2 | Persea americana :: Avocado 113 | 49x Milan Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997587.0 | 2087495.0 | 37.711725600519706 | -122.450168218052 | (37.7117256005197, -122.450168218052) | ||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 783 | 783 | 251381 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 818 | 818 | 251389 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 202x Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999774.0 | 2095231.0 | 37.7330917931436 | -122.44316462438499 | (37.7330917931436, -122.443164624385) | ||||
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 859 | 859 | 251396 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 934 | 934 | 251409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95x Andover St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6007642.0 | 2098274.0 | 37.741892697320296 | -122.41617822056101 | (37.7418926973203, -122.416178220561) | ||||
| 938 | 938 | 251414 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 947 | 947 | 251413 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 955 | 955 | 251402 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 190 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007981.0 | 2093052.0 | 37.7275732783897 | -122.41463660892599 | (37.7275732783897, -122.414636608926) | ||||
| 961 | 961 | 251408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 75 Christmas Tree Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998776.0 | 2103023.0 | 37.75442978774979 | -122.447175546291 | (37.7544297877498, -122.447175546291) | ||||
| 963 | 963 | 251419 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 967 | 967 | 251416 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | ||||
| 970 | 970 | 251418 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 39 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/14/2015 12:00:00 AM | 3x3 | 6009068.0 | 2112723.0 | 37.781646426577 | -122.412268559085 | (37.781646426577, -122.412268559085) | |||
| 971 | 971 | 251415 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1034 | 1034 | 251427 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5028 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999606.0 | 2100130.0 | 37.7465337016449 | -122.44409733772801 | (37.7465337016449, -122.444097337728) | ||||
| 1106 | 1106 | 251445 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6014884.877230001 | 2114997.01321 | 37.7882150346369 | -122.39230385636002 | (37.7882150346369, -122.39230385636) | ||||
| 1148 | 1148 | 251463 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 1156 | 1156 | 251462 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 1157 | 1157 | 251464 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 1162 | 1162 | 251437 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3377 Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999965.0 | 2104239.0 | 37.7578364910366 | -122.443151017453 | (37.7578364910366, -122.443151017453) | ||||
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1178 | 1178 | 251465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1188 | 1188 | 251477 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1590 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999686.0 | 2114300.0 | 37.785445538345996 | -122.444839109459 | (37.785445538346, -122.444839109459) | ||||
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1305 | 1305 | 251497 | Undocumented 2 | Tree(s) :: 17 | 329x Warren Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5994610.0 | 2103362.0 | 37.7551216790189 | -122.461607123764 | (37.7551216790189, -122.461607123764) | ||||
| 1333 | 1333 | 187634 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |||
| 1364 | 1364 | 251507 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1365 | 1365 | 251509 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1372 | 1372 | 251508 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1375 | 1375 | 251506 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1398 | 1398 | 251517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Bonview St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6007188.0 | 2098162.0 | 37.7415596321362 | -122.417740072125 | (37.7415596321362, -122.417740072125) | ||||
| 1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
| 1438 | 1438 | 251533 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201X Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6002292.0 | 2112799.0 | 37.7814725496882 | -122.43571571002899 | (37.7814725496882, -122.435715710029) | ||||
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 1494 | 1494 | 251576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490X Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 1498 | 1498 | 251577 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 490X Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 1513 | 1513 | 251580 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 788 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012749.64869 | 2112405.5203400003 | 37.78098060211779 | -122.39950942241998 | (37.7809806021178, -122.39950942242) | ||||
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) |
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");