superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Salton Sea SRA" and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1227 | 1227 | 1226 | {"type": "MultiPolygon", "coordinates": [[[[-115.77784, 33.37562], [-115.77783, 33.38352], [-115.76941, 33.38359], [-115.76938, 33.38358], [-115.7695, 33.37556], [-115.77784, 33.37562]]], [[[-115.79478, 33.39803], [-115.7868, 33.39803], [-115.78673, 33.39007], [-115.79427, 33.39009], [-115.79478, 33.39803]]], [[[-115.83439, 33.41435], [-115.82239, 33.41444], [-115.82236, 33.4124], [-115.81797, 33.41239], [-115.81311, 33.40829], [-115.82216, 33.40829], [-115.82238, 33.41239], [-115.83432, 33.4122], [-115.83439, 33.41435]]], [[[-115.8344, 33.43118], [-115.8344, 33.43118], [-115.83165, 33.427], [-115.83435, 33.427], [-115.8344, 33.43118]]], [[[-115.85227, 33.45336], [-115.85225, 33.45601], [-115.84339, 33.45573], [-115.83501, 33.4554], [-115.83471, 33.44138], [-115.83467, 33.44135], [-115.83467, 33.44132], [-115.8347, 33.4413], [-115.8347, 33.44126], [-115.83518, 33.44132], [-115.8375, 33.44131], [-115.84217, 33.44138], [-115.84249, 33.44141], [-115.84378, 33.44134], [-115.84467, 33.44136], [-115.85209, 33.44124], [-115.85217, 33.44525], [-115.85227, 33.45336]]], [[[-115.93924, 33.47013], [-115.93918, 33.4846], [-115.92186, 33.48465], [-115.92182, 33.49936], [-115.92198, 33.49937], [-115.92182, 33.51089], [-115.91969, 33.51088], [-115.91784, 33.50922], [-115.91728, 33.50874], [-115.91664, 33.50809], [-115.91607, 33.5074], [-115.91549, 33.50657], [-115.91397, 33.50449], [-115.91353, 33.50392], [-115.91307, 33.50337], [-115.91249, 33.50273], [-115.90905, 33.4993], [-115.90447, 33.49927], [-115.90464, 33.49502], [-115.90369, 33.494], [-115.90293, 33.49311], [-115.89935, 33.48832], [-115.89607, 33.4883], [-115.89576, 33.48472], [-115.89438, 33.48472], [-115.88727, 33.47618], [-115.88733, 33.47413], [-115.89145, 33.47413], [-115.8915, 33.47779], [-115.89543, 33.47805], [-115.89577, 33.48471], [-115.89999, 33.48472], [-115.90028, 33.48473], [-115.9048, 33.48468], [-115.90455, 33.48115], [-115.90454, 33.48114], [-115.90459, 33.47015], [-115.88726, 33.47025], [-115.88714, 33.47491], [-115.88438, 33.47362], [-115.88275, 33.47133], [-115.88276, 33.47016], [-115.88724, 33.4701], [-115.8871, 33.46767], [-115.88727, 33.45568], [-115.87013, 33.45559], [-115.86993, 33.4594], [-115.8697, 33.46293], [-115.86941, 33.46293], [-115.86923, 33.46996], [-115.87816, 33.47019], [-115.87797, 33.47749], [-115.88725, 33.47773], [-115.8873, 33.48096], [-115.88722, 33.48098], [-115.88726, 33.4847], [-115.88416, 33.48469], [-115.87797, 33.48463], [-115.87796, 33.47751], [-115.86931, 33.47729], [-115.86922, 33.46998], [-115.86898, 33.47003], [-115.85186, 33.47042], [-115.85242, 33.45964], [-115.86084, 33.45965], [-115.8608, 33.46327], [-115.8694, 33.46292], [-115.8694, 33.4628], [-115.86545, 33.46062], [-115.8655, 33.45934], [-115.86343, 33.45939], [-115.86122, 33.45801], [-115.86131, 33.45576], [-115.8638, 33.45578], [-115.87011, 33.45558], [-115.87012, 33.44116], [-115.87582, 33.44116], [-115.88726, 33.44099], [-115.88727, 33.45568], [-115.92196, 33.45559], [-115.92192, 33.47016], [-115.93924, 33.47013]]], [[[-115.86954, 33.4268], [-115.86954, 33.42685], [-115.86943, 33.42687], [-115.8695, 33.44092], [-115.86815, 33.44098], [-115.85237, 33.44124], [-115.85237, 33.43948], [-115.85247, 33.42767], [-115.8523, 33.42677], [-115.85568, 33.42683], [-115.85569, 33.42686], [-115.86954, 33.4268]]], [[[-115.88269, 33.47021], [-115.88142, 33.47022], [-115.87835, 33.46824], [-115.87832, 33.4667], [-115.88262, 33.46664], [-115.88269, 33.47021]]]]} | Open Access 1 | Salton Sea State Recreation Area | http://www.parks.ca.gov/default.asp?page_id=639 | 13840 | 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 | 6929.698 | Salton Sea SRA | 1951 |
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]);