superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 78 and YR_EST = 2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
996 | 996 | 995 | {"type": "Polygon", "coordinates": [[[-118.8224, 34.295], [-118.82168, 34.29571], [-118.82099, 34.29626], [-118.8176, 34.29545], [-118.81217, 34.29678], [-118.80476, 34.30392], [-118.79639, 34.30984], [-118.79638, 34.3044], [-118.80047, 34.30326], [-118.80195, 34.30167], [-118.80796, 34.29721], [-118.8082, 34.29486], [-118.80973, 34.29297], [-118.81042, 34.29303], [-118.8108, 34.29253], [-118.81063, 34.29221], [-118.81146, 34.29191], [-118.81295, 34.29197], [-118.81497, 34.29179], [-118.8156, 34.29223], [-118.81725, 34.2923], [-118.81836, 34.29215], [-118.81865, 34.29188], [-118.819, 34.29231], [-118.8199, 34.292], [-118.82059, 34.29224], [-118.82079, 34.29209], [-118.82145, 34.29225], [-118.82176, 34.29316], [-118.82239, 34.2945], [-118.8224, 34.295]]]} | Open Access 1 | Alamos Canyon Open Space | http://www.rsrpd.org/simi_valley/trails/alamoscanyon.php | 33233 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 281.362 | Alamos Canyon OS | 2016 |
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]);