units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where AGNCY_TYP = 3, DES_TP = 2 and MNG_AGENCY = 5
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Cruz, County of · 13 ✖
DES_TP 1
- Local Park · 13 ✖
ACCESS_TYP 1
- Open Access 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6294 | 6294 | 6293 | {"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.88266, 36.9536], [-121.88261, 36.95352], [-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 | 1412 | Trestle at Hidden Beach | 26524 | 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 | 13.189 | Trestle at Hidden Beach | 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 | |
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 | |
8423 | 8423 | 8422 | {"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.96285, 36.99402], [-121.96285, 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.96139, 36.98912], [-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.96478, 36.9936], [-121.96911, 36.99374]]]} | Open Access 1 | 13052 | Anna Jean Cummings Park | 15503 | 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 | 95.411 | Anna Jean Cummings Park | 0 | Local Park 2 | 4 | |
8578 | 8578 | 8577 | {"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.90345, 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.90211, 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.90448, 36.97926], [-121.90426, 36.97969], [-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.98034], [-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.90385, 36.97865], [-121.90359, 36.97852], [-121.90359, 36.97849], [-121.90346, 36.9784], [-121.90303, 36.97822], [-121.90278, 36.97807], [-121.90277, 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.90381, 36.97671], [-121.90375, 36.97664], [-121.90393, 36.97654], [-121.90398, 36.97662], [-121.90399, 36.97708], [-121.90452, 36.97704], [-121.90494, 36.97742]]]]} | Open Access 1 | 13614 | Aptos Village Park | 15547 | 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 | 14.362 | Aptos Village Park | 0 | Local Park 2 | 4 | |
9578 | 9578 | 9577 | {"type": "Polygon", "coordinates": [[[-121.81821, 36.96834], [-121.81746, 36.96925], [-121.81626, 36.96864], [-121.81428, 36.96715], [-121.81317, 36.96655], [-121.81352, 36.96634], [-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.81406, 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 | 16108 | Freedom Lake Park | 19082 | 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 | 33.981 | Freedom Lake 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 | |
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 | |
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 | |
10210 | 10210 | 10209 | {"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.9723], [-121.8174, 36.9724], [-121.81753, 36.97247], [-121.81777, 36.9725], [-121.81817, 36.97252], [-121.81837, 36.97245], [-121.81846, 36.97233], [-121.81851, 36.9722], [-121.81858, 36.97178], [-121.81871, 36.97143], [-121.81877, 36.97133], [-121.81885, 36.97126], [-121.8192, 36.97109], [-121.81943, 36.97142], [-121.81996, 36.97239], [-121.82016, 36.97266], [-121.82041, 36.97289], [-121.82055, 36.97299]]]} | Open Access 1 | 17847 | Bert Scott Estate Park | 16037 | 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 | 32.194 | Bert Scott Estate Park | 0 | Local Park 2 | 4 | |
10478 | 10478 | 10477 | {"type": "Polygon", "coordinates": [[[-121.78052, 36.96318], [-121.77845, 36.96386], [-121.77285, 36.96386], [-121.77286, 36.96497], [-121.76764, 36.965], [-121.76763, 36.96507], [-121.76721, 36.96507], [-121.76719, 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.77175, 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 | 18562 | Pinto Lake Park | 23706 | 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 | 186.068 | Pinto Lake 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 | |
10543 | 10543 | 10542 | {"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.88071, 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.87805, 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 | 18757 | Polo Grounds Park | 23875 | 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 | 61.312 | Polo Grounds 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]);