trees
50 rows where Police Districts = 8 and 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 105992 | 258053 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1651 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | Width 5ft | 5991822.8552 | 2096210.84451 | 37.7353256172728 | -122.470724935722 | (37.7353256172728, -122.470724935722) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 6335 | 262305 | Property Tree 8 | Casuarina cunninghamiana :: Horsetail pine 112 | 100 Saint Elmo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994960 | 2094889 | 37.7318770738882 | -122.459783023889 | (37.7318770738882, -122.459783023889) | 9 | 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 | ||||
| 194461 | 265095 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 1100 Junipero Serra Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 10x10 | 5991104 | 2090006 | 37.7182470667789 | -122.472757983106 | (37.7182470667789, -122.472757983106) | 9 | 8 | 4 | 64 | 40 | ||||
| 99909 | 96676 | Property Tree 8 | Prunus spp :: Cherry 68 | 1701 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | 1 | 8 | 3 | 56 | 35 | ||||
| 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 | ||||||
| 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 |
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) );