units_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)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, GAP_STS
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL ▼ | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-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 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
128 | 128 | 127 | {"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 | 394 | San Miguel Community Park | 24955 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.196 | San Miguel Community Park | 0 | Local Park 2 | 4 | |
142 | 142 | 141 | {"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 | 446 | Sand and Surf County Park | 25009 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 13.006 | Sand and Surf County Park | 0 | Local Park 2 | 4 | |
160 | 160 | 159 | {"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 | 409 | San Miguel Staging Area Park | 24961 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.605 | San Miguel Staging Area Park | 0 | Local Park 2 | 4 | |
288 | 288 | 287 | {"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 | 772 | Shamel Park | 25354 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.347 | Shamel Park | 0 | Local Park 2 | 4 | |
423 | 423 | 422 | {"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 | 1306 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.932 | Templeton Community Park | 0 | Local Park 2 | 4 | |
1720 | 1720 | 1719 | {"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 | 14878 | Elfin Forest Natural Preserve | 18558 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 35.806 | Elfin Forest Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
2075 | 2075 | 2074 | {"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 | 17231 | Lampton Cliffs County Park | 20995 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.776 | Lampton Cliffs County Park | 0 | Local Park 2 | 4 | |
2135 | 2135 | 2134 | {"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.83648, 35.3124], [-120.83653, 35.31252], [-120.8366, 35.31263], [-120.83727, 35.31351], [-120.83735, 35.31369], [-120.83742, 35.31397], [-120.83748, 35.31411]]]} | Open Access 1 | 17422 | Los Osos Community Park | 21522 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 6.857 | Los Osos Community Park | 0 | Local Park 2 | 4 | |
2257 | 2257 | 2256 | {"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.52084, 35.17586], [-120.52091, 35.1757], [-120.52108, 35.17542], [-120.52162, 35.17528], [-120.52199, 35.17516], [-120.5224, 35.17674]]]} | Open Access 1 | 18104 | Biddle Park | 16068 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 62.881 | Biddle Park | 0 | Local Park 2 | 4 | |
2313 | 2313 | 2312 | {"type": "Polygon", "coordinates": [[[-120.73725, 35.17986], [-120.73672, 35.18012], [-120.7367, 35.1801], [-120.73618, 35.18036], [-120.73607, 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 | 16972 | Avila Park | 15732 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.514 | Avila Park | 0 | Local Park 2 | 4 | |
2320 | 2320 | 2319 | {"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 | 17031 | Jim Miller Park | 20412 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 0.993 | Jim Miller Park | 0 | Local Park 2 | 4 | |
2694 | 2694 | 2693 | {"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 | 18257 | Oceano Memorial Campground | 23064 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.456 | Oceano Memorial Campground | 0 | Local Recreation Area 3 | 4 | |
2695 | 2695 | 2694 | {"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.62551, 35.10565], [-120.6255, 35.10593], [-120.62574, 35.10626], [-120.62594, 35.10634], [-120.62597, 35.10646]]]]} | Open Access 1 | 18260 | Oceano Memorial Park | 23065 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 6.953 | Oceano Memorial Park | 0 | Local Park 2 | 4 | |
3906 | 3906 | 3905 | {"type": "Polygon", "coordinates": [[[-120.68988, 35.7518], [-120.68637, 35.75282], [-120.68543, 35.7525], [-120.68529, 35.75228], [-120.68512, 35.75228], [-120.68514, 35.75221], [-120.68616, 35.75215], [-120.6861, 35.75083], [-120.68543, 35.75084], [-120.68542, 35.74725], [-120.68987, 35.74723], [-120.68988, 35.7518]]]} | Open Access 1 | 1959 | Wolf Property Natural Area | 27671 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 54.586 | Wolf Property Natural Area | 0 | Local Conservation Area 4 | 2 | |
5975 | 5975 | 5974 | {"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.60481, 35.39207], [-120.60494, 35.39217], [-120.60518, 35.39199], [-120.60526, 35.39209]]]} | Open Access 1 | 560 | Santa Margarita Community Park | 25094 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.636 | Santa Margarita Community Park | 0 | Local Park 2 | 4 | |
6518 | 6518 | 6517 | {"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.71324, 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.1937], [-120.71377, 35.19428], [-120.71329, 35.19436], [-120.71323, 35.19434], [-120.71322, 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.71445, 35.18914], [-120.71463, 35.18849], [-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 | 2755 | Canyon Creek Park | 16812 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 13.188 | Canyon Creek Park | 0 | Local Park 2 | 4 | |
7318 | 7318 | 7317 | {"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 | 11956 | CW Clarke Park | 17868 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 11.182 | CW Clarke Park | 0 | Local Park 2 | 4 | |
9841 | 9841 | 9840 | {"type": "Polygon", "coordinates": [[[-120.64277, 35.46619], [-120.64156, 35.46683], [-120.64042, 35.46748], [-120.64028, 35.46754], [-120.64011, 35.46754], [-120.64004, 35.46759], [-120.63996, 35.46768], [-120.63992, 35.4678], [-120.63996, 35.46802], [-120.63999, 35.46815], [-120.64005, 35.46834], [-120.64011, 35.46844], [-120.6402, 35.46857], [-120.64037, 35.46871], [-120.63791, 35.47016], [-120.63743, 35.46939], [-120.63727, 35.46901], [-120.63719, 35.4686], [-120.63727, 35.46813], [-120.63748, 35.46751], [-120.63739, 35.46725], [-120.63738, 35.46625], [-120.63752, 35.46583], [-120.63746, 35.46519], [-120.6386, 35.46461], [-120.64051, 35.46353], [-120.64277, 35.46619]]]} | Open Access 1 | 16821 | Heilmann Regional Park | 33134 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 48.892 | Heilmann RP | 0 | Local Park 2 | 4 | |
10185 | 10185 | 10184 | {"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.50813, 35.03123], [-120.51014, 35.03122], [-120.5108, 35.03095], [-120.51138, 35.03074], [-120.51225, 35.03007], [-120.51225, 35.02817], [-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.50714, 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.51117, 35.02818], [-120.51117, 35.02918], [-120.5108, 35.02919], [-120.51056, 35.02923], [-120.51033, 35.02932], [-120.51011, 35.02947], [-120.5095, 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 | 17778 | Mesa Meadows Natural Area | 22177 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 21.08 | Mesa Meadows Natural Area | 0 | Local Conservation Area 4 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);