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/Doyle-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15338 | 15338 | 15337 | {"type": "MultiPolygon", "coordinates": [[[[-120.01427, 40.10283], [-120.0142, 40.11387], [-120.01402, 40.12459], [-120.01393, 40.12653], [-120.01401, 40.12836], [-120.01395, 40.13198], [-120.00955, 40.1319], [-120.00955, 40.13553], [-120.00092, 40.13541], [-120.0009, 40.14265], [-119.99698, 40.1426], [-119.99711, 40.12491], [-119.99722, 40.12486], [-119.99726, 40.11735], [-120.00084, 40.11734], [-120.00084, 40.121], [-120.00089, 40.12462], [-120.00538, 40.12457], [-120.00539, 40.12097], [-120.00954, 40.12098], [-120.00955, 40.12097], [-120.00951, 40.11374], [-119.99727, 40.11373], [-119.99731, 40.10639], [-120.00018, 40.10639], [-120.00021, 40.10277], [-120.01427, 40.10283]]], [[[-120.0143, 40.07009], [-120.0051, 40.07007], [-120.00503, 40.06294], [-119.99728, 40.06304], [-119.99731, 40.05619], [-120.01423, 40.05621], [-120.0143, 40.07009]]], [[[-120.12386, 40.14076], [-120.11423, 40.1436], [-120.09504, 40.14345], [-120.07638, 40.14325], [-120.07644, 40.13818], [-120.07717, 40.13785], [-120.07823, 40.13746], [-120.07864, 40.13737], [-120.08037, 40.13679], [-120.08184, 40.13626], [-120.08264, 40.13588], [-120.08386, 40.1354], [-120.0839, 40.13537], [-120.08618, 40.13262], [-120.09047, 40.12718], [-120.09403, 40.12215], [-120.09511, 40.12067], [-120.09557, 40.12013], [-120.09552, 40.12897], [-120.10967, 40.12908], [-120.10956, 40.1327], [-120.11435, 40.13274], [-120.11442, 40.12911], [-120.12143, 40.12915], [-120.12226, 40.13303], [-120.12285, 40.13602], [-120.12346, 40.13875], [-120.12374, 40.14035], [-120.12386, 40.14076]]], [[[-120.11549, 40.10016], [-120.11489, 40.10018], [-120.11476, 40.10741], [-120.11471, 40.10924], [-120.1147, 40.11087], [-120.11318, 40.11256], [-120.11234, 40.11357], [-120.11189, 40.11408], [-120.11157, 40.11431], [-120.11128, 40.11448], [-120.11094, 40.11462], [-120.10504, 40.11456], [-120.10513, 40.10729], [-120.09571, 40.10717], [-120.0956, 40.11445], [-120.09557, 40.11982], [-120.09493, 40.12058], [-120.09384, 40.12207], [-120.09029, 40.1271], [-120.086, 40.13254], [-120.08374, 40.13526], [-120.08253, 40.13574], [-120.08173, 40.13611], [-120.08028, 40.13664], [-120.07856, 40.13721], [-120.07814, 40.13731], [-120.07706, 40.13771], [-120.07645, 40.13798], [-120.07652, 40.13237], [-120.079, 40.1324], [-120.07906, 40.12878], [-120.086, 40.12885], [-120.08602, 40.11433], [-120.08632, 40.11433], [-120.08645, 40.11427], [-120.08677, 40.11404], [-120.08697, 40.11386], [-120.08707, 40.11364], [-120.08727, 40.11344], [-120.08788, 40.11296], [-120.0883, 40.1125], [-120.08863, 40.11203], [-120.08877, 40.11174], [-120.08899, 40.11108], [-120.08909, 40.11086], [-120.08972, 40.11022], [-120.09001, 40.10987], [-120.09016, 40.10948], [-120.09026, 40.10932], [-120.09062, 40.10882], [-120.09086, 40.10836], [-120.0915, 40.10579], [-120.09187, 40.10439], [-120.09198, 40.10384], [-120.0923, 40.09988], [-120.10995, 40.1001], [-120.11003, 40.09646], [-120.11475, 40.09652], [-120.11549, 40.10016]]], [[[-120.09208, 40.09987], [-120.09177, 40.10383], [-120.09166, 40.10435], [-120.09129, 40.10576], [-120.09065, 40.10832], [-120.09043, 40.10875], [-120.09006, 40.10925], [-120.08996, 40.10943], [-120.08981, 40.10981], [-120.08955, 40.11012], [-120.0889, 40.1108], [-120.08879, 40.11103], [-120.08857, 40.11169], [-120.08843, 40.11197], [-120.08812, 40.11242], [-120.08771, 40.11286], [-120.0871, 40.11334], [-120.08687, 40.11357], [-120.08679, 40.11377], [-120.08661, 40.11393], [-120.08632, 40.11414], [-120.0859, 40.11433], [-120.08357, 40.1143], [-120.08314, 40.11416], [-120.0827, 40.11382], [-120.08193, 40.11313], [-120.08137, 40.1125], [-120.08152, 40.107], [-120.0768, 40.10694], [-120.07703, 40.09969], [-120.09208, 40.09987]]], [[[-120.083, 40.11429], [-120.0813, 40.11427], [-120.08135, 40.11277], [-120.08176, 40.11323], [-120.08255, 40.11394], [-120.083, 40.11429]]], [[[-120.11172, 40.082], [-120.10559, 40.08192], [-120.10552, 40.08554], [-120.09609, 40.08542], [-120.09622, 40.07818], [-120.10092, 40.07824], [-120.10099, 40.07463], [-120.10098, 40.07462], [-120.09628, 40.07456], [-120.09634, 40.07093], [-120.10945, 40.07108], [-120.1104, 40.07573], [-120.11036, 40.07834], [-120.11091, 40.07839], [-120.11172, 40.082]]], [[[-120.10118, 40.06388], [-120.10109, 40.06753], [-120.09639, 40.0675], [-120.09647, 40.06495], [-120.09662, 40.06389], [-120.10118, 40.06388]]], [[[-120.10499, 40.1218], [-120.10497, 40.12543], [-120.10025, 40.12538], [-120.10028, 40.12175], [-120.10499, 40.1218]]], [[[-120.11049, 40.07111], [-120.11044, 40.07457], [-120.11044, 40.07457], [-120.10978, 40.07109], [-120.11049, 40.07111]]], [[[-120.11399, 40.09289], [-120.1101, 40.09284], [-120.11017, 40.08922], [-120.11323, 40.08925], [-120.11399, 40.09289]]], [[[-120.17226, 40.08558], [-120.16253, 40.08566], [-120.16248, 40.09291], [-120.17179, 40.09311], [-120.17178, 40.10042], [-120.16238, 40.10041], [-120.16232, 40.09672], [-120.15268, 40.0968], [-120.15261, 40.1003], [-120.15747, 40.10035], [-120.15761, 40.1076], [-120.15766, 40.11147], [-120.15764, 40.11484], [-120.15263, 40.11483], [-120.15259, 40.10757], [-120.14772, 40.10752], [-120.14776, 40.10383], [-120.14293, 40.10383], [-120.1429, 40.10753], [-120.13361, 40.10762], [-120.13369, 40.10025], [-120.12433, 40.10017], [-120.12456, 40.08591], [-120.12447, 40.08568], [-120.11515, 40.08565], [-120.11519, 40.08205], [-120.11197, 40.08202], [-120.11122, 40.07841], [-120.11525, 40.07841], [-120.11538, 40.07117], [-120.11806, 40.07118], [-120.11807, 40.07116], [-120.11544, 40.0657], [-120.11545, 40.06364], [-120.11552, 40.06362], [-120.11553, 40.06258], [-120.11551, 40.0588], [-120.11554, 40.05666], [-120.11289, 40.05663], [-120.11257, 40.05288], [-120.1127, 40.04931], [-120.11733, 40.04934], [-120.11766, 40.05664], [-120.13914, 40.05654], [-120.13898, 40.0637], [-120.14356, 40.06373], [-120.14341, 40.06756], [-120.14841, 40.06748], [-120.14836, 40.06381], [-120.15817, 40.06382], [-120.15801, 40.06858], [-120.15809, 40.07016], [-120.15809, 40.07228], [-120.15759, 40.07158], [-120.15515, 40.0675], [-120.15491, 40.0675], [-120.1549, 40.06751], [-120.15499, 40.06763], [-120.1574, 40.07166], [-120.15811, 40.07265], [-120.15811, 40.07274], [-120.15806, 40.07283], [-120.15611, 40.0752], [-120.15343, 40.07851], [-120.15366, 40.07851], [-120.158, 40.07321], [-120.15802, 40.07853], [-120.17222, 40.07858], [-120.17226, 40.08558]], [[-120.13572, 40.09306], [-120.13572, 40.09304], [-120.13535, 40.09284], [-120.1347, 40.09269], [-120.13437, 40.09256], [-120.13405, 40.09238], [-120.13371, 40.09209], [-120.13358, 40.0919], [-120.13352, 40.08942], [-120.13353, 40.08574], [-120.13439, 40.08574], [-120.1344, 40.08572], [-120.12892, 40.08572], [-120.12905, 40.09207], [-120.12903, 40.09304], [-120.13348, 40.09309], [-120.1335, 40.09301], [-120.13355, 40.09301], [-120.13363, 40.09307], [-120.13572, 40.09306]]], [[[-120.11469, 40.11117], [-120.11463, 40.11466], [-120.11138, 40.11463], [-120.11172, 40.11443], [-120.11206, 40.11417], [-120.11252, 40.11366], [-120.11336, 40.11265], [-120.11469, 40.11117]]], [[[-120.11975, 40.08929], [-120.11973, 40.09292], [-120.11961, 40.10016], [-120.11571, 40.10016], [-120.11524, 40.09786], [-120.11495, 40.09653], [-120.11501, 40.09292], [-120.11421, 40.09289], [-120.11345, 40.08926], [-120.11507, 40.08928], [-120.11975, 40.08929]]], [[[-120.14109, 40.12926], [-120.14064, 40.13029], [-120.14012, 40.13121], [-120.1397, 40.1319], [-120.13921, 40.13259], [-120.13855, 40.1334], [-120.13796, 40.13404], [-120.13704, 40.13492], [-120.13632, 40.13551], [-120.13569, 40.13599], [-120.13404, 40.13706], [-120.13333, 40.13745], [-120.13234, 40.13797], [-120.13069, 40.13867], [-120.129, 40.13923], [-120.12406, 40.1407], [-120.12395, 40.14032], [-120.12367, 40.13873], [-120.12306, 40.136], [-120.12247, 40.13301], [-120.12165, 40.12915], [-120.13318, 40.1292], [-120.14109, 40.12926]]], [[[-120.18569, 40.12237], [-120.18561, 40.12589], [-120.18549, 40.12955], [-120.18077, 40.12953], [-120.18071, 40.13322], [-120.1806, 40.13324], [-120.18055, 40.13684], [-120.17121, 40.13679], [-120.17133, 40.12944], [-120.17155, 40.1249], [-120.17161, 40.12241], [-120.17249, 40.12241], [-120.17604, 40.12226], [-120.18103, 40.12233], [-120.18569, 40.12237]]], [[[-120.19981, 40.12605], [-120.19973, 40.12964], [-120.19968, 40.13327], [-120.19372, 40.13324], [-120.19026, 40.13326], [-120.19024, 40.13271], [-120.19029, 40.12959], [-120.1905, 40.12595], [-120.19981, 40.12605]]]]} | Open Access 1 | Doyle Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Doyle-WA | 30433 | 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 | 10534.328 | Doyle Wildlife Area | 1968 |
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]);