superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where MNG_AGENCY = 5 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2695 | 2695 | 2694 | {"type": "Polygon", "coordinates": [[[-122.14918, 37.24376], [-122.14914, 37.24377], [-122.14907, 37.24375], [-122.14904, 37.24355], [-122.14916, 37.24355], [-122.14919, 37.2437], [-122.14918, 37.24376]]]} | Open Access 1 | Castle Rock State Park | http://www.parks.ca.gov/?page_id=538 | 16955 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.065 | Castle Rock SP | 1968 |
6598 | 6598 | 6597 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92119], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | Manresa State Beach Access | http://www.parks.ca.gov/?page_id=545 | 21760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.136 | Manresa SB Access | |
9445 | 9445 | 9444 | {"type": "MultiPolygon", "coordinates": [[[[-121.89604, 36.96303], [-121.8959, 36.96315], [-121.89565, 36.96297], [-121.89579, 36.96284], [-121.89604, 36.96303]]], [[[-121.89601, 36.96337], [-121.89594, 36.96344], [-121.89597, 36.96347], [-121.89591, 36.96352], [-121.89585, 36.96371], [-121.89574, 36.96366], [-121.89573, 36.96365], [-121.89581, 36.96344], [-121.89591, 36.96334], [-121.89601, 36.96337]]]]} | Open Access 1 | Seacliff State Beach | http://www.parks.ca.gov/?page_id=543 | 25238 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.25 | Seacliff SB | 1931 |
8321 | 8321 | 8320 | {"type": "Polygon", "coordinates": [[[-121.95538, 36.98556], [-121.95509, 36.9857], [-121.95498, 36.98583], [-121.95502, 36.98592], [-121.95472, 36.98598], [-121.95477, 36.98571], [-121.9549, 36.98545], [-121.95538, 36.98556]]]} | Open Access 1 | Soquel Lions Park | 25623 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.381 | Soquel Lions Park | ||
8670 | 8670 | 8669 | {"type": "Polygon", "coordinates": [[[-121.93881, 36.98905], [-121.93822, 36.98905], [-121.93821, 36.98875], [-121.93824, 36.98871], [-121.93853, 36.9887], [-121.93856, 36.98875], [-121.93875, 36.98872], [-121.93881, 36.98905]]]} | Open Access 1 | Richard Vessey Park | 24328 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.46 | Richard Vessey Park | ||
6251 | 6251 | 6250 | {"type": "Polygon", "coordinates": [[[-121.95533, 36.98673], [-121.95482, 36.98678], [-121.95473, 36.98618], [-121.95489, 36.98615], [-121.95533, 36.98673]]]} | Open Access 1 | Lions Park | 21317 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.517 | Lions Park | ||
5089 | 5089 | 5088 | {"type": "Polygon", "coordinates": [[[-121.98799, 36.97419], [-121.98785, 36.97463], [-121.98734, 36.97452], [-121.98747, 36.97409], [-121.98799, 36.97419]]]} | Open Access 1 | Hestwood Park | 19885 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.588 | Hestwood Park | ||
1877 | 1877 | 1876 | {"type": "Polygon", "coordinates": [[[-121.95634, 36.96909], [-121.95598, 36.96939], [-121.95522, 36.97019], [-121.95526, 36.97], [-121.95536, 36.96979], [-121.95537, 36.96963], [-121.95551, 36.96959], [-121.95555, 36.96953], [-121.95557, 36.9693], [-121.95562, 36.96928], [-121.95576, 36.96934], [-121.95585, 36.96935], [-121.9559, 36.96935], [-121.95603, 36.96927], [-121.9562, 36.96905], [-121.95625, 36.96902], [-121.95634, 36.96909]]]} | Open Access 1 | Capitola Beach | 16838 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.61 | Capitola Beach | ||
14291 | 14291 | 14290 | {"type": "Polygon", "coordinates": [[[-121.85444, 36.9225], [-121.85412, 36.92319], [-121.85377, 36.92307], [-121.85374, 36.9231], [-121.85269, 36.92275], [-121.85271, 36.92271], [-121.85332, 36.92292], [-121.85334, 36.92288], [-121.85364, 36.92287], [-121.85392, 36.92281], [-121.85385, 36.92266], [-121.85379, 36.92263], [-121.85393, 36.92259], [-121.8539, 36.92264], [-121.85399, 36.92279], [-121.85421, 36.92268], [-121.85444, 36.9225]]]} | Open Access 1 | Unknown park - Santa Cruz, County of | 28665 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.746 | |||
10314 | 10314 | 10313 | {"type": "MultiPolygon", "coordinates": [[[[-121.9654, 36.95968], [-121.9654, 36.95968], [-121.96488, 36.96008], [-121.96489, 36.9599], [-121.96496, 36.95985], [-121.96516, 36.95981], [-121.96528, 36.95971], [-121.96532, 36.95963], [-121.96534, 36.95945], [-121.9654, 36.95935], [-121.9654, 36.95968]]], [[[-121.96554, 36.96051], [-121.96499, 36.96051], [-121.96499, 36.96023], [-121.96554, 36.9598], [-121.96554, 36.96051]]]]} | Open Access 1 | The Hook Beach Access | 26285 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.826 | The Hook Beach Access | ||
4272 | 4272 | 4271 | {"type": "Polygon", "coordinates": [[[-121.96736, 36.96132], [-121.96735, 36.96204], [-121.96697, 36.96203], [-121.96697, 36.96155], [-121.96651, 36.96154], [-121.96651, 36.96131], [-121.96736, 36.96132]]]} | Open Access 1 | Floral Park | 18959 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.937 | Floral Park | ||
14094 | 14094 | 14093 | {"type": "Polygon", "coordinates": [[[-121.9128, 36.9767], [-121.91215, 36.97675], [-121.91216, 36.97584], [-121.91275, 36.97583], [-121.91271, 36.97617], [-121.9128, 36.9767]]]} | Open Access 1 | Seacliff Village Park (McGregor) | http://www.scparks.com/Home/Parks/ListofAllCountyParks.aspx | 33609 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 1.282 | Seacliff Village Park (McGregor) | |
9061 | 9061 | 9060 | {"type": "Polygon", "coordinates": [[[-121.99783, 36.96797], [-121.99778, 36.96838], [-121.99638, 36.96825], [-121.99644, 36.96784], [-121.99783, 36.96797]]]} | Open Access 1 | Twin Lakes Park | 26617 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 1.416 | Twin Lakes Park | ||
9169 | 9169 | 9168 | {"type": "MultiPolygon", "coordinates": [[[[-121.86668, 36.99615], [-121.86622, 36.99659], [-121.86588, 36.99638], [-121.86594, 36.99611], [-121.86598, 36.99604], [-121.86629, 36.99605], [-121.86668, 36.99615]]], [[[-121.86716, 36.99638], [-121.86716, 36.99639], [-121.86607, 36.99714], [-121.8662, 36.99674], [-121.86631, 36.99659], [-121.86672, 36.99621], [-121.86716, 36.99638]]]]} | Open Access 1 | Valencia Hall Park | 26761 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 1.475 | Valencia Hall Park | ||
9307 | 9307 | 9306 | {"type": "Polygon", "coordinates": [[[-121.97829, 37.0053], [-121.97809, 37.00576], [-121.97787, 37.00575], [-121.97786, 37.00548], [-121.97734, 37.00547], [-121.97737, 37.00514], [-121.97736, 37.00494], [-121.97733, 37.00482], [-121.97818, 37.00467], [-121.97826, 37.00495], [-121.97822, 37.00505], [-121.97829, 37.0053]]]} | Open Access 1 | Santa Cruz Gardens Park | 25063 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 1.788 | Santa Cruz Gardens Park | ||
1946 | 1946 | 1945 | {"type": "MultiPolygon", "coordinates": [[[[-122.08941, 37.08847], [-122.08867, 37.0882], [-122.0887, 37.08805], [-122.0888, 37.08808], [-122.08909, 37.08823], [-122.08938, 37.08835], [-122.08941, 37.08847]]], [[[-122.09254, 37.08896], [-122.0925, 37.08902], [-122.09227, 37.08886], [-122.09149, 37.08889], [-122.09142, 37.08887], [-122.09136, 37.08877], [-122.09012, 37.08881], [-122.09009, 37.08846], [-122.09002, 37.08845], [-122.09019, 37.08817], [-122.09026, 37.08819], [-122.09035, 37.08816], [-122.09053, 37.08823], [-122.09047, 37.08832], [-122.09038, 37.08833], [-122.09042, 37.08845], [-122.09039, 37.08845], [-122.09039, 37.08849], [-122.09058, 37.08852], [-122.0911, 37.08856], [-122.09112, 37.08854], [-122.09111, 37.08848], [-122.09135, 37.08849], [-122.09136, 37.08857], [-122.09139, 37.08858], [-122.09176, 37.08858], [-122.09193, 37.08861], [-122.09225, 37.08874], [-122.09234, 37.08883], [-122.09245, 37.08889], [-122.09254, 37.08896]]]]} | Open Access 1 | Ben Lomond Park | 16002 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 1.957 | Ben Lomond Park | ||
5877 | 5877 | 5876 | {"type": "Polygon", "coordinates": [[[-121.76493, 36.96594], [-121.76442, 36.96592], [-121.76403, 36.96472], [-121.76492, 36.96472], [-121.76493, 36.96594]]]} | Open Access 1 | Mesa Village Park | 22182 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.065 | Mesa Village Park | ||
11287 | 11287 | 11286 | {"type": "Polygon", "coordinates": [[[-121.93328, 36.98717], [-121.93307, 36.98817], [-121.93247, 36.98809], [-121.93247, 36.98801], [-121.93215, 36.98797], [-121.93234, 36.98705], [-121.93328, 36.98717]]]} | Open Access 1 | Willowbrook Park | 27589 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.301 | Willowbrook Park | ||
11608 | 11608 | 11607 | {"type": "Polygon", "coordinates": [[[-121.74548, 36.91252], [-121.74543, 36.91258], [-121.74506, 36.91341], [-121.74351, 36.91547], [-121.7433, 36.91528], [-121.74403, 36.91429], [-121.74416, 36.91385], [-121.74483, 36.91341], [-121.74512, 36.91263], [-121.74548, 36.91252]]]} | Open Access 1 | Pajaro River | 28154 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.422 | Pajaro River | ||
5106 | 5106 | 5105 | {"type": "MultiPolygon", "coordinates": [[[[-121.88803, 36.96112], [-121.8874, 36.96143], [-121.88725, 36.96128], [-121.88733, 36.96113], [-121.88674, 36.96072], [-121.88659, 36.96057], [-121.88667, 36.96038], [-121.88733, 36.96103], [-121.88803, 36.96112]]], [[[-121.88865, 36.95676], [-121.88823, 36.9575], [-121.88824, 36.95754], [-121.88779, 36.95806], [-121.88785, 36.95842], [-121.88803, 36.95889], [-121.88785, 36.95921], [-121.88746, 36.9591], [-121.88746, 36.95897], [-121.88765, 36.95859], [-121.88751, 36.95839], [-121.88767, 36.95762], [-121.88767, 36.95746], [-121.8878, 36.95735], [-121.8882, 36.95748], [-121.88863, 36.95674], [-121.88865, 36.95676]]]]} | Open Access 1 | Hidden Beach Park | 19902 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.431 | Hidden Beach 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]);