superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Imperial-WA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15347 | 15347 | 15346 | {"type": "MultiPolygon", "coordinates": [[[[-115.54403, 33.0963], [-115.54396, 33.10096], [-115.53918, 33.09943], [-115.53686, 33.09817], [-115.53459, 33.09628], [-115.53452, 33.10291], [-115.52318, 33.10278], [-115.52328, 33.09652], [-115.52427, 33.09535], [-115.52227, 33.09321], [-115.52103, 33.09175], [-115.51989, 33.0921], [-115.51875, 33.09043], [-115.51874, 33.08887], [-115.51431, 33.08886], [-115.51428, 33.08362], [-115.51221, 33.08359], [-115.51223, 33.0816], [-115.51037, 33.08174], [-115.51035, 33.08229], [-115.50872, 33.08223], [-115.5059, 33.07844], [-115.50579, 33.07833], [-115.50573, 33.07821], [-115.50492, 33.07712], [-115.5046, 33.07628], [-115.50436, 33.07548], [-115.50443, 33.07469], [-115.50477, 33.07372], [-115.50541, 33.0722], [-115.50759, 33.07056], [-115.50718, 33.07005], [-115.50613, 33.07005], [-115.50546, 33.06981], [-115.50509, 33.06962], [-115.50474, 33.06928], [-115.50424, 33.06856], [-115.50398, 33.068], [-115.50358, 33.06771], [-115.50344, 33.06738], [-115.50342, 33.06645], [-115.50064, 33.06639], [-115.50061, 33.06447], [-115.49635, 33.06441], [-115.4962, 33.05942], [-115.49611, 33.05901], [-115.49181, 33.05894], [-115.49178, 33.0518], [-115.4875, 33.05174], [-115.48856, 33.04958], [-115.49027, 33.04958], [-115.49049, 33.04822], [-115.48758, 33.04622], [-115.48666, 33.04463], [-115.4927, 33.04464], [-115.49628, 33.04542], [-115.49972, 33.04559], [-115.50082, 33.0461], [-115.50089, 33.04639], [-115.50086, 33.04662], [-115.50093, 33.04693], [-115.50126, 33.04714], [-115.5027, 33.04818], [-115.50282, 33.04825], [-115.5029, 33.04969], [-115.50342, 33.0517], [-115.50248, 33.05177], [-115.50243, 33.05186], [-115.50228, 33.0524], [-115.50232, 33.05283], [-115.50229, 33.05319], [-115.50234, 33.05356], [-115.50235, 33.05387], [-115.50265, 33.0543], [-115.50274, 33.05466], [-115.50302, 33.05543], [-115.50315, 33.05593], [-115.5032, 33.05626], [-115.50336, 33.05657], [-115.50353, 33.05679], [-115.50406, 33.05712], [-115.50426, 33.05732], [-115.50449, 33.05776], [-115.50492, 33.05821], [-115.5054, 33.05869], [-115.5056, 33.05913], [-115.50665, 33.05917], [-115.50668, 33.06267], [-115.50905, 33.0627], [-115.50904, 33.06632], [-115.51075, 33.06633], [-115.51075, 33.06596], [-115.51323, 33.06592], [-115.51323, 33.06633], [-115.51351, 33.06634], [-115.51358, 33.06984], [-115.51418, 33.06988], [-115.51417, 33.07003], [-115.51438, 33.07003], [-115.51465, 33.07112], [-115.51569, 33.07233], [-115.51697, 33.07369], [-115.51696, 33.07401], [-115.51699, 33.07479], [-115.52297, 33.07498], [-115.523, 33.08181], [-115.52698, 33.08186], [-115.5269, 33.08549], [-115.52752, 33.08579], [-115.52816, 33.08644], [-115.5288, 33.08688], [-115.52949, 33.0871], [-115.52994, 33.0874], [-115.53064, 33.08812], [-115.53096, 33.08865], [-115.53145, 33.0892], [-115.53179, 33.08946], [-115.53601, 33.0897], [-115.53602, 33.09638], [-115.54403, 33.0963]], [[-115.50412, 33.06721], [-115.50373, 33.06641], [-115.50371, 33.06641], [-115.50362, 33.06652], [-115.50369, 33.06684], [-115.50404, 33.0674], [-115.50406, 33.06739], [-115.50412, 33.06721]]], [[[-115.61839, 33.31096], [-115.61839, 33.31419], [-115.61436, 33.3146], [-115.61438, 33.32181], [-115.609, 33.32183], [-115.60334, 33.31423], [-115.59698, 33.30727], [-115.59154, 33.29999], [-115.58547, 33.2927], [-115.58127, 33.28729], [-115.57569, 33.28037], [-115.5695, 33.27289], [-115.56605, 33.26854], [-115.56541, 33.26768], [-115.56517, 33.2672], [-115.56452, 33.26682], [-115.56365, 33.2662], [-115.56257, 33.26515], [-115.56256, 33.24864], [-115.55348, 33.24842], [-115.55335, 33.2347], [-115.56268, 33.23471], [-115.56263, 33.22769], [-115.57976, 33.22741], [-115.57968, 33.24921], [-115.58835, 33.24925], [-115.58839, 33.26366], [-115.58843, 33.26367], [-115.58844, 33.2637], [-115.59708, 33.26366], [-115.597, 33.28544], [-115.60105, 33.28546], [-115.60105, 33.28862], [-115.60135, 33.28864], [-115.60135, 33.28909], [-115.60539, 33.28912], [-115.60558, 33.29276], [-115.60997, 33.29279], [-115.60981, 33.30312], [-115.61001, 33.30316], [-115.61001, 33.30366], [-115.6143, 33.30368], [-115.61433, 33.31082], [-115.61436, 33.31083], [-115.61436, 33.31093], [-115.61839, 33.31096]]], [[[-115.59708, 33.1839], [-115.59706, 33.19835], [-115.58852, 33.1984], [-115.58851, 33.19841], [-115.57549, 33.19841], [-115.57549, 33.19115], [-115.58405, 33.19115], [-115.58333, 33.18994], [-115.58507, 33.18952], [-115.58509, 33.18907], [-115.58518, 33.18897], [-115.58551, 33.18874], [-115.58572, 33.18873], [-115.58599, 33.18867], [-115.58608, 33.18856], [-115.58618, 33.18826], [-115.58589, 33.18784], [-115.58527, 33.18735], [-115.58424, 33.18707], [-115.58404, 33.18695], [-115.58393, 33.18667], [-115.58369, 33.18651], [-115.58371, 33.18612], [-115.58418, 33.18608], [-115.5849, 33.18588], [-115.58551, 33.18562], [-115.5859, 33.18548], [-115.5861, 33.18532], [-115.58617, 33.1852], [-115.58625, 33.18504], [-115.58629, 33.18467], [-115.58626, 33.1844], [-115.58623, 33.18432], [-115.58618, 33.18389], [-115.59708, 33.1839]]]]} | Open Access 1 | Imperial Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Imperial-WA | 30457 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 7803.972 | Imperial Wildlife Area | 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]);