superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- Recreation/Parks District 1,091
- State Agency 872
- County Agency 828
- Non Profit - Land Trust 511
- Open Space District 241
- Home Owners Association 200
- Community Services District 193
- Water District 187
- County Agency - Parks 169
- Non Profit - Conservation 119
- Flood District 94
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- Port/Harbor District 32
- County Agency - Other 27
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Airport District 1
- Utility 1
- …
MNG_AGENCY >30
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 136
- East Bay Regional Park District 132
- San Diego, County of 108
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Santa Barbara, County of 69
- Orange, County of 67
- Valley-Wide Recreation and Park District 67
- Los Angeles - Department of Parks and Recreation, County of 57
- Rancho Simi Recreation and Park District 53
- Lake, County of 53
- University of California 50
- Yuba County Water Agency 50
- Conejo Recreation and Park District 44
- The Nature Conservancy 43
- Midpeninsula Regional Open Space District 43
- Sonoma County Regional Parks Dept., County of 40
- Southgate Recreation and Park District 40
- Marin County Open Space District 39
- Conejo Open Space Conservation Agency 39
- Sunrise Recreation and Park District 39
- Santa Cruz, County of 38
- Cordova Recreation and Park District 36
- Kern, County of 35
- Other State 33
- Greater Vallejo Recreation and Park District 33
- Sacramento, County of 33
- …
ACCESS_TYP 4
- Open Access 3,331
- Restricted Access 699
- No Public Access 568
- Unknown Access 213
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV ▼ | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3915 | 3915 | 3914 | {"type": "Polygon", "coordinates": [[[-120.39086, 36.50214], [-120.39079, 36.50243], [-120.39079, 36.50283], [-120.39059, 36.50287], [-120.39032, 36.50283], [-120.39015, 36.50274], [-120.38996, 36.50251], [-120.38987, 36.50246], [-120.38984, 36.5023], [-120.38984, 36.50215], [-120.38985, 36.50208], [-120.3899, 36.502], [-120.39023, 36.50191], [-120.39072, 36.50197], [-120.39086, 36.50214]]]} | Open Access 1 | El Parque de la Communida El Porvenir | 18524 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 1.861 | El Parque de la Communida El Porvenir | ||
3924 | 3924 | 3923 | {"type": "Polygon", "coordinates": [[[-118.42983, 33.91628], [-118.4284, 33.91628], [-118.4259, 33.91134], [-118.42605, 33.91129], [-118.42606, 33.91127], [-118.42358, 33.90637], [-118.42295, 33.90501], [-118.42323, 33.90492], [-118.42451, 33.90742], [-118.42615, 33.91031], [-118.42632, 33.9105], [-118.4267, 33.91083], [-118.42692, 33.91098], [-118.4275, 33.91078], [-118.42757, 33.91145], [-118.42767, 33.91175], [-118.42983, 33.91628]]]} | Open Access 1 | El Segundo Beach | 18539 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 27.601 | El Segundo Beach | ||
3935 | 3935 | 3934 | {"type": "Polygon", "coordinates": [[[-120.83252, 35.33196], [-120.83067, 35.3336], [-120.83044, 35.33382], [-120.82384, 35.33374], [-120.82365, 35.33357], [-120.82366, 35.33193], [-120.83252, 35.33196]]]} | Open Access 1 | Elfin Forest Natural Preserve | 18558 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 35.804 | Elfin Forest Natural Preserve | ||
3938 | 3938 | 3937 | {"type": "Polygon", "coordinates": [[[-119.32892, 36.14604], [-119.32886, 36.14623], [-119.3288, 36.14734], [-119.32844, 36.14755], [-119.32821, 36.14757], [-119.32768, 36.14749], [-119.32705, 36.14774], [-119.32673, 36.1479], [-119.32644, 36.14823], [-119.32636, 36.14829], [-119.32612, 36.14841], [-119.32589, 36.14841], [-119.32588, 36.14707], [-119.32732, 36.14605], [-119.32741, 36.14599], [-119.32764, 36.1459], [-119.32785, 36.14585], [-119.32806, 36.14583], [-119.32841, 36.14585], [-119.32875, 36.14595], [-119.32892, 36.14604]]]} | Open Access 1 | Elk Bayou Park | 18560 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 11.374 | Elk Bayou Park | ||
3941 | 3941 | 3940 | {"type": "Polygon", "coordinates": [[[-121.52266, 38.59411], [-121.52227, 38.59588], [-121.52142, 38.59544], [-121.5217, 38.59399], [-121.52266, 38.59411]]]} | Open Access 1 | Elkhorn Park | 18567 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 3.719 | Elkhorn Park | ||
3944 | 3944 | 3943 | {"type": "Polygon", "coordinates": [[[-121.74481, 36.84148], [-121.74245, 36.84316], [-121.74184, 36.84299], [-121.74342, 36.84161], [-121.74317, 36.84141], [-121.74385, 36.84096], [-121.74425, 36.84118], [-121.74481, 36.84148]]]} | Open Access 1 | Elkhorn Slough | 18570 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 5.161 | Elkhorn Slough | ||
3997 | 3997 | 3996 | {"type": "Polygon", "coordinates": [[[-120.89849, 37.63946], [-120.89787, 37.63947], [-120.89787, 37.6397], [-120.8961, 37.63972], [-120.89606, 37.63842], [-120.89783, 37.6384], [-120.89784, 37.63909], [-120.89848, 37.63909], [-120.89849, 37.63946]]]} | Open Access 1 | Empire Community Park | 18633 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 6.12 | Empire Community Park | ||
4041 | 4041 | 4040 | {"type": "Polygon", "coordinates": [[[-118.25872, 33.91281], [-118.25871, 33.91462], [-118.25659, 33.91463], [-118.25655, 33.9146], [-118.25654, 33.91456], [-118.25654, 33.91282], [-118.25872, 33.91281]]]} | Open Access 1 | Enterprise Park | 18685 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 9.987 | Enterprise Park | ||
4051 | 4051 | 4050 | {"type": "Polygon", "coordinates": [[[-122.49452, 38.30454], [-122.49377, 38.3048], [-122.49336, 38.30408], [-122.49301, 38.3042], [-122.49262, 38.30344], [-122.49253, 38.30334], [-122.49242, 38.30326], [-122.49212, 38.30312], [-122.49197, 38.3031], [-122.49146, 38.30305], [-122.49093, 38.30295], [-122.49061, 38.30299], [-122.49053, 38.30297], [-122.49039, 38.30284], [-122.49011, 38.30262], [-122.48963, 38.30238], [-122.48939, 38.30214], [-122.48932, 38.30204], [-122.4892, 38.30194], [-122.4891, 38.30188], [-122.48889, 38.30184], [-122.48857, 38.30189], [-122.48751, 38.30222], [-122.48744, 38.30222], [-122.48741, 38.3022], [-122.48739, 38.30215], [-122.48778, 38.30202], [-122.48782, 38.30207], [-122.4896, 38.3014], [-122.48976, 38.30169], [-122.48999, 38.30208], [-122.4902, 38.30247], [-122.49055, 38.30266], [-122.49065, 38.30255], [-122.49072, 38.30255], [-122.49081, 38.3025], [-122.4909, 38.30271], [-122.49136, 38.30275], [-122.49157, 38.3027], [-122.49165, 38.30276], [-122.49171, 38.30277], [-122.49178, 38.30275], [-122.49208, 38.30285], [-122.49216, 38.30262], [-122.49206, 38.30244], [-122.49196, 38.30232], [-122.4919, 38.30221], [-122.49236, 38.30204], [-122.49326, 38.30174], [-122.49452, 38.30454]]]} | Open Access 1 | Ernie Smith Community Park | 18699 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 12.513 | Ernie Smith Community Park | ||
4053 | 4053 | 4052 | {"type": "Polygon", "coordinates": [[[-118.78814, 34.01865], [-118.7881, 34.01912], [-118.78785, 34.01951], [-118.78753, 34.01984], [-118.78591, 34.02079], [-118.78483, 34.02128], [-118.78461, 34.02141], [-118.78379, 34.02177], [-118.78296, 34.02206], [-118.78252, 34.02224], [-118.7821, 34.02236], [-118.78205, 34.02231], [-118.78188, 34.02237], [-118.78182, 34.02243], [-118.78146, 34.02251], [-118.78103, 34.02265], [-118.7807, 34.02267], [-118.77956, 34.02287], [-118.77921, 34.02296], [-118.77874, 34.02305], [-118.77808, 34.0231], [-118.77791, 34.02314], [-118.77752, 34.02319], [-118.77673, 34.02342], [-118.77616, 34.02353], [-118.77593, 34.02364], [-118.77481, 34.02384], [-118.77368, 34.02413], [-118.77248, 34.02437], [-118.77115, 34.02452], [-118.77058, 34.02462], [-118.77031, 34.02457], [-118.76986, 34.02458], [-118.76947, 34.02469], [-118.76932, 34.02479], [-118.76842, 34.02498], [-118.76834, 34.02478], [-118.7686, 34.02479], [-118.76883, 34.02473], [-118.76915, 34.02468], [-118.76961, 34.02456], [-118.76982, 34.02448], [-118.77072, 34.02438], [-118.77175, 34.02418], [-118.77267, 34.02409], [-118.77303, 34.02395], [-118.77336, 34.02393], [-118.77428, 34.02373], [-118.77462, 34.02364], [-118.77484, 34.02355], [-118.77549, 34.02337], [-118.776, 34.02327], [-118.77624, 34.02315], [-118.77663, 34.0231], [-118.77688, 34.02312], [-118.77714, 34.02309], [-118.77772, 34.02293], [-118.77799, 34.02289], [-118.77833, 34.02289], [-118.77869, 34.02284], [-118.77917, 34.02274], [-118.77965, 34.02263], [-118.7799, 34.02255], [-118.78021, 34.02252], [-118.78076, 34.02239], [-118.78149, 34.0223], [-118.78173, 34.02224], [-118.78193, 34.02214], [-118.78204, 34.02211], [-118.78238, 34.02198], [-118.78266, 34.0219], [-118.78271, 34.02185], [-118.78317, 34.02177], [-118.78364, 34.02162], [-118.78375, 34.02155], [-118.78394, 34.02146], [-118.78404, 34.02145], [-118.78425, 34.02134], [-118.78432, 34.02128], [-118.78456, 34.0212], [-118.78487, 34.02104], [-118.7859, 34.02061], [-118.78626, 34.0203], [-118.78585, 34.0199], [-118.78593, 34.01982], [-118.78616, 34.02004], [-118.78615, 34.02008], [-118.78631, 34.02022], [-118.78671, 34.01992], [-118.78709, 34.01966], [-118.78719, 34.01957], [-118.78733, 34.01936], [-118.78756, 34.01913], [-118.78775, 34.01869], [-118.7878, 34.01825], [-118.78814, 34.01865]]]} | Open Access 1 | Escondido Beach | 18702 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 13.665 | Escondido Beach | ||
4067 | 4067 | 4066 | {"type": "Polygon", "coordinates": [[[-122.01653, 38.69301], [-122.01636, 38.69377], [-122.01579, 38.69368], [-122.01596, 38.69293], [-122.01653, 38.69301]]]} | Open Access 1 | Esparto Community Park | 18713 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 1.06 | Esparto Community Park | ||
4068 | 4068 | 4067 | {"type": "MultiPolygon", "coordinates": [[[[-117.81129, 33.76654], [-117.81097, 33.77124], [-117.8108, 33.77342], [-117.81067, 33.77342], [-117.81095, 33.76974], [-117.81117, 33.76654], [-117.81129, 33.76654]]], [[[-117.81175, 33.75996], [-117.81146, 33.76454], [-117.81131, 33.76637], [-117.81119, 33.76638], [-117.81132, 33.76454], [-117.81133, 33.76422], [-117.8115, 33.76143], [-117.81161, 33.75995], [-117.81175, 33.75996]]]]} | Open Access 1 | Esplanade Park | 18714 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 4.693 | Esplanade Park | ||
4074 | 4074 | 4073 | {"type": "Polygon", "coordinates": [[[-117.61031, 33.64797], [-117.61017, 33.64805], [-117.60994, 33.64812], [-117.60981, 33.64818], [-117.60961, 33.64834], [-117.60957, 33.64841], [-117.60956, 33.64848], [-117.6096, 33.64857], [-117.60991, 33.64887], [-117.61001, 33.64902], [-117.61003, 33.64908], [-117.61, 33.64911], [-117.60957, 33.64928], [-117.60952, 33.64936], [-117.60953, 33.64945], [-117.60924, 33.64954], [-117.60927, 33.64946], [-117.60912, 33.64938], [-117.609, 33.64924], [-117.6092, 33.64915], [-117.60923, 33.64911], [-117.60917, 33.64897], [-117.60904, 33.6488], [-117.60899, 33.64862], [-117.60894, 33.64857], [-117.6091, 33.64835], [-117.60916, 33.64831], [-117.60923, 33.64833], [-117.60934, 33.64843], [-117.60942, 33.64844], [-117.60956, 33.64815], [-117.60969, 33.64818], [-117.60975, 33.6481], [-117.60982, 33.64806], [-117.60987, 33.64799], [-117.60994, 33.64798], [-117.6101, 33.6479], [-117.61024, 33.64796], [-117.61029, 33.64795], [-117.61031, 33.64797]]]} | Open Access 1 | Estrella Vista Park | 18731 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 2.127 | Estrella Vista Park | ||
4082 | 4082 | 4081 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00108, 32.76046], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | Eucalyptus Park | http://www.sdparks.org/content/sdparks/en/park-pages/Eucalyptus.html | 18739 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 6.739 | Eucalyptus Park | |
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-121.61958, 36.0915], [-121.61863, 36.09223], [-121.61856, 36.09184], [-121.61851, 36.09168], [-121.61843, 36.0915], [-121.61829, 36.09127], [-121.61771, 36.09052], [-121.61762, 36.09034], [-121.61756, 36.09016], [-121.61754, 36.08997], [-121.61756, 36.0898], [-121.61759, 36.08966], [-121.61774, 36.08925], [-121.61781, 36.08885], [-121.61781, 36.08862], [-121.61779, 36.0884], [-121.61767, 36.08791], [-121.6187, 36.08785], [-121.61869, 36.08803], [-121.61867, 36.08811], [-121.61869, 36.08859], [-121.61876, 36.08874], [-121.61882, 36.089], [-121.61889, 36.08915], [-121.6189, 36.08924], [-121.61886, 36.08933], [-121.61877, 36.0894], [-121.61862, 36.08956], [-121.61858, 36.08964], [-121.61855, 36.08971], [-121.61857, 36.08995], [-121.6186, 36.09004], [-121.61868, 36.09011], [-121.61871, 36.09019], [-121.61874, 36.09027], [-121.61876, 36.09045], [-121.61885, 36.09067], [-121.61891, 36.09076], [-121.61906, 36.09092], [-121.61936, 36.09109], [-121.61944, 36.09117], [-121.61956, 36.09142], [-121.61958, 36.0915]]]} | Open Access 1 | Evans Park | 18752 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 10.332 | Evans Park | ||
4103 | 4103 | 4102 | {"type": "Polygon", "coordinates": [[[-117.96673, 34.52821], [-117.9667, 34.52825], [-117.96665, 34.52827], [-117.96573, 34.52827], [-117.96572, 34.52596], [-117.96673, 34.52596], [-117.96673, 34.52821]]]} | Open Access 1 | Everett Martin Park | 18762 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.821 | Everett Martin Park | ||
4105 | 4105 | 4104 | {"type": "MultiPolygon", "coordinates": [[[[-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.8882, 34.43768], [-119.88786, 34.43766], [-119.88738, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88747, 34.43903], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88962, 34.43701], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988]]], [[[-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44125], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44059], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414]]]]} | Open Access 1 | Evergreen Acres | 18765 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 28.796 | Evergreen Acres | ||
4148 | 4148 | 4147 | {"type": "Polygon", "coordinates": [[[-117.72332, 33.5635], [-117.72297, 33.56336], [-117.72223, 33.56295], [-117.72187, 33.56267], [-117.72153, 33.56236], [-117.72132, 33.5621], [-117.72113, 33.56181], [-117.72104, 33.56147], [-117.72087, 33.56092], [-117.7207, 33.56059], [-117.7207, 33.56051], [-117.7206, 33.56017], [-117.72038, 33.55977], [-117.72018, 33.55956], [-117.71984, 33.5593], [-117.71958, 33.55916], [-117.71884, 33.55882], [-117.71902, 33.55868], [-117.7184, 33.55712], [-117.71842, 33.55691], [-117.71838, 33.55634], [-117.71839, 33.55617], [-117.71845, 33.55604], [-117.71842, 33.55601], [-117.71858, 33.55577], [-117.71876, 33.55579], [-117.71876, 33.55589], [-117.71926, 33.55597], [-117.7193, 33.55588], [-117.71994, 33.55599], [-117.71998, 33.55618], [-117.71981, 33.55721], [-117.71994, 33.55776], [-117.72054, 33.55825], [-117.7218, 33.56002], [-117.72219, 33.56026], [-117.72224, 33.56042], [-117.72228, 33.56042], [-117.72238, 33.56071], [-117.72252, 33.56116], [-117.72209, 33.56196], [-117.72211, 33.5622], [-117.72214, 33.56232], [-117.72234, 33.56265], [-117.72257, 33.5629], [-117.72257, 33.56293], [-117.72332, 33.5635]]]} | Open Access 1 | Hillview Park | 19992 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 24.723 | Hillview Park | ||
4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-116.92544, 32.74521], [-116.92529, 32.74527], [-116.92388, 32.74556], [-116.92186, 32.74538], [-116.92193, 32.7451], [-116.92209, 32.74475], [-116.92224, 32.74452], [-116.9224, 32.74436], [-116.92264, 32.74419], [-116.9229, 32.74407], [-116.92313, 32.74401], [-116.92344, 32.74397], [-116.92381, 32.744], [-116.92395, 32.74404], [-116.92412, 32.74409], [-116.92441, 32.74424], [-116.92459, 32.74438], [-116.92544, 32.74521]]]} | Open Access 1 | Hilton Head Park | http://www.sdparks.org/content/sdparks/en/park-pages/HiltonHead.html | 19997 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 9.881 | Hilton Head Park | |
4153 | 4153 | 4152 | {"type": "Polygon", "coordinates": [[[-121.01692, 37.59738], [-121.01558, 37.59738], [-121.01558, 37.59597], [-121.01691, 37.59597], [-121.01692, 37.59738]]]} | Open Access 1 | Fairview Park | 18814 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 4.544 | Fairview Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);