trees
8,298 rows where qLegalStatus_id = 4 sorted by PermitNotes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4231 | 261663 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1099x Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | 3x3 | 6008393 | 2118190 | 37.7966195766837 | -122.414990814528 | (37.7966195766837, -122.414990814528) | 5 | 1 | 10 | 308 | 21 | |||
| 4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 4280 | 264767 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 90x Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
| 4298 | 262513 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
| 4317 | 261373 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1701x 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2020 12:00:00 AM | 3 | 3x3 | 5983095 | 2103514 | 37.7548694854578 | -122.501439939014 | (37.7548694854578, -122.501439939014) | 1 | 8 | 3 | 56 | 35 | ||
| 4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 4337 | 106918 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 274 PUTNAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009044.8 | 2096077.1 | 37.7359392652864 | -122.411172625582 | (37.7359392652864, -122.411172625582) | 10 | 7 | 7 | 28859 | 2 | |||||
| 4356 | 262525 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 4364 | 228727 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004008.60516 | 2106001.5865 | 37.7629058684239 | -122.429292229258 | (37.7629058684239, -122.429292229258) | 8 | 4 | 5 | 28862 | 3 | |||
| 4382 | 264774 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
| 4438 | 254757 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 13 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
| 4474 | 109514 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1501x FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | ||||
| 4476 | 112909 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 4509 | 262192 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799x 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992411 | 2103494 | 37.7553572944486 | -122.469221443954 | (37.7553572944486, -122.469221443954) | 1 | 8 | 4 | 56 | 12 | ||||
| 4569 | 104897 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 303 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 4589 | 261026 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 758 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 3x3 | 5989802 | 2110189 | 37.7735888483109 | -122.478733667362 | (37.7735888483109, -122.478733667362) | 11 | 6 | 2 | 55 | 26 | |||
| 4591 | 113471 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 4620 | 115387 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x8 | 5992895.1 | 2098893.2 | 37.7427526388588 | -122.467212790357 | (37.7427526388588, -122.467212790357) | 1 | 8 | 4 | 59 | 40 | |||
| 4623 | 106966 | Undocumented 4 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 4645 | 107053 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | |||||
| 4670 | 107425 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1600X Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997832.17799 | 2108247.26578 | 37.7687203321672 | -122.450816174345 | (37.7687203321672, -122.450816174345) | 15 | 5 | 11 | 29492 | 9 | |||||
| 4689 | 100758 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
| 4696 | 117040 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
| 4710 | 143042 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 443 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010246.7521 | 2120590.0026 | 37.8033133880365 | -122.408745792286 | (37.8033133880365, -122.408745792286) | 3 | 1 | 10 | 308 | 23 | |||
| 4752 | 107181 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.446241403234 | (37.7711622584795, -122.446241403234) | 15 | 5 | 11 | 29492 | 9 | |||
| 4754 | 101985 | Undocumented 4 | Tree(s) :: 17 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005538.6 | 2109749.6 | 37.7732835163003 | -122.424267082997 | (37.7732835163003, -122.424267082997) | 7 | 9 | 11 | 28852 | 10 | ||||
| 4789 | 96243 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 100X 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005866.5 | 2100251.5 | 37.7472224703829 | -122.422457811013 | (37.7472224703829, -122.422457811013) | 2 | 7 | 5 | 28859 | 22 | |||
| 4853 | 107519 | Undocumented 4 | Tree(s) :: 17 | 100x CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004015.5 | 2108290.9 | 37.7691921614924 | -122.429431648714 | (37.7691921614924, -122.429431648714) | 7 | 9 | 5 | 28862 | 3 | ||||||
| 4862 | 113857 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011184 | 2102716 | 37.7542879873687 | -122.40424363426 | (37.7542879873687, -122.40424363426) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4869 | 102616 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 2000X Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6009928.4 | 2120915.8 | 37.8041901109125 | -122.409870477339 | (37.8041901109125, -122.409870477339) | 3 | 1 | 10 | 308 | 23 | |||
| 4872 | 262191 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799x 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992411 | 2103494 | 37.7553572944486 | -122.469221443954 | (37.7553572944486, -122.469221443954) | 1 | 8 | 4 | 56 | 12 | ||||
| 4883 | 264808 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
| 4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
| 4964 | 104791 | Undocumented 4 | Tree(s) :: 17 | 98X 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005767 | 2099074 | 37.7439837097913 | -122.422718209223 | (37.7439837097913, -122.422718209223) | 2 | 7 | 5 | 28859 | 22 | ||||
| 4983 | 112267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 5012 | 261384 | Undocumented 4 | Potential Site :: Potential Site 48 | 246 Leavenworth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008558 | 2113314 | 37.7832405398106 | -122.41407474629 | (37.7832405398106, -122.41407474629) | 7 | 10 | 9 | 28852 | 36 | |||||
| 5017 | 262484 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 2 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
| 5054 | 102983 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
| 5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
| 5100 | 101532 | Undocumented 4 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
| 5119 | 254683 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:28:00 PM | 3 | 3x3 | 5999858 | 2092352 | 37.7251915169836 | -122.442667568748 | (37.7251915169836, -122.442667568748) | 9 | 7 | 6 | 28861 | 25 | ||
| 5249 | 100990 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
| 5250 | 264790 | Undocumented 4 | Potential Site :: Potential Site 48 | 2640 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011026 | 2101818 | 37.7518134471323 | -122.404726825793 | (37.7518134471323, -122.404726825793) | 10 | 4 | 8 | 28859 | 19 | ||||
| 5279 | 258778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 701X Ortega Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5991876 | 2102480 | 37.7525421857889 | -122.470997752755 | (37.7525421857889, -122.470997752755) | 1 | 8 | 4 | 29491 | 12 | ||||
| 5330 | 121676 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993867 | 2101351 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | 1 | 8 | 4 | 29491 | 40 | ||||
| 5372 | 256588 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 5426 | 102462 | Undocumented 4 | Tree(s) :: 17 | 3354 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007825.6 | 2104471.5 | 37.7589199559787 | -122.415982170306 | (37.7589199559787, -122.415982170306) | 2 | 4 | 7 | 28859 | 19 | |||
| 5429 | 116488 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2149 LYON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999319 | 2116238 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | 13 | 6 | 1 | 29490 | 31 | |||||
| 5491 | 125353 | Undocumented 4 | Acer palmatum :: Japanese Maple 216 | 2083 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6003071.4644 | 2118540.95305 | 37.7972827324699 | -122.43342959001 | (37.7972827324699, -122.43342959001) | 13 | 9 | 1 | 57 | 17 | |||
| 5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 5495 | 260381 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015697 | 2093053 | 37.7280065148754 | -122.387962157958 | (37.7280065148754, -122.387962157958) | 10 | 3 | 8 | 58 | 1 | ||||
| 5555 | 256038 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6015087 | 2093984 | 37.7305290408635 | -122.390135976897 | (37.7305290408635, -122.390135976897) | 10 | 3 | 8 | 58 | 1 | ||
| 5583 | 244247 | Undocumented 4 | :: 45 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005673.0642 | 2110022.689 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | 7 | 9 | 11 | 28852 | 10 | |||
| 5584 | 110379 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2194 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011949 | 2097537 | 37.7401102866319 | -122.401234145483 | (37.7401102866319, -122.401234145483) | 10 | 3 | 8 | 58 | 1 | ||||
| 5644 | 264791 | Undocumented 4 | Potential Site :: Potential Site 48 | 2640 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011026 | 2101818 | 37.7518134471323 | -122.404726825793 | (37.7518134471323, -122.404726825793) | 10 | 4 | 8 | 28859 | 19 | ||||
| 5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
| 5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 5731 | 261315 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 198 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006408 | 2115479 | 37.789064104593 | -122.421666719739 | (37.789064104593, -122.421666719739) | 13 | 9 | 10 | 28858 | 21 | ||||
| 5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
| 5772 | 262554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
| 5796 | 262396 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 470 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6008904 | 2106030 | 37.7632598120529 | -122.412362703349 | (37.7632598120529, -122.412362703349) | 8 | 4 | 7 | 28859 | 19 | ||
| 5810 | 111954 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 73 SEACLIFF AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5987709 | 2115789 | 37.7888431121968 | -122.486384796167 | (37.7888431121968, -122.486384796167) | 11 | 6 | 1 | 55 | 33 | ||||
| 5856 | 104233 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 298X Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5997366.55609 | 2109687.30332 | 37.7726476392362 | -122.452530652813 | (37.7726476392362, -122.452530652813) | 15 | 5 | 11 | 29492 | 16 | ||||
| 5908 | 105725 | Undocumented 4 | Ficus laurel :: 247 | 895 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002505 | 2109533 | 37.7725170259656 | -122.434745213579 | (37.7725170259656, -122.434745213579) | 15 | 5 | 11 | 29492 | 9 | |||
| 5972 | 136242 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006678.63942 | 2116999.88567 | 37.7932553363267 | -122.420838360099 | (37.7932553363267, -122.420838360099) | 13 | 9 | 10 | 28858 | 32 | |||
| 5992 | 115018 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4311 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000722 | 2105756 | 37.7620449359843 | -122.440641810954 | (37.7620449359843, -122.440641810954) | 15 | 5 | 5 | 28862 | 3 | |||
| 6007 | 261051 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 770 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2113137 | 37.7826496144307 | -122.420514344125 | (37.7826496144307, -122.420514344125) | 7 | 9 | 9 | 28852 | 36 | ||||
| 6071 | 258212 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987967 | 2106401 | 37.7630813299835 | -122.484803190012 | (37.7630813299835, -122.484803190012) | 1 | 8 | 3 | 56 | 35 | ||||
| 6145 | 117568 | Undocumented 4 | Tree(s) :: 17 | 2636 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990923 | 2095039.4 | 37.7320570487265 | -122.473750606168 | (37.7320570487265, -122.473750606168) | 1 | 8 | 4 | 64 | 40 | |||||
| 6168 | 107105 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 532 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6002950.4 | 2105092.9 | 37.7603508695767 | -122.432887270079 | (37.7603508695767, -122.432887270079) | 2 | 4 | 5 | 28862 | 3 | |||
| 6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
| 6197 | 122456 | Undocumented 4 | Arbutus unedo :: Strawberry Tree 106 | 1355x 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013550 | 2105274 | 37.7614436228031 | -122.396240621174 | (37.7614436228031, -122.396240621174) | 10 | 3 | 8 | 28856 | 29 | ||||
| 6266 | 112694 | Undocumented 4 | Tree(s) :: 17 | 1x CUMBERLAND ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6005299 | 2104587 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | 2 | 4 | 5 | 28859 | 19 | ||||
| 6304 | 105356 | Undocumented 4 | Tree(s) :: 17 | 207-211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006236 | 2101921 | 37.7518273734539 | -122.421298642673 | (37.7518273734539, -122.421298642673) | 2 | 4 | 5 | 28859 | 19 | |||
| 6331 | 261440 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 374x Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
| 6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 6380 | 110632 | Undocumented 4 | Tree(s) :: 17 | 1051X Mandalay Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991736.20076 | 2101819.33429 | 37.7507200830769 | -122.47143306251 | (37.7507200830769, -122.47143306251) | 1 | 8 | 4 | 29491 | 12 | |||||
| 6381 | 118299 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 | ||||
| 6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 6391 | 246158 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1652 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5997620.7172 | 2108179.7857 | 37.7685229419277 | -122.451542729467 | (37.7685229419277, -122.451542729467) | 15 | 5 | 11 | 29492 | 9 | |||
| 6425 | 102410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
| 6440 | 259042 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3612 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981996 | 2098820 | 37.7419164682935 | -122.504892709134 | (37.7419164682935, -122.504892709134) | 1 | 8 | 3 | 29491 | 35 | ||||
| 6455 | 117452 | Undocumented 4 | Tree(s) :: 17 | 1530 HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016055 | 2097226 | 37.7394845622146 | -122.387015456594 | (37.7394845622146, -122.387015456594) | 10 | 3 | 8 | 58 | 1 | ||||
| 6505 | 261618 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1900x Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2089018 | 37.7167576107691 | -122.398233561415 | (37.7167576107691, -122.398233561415) | 10 | 3 | 8 | 58 | 1 | ||||
| 6533 | 258833 | Undocumented 4 | Potential Site :: Potential Site 48 | 1199X Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996025 | 2091881 | 37.7236790151497 | -122.455883747529 | (37.7236790151497, -122.455883747529) | 9 | 8 | 4 | 28861 | 24 | ||||
| 6537 | 261310 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1751 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987774 | 2103374 | 37.7547587692818 | -122.485248582837 | (37.7547587692818, -122.485248582837) | 1 | 8 | 3 | 56 | 35 | ||||
| 6639 | 261563 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1801 25th St | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
| 6675 | 264798 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 698 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009708 | 2091117 | 37.7223570514359 | -122.408529889307 | (37.7223570514359, -122.408529889307) | 10 | 3 | 7 | 309 | 28 | ||||
| 6686 | 113093 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 598x ARBOR ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000747 | 2096921 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | 2 | 7 | 5 | 63 | 7 | ||||
| 6708 | 256455 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2901 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 6720 | 116625 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 6 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 6759 | 111228 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
| 6775 | 256471 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 6793 | 106402 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 163 25TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | 5987994.2 | 2114906.9 | 37.7864377375077 | -122.485333302781 | (37.7864377375077, -122.485333302781) | 11 | 6 | 1 | 55 | 33 | ||
| 6838 | 256837 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1201x Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 6858 | 261031 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6011107 | 2121175 | 37.8049677916951 | -122.405810090856 | (37.8049677916951, -122.405810090856) | 3 | 1 | 10 | 308 | 23 | ||||
| 7079 | 120113 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 266 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999649 | 2094406 | 37.7308194078275 | -122.443537538611 | (37.7308194078275, -122.443537538611) | 9 | 7 | 4 | 63 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );