units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 138 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 10
- Local Park 43
- Local Other or Unknown 21
- Local Conservation Area 19
- Local Recreation Area 5
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_TYP 4 ✖
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Orange, County of · 95 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1894 | 1894 | 1893 | {"type": "Polygon", "coordinates": [[[-118.08938, 33.73032], [-118.08887, 33.73109], [-118.08653, 33.72956], [-118.08211, 33.72662], [-118.07756, 33.72272], [-118.07496, 33.72052], [-118.07152, 33.71736], [-118.06492, 33.71162], [-118.06543, 33.71158], [-118.0694, 33.71455], [-118.07064, 33.71524], [-118.07147, 33.71563], [-118.07167, 33.71594], [-118.07357, 33.71743], [-118.07588, 33.71905], [-118.07662, 33.71984], [-118.07762, 33.7205], [-118.07884, 33.72184], [-118.07967, 33.72233], [-118.08137, 33.72397], [-118.08275, 33.72511], [-118.08441, 33.72673], [-118.08676, 33.72852], [-118.08938, 33.73032]]]} | Open Access 1 | 14590 | Sunset County Beach | 26043 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 94.025 | Sunset County Beach | 0 | Local Park 2 | 4 | |
2917 | 2917 | 2916 | {"type": "Polygon", "coordinates": [[[-117.97887, 33.74548], [-117.9787, 33.74549], [-117.97867, 33.74567], [-117.97867, 33.74584], [-117.9787, 33.74593], [-117.97872, 33.74606], [-117.97848, 33.74607], [-117.97846, 33.74505], [-117.97886, 33.74505], [-117.97887, 33.74548]]]} | Open Access 1 | 19011 | Roger Stanton Park | 24560 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.748 | Roger Stanton Park | 0 | Local Park 2 | 4 | |
4291 | 4291 | 4290 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | 14646 | Talbert Marsh | 26170 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 34.691 | Talbert Marsh | None 375 | |||
8037 | 8037 | 8036 | {"type": "Polygon", "coordinates": [[[-117.958, 33.63182], [-117.95451, 33.6433], [-117.95349, 33.6469], [-117.95241, 33.65046], [-117.95155, 33.65368], [-117.95038, 33.65777], [-117.95028, 33.65793], [-117.94621, 33.67223], [-117.94617, 33.67255], [-117.94536, 33.67535], [-117.94493, 33.67669], [-117.94386, 33.67968], [-117.94311, 33.68154], [-117.94229, 33.68339], [-117.94154, 33.68494], [-117.94051, 33.68687], [-117.93973, 33.68823], [-117.93913, 33.68922], [-117.93869, 33.68993], [-117.93683, 33.69276], [-117.93581, 33.69429], [-117.93582, 33.69431], [-117.9359, 33.69431], [-117.93313, 33.69845], [-117.92833, 33.70568], [-117.92833, 33.70579], [-117.92731, 33.70727], [-117.92712, 33.70753], [-117.92709, 33.70753], [-117.92639, 33.70861], [-117.92207, 33.7151], [-117.92123, 33.7164], [-117.9211, 33.71664], [-117.92059, 33.71741], [-117.92048, 33.71762], [-117.91981, 33.71877], [-117.91981, 33.71881], [-117.91892, 33.72044], [-117.91825, 33.72178], [-117.91786, 33.72259], [-117.91691, 33.72472], [-117.9162, 33.72648], [-117.91584, 33.72746], [-117.91541, 33.72869], [-117.9144, 33.73232], [-117.91384, 33.73467], [-117.91357, 33.736], [-117.91301, 33.7392], [-117.9128, 33.7403], [-117.91221, 33.74282], [-117.912, 33.74358], [-117.91151, 33.74504], [-117.91144, 33.74517], [-117.91113, 33.74593], [-117.91067, 33.74698], [-117.91005, 33.74823], [-117.90945, 33.74933], [-117.90864, 33.75065], [-117.90789, 33.75177], [-117.90656, 33.75354], [-117.90503, 33.7554], [-117.90226, 33.75865], [-117.90214, 33.75866], [-117.90165, 33.75931], [-117.90048, 33.76105], [-117.90013, 33.76123], [-117.89983, 33.76149], [-117.8997, 33.76164], [-117.89951, 33.76195], [-117.89925, 33.76227], [-117.89894, 33.76261], [-117.89884, 33.76282], [-117.89882, 33.76292], [-117.89863, 33.76327], [-117.89646, 33.76588], [-117.89573, 33.76715], [-117.89556, 33.76716], [-117.8953, 33.7676], [-117.89523, 33.76768], [-117.89431, 33.76867], [-117.89313, 33.76987], [-117.89313, 33.76982], [-117.89312, 33.76982], [-117.89224, 33.77081], [-117.89223, 33.77069], [-117.89222, 33.77069], [-117.8914, 33.77167], [-117.89145, 33.77171], [-117.89009, 33.77404], [-117.88867, 33.77668], [-117.88803, 33.77812], [-117.88599, 33.78204], [-117.88592, 33.78204], [-117.88584, 33.78222], [-117.88555, 33.78272], [-117.88519, 33.78316], [-117.88483, 33.78355], [-117.88466, 33.78368], [-117.88428, 33.78403], [-117.88403, 33.78432], [-117.88373, 33.78477], [-117.88355, 33.78502], [-117.88344, 33.78523], [-117.88341, 33.78534], [-117.88339, 33.78774], [-117.88332, 33.78801], [-117.88249, 33.78996], [-117.88222, 33.79073], [-117.88217, 33.79077], [-117.88156, 33.79234], [-117.88115, 33.79342], [-117.88108, 33.79364], [-117.88107, 33.79376], [-117.88017, 33.796], [-117.87966, 33.79747], [-117.87885, 33.79943], [-117.87873, 33.79956], [-117.87848, 33.79969], [-117.87832, 33.79983], [-117.87795, 33.8005], [-117.87788, 33.80068], [-117.87787, 33.80083], [-117.87788, 33.80096], [-117.87719, 33.80256], [-117.8771, 33.80253], [-117.87701, 33.80268], [-117.87626, 33.80429], [-117.87602, 33.80496], [-117.8759, 33.80535], [-117.87573, 33.80574], [-117.87572, 33.80589], [-117.87535, 33.80653], [-117.87444, 33.80847], [-117.87429, 33.80875], [-117.8742, 33.80882], [-117.87353, 33.81006], [-117.87348, 33.8102], [-117.8732, 33.81072], [-117.87312, 33.81083], [-117.87285, 33.81134], [-117.87278, 33.8116], [-117.87279, 33.81229], [-117.87293, 33.81232], [-117.87362, 33.81232], [-117.87287, 33.81453], [-117.87287, 33.81476], [-117.8729, 33.81518], [-117.87284, 33.81544], [-117.87218, 33.81733], [-117.87207, 33.81755], [-117.87062, 33.82121], [-117.8693, 33.82654], [-117.86844, 33.82875], [-117.86712, 33.83254], [-117.86698, 33.83272], [-117.8659, 33.83586], [-117.86586, 33.8363], [-117.86475, 33.83966], [-117.85966, 33.84293], [-117.85664, 33.84459], [-117.85525, 33.84529], [-117.85407, 33.84582], [-117.85245, 33.8465], [-117.85157, 33.84683], [-117.85077, 33.84711], [-117.85073, 33.84712], [-117.85072, 33.84711], [-117.84188, 33.85001], [-117.84213, 33.84913], [-117.83795, 33.84947], [-117.83756, 33.84952], [-117.83642, 33.84975], [-117.83521, 33.84992], [-117.83521, 33.84994], [-117.83648, 33.8509], [-117.837, 33.85139], [-117.83744, 33.85174], [-117.83743, 33.85184], [-117.83625, 33.85184], [-117.83619, 33.85403], [-117.83603, 33.85403], [-117.83587, 33.85476], [-117.83571, 33.85494], [-117.8354, 33.85511], [-117.83462, 33.85522], [-117.83431, 33.8553], [-117.83387, 33.85545], [-117.83341, 33.85564], [-117.83293, 33.8559], [-117.83224, 33.85645], [-117.83107, 33.85766], [-117.83084, 33.85782], [-117.83056, 33.85794], [-117.83026, 33.85798], [-117.82863, 33.85771], [-117.82849, 33.85826], [-117.82606, 33.85828], [-117.82584, 33.85775], [-117.82324, 33.85776], [-117.82323, 33.85812], [-117.81836, 33.85814], [-117.81835, 33.85815], [-117.81843, 33.85872], [-117.81842, 33.85909], [-117.81826, 33.85909], [-117.8131, 33.85798], [-117.81309, 33.85799], [-117.81309, 33.85805], [-117.81049, 33.8581], [-117.80027, 33.85684], [-117.79073, 33.85799], [-117.79025, 33.85801], [-117.78569, 33.85882], [-117.78515, 33.85893], [-117.78442, 33.8591], [-117.78324, 33.8594], [-117.7823, 33.8597], [-117.7813, 33.86007], [-117.7808, 33.86029], [-117.77812, 33.86158], [-117.77135, 33.86488], [-117.77053, 33.86526], [-117.76967, 33.8657], [-117.76882, 33.8661], [-117.76672, 33.86711], [-117.76628, 33.86734], [-117.76518, 33.86786], [-117.76248, 33.86919], [-117.7611, 33.86982], [-117.75927, 33.87055], [-117.75884, 33.8707], [-117.75782, 33.87105], [-117.75634, 33.87152], [-117.75548, 33.87183], [-117.754, 33.87242], [-117.75219, 33.87321], [-117.75135, 33.87366], [-117.74981, 33.87456], [-117.74964, 33.87468], [-117.74945, 33.87509], [-117.74893, 33.87504], [-117.74868, 33.87569], [-117.74794, 33.87438], [-117.7482, 33.8742], [-117.75061, 33.87276], [-117.75204, 33.87204], [-117.75307, 33.87158], [-117.75429, 33.87107], [-117.75511, 33.87076], [-117.75663, 33.87024], [-117.75847, 33.86967], [-117.76192, 33.86821], [-117.7804, 33.85924], [-117.78223, 33.85854], [-117.78352, 33.85813], [-117.78471, 33.85783], [-117.78572, 33.85763], [-117.78959, 33.85695], [-117.79028, 33.85663], [-117.79138, 33.85661], [-117.79232, 33.85645], [-117.79927, 33.85518], [-117.80152, 33.85486], [-117.80247, 33.85482], [-117.80299, 33.85479], [-117.80328, 33.85476], [-117.80518, 33.85489], [-117.80578, 33.8549], [-117.80615, 33.85488], [-117.80617, 33.85508], [-117.80682, 33.85519], [-117.80926, 33.85575], [-117.80974, 33.85582], [-117.81047, 33.85585], [-117.81182, 33.8558], [-117.81264, 33.8557], [-117.81338, 33.85557], [-117.81435, 33.85536], [-117.81694, 33.85459], [-117.82124, 33.85329], [-117.82318, 33.85261], [-117.82455, 33.85186], [-117.82491, 33.85164], [-117.82755, 33.84997], [-117.83017, 33.84902], [-117.83129, 33.84869], [-117.83416, 33.84798], [-117.83482, 33.84768], [-117.83531, 33.84751], [-117.83579, 33.84743], [-117.83748, 33.8471], [-117.84525, 33.84543], [-117.84527, 33.84551], [-117.84667, 33.84524], [-117.84746, 33.84498], [-117.8486, 33.84465], [-117.84926, 33.84444], [-117.84979, 33.84426], [-117.85089, 33.84386], [-117.85218, 33.84332], [-117.85277, 33.84304], [-117.8546, 33.84208], [-117.85458, 33.84205], [-117.85551, 33.84162], [-117.85923, 33.83895], [-117.8604, 33.83772], [-117.86154, 33.83667], [-117.86217, 33.83533], [-117.86224, 33.83534], [-117.8624, 33.83504], [-117.86241, 33.83432], [-117.86296, 33.83333], [-117.86323, 33.83269], [-117.86342, 33.83216], [-117.86489, 33.82779], [-117.86556, 33.82681], [-117.86569, 33.82649], [-117.86851, 33.81806], [-117.86901, 33.81649], [-117.86929, 33.81567], [-117.86928, 33.81565], [-117.86909, 33.81565], [-117.86999, 33.8131], [-117.87073, 33.81167], [-117.87193, 33.80902], [-117.87199, 33.80901], [-117.87328, 33.80622], [-117.87376, 33.80588], [-117.87375, 33.80537], [-117.87444, 33.80386], [-117.87475, 33.80322], [-117.87552, 33.80169], [-117.87705, 33.79857], [-117.87738, 33.7987], [-117.87827, 33.79681], [-117.87841, 33.7959], [-117.87847, 33.79562], [-117.87875, 33.79468], [-117.87921, 33.79372], [-117.87974, 33.79249], [-117.88021, 33.79112], [-117.88037, 33.791], [-117.88049, 33.79012], [-117.88101, 33.78921], [-117.88131, 33.78873], [-117.8814, 33.78798], [-117.88147, 33.7876], [-117.88148, 33.78698], [-117.88153, 33.78697], [-117.88153, 33.78535], [-117.88158, 33.785], [-117.88167, 33.78469], [-117.88181, 33.78432], [-117.882, 33.784], [-117.88252, 33.78336], [-117.88326, 33.78273], [-117.8835, 33.78247], [-117.88398, 33.78186], [-117.88418, 33.78153], [-117.88418, 33.78049], [-117.8848, 33.78049], [-117.88525, 33.77965], [-117.88579, 33.77854], [-117.8858, 33.77839], [-117.88577, 33.77823], [-117.88713, 33.7756], [-117.88773, 33.77368], [-117.88785, 33.7734], [-117.88846, 33.77289], [-117.88872, 33.77255], [-117.88913, 33.77192], [-117.88929, 33.77151], [-117.88949, 33.77138], [-117.88992, 33.77058], [-117.89017, 33.76993], [-117.88992, 33.76948], [-117.89174, 33.76706], [-117.89302, 33.76519], [-117.8934, 33.76471], [-117.89368, 33.76486], [-117.89696, 33.76234], [-117.89709, 33.7624], [-117.89712, 33.76238], [-117.89742, 33.76251], [-117.89762, 33.76229], [-117.89831, 33.76168], [-117.89893, 33.76094], [-117.89856, 33.76071], [-117.89917, 33.76041], [-117.90267, 33.75622], [-117.90302, 33.75571], [-117.90343, 33.7552], [-117.90422, 33.75428], [-117.90433, 33.75428], [-117.90537, 33.75302], [-117.90613, 33.75205], [-117.90664, 33.75135], [-117.90764, 33.74986], [-117.90818, 33.74898], [-117.9086, 33.74824], [-117.90961, 33.74622], [-117.91009, 33.74511], [-117.91065, 33.74354], [-117.91082, 33.74298], [-117.91099, 33.7424], [-117.91118, 33.74162], [-117.9116, 33.73961], [-117.91215, 33.73649], [-117.91254, 33.73448], [-117.91271, 33.73374], [-117.91305, 33.73238], [-117.91336, 33.73125], [-117.91473, 33.72725], [-117.91502, 33.72724], [-117.91646, 33.72299], [-117.91662, 33.72263], [-117.91756, 33.7207], [-117.91863, 33.7187], [-117.91987, 33.7165], [-117.92103, 33.71469], [-117.9249, 33.70884], [-117.92944, 33.70202], [-117.92959, 33.70177], [-117.93155, 33.69882], [-117.93667, 33.69119], [-117.93666, 33.69117], [-117.93609, 33.69093], [-117.93639, 33.69044], [-117.93695, 33.6896], [-117.9379, 33.68807], [-117.93844, 33.68712], [-117.93935, 33.68548], [-117.9404, 33.68342], [-117.94098, 33.68218], [-117.94175, 33.68041], [-117.94247, 33.67853], [-117.943, 33.67701], [-117.94336, 33.67592], [-117.94375, 33.67459], [-117.94453, 33.67186], [-117.94455, 33.67167], [-117.94451, 33.67145], [-117.94451, 33.67131], [-117.9444, 33.67119], [-117.94442, 33.67113], [-117.94454, 33.67108], [-117.94526, 33.66852], [-117.94686, 33.66245], [-117.94829, 33.65775], [-117.94828, 33.65774], [-117.94797, 33.65774], [-117.94895, 33.65432], [-117.9495, 33.65229], [-117.95, 33.65228], [-117.95044, 33.65129], [-117.95032, 33.65063], [-117.95069, 33.65025], [-117.95264, 33.64375], [-117.95257, 33.6435], [-117.95271, 33.64349], [-117.95276, 33.64333], [-117.95288, 33.64311], [-117.95634, 33.63093], [-117.95649, 33.63099], [-117.95655, 33.63092], [-117.958, 33.63182]]]} | Open Access 1 | 11403 | Santa Ana River Trail | 29296 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.santaanarivertrail.org/home.html | Orange 3 | 1909.063 | Santa Ana River Trail | 0 | Local Recreation Area 3 | 4 |
8030 | 8030 | 8029 | {"type": "Polygon", "coordinates": [[[-117.95741, 33.62872], [-117.95706, 33.62962], [-117.9526, 33.62718], [-117.94262, 33.62183], [-117.94138, 33.62113], [-117.94019, 33.62061], [-117.93653, 33.61699], [-117.93151, 33.61156], [-117.93212, 33.61121], [-117.93227, 33.61144], [-117.93392, 33.61329], [-117.93419, 33.61384], [-117.93741, 33.61721], [-117.93957, 33.61938], [-117.94029, 33.61993], [-117.94128, 33.62059], [-117.94314, 33.62168], [-117.94645, 33.62335], [-117.9474, 33.62381], [-117.94967, 33.625], [-117.95099, 33.62563], [-117.9543, 33.62728], [-117.95557, 33.62815], [-117.95676, 33.62864], [-117.95741, 33.62872]]]} | Open Access 1 | 11391 | Santa Ana River County Beach | 25032 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 42.56 | Santa Ana River County Beach | 0 | Local Park 2 | 4 | |
12987 | 12987 | 12986 | {"type": "Polygon", "coordinates": [[[-117.95443, 33.73019], [-117.95436, 33.73026], [-117.95426, 33.73026], [-117.94777, 33.73043], [-117.94169, 33.73062], [-117.9416, 33.72608], [-117.94053, 33.72571], [-117.94052, 33.72461], [-117.94155, 33.72372], [-117.94153, 33.72203], [-117.94128, 33.72199], [-117.94098, 33.72168], [-117.94094, 33.72129], [-117.9419, 33.71991], [-117.94347, 33.71884], [-117.94402, 33.71875], [-117.94344, 33.71734], [-117.94412, 33.71715], [-117.94413, 33.71651], [-117.95425, 33.71643], [-117.95433, 33.71648], [-117.95437, 33.72142], [-117.95382, 33.72148], [-117.95241, 33.72317], [-117.95049, 33.72413], [-117.94943, 33.72413], [-117.94859, 33.72456], [-117.94665, 33.72493], [-117.94676, 33.72783], [-117.94853, 33.72841], [-117.94947, 33.7276], [-117.95442, 33.72763], [-117.95443, 33.73019]]]} | Restricted Access 2 | 30459 | Mile Square Golf Course | 33098 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 362.625 | Mile Square GC | 0 | Local Recreation Area 3 | 4 | |
6808 | 6808 | 6807 | {"type": "Polygon", "coordinates": [[[-117.94413, 33.71651], [-117.94413, 33.71715], [-117.94344, 33.71735], [-117.94402, 33.71875], [-117.94347, 33.71884], [-117.9419, 33.7199], [-117.94094, 33.72129], [-117.94099, 33.72168], [-117.94128, 33.72199], [-117.94153, 33.72203], [-117.94155, 33.72372], [-117.94052, 33.72461], [-117.94053, 33.72571], [-117.9416, 33.72608], [-117.94169, 33.73062], [-117.9376, 33.73074], [-117.9375, 33.73069], [-117.93728, 33.71663], [-117.93738, 33.71656], [-117.94413, 33.71651]], [[-117.93975, 33.72889], [-117.9397, 33.7287], [-117.93968, 33.72854], [-117.93961, 33.72845], [-117.93937, 33.72832], [-117.93888, 33.72811], [-117.93866, 33.72817], [-117.9386, 33.72826], [-117.9386, 33.72838], [-117.93864, 33.72849], [-117.93862, 33.72865], [-117.93844, 33.72881], [-117.93826, 33.72888], [-117.93813, 33.72901], [-117.93814, 33.72924], [-117.9382, 33.72936], [-117.93842, 33.7295], [-117.93866, 33.72957], [-117.93881, 33.72953], [-117.93901, 33.72944], [-117.93917, 33.7294], [-117.93926, 33.72947], [-117.93929, 33.72954], [-117.93924, 33.72965], [-117.93904, 33.72987], [-117.939, 33.73], [-117.93905, 33.73009], [-117.93923, 33.73019], [-117.93965, 33.73022], [-117.93999, 33.73001], [-117.94018, 33.72995], [-117.94042, 33.72998], [-117.94065, 33.72997], [-117.94076, 33.72992], [-117.94078, 33.72981], [-117.94071, 33.72968], [-117.94064, 33.7294], [-117.94057, 33.7293], [-117.94034, 33.72921], [-117.94003, 33.72911], [-117.93986, 33.729], [-117.93975, 33.72889]], [[-117.94014, 33.71842], [-117.94011, 33.71824], [-117.93998, 33.71812], [-117.93983, 33.71807], [-117.9397, 33.71805], [-117.93955, 33.71808], [-117.93944, 33.71815], [-117.93937, 33.71837], [-117.93923, 33.71842], [-117.93887, 33.71841], [-117.93877, 33.71852], [-117.93875, 33.71864], [-117.93877, 33.71885], [-117.93864, 33.71908], [-117.93864, 33.71924], [-117.93871, 33.71935], [-117.93888, 33.71943], [-117.93906, 33.71943], [-117.93932, 33.71928], [-117.93936, 33.7193], [-117.93953, 33.71918], [-117.93971, 33.71917], [-117.9399, 33.7192], [-117.94015, 33.71919], [-117.94034, 33.71916], [-117.94046, 33.71902], [-117.94051, 33.71887], [-117.94046, 33.71864], [-117.9403, 33.71855], [-117.94014, 33.71842]]]} | Open Access 1 | 5355 | Mile Square Regional Park | 22217 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 149.5 | Mile Square RP | 0 | Local Park 2 | 4 | |
5366 | 5366 | 5365 | {"type": "Polygon", "coordinates": [[[-117.89824, 33.61741], [-117.89741, 33.61921], [-117.89533, 33.61943], [-117.8951, 33.61942], [-117.89488, 33.61939], [-117.89455, 33.6193], [-117.89435, 33.61921], [-117.89417, 33.61909], [-117.89393, 33.61888], [-117.89516, 33.61634], [-117.89531, 33.616], [-117.89466, 33.61532], [-117.89308, 33.61513], [-117.89234, 33.61565], [-117.89193, 33.6178], [-117.89194, 33.61783], [-117.89187, 33.61802], [-117.89277, 33.61917], [-117.89283, 33.61943], [-117.89273, 33.61944], [-117.89253, 33.61941], [-117.89187, 33.61905], [-117.89152, 33.61909], [-117.89138, 33.61948], [-117.89105, 33.61996], [-117.89105, 33.62014], [-117.89111, 33.6202], [-117.89057, 33.62076], [-117.89063, 33.62082], [-117.89049, 33.62084], [-117.89043, 33.62074], [-117.89047, 33.62072], [-117.89015, 33.62006], [-117.89006, 33.6198], [-117.89001, 33.6195], [-117.89, 33.6192], [-117.89003, 33.61898], [-117.89008, 33.61879], [-117.8902, 33.6185], [-117.89067, 33.61772], [-117.89074, 33.61756], [-117.89083, 33.61725], [-117.89087, 33.61699], [-117.89087, 33.61684], [-117.89085, 33.61669], [-117.89081, 33.61654], [-117.891, 33.61517], [-117.89233, 33.61421], [-117.89341, 33.61391], [-117.89514, 33.614], [-117.89689, 33.61477], [-117.89824, 33.61741]]]} | Open Access 1 | 5688 | Newport Dunes Aquatic Park | 22736 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 66.714 | Newport Dunes Aquatic Park | 0 | Local Park 2 | 4 | |
10409 | 10409 | 10408 | {"type": "Polygon", "coordinates": [[[-117.8945, 33.64271], [-117.89399, 33.64322], [-117.89392, 33.64333], [-117.89379, 33.64355], [-117.89373, 33.64375], [-117.89371, 33.64388], [-117.89372, 33.6441], [-117.8938, 33.64442], [-117.89385, 33.64455], [-117.8939, 33.64478], [-117.89389, 33.64513], [-117.89384, 33.64535], [-117.89379, 33.64547], [-117.89367, 33.64567], [-117.89359, 33.64578], [-117.89251, 33.64687], [-117.89238, 33.64703], [-117.89231, 33.64717], [-117.89224, 33.64738], [-117.89224, 33.64756], [-117.89226, 33.6477], [-117.8923, 33.64784], [-117.89244, 33.64813], [-117.89249, 33.64839], [-117.89248, 33.64875], [-117.89241, 33.64901], [-117.89223, 33.64934], [-117.89157, 33.65003], [-117.89146, 33.65016], [-117.89132, 33.6504], [-117.89119, 33.6507], [-117.89101, 33.65145], [-117.89086, 33.65185], [-117.89068, 33.65213], [-117.89053, 33.65231], [-117.88773, 33.65511], [-117.8874, 33.65553], [-117.8871, 33.65583], [-117.88433, 33.6539], [-117.88384, 33.65362], [-117.88331, 33.65339], [-117.88314, 33.65333], [-117.8833, 33.65323], [-117.88392, 33.65293], [-117.88473, 33.65264], [-117.88618, 33.65226], [-117.88784, 33.65191], [-117.88811, 33.65188], [-117.88869, 33.65158], [-117.88878, 33.65161], [-117.88842, 33.65251], [-117.88843, 33.65252], [-117.88858, 33.6525], [-117.88878, 33.6524], [-117.88892, 33.65213], [-117.88901, 33.65178], [-117.88915, 33.65163], [-117.88993, 33.65133], [-117.88998, 33.65135], [-117.88993, 33.65135], [-117.88917, 33.65166], [-117.88904, 33.65178], [-117.88895, 33.65214], [-117.88881, 33.65242], [-117.88872, 33.65247], [-117.88873, 33.65248], [-117.88889, 33.65246], [-117.88932, 33.65262], [-117.88973, 33.65289], [-117.89045, 33.65216], [-117.89057, 33.65202], [-117.89068, 33.65184], [-117.89043, 33.65169], [-117.8901, 33.6513], [-117.88975, 33.65122], [-117.88957, 33.65102], [-117.88978, 33.65087], [-117.8898, 33.65087], [-117.89017, 33.65045], [-117.89054, 33.64966], [-117.89062, 33.64945], [-117.89083, 33.64873], [-117.89091, 33.64809], [-117.89093, 33.64785], [-117.89089, 33.64759], [-117.89084, 33.64753], [-117.89083, 33.64719], [-117.89089, 33.64677], [-117.89113, 33.64628], [-117.89142, 33.64576], [-117.89224, 33.64469], [-117.89242, 33.64479], [-117.89283, 33.64534], [-117.89283, 33.64575], [-117.89286, 33.64629], [-117.89319, 33.64598], [-117.8934, 33.64575], [-117.89335, 33.64553], [-117.89324, 33.64457], [-117.89312, 33.64423], [-117.89296, 33.64373], [-117.89251, 33.64306], [-117.89186, 33.64225], [-117.89135, 33.64175], [-117.89166, 33.64148], [-117.89184, 33.64155], [-117.89228, 33.64157], [-117.89231, 33.64166], [-117.89249, 33.6416], [-117.89262, 33.6415], [-117.89268, 33.64144], [-117.8945, 33.64271]]]} | Open Access 1 | 18405 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 71.487 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10407 | 10407 | 10406 | {"type": "Polygon", "coordinates": [[[-117.8934, 33.64575], [-117.89286, 33.64631], [-117.89283, 33.64533], [-117.89242, 33.64479], [-117.89224, 33.64469], [-117.89142, 33.64576], [-117.89221, 33.64468], [-117.892, 33.64456], [-117.89199, 33.64287], [-117.89123, 33.64185], [-117.89134, 33.64175], [-117.89186, 33.64225], [-117.89251, 33.64306], [-117.89296, 33.64373], [-117.89312, 33.64423], [-117.89324, 33.64457], [-117.89335, 33.64553], [-117.8934, 33.64575]]]} | Open Access 1 | 18400 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.201 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
16372 | 16372 | 16371 | {"type": "Polygon", "coordinates": [[[-117.88948, 33.90805], [-117.88863, 33.90953], [-117.8888, 33.90976], [-117.88839, 33.91059], [-117.88553, 33.91066], [-117.88493, 33.91029], [-117.88439, 33.91015], [-117.88285, 33.90799], [-117.88273, 33.90772], [-117.88237, 33.90702], [-117.88223, 33.90694], [-117.88249, 33.90662], [-117.88267, 33.90638], [-117.88281, 33.90612], [-117.88317, 33.90534], [-117.88332, 33.90496], [-117.88341, 33.90465], [-117.88345, 33.9044], [-117.88346, 33.90404], [-117.88393, 33.9035], [-117.88393, 33.90139], [-117.88395, 33.89918], [-117.88326, 33.89918], [-117.88354, 33.8988], [-117.88359, 33.8985], [-117.88355, 33.89829], [-117.88368, 33.89807], [-117.88396, 33.8978], [-117.88403, 33.89755], [-117.88427, 33.8973], [-117.88475, 33.8966], [-117.88486, 33.89631], [-117.88509, 33.8958], [-117.88549, 33.89512], [-117.88552, 33.89498], [-117.88564, 33.89487], [-117.88563, 33.89448], [-117.88568, 33.89432], [-117.88656, 33.89431], [-117.88781, 33.8962], [-117.88781, 33.89625], [-117.88733, 33.90037], [-117.88634, 33.90045], [-117.88663, 33.90109], [-117.88628, 33.90184], [-117.88816, 33.90231], [-117.88687, 33.90265], [-117.88686, 33.90266], [-117.88784, 33.90345], [-117.8888, 33.90426], [-117.88709, 33.90358], [-117.88645, 33.90359], [-117.88644, 33.90415], [-117.88579, 33.90416], [-117.88576, 33.90578], [-117.88948, 33.90805]], [[-117.8851, 33.9056], [-117.88523, 33.90589], [-117.88537, 33.90606], [-117.88552, 33.9061], [-117.88557, 33.90604], [-117.88544, 33.9058], [-117.88526, 33.90495], [-117.88526, 33.90474], [-117.88542, 33.90436], [-117.88534, 33.90411], [-117.8852, 33.90402], [-117.88497, 33.90406], [-117.88473, 33.90417], [-117.88463, 33.90429], [-117.88463, 33.90446], [-117.8847, 33.90456], [-117.88471, 33.90482], [-117.88466, 33.90489], [-117.88412, 33.9054], [-117.88438, 33.90554], [-117.88475, 33.9052], [-117.8851, 33.9056]]]} | Open Access 1 | 18254 | Craig Regional Park | 17752 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 144.448 | Craig RP | 0 | Local Park 2 | 4 | |
10406 | 10406 | 10405 | {"type": "Polygon", "coordinates": [[[-117.88675, 33.63629], [-117.88676, 33.63671], [-117.88656, 33.63756], [-117.88651, 33.63789], [-117.88644, 33.63864], [-117.88628, 33.63944], [-117.88624, 33.64024], [-117.88617, 33.64049], [-117.88615, 33.64054], [-117.88604, 33.64067], [-117.88588, 33.64072], [-117.88507, 33.64081], [-117.88518, 33.64074], [-117.88577, 33.64058], [-117.88601, 33.64014], [-117.88595, 33.63961], [-117.88605, 33.63868], [-117.8862, 33.638], [-117.88625, 33.63711], [-117.88644, 33.63657], [-117.88657, 33.63646], [-117.88649, 33.63611], [-117.88598, 33.63572], [-117.88576, 33.63561], [-117.88532, 33.63466], [-117.88467, 33.63416], [-117.88461, 33.63407], [-117.88479, 33.63397], [-117.88534, 33.63446], [-117.88542, 33.63454], [-117.88552, 33.63478], [-117.88576, 33.63522], [-117.88604, 33.63554], [-117.88649, 33.63592], [-117.88675, 33.63629]]]} | Open Access 1 | 18399 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.179 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
12982 | 12982 | 12981 | {"type": "Polygon", "coordinates": [[[-117.88557, 33.90604], [-117.88552, 33.9061], [-117.88537, 33.90606], [-117.88523, 33.90589], [-117.8851, 33.9056], [-117.88475, 33.90521], [-117.88437, 33.90554], [-117.88411, 33.9054], [-117.88466, 33.90489], [-117.88471, 33.90482], [-117.8847, 33.90456], [-117.88463, 33.90446], [-117.88463, 33.9043], [-117.88473, 33.90417], [-117.88498, 33.90406], [-117.8852, 33.90402], [-117.88534, 33.90411], [-117.88542, 33.90436], [-117.88526, 33.90474], [-117.88526, 33.90495], [-117.88544, 33.9058], [-117.88557, 33.90604]]]} | Open Access 1 | 30439 | Craig Regional Park | 17752 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.996 | Craig RP | 0 | Local Park 2 | 4 | |
10400 | 10400 | 10399 | {"type": "Polygon", "coordinates": [[[-117.88536, 33.64086], [-117.88519, 33.64097], [-117.88485, 33.64127], [-117.88427, 33.64172], [-117.88345, 33.64241], [-117.88291, 33.64282], [-117.88256, 33.64313], [-117.88233, 33.6434], [-117.88221, 33.64362], [-117.8821, 33.64402], [-117.88208, 33.64435], [-117.88216, 33.64517], [-117.88212, 33.64546], [-117.88197, 33.64574], [-117.88185, 33.64587], [-117.88177, 33.64595], [-117.88137, 33.6462], [-117.8809, 33.64632], [-117.87895, 33.64644], [-117.87853, 33.64644], [-117.87817, 33.64626], [-117.87799, 33.64614], [-117.87779, 33.64607], [-117.87661, 33.6457], [-117.87624, 33.64562], [-117.87588, 33.64556], [-117.87472, 33.64547], [-117.87401, 33.64551], [-117.87283, 33.64533], [-117.87265, 33.64533], [-117.87246, 33.64535], [-117.87244, 33.64534], [-117.87177, 33.64537], [-117.87116, 33.64511], [-117.87158, 33.6452], [-117.87178, 33.64521], [-117.87191, 33.6452], [-117.87256, 33.64508], [-117.87274, 33.64508], [-117.87339, 33.64517], [-117.87432, 33.64536], [-117.87441, 33.64536], [-117.87465, 33.64531], [-117.87484, 33.6453], [-117.87506, 33.64535], [-117.87571, 33.64536], [-117.87589, 33.64537], [-117.87689, 33.64562], [-117.87736, 33.64565], [-117.87757, 33.64569], [-117.87787, 33.64588], [-117.87801, 33.64593], [-117.87842, 33.64602], [-117.87878, 33.64602], [-117.8813, 33.64536], [-117.88168, 33.64514], [-117.88189, 33.64483], [-117.88195, 33.64456], [-117.88204, 33.64288], [-117.88185, 33.64287], [-117.88185, 33.64279], [-117.88204, 33.64279], [-117.88209, 33.64277], [-117.88232, 33.64202], [-117.88236, 33.64196], [-117.88288, 33.64139], [-117.88295, 33.64145], [-117.88319, 33.6413], [-117.88345, 33.64116], [-117.88358, 33.64112], [-117.8842, 33.64098], [-117.88536, 33.64086]]]} | Open Access 1 | 18395 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 18.576 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
639 | 639 | 638 | {"type": "Polygon", "coordinates": [[[-117.88348, 33.60245], [-117.88321, 33.60315], [-117.88242, 33.60231], [-117.88295, 33.60212], [-117.88348, 33.60245]]]} | Open Access 1 | 2654 | Bayside Drive Beach | 15893 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.344 | Bayside Drive Beach | 0 | Local Park 2 | 4 | |
10405 | 10405 | 10404 | {"type": "Polygon", "coordinates": [[[-117.8834, 33.65287], [-117.88279, 33.65322], [-117.88239, 33.6535], [-117.88162, 33.65407], [-117.88134, 33.65422], [-117.88214, 33.65355], [-117.88214, 33.65353], [-117.8818, 33.65332], [-117.88142, 33.65315], [-117.88102, 33.65301], [-117.8796, 33.65272], [-117.87919, 33.65258], [-117.87899, 33.65248], [-117.87849, 33.65219], [-117.87799, 33.65203], [-117.87759, 33.65187], [-117.87644, 33.65108], [-117.87585, 33.65094], [-117.87545, 33.65088], [-117.87483, 33.65085], [-117.8742, 33.65087], [-117.87418, 33.65155], [-117.87412, 33.65161], [-117.87303, 33.65086], [-117.87424, 33.65054], [-117.87548, 33.65047], [-117.87553, 33.65046], [-117.87556, 33.65047], [-117.87636, 33.65059], [-117.87714, 33.65077], [-117.87817, 33.65111], [-117.87883, 33.65136], [-117.87933, 33.65162], [-117.87978, 33.65172], [-117.88007, 33.65181], [-117.88053, 33.65186], [-117.8834, 33.65287]]]} | Open Access 1 | 18398 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 19.731 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
615 | 615 | 614 | {"type": "Polygon", "coordinates": [[[-117.87482, 33.89648], [-117.87514, 33.89647], [-117.87518, 33.89649], [-117.87521, 33.89653], [-117.87521, 33.89758], [-117.87518, 33.89763], [-117.87514, 33.89764], [-117.87508, 33.89764], [-117.87503, 33.8976], [-117.87496, 33.89757], [-117.87445, 33.89756], [-117.87443, 33.89649], [-117.87482, 33.89648]]]} | Open Access 1 | 944 | George Key Ranch Historic Park | 19269 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.158 | George Key Ranch Historic Park | 0 | Local Historic or Cultural Area 19 | 4 | |
10403 | 10403 | 10402 | {"type": "Polygon", "coordinates": [[[-117.87426, 33.65171], [-117.87411, 33.65186], [-117.87368, 33.65165], [-117.87349, 33.65159], [-117.87309, 33.65154], [-117.87287, 33.65155], [-117.87262, 33.6516], [-117.87254, 33.65162], [-117.87253, 33.65194], [-117.87219, 33.65186], [-117.87188, 33.65195], [-117.87143, 33.65239], [-117.87108, 33.65252], [-117.87085, 33.65215], [-117.87074, 33.65219], [-117.8706, 33.65196], [-117.8698, 33.65217], [-117.87, 33.65204], [-117.87103, 33.65164], [-117.87218, 33.65124], [-117.8725, 33.65115], [-117.87249, 33.6511], [-117.87303, 33.65086], [-117.87426, 33.65171]]]} | Open Access 1 | 18396 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.536 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
5324 | 5324 | 5323 | {"type": "Polygon", "coordinates": [[[-117.87081, 33.58987], [-117.87057, 33.5901], [-117.87047, 33.59017], [-117.87031, 33.59023], [-117.87023, 33.59023], [-117.86914, 33.5899], [-117.8688, 33.58974], [-117.8687, 33.58967], [-117.86857, 33.58971], [-117.86853, 33.58978], [-117.86837, 33.58952], [-117.86822, 33.58933], [-117.86799, 33.58913], [-117.86753, 33.58885], [-117.86748, 33.58879], [-117.86752, 33.58844], [-117.86743, 33.58829], [-117.86725, 33.58817], [-117.867, 33.58794], [-117.86685, 33.58788], [-117.86663, 33.58784], [-117.86629, 33.58758], [-117.86584, 33.58715], [-117.86554, 33.58681], [-117.86536, 33.58663], [-117.86504, 33.58617], [-117.86492, 33.58612], [-117.86475, 33.58608], [-117.8645, 33.58597], [-117.86432, 33.58592], [-117.86424, 33.5858], [-117.8642, 33.58564], [-117.86413, 33.58546], [-117.86417, 33.58532], [-117.86436, 33.585], [-117.86442, 33.58494], [-117.86438, 33.58488], [-117.86425, 33.58484], [-117.86379, 33.58483], [-117.86352, 33.58479], [-117.86325, 33.58471], [-117.86307, 33.58461], [-117.86285, 33.58452], [-117.86263, 33.5845], [-117.86238, 33.58444], [-117.86223, 33.58433], [-117.86267, 33.58392], [-117.86275, 33.58396], [-117.86292, 33.58397], [-117.86313, 33.58403], [-117.86336, 33.58412], [-117.86354, 33.58421], [-117.86366, 33.58425], [-117.86406, 33.58429], [-117.86428, 33.5843], [-117.86449, 33.58433], [-117.8647, 33.5844], [-117.8648, 33.58446], [-117.86494, 33.58459], [-117.86504, 33.58473], [-117.86508, 33.58492], [-117.86507, 33.58502], [-117.86504, 33.58511], [-117.865, 33.5852], [-117.86483, 33.58545], [-117.86484, 33.5855], [-117.86498, 33.58556], [-117.86524, 33.58564], [-117.86546, 33.58574], [-117.8656, 33.58589], [-117.86589, 33.58631], [-117.86607, 33.58648], [-117.86635, 33.5868], [-117.86676, 33.58719], [-117.86695, 33.58733], [-117.86715, 33.58739], [-117.86741, 33.58751], [-117.86763, 33.58773], [-117.86765, 33.58773], [-117.86793, 33.58793], [-117.868, 33.58801], [-117.86813, 33.58825], [-117.86817, 33.58834], [-117.86817, 33.58855], [-117.86848, 33.58875], [-117.8687, 33.58896], [-117.86896, 33.58928], [-117.8691, 33.5895], [-117.86932, 33.5896], [-117.86955, 33.58966], [-117.86984, 33.58967], [-117.87045, 33.58972], [-117.87067, 33.58978], [-117.87081, 33.58987]]]} | Unknown Access 4 | 5677 | Newport Beach Marine Life Refuge | 22734 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 16.208 | Newport Beach Marine Life Refuge | 0 | Local Conservation Area 4 | 2 | |
10404 | 10404 | 10403 | {"type": "Polygon", "coordinates": [[[-117.87074, 33.65219], [-117.87051, 33.65232], [-117.87072, 33.65266], [-117.86908, 33.6533], [-117.86899, 33.65299], [-117.86823, 33.65312], [-117.86746, 33.65307], [-117.86756, 33.65296], [-117.86713, 33.65287], [-117.86698, 33.65266], [-117.86703, 33.65232], [-117.86752, 33.65236], [-117.86794, 33.65237], [-117.86852, 33.65235], [-117.86896, 33.65231], [-117.8698, 33.65217], [-117.87037, 33.65203], [-117.8706, 33.65196], [-117.87074, 33.65219]]]} | Open Access 1 | 18397 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 7.01 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 |
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]);