trees
341 rows where qLegalStatus_id = 8 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12415 | 258693 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
15996 | 258691 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 100x Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
17872 | 258685 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 2 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
157400 | 97685 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 84 Coventry Ct | Back Yard : Yard | Tree | Private 2 | 5997084 | 2096485 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | 9 | 7 | 4 | 59 | 40 | ||||||
171323 | 253471 | Property Tree 8 | Sequoiadendron giganteum :: Sierra Redwood 240 | 17 Valletta Ct | 1 | Side Yard : Yard | Tree | Private 2 | 6x10 | 5999337 | 2096545 | 37.7366747995559 | -122.444769861358 | (37.7366747995559, -122.444769861358) | 9 | 7 | 4 | 63 | 40 | ||||
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 | ||||||
390 | 255918 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 80 Molimo Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998634.42423 | 2096706.77911 | 37.7370788872961 | -122.447210599537 | (37.7370788872961, -122.447210599537) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||||
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 | |||||
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 | ||||
192549 | 98880 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 5994747.9 | 2097283.1 | 37.7384384842789 | -122.460689725403 | (37.7384384842789, -122.460689725403) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
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 | |||||
22321 | 256538 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 19 Miguel St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003470 | 2097467 | 37.7394413932778 | -122.430546066859 | (37.7394413932778, -122.430546066859) | 2 | 7 | 5 | 63 | 7 | ||||
135134 | 113440 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 BEACON ST | Back Yard : Yard | Tree | Private 2 | 32 | 3x3 | 6003193 | 2097540 | 37.7396261385587 | -122.431509020833 | (37.7396261385587, -122.431509020833) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
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 | ||||||
107546 | 112377 | Property Tree 8 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 36 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 40 | ||||
1189 | 261265 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
13075 | 261490 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
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 | ||||
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 | |||
148738 | 252848 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 99 Reposa Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5998022 | 2098104 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | 9 | 7 | 4 | 59 | 40 | ||||
53202 | 102251 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 125X Powhattan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
101616 | 102250 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
108303 | 102249 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
117229 | 102248 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
183601 | 256482 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 168 Moultrie St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 6007766 | 2098288 | 37.7419381097545 | -122.415750458671 | (37.7419381097545, -122.415750458671) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
9214 | 264784 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 67 Rosenkranz St | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
15695 | 262389 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 67 Rosenkranz St | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
13614 | 258670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 152 Kensington Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994743 | 2098651 | 37.7421941161526 | -122.460805774677 | (37.7421941161526, -122.460805774677) | 1 | 8 | 4 | 59 | 40 | |||||
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 | ||||
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 | ||||
28785 | 122558 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1760 Diamond St | 1 | Back Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6001927 | 2098732 | 37.7428272563398 | -122.435971568238 | (37.7428272563398, -122.435971568238) | 2 | 7 | 5 | 63 | 22 | |||
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 |
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 | |||
342 | 115652 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 18 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
24981 | 115647 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 13 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
27745 | 115653 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 19 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
36364 | 115642 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 8 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
61637 | 115638 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 4 | Back Yard : Cutout | Tree | DPW 1 | 7 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
67651 | 115641 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 7 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
69931 | 115646 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 12 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
82655 | 115645 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 11 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
92653 | 115639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 5 | Back Yard : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
94640 | 115635 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 1 | Back Yard : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
102518 | 115648 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 14 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
109260 | 115649 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 15 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
113451 | 115644 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 10 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
137355 | 115636 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 2 | Back Yard : Cutout | Tree | DPW 1 | 16 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
144021 | 115650 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 16 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
163840 | 115640 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 6 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
168631 | 115643 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 9 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
173132 | 115637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 3 | Back Yard : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
175002 | 115655 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 21 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
177053 | 115654 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 20 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
181668 | 115651 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 17 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
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 | |||
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 | |||||
172414 | 256223 | Property Tree 8 | Schinus molle :: California Pepper 91 | 116X Brewster St | 1 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 6x6 | 6010334 | 2099321 | 37.7449185312124 | -122.406943891675 | (37.7449185312124, -122.406943891675) | 2 | 7 | 7 | 28859 | 2 | ||||
106981 | 109092 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 237 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) | 2 | 7 | 5 | 63 | 22 |
44517 | 251117 | Property Tree 8 | Sequoiadendron giganteum :: Sierra Redwood 240 | 2024 Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 6002622 | 2099601 | 37.7452527853239 | -122.433630548541 | (37.7452527853239, -122.433630548541) | 2 | 7 | 5 | 63 | 22 | |||||
5758 | 262529 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 555 Portola Dr | 8 | Front Yard : Yard | Tree | SFUSD 4 | 10x10 | 5997546 | 2099815 | 37.7455510557903 | -122.451197845188 | (37.7455510557903, -122.451197845188) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
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 | |
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 | ||||||
6585 | 260539 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997905 | 2100119 | 37.7464063138276 | -122.449978390477 | (37.7464063138276, -122.449978390477) | 2 | 5 | 4 | 63 | 38 | ||||
89692 | 122453 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 217 San Marcos Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | 1 | 8 | 4 | 29491 | 40 | ||||
192149 | 98878 | Property Tree 8 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard | Landscaping | Private 2 | 5998029 | 2100213 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | 2 | 5 | 4 | 63 | 38 | ||||||
15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
45129 | 98465 | Property Tree 8 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard | Landscaping | Private 2 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | 2 | 5 | 5 | 63 | 38 | ||||||
99841 | 98436 | Property Tree 8 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5999035 | 2100736 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | 2 | 5 | 5 | 63 | 38 | ||||||
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 | ||||||
137488 | 98501 | Property Tree 8 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998998 | 2100740 | 37.7481739100487 | -122.446243600021 | (37.7481739100487, -122.446243600021) | 2 | 5 | 5 | 63 | 38 | ||||||
22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||||
105747 | 98892 | Property Tree 8 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998935 | 2100753 | 37.7482060067302 | -122.44646238624 | (37.7482060067302, -122.44646238624) | 2 | 5 | 5 | 63 | 38 | ||||||
90504 | 98893 | Property Tree 8 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2100761 | 37.7482265448319 | -122.446549410607 | (37.7482265448319, -122.446549410607) | 2 | 5 | 5 | 63 | 38 | ||||||
20402 | 257888 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Magellan Ave | 1 | Front Yard : Yard | Tree | MTA 3 | 10x10 | 5995070 | 2100842 | 37.7482288640106 | -122.459833790503 | (37.7482288640106, -122.459833790503) | 1 | 8 | 4 | 29491 | 40 | ||||
30200 | 98503 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 208 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5998871 | 2100779 | 37.7482737407191 | -122.446685565827 | (37.7482737407191, -122.446685565827) | 2 | 5 | 5 | 63 | 38 | ||||||
96282 | 117254 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2067 33RD AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5985987 | 2101171 | 37.7486056682842 | -122.491266304796 | (37.7486056682842, -122.491266304796) | 1 | 8 | 3 | 29491 | 35 | ||||
105934 | 99256 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1466 York St | Back Yard : Yard | Tree | Private 2 | 6010099 | 2100741 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | 2 | 4 | 7 | 28859 | 19 | ||||||
94159 | 97024 | Property Tree 8 | Jacaranda mimosifolia :: Jacaranda 50 | 1455 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349 | 2100759.5 | 37.7488131674601 | -122.410451409671 | (37.7488131674601, -122.410451409671) | 2 | 4 | 7 | 28859 | 19 | ||||
103546 | 113379 | Property Tree 8 | Fagus sylvatica :: European Beech 272 | 140 CASTENADA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 50 | 5994437 | 2101097 | 37.7488926059174 | -122.462041158848 | (37.7488926059174, -122.462041158848) | 1 | 8 | 4 | 29491 | 40 | ||||
122314 | 97023 | Property Tree 8 | Jacaranda mimosifolia :: Jacaranda 50 | 1443 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.7488938036461 | -122.410459018192 | (37.7488938036461, -122.410459018192) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | ||||
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 | ||||
3020 | 260513 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1990 41st Ave | 1 | Back Yard : Yard | Tree | Health Dept 13 | 10x10 | 5983703 | 2101544 | 37.7494961014415 | -122.499191781388 | (37.7494961014415, -122.499191781388) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||||
10460 | 258772 | Property Tree 8 | Cupressus spp :: Cypress species 337 | 20 Crestline Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 5999139 | 2101332 | 37.7498074496931 | -122.445798597569 | (37.7498074496931, -122.445798597569) | 2 | 5 | 5 | 63 | 38 | |||
112077 | 253339 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard | Tree | PUC 8 | 3x3 | 5988853 | 2101569 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | 1 | 8 | 3 | 29491 | 35 | ||||
2998 | 261600 | Property Tree 8 | Acer macrophyllum :: Big Leaf Maple 180 | 451X Jersey St | 1 | Back Yard : Yard | Tree | Public Library 12 | 3x3 | 6002237 | 2101405 | 37.7501842910814 | -122.435090813874 | (37.7501842910814, -122.435090813874) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||||||
628 | 256542 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 133 Olympia Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996852 | 2101844 | 37.7510824274474 | -122.453744067192 | (37.7510824274474, -122.453744067192) | 1 | 5 | 4 | 63 | 38 | ||||
51917 | 256537 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 139 Olympia Way | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5996818 | 2101849 | 37.7510942069084 | -122.453862003079 | (37.7510942069084, -122.453862003079) | 1 | 5 | 4 | 63 | 38 | ||||
89545 | 256543 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 139 Olympia Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996818 | 2101849 | 37.7510942069084 | -122.453862003079 | (37.7510942069084, -122.453862003079) | 1 | 5 | 4 | 63 | 38 |
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) );