trees
14 rows where PlotSize = 5 and qSpecies_id = 105
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23116 | 786 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2301X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984816.6595314 | 2099521.6133491 | 37.7440084477813 | -122.495191653565 | (37.7440084477813, -122.495191653565) | 1 | 8 | 3 | 29491 | 35 | |||
23605 | 789 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2301X 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984816.6595314 | 2099521.6133491 | 37.7440084477813 | -122.495191653565 | (37.7440084477813, -122.495191653565) | 1 | 8 | 3 | 29491 | 35 | |||
89091 | 784 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2201X 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984793.4110368 | 2100199.4734369 | 37.7458683061814 | -122.495322021107 | (37.7458683061814, -122.495322021107) | 1 | 8 | 3 | 29491 | 35 | |||
96208 | 783 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2201X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984793.4110368 | 2100199.4734369 | 37.7458683061814 | -122.495322021107 | (37.7458683061814, -122.495322021107) | 1 | 8 | 3 | 29491 | 35 | |||
98607 | 788 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2301X 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984816.6595314 | 2099521.6133491 | 37.7440084477813 | -122.495191653565 | (37.7440084477813, -122.495191653565) | 1 | 8 | 3 | 29491 | 35 | |||
103834 | 782 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2100X 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984820.234801 | 2100881.0701699 | 37.7477413554748 | -122.495279526069 | (37.7477413554748, -122.495279526069) | 1 | 8 | 3 | 29491 | 35 | |||
105508 | 790 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2401X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984839.6656165 | 2098840.9778552 | 37.7421409539499 | -122.495061926104 | (37.7421409539499, -122.495061926104) | 1 | 8 | 3 | 29491 | 35 | |||
108566 | 787 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2301X 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984816.6595314 | 2099521.6133491 | 37.7440084477813 | -122.495191653565 | (37.7440084477813, -122.495191653565) | 1 | 8 | 3 | 29491 | 35 | |||
122674 | 785 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2201X 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984793.4110368 | 2100199.4734369 | 37.7458683061814 | -122.495322021107 | (37.7458683061814, -122.495322021107) | 1 | 8 | 3 | 29491 | 35 | |||
138073 | 780 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2100X 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5 | 5984820.234801 | 2100881.0701699 | 37.7477413554748 | -122.495279526069 | (37.7477413554748, -122.495279526069) | 1 | 8 | 3 | 29491 | 35 | |||
140338 | 792 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2401X 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5 | 5984839.6656165 | 2098840.9778552 | 37.7421409539499 | -122.495061926104 | (37.7421409539499, -122.495061926104) | 1 | 8 | 3 | 29491 | 35 | |||
167937 | 791 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2401X 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984839.6656165 | 2098840.9778552 | 37.7421409539499 | -122.495061926104 | (37.7421409539499, -122.495061926104) | 1 | 8 | 3 | 29491 | 35 | |||
183696 | 781 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2100X 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 5984820.234801 | 2100881.0701699 | 37.7477413554748 | -122.495279526069 | (37.7477413554748, -122.495279526069) | 1 | 8 | 3 | 29491 | 35 | |||
190637 | 779 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 2100X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5 | 5984820.234801 | 2100881.0701699 | 37.7477413554748 | -122.495279526069 | (37.7477413554748, -122.495279526069) | 1 | 8 | 3 | 29491 | 35 |
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) );