superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 8 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1698 | 1698 | 1697 | {"type": "Polygon", "coordinates": [[[-120.73725, 35.17986], [-120.73672, 35.18012], [-120.73669, 35.1801], [-120.73618, 35.18036], [-120.73606, 35.1802], [-120.73594, 35.18024], [-120.73585, 35.1803], [-120.73577, 35.18031], [-120.73612, 35.17952], [-120.73725, 35.17986]]]} | Open Access 1 | Avila Park | 15732 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.515 | Avila Park | ||
1989 | 1989 | 1988 | {"type": "Polygon", "coordinates": [[[-120.5224, 35.17674], [-120.52095, 35.17779], [-120.52068, 35.17801], [-120.52048, 35.1782], [-120.52022, 35.1785], [-120.51996, 35.17888], [-120.51981, 35.17917], [-120.51963, 35.1796], [-120.51912, 35.1796], [-120.51887, 35.17973], [-120.51864, 35.17995], [-120.51835, 35.18017], [-120.51803, 35.18033], [-120.51772, 35.18041], [-120.51707, 35.18055], [-120.51675, 35.18072], [-120.51607, 35.18122], [-120.51547, 35.18159], [-120.5141, 35.18133], [-120.51375, 35.1813], [-120.5134, 35.1813], [-120.51361, 35.1807], [-120.51436, 35.1804], [-120.5146, 35.17859], [-120.52025, 35.17532], [-120.52083, 35.17585], [-120.52108, 35.17542], [-120.52162, 35.17528], [-120.52199, 35.17516], [-120.5224, 35.17674]]]} | Open Access 1 | Biddle Park | 16068 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 62.883 | Biddle Park | ||
2591 | 2591 | 2590 | {"type": "Polygon", "coordinates": [[[-120.71877, 35.18867], [-120.71877, 35.18888], [-120.71571, 35.18845], [-120.71498, 35.18848], [-120.71489, 35.18895], [-120.71472, 35.18942], [-120.71433, 35.18946], [-120.71376, 35.19011], [-120.71369, 35.19037], [-120.7137, 35.19053], [-120.71428, 35.19078], [-120.71465, 35.19089], [-120.7145, 35.19134], [-120.71428, 35.19154], [-120.71401, 35.19172], [-120.71389, 35.19198], [-120.71326, 35.19208], [-120.71321, 35.19217], [-120.71325, 35.19223], [-120.71357, 35.19254], [-120.71364, 35.19288], [-120.71353, 35.19302], [-120.71341, 35.19314], [-120.71319, 35.19333], [-120.71326, 35.19369], [-120.71377, 35.19428], [-120.71329, 35.19436], [-120.71323, 35.19434], [-120.71321, 35.19431], [-120.71282, 35.19279], [-120.71276, 35.1923], [-120.71276, 35.19187], [-120.71297, 35.19186], [-120.71337, 35.19109], [-120.71343, 35.19006], [-120.71444, 35.18915], [-120.71463, 35.1885], [-120.71386, 35.1885], [-120.7133, 35.18849], [-120.7111, 35.18795], [-120.71117, 35.18767], [-120.71344, 35.18825], [-120.71577, 35.18824], [-120.71877, 35.18867]]]} | Open Access 1 | Canyon Creek Park | 16812 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 13.209 | Canyon Creek Park | ||
3370 | 3370 | 3369 | {"type": "MultiPolygon", "coordinates": [[[[-120.64475, 35.29287], [-120.64465, 35.29305], [-120.64413, 35.29433], [-120.64404, 35.29441], [-120.64389, 35.29445], [-120.64286, 35.29441], [-120.64291, 35.29421], [-120.6425, 35.29418], [-120.64267, 35.29411], [-120.64372, 35.29308], [-120.64418, 35.29278], [-120.64434, 35.29269], [-120.64475, 35.29287]]], [[[-120.64377, 35.29458], [-120.6437, 35.29472], [-120.64281, 35.29519], [-120.64277, 35.29455], [-120.64377, 35.29458]]]]} | Open Access 1 | Cuesta Canyon County Park | 17849 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 5.733 | Cuesta Canyon County Park | ||
3386 | 3386 | 3385 | {"type": "Polygon", "coordinates": [[[-120.38069, 35.65556], [-120.38069, 35.65694], [-120.37742, 35.65689], [-120.37739, 35.65552], [-120.38069, 35.65556]]]} | Open Access 1 | CW Clarke Park | 17868 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 11.181 | CW Clarke Park | ||
3935 | 3935 | 3934 | {"type": "Polygon", "coordinates": [[[-120.83252, 35.33196], [-120.83067, 35.3336], [-120.83044, 35.33382], [-120.82384, 35.33374], [-120.82365, 35.33357], [-120.82366, 35.33193], [-120.83252, 35.33196]]]} | Open Access 1 | Elfin Forest Natural Preserve | 18558 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 35.804 | Elfin Forest Natural Preserve | ||
5375 | 5375 | 5374 | {"type": "Polygon", "coordinates": [[[-120.83748, 35.31411], [-120.83659, 35.31445], [-120.83503, 35.31172], [-120.83643, 35.31201], [-120.83645, 35.31205], [-120.83645, 35.31227], [-120.83653, 35.31251], [-120.8366, 35.31263], [-120.83727, 35.31351], [-120.83735, 35.31369], [-120.83742, 35.31396], [-120.83748, 35.31411]]]} | Open Access 1 | Los Osos Community Park | 21522 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 6.86 | Los Osos Community Park | ||
5531 | 5531 | 5530 | {"type": "Polygon", "coordinates": [[[-120.48026, 35.03952], [-120.47988, 35.03981], [-120.47918, 35.0393], [-120.47957, 35.03902], [-120.48026, 35.03952]]]} | Open Access 1 | Jim Miller Park | 20412 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 0.993 | Jim Miller Park | ||
5949 | 5949 | 5948 | {"type": "Polygon", "coordinates": [[[-121.09334, 35.54157], [-121.09224, 35.54226], [-121.09185, 35.54185], [-121.09291, 35.54118], [-121.09334, 35.54157]]]} | Open Access 1 | Lampton Cliffs County Park | 20995 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.776 | Lampton Cliffs County Park | ||
6945 | 6945 | 6944 | {"type": "MultiPolygon", "coordinates": [[[[-120.51236, 35.03141], [-120.51151, 35.03142], [-120.50616, 35.0315], [-120.50672, 35.03036], [-120.50677, 35.03033], [-120.50812, 35.0308], [-120.50814, 35.03123], [-120.51014, 35.03122], [-120.5108, 35.03095], [-120.51138, 35.03074], [-120.51225, 35.03007], [-120.51225, 35.02818], [-120.5119, 35.02817], [-120.5119, 35.02787], [-120.51192, 35.02784], [-120.51196, 35.02782], [-120.51235, 35.02782], [-120.51236, 35.03141]]], [[[-120.50742, 35.03009], [-120.50724, 35.03034], [-120.50686, 35.03021], [-120.50683, 35.03017], [-120.50683, 35.03014], [-120.50708, 35.02961], [-120.50714, 35.02943], [-120.50717, 35.0294], [-120.50723, 35.0294], [-120.50741, 35.02947], [-120.50715, 35.02999], [-120.50742, 35.03009]]], [[[-120.50768, 35.02852], [-120.50733, 35.02929], [-120.50726, 35.02926], [-120.50723, 35.02921], [-120.50728, 35.02905], [-120.50756, 35.02853], [-120.50761, 35.0285], [-120.50768, 35.02852]]], [[[-120.51174, 35.02817], [-120.51118, 35.02818], [-120.51117, 35.02918], [-120.5108, 35.02919], [-120.51056, 35.02923], [-120.51033, 35.02932], [-120.51011, 35.02947], [-120.50951, 35.02885], [-120.50923, 35.02904], [-120.50905, 35.02889], [-120.50882, 35.02877], [-120.50771, 35.02838], [-120.50767, 35.02833], [-120.50791, 35.02787], [-120.50797, 35.02784], [-120.50911, 35.02784], [-120.51168, 35.02782], [-120.51172, 35.02784], [-120.51174, 35.02787], [-120.51174, 35.02817]]]]} | Open Access 1 | Mesa Meadows Natural Area | 22177 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 21.104 | Mesa Meadows Natural Area | ||
7104 | 7104 | 7103 | {"type": "Polygon", "coordinates": [[[-120.86112, 35.31032], [-120.86111, 35.31276], [-120.86105, 35.31586], [-120.86045, 35.31587], [-120.86045, 35.31573], [-120.86041, 35.31569], [-120.86078, 35.31419], [-120.86095, 35.31265], [-120.85951, 35.31264], [-120.85951, 35.31145], [-120.8592, 35.31143], [-120.85933, 35.31126], [-120.85933, 35.31119], [-120.8593, 35.31114], [-120.8592, 35.3111], [-120.85909, 35.31112], [-120.85899, 35.31102], [-120.85674, 35.31101], [-120.85675, 35.31089], [-120.85678, 35.31076], [-120.85674, 35.31066], [-120.85667, 35.31059], [-120.85667, 35.3103], [-120.86112, 35.31032]]]} | Open Access 1 | Monarch Grove Natural Area | 22365 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 17.535 | Monarch Grove Natural Area | ||
7391 | 7391 | 7390 | {"type": "MultiPolygon", "coordinates": [[[[-120.50201, 35.02849], [-120.49971, 35.03343], [-120.4986, 35.03308], [-120.49843, 35.03301], [-120.49819, 35.03289], [-120.49524, 35.03088], [-120.49522, 35.03085], [-120.49522, 35.0308], [-120.49548, 35.03047], [-120.49593, 35.02976], [-120.49622, 35.02925], [-120.49661, 35.02847], [-120.49909, 35.02926], [-120.49982, 35.02776], [-120.50201, 35.02849]]], [[[-120.50667, 35.03003], [-120.50484, 35.03377], [-120.50263, 35.03787], [-120.50037, 35.03396], [-120.50026, 35.03382], [-120.5001, 35.03366], [-120.49995, 35.03355], [-120.49978, 35.03346], [-120.50209, 35.02851], [-120.50667, 35.03003]]]]} | Open Access 1 | Nipomo Community Park | 22767 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 134.895 | Nipomo Community Park | ||
7629 | 7629 | 7628 | {"type": "Polygon", "coordinates": [[[-120.62642, 35.1044], [-120.62597, 35.10496], [-120.62525, 35.10457], [-120.6257, 35.10401], [-120.62642, 35.1044]]]} | Open Access 1 | Oceano Memorial Campground | 23064 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.456 | Oceano Memorial Campground | ||
7630 | 7630 | 7629 | {"type": "MultiPolygon", "coordinates": [[[[-120.62428, 35.10545], [-120.62366, 35.10564], [-120.6231, 35.1049], [-120.62418, 35.10482], [-120.62428, 35.10545]]], [[[-120.62597, 35.10646], [-120.62472, 35.10684], [-120.62438, 35.10481], [-120.62511, 35.10475], [-120.62594, 35.10521], [-120.62552, 35.10565], [-120.6255, 35.10592], [-120.62574, 35.10626], [-120.62594, 35.10634], [-120.62597, 35.10646]]]]} | Open Access 1 | Oceano Memorial Park | 23065 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 6.954 | Oceano Memorial Park | ||
7693 | 7693 | 7692 | {"type": "Polygon", "coordinates": [[[-120.70316, 35.18542], [-120.70293, 35.18607], [-120.70292, 35.18601], [-120.70288, 35.18597], [-120.7028, 35.18595], [-120.70274, 35.18597], [-120.70204, 35.18641], [-120.70158, 35.18682], [-120.70176, 35.18626], [-120.70316, 35.18542]]]} | Open Access 1 | Ontario Road Staging Area Park | 23147 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.185 | Ontario Road Staging Area Park | ||
7711 | 7711 | 7710 | {"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73284, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34154], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]} | Restricted Access 2 | El Chorro Regional Park and Dairy Creek Golf Course | 33039 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 684.14 | El Chorro RP and Dairy Creek GC | ||
8732 | 8732 | 8731 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73761], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 3.26 | Rios Caledonia Adobe | ||
9187 | 9187 | 9186 | {"type": "MultiPolygon", "coordinates": [[[[-120.6245, 35.11002], [-120.62419, 35.11012], [-120.62312, 35.1078], [-120.62286, 35.1073], [-120.62239, 35.10649], [-120.62277, 35.10634], [-120.6229, 35.10654], [-120.62301, 35.10675], [-120.6245, 35.11002]]], [[[-120.62952, 35.12079], [-120.6292, 35.12089], [-120.62657, 35.11519], [-120.62426, 35.11027], [-120.62457, 35.11017], [-120.62699, 35.11532], [-120.62952, 35.12079]]]]} | Open Access 1 | Sand and Surf County Park | 25009 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 13.004 | Sand and Surf County Park | ||
9228 | 9228 | 9227 | {"type": "Polygon", "coordinates": [[[-120.6997, 35.75055], [-120.69948, 35.75185], [-120.69912, 35.7518], [-120.6989, 35.75166], [-120.69837, 35.75161], [-120.69849, 35.75083], [-120.69876, 35.75085], [-120.69881, 35.7505], [-120.6997, 35.75055]]]} | Open Access 1 | San Miguel Community Park | 24955 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 3.198 | San Miguel Community Park | ||
9230 | 9230 | 9229 | {"type": "Polygon", "coordinates": [[[-120.6906, 35.75373], [-120.68985, 35.75372], [-120.68986, 35.75288], [-120.69045, 35.75267], [-120.6906, 35.75373]]]} | Open Access 1 | San Miguel Staging Area Park | 24961 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.605 | San Miguel Staging Area Park |
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]);