superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LAYER = 9, MNG_AG_TYP = 5 and PARK_NAME = "Unnamed site - California Department of Parks and Recreation"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14344 | 14344 | 14343 | {"type": "MultiPolygon", "coordinates": [[[[-118.74074, 34.07084], [-118.73649, 34.07068], [-118.73648, 34.06711], [-118.74072, 34.06713], [-118.74074, 34.07084]]], [[[-123.78094, 40.04105], [-123.77631, 40.04038], [-123.77621, 40.03407], [-123.77658, 40.03481], [-123.77778, 40.03667], [-123.77813, 40.03737], [-123.77819, 40.03767], [-123.7784, 40.03788], [-123.77868, 40.0386], [-123.77936, 40.03934], [-123.78039, 40.0401], [-123.78085, 40.0399], [-123.78089, 40.03991], [-123.78086, 40.03994], [-123.78094, 40.04105]]], [[[-124.15793, 40.54867], [-124.15215, 40.54859], [-124.15399, 40.54211], [-124.15466, 40.54314], [-124.15526, 40.54451], [-124.15583, 40.54559], [-124.15629, 40.54623], [-124.157, 40.54706], [-124.15756, 40.54776], [-124.15793, 40.54867]]], [[[-124.15905, 40.56405], [-124.15698, 40.56404], [-124.15638, 40.56307], [-124.15904, 40.5631], [-124.15905, 40.56405]]], [[[-124.17889, 40.59558], [-124.17889, 40.59558], [-124.17622, 40.59879], [-124.17608, 40.59791], [-124.17667, 40.59502], [-124.17645, 40.59463], [-124.17889, 40.59558]]]]} | Open Access 1 | Unnamed site - California Department of Parks and Recreation | 30566 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 130.312 |
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]);