trees
222 rows where qCaretaker_id = 2 and qLegalStatus_id = 8 sorted by qAddress
This data as json, CSV (advanced)
These facets timed out: qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4239 | 258982 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 239 Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997275 | 2101153 | 37.7492093542443 | -122.452231443092 | (37.7492093542443, -122.452231443092) | 1 | 5 | 4 | 63 | 38 | ||||
139843 | 108680 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 240 SANTA ANA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 5992606.9 | 2095181.7 | 37.7325451527527 | -122.46793939449 | (37.7325451527527, -122.46793939449) | 9 | 8 | 4 | 59 | 40 | |||||
54211 | 98502 | Property Tree 8 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999066 | 2100737 | 37.7481695560511 | -122.446008243376 | (37.7481695560511, -122.446008243376) | 2 | 5 | 5 | 63 | 38 | ||||||
170932 | 102752 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 2452 Green St | Back Yard : Yard | Tree | Private 2 | 6001313 | 2117994 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | 13 | 9 | 1 | 57 | 17 | ||||||
137283 | 109242 | Property Tree 8 | Private shrub :: Private Shrub 284 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | 2 | 7 | 5 | 63 | 7 | ||||||
23775 | 108576 | Property Tree 8 | :: 45 | 2479 Diamond St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6002240 | 2097369 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | 2 | 7 | 5 | 63 | 7 | |||||
176836 | 102639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 251 Dorado Ter | 1 | Back Yard : Yard | Tree | Private 2 | 5994312.1 | 2092840.7 | 37.7262156610351 | -122.461874461465 | (37.7262156610351, -122.461874461465) | 9 | 8 | 4 | 28861 | 40 | |||||
20664 | 121198 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 2521 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990743 | 2098231 | 37.740809941753 | -122.47460574514 | (37.740809941753, -122.47460574514) | 1 | 8 | 4 | 29491 | 40 | |||
168913 | 114365 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2546 28th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 35 | 5987735.7 | 2097954.4 | 37.7398757613896 | -122.484983441996 | (37.7398757613896, -122.484983441996) | 1 | 8 | 3 | 29491 | 35 | ||||
113384 | 98890 | Property Tree 8 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999134 | 2100748 | 37.7482036421854 | -122.44577389345 | (37.7482036421854, -122.44577389345) | 2 | 5 | 5 | 63 | 38 | ||||||
92154 | 97177 | Property Tree 8 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard | Tree | Private 2 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.7658190148973 | -122.440304070451 | (37.7658190148973, -122.440304070451) | 15 | 5 | 5 | 28862 | 3 | |||||
176195 | 102381 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 258 Molimo Dr | Back Yard : Yard | Tree | Private 2 | 5997615 | 2096604 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | 9 | 7 | 4 | 59 | 40 | ||||||
127263 | 98715 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 26 Vernon St | Back Yard : Yard | Tree | Private 2 | 5992459 | 2088068 | 37.713004133171 | -122.467933479353 | (37.713004133171, -122.467933479353) | 9 | 8 | 6 | 64 | 24 | ||||||
136282 | 110181 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.7847814144727 | -122.444071244627 | (37.7847814144727, -122.444071244627) | 15 | 6 | 1 | 29490 | 31 | |||
96626 | 91109 | Property Tree 8 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard | Tree | Private 2 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | 15 | 6 | 2 | 29492 | 16 | ||||
109556 | 91108 | Property Tree 8 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard | Tree | Private 2 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | 15 | 6 | 2 | 29492 | 16 | ||||
227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
533 | 257925 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 274 Staples Ave | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998272.17919 | 2093819.44967 | 37.7291302611298 | -122.448255187535 | (37.7291302611298, -122.448255187535) | 9 | 7 | 4 | 28861 | 40 | |||||
28314 | 256608 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
87678 | 254111 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
113165 | 113482 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2839 Pierce St | Back Yard : Yard | Tree | Private 2 | 6001345 | 2118077 | 37.7959107386074 | -122.439370308548 | (37.7959107386074, -122.439370308548) | 13 | 9 | 1 | 57 | 17 | ||||||
33827 | 99268 | Property Tree 8 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout | Tree | Private 2 | 6004280 | 2096681 | 37.7373290690714 | -122.427689454915 | (37.7373290690714, -122.427689454915) | 2 | 7 | 5 | 63 | 7 | ||||||
80950 | 255115 | Property Tree 8 | Lophostemon confertus :: Brisbane Box 11 | 301X Chester Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
104559 | 254162 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 301X Chester Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
75016 | 98140 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 315 San Marcos Ave | Front Yard : Yard | Tree | Private 2 | 5992920.8 | 2100212.1 | 37.7463754865467 | -122.467219803339 | (37.7463754865467, -122.467219803339) | 1 | 8 | 4 | 29491 | 40 | ||||||
28928 | 116154 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 324 POPE ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000502 | 2087202 | 37.7110874704678 | -122.440072212787 | (37.7110874704678, -122.440072212787) | 9 | 7 | 6 | 28861 | 5 | ||||
99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
30075 | 100070 | Property Tree 8 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 777990 | 5990400 | 2090718 | 37.7201612636948 | -122.475243338807 | (37.7201612636948, -122.475243338807) | 1 | 8 | 4 | 64 | 40 | ||||
124062 | 102101 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.7184923011832 | -122.468164197766 | (37.7184923011832, -122.468164197766) | 9 | 8 | 6 | 64 | 24 |
193463 | 102056 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 332 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5990007.7 | 2113121.3 | 37.7816520743217 | -122.478236569715 | (37.7816520743217, -122.478236569715) | 11 | 6 | 2 | 55 | 26 | |||||
27030 | 106971 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3479X San Bruno Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6011510.60551 | 2091910.03431 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | 10 | 3 | 7 | 309 | 28 | ||||
117341 | 104397 | Property Tree 8 | Pseudotsuga menziesii :: Douglas Fir 285 | 350 Collingwood St | 1 | Front Yard : Yard | Tree | Private 2 | 6002086 | 2103822 | 37.7568122198273 | -122.435785890783 | (37.7568122198273, -122.435785890783) | 2 | 4 | 5 | 28862 | 3 | |||||
98201 | 106968 | Property Tree 8 | :: 45 | 351 26th Ave | Back Yard : Yard | Tree | Private 2 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.486185401226 | (37.7828456076198, -122.486185401226) | 11 | 6 | 2 | 55 | 26 | ||||||
5288 | 260453 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 4 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
7863 | 260451 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 2 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
8587 | 260455 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 6 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
12648 | 260457 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 8 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
16690 | 260450 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
19362 | 260454 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 5 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
19609 | 260452 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 3 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
158127 | 104008 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 357 Collingwood St | 1 | Back Yard : Yard | Tree | Private 2 | 36 | 6002124 | 2103789 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | 2 | 4 | 5 | 28862 | 3 | ||||
2059 | 264900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 35X Parkridge Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5999060 | 2101975 | 37.7515684597407 | -122.446118026985 | (37.7515684597407, -122.446118026985) | 2 | 5 | 5 | 63 | 38 | ||||
131293 | 254124 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 365 Edgehill Way | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5994964 | 2098864 | 37.7427916745102 | -122.460057057879 | (37.7427916745102, -122.460057057879) | 1 | 8 | 4 | 59 | 40 | ||||
92957 | 257936 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 375 Woodside Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
176576 | 257935 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
131954 | 110939 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 38 SAINT CHARLES AVE | 1 | Back Yard : Cutout | Tree | Private 2 | 30 | 3x3 | 5992046 | 2088201 | 37.7133454608488 | -122.46937060641 | (37.7133454608488, -122.46937060641) | 9 | 8 | 6 | 64 | 24 | |||
129920 | 106227 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 38 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997884 | 2095808.5 | 37.7345695210024 | -122.44974042874 | (37.7345695210024, -122.44974042874) | 9 | 7 | 4 | 59 | 40 | |||||
122758 | 121144 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 400 Franconia St | 1 | Back Yard : Yard | Tree | Private 2 | 15 | 3x3 | 6010016 | 2098808 | 37.7434921454983 | -122.408007311669 | (37.7434921454983, -122.408007311669) | 2 | 7 | 7 | 28859 | 2 | |||
145213 | 256660 | Property Tree 8 | Private shrub :: Private Shrub 284 | 40X Miguel St | 1 | Back Yard : Yard | Landscaping | Private 2 | 3x3 | 6003624 | 2097154 | 37.7385906898162 | -122.429991281012 | (37.7385906898162, -122.429991281012) | 2 | 7 | 5 | 63 | 7 | ||||
24750 | 94468 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
71699 | 94469 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
104809 | 94487 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
150726 | 106275 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 42 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | 9 | 7 | 4 | 59 | 40 | |||||
90477 | 109091 | Property Tree 8 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876 | (37.7525900037408, -122.43731782876) | 2 | 4 | 5 | 28862 | 22 |
40432 | 110929 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 445 BEACON ST | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002243 | 2098437 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | 2 | 7 | 5 | 63 | 7 | |||||
56024 | 105231 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6000051 | 2106345 | 37.7636239504047 | -122.443004833609 | (37.7636239504047, -122.443004833609) | 15 | 5 | 5 | 29492 | 3 | ||||
149052 | 105232 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard | Tree | Private 2 | 17 | 5999944 | 2106286 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | 15 | 5 | 5 | 29492 | 3 | ||||
97665 | 121104 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 477 Myra Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997298 | 2097021 | 37.7378652095891 | -122.45185385939 | (37.7378652095891, -122.45185385939) | 9 | 7 | 4 | 59 | 40 | ||||
150502 | 97162 | Property Tree 8 | Malus :: Crab Apple 82 | 478 10th Ave | Back Yard : Yard | Tree | Private 2 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | 11 | 6 | 2 | 54 | 11 | |||||
84644 | 118371 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999981 | 2101110 | 37.7492459313263 | -122.442870994168 | (37.7492459313263, -122.442870994168) | 2 | 4 | 5 | 28862 | 22 | ||||
178160 | 173600 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996184 | 2102497 | 37.7528370823128 | -122.456101271869 | (37.7528370823128, -122.456101271869) | 1 | 5 | 4 | 63 | 12 | ||||
6943 | 262154 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 519 22nd Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5989039 | 2111772 | 37.7778909946523 | -122.481488924787 | (37.7778909946523, -122.481488924787) | 11 | 6 | 2 | 55 | 26 | ||||
68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
364 | 255980 | Property Tree 8 | Tree(s) :: 17 | 541 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000551 | 2110847 | 37.7760138103106 | -122.441598590487 | (37.7760138103106, -122.441598590487) | 15 | 5 | 11 | 29492 | 16 | ||||
33684 | 97290 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 55 Hiliritas Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | 2 | 7 | 5 | 63 | 7 | |||||
120627 | 100045 | Property Tree 8 | Acacia decurrens :: Acacia: Silver Wattle 111 | 556 28th St | Front Yard : Yard | Tree | Private 2 | Not sure which property tree is located on. | 6002301 | 2099461 | 37.7448501592716 | -122.434730501666 | (37.7448501592716, -122.434730501666) | 2 | 7 | 5 | 63 | 22 | |||||
173830 | 98139 | Property Tree 8 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 556 Laidley St | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003085 | 2096041 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | 2 | 7 | 5 | 63 | 7 | |||||
58309 | 100046 | Property Tree 8 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard | Tree | Private 2 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262 | 2099459 | 37.7448424535299 | -122.434865213189 | (37.7448424535299, -122.434865213189) | 2 | 7 | 5 | 63 | 22 | |||
7179 | 260247 | Property Tree 8 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |||||
108384 | 122480 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 596X Buckingham Way | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5990152 | 2094375 | 37.7301880902761 | -122.476367577616 | (37.7301880902761, -122.476367577616) | 1 | 8 | 4 | 64 | 14 | ||||
9029 | 258675 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 60 Laidley St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003232 | 2097949 | 37.7407513687421 | -122.431403364879 | (37.7407513687421, -122.431403364879) | 2 | 7 | 5 | 63 | 7 | ||||
22075 | 187658 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 600X Clarendon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995637 | 2102382 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | 1 | 5 | 4 | 63 | 12 | ||||
48396 | 109097 | Property Tree 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 601 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 |
42557 | 101977 | Property Tree 8 | Cedrus deodara :: Deodar Cedar 109 | 601 Grand View Ave | Front Yard : Yard | Tree | Private 2 | 6000076.2 | 2101609.9 | 37.7506239629918 | -122.442577679409 | (37.7506239629918, -122.442577679409) | 2 | 4 | 5 | 28862 | 22 | ||||||
34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
145638 | 105686 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 3 | Front Yard : Pot | Tree | Private 2 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
179317 | 103673 | Property Tree 8 | :: 45 | 64 Henry St | Back Yard : Yard | Tree | Private 2 | 6003097 | 2107420 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | 15 | 5 | 5 | 28862 | 3 | ||||||
120621 | 101625 | Property Tree 8 | Fagus sylvatica :: European Beech 272 | 64 Levant St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.7639895997076 | -122.442236202383 | (37.7639895997076, -122.442236202383) | 15 | 5 | 5 | 28862 | 3 | ||||
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
167578 | 100472 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 70 Stanford Heights Ave | Back Yard : Yard | Tree | Private 2 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.449794826729 | (37.735113616296, -122.449794826729) | 9 | 7 | 4 | 59 | 40 | ||||||
80203 | 253469 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 701 Stanyan St | 5 | Side Yard : Yard | Tree | Private 2 | 5997178 | 2108423 | 37.7691653834469 | -122.453091601514 | (37.7691653834469, -122.453091601514) | 15 | 5 | 11 | 29492 | 9 | |||||
123806 | 256658 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 7014 Fulton St | 1 | Back Yard : Cutout | Tree | Private 2 | 5981603 | 2109659 | 37.7716541501084 | -122.507055421099 | (37.7716541501084, -122.507055421099) | 11 | 6 | 2 | 55 | 26 | |||||
149268 | 106458 | Property Tree 8 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard | Tree | Private 2 | 6003861.6 | 2105050 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | 2 | 4 | 5 | 28862 | 3 | ||||||
141124 | 100244 | Property Tree 8 | Persea americana :: Avocado 34 | 71 Sanchez St | Back Yard : Yard | Tree | Private 2 | Interior courtyard | 6003507 | 2107903 | 37.7680982797144 | -122.431162830878 | (37.7680982797144, -122.431162830878) | 7 | 9 | 5 | 28862 | 3 | |||||
67079 | 251294 | Property Tree 8 | :: 45 | 7126 Geary Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5984860 | 2112552 | 37.7797887789018 | -122.496002892522 | (37.7797887789018, -122.496002892522) | 11 | 6 | 2 | 55 | 26 | ||||
66427 | 248974 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 716 Goettingen St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010713 | 2091306 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | 10 | 3 | 7 | 309 | 28 | ||||
57789 | 121199 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 72 Fountain St | 1 | Back Yard : Yard | Tree | Private 2 | 6000322 | 2101283 | 37.7497403826665 | -122.441704227556 | (37.7497403826665, -122.441704227556) | 2 | 4 | 5 | 28862 | 22 | |||||
87602 | 253142 | Property Tree 8 | Juniperus silicicola :: Southern red cedar 429 | 735 29th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5986898 | 2110914 | 37.7754104499772 | -122.488832209773 | (37.7754104499772, -122.488832209773) | 11 | 6 | 2 | 55 | 26 | ||||
163643 | 253143 | Property Tree 8 | Juniperus silicicola :: Southern red cedar 429 | 735 29th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5986898 | 2110914 | 37.7754104499772 | -122.488832209773 | (37.7754104499772, -122.488832209773) | 11 | 6 | 2 | 55 | 26 | ||||
53937 | 94690 | Property Tree 8 | Brachychiton populneus :: Bottle Tree 348 | 749 Congo St | Front Yard : Yard | Tree | Private 2 | 10/28/2010 12:00:00 AM | Permit Number 53820 | 6000274 | 2096023 | 37.735294937499 | -122.441492809367 | (37.735294937499, -122.441492809367) | 9 | 7 | 4 | 63 | 40 | ||||
66704 | 107130 | Property Tree 8 | Phoenix dactylifera :: Date Palm 87 | 751 DOLORES ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.425434294507 | (37.7573290011944, -122.425434294507) | 2 | 4 | 5 | 28859 | 19 | |||||
19898 | 98265 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 755 O'Farrell St | Back Yard : Yard | Tree | Private 2 | Backyard tree; not significant | 6007700 | 2113968.3 | 37.7849888609023 | -122.417089467607 | (37.7849888609023, -122.417089467607) | 7 | 10 | 9 | 28858 | 36 | |||||
166769 | 102079 | Property Tree 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 76 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769729 | 6008162.3 | 2099676.4 | 37.7457726186307 | -122.414478397936 | (37.7457726186307, -122.414478397936) | 2 | 7 | 7 | 28859 | 2 | |
124235 | 122518 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 772X Panorama Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5996713 | 2102901 | 37.7539767153501 | -122.45430108189 | (37.7539767153501, -122.45430108189) | 1 | 5 | 4 | 63 | 38 | ||||
185468 | 120977 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 794x Gates St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3030 | 3x3 | 6008103 | 2095407 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | 2 | 7 | 7 | 28859 | 2 | |||
39203 | 97052 | Property Tree 8 | Pyrus spp :: Pear Tree 281 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
51341 | 97051 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 |
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) );