superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 8 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13858 | 13858 | 13857 | {"type": "Polygon", "coordinates": [[[-120.8994, 35.44501], [-120.89928, 35.44513], [-120.89917, 35.44528], [-120.8991, 35.44542], [-120.89902, 35.44564], [-120.89897, 35.44571], [-120.89886, 35.44584], [-120.89882, 35.44596], [-120.89867, 35.44589], [-120.89871, 35.44576], [-120.89885, 35.44561], [-120.89897, 35.4453], [-120.89912, 35.44507], [-120.89925, 35.44494], [-120.8994, 35.44501]]]} | Open Access 1 | Paul Andrew Park | https://slocountyparks.com/day-use-parks/paul-andrew-park/ | 33176 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 0.448 | Paul Andrew 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 | ||
13159 | 13159 | 13158 | {"type": "Polygon", "coordinates": [[[-120.90688, 35.45191], [-120.90672, 35.45268], [-120.90648, 35.45256], [-120.90647, 35.45233], [-120.90604, 35.45211], [-120.90637, 35.45164], [-120.90688, 35.45191]]]} | Open Access 1 | Hardie Park | https://slocountyparks.com/day-use-parks/hardie-park/ | 31990 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.121 | Hardie 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 | ||
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 | ||
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 | ||
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 | ||
9322 | 9322 | 9321 | {"type": "Polygon", "coordinates": [[[-120.60526, 35.39209], [-120.60496, 35.39235], [-120.60474, 35.3926], [-120.60455, 35.39286], [-120.60443, 35.39309], [-120.60389, 35.39241], [-120.60489, 35.39187], [-120.60496, 35.39195], [-120.60482, 35.39207], [-120.60493, 35.39216], [-120.60518, 35.39199], [-120.60526, 35.39209]]]} | Open Access 1 | Santa Margarita Community Park | 25094 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 1.639 | Santa Margarita Community 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 | ||
9550 | 9550 | 9549 | {"type": "Polygon", "coordinates": [[[-121.1085, 35.56657], [-121.10785, 35.56657], [-121.10746, 35.56522], [-121.10769, 35.56517], [-121.10777, 35.5654], [-121.10792, 35.56539], [-121.10789, 35.56525], [-121.10824, 35.56519], [-121.1085, 35.56657]]]} | Open Access 1 | Shamel Park | 25354 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 2.35 | Shamel Park | ||
10267 | 10267 | 10266 | {"type": "Polygon", "coordinates": [[[-120.7087, 35.54967], [-120.70788, 35.55014], [-120.70681, 35.54963], [-120.7074, 35.54889], [-120.7087, 35.54967]]]} | Open Access 1 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 2.931 | Templeton Community 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);