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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |
6967 | 6967 | 6966 | {"type": "Polygon", "coordinates": [[[-122.0518, 37.04316], [-122.05171, 37.04325], [-122.05136, 37.04307], [-122.05098, 37.04293], [-122.05, 37.04275], [-122.05026, 37.04347], [-122.04925, 37.04494], [-122.0486, 37.04622], [-122.04469, 37.04114], [-122.04518, 37.04088], [-122.04547, 37.04119], [-122.04567, 37.04136], [-122.04589, 37.04151], [-122.04612, 37.04165], [-122.04637, 37.04178], [-122.04663, 37.04188], [-122.04719, 37.04204], [-122.05101, 37.04281], [-122.05123, 37.04287], [-122.05152, 37.04299], [-122.0518, 37.04316]]]} | Open Access 1 | Michael Gray Field Park | 22195 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 27.916 | Michael Gray Field Park | ||
7200 | 7200 | 7199 | {"type": "MultiPolygon", "coordinates": [[[[-121.97832, 36.95705], [-121.97829, 36.95709], [-121.9783, 36.95711], [-121.97787, 36.95759], [-121.97783, 36.95757], [-121.97775, 36.95765], [-121.97718, 36.95745], [-121.97668, 36.9574], [-121.97609, 36.95755], [-121.97595, 36.95809], [-121.97577, 36.9583], [-121.97571, 36.95895], [-121.97546, 36.95939], [-121.97509, 36.95967], [-121.97488, 36.95987], [-121.97474, 36.95987], [-121.97499, 36.95918], [-121.97528, 36.95862], [-121.97554, 36.95745], [-121.9757, 36.95715], [-121.97617, 36.9566], [-121.97634, 36.95646], [-121.97646, 36.95645], [-121.97691, 36.95656], [-121.97758, 36.95608], [-121.97784, 36.95626], [-121.97797, 36.95666], [-121.97792, 36.95673], [-121.97828, 36.95698], [-121.97832, 36.95705]]], [[[-121.97827, 36.95625], [-121.97813, 36.95638], [-121.97809, 36.95638], [-121.97801, 36.95612], [-121.97812, 36.95614], [-121.97827, 36.95625]]]]} | Open Access 1 | Moran Lake Park | 22471 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 8.947 | Moran Lake Park | ||
7839 | 7839 | 7838 | {"type": "MultiPolygon", "coordinates": [[[[-122.07465, 37.09388], [-122.07452, 37.0943], [-122.07432, 37.0947], [-122.07404, 37.09507], [-122.07345, 37.09551], [-122.07319, 37.09568], [-122.07298, 37.09587], [-122.07282, 37.09611], [-122.06231, 37.09602], [-122.06222, 37.09358], [-122.07465, 37.09388]]], [[[-122.07657, 37.09618], [-122.07657, 37.09618], [-122.0731, 37.09611], [-122.07328, 37.09589], [-122.07427, 37.09515], [-122.07455, 37.09477], [-122.07476, 37.09435], [-122.07489, 37.09389], [-122.07653, 37.09393], [-122.07657, 37.09618]]]]} | Open Access 1 | Pace Family Wilderness Park | 23289 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 79.548 | Pace Family Wilderness Park | ||
8167 | 8167 | 8166 | {"type": "Polygon", "coordinates": [[[-121.78052, 36.96318], [-121.77845, 36.96386], [-121.77286, 36.96386], [-121.77286, 36.96497], [-121.76765, 36.965], [-121.76763, 36.96507], [-121.76721, 36.96507], [-121.76718, 36.96458], [-121.76511, 36.96457], [-121.76511, 36.96371], [-121.7679, 36.96373], [-121.76868, 36.9632], [-121.76904, 36.96274], [-121.76886, 36.96189], [-121.76851, 36.96134], [-121.768, 36.96075], [-121.7678, 36.96029], [-121.77036, 36.95751], [-121.77174, 36.95749], [-121.77176, 36.95734], [-121.77403, 36.95659], [-121.77841, 36.95854], [-121.7789, 36.95964], [-121.78052, 36.96318]]]} | Open Access 1 | Pinto Lake Park | 23706 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 186.089 | Pinto Lake Park | ||
8217 | 8217 | 8216 | {"type": "Polygon", "coordinates": [[[-121.85845, 36.92895], [-121.85841, 36.9293], [-121.85822, 36.92941], [-121.8581, 36.92954], [-121.85785, 36.92946], [-121.85754, 36.93007], [-121.85696, 36.92982], [-121.85766, 36.92846], [-121.85774, 36.92846], [-121.85765, 36.92869], [-121.85845, 36.92895]]]} | Open Access 1 | Place de Mer Park | 23760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.662 | Place de Mer Park | ||
8288 | 8288 | 8287 | {"type": "MultiPolygon", "coordinates": [[[[-121.8835, 36.97893], [-121.88331, 36.97947], [-121.88316, 36.97975], [-121.88196, 36.98072], [-121.88189, 36.98075], [-121.88181, 36.98077], [-121.88125, 36.98065], [-121.88096, 36.98068], [-121.8807, 36.98079], [-121.88026, 36.98105], [-121.88021, 36.98107], [-121.88013, 36.98106], [-121.87992, 36.98133], [-121.87975, 36.98142], [-121.87919, 36.98229], [-121.87872, 36.98226], [-121.87821, 36.98272], [-121.87793, 36.98253], [-121.87787, 36.98236], [-121.87804, 36.98216], [-121.87789, 36.98198], [-121.87786, 36.98181], [-121.8777, 36.98183], [-121.87745, 36.98209], [-121.87697, 36.98284], [-121.87663, 36.98278], [-121.87654, 36.98282], [-121.87645, 36.9831], [-121.87615, 36.98336], [-121.87587, 36.98373], [-121.87554, 36.98396], [-121.87482, 36.98371], [-121.87456, 36.98364], [-121.87431, 36.98366], [-121.87389, 36.98414], [-121.87344, 36.98398], [-121.87253, 36.98125], [-121.87492, 36.98126], [-121.88113, 36.97826], [-121.88151, 36.97884], [-121.88172, 36.97876], [-121.88212, 36.97864], [-121.88254, 36.9786], [-121.88296, 36.97862], [-121.88337, 36.97873], [-121.88348, 36.97881], [-121.8835, 36.97893]]], [[[-121.88406, 36.97913], [-121.88403, 36.97919], [-121.88359, 36.9791], [-121.88361, 36.97903], [-121.88406, 36.97913]]]]} | Open Access 1 | Polo Grounds Park | 23875 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 61.324 | Polo Grounds Park | ||
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 | ||
8445 | 8445 | 8444 | {"type": "Polygon", "coordinates": [[[-122.06767, 37.07161], [-122.06612, 37.07145], [-122.06525, 37.07244], [-122.06498, 37.0733], [-122.06239, 37.07328], [-122.06241, 37.06957], [-122.06378, 37.06958], [-122.06746, 37.07014], [-122.06767, 37.07161]]]} | Open Access 1 | Quail Hollow Quarry Conservation Areas | 24044 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 34.793 | Quail Hollow Quarry Conservation Areas | ||
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 | ||
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 | ||
9406 | 9406 | 9405 | {"type": "MultiPolygon", "coordinates": [[[[-122.23041, 37.0415], [-122.23027, 37.04144], [-122.22709, 37.03829], [-122.22677, 37.03784], [-122.22648, 37.03724], [-122.22643, 37.03683], [-122.22683, 37.03663], [-122.22746, 37.03681], [-122.22748, 37.0368], [-122.22713, 37.03561], [-122.22819, 37.03545], [-122.2286, 37.03708], [-122.22761, 37.03718], [-122.2276, 37.0372], [-122.22783, 37.03768], [-122.22861, 37.03872], [-122.2296, 37.0396], [-122.22966, 37.03974], [-122.22972, 37.04006], [-122.22978, 37.04028], [-122.22991, 37.04064], [-122.23017, 37.04114], [-122.23041, 37.0415]]], [[[-122.23673, 37.04552], [-122.23579, 37.04621], [-122.23161, 37.04252], [-122.23133, 37.04211], [-122.23249, 37.04226], [-122.23448, 37.04414], [-122.23673, 37.04552]]], [[[-122.24596, 37.05447], [-122.24536, 37.05496], [-122.24437, 37.05386], [-122.24429, 37.0537], [-122.24423, 37.0535], [-122.24406, 37.05334], [-122.24383, 37.05324], [-122.24364, 37.0532], [-122.24351, 37.0531], [-122.24221, 37.05182], [-122.24128, 37.05102], [-122.2411, 37.05077], [-122.24086, 37.05056], [-122.24056, 37.0504], [-122.23732, 37.04755], [-122.23804, 37.04701], [-122.23845, 37.04744], [-122.23884, 37.04766], [-122.23951, 37.04799], [-122.24018, 37.04865], [-122.24066, 37.04934], [-122.24114, 37.04967], [-122.24138, 37.0499], [-122.24208, 37.05043], [-122.24303, 37.05105], [-122.24324, 37.0513], [-122.24347, 37.05148], [-122.24371, 37.05169], [-122.24415, 37.05244], [-122.2443, 37.0528], [-122.2445, 37.0531], [-122.24529, 37.05369], [-122.24596, 37.05447]]]]} | Open Access 1 | Scott Creek Beach County Park | 25202 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 50.647 | Scott Creek Beach County Park | ||
9407 | 9407 | 9406 | {"type": "Polygon", "coordinates": [[[-121.81987, 36.97069], [-121.81931, 36.97091], [-121.81883, 36.97022], [-121.81864, 36.96998], [-121.81841, 36.96978], [-121.81822, 36.96964], [-121.81752, 36.96928], [-121.81814, 36.96853], [-121.81894, 36.96939], [-121.81987, 36.97069]]]} | Open Access 1 | Scott Park | 25203 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 4.267 | Scott Park | ||
9443 | 9443 | 9442 | {"type": "Polygon", "coordinates": [[[-121.87593, 36.94744], [-121.87547, 36.94775], [-121.87484, 36.94762], [-121.87458, 36.94761], [-121.87438, 36.94764], [-121.87414, 36.94784], [-121.87421, 36.948], [-121.87412, 36.94846], [-121.87401, 36.94854], [-121.87273, 36.94732], [-121.87231, 36.94688], [-121.8722, 36.94674], [-121.87472, 36.94532], [-121.87575, 36.94641], [-121.87484, 36.94682], [-121.87485, 36.94684], [-121.87474, 36.94696], [-121.87481, 36.94702], [-121.87478, 36.94716], [-121.87484, 36.94727], [-121.87483, 36.94735], [-121.87497, 36.94735], [-121.87509, 36.94731], [-121.87541, 36.94707], [-121.87546, 36.94691], [-121.87558, 36.94706], [-121.87566, 36.94715], [-121.8758, 36.94736], [-121.87593, 36.94744]]]} | Open Access 1 | Seascape Park | 25248 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 13.664 | Seascape Park | ||
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 |
9707 | 9707 | 9706 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96795], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 9.9 | Simpkins Swim Ctr. | ||
10136 | 10136 | 10135 | {"type": "Polygon", "coordinates": [[[-121.82055, 36.87191], [-121.82046, 36.872], [-121.82016, 36.87219], [-121.81982, 36.87232], [-121.81941, 36.87243], [-121.81935, 36.87243], [-121.81931, 36.8724], [-121.81904, 36.87191], [-121.81895, 36.87179], [-121.81886, 36.87168], [-121.81843, 36.87126], [-121.81874, 36.87076], [-121.81887, 36.87049], [-121.81924, 36.87028], [-121.8193, 36.87051], [-121.81938, 36.87127], [-121.81992, 36.87155], [-121.82031, 36.87159], [-121.82055, 36.87191]]]} | Open Access 1 | Sunset State Beach | http://www.parks.ca.gov/?page_id=544 | 26065 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 4.629 | Sunset SB | 1931 |
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]);