units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,530
- County Agency 1,123
- Recreation/Parks District 1,114
- State Agency 1,103
- Non Profit - Land Trust 567
- Federal Agency 487
- Open Space District 401
- Water District 234
- County Agency - Parks 226
- Home Owners Association 198
- Community Services District 197
- Non Profit - Conservation 146
- Flood District 101
- Irrigation District 48
- Cemetery District 46
- Non Profit - Other 45
- School District 38
- County Agency - Other 30
- Port/Harbor District 29
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 469
- Los Angeles, City of 430
- California Department of Fish and Wildlife 428
- California Department of Parks and Recreation 372
- Mountains Recreation and Conservation Authority 326
- San Jose, City of 230
- Sacramento, City of 220
- San Francisco, City and County of 196
- East Bay Regional Park District 164
- Los Angeles, County of 152
- Ventura, City of 144
- Roseville, City of 130
- Long Beach, City of 127
- Oakland, City of 119
- United States Bureau of Land Management 117
- Santa Barbara, County of 109
- United States Forest Service 105
- San Diego, County of 103
- Irvine, City of 98
- Consumnes Community Services District 94
- Orange, County of 85
- Modesto, City of 85
- California State Lands Commission 83
- Hayward Area Recreation and Park District 82
- Stockton, City of 81
- Napa, City of 81
- United States Fish and Wildlife Service 80
- United States National Park Service 78
- Santa Rosa, City of 77
- Tracy, City of 73
- …
DES_TP >30
- Local Park 8,414
- Local Recreation Area 1,884
- Local Other or Unknown 1,165
- Private Conservation 594
- Local Conservation Area 460
- State Conservation Area 370
- Private Recreation or Education 263
- State Park 204
- State Resource Management Area 157
- State Recreation Area 140
- Local Historic or Cultural Area 96
- National Forest 92
- National Wildlife Refuge 73
- National Public Lands 72
- State Other or Unknown 68
- State Historic or Cultural Area 63
- Recreation Management Area 56
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 37
- Resource Management Area 24
- Local Resource Management Area 23
- Federal Other or Unknown 23
- National Park 22
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,272
- Restricted Access 1,159
- No Public Access 936
- Unknown Access 377
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1325 | 1325 | 1324 | {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47541], [-122.70162, 38.47624], [-122.70157, 38.47671], [-122.7013, 38.47657], [-122.70121, 38.4765], [-122.70093, 38.47617], [-122.70076, 38.47599], [-122.70056, 38.47583], [-122.69975, 38.47539], [-122.6998, 38.47531], [-122.69915, 38.47498], [-122.69895, 38.47484], [-122.69885, 38.47467], [-122.70244, 38.47464], [-122.7023, 38.47517], [-122.70221, 38.47536], [-122.70256, 38.47544]]]} | Open Access 1 | 10821 | Hidden Valley Park | 19920 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 8.794 | Hidden Valley Park | 0 | Local Park 2 | 4 | |
1326 | 1326 | 1325 | {"type": "Polygon", "coordinates": [[[-117.05556, 32.60243], [-117.0517, 32.60351], [-117.0517, 32.60349], [-117.05163, 32.60309], [-117.05161, 32.60259], [-117.05521, 32.60157], [-117.05556, 32.60243]]]} | Open Access 1 | 10822 | San Diego Gas & Electric Park West | 24855 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sdg-e-park | San Diego 4 | 9.164 | San Diego Gas & Electric Park West | 0 | Local Park 2 | 4 |
1327 | 1327 | 1326 | {"type": "Polygon", "coordinates": [[[-122.69381, 38.48999], [-122.69379, 38.49004], [-122.69375, 38.49006], [-122.69344, 38.49011], [-122.69317, 38.49012], [-122.69239, 38.49008], [-122.69236, 38.49005], [-122.69238, 38.4897], [-122.69237, 38.48951], [-122.69231, 38.48938], [-122.69218, 38.48923], [-122.69204, 38.48914], [-122.69189, 38.48908], [-122.69146, 38.489], [-122.69126, 38.48894], [-122.69096, 38.48877], [-122.69078, 38.48865], [-122.69125, 38.48827], [-122.69152, 38.48843], [-122.69216, 38.48858], [-122.69245, 38.48857], [-122.69273, 38.48852], [-122.69314, 38.48835], [-122.69317, 38.48825], [-122.69296, 38.48806], [-122.69306, 38.48799], [-122.69316, 38.48795], [-122.69332, 38.48792], [-122.69337, 38.48793], [-122.6934, 38.48797], [-122.69343, 38.48816], [-122.6935, 38.48892], [-122.69361, 38.48938], [-122.69369, 38.48967], [-122.69381, 38.48999]]]} | Open Access 1 | 10830 | Rincon Ridge Park | 24370 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 7.263 | Rincon Ridge Park | 0 | Local Park 2 | 4 | |
1328 | 1328 | 1327 | {"type": "Polygon", "coordinates": [[[-122.15732, 38.0806], [-122.1569, 38.08087], [-122.15644, 38.08063], [-122.15466, 38.08044], [-122.15466, 38.08032], [-122.1548, 38.08004], [-122.15494, 38.07957], [-122.15567, 38.07968], [-122.15607, 38.07993], [-122.15624, 38.08012], [-122.15681, 38.08024], [-122.15732, 38.0806]]]} | Open Access 1 | 10834 | Frank Skillman Park | 19054 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.944 | Frank Skillman Park | 0 | Local Park 2 | 4 | |
1329 | 1329 | 1328 | {"type": "Polygon", "coordinates": [[[-122.18383, 38.09471], [-122.1838, 38.09489], [-122.18358, 38.09508], [-122.18317, 38.09495], [-122.18237, 38.09491], [-122.18239, 38.09454], [-122.18298, 38.09452], [-122.18335, 38.09437], [-122.18383, 38.09471]]]} | Open Access 1 | 10843 | Channing Circle Park | 17124 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 1.577 | Channing Circle Park | 0 | Local Park 2 | 4 | |
1330 | 1330 | 1329 | {"type": "Polygon", "coordinates": [[[-122.17182, 38.08036], [-122.17165, 38.08078], [-122.17099, 38.08064], [-122.17094, 38.08045], [-122.1708, 38.08028], [-122.17092, 38.08026], [-122.17102, 38.08011], [-122.17182, 38.08036]]]} | Open Access 1 | 10851 | Park Solano | 23438 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 0.974 | Park Solano | None 116 | |||
1331 | 1331 | 1330 | {"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]} | No Public Access 3 | 47644 | Box Springs Reserve | 31388 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | http://www.ucnrs.org/reserves/box-springs-reserve.html | Riverside 10 | 159.828 | Box Springs Reserve | 0 | State Conservation Area 8 | 2 |
1332 | 1332 | 1331 | {"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45334, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45115, 34.14929], [-116.44898, 34.1493], [-116.44892, 34.13524], [-116.45764, 34.13534], [-116.45767, 34.14247], [-116.45768, 34.14968]], [[-116.45762, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45333, 34.14699], [-116.45654, 34.14833], [-116.45761, 34.14833], [-116.45762, 34.14811]]]} | No Public Access 3 | 47645 | Burns Piñon Ridge Reserve | 31389 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html | San Bernardino 22 | 304.422 | Burns Piñon Ridge Reserve | 0 | State Conservation Area 8 | 2 |
1333 | 1333 | 1332 | {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} | Open Access 1 | 7580 | Palo Verde County Park | 23359 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 13.919 | Palo Verde County Park | 0 | Local Park 2 | 4 | |
1334 | 1334 | 1333 | {"type": "Polygon", "coordinates": [[[-122.15933, 38.07512], [-122.15933, 38.07532], [-122.15829, 38.07543], [-122.15682, 38.07548], [-122.15563, 38.0758], [-122.15542, 38.07564], [-122.15525, 38.07575], [-122.15507, 38.07565], [-122.15491, 38.07575], [-122.15472, 38.07575], [-122.15485, 38.07472], [-122.15508, 38.07477], [-122.15591, 38.07472], [-122.15688, 38.07449], [-122.15786, 38.07409], [-122.15809, 38.07452], [-122.15852, 38.07478], [-122.15916, 38.07489], [-122.15933, 38.07512]]]} | Open Access 1 | 10860 | Southhampton Park | 25691 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 10.134 | Southhampton Park | 0 | Local Park 2 | 4 | |
1335 | 1335 | 1334 | {"type": "Polygon", "coordinates": [[[-122.16896, 38.0589], [-122.16836, 38.05972], [-122.16685, 38.05884], [-122.16731, 38.05817], [-122.16896, 38.0589]]]} | Open Access 1 | 10872 | Willow Glen Park | 27578 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.875 | Willow Glen Park | 0 | Local Park 2 | 4 | |
1336 | 1336 | 1335 | {"type": "MultiPolygon", "coordinates": [[[[-117.24613, 33.56531], [-117.24559, 33.5653], [-117.24526, 33.56496], [-117.24493, 33.56474], [-117.24443, 33.56451], [-117.24378, 33.56407], [-117.24287, 33.56387], [-117.24259, 33.56487], [-117.24271, 33.56518], [-117.24246, 33.56527], [-117.24224, 33.56541], [-117.24186, 33.56521], [-117.24159, 33.56501], [-117.24139, 33.56475], [-117.24126, 33.56425], [-117.2411, 33.56402], [-117.24073, 33.56396], [-117.2402, 33.56413], [-117.23902, 33.56104], [-117.24018, 33.56138], [-117.24228, 33.5625], [-117.24287, 33.56174], [-117.24294, 33.56171], [-117.24301, 33.56182], [-117.24339, 33.56225], [-117.24483, 33.56334], [-117.245, 33.5632], [-117.24534, 33.56346], [-117.24562, 33.56374], [-117.24584, 33.56406], [-117.246, 33.56441], [-117.24609, 33.56477], [-117.24613, 33.56531]]], [[[-117.25567, 33.56274], [-117.25536, 33.56276], [-117.25496, 33.56267], [-117.25484, 33.56266], [-117.25462, 33.5627], [-117.2544, 33.56283], [-117.25424, 33.56286], [-117.25339, 33.56288], [-117.25386, 33.56394], [-117.25403, 33.56505], [-117.25412, 33.56583], [-117.25407, 33.5658], [-117.25394, 33.56578], [-117.25384, 33.5658], [-117.25382, 33.56577], [-117.25378, 33.56577], [-117.25365, 33.56592], [-117.25357, 33.56608], [-117.25343, 33.56655], [-117.25343, 33.56672], [-117.25348, 33.56675], [-117.2536, 33.56676], [-117.25376, 33.56681], [-117.25381, 33.5668], [-117.25384, 33.56695], [-117.25359, 33.56696], [-117.25342, 33.56702], [-117.25336, 33.56709], [-117.25337, 33.56727], [-117.25336, 33.56729], [-117.25334, 33.56757], [-117.25351, 33.56758], [-117.25352, 33.56763], [-117.25297, 33.5677], [-117.25289, 33.5677], [-117.25293, 33.56764], [-117.25298, 33.56744], [-117.25291, 33.56731], [-117.2529, 33.56725], [-117.25299, 33.56713], [-117.253, 33.56699], [-117.25311, 33.5668], [-117.25308, 33.5666], [-117.25309, 33.56647], [-117.25307, 33.56645], [-117.25311, 33.56598], [-117.25309, 33.56585], [-117.25293, 33.56584], [-117.25273, 33.56604], [-117.25267, 33.56601], [-117.25261, 33.566], [-117.25255, 33.56601], [-117.2525, 33.56604], [-117.25212, 33.56588], [-117.25218, 33.56583], [-117.25217, 33.56564], [-117.25214, 33.56537], [-117.25209, 33.56516], [-117.25201, 33.56472], [-117.25226, 33.56468], [-117.2522, 33.56429], [-117.25275, 33.5642], [-117.2528, 33.56425], [-117.25307, 33.56405], [-117.25316, 33.56356], [-117.25282, 33.5632], [-117.25254, 33.56335], [-117.25231, 33.56355], [-117.25213, 33.56367], [-117.25194, 33.56375], [-117.25166, 33.56385], [-117.25138, 33.56391], [-117.25111, 33.56393], [-117.25026, 33.56405], [-117.24987, 33.56438], [-117.24981, 33.56445], [-117.2498, 33.56454], [-117.24982, 33.56462], [-117.24986, 33.56469], [-117.25, 33.56484], [-117.25061, 33.56488], [-117.25123, 33.56482], [-117.25129, 33.56519], [-117.25092, 33.56524], [-117.25096, 33.56549], [-117.2508, 33.56555], [-117.25028, 33.56563], [-117.24949, 33.56545], [-117.24948, 33.56543], [-117.24879, 33.56527], [-117.24877, 33.56529], [-117.24869, 33.56527], [-117.24869, 33.56524], [-117.24838, 33.56517], [-117.24699, 33.56556], [-117.2464, 33.5655], [-117.24638, 33.56552], [-117.24635, 33.56552], [-117.24635, 33.56527], [-117.2463, 33.56475], [-117.24622, 33.56439], [-117.24613, 33.56415], [-117.24593, 33.56382], [-117.24577, 33.56361], [-117.24548, 33.56333], [-117.24515, 33.56307], [-117.24683, 33.5616], [-117.25252, 33.56095], [-117.25406, 33.55451], [-117.25485, 33.5545], [-117.25567, 33.56274]]]]} | Open Access 1 | 48457 | Cole Canyon Natural Park | 33160 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 152.333 | Cole Canyon Natural Park | 0 | Local Park 2 | 4 | |
1337 | 1337 | 1336 | {"type": "Polygon", "coordinates": [[[-119.64592, 36.33406], [-119.64591, 36.33478], [-119.6445, 36.33478], [-119.64451, 36.33407], [-119.64592, 36.33406]]]} | Open Access 1 | 10875 | Lacey Park | 20817 | 1129 | Hanford, City of 349 | City 2 | City Agency 2 | http://www.ci.hanford.ca.us/depts/rec/default.asp | City 2 | 1129 | Hanford, City of 346 | City 2 | City Agency 2 | Kings 44 | 2.469 | Lacey Park | 0 | Local Park 2 | 4 | |
1338 | 1338 | 1337 | {"type": "Polygon", "coordinates": [[[-118.4728, 34.00128], [-118.47142, 34.00207], [-118.47128, 34.00191], [-118.47271, 34.00116], [-118.4728, 34.00128]]]} | Open Access 1 | 7397 | Ozone Park | 23286 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.715 | Ozone Park | 0 | Local Park 2 | 4 | |
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.163 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1341 | 1341 | 1340 | {"type": "Polygon", "coordinates": [[[-117.26959, 34.11193], [-117.26877, 34.11194], [-117.26876, 34.11031], [-117.26959, 34.11031], [-117.26959, 34.11193]]]} | Open Access 1 | 7519 | Palm Field Park | 23337 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 3.376 | Palm Field Park | 0 | Local Recreation Area 3 | 4 | |
1342 | 1342 | 1341 | {"type": "Polygon", "coordinates": [[[-118.24873, 34.13131], [-118.24873, 34.13149], [-118.24795, 34.13149], [-118.248, 34.13258], [-118.24703, 34.13258], [-118.24698, 34.13222], [-118.2465, 34.13213], [-118.24645, 34.13206], [-118.24711, 34.13179], [-118.24738, 34.13145], [-118.24766, 34.13134], [-118.24793, 34.13134], [-118.24794, 34.13131], [-118.24873, 34.13131]]]} | Open Access 1 | 7560 | Palmer Park | 23353 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 3.334 | Palmer Park | 0 | Local Park 2 | 4 | |
1343 | 1343 | 1342 | {"type": "Polygon", "coordinates": [[[-117.48634, 34.15655], [-117.48601, 34.15655], [-117.48202, 34.15653], [-117.48215, 34.15623], [-117.48235, 34.15589], [-117.4826, 34.15556], [-117.48281, 34.15535], [-117.48322, 34.15502], [-117.48435, 34.15431], [-117.4846, 34.15433], [-117.48566, 34.15525], [-117.48586, 34.15545], [-117.48606, 34.15571], [-117.4862, 34.15598], [-117.4863, 34.15629], [-117.48634, 34.15655]]]} | Open Access 1 | 11266 | San Sevaine Park | 24992 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 15.66 | San Sevaine Park | 0 | Local Park 2 | 4 | |
1344 | 1344 | 1343 | {"type": "Polygon", "coordinates": [[[-121.80306, 37.96023], [-121.80282, 37.96064], [-121.80082, 37.96089], [-121.80065, 37.96007], [-121.80169, 37.95988], [-121.80252, 37.95958], [-121.8027, 37.95983], [-121.80296, 37.95969], [-121.80306, 37.96023]]]} | Open Access 1 | 11320 | Dallas Ranch Park | 17898 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 5.028 | Dallas Ranch 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]);