superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Freedom Park" and MNG_AGENCY = 211
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4397 | 4397 | 4396 | {"type": "Polygon", "coordinates": [[[-116.31697, 33.7584], [-116.31696, 33.75867], [-116.3169, 33.75897], [-116.31677, 33.75925], [-116.31661, 33.75948], [-116.31646, 33.75965], [-116.31625, 33.75982], [-116.31618, 33.75976], [-116.31594, 33.7599], [-116.31584, 33.7599], [-116.31576, 33.75993], [-116.31572, 33.75997], [-116.31569, 33.76004], [-116.31543, 33.76019], [-116.31526, 33.76033], [-116.31514, 33.76047], [-116.31504, 33.76066], [-116.31499, 33.76081], [-116.31496, 33.76097], [-116.31495, 33.76169], [-116.31492, 33.76185], [-116.31493, 33.7619], [-116.31496, 33.76196], [-116.31496, 33.76313], [-116.31247, 33.76238], [-116.31251, 33.75837], [-116.31697, 33.7584]], [[-116.3159, 33.75965], [-116.31606, 33.75981], [-116.31629, 33.75964], [-116.3165, 33.75943], [-116.31664, 33.75924], [-116.31675, 33.75903], [-116.31683, 33.75876], [-116.31684, 33.75852], [-116.31675, 33.75846], [-116.31625, 33.75846], [-116.31595, 33.75843], [-116.31336, 33.75842], [-116.31336, 33.75986], [-116.31457, 33.75987], [-116.31459, 33.75993], [-116.3149, 33.75994], [-116.31496, 33.75999], [-116.31497, 33.76008], [-116.315, 33.76013], [-116.31505, 33.76015], [-116.31518, 33.76015], [-116.31554, 33.75988], [-116.3159, 33.75965]]]} | Open Access 1 | Freedom Park | 19087 | 1240 | Palm Desert, City of 211 | City 2 | City Agency 2 | http://www.cityofpalmdesert.org/Index.aspx?page=174 | City 2 | 22.97 | Freedom Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);