units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 138 and MNG_AG_TYP = 3 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 33
- Local Other or Unknown 18
- Local Conservation Area 16
- Local Recreation Area 4
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- County Agency · 75 ✖
MNG_AGENCY 1
- Orange, County of · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
6570 | 6570 | 6569 | {"type": "MultiPolygon", "coordinates": [[[[-117.69044, 33.46418], [-117.69034, 33.46429], [-117.69023, 33.46447], [-117.69002, 33.46503], [-117.68829, 33.46459], [-117.68888, 33.46407], [-117.68896, 33.46406], [-117.68911, 33.46414], [-117.68937, 33.46441], [-117.68946, 33.46447], [-117.68962, 33.4645], [-117.68977, 33.46451], [-117.68996, 33.46447], [-117.69008, 33.46442], [-117.69044, 33.46418]]], [[[-117.69419, 33.46413], [-117.69416, 33.46417], [-117.69406, 33.46424], [-117.69374, 33.46433], [-117.69359, 33.4644], [-117.69355, 33.46427], [-117.69347, 33.46415], [-117.69334, 33.46406], [-117.69324, 33.46402], [-117.69313, 33.46401], [-117.69291, 33.46402], [-117.69269, 33.464], [-117.69209, 33.46393], [-117.69148, 33.46393], [-117.69151, 33.46387], [-117.69148, 33.4638], [-117.6914, 33.46375], [-117.69133, 33.46374], [-117.69118, 33.46379], [-117.69098, 33.4638], [-117.69085, 33.46382], [-117.69069, 33.46388], [-117.69039, 33.46403], [-117.69004, 33.46427], [-117.68981, 33.46437], [-117.68966, 33.46438], [-117.68956, 33.46436], [-117.68947, 33.46432], [-117.68911, 33.46392], [-117.68911, 33.46386], [-117.68941, 33.46363], [-117.68956, 33.46354], [-117.68997, 33.46325], [-117.69023, 33.4631], [-117.69063, 33.46296], [-117.69143, 33.46279], [-117.69352, 33.46272], [-117.69359, 33.46279], [-117.69359, 33.46298], [-117.69361, 33.46311], [-117.69368, 33.46339], [-117.69375, 33.46357], [-117.69395, 33.46387], [-117.69419, 33.46413]]]]} | Open Access 1 | 3587 | Lantern Bay Park | 21016 | 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 | 15.065 | Lantern Bay Park | 0 | Local Park 2 | 4 | |
6629 | 6629 | 6628 | {"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.60928, 33.64947], [-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.60993, 33.64798], [-117.6101, 33.6479], [-117.61025, 33.64796], [-117.61029, 33.64795], [-117.61031, 33.64797]]]} | Open Access 1 | 4357 | Estrella Vista Park | 18731 | 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.124 | Estrella Vista Park | 0 | Local Park 2 | 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 | |
7781 | 7781 | 7780 | {"type": "Polygon", "coordinates": [[[-117.64544, 33.44089], [-117.64521, 33.44122], [-117.64472, 33.44093], [-117.64482, 33.44062], [-117.64519, 33.44075], [-117.64544, 33.44089]]]} | Open Access 1 | 8672 | Poche Beach Park | 23820 | 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.6 | Poche Beach Park | 0 | Local Park 2 | 4 | |
7930 | 7930 | 7929 | {"type": "MultiPolygon", "coordinates": [[[[-117.72548, 33.48131], [-117.72452, 33.48145], [-117.72446, 33.48119], [-117.72395, 33.48016], [-117.72398, 33.48012], [-117.72336, 33.4795], [-117.72333, 33.47941], [-117.72336, 33.47868], [-117.72328, 33.47868], [-117.7231, 33.47813], [-117.72161, 33.47762], [-117.72145, 33.47746], [-117.72125, 33.47718], [-117.72108, 33.47707], [-117.72086, 33.47699], [-117.72064, 33.477], [-117.72041, 33.47707], [-117.72027, 33.47717], [-117.72021, 33.47724], [-117.72008, 33.47735], [-117.71991, 33.47743], [-117.71975, 33.47747], [-117.71969, 33.47754], [-117.71966, 33.47731], [-117.71958, 33.47706], [-117.71949, 33.47687], [-117.71933, 33.47657], [-117.71958, 33.4764], [-117.71972, 33.47633], [-117.72017, 33.47617], [-117.72059, 33.47608], [-117.7207, 33.47603], [-117.72075, 33.47598], [-117.72104, 33.47614], [-117.72111, 33.47614], [-117.72116, 33.47612], [-117.72125, 33.47604], [-117.72131, 33.47596], [-117.72133, 33.47589], [-117.72132, 33.4755], [-117.72116, 33.47511], [-117.72109, 33.47457], [-117.72114, 33.47428], [-117.72126, 33.47406], [-117.72131, 33.47375], [-117.72119, 33.47355], [-117.72083, 33.47339], [-117.72013, 33.47303], [-117.72003, 33.47295], [-117.71995, 33.47282], [-117.71983, 33.4727], [-117.71982, 33.47267], [-117.71986, 33.47266], [-117.71988, 33.47253], [-117.71864, 33.47072], [-117.7178, 33.46933], [-117.71763, 33.46924], [-117.71756, 33.46924], [-117.71756, 33.46918], [-117.71684, 33.46918], [-117.7166, 33.46927], [-117.71639, 33.4692], [-117.71607, 33.46922], [-117.71542, 33.46922], [-117.71549, 33.46914], [-117.71813, 33.46914], [-117.71825, 33.46933], [-117.71846, 33.46972], [-117.71862, 33.46995], [-117.71874, 33.47021], [-117.71884, 33.47034], [-117.71889, 33.4705], [-117.71908, 33.47069], [-117.71912, 33.47079], [-117.71927, 33.47101], [-117.71934, 33.47104], [-117.71953, 33.47137], [-117.71964, 33.47151], [-117.71968, 33.4716], [-117.71982, 33.47167], [-117.71991, 33.47185], [-117.72032, 33.47209], [-117.72052, 33.47231], [-117.72061, 33.47247], [-117.72071, 33.4728], [-117.72084, 33.47289], [-117.72098, 33.47317], [-117.72118, 33.47329], [-117.72146, 33.47342], [-117.72154, 33.47348], [-117.72165, 33.47365], [-117.7219, 33.47424], [-117.7219, 33.47428], [-117.72206, 33.47454], [-117.72209, 33.47468], [-117.72216, 33.47477], [-117.72219, 33.47493], [-117.72228, 33.47503], [-117.72242, 33.4754], [-117.72265, 33.47591], [-117.72271, 33.47605], [-117.72272, 33.47626], [-117.72279, 33.47633], [-117.72304, 33.47688], [-117.72319, 33.47707], [-117.72322, 33.47719], [-117.72335, 33.47734], [-117.72352, 33.47769], [-117.7238, 33.47848], [-117.72397, 33.47877], [-117.72404, 33.47905], [-117.72416, 33.47929], [-117.72436, 33.47984], [-117.72446, 33.48001], [-117.72456, 33.48027], [-117.72466, 33.48044], [-117.72479, 33.48074], [-117.72483, 33.48079], [-117.72493, 33.48082], [-117.72513, 33.48102], [-117.72535, 33.48114], [-117.72548, 33.48131]]], [[[-117.71875, 33.47865], [-117.71714, 33.47625], [-117.71803, 33.47583], [-117.7184, 33.47602], [-117.71861, 33.47614], [-117.71883, 33.47632], [-117.719, 33.47648], [-117.71911, 33.47661], [-117.71928, 33.47687], [-117.71941, 33.47716], [-117.71946, 33.47732], [-117.71951, 33.47762], [-117.71951, 33.47784], [-117.71949, 33.47813], [-117.71943, 33.4783], [-117.71937, 33.47839], [-117.71919, 33.47853], [-117.7189, 33.47866], [-117.71875, 33.47865]]], [[[-117.72425, 33.4818], [-117.72336, 33.48334], [-117.7219, 33.48208], [-117.72357, 33.48188], [-117.72425, 33.4818]]]]} | Open Access 1 | 10745 | Salt Creek Beach County Park | 24808 | 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 | 44.889 | Salt Creek Beach County Park | 0 | Local Park 2 | 4 | |
7995 | 7995 | 7994 | {"type": "MultiPolygon", "coordinates": [[[[-117.85104, 33.66409], [-117.85056, 33.66457], [-117.85039, 33.66479], [-117.84631, 33.66889], [-117.84585, 33.66943], [-117.84565, 33.66972], [-117.84503, 33.67081], [-117.84484, 33.67084], [-117.84412, 33.67062], [-117.84355, 33.67048], [-117.84327, 33.67042], [-117.84269, 33.67034], [-117.84197, 33.67028], [-117.84123, 33.67027], [-117.83645, 33.6705], [-117.83635, 33.66901], [-117.83652, 33.66899], [-117.83642, 33.66747], [-117.8364, 33.66689], [-117.83644, 33.66642], [-117.83657, 33.66573], [-117.83714, 33.666], [-117.83906, 33.66736], [-117.8446, 33.66183], [-117.8446, 33.66181], [-117.84162, 33.65973], [-117.84575, 33.65589], [-117.8462, 33.65622], [-117.84645, 33.65643], [-117.84675, 33.65673], [-117.84713, 33.65719], [-117.8473, 33.65742], [-117.84745, 33.65769], [-117.84757, 33.65796], [-117.84767, 33.65824], [-117.84851, 33.66087], [-117.84871, 33.66139], [-117.84903, 33.662], [-117.84935, 33.66247], [-117.84958, 33.66275], [-117.85011, 33.66327], [-117.85059, 33.66366], [-117.85104, 33.66398], [-117.85104, 33.66409]]], [[[-117.86095, 33.65401], [-117.86078, 33.6542], [-117.86051, 33.65429], [-117.86026, 33.65441], [-117.8598, 33.65467], [-117.85946, 33.65494], [-117.85934, 33.65506], [-117.85902, 33.65504], [-117.8585, 33.65477], [-117.85822, 33.65469], [-117.85779, 33.65464], [-117.85729, 33.65455], [-117.85688, 33.65444], [-117.85636, 33.65413], [-117.85617, 33.65399], [-117.8559, 33.65387], [-117.85583, 33.65381], [-117.85571, 33.65361], [-117.85295, 33.65099], [-117.85325, 33.65094], [-117.85983, 33.6509], [-117.85988, 33.65115], [-117.85998, 33.65155], [-117.86004, 33.6518], [-117.86013, 33.65205], [-117.86013, 33.6521], [-117.8601, 33.65216], [-117.86012, 33.65247], [-117.86022, 33.65247], [-117.86042, 33.6532], [-117.86058, 33.65354], [-117.86075, 33.65379], [-117.86095, 33.65401]]]]} | Restricted Access 2 | 11112 | San Joaquin Freshwater Marsh Reserve | 24910 | 2346 | Irvine Ranch Water District 884 | Special District 4 | Water District 13 | http://www.irwd.com/ | Special District 4 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 309.259 | San Joaquin Freshwater Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
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 | |
8133 | 8133 | 8132 | {"type": "Polygon", "coordinates": [[[-117.71925, 33.56722], [-117.71925, 33.56736], [-117.71915, 33.56784], [-117.71894, 33.5685], [-117.71855, 33.56855], [-117.71852, 33.56887], [-117.71822, 33.56895], [-117.71714, 33.56676], [-117.71752, 33.56632], [-117.71893, 33.56711], [-117.71925, 33.56722]]]} | Open Access 1 | 12312 | Foxborough Park | 19036 | 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.537 | Foxborough Park | 0 | Local Park 2 | 4 | |
8270 | 8270 | 8269 | {"type": "Polygon", "coordinates": [[[-117.71813, 33.46914], [-117.71782, 33.46914], [-117.71759, 33.46875], [-117.71627, 33.4669], [-117.71623, 33.46688], [-117.71581, 33.46699], [-117.71576, 33.46684], [-117.71616, 33.46674], [-117.71618, 33.46673], [-117.71618, 33.46669], [-117.71605, 33.46642], [-117.71602, 33.4663], [-117.71589, 33.46599], [-117.71512, 33.46478], [-117.71464, 33.46368], [-117.71535, 33.46391], [-117.71545, 33.46419], [-117.71551, 33.4647], [-117.71576, 33.46533], [-117.71605, 33.46569], [-117.71634, 33.46625], [-117.71644, 33.46654], [-117.71691, 33.46711], [-117.71701, 33.46745], [-117.71715, 33.46761], [-117.71731, 33.46791], [-117.71741, 33.46805], [-117.71749, 33.46833], [-117.71763, 33.46861], [-117.71779, 33.4688], [-117.71797, 33.46895], [-117.71813, 33.46914]]]} | Open Access 1 | 12658 | Silver Strand Beach County Park | 25495 | 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.163 | Silver Strand Beach County Park | 0 | Local Park 2 | 4 | |
9246 | 9246 | 9245 | {"type": "MultiPolygon", "coordinates": [[[[-117.81111, 33.6459], [-117.81107, 33.64602], [-117.81103, 33.64621], [-117.81064, 33.6462], [-117.81052, 33.64615], [-117.81043, 33.64602], [-117.81027, 33.64568], [-117.81001, 33.64552], [-117.80971, 33.64503], [-117.80936, 33.64468], [-117.80921, 33.64469], [-117.80885, 33.64485], [-117.80846, 33.64492], [-117.80839, 33.64464], [-117.80841, 33.64457], [-117.8095, 33.64431], [-117.81045, 33.64542], [-117.81111, 33.6459]]], [[[-117.81472, 33.64741], [-117.81478, 33.64752], [-117.81479, 33.6477], [-117.81477, 33.64785], [-117.81472, 33.64795], [-117.81466, 33.64804], [-117.81422, 33.64845], [-117.81412, 33.64845], [-117.81358, 33.64804], [-117.81336, 33.64791], [-117.81288, 33.64769], [-117.81253, 33.64758], [-117.81251, 33.64738], [-117.81244, 33.64706], [-117.81233, 33.64683], [-117.81223, 33.64671], [-117.81212, 33.64662], [-117.81196, 33.64652], [-117.81171, 33.64643], [-117.81146, 33.64624], [-117.8114, 33.64622], [-117.81133, 33.64628], [-117.81121, 33.64631], [-117.81124, 33.64612], [-117.81128, 33.64601], [-117.81129, 33.64598], [-117.81244, 33.64648], [-117.8127, 33.6467], [-117.81279, 33.6468], [-117.81272, 33.64694], [-117.81295, 33.64713], [-117.81292, 33.64717], [-117.81292, 33.64721], [-117.81296, 33.64727], [-117.81374, 33.64777], [-117.81404, 33.64792], [-117.8142, 33.64798], [-117.81437, 33.6477], [-117.81457, 33.64749], [-117.81472, 33.64741]]], [[[-117.81827, 33.64906], [-117.81816, 33.6491], [-117.81824, 33.64925], [-117.81807, 33.64933], [-117.81763, 33.64949], [-117.8176, 33.6494], [-117.81775, 33.64922], [-117.81786, 33.64874], [-117.81782, 33.64854], [-117.81737, 33.64781], [-117.81712, 33.64759], [-117.81698, 33.64754], [-117.81664, 33.64758], [-117.81656, 33.64751], [-117.81638, 33.64728], [-117.81612, 33.64723], [-117.81597, 33.64726], [-117.81584, 33.6474], [-117.81544, 33.64753], [-117.81525, 33.64772], [-117.81501, 33.64771], [-117.815, 33.64757], [-117.81498, 33.64749], [-117.81492, 33.64739], [-117.81581, 33.64705], [-117.81586, 33.647], [-117.81602, 33.64694], [-117.81604, 33.64689], [-117.81604, 33.64686], [-117.81616, 33.64681], [-117.81618, 33.64683], [-117.81654, 33.64694], [-117.81678, 33.64705], [-117.81691, 33.64712], [-117.81684, 33.64722], [-117.81701, 33.64732], [-117.81728, 33.64751], [-117.81748, 33.64769], [-117.8177, 33.64794], [-117.81787, 33.6482], [-117.81827, 33.64906]]], [[[-117.81731, 33.6546], [-117.81657, 33.65442], [-117.81656, 33.65417], [-117.81637, 33.65388], [-117.81631, 33.6537], [-117.81611, 33.65347], [-117.81582, 33.65336], [-117.81599, 33.65304], [-117.81625, 33.65318], [-117.81628, 33.65352], [-117.81711, 33.65346], [-117.81716, 33.65369], [-117.81721, 33.65384], [-117.81738, 33.65413], [-117.81742, 33.65424], [-117.81743, 33.65446], [-117.81737, 33.65456], [-117.81731, 33.6546]]], [[[-117.81824, 33.65269], [-117.81803, 33.65277], [-117.81795, 33.65312], [-117.81797, 33.65314], [-117.81734, 33.65372], [-117.81731, 33.65359], [-117.8173, 33.65346], [-117.81731, 33.65332], [-117.81733, 33.65323], [-117.81746, 33.653], [-117.81802, 33.65247], [-117.81811, 33.65248], [-117.81819, 33.65253], [-117.81822, 33.65259], [-117.81824, 33.65269]]], [[[-117.81816, 33.65479], [-117.81787, 33.65538], [-117.81745, 33.6551], [-117.81748, 33.65484], [-117.81754, 33.65483], [-117.81759, 33.65477], [-117.8176, 33.65473], [-117.81758, 33.65459], [-117.8176, 33.65446], [-117.8176, 33.65428], [-117.81802, 33.65447], [-117.81816, 33.65479]]], [[[-117.81982, 33.65319], [-117.81947, 33.65332], [-117.81934, 33.65341], [-117.8192, 33.65359], [-117.81923, 33.65351], [-117.81924, 33.65332], [-117.81918, 33.65307], [-117.8188, 33.65227], [-117.81874, 33.65221], [-117.81847, 33.65231], [-117.81843, 33.65245], [-117.81834, 33.65242], [-117.81828, 33.65238], [-117.81823, 33.65233], [-117.81822, 33.6523], [-117.81841, 33.65201], [-117.81855, 33.65184], [-117.81871, 33.6517], [-117.81843, 33.65141], [-117.81894, 33.65052], [-117.81858, 33.65026], [-117.81845, 33.65014], [-117.81828, 33.64999], [-117.81804, 33.64971], [-117.81831, 33.64961], [-117.81843, 33.6496], [-117.81861, 33.6498], [-117.81893, 33.65007], [-117.81931, 33.65033], [-117.81964, 33.65048], [-117.81901, 33.65139], [-117.81963, 33.6528], [-117.81982, 33.65319]]]]} | Open Access 1 | 15391 | Turtle Rock Riparian Corridor | 26598 | 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 | 21.639 | Turtle Rock Riparian Corridor | 0 | Local Conservation Area 4 | 2 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
10672 | 10672 | 10671 | {"type": "Polygon", "coordinates": [[[-117.70798, 33.89469], [-117.70763, 33.89501], [-117.70756, 33.89497], [-117.6896, 33.88395], [-117.68955, 33.87758], [-117.68999, 33.87756], [-117.69017, 33.87753], [-117.68986, 33.87846], [-117.69036, 33.87883], [-117.69094, 33.87959], [-117.69101, 33.87994], [-117.69144, 33.88007], [-117.69149, 33.88026], [-117.69222, 33.88034], [-117.69362, 33.88074], [-117.69522, 33.88101], [-117.69761, 33.88188], [-117.69825, 33.88174], [-117.69787, 33.88072], [-117.69774, 33.88003], [-117.69764, 33.87981], [-117.69742, 33.87946], [-117.69725, 33.87887], [-117.69723, 33.87866], [-117.69792, 33.87846], [-117.69814, 33.87842], [-117.69824, 33.87841], [-117.69827, 33.87883], [-117.69842, 33.87918], [-117.69873, 33.87965], [-117.69886, 33.88043], [-117.69922, 33.88154], [-117.70225, 33.8805], [-117.70271, 33.8803], [-117.70297, 33.88028], [-117.70342, 33.8806], [-117.70394, 33.88052], [-117.70446, 33.88055], [-117.7046, 33.88086], [-117.70473, 33.88125], [-117.70486, 33.88142], [-117.70558, 33.88204], [-117.70583, 33.88146], [-117.70629, 33.8814], [-117.70629, 33.8815], [-117.70613, 33.88256], [-117.70533, 33.88246], [-117.70508, 33.88385], [-117.70563, 33.88432], [-117.70543, 33.88526], [-117.705, 33.88518], [-117.70423, 33.8845], [-117.70265, 33.88468], [-117.70271, 33.8855], [-117.7031, 33.88682], [-117.7036, 33.88747], [-117.70282, 33.88808], [-117.70342, 33.89001], [-117.70382, 33.8902], [-117.70441, 33.89015], [-117.70684, 33.89051], [-117.7076, 33.89152], [-117.70742, 33.89317], [-117.70772, 33.89317], [-117.70738, 33.89424], [-117.70798, 33.89469]]]} | Open Access 1 | 19014 | Brush Canyon | 8044 | 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 | 320.468 | Brush Canyon | None 938 |
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]);