superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 6 and PARK_URL = "http://www.malibucity.org/Facilities/Facility/Details/Charmlee-Wilderness-Park-8"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12200 | 12200 | 12199 | {"type": "Polygon", "coordinates": [[[-118.89578, 34.04583], [-118.89545, 34.0465], [-118.89534, 34.04777], [-118.89496, 34.04803], [-118.89531, 34.04821], [-118.89497, 34.04882], [-118.895, 34.04908], [-118.89444, 34.04961], [-118.894, 34.04997], [-118.89375, 34.0506], [-118.89329, 34.05057], [-118.89309, 34.05109], [-118.89312, 34.05144], [-118.89217, 34.05168], [-118.89171, 34.052], [-118.89167, 34.05245], [-118.89133, 34.05309], [-118.89159, 34.05384], [-118.89131, 34.05475], [-118.89087, 34.05501], [-118.89087, 34.0588], [-118.8852, 34.057], [-118.88519, 34.06002], [-118.88513, 34.06086], [-118.88502, 34.06371], [-118.88079, 34.06367], [-118.88078, 34.06183], [-118.87713, 34.06178], [-118.87711, 34.06155], [-118.87705, 34.06135], [-118.87693, 34.06114], [-118.87676, 34.06093], [-118.87657, 34.06077], [-118.87635, 34.06064], [-118.87611, 34.06054], [-118.87586, 34.06048], [-118.87576, 34.05396], [-118.87638, 34.05415], [-118.8764, 34.05414], [-118.8764, 34.04833], [-118.88472, 34.04835], [-118.88474, 34.04851], [-118.8897, 34.04852], [-118.89018, 34.04758], [-118.89017, 34.04757], [-118.89007, 34.04759], [-118.88998, 34.04755], [-118.88994, 34.04748], [-118.88998, 34.04738], [-118.89064, 34.04738], [-118.89172, 34.04673], [-118.89184, 34.04684], [-118.89342, 34.04589], [-118.89257, 34.04487], [-118.89169, 34.04565], [-118.89155, 34.04555], [-118.89134, 34.04558], [-118.8913, 34.04542], [-118.89104, 34.04593], [-118.8908, 34.0459], [-118.89068, 34.0459], [-118.89055, 34.04593], [-118.89051, 34.04586], [-118.89061, 34.04457], [-118.89139, 34.0446], [-118.89167, 34.04457], [-118.8919, 34.0445], [-118.89214, 34.04439], [-118.89214, 34.04436], [-118.89236, 34.0442], [-118.89252, 34.04402], [-118.89263, 34.04383], [-118.89312, 34.04483], [-118.89521, 34.04485], [-118.89558, 34.04522], [-118.89561, 34.04562], [-118.89578, 34.04583]]]} | Open Access 1 | Charmlee Wilderness Park | http://www.malibucity.org/Facilities/Facility/Details/Charmlee-Wilderness-Park-8 | 29180 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 534.016 | Charmlee Wilderness 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]);