units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where AGNCY_TYP = 3 and MNG_AGENCY = 5 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 10
- Local Park 33
- Local Recreation Area 5
- Local Other or Unknown 4
- Local Conservation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Cruz, County of · 51 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
4473 | 4473 | 4472 | {"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.95613], [-121.97105, 36.95599], [-121.9711, 36.95587], [-121.97115, 36.95582], [-121.97122, 36.95566], [-121.97128, 36.95558], [-121.9715, 36.95551], [-121.97151, 36.95549], [-121.97172, 36.95544], [-121.97193, 36.95527], [-121.97196, 36.9553], [-121.97173, 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.97264, 36.95469], [-121.97275, 36.95462], [-121.97288, 36.95459], [-121.97305, 36.95462], [-121.97324, 36.95471], [-121.97325, 36.95473]]]]} | Open Access 1 | 1619 | Unnamed site - Santa Cruz, County of | 28666 | 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.964 | 0 | Local Other or Unknown 14 | 4 | ||
15469 | 15469 | 15468 | {"type": "Polygon", "coordinates": [[[-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 | 36562 | Unnamed site - Santa Cruz, County of | 28666 | 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.486 | 0 | Local Other or Unknown 14 | 4 | ||
4577 | 4577 | 4576 | {"type": "Polygon", "coordinates": [[[-121.85444, 36.9225], [-121.85412, 36.92319], [-121.85376, 36.92307], [-121.85374, 36.9231], [-121.85269, 36.92275], [-121.85271, 36.92271], [-121.85333, 36.92292], [-121.85334, 36.92288], [-121.85364, 36.92288], [-121.85392, 36.92281], [-121.85385, 36.92265], [-121.85379, 36.92263], [-121.85393, 36.92259], [-121.8539, 36.92263], [-121.85399, 36.92279], [-121.85421, 36.92268], [-121.85444, 36.9225]]]} | Open Access 1 | 35238 | Unknown park - Santa Cruz, County of | 28665 | 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.741 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
6125 | 6125 | 6124 | {"type": "MultiPolygon", "coordinates": [[[[-121.9654, 36.95968], [-121.96527, 36.95978], [-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 | 1336 | The Hook Beach Access | 26285 | 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.827 | The Hook Beach Access | 0 | Local Recreation Area 3 | 4 | |
17031 | 17031 | 17030 | {"type": "Polygon", "coordinates": [[[-121.94388, 36.98798], [-121.94332, 36.99061], [-121.94267, 36.99058], [-121.94267, 36.99056], [-121.94276, 36.99045], [-121.94269, 36.99022], [-121.94259, 36.99013], [-121.94264, 36.98993], [-121.94279, 36.98973], [-121.9428, 36.98959], [-121.94286, 36.98949], [-121.94287, 36.98945], [-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 | 48177 | The Farm Park & Community Center | 32712 | 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 | http://www.scparks.com/Home/Parks/TheFarmPark-CommunityMeetings.aspx | Santa Cruz 5 | 5.534 | The Farm Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
6210 | 6210 | 6209 | {"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 | 1259 | Sunset State Beach | 26065 | 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 | http://www.parks.ca.gov/?page_id=544 | Santa Cruz 5 | 4.627 | Sunset SB | 1931 | None 502 | |
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 | |
414 | 414 | 413 | {"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.96794], [-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 | 830 | Simpkins Swim Center | 25513 | 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 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
6033 | 6033 | 6032 | {"type": "Polygon", "coordinates": [[[-121.87593, 36.94744], [-121.87547, 36.94775], [-121.87485, 36.94762], [-121.87457, 36.94761], [-121.87438, 36.94764], [-121.87413, 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.87477, 36.94716], [-121.87484, 36.94727], [-121.87482, 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 | 727 | Seascape Park | 25248 | 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.659 | Seascape Park | 0 | Local Park 2 | 4 | |
6363 | 6363 | 6362 | {"type": "Polygon", "coordinates": [[[-121.9128, 36.9767], [-121.91215, 36.97675], [-121.91216, 36.97584], [-121.91275, 36.97583], [-121.91271, 36.97616], [-121.9128, 36.9767]]]} | Open Access 1 | 48892 | Seacliff Village Park (McGregor) | 33609 | 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 | http://www.scparks.com/Home/Parks/ListofAllCountyParks.aspx | Santa Cruz 5 | 1.282 | Seacliff Village Park (McGregor) | None 516 | ||
6034 | 6034 | 6033 | {"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 | 720 | Seacliff State Beach | 25238 | 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 | http://www.parks.ca.gov/?page_id=543 | Santa Cruz 5 | 0.249 | Seacliff SB | 1931 | None 487 | |
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 | |
6014 | 6014 | 6013 | {"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.24111, 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 | 669 | Scott Creek Beach County Park | 25202 | 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 | 50.646 | Scott Creek Beach County 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 | |
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 |
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]);