units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
106 rows where COUNTY = 20 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
AGNCY_NAME 22 ✖
- Calexico, City of 23
- Brawley, City of 15
- El Centro, City of 14
- Imperial, City of 10
- California Department of Parks and Recreation 7
- California Department of Fish and Wildlife 5
- Imperial, County of 5
- Heber Public Utility District 4
- Calipatria, City of 4
- Holtville, City of 3
- United States Bureau of Land Management 2
- United States Bureau of Reclamation 2
- Imperial Irrigation District 2
- Salton Community Services District 2
- United States Fish and Wildlife Service 1
- California State Lands Commission 1
- Metropolitan Water District of Southern California 1
- El Centro Elementary School District 1
- Mojave Desert Land Trust 1
- Holtville Community Redevelopment Agency 1
- Pulte Home Corporation 1
- Westmorland, City of 1
MNG_AGENCY 19
- Calexico, City of 23
- El Centro, City of 16
- Brawley, City of 15
- Imperial, City of 10
- California Department of Parks and Recreation 8
- California Department of Fish and Wildlife 5
- Imperial, County of 5
- Holtville, City of 4
- Heber Public Utility District 4
- Calipatria, City of 4
- United States Bureau of Reclamation 2
- Imperial Irrigation District 2
- Salton Community Services District 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- California State Lands Commission 1
- Metropolitan Water District of Southern California 1
- Mojave Desert Land Trust 1
- Westmorland, City of 1
DES_TP 15
MNG_AG_TYP 8
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
82 | 82 | 81 | {"type": "Polygon", "coordinates": [[[-115.57468, 32.84244], [-115.57468, 32.84326], [-115.5737, 32.84326], [-115.57371, 32.84244], [-115.57468, 32.84244]]]} | Open Access 1 | 263 | Freddie White Park | 19078 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 2.047 | Freddie White Park | 0 | Local Park 2 | 4 | |
232 | 232 | 231 | {"type": "Polygon", "coordinates": [[[-115.55924, 32.80381], [-115.55717, 32.80381], [-115.55717, 32.80208], [-115.5575, 32.80209], [-115.5578, 32.80221], [-115.5592, 32.8022], [-115.55924, 32.80381]]]} | Open Access 1 | 627 | Fraizer Field | 19039 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 8.576 | Fraizer Field | 0 | Local Recreation Area 3 | 4 | |
401 | 401 | 400 | {"type": "Polygon", "coordinates": [[[-115.52412, 32.9724], [-115.52322, 32.9724], [-115.52322, 32.97086], [-115.52412, 32.97086], [-115.52412, 32.9724]]]} | Open Access 1 | 1270 | Guadalupe Park | 19557 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 3.577 | Guadalupe Park | 0 | Local Park 2 | 4 | |
477 | 477 | 476 | {"type": "Polygon", "coordinates": [[[-115.54149, 32.97992], [-115.54149, 32.98078], [-115.53953, 32.98078], [-115.53954, 32.97992], [-115.54149, 32.97992]]]} | Open Access 1 | 1566 | Gonzalez Park | 19400 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 4.312 | Gonzalez Park | 0 | Local Park 2 | 4 | |
5738 | 5738 | 5737 | {"type": "Polygon", "coordinates": [[[-115.39721, 32.70888], [-115.3965, 32.71603], [-115.39651, 32.72278], [-115.39116, 32.72283], [-115.38802, 32.73027], [-115.38802, 32.73065], [-115.38463, 32.73065], [-115.38568, 32.72835], [-115.38577, 32.72807], [-115.38586, 32.72762], [-115.38709, 32.72343], [-115.38805, 32.72342], [-115.38806, 32.72285], [-115.38725, 32.72285], [-115.38738, 32.72244], [-115.38807, 32.72065], [-115.38808, 32.71976], [-115.38837, 32.71975], [-115.38893, 32.71803], [-115.3902, 32.71249], [-115.39188, 32.70941], [-115.39232, 32.70913], [-115.39232, 32.70888], [-115.39721, 32.70888]]]} | Open Access 1 | 1634 | Heber Dunes State Vehicular Recreation Area | 1560 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=408 | Imperial 20 | 325.49 | Heber Dunes SVRA | 1998 | State Recreation Area 39 | 4 |
16697 | 16697 | 16696 | {"type": "MultiPolygon", "coordinates": [[[[-115.54403, 33.0963], [-115.54396, 33.10096], [-115.53918, 33.09943], [-115.53686, 33.09817], [-115.53459, 33.09627], [-115.53452, 33.10291], [-115.52318, 33.10278], [-115.52328, 33.09652], [-115.52428, 33.09535], [-115.52227, 33.09321], [-115.52102, 33.09174], [-115.51989, 33.0921], [-115.51875, 33.09043], [-115.51874, 33.08887], [-115.51431, 33.08886], [-115.51428, 33.08362], [-115.51221, 33.08359], [-115.51224, 33.0816], [-115.51036, 33.08174], [-115.51035, 33.08229], [-115.50872, 33.08223], [-115.5059, 33.07844], [-115.50579, 33.07833], [-115.50573, 33.07822], [-115.50492, 33.07712], [-115.5046, 33.07628], [-115.50436, 33.07548], [-115.50443, 33.07469], [-115.50477, 33.07372], [-115.50541, 33.0722], [-115.50759, 33.07057], [-115.50719, 33.07005], [-115.50613, 33.07005], [-115.50546, 33.06981], [-115.50509, 33.06962], [-115.50474, 33.06928], [-115.50424, 33.06856], [-115.50398, 33.068], [-115.50358, 33.06771], [-115.50344, 33.06738], [-115.50342, 33.06644], [-115.50064, 33.06639], [-115.50061, 33.06447], [-115.49635, 33.06441], [-115.4962, 33.05942], [-115.49612, 33.05901], [-115.49181, 33.05894], [-115.49178, 33.0518], [-115.4875, 33.05174], [-115.48856, 33.04958], [-115.49027, 33.04958], [-115.49049, 33.04822], [-115.48758, 33.04622], [-115.48666, 33.04463], [-115.4927, 33.04464], [-115.49628, 33.04542], [-115.49972, 33.04559], [-115.50082, 33.0461], [-115.50089, 33.04639], [-115.50086, 33.04662], [-115.50093, 33.04693], [-115.50126, 33.04714], [-115.5027, 33.04818], [-115.50282, 33.04825], [-115.5029, 33.04969], [-115.50342, 33.0517], [-115.50248, 33.05176], [-115.50243, 33.05186], [-115.50228, 33.0524], [-115.50232, 33.05283], [-115.50229, 33.05319], [-115.50234, 33.05356], [-115.50235, 33.05387], [-115.50265, 33.0543], [-115.50274, 33.05466], [-115.50302, 33.05543], [-115.50315, 33.05593], [-115.5032, 33.05626], [-115.50336, 33.05657], [-115.50353, 33.05679], [-115.50406, 33.05712], [-115.50426, 33.05732], [-115.50449, 33.05776], [-115.50492, 33.05821], [-115.5054, 33.05869], [-115.5056, 33.05914], [-115.50665, 33.05917], [-115.50667, 33.06267], [-115.50905, 33.0627], [-115.50903, 33.06633], [-115.51075, 33.06633], [-115.51075, 33.06596], [-115.51323, 33.06592], [-115.51323, 33.06633], [-115.51351, 33.06634], [-115.51358, 33.06985], [-115.51418, 33.06988], [-115.51416, 33.07004], [-115.51438, 33.07003], [-115.51464, 33.07112], [-115.51569, 33.07233], [-115.51697, 33.07369], [-115.51696, 33.07401], [-115.51699, 33.07479], [-115.52297, 33.07498], [-115.523, 33.08181], [-115.52698, 33.08186], [-115.5269, 33.08549], [-115.52752, 33.08579], [-115.52816, 33.08644], [-115.52881, 33.08688], [-115.52949, 33.0871], [-115.52994, 33.0874], [-115.53064, 33.08812], [-115.53096, 33.08865], [-115.53145, 33.0892], [-115.5318, 33.08946], [-115.53601, 33.0897], [-115.53601, 33.09639], [-115.54403, 33.0963]], [[-115.50412, 33.06721], [-115.50373, 33.06641], [-115.50371, 33.0664], [-115.50362, 33.06651], [-115.50369, 33.06684], [-115.50404, 33.0674], [-115.50406, 33.0674], [-115.50412, 33.06721]]], [[[-115.61839, 33.31096], [-115.61839, 33.31419], [-115.61435, 33.3146], [-115.61438, 33.32181], [-115.609, 33.32183], [-115.60334, 33.31423], [-115.59698, 33.30727], [-115.59154, 33.29999], [-115.58547, 33.2927], [-115.58127, 33.28729], [-115.57569, 33.28037], [-115.5695, 33.27289], [-115.56605, 33.26854], [-115.56541, 33.26768], [-115.56517, 33.2672], [-115.56452, 33.26682], [-115.56365, 33.2662], [-115.56257, 33.26515], [-115.56256, 33.24864], [-115.55348, 33.24842], [-115.55335, 33.2347], [-115.56268, 33.23472], [-115.56263, 33.22769], [-115.57976, 33.22741], [-115.57968, 33.24922], [-115.58835, 33.24925], [-115.58839, 33.26366], [-115.58843, 33.26367], [-115.58844, 33.2637], [-115.59708, 33.26366], [-115.597, 33.28545], [-115.60105, 33.28546], [-115.60105, 33.28863], [-115.60135, 33.28864], [-115.60135, 33.2891], [-115.60539, 33.28912], [-115.60558, 33.29276], [-115.60997, 33.29279], [-115.60981, 33.30313], [-115.61001, 33.30316], [-115.61001, 33.30366], [-115.6143, 33.30368], [-115.61433, 33.31083], [-115.61436, 33.31083], [-115.61436, 33.31093], [-115.61839, 33.31096]]], [[[-115.59708, 33.1839], [-115.59706, 33.19835], [-115.58852, 33.1984], [-115.58851, 33.19841], [-115.57549, 33.19841], [-115.57549, 33.19115], [-115.58406, 33.19115], [-115.58333, 33.18994], [-115.58507, 33.18952], [-115.58509, 33.18907], [-115.58518, 33.18897], [-115.58551, 33.18874], [-115.58571, 33.18873], [-115.58598, 33.18867], [-115.58608, 33.18856], [-115.58618, 33.18826], [-115.58589, 33.18784], [-115.58527, 33.18735], [-115.58424, 33.18707], [-115.58404, 33.18695], [-115.58393, 33.18667], [-115.58369, 33.18651], [-115.58371, 33.18612], [-115.58418, 33.18608], [-115.5849, 33.18588], [-115.58551, 33.18562], [-115.5859, 33.18548], [-115.5861, 33.18532], [-115.58617, 33.1852], [-115.58625, 33.18504], [-115.58629, 33.18467], [-115.58626, 33.1844], [-115.58623, 33.18432], [-115.58618, 33.18389], [-115.59708, 33.1839]]]]} | Open Access 1 | 1740 | Imperial Wildlife Area | 30457 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Imperial-WA | Imperial 20 | 7802.975 | Imperial Wildlife Area | 1951 | State Conservation Area 8 | 2 |
571 | 571 | 570 | {"type": "Polygon", "coordinates": [[[-115.38124, 32.81265], [-115.38119, 32.81269], [-115.38034, 32.81269], [-115.38033, 32.8111], [-115.38123, 32.8111], [-115.38124, 32.81265]]]} | Open Access 1 | 1910 | Holt Park | 20057 | 1139 | Holtville, City of 213 | City 2 | City Agency 2 | http://www.holtville.ca.gov/section.php?id=61 | City 2 | 1139 | Holtville, City of 209 | City 2 | City Agency 2 | Imperial 20 | 3.67 | Holt Park | 0 | Local Park 2 | 4 | |
6481 | 6481 | 6480 | {"type": "Polygon", "coordinates": [[[-115.57585, 32.85382], [-115.57585, 32.85465], [-115.57488, 32.85465], [-115.57488, 32.85381], [-115.57585, 32.85382]]]} | Open Access 1 | 2303 | C A Irving Park | 16624 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 2.089 | C A Irving Park | 0 | Local Park 2 | 4 | |
6644 | 6644 | 6643 | {"type": "Polygon", "coordinates": [[[-115.52958, 32.97543], [-115.52929, 32.97631], [-115.52654, 32.97631], [-115.52654, 32.97543], [-115.52958, 32.97543]]]} | Open Access 1 | 4656 | Hinojosa Park | 20003 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 6.523 | Hinojosa Park | 0 | Local Park 2 | 4 | |
803 | 803 | 802 | {"type": "Polygon", "coordinates": [[[-115.54406, 32.79085], [-115.54196, 32.79085], [-115.54196, 32.78986], [-115.54406, 32.78986], [-115.54406, 32.79085]]]} | Open Access 1 | 5217 | McGee Park | 22034 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 5.333 | McGee Park | 0 | Local Park 2 | 4 | |
6799 | 6799 | 6798 | {"type": "Polygon", "coordinates": [[[-115.53932, 32.9741], [-115.53736, 32.97411], [-115.53736, 32.97323], [-115.53932, 32.97322], [-115.53932, 32.9741]]]} | Open Access 1 | 5309 | Meserve Park | 22184 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 4.435 | Meserve Park | 0 | Local Park 2 | 4 | |
6854 | 6854 | 6853 | {"type": "MultiPolygon", "coordinates": [[[[-115.55482, 32.79638], [-115.55473, 32.79638], [-115.55446, 32.79632], [-115.55423, 32.79625], [-115.55403, 32.79617], [-115.55367, 32.79598], [-115.55459, 32.79597], [-115.55459, 32.79604], [-115.55462, 32.7961], [-115.55477, 32.79627], [-115.55482, 32.79638]]], [[[-115.55697, 32.7964], [-115.55502, 32.7964], [-115.55499, 32.79631], [-115.55488, 32.79612], [-115.55485, 32.79597], [-115.5568, 32.79596], [-115.55684, 32.79611], [-115.55694, 32.79628], [-115.55697, 32.7964]]], [[[-115.55913, 32.7964], [-115.55717, 32.7964], [-115.55707, 32.79606], [-115.55706, 32.79596], [-115.55902, 32.79595], [-115.55904, 32.79608], [-115.55911, 32.79629], [-115.55913, 32.7964]]], [[[-115.56129, 32.7964], [-115.55932, 32.7964], [-115.55932, 32.79632], [-115.55924, 32.79606], [-115.55922, 32.79595], [-115.56129, 32.79594], [-115.56129, 32.7964]]]]} | Open Access 1 | 5483 | Adams Park | 15260 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 7.435 | Adams Park | 0 | Local Park 2 | 4 | |
16542 | 16542 | 16541 | {"type": "MultiPolygon", "coordinates": [[[[-116.01115, 32.90743], [-116.01113, 32.90925], [-116.00681, 32.90925], [-116.00682, 32.90743], [-116.01115, 32.90743]]], [[[-116.03244, 33.32813], [-116.02393, 33.32812], [-116.0239, 33.3263], [-116.02497, 33.3263], [-116.02499, 33.32766], [-116.02605, 33.32766], [-116.02604, 33.3263], [-116.0303, 33.32631], [-116.03029, 33.32449], [-116.03243, 33.32449], [-116.03244, 33.32813]]], [[[-116.06696, 33.30979], [-116.04964, 33.30977], [-116.04954, 33.29508], [-116.06692, 33.2951], [-116.06696, 33.30979]]], [[[-116.08561, 33.39706], [-116.08548, 33.41157], [-116.06812, 33.41151], [-116.0681, 33.39705], [-116.08561, 33.39706]]], [[[-116.10318, 33.07475], [-116.09834, 33.07475], [-116.08435, 33.07469], [-116.08444, 33.0745], [-116.08441, 33.05943], [-116.08944, 33.05942], [-116.08941, 33.04493], [-116.08439, 33.04492], [-116.08437, 33.03461], [-116.08437, 33.03461], [-116.08437, 33.03454], [-116.08438, 33.03462], [-116.08465, 33.03462], [-116.10313, 33.03455], [-116.10318, 33.07475]]]]} | Open Access 1 | 5487 | Anza-Borrego Desert State Park | 1413 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | Imperial 20 | 3100.859 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
15569 | 15569 | 15568 | {"type": "MultiPolygon", "coordinates": [[[[-115.90891, 33.11807], [-115.89199, 33.11825], [-115.89181, 33.105], [-115.89125, 33.10497], [-115.89125, 33.10383], [-115.89179, 33.10383], [-115.89182, 33.10499], [-115.90865, 33.10492], [-115.90891, 33.11807]]], [[[-115.92585, 33.08992], [-115.92581, 33.10387], [-115.90914, 33.10384], [-115.90877, 33.08985], [-115.92585, 33.08992]]], [[[-115.96046, 33.08941], [-115.96045, 33.10392], [-115.94319, 33.10392], [-115.94318, 33.09143], [-115.94312, 33.09009], [-115.96037, 33.08972], [-115.96038, 33.08941], [-115.96046, 33.08941]]]]} | Open Access 1 | 5573 | San Felipe Creek Ecological Reserve | 32292 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Felipe-Creek-ER | Imperial 20 | 1794.365 | San Felipe Creek ER | 1994 | State Conservation Area 8 | 2 |
764 | 764 | 763 | {"type": "Polygon", "coordinates": [[[-115.57217, 32.8486], [-115.57216, 32.8494], [-115.57122, 32.84939], [-115.57122, 32.8486], [-115.57217, 32.8486]]]} | Open Access 1 | 5617 | Eager Park | 18336 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 1.933 | Eager Park | 0 | Local Park 2 | 4 | |
4490 | 4490 | 4489 | {"type": "Polygon", "coordinates": [[[-115.56564, 32.84427], [-115.56515, 32.84427], [-115.56515, 32.84344], [-115.56564, 32.84344], [-115.56564, 32.84427]]]} | Open Access 1 | 5643 | Evans Park | 18756 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 1.035 | Evans Park | 0 | Local Park 2 | 4 | |
5371 | 5371 | 5370 | {"type": "Polygon", "coordinates": [[[-115.53929, 32.98428], [-115.53929, 32.98506], [-115.5373, 32.98507], [-115.53731, 32.98428], [-115.53929, 32.98428]]]} | Open Access 1 | 5697 | Beechey Field | 15951 | 1394 | Brawley, City of 162 | City 2 | City Agency 2 | http://www.brawley-ca.gov/community/parks-&-recreation/ | City 2 | 1394 | Brawley, City of 158 | City 2 | City Agency 2 | Imperial 20 | 3.986 | Beechey Field | 0 | Local Recreation Area 3 | 4 | |
6894 | 6894 | 6893 | {"type": "Polygon", "coordinates": [[[-115.57346, 32.80572], [-115.57237, 32.80573], [-115.57237, 32.80519], [-115.57248, 32.80519], [-115.57249, 32.80471], [-115.57239, 32.80469], [-115.57234, 32.80393], [-115.57345, 32.80393], [-115.57346, 32.80572]]]} | Open Access 1 | 5736 | Carlos Aguilar Park | 16859 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 4.876 | Carlos Aguilar Park | 0 | Local Park 2 | 4 | |
16648 | 16648 | 16647 | {"type": "Polygon", "coordinates": [[[-114.69597, 33.07013], [-114.68771, 33.07016], [-114.68736, 33.07012], [-114.68589, 33.07012], [-114.68438, 33.06864], [-114.68426, 33.06832], [-114.68389, 33.06799], [-114.68248, 33.06652], [-114.67977, 33.06328], [-114.6772, 33.06053], [-114.67638, 33.05983], [-114.67416, 33.05732], [-114.67397, 33.05664], [-114.674, 33.05602], [-114.67398, 33.05576], [-114.67403, 33.05464], [-114.67403, 33.05407], [-114.67454, 33.05221], [-114.67493, 33.0512], [-114.67499, 33.04875], [-114.67519, 33.048], [-114.67498, 33.04628], [-114.67479, 33.04557], [-114.67449, 33.04488], [-114.67266, 33.04188], [-114.67185, 33.04078], [-114.67141, 33.03993], [-114.67104, 33.03939], [-114.66985, 33.03811], [-114.66746, 33.03645], [-114.66535, 33.03521], [-114.66218, 33.03352], [-114.66166, 33.03339], [-114.6603, 33.03326], [-114.65949, 33.03343], [-114.65894, 33.03363], [-114.65847, 33.03386], [-114.65793, 33.03429], [-114.65724, 33.03504], [-114.65578, 33.03633], [-114.65457, 33.03833], [-114.65375, 33.03943], [-114.65307, 33.04009], [-114.65171, 33.04258], [-114.65084, 33.04482], [-114.64917, 33.04731], [-114.64775, 33.04871], [-114.64729, 33.04905], [-114.64642, 33.04907], [-114.64533, 33.04913], [-114.64424, 33.04884], [-114.64313, 33.04828], [-114.64275, 33.04804], [-114.64227, 33.04759], [-114.64074, 33.04669], [-114.64002, 33.04604], [-114.63959, 33.0458], [-114.63888, 33.04528], [-114.63683, 33.04321], [-114.63621, 33.04219], [-114.63559, 33.04147], [-114.6334, 33.03835], [-114.6324, 33.03647], [-114.63108, 33.03458], [-114.62921, 33.03243], [-114.62719, 33.03035], [-114.62662, 33.02994], [-114.62578, 33.02966], [-114.62542, 33.02949], [-114.62466, 33.02906], [-114.62331, 33.02867], [-114.62181, 33.02828], [-114.62002, 33.02788], [-114.61848, 33.02748], [-114.61766, 33.02729], [-114.6163, 33.02712], [-114.61536, 33.02704], [-114.6144, 33.02702], [-114.61424, 33.02703], [-114.61286, 33.02678], [-114.61163, 33.02673], [-114.61127, 33.02668], [-114.60978, 33.02639], [-114.60829, 33.0262], [-114.60479, 33.02582], [-114.60026, 33.02573], [-114.59884, 33.02584], [-114.59769, 33.0258], [-114.59544, 33.02593], [-114.59334, 33.02622], [-114.59255, 33.02614], [-114.59107, 33.02645], [-114.59106, 33.02259], [-114.5907, 33.02257], [-114.59069, 33.00798], [-114.62574, 33.00801], [-114.62575, 33.02256], [-114.62576, 33.02257], [-114.64343, 33.02254], [-114.66088, 33.02259], [-114.66089, 33.00798], [-114.69562, 33.0081], [-114.6956, 33.03705], [-114.69576, 33.05181], [-114.69596, 33.06648], [-114.69597, 33.07013]]]} | Open Access 1 | 5750 | Picacho State Recreation Area | 13835 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=641 | Imperial 20 | 7510.524 | Picacho SRA | 1960 | State Recreation Area 39 | 4 |
6935 | 6935 | 6934 | {"type": "MultiPolygon", "coordinates": [[[[-115.77784, 33.37562], [-115.77783, 33.38352], [-115.76941, 33.38359], [-115.76938, 33.38358], [-115.7695, 33.37556], [-115.77784, 33.37562]]], [[[-115.79478, 33.39803], [-115.7868, 33.39803], [-115.78673, 33.39007], [-115.79427, 33.39009], [-115.79478, 33.39803]]], [[[-115.83439, 33.41435], [-115.82239, 33.41444], [-115.82236, 33.41239], [-115.81797, 33.41239], [-115.81311, 33.40829], [-115.82216, 33.40829], [-115.82237, 33.41239], [-115.83432, 33.4122], [-115.83439, 33.41435]]]]} | Open Access 1 | 5844 | Salton Sea State Recreation Area | 13840 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=639 | Imperial 20 | 462.442 | Salton Sea SRA | 1951 | State Recreation Area 39 | 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]);