trees
341 rows where qLegalStatus_id = 8 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
173335 | 117644 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1111X SANSOME ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x30 | 6011937 | 2119613 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | 3 | 1 | 10 | 308 | 23 | ||||
124153 | 118318 | Property Tree 8 | Maytenus boaria :: Mayten 58 | 20 Norton St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002015.68632 | 2092167.12899 | 37.7248066672809 | -122.435195459751 | (37.7248066672809, -122.435195459751) | 9 | 7 | 6 | 28861 | 25 | |||||
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 | ||||
159644 | 120526 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1439 47th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 20 | 3x3 | 5981489 | 2105275 | 37.7596102388302 | -122.50712446854 | (37.7596102388302, -122.50712446854) | 1 | 8 | 3 | 56 | 35 | |||
189109 | 120533 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010745 | 2108673 | 37.7706200263658 | -122.406181480785 | (37.7706200263658, -122.406181480785) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
101831 | 120995 | Property Tree 8 | Private shrub :: Private Shrub 284 | 231 Delano Ave | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6000066 | 2092260 | 37.7249507611268 | -122.44194193564 | (37.7249507611268, -122.44194193564) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||||
55834 | 121404 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1900 08th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 10x10 | 5993817 | 2102486 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
60302 | 187670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 230 Victoria St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5993274 | 2088748 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | 9 | 8 | 6 | 64 | 24 | ||||
5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
154580 | 224422 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 2 | Front Yard : Cutout | Tree | MTA 3 | 16 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
141413 | 224714 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 3 | Front Yard : Cutout | Tree | MTA 3 | 11 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
68467 | 224715 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 4 | Front Yard : Cutout | Tree | MTA 3 | 12 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
42570 | 224716 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 5 | Front Yard : Cutout | Tree | MTA 3 | 13 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
111666 | 225888 | Property Tree 8 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 474 | 3255x 24th St | 1 | Front Yard : Cutout | Tree | MTA 3 | 32 | 6x6 | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
50874 | 225889 | Property Tree 8 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 474 | 3255x 24th St | 7 | Back Yard : Cutout | Tree | MTA 3 | 18 | Width 8ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | ||||
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 | |||||
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 | ||||
183366 | 251343 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 934 Brannan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
122810 | 251512 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4116x 18th St | 1 | Back Yard : Yard | Tree | MTA 3 | 3x3 | 6002190 | 2105341 | 37.7609889340227 | -122.43553488468 | (37.7609889340227, -122.43553488468) | 15 | 4 | 5 | 28862 | 3 | ||||
11932 | 252833 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
136363 | 252834 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
183841 | 252835 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
13841 | 252837 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
103773 | 252839 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 99 Pond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 | ||||
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 | ||||
161514 | 253207 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 89 Woodhaven Ct | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5996069 | 2103645 | 37.7559825991437 | -122.456581972884 | (37.7559825991437, -122.456581972884) | 1 | 5 | 4 | 63 | 12 | ||||
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 | ||||
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 | |||||
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 | ||||
46471 | 253626 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1671 Funston Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5992125 | 2104081 | 37.7569525124502 | -122.470253253306 | (37.7569525124502, -122.470253253306) | 1 | 8 | 4 | 56 | 12 | ||||
113507 | 253768 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Raccoon Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5998692 | 2104165 | 37.7575606372552 | -122.447548237739 | (37.7575606372552, -122.447548237739) | 15 | 5 | 5 | 28862 | 3 | |||||
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 | ||||
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 | ||||
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 | ||||
53415 | 254271 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1201X Junipero Serra Blvd | 1 | Side Yard : Yard | Tree | PUC 8 | 10x10 | 5991180 | 2089593 | 37.717117469349 | -122.472465193375 | (37.717117469349, -122.472465193375) | 9 | 8 | 6 | 64 | 24 | ||||
35596 | 254587 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1270 24th Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5988678 | 2106679 | 37.7638860263594 | -122.482364481098 | (37.7638860263594, -122.482364481098) | 1 | 8 | 3 | 56 | 35 | ||||
134313 | 255008 | Property Tree 8 | Pittosporum undulatum :: Victorian Box 36 | 1 Villa Ter | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | ||||
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 | ||||
153614 | 255116 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 301X Chester Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
130825 | 255872 | Property Tree 8 | Tree(s) :: 17 | 100 Stonecrest Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5990801 | 2093784 | 37.7286029699614 | -122.474080817952 | (37.7286029699614, -122.474080817952) | 9 | 8 | 4 | 64 | 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 | ||||
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 | ||||
71797 | 256101 | Property Tree 8 | Populus spp :: Poplar Spp 262 | 1255 Oak St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 6001013 | 2109627 | 37.7726903083913 | -122.439912920243 | (37.7726903083913, -122.439912920243) | 15 | 5 | 11 | 29492 | 9 | ||||
106673 | 256140 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 892 Moultrie St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007512 | 2095150 | 37.7333075704823 | -122.416406492547 | (37.7333075704823, -122.416406492547) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
189291 | 256552 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 1 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:54:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
176971 | 256553 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 2 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:24:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
34431 | 256554 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 3 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:10:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
90011 | 256555 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 4 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:48:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
175776 | 256557 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 6 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:44:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
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 | ||||
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 | |||||
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 | ||||
39981 | 256672 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 Kenwood Way | 11 | Back Yard : Yard | Tree | Private 2 | 30x30 | 5994751 | 2093714 | 37.7286387886762 | -122.4604204683 | (37.7286387886762, -122.4604204683) | 9 | 8 | 4 | 59 | 40 | ||||
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 | ||||
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 |
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) );