units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where DES_TP = 2, MNG_AGENCY = 5 and MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Cruz, County of · 33 ✖
DES_TP 1
- Local Park · 33 ✖
ACCESS_TYP 1
- Open Access 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339 | 339 | 338 | {"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 | 932 | Soquel Lions Park | 25623 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.38 | Soquel Lions Park | 0 | Local Park 2 | 4 | |
7 | 7 | 6 | {"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 | 28 | Richard Vessey Park | 24328 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.46 | Richard Vessey Park | 0 | Local Park 2 | 4 | |
3080 | 3080 | 3079 | {"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 | 25004 | Lions Park | 21317 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.517 | Lions Park | 0 | Local Park 2 | 4 | |
2279 | 2279 | 2278 | {"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 | 16844 | Hestwood Park | 19885 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.588 | Hestwood Park | 0 | Local Park 2 | 4 | |
5744 | 5744 | 5743 | {"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.96958], [-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 | 3076 | Capitola Beach | 16838 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.609 | Capitola Beach | 0 | Local Park 2 | 4 | |
2101 | 2101 | 2100 | {"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 | 15870 | Floral Park | 18959 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.934 | Floral Park | 0 | Local Park 2 | 4 | |
6314 | 6314 | 6313 | {"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 | 1487 | Twin Lakes Park | 26617 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.416 | Twin Lakes Park | 0 | Local Park 2 | 4 | |
425 | 425 | 424 | {"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 | 1674 | Valencia Hall Park | 26761 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.476 | Valencia Hall Park | 0 | Local Park 2 | 4 | |
201 | 201 | 200 | {"type": "Polygon", "coordinates": [[[-121.97829, 37.0053], [-121.97809, 37.00576], [-121.97787, 37.00575], [-121.97787, 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 | 539 | Santa Cruz Gardens Park | 25063 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.786 | Santa Cruz Gardens Park | 0 | Local Park 2 | 4 | |
2692 | 2692 | 2691 | {"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.09228, 37.08886], [-122.09149, 37.08889], [-122.09142, 37.08887], [-122.09137, 37.08877], [-122.09012, 37.08881], [-122.09009, 37.08845], [-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.09038, 37.08844], [-122.09039, 37.08849], [-122.09058, 37.08852], [-122.09111, 37.08856], [-122.09112, 37.08855], [-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 | 17802 | Ben Lomond Park | 16002 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.953 | Ben Lomond Park | 0 | Local Park 2 | 4 | |
10146 | 10146 | 10145 | {"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 | 17782 | Mesa Village Park | 22182 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.066 | Mesa Village Park | 0 | Local Park 2 | 4 | |
5049 | 5049 | 5048 | {"type": "Polygon", "coordinates": [[[-121.93328, 36.98717], [-121.93307, 36.98817], [-121.93247, 36.98809], [-121.93248, 36.98801], [-121.93215, 36.98797], [-121.93234, 36.98705], [-121.93328, 36.98717]]]} | Open Access 1 | 1909 | Willowbrook Park | 27589 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.3 | Willowbrook Park | 0 | Local Park 2 | 4 | |
9854 | 9854 | 9853 | {"type": "MultiPolygon", "coordinates": [[[[-121.88803, 36.96112], [-121.8874, 36.96143], [-121.88725, 36.96128], [-121.88734, 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.95749], [-121.88863, 36.95674], [-121.88865, 36.95676]]]]} | Open Access 1 | 16866 | Hidden Beach Park | 19902 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.424 | Hidden Beach Park | 0 | Local Park 2 | 4 | |
10497 | 10497 | 10496 | {"type": "Polygon", "coordinates": [[[-121.85845, 36.92895], [-121.85841, 36.9293], [-121.85822, 36.92941], [-121.8581, 36.92954], [-121.85786, 36.92946], [-121.85754, 36.93007], [-121.85696, 36.92982], [-121.85766, 36.92846], [-121.8577, 36.92845], [-121.85774, 36.92846], [-121.85764, 36.92869], [-121.85845, 36.92895]]]} | Open Access 1 | 18621 | Place de Mer Park | 23760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.659 | Place de Mer Park | 0 | Local Park 2 | 4 | |
1357 | 1357 | 1356 | {"type": "Polygon", "coordinates": [[[-121.9737, 36.9789], [-121.97373, 36.97903], [-121.97373, 36.97947], [-121.97365, 36.97963], [-121.97249, 36.97967], [-121.97247, 36.97939], [-121.97093, 36.97945], [-121.97096, 36.97932], [-121.97243, 36.97925], [-121.97242, 36.97895], [-121.9737, 36.9789]]]} | Open Access 1 | 7881 | Coffee Lane Park | 17475 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.75 | Coffee Lane Park | 0 | Local Park 2 | 4 | |
6135 | 6135 | 6134 | {"type": "Polygon", "coordinates": [[[-121.81009, 36.98721], [-121.80994, 36.98711], [-121.80897, 36.98712], [-121.80907, 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.80828, 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 | 1127 | Aldridge Lane Park | 15351 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 3.265 | Aldridge Lane Park | 0 | Local Park 2 | 4 | |
216 | 216 | 215 | {"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 | 691 | Scott Park | 25203 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 4.268 | Scott Park | 0 | Local Park 2 | 4 | |
1846 | 1846 | 1845 | {"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 | 15786 | Felton Covered Bridge Park | 18870 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 5.596 | Felton Covered Bridge Park | 0 | Local Park 2 | 4 | |
9927 | 9927 | 9926 | {"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.97556], [-121.9899, 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.99007, 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 | 17068 | Jose Avenue Park | 20491 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 5.839 | Jose Avenue Park | 0 | Local Park 2 | 4 | |
6433 | 6433 | 6432 | {"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.99054], [-121.97583, 36.9896], [-121.97728, 36.98977]]]} | Open Access 1 | 1956 | Winkle Farm Park | 27647 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 6.402 | Winkle Farm Park | 0 | Local Park 2 | 4 |
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]);