units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where DES_TP = 3, MNG_AGENCY = 543 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- County Agency · 8 ✖
MNG_AGENCY 1
- Sacramento, County of · 8 ✖
DES_TP 1
- Local Recreation Area · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11132 | 11132 | 11131 | {"type": "MultiPolygon", "coordinates": [[[[-121.09148, 38.49227], [-121.09125, 38.49243], [-121.09091, 38.49263], [-121.09073, 38.49271], [-121.09048, 38.49267], [-121.09013, 38.49268], [-121.0895, 38.49277], [-121.08916, 38.49278], [-121.08856, 38.49271], [-121.08839, 38.49288], [-121.08806, 38.49299], [-121.08776, 38.49324], [-121.08758, 38.49346], [-121.08736, 38.49369], [-121.08706, 38.49389], [-121.08684, 38.49411], [-121.08668, 38.49447], [-121.08635, 38.49468], [-121.08587, 38.4948], [-121.08548, 38.49497], [-121.08494, 38.49507], [-121.08444, 38.49513], [-121.08401, 38.49522], [-121.08368, 38.4954], [-121.08321, 38.49533], [-121.08263, 38.4952], [-121.08218, 38.49516], [-121.08186, 38.49517], [-121.08155, 38.49514], [-121.08119, 38.49514], [-121.08085, 38.49518], [-121.08048, 38.49518], [-121.07954, 38.49521], [-121.07918, 38.4953], [-121.07885, 38.49527], [-121.07803, 38.49512], [-121.07721, 38.49518], [-121.07672, 38.49507], [-121.07643, 38.49489], [-121.07601, 38.49485], [-121.07561, 38.49479], [-121.07506, 38.49468], [-121.0745, 38.49467], [-121.07387, 38.49457], [-121.07313, 38.4944], [-121.07188, 38.49433], [-121.07136, 38.49445], [-121.0709, 38.49468], [-121.07057, 38.49491], [-121.07008, 38.49571], [-121.06978, 38.49606], [-121.06879, 38.4965], [-121.0684, 38.49662], [-121.06787, 38.4969], [-121.06772, 38.49747], [-121.06745, 38.49789], [-121.06741, 38.4964], [-121.0678, 38.49625], [-121.06829, 38.49619], [-121.0692, 38.4956], [-121.06938, 38.49529], [-121.06934, 38.49511], [-121.06944, 38.49477], [-121.06956, 38.4945], [-121.07004, 38.4941], [-121.07124, 38.49356], [-121.07312, 38.49317], [-121.07514, 38.49348], [-121.07693, 38.49402], [-121.08244, 38.49408], [-121.08245, 38.49418], [-121.08279, 38.49418], [-121.08281, 38.49409], [-121.083, 38.49409], [-121.08466, 38.49399], [-121.08601, 38.4936], [-121.08706, 38.49299], [-121.08713, 38.49306], [-121.08756, 38.49279], [-121.08806, 38.49236], [-121.08926, 38.49218], [-121.0898, 38.49205], [-121.09063, 38.49184], [-121.09106, 38.49171], [-121.09128, 38.49189], [-121.09127, 38.49191], [-121.09133, 38.49195], [-121.09148, 38.49227]]], [[[-121.11462, 38.48233], [-121.11316, 38.48204], [-121.10939, 38.48209], [-121.10861, 38.48241], [-121.10763, 38.483], [-121.10532, 38.48394], [-121.10435, 38.48511], [-121.10083, 38.48719], [-121.10067, 38.48782], [-121.09651, 38.49026], [-121.09674, 38.49053], [-121.09379, 38.49339], [-121.09281, 38.49263], [-121.09319, 38.49205], [-121.09333, 38.49171], [-121.09343, 38.49155], [-121.09393, 38.48993], [-121.09485, 38.48922], [-121.09593, 38.48922], [-121.09595, 38.48641], [-121.09858, 38.48505], [-121.09983, 38.48505], [-121.09985, 38.48438], [-121.10456, 38.4818], [-121.11192, 38.48073], [-121.1122, 38.4807], [-121.1146, 38.48154], [-121.11462, 38.48233]]]]} | Restricted Access 2 | 21421 | Cosumnes River Parkway | 17677 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 188.683 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
11136 | 11136 | 11135 | {"type": "MultiPolygon", "coordinates": [[[[-121.44491, 38.68324], [-121.4449, 38.68382], [-121.44336, 38.6838], [-121.444, 38.68323], [-121.44491, 38.68324]]], [[[-121.45109, 38.68402], [-121.45214, 38.68404], [-121.45214, 38.68408], [-121.45181, 38.68474], [-121.45132, 38.68505], [-121.45027, 38.68506], [-121.4494, 38.68518], [-121.44928, 38.68525], [-121.44928, 38.68409], [-121.44991, 38.68405], [-121.44992, 38.68395], [-121.45063, 38.68396], [-121.45064, 38.68403], [-121.45109, 38.68402]]], [[[-121.45527, 38.67304], [-121.45483, 38.67456], [-121.45491, 38.6754], [-121.45515, 38.67609], [-121.45465, 38.67721], [-121.45391, 38.67774], [-121.45352, 38.67832], [-121.45274, 38.67905], [-121.45232, 38.68022], [-121.45233, 38.68024], [-121.45455, 38.68026], [-121.45455, 38.68091], [-121.45328, 38.68091], [-121.45328, 38.68116], [-121.45332, 38.6812], [-121.45328, 38.68125], [-121.45328, 38.6813], [-121.45331, 38.68135], [-121.45336, 38.68139], [-121.45333, 38.68144], [-121.45333, 38.6819], [-121.45336, 38.68195], [-121.45329, 38.68201], [-121.45328, 38.68206], [-121.45329, 38.6821], [-121.45322, 38.68215], [-121.45287, 38.68277], [-121.45279, 38.68291], [-121.45262, 38.68342], [-121.45227, 38.68342], [-121.45228, 38.68335], [-121.45251, 38.68275], [-121.45281, 38.68221], [-121.45299, 38.68181], [-121.45293, 38.68113], [-121.45268, 38.68058], [-121.45232, 38.68024], [-121.4516, 38.68023], [-121.45174, 38.68093], [-121.45168, 38.68135], [-121.45132, 38.68204], [-121.45108, 38.68204], [-121.45108, 38.68374], [-121.45041, 38.68375], [-121.4504, 38.68376], [-121.45019, 38.68376], [-121.44998, 38.68378], [-121.44761, 38.68376], [-121.44761, 38.68412], [-121.44866, 38.68412], [-121.44865, 38.68562], [-121.44847, 38.68573], [-121.44781, 38.68606], [-121.44729, 38.68642], [-121.44728, 38.68062], [-121.44629, 38.68061], [-121.44629, 38.68017], [-121.44592, 38.68016], [-121.44592, 38.68009], [-121.44595, 38.68008], [-121.44598, 38.68001], [-121.44609, 38.68005], [-121.44632, 38.68005], [-121.44661, 38.68009], [-121.44728, 38.67919], [-121.44726, 38.66936], [-121.44761, 38.66934], [-121.45314, 38.66939], [-121.45374, 38.6701], [-121.45224, 38.67009], [-121.45223, 38.6712], [-121.44761, 38.67116], [-121.44761, 38.67527], [-121.44819, 38.67476], [-121.45221, 38.6748], [-121.45222, 38.67302], [-121.45527, 38.67304]]], [[[-121.44427, 38.68613], [-121.44224, 38.68776], [-121.44166, 38.68732], [-121.44115, 38.68772], [-121.44115, 38.68774], [-121.44173, 38.68818], [-121.44147, 38.68838], [-121.44089, 38.68794], [-121.44113, 38.68774], [-121.44113, 38.68772], [-121.43843, 38.68768], [-121.43843, 38.68743], [-121.43847, 38.68742], [-121.43847, 38.68713], [-121.43894, 38.68713], [-121.44088, 38.68632], [-121.44218, 38.68731], [-121.44396, 38.6859], [-121.44427, 38.68613]]], [[[-121.44687, 38.68673], [-121.44621, 38.68862], [-121.44608, 38.68884], [-121.44574, 38.68894], [-121.44458, 38.68912], [-121.4426, 38.68764], [-121.44526, 38.68548], [-121.44687, 38.68673]]], [[[-121.44045, 38.68921], [-121.44021, 38.6894], [-121.43963, 38.68895], [-121.43986, 38.68877], [-121.44045, 38.68921]]], [[[-121.44203, 38.68932], [-121.44163, 38.68953], [-121.44094, 38.68901], [-121.44128, 38.68874], [-121.44203, 38.68932]]], [[[-121.43822, 38.68724], [-121.43822, 38.69228], [-121.43819, 38.69228], [-121.43819, 38.69233], [-121.43722, 38.69239], [-121.43717, 38.69191], [-121.43639, 38.69196], [-121.4364, 38.69218], [-121.43615, 38.69221], [-121.43615, 38.6923], [-121.43591, 38.69238], [-121.43611, 38.69267], [-121.43716, 38.69245], [-121.43743, 38.69241], [-121.43819, 38.69238], [-121.43819, 38.6927], [-121.43768, 38.69278], [-121.4371, 38.69282], [-121.43691, 38.69289], [-121.43672, 38.69293], [-121.4365, 38.69302], [-121.43632, 38.69305], [-121.43569, 38.69313], [-121.43511, 38.69314], [-121.43482, 38.69317], [-121.43449, 38.69327], [-121.43418, 38.69341], [-121.43395, 38.6936], [-121.43372, 38.69382], [-121.43324, 38.69405], [-121.43317, 38.69418], [-121.43302, 38.69425], [-121.43289, 38.69438], [-121.43253, 38.69458], [-121.4325, 38.69478], [-121.43216, 38.69516], [-121.432, 38.69522], [-121.43185, 38.69546], [-121.43168, 38.69615], [-121.43136, 38.69636], [-121.42932, 38.698], [-121.42212, 38.69792], [-121.42285, 38.69762], [-121.42348, 38.69742], [-121.42416, 38.69726], [-121.42508, 38.6971], [-121.42564, 38.69695], [-121.4259, 38.69686], [-121.42623, 38.69671], [-121.42667, 38.69649], [-121.42699, 38.6963], [-121.42728, 38.69608], [-121.42767, 38.69571], [-121.42788, 38.69543], [-121.42809, 38.69523], [-121.42833, 38.69495], [-121.42851, 38.69472], [-121.42865, 38.6945], [-121.42879, 38.69433], [-121.42938, 38.69378], [-121.4297, 38.69341], [-121.42989, 38.69315], [-121.43006, 38.69288], [-121.43025, 38.69248], [-121.43034, 38.69217], [-121.43052, 38.69186], [-121.43072, 38.69145], [-121.4308, 38.69134], [-121.43088, 38.69127], [-121.43103, 38.69119], [-121.43142, 38.69107], [-121.43168, 38.69095], [-121.43221, 38.69094], [-121.43283, 38.69085], [-121.43319, 38.69081], [-121.43345, 38.69053], [-121.43377, 38.69038], [-121.43406, 38.69036], [-121.43432, 38.69027], [-121.43462, 38.69007], [-121.43497, 38.68973], [-121.43525, 38.68936], [-121.43549, 38.68891], [-121.43557, 38.68881], [-121.4357, 38.68869], [-121.4359, 38.68854], [-121.43608, 38.68844], [-121.43635, 38.68825], [-121.43669, 38.68806], [-121.43686, 38.68792], [-121.43705, 38.68782], [-121.43788, 38.68725], [-121.43819, 38.68707], [-121.43819, 38.68724], [-121.43822, 38.68724]]], [[[-121.42895, 38.69816], [-121.42895, 38.69827], [-121.42771, 38.69913], [-121.42726, 38.69934], [-121.4268, 38.69949], [-121.42679, 38.69971], [-121.42472, 38.70032], [-121.42453, 38.70043], [-121.42414, 38.70056], [-121.42307, 38.70106], [-121.42281, 38.70097], [-121.42215, 38.70131], [-121.42194, 38.70135], [-121.42179, 38.70141], [-121.42169, 38.70148], [-121.42149, 38.70167], [-121.42125, 38.7018], [-121.42108, 38.70186], [-121.42032, 38.702], [-121.41984, 38.70217], [-121.41983, 38.70339], [-121.41905, 38.7034], [-121.41902, 38.70361], [-121.41822, 38.70358], [-121.41819, 38.70399], [-121.41799, 38.70411], [-121.41777, 38.70426], [-121.41773, 38.70439], [-121.41772, 38.70452], [-121.41805, 38.70469], [-121.41826, 38.70473], [-121.4171, 38.70473], [-121.41631, 38.70551], [-121.4151, 38.706], [-121.41446, 38.70719], [-121.41448, 38.70789], [-121.41438, 38.70818], [-121.41368, 38.70863], [-121.41304, 38.70897], [-121.41165, 38.70945], [-121.41083, 38.70986], [-121.41083, 38.70947], [-121.41147, 38.70911], [-121.41284, 38.70864], [-121.41402, 38.70801], [-121.41417, 38.70784], [-121.41404, 38.70739], [-121.41435, 38.70663], [-121.41485, 38.70577], [-121.41611, 38.70523], [-121.41661, 38.70474], [-121.41195, 38.70471], [-121.41294, 38.70372], [-121.41291, 38.70359], [-121.41408, 38.7031], [-121.4156, 38.70228], [-121.41718, 38.70182], [-121.41774, 38.70158], [-121.41895, 38.70051], [-121.41982, 38.69953], [-121.41982, 38.69806], [-121.42895, 38.69816]]], [[[-121.40388, 38.71424], [-121.40327, 38.71424], [-121.40325, 38.71411], [-121.40335, 38.71383], [-121.40359, 38.71358], [-121.40377, 38.71331], [-121.40377, 38.71302], [-121.4037, 38.71278], [-121.40377, 38.71253], [-121.40387, 38.71253], [-121.40388, 38.71424]]], [[[-121.41101, 38.72869], [-121.4054, 38.72873], [-121.40539, 38.72888], [-121.39797, 38.7289], [-121.39502, 38.72871], [-121.39502, 38.72751], [-121.39442, 38.72751], [-121.39389, 38.72696], [-121.39389, 38.72684], [-121.3945, 38.72685], [-121.39484, 38.72695], [-121.39505, 38.72695], [-121.39575, 38.72665], [-121.39589, 38.72634], [-121.39601, 38.72632], [-121.39612, 38.72647], [-121.3963, 38.72646], [-121.39638, 38.72613], [-121.39656, 38.72613], [-121.39649, 38.72585], [-121.39652, 38.7257], [-121.3971, 38.72568], [-121.3972, 38.72557], [-121.39721, 38.72534], [-121.3973, 38.72525], [-121.39745, 38.72477], [-121.39758, 38.72469], [-121.39757, 38.72468], [-121.39705, 38.72468], [-121.39831, 38.72412], [-121.39832, 38.72337], [-121.3985, 38.72336], [-121.39858, 38.72253], [-121.39937, 38.72148], [-121.40018, 38.72031], [-121.40032, 38.7188], [-121.40025, 38.71827], [-121.40025, 38.71744], [-121.40099, 38.71584], [-121.401, 38.7145], [-121.40329, 38.71451], [-121.4033, 38.71447], [-121.40513, 38.71447], [-121.40514, 38.71451], [-121.40531, 38.71451], [-121.40532, 38.71624], [-121.40516, 38.71628], [-121.40518, 38.71707], [-121.40524, 38.71729], [-121.4065, 38.72098], [-121.41095, 38.72093], [-121.41101, 38.72869]], [[-121.40537, 38.72714], [-121.40541, 38.72708], [-121.40541, 38.72706], [-121.40302, 38.72705], [-121.40297, 38.72795], [-121.40296, 38.72804], [-121.40285, 38.72832], [-121.40285, 38.72846], [-121.40325, 38.72847], [-121.40367, 38.72853], [-121.40397, 38.72853], [-121.40426, 38.72847], [-121.40453, 38.72837], [-121.40476, 38.72822], [-121.40495, 38.72804], [-121.40508, 38.72783], [-121.40519, 38.72745], [-121.40524, 38.72732], [-121.4053, 38.72727], [-121.40537, 38.72714]], [[-121.40477, 38.72424], [-121.40476, 38.72362], [-121.40396, 38.72365], [-121.40398, 38.72355], [-121.4038, 38.72355], [-121.40389, 38.72287], [-121.404, 38.72287], [-121.40403, 38.72266], [-121.40453, 38.72265], [-121.40454, 38.7224], [-121.40384, 38.72237], [-121.40374, 38.72319], [-121.40333, 38.72316], [-121.40332, 38.72324], [-121.40166, 38.72311], [-121.40133, 38.72506], [-121.40307, 38.72516], [-121.40319, 38.72497], [-121.40336, 38.72478], [-121.40347, 38.72462], [-121.4036, 38.72438], [-121.4036, 38.72424], [-121.40399, 38.72424], [-121.40391, 38.72497], [-121.40519, 38.72504], [-121.40521, 38.72425], [-121.40477, 38.72424]]]]} | Open Access 1 | 21416 | Dry Creek Parkway | 9979 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.regionalparks.saccounty.net/Parks/RegionalParksDetails/Pages/DryCreekParkway.aspx | Sacramento 41 | 749.749 | Dry Creek Parkway | 0 | Local Recreation Area 3 | 4 |
11151 | 11151 | 11150 | {"type": "Polygon", "coordinates": [[[-121.20538, 38.65866], [-121.20428, 38.65916], [-121.20345, 38.65918], [-121.20385, 38.65822], [-121.20389, 38.65804], [-121.20397, 38.65732], [-121.20401, 38.65732], [-121.20406, 38.65728], [-121.20459, 38.65729], [-121.2053, 38.65726], [-121.20538, 38.65866]]]} | Open Access 1 | 21446 | Orangevale Recreation/park Dist | 23182 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.364 | Orangevale Rec./park Dist | 0 | Local Recreation Area 3 | 4 | |
11398 | 11398 | 11397 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | 22206 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.065 | Sunrise Rec./parks District | 0 | Local Recreation Area 3 | 4 | |
11404 | 11404 | 11403 | {"type": "MultiPolygon", "coordinates": [[[[-121.34337, 38.42102], [-121.34299, 38.42102], [-121.34294, 38.42105], [-121.34288, 38.42102], [-121.34281, 38.42101], [-121.34231, 38.4211], [-121.34215, 38.42109], [-121.34206, 38.42113], [-121.342, 38.4211], [-121.34169, 38.42116], [-121.34132, 38.42126], [-121.3413, 38.42129], [-121.34121, 38.42128], [-121.34114, 38.42132], [-121.34111, 38.42138], [-121.34083, 38.42138], [-121.34065, 38.42153], [-121.34024, 38.4216], [-121.34023, 38.42183], [-121.34015, 38.42182], [-121.34007, 38.42185], [-121.34002, 38.4218], [-121.33939, 38.42179], [-121.3394, 38.42127], [-121.33946, 38.42122], [-121.3397, 38.42118], [-121.34181, 38.42062], [-121.34197, 38.42062], [-121.34204, 38.42059], [-121.34208, 38.42054], [-121.34214, 38.42056], [-121.34244, 38.42056], [-121.34275, 38.42053], [-121.34281, 38.4205], [-121.34286, 38.42054], [-121.34293, 38.42055], [-121.34306, 38.42053], [-121.34331, 38.42053], [-121.34337, 38.42056], [-121.34338, 38.42059], [-121.34337, 38.42102]]], [[[-121.348, 38.42339], [-121.34793, 38.42339], [-121.34784, 38.42349], [-121.34725, 38.42351], [-121.34725, 38.42321], [-121.3472, 38.42317], [-121.34724, 38.42314], [-121.34726, 38.42308], [-121.34723, 38.42298], [-121.34722, 38.42258], [-121.34717, 38.42232], [-121.34709, 38.42212], [-121.34692, 38.42185], [-121.34667, 38.42158], [-121.34663, 38.42151], [-121.34658, 38.42147], [-121.3465, 38.42146], [-121.3465, 38.4214], [-121.34617, 38.4212], [-121.34574, 38.42108], [-121.34568, 38.42111], [-121.34564, 38.42107], [-121.34555, 38.42106], [-121.34546, 38.42107], [-121.34521, 38.42105], [-121.34422, 38.42105], [-121.34408, 38.42102], [-121.34398, 38.42106], [-121.34393, 38.42102], [-121.34355, 38.42102], [-121.34357, 38.41969], [-121.34366, 38.41886], [-121.3437, 38.41882], [-121.34376, 38.4188], [-121.34483, 38.4188], [-121.34482, 38.42053], [-121.34515, 38.42053], [-121.3452, 38.42049], [-121.34531, 38.42053], [-121.34542, 38.42051], [-121.34561, 38.42052], [-121.34588, 38.42056], [-121.34599, 38.4206], [-121.34605, 38.42059], [-121.34612, 38.42056], [-121.34617, 38.42059], [-121.34656, 38.42078], [-121.34687, 38.42084], [-121.34691, 38.42094], [-121.34697, 38.42104], [-121.34705, 38.42113], [-121.34715, 38.42122], [-121.34737, 38.42134], [-121.34765, 38.42141], [-121.34769, 38.42143], [-121.34772, 38.42147], [-121.34773, 38.42167], [-121.34778, 38.42186], [-121.34795, 38.42229], [-121.348, 38.42247], [-121.34802, 38.42262], [-121.34802, 38.42291], [-121.348, 38.42302], [-121.348, 38.42339]]], [[[-121.3531, 38.42257], [-121.35311, 38.42341], [-121.35308, 38.42346], [-121.35302, 38.42348], [-121.35198, 38.42348], [-121.35198, 38.42332], [-121.35204, 38.42312], [-121.35213, 38.42298], [-121.35228, 38.42282], [-121.35243, 38.42272], [-121.35265, 38.42263], [-121.35289, 38.42258], [-121.3531, 38.42257]]], [[[-121.36834, 38.41988], [-121.36825, 38.41988], [-121.36759, 38.41811], [-121.36706, 38.41799], [-121.36678, 38.41806], [-121.3666, 38.41807], [-121.36657, 38.41802], [-121.36652, 38.41797], [-121.36645, 38.41795], [-121.36637, 38.41796], [-121.36628, 38.4178], [-121.36371, 38.41719], [-121.36245, 38.41682], [-121.36183, 38.41627], [-121.36165, 38.41627], [-121.35967, 38.41682], [-121.35955, 38.41693], [-121.35946, 38.41691], [-121.35936, 38.41693], [-121.35926, 38.41701], [-121.35892, 38.41715], [-121.35854, 38.41733], [-121.35817, 38.41754], [-121.35779, 38.41778], [-121.35768, 38.41782], [-121.35763, 38.41786], [-121.35762, 38.41792], [-121.35763, 38.41798], [-121.35766, 38.41802], [-121.35718, 38.41834], [-121.35717, 38.41841], [-121.35709, 38.41842], [-121.35705, 38.41845], [-121.35703, 38.41849], [-121.35703, 38.41854], [-121.35706, 38.41859], [-121.3571, 38.41861], [-121.35694, 38.41884], [-121.35691, 38.41931], [-121.35684, 38.41932], [-121.35679, 38.41937], [-121.35678, 38.41943], [-121.35681, 38.41948], [-121.35673, 38.41953], [-121.35653, 38.42003], [-121.35645, 38.42003], [-121.35638, 38.42006], [-121.3563, 38.42018], [-121.35614, 38.42031], [-121.35594, 38.42043], [-121.35582, 38.42054], [-121.35533, 38.42139], [-121.3552, 38.42149], [-121.35518, 38.42153], [-121.35518, 38.42157], [-121.35512, 38.42159], [-121.35495, 38.42184], [-121.35563, 38.42207], [-121.35612, 38.42336], [-121.35363, 38.42338], [-121.35357, 38.42336], [-121.35353, 38.4233], [-121.35332, 38.42353], [-121.35324, 38.4163], [-121.3563, 38.41629], [-121.35595, 38.41801], [-121.35597, 38.41802], [-121.35628, 38.41799], [-121.35705, 38.41727], [-121.35779, 38.417], [-121.35794, 38.41628], [-121.35944, 38.41627], [-121.35944, 38.41534], [-121.36041, 38.41535], [-121.36095, 38.4153], [-121.36196, 38.41542], [-121.36268, 38.41542], [-121.36362, 38.4161], [-121.36457, 38.4166], [-121.3658, 38.41631], [-121.36584, 38.41638], [-121.36592, 38.41642], [-121.36601, 38.41641], [-121.36608, 38.41637], [-121.36733, 38.41717], [-121.36834, 38.41988]]], [[[-121.35312, 38.42382], [-121.35203, 38.42429], [-121.35182, 38.42415], [-121.35182, 38.42407], [-121.35185, 38.42393], [-121.35182, 38.42379], [-121.35182, 38.42368], [-121.35192, 38.42365], [-121.35295, 38.42366], [-121.3531, 38.4237], [-121.35312, 38.42382]]], [[[-121.35447, 38.42365], [-121.3538, 38.42377], [-121.3536, 38.42387], [-121.35346, 38.424], [-121.35337, 38.42417], [-121.35334, 38.42437], [-121.35328, 38.42467], [-121.35327, 38.42374], [-121.35332, 38.42367], [-121.35337, 38.42365], [-121.35373, 38.42365], [-121.35373, 38.42367], [-121.35374, 38.42369], [-121.35387, 38.42365], [-121.35447, 38.42365]]], [[[-121.37599, 38.43282], [-121.37587, 38.43303], [-121.37545, 38.4329], [-121.37505, 38.43271], [-121.37466, 38.43242], [-121.37452, 38.4323], [-121.37425, 38.43221], [-121.37404, 38.43224], [-121.37392, 38.43231], [-121.37383, 38.4324], [-121.37353, 38.43288], [-121.37343, 38.43262], [-121.37365, 38.4321], [-121.37447, 38.43205], [-121.37528, 38.43261], [-121.37599, 38.43282]]], [[[-121.38109, 38.43438], [-121.38073, 38.43439], [-121.38069, 38.43442], [-121.38059, 38.43441], [-121.38052, 38.43444], [-121.38045, 38.43437], [-121.37978, 38.43427], [-121.37971, 38.43428], [-121.37967, 38.43423], [-121.37961, 38.4342], [-121.37959, 38.43407], [-121.37926, 38.43394], [-121.37886, 38.43384], [-121.37883, 38.43378], [-121.37877, 38.43374], [-121.37869, 38.43374], [-121.37861, 38.43378], [-121.37852, 38.43372], [-121.37828, 38.43363], [-121.37828, 38.43358], [-121.37788, 38.43349], [-121.37745, 38.43332], [-121.377, 38.43319], [-121.37689, 38.43317], [-121.37687, 38.43331], [-121.37669, 38.43318], [-121.37659, 38.43314], [-121.37606, 38.43309], [-121.37615, 38.43292], [-121.38002, 38.43402], [-121.38039, 38.43422], [-121.38109, 38.43426], [-121.38109, 38.43438]]], [[[-121.41743, 38.43574], [-121.41727, 38.43566], [-121.41709, 38.43562], [-121.4169, 38.4356], [-121.41666, 38.4356], [-121.41648, 38.43558], [-121.41633, 38.43553], [-121.41618, 38.43546], [-121.41606, 38.43536], [-121.41595, 38.43523], [-121.41588, 38.43507], [-121.41586, 38.43493], [-121.41553, 38.43459], [-121.41522, 38.43433], [-121.41495, 38.43413], [-121.41461, 38.43392], [-121.41431, 38.43377], [-121.414, 38.43369], [-121.41371, 38.43364], [-121.41284, 38.43361], [-121.4124, 38.43356], [-121.41197, 38.43348], [-121.41143, 38.43333], [-121.41108, 38.43327], [-121.41084, 38.43325], [-121.41061, 38.43326], [-121.41037, 38.4333], [-121.4101, 38.43332], [-121.40989, 38.43329], [-121.40948, 38.43318], [-121.40872, 38.43309], [-121.40871, 38.43284], [-121.40795, 38.43275], [-121.40774, 38.43271], [-121.4074, 38.43258], [-121.40713, 38.43241], [-121.40647, 38.4334], [-121.40637, 38.43328], [-121.40593, 38.43262], [-121.4058, 38.43249], [-121.40568, 38.43238], [-121.40547, 38.43224], [-121.40526, 38.43214], [-121.40501, 38.43205], [-121.40472, 38.432], [-121.40388, 38.4319], [-121.40366, 38.4319], [-121.40339, 38.43193], [-121.4031, 38.432], [-121.40291, 38.43207], [-121.40205, 38.43255], [-121.40186, 38.43263], [-121.40166, 38.43269], [-121.40136, 38.43274], [-121.40109, 38.43275], [-121.40076, 38.43272], [-121.40049, 38.43266], [-121.40027, 38.43258], [-121.40005, 38.43246], [-121.39985, 38.43231], [-121.3997, 38.43216], [-121.39909, 38.43082], [-121.39895, 38.4304], [-121.39889, 38.43028], [-121.39889, 38.43024], [-121.39894, 38.4302], [-121.39927, 38.43011], [-121.39945, 38.43008], [-121.39956, 38.43031], [-121.39998, 38.43046], [-121.40079, 38.43023], [-121.40086, 38.43003], [-121.40075, 38.4298], [-121.40226, 38.42939], [-121.40232, 38.42959], [-121.40265, 38.42973], [-121.40275, 38.42992], [-121.4029, 38.43015], [-121.40322, 38.43015], [-121.40345, 38.43013], [-121.40367, 38.42993], [-121.40378, 38.42988], [-121.40429, 38.42997], [-121.40434, 38.43003], [-121.40442, 38.43006], [-121.40455, 38.43005], [-121.40473, 38.43006], [-121.40497, 38.43009], [-121.40554, 38.43028], [-121.40589, 38.43034], [-121.40603, 38.43041], [-121.40612, 38.43042], [-121.40621, 38.43039], [-121.40622, 38.43053], [-121.40655, 38.4306], [-121.40692, 38.43073], [-121.40777, 38.43114], [-121.40837, 38.43145], [-121.40872, 38.4315], [-121.40873, 38.43149], [-121.40874, 38.43084], [-121.41306, 38.43081], [-121.4173, 38.43327], [-121.4173, 38.43363], [-121.41743, 38.43512], [-121.41743, 38.43574]]], [[[-121.39814, 38.43322], [-121.39812, 38.43418], [-121.39788, 38.43417], [-121.39764, 38.43408], [-121.39736, 38.43403], [-121.39681, 38.43401], [-121.3968, 38.43398], [-121.39409, 38.43397], [-121.39409, 38.43348], [-121.39232, 38.43347], [-121.39231, 38.43627], [-121.39217, 38.43648], [-121.39186, 38.43656], [-121.39189, 38.43319], [-121.39814, 38.43322]]], [[[-121.42456, 38.43799], [-121.42243, 38.438], [-121.41963, 38.43674], [-121.41945, 38.43662], [-121.41932, 38.43649], [-121.4192, 38.43633], [-121.41912, 38.43618], [-121.41788, 38.43618], [-121.41786, 38.43448], [-121.42043, 38.43446], [-121.42019, 38.43274], [-121.42042, 38.43274], [-121.42044, 38.43341], [-121.42056, 38.43409], [-121.4209, 38.43413], [-121.42089, 38.43432], [-121.42085, 38.43448], [-121.42081, 38.43479], [-121.42098, 38.43539], [-121.42307, 38.43538], [-121.42376, 38.4356], [-121.42396, 38.43652], [-121.42446, 38.4374], [-121.42456, 38.43787], [-121.42456, 38.43799]], [[-121.42126, 38.43616], [-121.42075, 38.43588], [-121.42074, 38.43589], [-121.42073, 38.43617], [-121.42028, 38.43617], [-121.42027, 38.43618], [-121.42083, 38.43649], [-121.42209, 38.43706], [-121.42322, 38.43761], [-121.42346, 38.43769], [-121.42322, 38.43705], [-121.42313, 38.43693], [-121.42297, 38.4368], [-121.42286, 38.43673], [-121.42271, 38.43668], [-121.42254, 38.43664], [-121.42241, 38.43662], [-121.42204, 38.43647], [-121.4216, 38.43634], [-121.42126, 38.43616]]]]} | Open Access 1 | 22184 | Laguna Creek Parkway | 20850 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 248.446 | Laguna Creek Parkway | 0 | Local Recreation Area 3 | 4 | |
12673 | 12673 | 12672 | {"type": "Polygon", "coordinates": [[[-121.09228, 38.49266], [-121.09217, 38.49275], [-121.09165, 38.49255], [-121.09152, 38.49227], [-121.09165, 38.49217], [-121.09228, 38.49266]]]} | Open Access 1 | 29637 | Cosumnes River Parkway | 17676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.435 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
15700 | 15700 | 15699 | {"type": "MultiPolygon", "coordinates": [[[[-121.39794, 38.718], [-121.39794, 38.71803], [-121.39732, 38.718], [-121.39658, 38.71802], [-121.39577, 38.71793], [-121.39554, 38.71792], [-121.39551, 38.71787], [-121.39552, 38.71785], [-121.39555, 38.71784], [-121.39583, 38.71783], [-121.39606, 38.71779], [-121.39641, 38.71779], [-121.39656, 38.7178], [-121.39671, 38.71785], [-121.39676, 38.7179], [-121.39686, 38.71795], [-121.39728, 38.71796], [-121.39737, 38.71794], [-121.39749, 38.71784], [-121.39758, 38.71779], [-121.3976, 38.71781], [-121.39758, 38.71783], [-121.39748, 38.71789], [-121.39744, 38.71795], [-121.39783, 38.71794], [-121.39783, 38.71791], [-121.39779, 38.71786], [-121.39778, 38.71783], [-121.39781, 38.71782], [-121.39785, 38.71784], [-121.39789, 38.71788], [-121.39794, 38.718]]], [[[-121.39618, 38.71991], [-121.39616, 38.72016], [-121.39605, 38.72016], [-121.39597, 38.72018], [-121.39591, 38.72022], [-121.39584, 38.72035], [-121.3958, 38.72036], [-121.39565, 38.72036], [-121.39555, 38.7204], [-121.39556, 38.72018], [-121.39566, 38.72015], [-121.39571, 38.72], [-121.39583, 38.71988], [-121.39595, 38.71984], [-121.39608, 38.71986], [-121.39618, 38.71991]]], [[[-121.39818, 38.72268], [-121.39814, 38.72274], [-121.39806, 38.72275], [-121.39799, 38.72272], [-121.39741, 38.72221], [-121.39721, 38.72206], [-121.39692, 38.72206], [-121.39681, 38.72208], [-121.39667, 38.72208], [-121.39636, 38.72209], [-121.3963, 38.72213], [-121.39624, 38.72223], [-121.39618, 38.72225], [-121.39614, 38.72225], [-121.39614, 38.72214], [-121.39627, 38.72204], [-121.39642, 38.722], [-121.39678, 38.72199], [-121.397, 38.72193], [-121.39712, 38.72193], [-121.39716, 38.7219], [-121.39732, 38.72192], [-121.39736, 38.72188], [-121.39735, 38.7218], [-121.3974, 38.7218], [-121.39766, 38.72198], [-121.39765, 38.72205], [-121.39772, 38.72225], [-121.39781, 38.72236], [-121.39793, 38.72246], [-121.39806, 38.72253], [-121.39815, 38.72262], [-121.39818, 38.72268]]], [[[-121.39707, 38.71962], [-121.39706, 38.71979], [-121.39699, 38.71992], [-121.39686, 38.72003], [-121.3967, 38.7201], [-121.39652, 38.72011], [-121.39623, 38.7201], [-121.39627, 38.71989], [-121.39643, 38.71978], [-121.39654, 38.71961], [-121.39661, 38.71955], [-121.39665, 38.71954], [-121.39669, 38.71956], [-121.3967, 38.71969], [-121.39676, 38.71971], [-121.39683, 38.71966], [-121.39686, 38.71961], [-121.3969, 38.7196], [-121.39707, 38.71962]]], [[[-121.39714, 38.72282], [-121.39707, 38.72291], [-121.39709, 38.72297], [-121.39705, 38.72298], [-121.39697, 38.72297], [-121.39696, 38.72294], [-121.39698, 38.72291], [-121.39703, 38.72287], [-121.39705, 38.7228], [-121.39711, 38.72278], [-121.39714, 38.72282]]], [[[-121.39748, 38.71779], [-121.39746, 38.71783], [-121.39735, 38.71791], [-121.39728, 38.71789], [-121.39722, 38.7178], [-121.3973, 38.71778], [-121.39748, 38.71779]]], [[[-121.39777, 38.72167], [-121.39772, 38.72182], [-121.39774, 38.72194], [-121.39773, 38.72196], [-121.39751, 38.72182], [-121.39744, 38.72169], [-121.39747, 38.72165], [-121.39749, 38.72157], [-121.39747, 38.72152], [-121.39743, 38.72147], [-121.39759, 38.72147], [-121.39758, 38.72153], [-121.39763, 38.72157], [-121.39766, 38.72157], [-121.3977, 38.7215], [-121.39772, 38.72151], [-121.39777, 38.72167]]], [[[-121.39838, 38.7181], [-121.39828, 38.71814], [-121.39808, 38.71811], [-121.39802, 38.71806], [-121.39799, 38.71795], [-121.39803, 38.71791], [-121.3982, 38.71785], [-121.39827, 38.71781], [-121.39836, 38.71786], [-121.39833, 38.71791], [-121.39838, 38.7181]], [[-121.39827, 38.71793], [-121.39823, 38.71793], [-121.3981, 38.71799], [-121.39807, 38.71801], [-121.39808, 38.71804], [-121.39814, 38.71808], [-121.39829, 38.71808], [-121.3983, 38.71806], [-121.3983, 38.71802], [-121.39827, 38.71793]]], [[[-121.39856, 38.71876], [-121.39851, 38.71878], [-121.39844, 38.71876], [-121.39837, 38.71876], [-121.39836, 38.71877], [-121.39837, 38.71878], [-121.39847, 38.71879], [-121.39849, 38.7188], [-121.39849, 38.71882], [-121.39834, 38.71882], [-121.39826, 38.71884], [-121.39821, 38.71882], [-121.39814, 38.71876], [-121.39799, 38.71874], [-121.39799, 38.71871], [-121.39807, 38.71868], [-121.39808, 38.71864], [-121.39807, 38.71857], [-121.3981, 38.71854], [-121.39828, 38.71856], [-121.39835, 38.71854], [-121.39841, 38.71868], [-121.39856, 38.71873], [-121.39856, 38.71876]]], [[[-121.39831, 38.71842], [-121.3983, 38.71845], [-121.39827, 38.71847], [-121.39812, 38.71846], [-121.39806, 38.71841], [-121.39809, 38.71835], [-121.39812, 38.71833], [-121.39817, 38.71832], [-121.39825, 38.71834], [-121.39831, 38.71842]]], [[[-121.39929, 38.71634], [-121.3993, 38.7164], [-121.39929, 38.7165], [-121.39912, 38.71679], [-121.39902, 38.7169], [-121.39895, 38.71708], [-121.39891, 38.71713], [-121.39875, 38.71725], [-121.3987, 38.7173], [-121.39851, 38.71762], [-121.3985, 38.71769], [-121.39844, 38.71774], [-121.3984, 38.7178], [-121.39832, 38.71779], [-121.39832, 38.71776], [-121.3984, 38.7176], [-121.39865, 38.71724], [-121.39869, 38.71712], [-121.39881, 38.71706], [-121.39899, 38.71683], [-121.39904, 38.7168], [-121.39918, 38.71658], [-121.39922, 38.71649], [-121.39924, 38.71633], [-121.39929, 38.71634]]], [[[-121.39855, 38.71891], [-121.39854, 38.71895], [-121.39849, 38.71897], [-121.39844, 38.71895], [-121.39837, 38.71895], [-121.39834, 38.71892], [-121.39836, 38.71889], [-121.3985, 38.71887], [-121.39852, 38.71887], [-121.39855, 38.71891]]], [[[-121.399, 38.71916], [-121.39899, 38.7193], [-121.39893, 38.71943], [-121.39888, 38.71974], [-121.39877, 38.72018], [-121.39878, 38.72047], [-121.39876, 38.72053], [-121.39867, 38.72068], [-121.39863, 38.72089], [-121.39857, 38.72103], [-121.39855, 38.72112], [-121.3985, 38.72116], [-121.39845, 38.72114], [-121.39842, 38.72111], [-121.39842, 38.72097], [-121.39847, 38.72082], [-121.3985, 38.72065], [-121.39847, 38.7206], [-121.39853, 38.72028], [-121.39864, 38.71992], [-121.39871, 38.71981], [-121.3988, 38.71951], [-121.39879, 38.71916], [-121.39885, 38.71911], [-121.39894, 38.71911], [-121.399, 38.71916]]], [[[-121.40081, 38.71464], [-121.40058, 38.71479], [-121.40051, 38.71481], [-121.40037, 38.71487], [-121.40032, 38.71491], [-121.40027, 38.71504], [-121.4002, 38.71514], [-121.39991, 38.71531], [-121.3999, 38.71535], [-121.40001, 38.71548], [-121.39996, 38.71553], [-121.39964, 38.71561], [-121.39948, 38.71568], [-121.39943, 38.71572], [-121.39939, 38.71579], [-121.39938, 38.71583], [-121.39939, 38.71588], [-121.39952, 38.71594], [-121.39954, 38.71599], [-121.39951, 38.71607], [-121.39939, 38.71624], [-121.39933, 38.71628], [-121.39928, 38.71625], [-121.39927, 38.71623], [-121.39943, 38.71603], [-121.3994, 38.71598], [-121.39927, 38.71596], [-121.39924, 38.71594], [-121.39922, 38.7159], [-121.39923, 38.7158], [-121.39939, 38.71563], [-121.3995, 38.71556], [-121.39981, 38.7155], [-121.39985, 38.71546], [-121.39972, 38.71525], [-121.39962, 38.71525], [-121.39965, 38.71522], [-121.3997, 38.71521], [-121.39969, 38.71515], [-121.39971, 38.71513], [-121.39977, 38.71509], [-121.40009, 38.71507], [-121.40012, 38.71504], [-121.40018, 38.7149], [-121.40026, 38.71479], [-121.40037, 38.71472], [-121.40055, 38.71466], [-121.40071, 38.71457], [-121.4008, 38.71462], [-121.40081, 38.71464]]], [[[-121.40096, 38.71443], [-121.4009, 38.71456], [-121.40083, 38.71459], [-121.40079, 38.71456], [-121.40079, 38.71453], [-121.40085, 38.71449], [-121.40086, 38.71443], [-121.40096, 38.71443]]]]} | Restricted Access 2 | 21434 | Antelope Greens Golf Course | 28301 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.742 | Antelope Greens GC | 0 | Local Recreation Area 3 | 4 | |
16641 | 16641 | 16640 | {"type": "Polygon", "coordinates": [[[-121.16941, 38.69857], [-121.16888, 38.69857], [-121.16885, 38.69983], [-121.16707, 38.69983], [-121.16698, 38.69882], [-121.16667, 38.69756], [-121.16679, 38.69664], [-121.16671, 38.69636], [-121.16673, 38.69612], [-121.16755, 38.69261], [-121.16755, 38.69204], [-121.16816, 38.692], [-121.16938, 38.69204], [-121.16946, 38.69624], [-121.16941, 38.69857]]]} | Open Access 1 | 22260 | Folsom Lake State Recreation Area | 18970 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 42.957 | Folsom Lake SRA | 1956 | Local Recreation Area 3 | 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]);