superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Redwood-Shores-ER"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14507 | 14507 | 14506 | {"type": "MultiPolygon", "coordinates": [[[[-122.24109, 37.53196], [-122.24026, 37.53267], [-122.23995, 37.53284], [-122.23981, 37.53272], [-122.23951, 37.53287], [-122.23951, 37.53297], [-122.23917, 37.5335], [-122.23916, 37.53388], [-122.23889, 37.53387], [-122.23889, 37.53344], [-122.23907, 37.53318], [-122.23905, 37.53291], [-122.23853, 37.53291], [-122.23777, 37.53271], [-122.23755, 37.53276], [-122.23679, 37.53301], [-122.23602, 37.53333], [-122.23549, 37.53361], [-122.23498, 37.53394], [-122.2344, 37.53393], [-122.23539, 37.53323], [-122.2372, 37.53252], [-122.23814, 37.53242], [-122.23881, 37.5325], [-122.23917, 37.53234], [-122.23956, 37.53233], [-122.24054, 37.53203], [-122.24095, 37.53182], [-122.24109, 37.53196]]], [[[-122.24821, 37.55457], [-122.24811, 37.55571], [-122.24805, 37.5559], [-122.24656, 37.55451], [-122.24761, 37.55355], [-122.24821, 37.55457]]], [[[-122.25316, 37.51712], [-122.25288, 37.51718], [-122.25278, 37.51722], [-122.2523, 37.51759], [-122.2519, 37.51784], [-122.25133, 37.51812], [-122.2507, 37.51834], [-122.25055, 37.51843], [-122.25045, 37.51856], [-122.25041, 37.51866], [-122.2504, 37.51876], [-122.25042, 37.51992], [-122.25044, 37.51997], [-122.25048, 37.52001], [-122.25135, 37.52014], [-122.25121, 37.52048], [-122.25113, 37.52073], [-122.25093, 37.5215], [-122.25092, 37.52179], [-122.25093, 37.52219], [-122.25098, 37.52258], [-122.25105, 37.52292], [-122.24961, 37.52337], [-122.24827, 37.52219], [-122.24918, 37.52094], [-122.24962, 37.52019], [-122.25022, 37.52041], [-122.2503, 37.52029], [-122.25029, 37.52027], [-122.25, 37.52016], [-122.24999, 37.51858], [-122.25002, 37.51852], [-122.25011, 37.51839], [-122.25021, 37.51828], [-122.25047, 37.51809], [-122.25061, 37.51803], [-122.25097, 37.51791], [-122.25129, 37.51778], [-122.2516, 37.51762], [-122.25183, 37.51748], [-122.25216, 37.51725], [-122.25273, 37.51675], [-122.25316, 37.51712]]], [[[-122.25128, 37.54022], [-122.25087, 37.54031], [-122.25022, 37.54105], [-122.25023, 37.54173], [-122.25044, 37.54207], [-122.24881, 37.54254], [-122.24881, 37.54222], [-122.24906, 37.54167], [-122.24868, 37.541], [-122.24918, 37.54088], [-122.24937, 37.5405], [-122.24959, 37.54056], [-122.24986, 37.54008], [-122.25078, 37.53917], [-122.25106, 37.53902], [-122.25105, 37.53888], [-122.2511, 37.53887], [-122.25128, 37.54022]]], [[[-122.25855, 37.5412], [-122.25773, 37.54143], [-122.25686, 37.54155], [-122.25402, 37.54146], [-122.25328, 37.54132], [-122.25285, 37.5414], [-122.25253, 37.54157], [-122.25236, 37.54191], [-122.25233, 37.54212], [-122.25272, 37.54271], [-122.2534, 37.54315], [-122.25387, 37.54464], [-122.254, 37.54546], [-122.25422, 37.54582], [-122.25427, 37.54616], [-122.25413, 37.54701], [-122.25415, 37.54736], [-122.25426, 37.54758], [-122.25438, 37.54772], [-122.25422, 37.54783], [-122.25378, 37.548], [-122.25358, 37.5483], [-122.25327, 37.54856], [-122.25262, 37.54948], [-122.25257, 37.54946], [-122.25317, 37.54859], [-122.25247, 37.54858], [-122.25405, 37.54638], [-122.25416, 37.54592], [-122.25401, 37.54574], [-122.25339, 37.54369], [-122.25148, 37.54188], [-122.25145, 37.54121], [-122.25503, 37.54121], [-122.25559, 37.54134], [-122.25724, 37.54136], [-122.25772, 37.54131], [-122.25804, 37.54119], [-122.25855, 37.5412]]], [[[-122.26038, 37.53109], [-122.26037, 37.53411], [-122.25952, 37.53411], [-122.25952, 37.53396], [-122.25955, 37.53368], [-122.25965, 37.53339], [-122.25979, 37.53265], [-122.2599, 37.53229], [-122.25991, 37.53193], [-122.25989, 37.53168], [-122.25979, 37.5313], [-122.25972, 37.53112], [-122.26011, 37.53083], [-122.26038, 37.53109]]], [[[-122.26467, 37.53385], [-122.26452, 37.53416], [-122.26216, 37.53344], [-122.2617, 37.5334], [-122.26128, 37.5337], [-122.26076, 37.53587], [-122.26057, 37.53803], [-122.26052, 37.53972], [-122.26051, 37.53421], [-122.26066, 37.53374], [-122.26128, 37.53325], [-122.26215, 37.53307], [-122.26467, 37.53385]]]]} | Open Access 1 | Redwood Shores Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Redwood-Shores-ER | 32274 | 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 | 63.659 | Redwood Shores ER | 1976 |
14526 | 14526 | 14525 | {"type": "MultiPolygon", "coordinates": [[[[-122.25028, 37.5486], [-122.24616, 37.55153], [-122.24454, 37.55092], [-122.24449, 37.55056], [-122.23268, 37.5485], [-122.22913, 37.54832], [-122.22573, 37.54575], [-122.22551, 37.54456], [-122.22647, 37.54375], [-122.22746, 37.54312], [-122.228, 37.54251], [-122.22814, 37.54218], [-122.2287, 37.54151], [-122.22976, 37.53961], [-122.23149, 37.53647], [-122.23186, 37.53603], [-122.23309, 37.53486], [-122.2344, 37.53393], [-122.23498, 37.53394], [-122.23331, 37.53504], [-122.23279, 37.53595], [-122.23386, 37.53877], [-122.23244, 37.53989], [-122.23463, 37.54114], [-122.23471, 37.54139], [-122.23202, 37.54174], [-122.23135, 37.54208], [-122.22993, 37.54172], [-122.22602, 37.54478], [-122.22612, 37.54565], [-122.22864, 37.54753], [-122.22881, 37.54742], [-122.2294, 37.54785], [-122.22964, 37.54796], [-122.2339, 37.54828], [-122.23459, 37.54768], [-122.23539, 37.54826], [-122.23601, 37.54817], [-122.2431, 37.54898], [-122.2432, 37.54887], [-122.24423, 37.54895], [-122.24467, 37.54932], [-122.24458, 37.54992], [-122.24415, 37.54988], [-122.24432, 37.55034], [-122.24486, 37.55048], [-122.24483, 37.54996], [-122.24511, 37.54992], [-122.24523, 37.55012], [-122.24553, 37.54982], [-122.24629, 37.54998], [-122.2473, 37.54929], [-122.2456, 37.54832], [-122.24616, 37.54769], [-122.24856, 37.54903], [-122.2492, 37.54861], [-122.24947, 37.5484], [-122.24989, 37.54788], [-122.25022, 37.54713], [-122.25046, 37.54652], [-122.2505, 37.54636], [-122.25049, 37.54618], [-122.2501, 37.54469], [-122.24881, 37.54254], [-122.24985, 37.54224], [-122.25108, 37.54487], [-122.25117, 37.54517], [-122.25127, 37.5459], [-122.25116, 37.54638], [-122.25055, 37.54751], [-122.25015, 37.5481], [-122.24992, 37.54835], [-122.24962, 37.54859], [-122.25028, 37.5486]]], [[[-122.25031, 37.52028], [-122.25023, 37.52041], [-122.24962, 37.5202], [-122.24918, 37.52094], [-122.24828, 37.52218], [-122.2483, 37.52221], [-122.24792, 37.52383], [-122.24781, 37.52382], [-122.2478, 37.52386], [-122.24781, 37.5241], [-122.24786, 37.52424], [-122.24796, 37.52444], [-122.24799, 37.52472], [-122.24791, 37.52535], [-122.24786, 37.52542], [-122.24778, 37.52547], [-122.24723, 37.52548], [-122.24707, 37.52552], [-122.24692, 37.52562], [-122.24685, 37.52574], [-122.2467, 37.52589], [-122.24634, 37.52667], [-122.245, 37.52927], [-122.24342, 37.53062], [-122.24231, 37.53147], [-122.24153, 37.53184], [-122.24148, 37.53156], [-122.24182, 37.53144], [-122.24329, 37.5305], [-122.24468, 37.52927], [-122.245, 37.52866], [-122.24525, 37.52848], [-122.24547, 37.52798], [-122.24599, 37.52722], [-122.24624, 37.52667], [-122.24633, 37.52654], [-122.24643, 37.52628], [-122.24654, 37.52603], [-122.24661, 37.52577], [-122.24721, 37.52417], [-122.24776, 37.52234], [-122.24798, 37.52223], [-122.2481, 37.52205], [-122.24773, 37.52171], [-122.24828, 37.51948], [-122.24999, 37.51947], [-122.25, 37.52016], [-122.25031, 37.52028]]], [[[-122.25278, 37.54858], [-122.25136, 37.55035], [-122.25103, 37.55059], [-122.24968, 37.55201], [-122.24686, 37.55341], [-122.24684, 37.55426], [-122.24657, 37.55451], [-122.24683, 37.55476], [-122.24681, 37.55559], [-122.24618, 37.55478], [-122.24514, 37.55598], [-122.24549, 37.55472], [-122.24616, 37.55371], [-122.24753, 37.55203], [-122.25081, 37.54981], [-122.25228, 37.54852], [-122.25251, 37.54853], [-122.25248, 37.54856], [-122.25249, 37.54858], [-122.25278, 37.54858]]], [[[-122.24865, 37.51867], [-122.24743, 37.51868], [-122.24741, 37.51813], [-122.24748, 37.51813], [-122.2475, 37.51816], [-122.24862, 37.51816], [-122.24865, 37.51867]]], [[[-122.26048, 37.53983], [-122.25986, 37.54047], [-122.25946, 37.54084], [-122.25913, 37.54101], [-122.25855, 37.5412], [-122.25804, 37.54119], [-122.25772, 37.54131], [-122.25724, 37.54136], [-122.25559, 37.54134], [-122.25503, 37.54121], [-122.25145, 37.54121], [-122.25134, 37.54061], [-122.25128, 37.54022], [-122.25111, 37.53887], [-122.25235, 37.53852], [-122.25331, 37.5382], [-122.25366, 37.53831], [-122.25397, 37.53888], [-122.25428, 37.53932], [-122.25501, 37.53978], [-122.25625, 37.54008], [-122.2566, 37.54011], [-122.25696, 37.54005], [-122.25758, 37.53973], [-122.25905, 37.53885], [-122.25959, 37.53581], [-122.25953, 37.53523], [-122.25952, 37.53411], [-122.26037, 37.53411], [-122.26039, 37.53561], [-122.26051, 37.53857], [-122.26048, 37.53983]]]]} | Restricted Access 2 | Redwood Shores Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Redwood-Shores-ER | 24252 | 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 | 218.214 | Redwood Shores ER | 1976 |
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]);