superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 168 and PARK_NAME = "Miller 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7003 | 7003 | 7002 | {"type": "Polygon", "coordinates": [[[-118.86313, 34.27395], [-118.86268, 34.27401], [-118.86263, 34.27389], [-118.86243, 34.27377], [-118.86231, 34.27367], [-118.86222, 34.27365], [-118.86173, 34.27375], [-118.86156, 34.27385], [-118.86157, 34.2739], [-118.86154, 34.27398], [-118.86121, 34.27422], [-118.86114, 34.27423], [-118.86108, 34.27409], [-118.86095, 34.27399], [-118.86078, 34.27394], [-118.86064, 34.27388], [-118.86054, 34.27388], [-118.86042, 34.27393], [-118.86037, 34.27389], [-118.8603, 34.2734], [-118.86042, 34.27334], [-118.86049, 34.27327], [-118.86052, 34.27313], [-118.86076, 34.27301], [-118.86124, 34.27284], [-118.86133, 34.27278], [-118.86149, 34.27265], [-118.86165, 34.27243], [-118.86173, 34.27237], [-118.86189, 34.27233], [-118.86219, 34.27234], [-118.8629, 34.27227], [-118.86283, 34.27276], [-118.86285, 34.27315], [-118.86289, 34.27336], [-118.86295, 34.27356], [-118.86303, 34.27377], [-118.86313, 34.27395]]]} | Open Access 1 | Miller Park | 22244 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 8.21 | Miller 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]);