trees
11 rows where Zip Codes = 28862 and qSpecies_id = 12 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193268 | 52304 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 180DANVERS Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48464 | 6000126.86103947 | 2104901.42011078 | 37.7596645617882 | -122.442638797859 | (37.7596645617882, -122.442638797859) | 2 | 4 | 5 | 28862 | 3 | ||
182160 | 241176 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 16 Temple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999954.14374 | 2105886.54526 | 37.7623596247176 | -122.443306897094 | (37.7623596247176, -122.443306897094) | 15 | 5 | 5 | 28862 | 3 | |||
173662 | 95690 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 128 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767441 | 6000854 | 2105632 | 37.7617119784366 | -122.440176382755 | (37.7617119784366, -122.440176382755) | 15 | 5 | 5 | 28862 | 3 | |
151075 | 241171 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 29 Levant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000270.28212 | 2106683.67196 | 37.764566359572 | -122.442270721627 | (37.764566359572, -122.442270721627) | 15 | 5 | 5 | 28862 | 3 | |||
135379 | 241177 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 22 Temple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999945.77757 | 2105873.29085 | 37.7623227543165 | -122.443334880405 | (37.7623227543165, -122.443334880405) | 15 | 5 | 5 | 28862 | 3 | |||
112670 | 52291 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48450 | 6004924.5040582 | 2101031.6740118 | 37.7493114629054 | -122.425770685059 | (37.7493114629054, -122.425770685059) | 2 | 4 | 5 | 28862 | 22 | ||
87447 | 241172 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 29 Levant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000269.35575 | 2106710.14367 | 37.7646389915166 | -122.442275826165 | (37.7646389915166, -122.442275826165) | 15 | 5 | 5 | 28862 | 3 | |||
45536 | 50054 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 646 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51273 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | ||
39316 | 102940 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 115 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769103 | 6000989 | 2105709 | 37.7619310864697 | -122.439714993758 | (37.7619310864697, -122.439714993758) | 15 | 5 | 5 | 28862 | 3 | |||
37623 | 241174 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 315 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 778328 | 6003586.53553 | 2106468.03188 | 37.7641627114691 | -122.430785309798 | (37.7641627114691, -122.430785309798) | 8 | 4 | 5 | 28862 | 3 | ||
24409 | 246997 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004899.11495 | 2101036.5235 | 37.7493233437145 | -122.425858826318 | (37.7493233437145, -122.425858826318) | 2 | 4 | 5 | 28862 | 22 |
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) );