trees
121 rows where qSpecies_id = 82 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102324 | 44446 | DPW Maintained 1 | Malus :: Crab Apple 82 | 59 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776702 | 6002663.70845 | 2086958.55404 | 37.7105418493914 | -122.432583452082 | (37.7105418493914, -122.432583452082) | 9 | 7 | 6 | 28861 | 5 | |
104025 | 177473 | DPW Maintained 1 | Malus :: Crab Apple 82 | 661 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6001084.39959 | 2089950.75515 | 37.7186680775449 | -122.438256094064 | (37.7186680775449, -122.438256094064) | 9 | 7 | 6 | 28861 | 5 | ||||
107357 | 208890 | DPW Maintained 1 | Malus :: Crab Apple 82 | 843 Detroit St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999418.03526 | 2095622.98585 | 37.734147790474 | -122.444423445903 | (37.734147790474, -122.444423445903) | 9 | 7 | 4 | 59 | 40 | |||
115277 | 177471 | DPW Maintained 1 | Malus :: Crab Apple 82 | 184 Mount Vernon Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 5998983.26506 | 2089357.76175 | 37.7169201246297 | -122.445476221974 | (37.7169201246297, -122.445476221974) | 9 | 7 | 6 | 28861 | 25 | ||||
119762 | 208892 | DPW Maintained 1 | Malus :: Crab Apple 82 | 501 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5998746.62253 | 2094953.78578 | 37.7322719935398 | -122.446696588498 | (37.7322719935398, -122.446696588498) | 9 | 7 | 4 | 59 | 40 | |||
124887 | 177482 | DPW Maintained 1 | Malus :: Crab Apple 82 | 498 Capistrano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000792.34501 | 2092048.92501 | 37.7244125609655 | -122.439415925402 | (37.7244125609655, -122.439415925402) | 9 | 7 | 6 | 28861 | 25 | |||
127109 | 208887 | DPW Maintained 1 | Malus :: Crab Apple 82 | 747 Detroit St | 9 | Side Yard : Yard | Tree | Private 2 | 5 | 5999422.56432 | 2095411.39604 | 37.7335670730599 | -122.444392586573 | (37.7335670730599, -122.444392586573) | 9 | 7 | 4 | 59 | 40 | ||||
131051 | 208881 | DPW Maintained 1 | Malus :: Crab Apple 82 | 298 Staples Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998181.94254 | 2093824.01975 | 37.7291376502845 | -122.448567470638 | (37.7291376502845, -122.448567470638) | 9 | 7 | 4 | 28861 | 40 | ||||
134041 | 177470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 184 Mount Vernon Ave | 2 | Side Yard : Yard | Tree | Private 2 | 9 | 5998987.4843 | 2089354.3008 | 37.7169108625194 | -122.445461389446 | (37.7169108625194, -122.445461389446) | 9 | 7 | 6 | 28861 | 25 | ||||
135468 | 208894 | DPW Maintained 1 | Malus :: Crab Apple 82 | 279 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998236.07882 | 2093773.59941 | 37.7290023032069 | -122.448376688427 | (37.7290023032069, -122.448376688427) | 9 | 7 | 4 | 28861 | 40 | ||||
146342 | 177469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Rome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998624.12491 | 2088874.96347 | 37.7155739618475 | -122.44668287204 | (37.7155739618475, -122.44668287204) | 9 | 7 | 6 | 28861 | 25 | |||
154600 | 177475 | DPW Maintained 1 | Malus :: Crab Apple 82 | 631 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009520.83405 | 2088792.43347 | 37.7159637900627 | -122.409012944318 | (37.7159637900627, -122.409012944318) | 9 | 7 | 8 | 309 | 39 | |||
158247 | 177477 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009582.84307 | 2087291.35745 | 37.7118456163483 | -122.408692776665 | (37.7118456163483, -122.408692776665) | 9 | 7 | 8 | 309 | 39 | |||
166119 | 177481 | DPW Maintained 1 | Malus :: Crab Apple 82 | 498 Capistrano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000793.16636 | 2092058.90584 | 37.7244400127919 | -122.439413801227 | (37.7244400127919, -122.439413801227) | 9 | 7 | 6 | 28861 | 25 | |||
166690 | 208878 | DPW Maintained 1 | Malus :: Crab Apple 82 | 430 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995998.78542 | 2096380.30117 | 37.7360315086418 | -122.456299537593 | (37.7360315086418, -122.456299537593) | 9 | 7 | 4 | 59 | 40 | |||
173353 | 177472 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1 Balhi Ct | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 1ft | 6000768.04066 | 2090886.53495 | 37.7212195189404 | -122.439416658362 | (37.7212195189404, -122.439416658362) | 9 | 7 | 6 | 28861 | 25 | |||
180403 | 208883 | DPW Maintained 1 | Malus :: Crab Apple 82 | 350 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994771.01328 | 2090927.26714 | 37.7209882430054 | -122.460149470526 | (37.7209882430054, -122.460149470526) | 9 | 8 | 6 | 28861 | 24 | |||
187344 | 177476 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009578.57754 | 2087278.80094 | 37.7118108998241 | -122.408706634324 | (37.7118108998241, -122.408706634324) | 9 | 7 | 8 | 309 | 39 | |||
187628 | 177483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 37 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6005099.05752 | 2093268.21852 | 37.7280046286024 | -122.424614893969 | (37.7280046286024, -122.424614893969) | 9 | 7 | 6 | 28861 | 5 | ||||
188281 | 208877 | DPW Maintained 1 | Malus :: Crab Apple 82 | 136 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995442.32442 | 2097008.84044 | 37.7377253637243 | -122.458268913495 | (37.7377253637243, -122.458268913495) | 9 | 7 | 4 | 59 | 40 | |||
190829 | 208889 | DPW Maintained 1 | Malus :: Crab Apple 82 | 714 Detroit St | 10 | Side Yard : Yard | Tree | Private 2 | 6 | 5999450.60571 | 2095416.85302 | 37.7335836565405 | -122.444296031762 | (37.7335836565405, -122.444296031762) | 9 | 7 | 4 | 63 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );