units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- National Recreation Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,135
- Restricted Access 63
- Unknown Access 36
- No Public Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16308 | 16308 | 16307 | {"type": "MultiPolygon", "coordinates": [[[[-117.0198, 32.82876], [-117.01951, 32.82959], [-117.01936, 32.8301], [-117.01773, 32.83003], [-117.01791, 32.82937], [-117.01801, 32.82935], [-117.01803, 32.82882], [-117.01793, 32.82837], [-117.01781, 32.82808], [-117.01732, 32.82737], [-117.01791, 32.82736], [-117.0198, 32.82876]]], [[[-117.04626, 32.81855], [-117.04598, 32.81888], [-117.04576, 32.81919], [-117.04407, 32.82211], [-117.04113, 32.82749], [-117.04075, 32.82815], [-117.04034, 32.82876], [-117.03996, 32.82928], [-117.03954, 32.82979], [-117.0391, 32.83029], [-117.03793, 32.83145], [-117.03427, 32.83146], [-117.02856, 32.82771], [-117.02747, 32.82882], [-117.02687, 32.82902], [-117.02698, 32.82892], [-117.0266, 32.82839], [-117.02654, 32.82842], [-117.02589, 32.82794], [-117.02548, 32.82847], [-117.02498, 32.82829], [-117.02459, 32.82809], [-117.02386, 32.82757], [-117.02399, 32.82745], [-117.02411, 32.82684], [-117.02346, 32.82662], [-117.02302, 32.82699], [-117.02263, 32.82673], [-117.02249, 32.82686], [-117.02235, 32.82676], [-117.02233, 32.82677], [-117.02208, 32.82659], [-117.01999, 32.82869], [-117.01798, 32.82719], [-117.01706, 32.8272], [-117.01687, 32.82685], [-117.01635, 32.82571], [-117.01586, 32.82388], [-117.01584, 32.82388], [-117.01574, 32.82376], [-117.01563, 32.82364], [-117.01539, 32.82346], [-117.01521, 32.82324], [-117.01505, 32.8231], [-117.01499, 32.823], [-117.01493, 32.82269], [-117.01488, 32.82256], [-117.01458, 32.82224], [-117.01449, 32.82216], [-117.01421, 32.82197], [-117.01183, 32.82066], [-117.01156, 32.82047], [-117.01137, 32.82028], [-117.01119, 32.82005], [-117.01107, 32.81978], [-117.0107, 32.81851], [-117.01061, 32.81816], [-117.0106, 32.81809], [-117.01066, 32.81799], [-117.01075, 32.81793], [-117.01086, 32.81792], [-117.01099, 32.81796], [-117.01107, 32.81805], [-117.01136, 32.81892], [-117.01145, 32.81906], [-117.01158, 32.81921], [-117.01183, 32.81938], [-117.01271, 32.81981], [-117.01289, 32.81988], [-117.01308, 32.81992], [-117.01337, 32.81993], [-117.01361, 32.8199], [-117.01385, 32.81983], [-117.01409, 32.8197], [-117.01425, 32.81957], [-117.01435, 32.81946], [-117.01481, 32.81877], [-117.0147, 32.81871], [-117.01426, 32.81937], [-117.01416, 32.81949], [-117.01399, 32.81963], [-117.01383, 32.81972], [-117.01365, 32.81978], [-117.01341, 32.81982], [-117.01323, 32.81983], [-117.01299, 32.8198], [-117.01277, 32.81972], [-117.0119, 32.81929], [-117.01168, 32.81914], [-117.01156, 32.81899], [-117.01147, 32.81885], [-117.01119, 32.81801], [-117.01113, 32.81792], [-117.01103, 32.81785], [-117.0109, 32.81781], [-117.01075, 32.81782], [-117.01063, 32.81786], [-117.01052, 32.81797], [-117.01048, 32.81805], [-117.01047, 32.81813], [-117.01058, 32.81855], [-117.01023, 32.81751], [-117.00997, 32.81563], [-117.01204, 32.81698], [-117.01391, 32.81818], [-117.0198, 32.8119], [-117.01979, 32.81188], [-117.01937, 32.81159], [-117.01979, 32.81115], [-117.02118, 32.8122], [-117.02174, 32.81214], [-117.02325, 32.81054], [-117.02339, 32.8101], [-117.02316, 32.80969], [-117.02272, 32.80941], [-117.02259, 32.8095], [-117.02245, 32.80957], [-117.02229, 32.80961], [-117.02212, 32.80963], [-117.02193, 32.80962], [-117.02176, 32.80957], [-117.02161, 32.8095], [-117.0215, 32.80942], [-117.0216, 32.80933], [-117.0219, 32.80952], [-117.02312, 32.80816], [-117.02571, 32.80819], [-117.02706, 32.80763], [-117.02759, 32.80851], [-117.02839, 32.80817], [-117.02788, 32.80729], [-117.02849, 32.80704], [-117.02918, 32.80557], [-117.0298, 32.80447], [-117.0313, 32.80375], [-117.03165, 32.80305], [-117.0317, 32.80307], [-117.03622, 32.80401], [-117.03728, 32.80422], [-117.03718, 32.80461], [-117.03774, 32.80471], [-117.0377, 32.80494], [-117.03767, 32.80517], [-117.03767, 32.8054], [-117.03771, 32.80568], [-117.03778, 32.80594], [-117.03785, 32.80614], [-117.03795, 32.80634], [-117.03809, 32.80655], [-117.03832, 32.80684], [-117.03857, 32.80707], [-117.03903, 32.8074], [-117.0394, 32.80757], [-117.03925, 32.80783], [-117.04019, 32.80836], [-117.03971, 32.80914], [-117.03963, 32.80933], [-117.0396, 32.80953], [-117.03959, 32.80986], [-117.03983, 32.81006], [-117.04008, 32.81009], [-117.04005, 32.81052], [-117.04018, 32.81053], [-117.04039, 32.81104], [-117.04042, 32.81119], [-117.04041, 32.81136], [-117.04046, 32.81152], [-117.04087, 32.81226], [-117.04123, 32.81262], [-117.04166, 32.81316], [-117.0432, 32.81475], [-117.04291, 32.8147], [-117.04273, 32.81537], [-117.04315, 32.81545], [-117.0436, 32.81548], [-117.04419, 32.81549], [-117.04512, 32.8158], [-117.04555, 32.8159], [-117.04626, 32.81855]]]]} | Open Access 1 | 1152 | Mission Trails Regional Park | 29248 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 1520.459 | Mission Trails RP | 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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | ||
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 |
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]);