superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Beverly Glen Park" and MNG_AG_TYP = 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12476 | 12476 | 12475 | {"type": "MultiPolygon", "coordinates": [[[[-118.44618, 34.11604], [-118.44484, 34.11604], [-118.44484, 34.11511], [-118.44451, 34.1151], [-118.4445, 34.11353], [-118.44397, 34.11337], [-118.44376, 34.11384], [-118.44371, 34.11406], [-118.44371, 34.11421], [-118.44373, 34.11433], [-118.44387, 34.11474], [-118.44384, 34.1148], [-118.44378, 34.11479], [-118.44347, 34.11499], [-118.44346, 34.11536], [-118.44338, 34.11548], [-118.44279, 34.11594], [-118.44274, 34.11612], [-118.44265, 34.11627], [-118.44222, 34.11633], [-118.44216, 34.11641], [-118.4422, 34.11662], [-118.44246, 34.11684], [-118.44251, 34.11711], [-118.4426, 34.11728], [-118.44245, 34.11747], [-118.44228, 34.11752], [-118.44194, 34.11748], [-118.4418, 34.11756], [-118.44158, 34.11756], [-118.44113, 34.11732], [-118.44103, 34.11704], [-118.44049, 34.11692], [-118.44021, 34.11673], [-118.4402, 34.11602], [-118.4379, 34.11601], [-118.4379, 34.1145], [-118.43905, 34.11444], [-118.44021, 34.11459], [-118.44022, 34.10877], [-118.44407, 34.10878], [-118.44428, 34.10927], [-118.44309, 34.1102], [-118.44397, 34.11237], [-118.44555, 34.11239], [-118.44635, 34.11437], [-118.44631, 34.11477], [-118.44631, 34.11523], [-118.44628, 34.1155], [-118.44618, 34.11604]]], [[[-118.44706, 34.11605], [-118.44644, 34.11605], [-118.44654, 34.11542], [-118.44655, 34.11514], [-118.44658, 34.1151], [-118.44665, 34.1151], [-118.44668, 34.11513], [-118.44706, 34.11605]]]]} | Open Access 1 | Beverly Glen Park | 29532 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 95.56 | Beverly Glen 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]);