superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 601 and PARK_NAME = "Seasons Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9468 | 9468 | 9467 | {"type": "Polygon", "coordinates": [[[-116.30097, 33.68143], [-116.30036, 33.68198], [-116.3002, 33.6821], [-116.29947, 33.68258], [-116.29933, 33.68264], [-116.29917, 33.68266], [-116.29895, 33.68263], [-116.29771, 33.68223], [-116.29677, 33.68185], [-116.29669, 33.6818], [-116.29655, 33.68165], [-116.2965, 33.68162], [-116.29643, 33.68163], [-116.29642, 33.68159], [-116.29694, 33.68146], [-116.29745, 33.68136], [-116.29748, 33.68138], [-116.29743, 33.68146], [-116.29742, 33.68151], [-116.29744, 33.68156], [-116.29758, 33.68172], [-116.29777, 33.682], [-116.29785, 33.68207], [-116.29793, 33.68211], [-116.29812, 33.68214], [-116.29901, 33.68208], [-116.29932, 33.68201], [-116.29959, 33.68193], [-116.29973, 33.68185], [-116.29985, 33.68173], [-116.29993, 33.68158], [-116.29996, 33.68143], [-116.30097, 33.68143]]]} | Open Access 1 | Seasons Park | 25270 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 5.136 | Seasons 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]);