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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
14281 | 14281 | 14280 | {"type": "MultiPolygon", "coordinates": [[[[-121.97217, 36.95571], [-121.97161, 36.95571], [-121.97067, 36.95684], [-121.96972, 36.95745], [-121.96972, 36.9572], [-121.96985, 36.95709], [-121.97002, 36.95701], [-121.97017, 36.95688], [-121.97046, 36.95667], [-121.97057, 36.95657], [-121.97068, 36.9564], [-121.97079, 36.9563], [-121.9709, 36.95612], [-121.97105, 36.95599], [-121.9711, 36.95587], [-121.97115, 36.95582], [-121.97122, 36.95566], [-121.97128, 36.95558], [-121.97149, 36.95551], [-121.97151, 36.95549], [-121.97172, 36.95544], [-121.97193, 36.95527], [-121.97196, 36.9553], [-121.97174, 36.9555], [-121.97217, 36.9556], [-121.97217, 36.95571]]], [[[-121.97325, 36.95473], [-121.97294, 36.95463], [-121.97273, 36.95464], [-121.97267, 36.95471], [-121.97265, 36.95471], [-121.97265, 36.95469], [-121.97275, 36.95462], [-121.97288, 36.95459], [-121.97305, 36.95462], [-121.97324, 36.95471], [-121.97325, 36.95473]]], [[[-121.98479, 36.95999], [-121.98474, 36.96002], [-121.98461, 36.96034], [-121.98443, 36.96068], [-121.98393, 36.96052], [-121.98353, 36.96036], [-121.98386, 36.96002], [-121.98431, 36.95983], [-121.98479, 36.95999]]]]} | Open Access 1 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 3.457 | |||
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) | |
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 | ||
11607 | 11607 | 11606 | {"type": "MultiPolygon", "coordinates": [[[[-121.81062, 36.91], [-121.81032, 36.90991], [-121.81001, 36.91005], [-121.80937, 36.91143], [-121.80919, 36.91137], [-121.8094, 36.91089], [-121.80963, 36.91001], [-121.80983, 36.90957], [-121.80981, 36.90862], [-121.81062, 36.91]]], [[[-121.8208, 36.91677], [-121.81946, 36.91684], [-121.8184, 36.91715], [-121.81784, 36.91788], [-121.81749, 36.91791], [-121.81589, 36.91711], [-121.81536, 36.91645], [-121.8149, 36.91595], [-121.81467, 36.91595], [-121.81398, 36.91524], [-121.81265, 36.91331], [-121.81191, 36.9127], [-121.81154, 36.9117], [-121.81148, 36.91147], [-121.81215, 36.91258], [-121.81332, 36.91179], [-121.8138, 36.91263], [-121.81399, 36.91289], [-121.81422, 36.91312], [-121.81616, 36.91481], [-121.81662, 36.91515], [-121.81714, 36.91542], [-121.81771, 36.91562], [-121.81831, 36.91574], [-121.81892, 36.91578], [-121.81954, 36.91574], [-121.82052, 36.91553], [-121.8208, 36.91677]]]]} | Restricted Access 2 | Gallighan Slough | 28152 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 41.893 | Gallighan Slough | ||
11603 | 11603 | 11602 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 20.479 | Harkins Slough | ||
11337 | 11337 | 11336 | {"type": "Polygon", "coordinates": [[[-121.97728, 36.98977], [-121.97688, 36.99123], [-121.97544, 36.99106], [-121.97541, 36.9911], [-121.97467, 36.99101], [-121.97477, 36.99045], [-121.97558, 36.99053], [-121.97583, 36.9896], [-121.97728, 36.98977]]]} | Open Access 1 | Winkle Farm Park | 27647 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 6.408 | Winkle Farm 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 | ||
10455 | 10455 | 10454 | {"type": "Polygon", "coordinates": [[[-121.88394, 36.95303], [-121.88313, 36.95362], [-121.88287, 36.95358], [-121.8827, 36.95365], [-121.88262, 36.95372], [-121.88258, 36.95366], [-121.88265, 36.9536], [-121.88261, 36.95353], [-121.88252, 36.95344], [-121.88226, 36.95327], [-121.8822, 36.95312], [-121.88213, 36.95301], [-121.88208, 36.95296], [-121.88204, 36.95296], [-121.88197, 36.953], [-121.88177, 36.95321], [-121.88167, 36.95333], [-121.8814, 36.95338], [-121.88133, 36.95337], [-121.8812, 36.95342], [-121.88084, 36.95385], [-121.88068, 36.95396], [-121.88056, 36.95393], [-121.8804, 36.95374], [-121.88026, 36.95366], [-121.87994, 36.95365], [-121.87969, 36.95371], [-121.87941, 36.95324], [-121.87926, 36.95315], [-121.87947, 36.95303], [-121.87986, 36.95273], [-121.88001, 36.95249], [-121.881, 36.95231], [-121.88219, 36.95156], [-121.88394, 36.95303]]]} | Open Access 1 | Trestle at Hidden Beach | 26524 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 13.191 | Trestle at Hidden Beach | ||
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 | ||
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 |
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. | ||
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 |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);