units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 5 and MNG_AG_LEV = 3 sorted by PARK_URL 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2868 | 2868 | 2867 | {"type": "Polygon", "coordinates": [[[-122.06456, 37.08051], [-122.06575, 37.08186], [-122.06516, 37.08188], [-122.06511, 37.08397], [-122.06795, 37.08404], [-122.06788, 37.08414], [-122.06787, 37.08425], [-122.06814, 37.08465], [-122.06759, 37.08465], [-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.08555], [-122.06005, 37.07987], [-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]]]} | Open Access 1 | 18850 | Quail Hollow Ranch Park | 12092 | 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/quail_hollow.html | Santa Cruz 5 | 227.323 | Quail Hollow Ranch Park | 0 | Local Park 2 | 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 |
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 | ||
10113 | 10113 | 10112 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92118], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | 17544 | Manresa State Beach Access | 21760 | 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=545 | Santa Cruz 5 | 0.136 | Manresa SB Access | 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 | |
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 | |
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 | |
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 | |
2293 | 2293 | 2292 | {"type": "Polygon", "coordinates": [[[-122.08447, 37.08129], [-122.08267, 37.08185], [-122.08229, 37.08166], [-122.08161, 37.08221], [-122.0806, 37.08182], [-122.0801, 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 | 16891 | Highland Park | 19931 | 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 | 25.586 | Highland Park | 0 | Local Park 2 | 4 | |
2608 | 2608 | 2607 | {"type": "MultiPolygon", "coordinates": [[[[-121.97832, 36.95705], [-121.97828, 36.95709], [-121.9783, 36.95711], [-121.97787, 36.95759], [-121.97783, 36.95757], [-121.97775, 36.95765], [-121.97718, 36.95745], [-121.97667, 36.9574], [-121.97609, 36.95755], [-121.97595, 36.95809], [-121.97577, 36.9583], [-121.97571, 36.95895], [-121.97546, 36.95939], [-121.97509, 36.95967], [-121.97488, 36.95987], [-121.97474, 36.95987], [-121.97499, 36.95918], [-121.97528, 36.95862], [-121.97554, 36.95745], [-121.9757, 36.95715], [-121.97617, 36.9566], [-121.97634, 36.95646], [-121.97646, 36.95645], [-121.97691, 36.95656], [-121.97758, 36.95608], [-121.97784, 36.95626], [-121.97797, 36.95666], [-121.97791, 36.95672], [-121.97828, 36.95698], [-121.97832, 36.95705]]], [[[-121.97827, 36.95625], [-121.97813, 36.95638], [-121.97809, 36.95638], [-121.97801, 36.95612], [-121.97812, 36.95614], [-121.97827, 36.95625]]]]} | Open Access 1 | 17987 | Moran Lake Park | 22471 | 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 | 8.942 | Moran Lake 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]);