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 GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
782 | 782 | 781 | {"type": "Polygon", "coordinates": [[[-122.14918, 37.24376], [-122.14913, 37.24377], [-122.14907, 37.24375], [-122.14904, 37.24355], [-122.14916, 37.24355], [-122.14915, 37.24358], [-122.14919, 37.2437], [-122.14918, 37.24376]]]} | Open Access 1 | 5057 | Castle Rock State Park | 16955 | 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=538 | Santa Cruz 5 | 0.063 | Castle Rock SP | 1968 | None 72 | |
5638 | 5638 | 5637 | {"type": "Polygon", "coordinates": [[[-122.06767, 37.07161], [-122.06612, 37.07145], [-122.06525, 37.07244], [-122.06498, 37.0733], [-122.06239, 37.07328], [-122.06241, 37.06957], [-122.06378, 37.06958], [-122.06746, 37.07014], [-122.06767, 37.07161]]]} | Open Access 1 | 29800 | Quail Hollow Quarry Conservation Areas | 24044 | 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 | 34.79 | Quail Hollow Quarry Conservation Areas | None 456 | |||
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 | |
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 | |
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 | ||
10310 | 10310 | 10309 | {"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 | 18353 | Pajaro River | 28154 | 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.421 | Pajaro River | None 901 | |||
9135 | 9135 | 9134 | {"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 | 16765 | Harkins Slough | 28149 | 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 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
9698 | 9698 | 9697 | {"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.9109], [-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.81264, 36.91331], [-121.81191, 36.9127], [-121.81154, 36.9117], [-121.81148, 36.91147], [-121.81215, 36.91259], [-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.8177, 36.91562], [-121.8183, 36.91574], [-121.81892, 36.91578], [-121.81954, 36.91574], [-121.82052, 36.91553], [-121.8208, 36.91677]]]]} | Restricted Access 2 | 16385 | Gallighan Slough | 28152 | 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 | 41.877 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
9887 | 9887 | 9886 | {"type": "MultiPolygon", "coordinates": [[[[-122.07465, 37.09388], [-122.07452, 37.0943], [-122.07432, 37.0947], [-122.07404, 37.09507], [-122.07345, 37.09551], [-122.07319, 37.09568], [-122.07298, 37.09588], [-122.07282, 37.09611], [-122.06231, 37.09602], [-122.06222, 37.09358], [-122.07465, 37.09388]]], [[[-122.07657, 37.09618], [-122.0732, 37.09611], [-122.0731, 37.09611], [-122.07328, 37.09589], [-122.07427, 37.09516], [-122.07455, 37.09477], [-122.07476, 37.09435], [-122.07489, 37.09389], [-122.07653, 37.09393], [-122.07657, 37.09618]]]]} | Open Access 1 | 18330 | Pace Family Wilderness Park | 23289 | 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 | 79.551 | Pace Family Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
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 | |
144 | 144 | 143 | {"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.97438, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} | Open Access 1 | 363 | Brommer Park | 16416 | 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 | 7.663 | Brommer 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);