superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where AGNCY_WEB = "http://www.scparks.com/" and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
763 | 763 | 762 | {"type": "Polygon", "coordinates": [[[-121.94388, 36.98798], [-121.94332, 36.99061], [-121.94267, 36.99058], [-121.94267, 36.99056], [-121.94275, 36.99044], [-121.94269, 36.99023], [-121.94259, 36.99013], [-121.94264, 36.98993], [-121.94279, 36.98973], [-121.9428, 36.98959], [-121.94287, 36.98946], [-121.94242, 36.98943], [-121.94249, 36.98922], [-121.94269, 36.98889], [-121.94279, 36.98867], [-121.94289, 36.98833], [-121.94293, 36.98807], [-121.94297, 36.98802], [-121.94302, 36.98799], [-121.9433, 36.98804], [-121.94345, 36.98801], [-121.94346, 36.98799], [-121.94388, 36.98798]]]} | Open Access 1 | The Farm Park & Community Center | http://www.scparks.com/Home/Parks/TheFarmPark-CommunityMeetings.aspx | 32712 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 5.54 | The Farm Park & Community Ctr. | |
1031 | 1031 | 1030 | {"type": "Polygon", "coordinates": [[[-121.81009, 36.98721], [-121.80994, 36.98711], [-121.80898, 36.98712], [-121.80908, 36.98747], [-121.80915, 36.98801], [-121.80804, 36.98783], [-121.80804, 36.98741], [-121.80794, 36.98713], [-121.80693, 36.98714], [-121.80692, 36.98712], [-121.80827, 36.9871], [-121.8081, 36.98657], [-121.80874, 36.98643], [-121.80896, 36.98709], [-121.81004, 36.98708], [-121.81009, 36.98721]]]} | Open Access 1 | Aldridge Lane Park | 15351 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 3.284 | Aldridge Lane Park | ||
1041 | 1041 | 1040 | {"type": "Polygon", "coordinates": [[[-122.06814, 37.08465], [-122.06758, 37.08466], [-122.06753, 37.08556], [-122.06777, 37.08559], [-122.0675, 37.09096], [-122.0622, 37.09094], [-122.05739, 37.09066], [-122.05741, 37.08554], [-122.06002, 37.08554], [-122.06005, 37.07988], [-122.0576, 37.07982], [-122.05766, 37.07656], [-122.05927, 37.07841], [-122.06113, 37.07958], [-122.06188, 37.07978], [-122.06215, 37.07992], [-122.06335, 37.0792], [-122.06456, 37.08051], [-122.06575, 37.08186], [-122.06516, 37.08189], [-122.06512, 37.08397], [-122.06795, 37.08404], [-122.06788, 37.08414], [-122.06787, 37.08425], [-122.06814, 37.08465]]]} | Open Access 1 | Quail Hollow Ranch Park | http://www.scparks.com/quail_hollow.html | 12092 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 227.414 | Quail Hollow Ranch Park | |
1508 | 1508 | 1507 | {"type": "Polygon", "coordinates": [[[-121.96911, 36.99374], [-121.96911, 36.9956], [-121.96692, 36.99562], [-121.96309, 36.99562], [-121.96246, 36.9956], [-121.96244, 36.99562], [-121.95684, 36.99562], [-121.95676, 36.99559], [-121.95674, 36.99553], [-121.95703, 36.99446], [-121.95713, 36.99403], [-121.96284, 36.99402], [-121.96284, 36.99302], [-121.96101, 36.99209], [-121.9608, 36.99165], [-121.9608, 36.99137], [-121.96112, 36.99083], [-121.96101, 36.99058], [-121.96049, 36.99024], [-121.96035, 36.98998], [-121.96042, 36.9898], [-121.96029, 36.98928], [-121.96046, 36.98905], [-121.96138, 36.98911], [-121.9614, 36.98894], [-121.962, 36.98898], [-121.96253, 36.98888], [-121.96344, 36.98837], [-121.9639, 36.98815], [-121.96463, 36.98842], [-121.96479, 36.99359], [-121.96911, 36.99374]]]} | Open Access 1 | Anna Jean Cummings Park | 15503 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 95.474 | Anna Jean Cummings Park | ||
1528 | 1528 | 1527 | {"type": "MultiPolygon", "coordinates": [[[[-121.9012, 36.97535], [-121.90104, 36.97554], [-121.9009, 36.97565], [-121.90022, 36.97565], [-121.9, 36.97562], [-121.89997, 36.97558], [-121.89973, 36.97546], [-121.89978, 36.97517], [-121.90053, 36.97515], [-121.90119, 36.97534], [-121.9012, 36.97535]]], [[[-121.90391, 36.97622], [-121.90364, 36.97625], [-121.90357, 36.9762], [-121.90346, 36.97617], [-121.90284, 36.97609], [-121.9025, 36.97598], [-121.90204, 36.97598], [-121.90206, 36.97594], [-121.90199, 36.97591], [-121.90206, 36.97533], [-121.90205, 36.97559], [-121.90212, 36.97585], [-121.90219, 36.97584], [-121.90231, 36.97592], [-121.90246, 36.97591], [-121.9026, 36.97592], [-121.90263, 36.97583], [-121.90276, 36.97582], [-121.9032, 36.97591], [-121.90382, 36.97612], [-121.90391, 36.97622]]], [[[-121.90494, 36.97742], [-121.90501, 36.97777], [-121.90491, 36.97835], [-121.90452, 36.97864], [-121.90473, 36.97891], [-121.90466, 36.97907], [-121.90447, 36.97926], [-121.90426, 36.9797], [-121.90428, 36.98012], [-121.90472, 36.9802], [-121.90476, 36.98033], [-121.90457, 36.98062], [-121.90442, 36.98093], [-121.90434, 36.98123], [-121.90412, 36.98134], [-121.90415, 36.98094], [-121.90432, 36.98035], [-121.9041, 36.98031], [-121.90404, 36.98008], [-121.90367, 36.97979], [-121.9036, 36.97965], [-121.90358, 36.97936], [-121.90366, 36.97924], [-121.90361, 36.979], [-121.90384, 36.97865], [-121.90359, 36.97852], [-121.90359, 36.97849], [-121.90346, 36.9784], [-121.90303, 36.97822], [-121.90278, 36.97808], [-121.90278, 36.97809], [-121.90296, 36.97834], [-121.90299, 36.97854], [-121.90288, 36.97856], [-121.90286, 36.97847], [-121.90276, 36.97827], [-121.90259, 36.97804], [-121.9025, 36.97783], [-121.9025, 36.97762], [-121.90257, 36.97739], [-121.90268, 36.97731], [-121.90277, 36.97721], [-121.90309, 36.97701], [-121.9038, 36.97673], [-121.9038, 36.97671], [-121.90375, 36.97664], [-121.90393, 36.97654], [-121.90398, 36.97662], [-121.904, 36.97708], [-121.90452, 36.97704], [-121.90494, 36.97742]]]]} | Open Access 1 | Aptos Village Park | 15547 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 14.382 | Aptos Village 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 | ||
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 | ||
1973 | 1973 | 1972 | {"type": "Polygon", "coordinates": [[[-121.82055, 36.97299], [-121.81716, 36.97618], [-121.81662, 36.97634], [-121.81537, 36.97315], [-121.81532, 36.97306], [-121.81525, 36.97298], [-121.81716, 36.97213], [-121.81729, 36.97229], [-121.8174, 36.9724], [-121.81753, 36.97247], [-121.81777, 36.9725], [-121.81817, 36.97252], [-121.81837, 36.97245], [-121.81847, 36.97233], [-121.81851, 36.9722], [-121.81858, 36.97178], [-121.81871, 36.97142], [-121.81877, 36.97134], [-121.81885, 36.97126], [-121.8192, 36.97109], [-121.81943, 36.97142], [-121.81996, 36.9724], [-121.82016, 36.97266], [-121.82041, 36.97289], [-121.82055, 36.97299]]]} | Open Access 1 | Bert Scott Estate Park | 16037 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 32.194 | Bert Scott Estate Park | ||
2274 | 2274 | 2273 | {"type": "Polygon", "coordinates": [[[-121.97587, 36.97007], [-121.9757, 36.97077], [-121.97566, 36.97132], [-121.97552, 36.9716], [-121.97389, 36.9716], [-121.97365, 36.97101], [-121.9733, 36.97101], [-121.97331, 36.97038], [-121.97437, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} | Open Access 1 | Brommer Park | 16416 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 7.664 | Brommer Park | ||
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 |
3046 | 3046 | 3045 | {"type": "Polygon", "coordinates": [[[-121.9737, 36.9789], [-121.97373, 36.97903], [-121.97373, 36.97947], [-121.97365, 36.97963], [-121.97249, 36.97967], [-121.97246, 36.97939], [-121.97093, 36.97945], [-121.97096, 36.97932], [-121.97242, 36.97925], [-121.97242, 36.97895], [-121.9737, 36.9789]]]} | Open Access 1 | Coffee Lane Park | 17475 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 2.756 | Coffee Lane Park | ||
3508 | 3508 | 3507 | {"type": "Polygon", "coordinates": [[[-121.81821, 36.96834], [-121.81746, 36.96925], [-121.81626, 36.96864], [-121.81428, 36.96715], [-121.81317, 36.96654], [-121.81351, 36.96633], [-121.81165, 36.96381], [-121.81156, 36.96376], [-121.81185, 36.96359], [-121.81206, 36.96375], [-121.813, 36.96409], [-121.8131, 36.96396], [-121.81321, 36.96377], [-121.81341, 36.96282], [-121.8137, 36.96248], [-121.8144, 36.96281], [-121.81472, 36.96425], [-121.81458, 36.96441], [-121.81407, 36.96461], [-121.81406, 36.96462], [-121.81425, 36.96484], [-121.81452, 36.96497], [-121.81487, 36.96499], [-121.815, 36.96501], [-121.81681, 36.96701], [-121.81723, 36.96731], [-121.81718, 36.96772], [-121.81821, 36.96834]]]} | Open Access 1 | Freedom Lake Park | 19082 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 33.992 | Freedom Lake Park | ||
4203 | 4203 | 4202 | {"type": "Polygon", "coordinates": [[[-122.07213, 37.05232], [-122.07202, 37.05234], [-122.07061, 37.05188], [-122.06936, 37.05156], [-122.06955, 37.05119], [-122.06989, 37.05114], [-122.07065, 37.05095], [-122.07126, 37.05071], [-122.07141, 37.05075], [-122.07159, 37.05093], [-122.07213, 37.05232]]]} | Open Access 1 | Felton Covered Bridge Park | 18870 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 5.596 | Felton Covered Bridge Park | ||
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 | ||
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 | ||
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 | ||
5127 | 5127 | 5126 | {"type": "Polygon", "coordinates": [[[-122.08447, 37.08129], [-122.08267, 37.08185], [-122.08229, 37.08166], [-122.08161, 37.08221], [-122.0806, 37.08182], [-122.08011, 37.08182], [-122.07978, 37.08175], [-122.07979, 37.08108], [-122.07892, 37.08061], [-122.07893, 37.08031], [-122.07917, 37.08], [-122.07986, 37.07971], [-122.08017, 37.0795], [-122.08045, 37.07977], [-122.0815, 37.07968], [-122.0816, 37.07953], [-122.08169, 37.07949], [-122.08201, 37.07942], [-122.08222, 37.07931], [-122.0828, 37.07895], [-122.08312, 37.07895], [-122.0836, 37.07989], [-122.08377, 37.08028], [-122.08406, 37.08086], [-122.0842, 37.08104], [-122.08429, 37.08114], [-122.08447, 37.08129]]]} | Open Access 1 | Highland Park | 19931 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 25.593 | Highland Park | ||
5603 | 5603 | 5602 | {"type": "Polygon", "coordinates": [[[-121.99187, 36.9749], [-121.99092, 36.97662], [-121.99045, 36.97644], [-121.99045, 36.97637], [-121.99042, 36.97632], [-121.99082, 36.97555], [-121.98991, 36.97523], [-121.98986, 36.97527], [-121.9895, 36.97539], [-121.98912, 36.97532], [-121.98942, 36.97511], [-121.98952, 36.97507], [-121.9896, 36.97494], [-121.99006, 36.97503], [-121.99003, 36.97493], [-121.99018, 36.97471], [-121.99049, 36.97461], [-121.99079, 36.9743], [-121.99187, 36.9749]]]} | Open Access 1 | Jose Avenue Park | 20491 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 5.852 | Jose Avenue 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 | ||
5902 | 5902 | 5901 | {"type": "MultiPolygon", "coordinates": [[[[-122.12695, 37.15886], [-122.12688, 37.15908], [-122.12693, 37.15949], [-122.12686, 37.1596], [-122.12676, 37.15972], [-122.12663, 37.15982], [-122.12646, 37.15991], [-122.12603, 37.16008], [-122.12577, 37.16023], [-122.12556, 37.16043], [-122.12542, 37.16067], [-122.12536, 37.16093], [-122.12534, 37.16109], [-122.1253, 37.16125], [-122.12469, 37.16238], [-122.12442, 37.16276], [-122.12403, 37.16305], [-122.12382, 37.16312], [-122.12368, 37.16339], [-122.12366, 37.16406], [-122.12331, 37.16443], [-122.12297, 37.16475], [-122.12282, 37.16546], [-122.11806, 37.16587], [-122.11653, 37.16016], [-122.11657, 37.15906], [-122.12571, 37.15915], [-122.12695, 37.15886]]], [[[-122.13103, 37.16474], [-122.13043, 37.16479], [-122.12301, 37.16544], [-122.12314, 37.16482], [-122.12374, 37.16422], [-122.12388, 37.164], [-122.12399, 37.16337], [-122.12412, 37.16317], [-122.12456, 37.16284], [-122.12467, 37.16271], [-122.12485, 37.16244], [-122.1251, 37.162], [-122.12546, 37.16129], [-122.1255, 37.16115], [-122.12553, 37.16093], [-122.12561, 37.16064], [-122.12581, 37.16039], [-122.12611, 37.1602], [-122.12648, 37.16009], [-122.1268, 37.15992], [-122.12705, 37.15968], [-122.12714, 37.15952], [-122.12708, 37.15901], [-122.12714, 37.15882], [-122.13035, 37.15808], [-122.13103, 37.16474]]]]} | Open Access 1 | Miller Property County Park | 22248 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 208.729 | Miller Property County 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]);