units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
88 rows where ACCESS_TYP = 1 and MNG_AGENCY = 138 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16364 | 16364 | 16363 | {"type": "Polygon", "coordinates": [[[-117.78127, 33.86017], [-117.78126, 33.86048], [-117.78076, 33.86071], [-117.76229, 33.86967], [-117.76089, 33.87029], [-117.75995, 33.87067], [-117.7585, 33.8712], [-117.75664, 33.8718], [-117.75577, 33.87211], [-117.75492, 33.87244], [-117.75365, 33.87297], [-117.75361, 33.87262], [-117.75407, 33.87242], [-117.75549, 33.87185], [-117.75646, 33.87151], [-117.75743, 33.87119], [-117.75748, 33.87124], [-117.75843, 33.87093], [-117.75937, 33.87059], [-117.76077, 33.87004], [-117.76213, 33.86943], [-117.78035, 33.86059], [-117.78127, 33.86017]]]} | Open Access 1 | 47964 | Yorba Regional Park | 27778 | 2420 | Orange County Flood Control District 1171 | Special District 4 | Flood District 8 | http://www.ocflood.com/ | Special District 4 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 22.503 | Yorba RP | 0 | Local Park 2 | 4 |
9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 0 | Local Park 2 | 4 |
9944 | 9944 | 9943 | {"type": "MultiPolygon", "coordinates": [[[[-117.76222, 33.57793], [-117.76221, 33.57794], [-117.76006, 33.57795], [-117.76026, 33.57771], [-117.76114, 33.57773], [-117.76143, 33.57793], [-117.76222, 33.57793]]], [[[-117.77259, 33.55359], [-117.77256, 33.55666], [-117.77201, 33.55663], [-117.76932, 33.56064], [-117.76878, 33.56109], [-117.76727, 33.56041], [-117.7667, 33.56206], [-117.76664, 33.56205], [-117.7666, 33.56215], [-117.7658, 33.56183], [-117.76493, 33.56185], [-117.76466, 33.56149], [-117.76455, 33.56156], [-117.76453, 33.5622], [-117.76368, 33.56271], [-117.76348, 33.56293], [-117.76318, 33.56274], [-117.76278, 33.56327], [-117.76256, 33.56377], [-117.76247, 33.56426], [-117.76112, 33.5641], [-117.76072, 33.56636], [-117.76207, 33.56653], [-117.75923, 33.56645], [-117.75918, 33.56686], [-117.76061, 33.56704], [-117.76061, 33.56707], [-117.76069, 33.56713], [-117.76069, 33.56718], [-117.76067, 33.56722], [-117.76039, 33.56743], [-117.76027, 33.56759], [-117.76019, 33.56759], [-117.76035, 33.56791], [-117.76016, 33.56896], [-117.76133, 33.56911], [-117.76097, 33.56993], [-117.7611, 33.57], [-117.76118, 33.57007], [-117.7615, 33.57067], [-117.76154, 33.57078], [-117.76156, 33.5709], [-117.76155, 33.57102], [-117.76141, 33.57135], [-117.7614, 33.57142], [-117.76142, 33.57148], [-117.7615, 33.57156], [-117.76215, 33.57203], [-117.76225, 33.57214], [-117.76232, 33.57226], [-117.76235, 33.57238], [-117.76235, 33.57277], [-117.76007, 33.57278], [-117.76007, 33.57432], [-117.75934, 33.57433], [-117.7592, 33.57794], [-117.7612, 33.57802], [-117.76104, 33.57874], [-117.76203, 33.57874], [-117.76191, 33.57929], [-117.7609, 33.57931], [-117.76069, 33.58024], [-117.75555, 33.5803], [-117.75557, 33.58188], [-117.74937, 33.58194], [-117.74941, 33.5563], [-117.75694, 33.55625], [-117.75696, 33.55673], [-117.75807, 33.55671], [-117.75809, 33.55692], [-117.75932, 33.55689], [-117.75975, 33.5562], [-117.76386, 33.55613], [-117.767, 33.55632], [-117.76702, 33.555], [-117.76729, 33.555], [-117.76729, 33.55468], [-117.76928, 33.55469], [-117.76931, 33.55466], [-117.76913, 33.55443], [-117.76888, 33.55429], [-117.76859, 33.55416], [-117.76841, 33.554], [-117.76854, 33.55404], [-117.76864, 33.55404], [-117.76911, 33.55386], [-117.76921, 33.5538], [-117.76934, 33.55369], [-117.76926, 33.55357], [-117.76982, 33.5536], [-117.77029, 33.55356], [-117.77069, 33.5535], [-117.77127, 33.55354], [-117.77125, 33.55326], [-117.77142, 33.55327], [-117.77259, 33.55359]], [[-117.75922, 33.57949], [-117.75919, 33.57946], [-117.7588, 33.57963], [-117.75901, 33.57998], [-117.75941, 33.57981], [-117.75922, 33.57949]], [[-117.75533, 33.57725], [-117.75514, 33.57779], [-117.75556, 33.5779], [-117.75572, 33.57773], [-117.75573, 33.57765], [-117.75563, 33.57732], [-117.75533, 33.57725]], [[-117.75784, 33.57433], [-117.75754, 33.57433], [-117.75754, 33.57464], [-117.75784, 33.57464], [-117.75784, 33.57433]], [[-117.76033, 33.55702], [-117.76033, 33.55718], [-117.7603, 33.55734], [-117.76024, 33.55749], [-117.76015, 33.55763], [-117.76026, 33.55783], [-117.76039, 33.55798], [-117.76058, 33.55808], [-117.76073, 33.55812], [-117.76088, 33.55812], [-117.76102, 33.5581], [-117.76116, 33.55805], [-117.76128, 33.55798], [-117.76138, 33.55788], [-117.76147, 33.55771], [-117.76149, 33.55753], [-117.76143, 33.55735], [-117.76131, 33.55719], [-117.76113, 33.55708], [-117.76099, 33.55704], [-117.76084, 33.55702], [-117.76033, 33.55702]]]]} | Open Access 1 | 47960 | Aliso and Wood Canyons Wilderness Park | 8041 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/aliso | Orange 3 | 885.097 | Aliso and Wood Canyons Wilderness Park | 0 | Local Conservation Area 4 | 2 |
14690 | 14690 | 14689 | {"type": "MultiPolygon", "coordinates": [[[[-118.07693, 33.72934], [-118.0768, 33.72967], [-118.07605, 33.7304], [-118.06997, 33.73039], [-118.071, 33.72955], [-118.07185, 33.72959], [-118.07242, 33.72965], [-118.07248, 33.72963], [-118.07273, 33.72967], [-118.07272, 33.72961], [-118.07273, 33.72957], [-118.07283, 33.72939], [-118.07291, 33.7293], [-118.07302, 33.72921], [-118.07321, 33.72907], [-118.07344, 33.72896], [-118.07363, 33.72888], [-118.07386, 33.72881], [-118.0741, 33.72877], [-118.07429, 33.729], [-118.07423, 33.72927], [-118.07389, 33.72947], [-118.07379, 33.7298], [-118.07483, 33.72994], [-118.07603, 33.72987], [-118.07624, 33.7297], [-118.07617, 33.7294], [-118.07616, 33.72921], [-118.0763, 33.72904], [-118.07693, 33.72934]]], [[[-118.08125, 33.72954], [-118.08108, 33.72965], [-118.08084, 33.72973], [-118.08082, 33.72994], [-118.08091, 33.73], [-118.08074, 33.73008], [-118.08067, 33.7302], [-118.08049, 33.73035], [-118.08026, 33.73039], [-118.07999, 33.73038], [-118.07968, 33.7304], [-118.07691, 33.7304], [-118.07732, 33.73003], [-118.07773, 33.72887], [-118.0786, 33.72857], [-118.07912, 33.72844], [-118.08014, 33.72894], [-118.08047, 33.7293], [-118.08064, 33.72946], [-118.08073, 33.72938], [-118.08114, 33.72944], [-118.08125, 33.72954]]]]} | Open Access 1 | 45012 | Sunset Harbor | 26046 | 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 | 27.07 | Sunset Harbor | None 1259 | |||
16210 | 16210 | 16209 | {"type": "Polygon", "coordinates": [[[-117.79786, 33.79687], [-117.79697, 33.79689], [-117.79699, 33.80001], [-117.79692, 33.80257], [-117.79603, 33.80165], [-117.79601, 33.80166], [-117.79605, 33.80244], [-117.79636, 33.8025], [-117.79654, 33.80249], [-117.79645, 33.80291], [-117.797, 33.80302], [-117.7972, 33.8029], [-117.79765, 33.80341], [-117.79758, 33.80342], [-117.79731, 33.80361], [-117.79716, 33.80362], [-117.79714, 33.80366], [-117.79648, 33.80353], [-117.79628, 33.80414], [-117.79612, 33.80457], [-117.7957, 33.80529], [-117.79569, 33.8058], [-117.79585, 33.80604], [-117.79574, 33.80649], [-117.7957, 33.80634], [-117.79568, 33.80618], [-117.79562, 33.80602], [-117.79552, 33.80588], [-117.79541, 33.80577], [-117.79533, 33.80572], [-117.79549, 33.80554], [-117.79545, 33.80531], [-117.7951, 33.80438], [-117.79474, 33.80371], [-117.79303, 33.80422], [-117.79285, 33.80399], [-117.79248, 33.80302], [-117.79273, 33.80195], [-117.7926, 33.8016], [-117.79241, 33.80164], [-117.79254, 33.80095], [-117.79256, 33.80077], [-117.79255, 33.8004], [-117.79249, 33.80003], [-117.79245, 33.79986], [-117.79225, 33.79934], [-117.79175, 33.79836], [-117.79166, 33.798], [-117.79161, 33.7976], [-117.79159, 33.79734], [-117.7916, 33.79702], [-117.79164, 33.79674], [-117.79175, 33.79638], [-117.79183, 33.79615], [-117.79242, 33.79519], [-117.79266, 33.79463], [-117.79284, 33.79395], [-117.79288, 33.79333], [-117.79301, 33.79279], [-117.79313, 33.7925], [-117.7934, 33.79209], [-117.79418, 33.79178], [-117.79474, 33.79176], [-117.79538, 33.79184], [-117.79635, 33.7925], [-117.79678, 33.79246], [-117.79704, 33.79294], [-117.79723, 33.79294], [-117.79729, 33.79329], [-117.79749, 33.79434], [-117.79657, 33.79485], [-117.79655, 33.79592], [-117.79786, 33.79687]]]} | Open Access 1 | 44429 | Orange County Open Space | 23152 | 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 | 141.749 | Orange County OS | 0 | Local Recreation Area 3 | 4 | |
13983 | 13983 | 13982 | {"type": "Polygon", "coordinates": [[[-117.64491, 33.56844], [-117.64472, 33.56847], [-117.64447, 33.56847], [-117.64433, 33.56843], [-117.64421, 33.56756], [-117.6448, 33.56756], [-117.64491, 33.56844]]]} | Open Access 1 | 36656 | Orange holding 10 | 23157 | 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.331 | Orange holding 10 | 0 | Local Other or Unknown 14 | 4 | |
12496 | 12496 | 12495 | {"type": "Polygon", "coordinates": [[[-117.77687, 33.7649], [-117.77713, 33.76457], [-117.77646, 33.76411], [-117.77593, 33.76388], [-117.77537, 33.76368], [-117.77447, 33.76339], [-117.77528, 33.76258], [-117.77535, 33.76253], [-117.77543, 33.76254], [-117.77665, 33.76339], [-117.77667, 33.76338], [-117.77774, 33.76413], [-117.77775, 33.76416], [-117.77773, 33.7642], [-117.7774, 33.76452], [-117.77704, 33.76493], [-117.77697, 33.76495], [-117.77687, 33.7649]]]} | Open Access 1 | 36503 | Orange holding 19 | 23166 | 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 | 6.636 | Orange holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13546 | 13546 | 13545 | {"type": "Polygon", "coordinates": [[[-117.63087, 33.67292], [-117.63058, 33.67337], [-117.6304, 33.67329], [-117.63037, 33.67331], [-117.63009, 33.67319], [-117.62988, 33.67335], [-117.62977, 33.6733], [-117.62957, 33.67326], [-117.62939, 33.67329], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62914, 33.67323], [-117.62913, 33.67308], [-117.62914, 33.67295], [-117.62924, 33.67274], [-117.62944, 33.67259], [-117.62946, 33.67244], [-117.62955, 33.67229], [-117.63087, 33.67292]]]} | Open Access 1 | 35861 | Orange holding 4 | 23171 | 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.903 | Orange holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13530 | 13530 | 13529 | {"type": "Polygon", "coordinates": [[[-117.63308, 33.68047], [-117.63275, 33.68098], [-117.63268, 33.68098], [-117.63235, 33.6812], [-117.63229, 33.68167], [-117.63149, 33.68159], [-117.63135, 33.68156], [-117.63122, 33.68152], [-117.63106, 33.68143], [-117.63107, 33.68139], [-117.63124, 33.6812], [-117.63246, 33.68007], [-117.63255, 33.68007], [-117.63308, 33.68047]]]} | Open Access 1 | 35831 | Orange holding 1 | 23155 | 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 | 3.943 | Orange holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13486 | 13486 | 13485 | {"type": "Polygon", "coordinates": [[[-117.63374, 33.56465], [-117.63372, 33.56475], [-117.63293, 33.56513], [-117.63284, 33.56515], [-117.63278, 33.5651], [-117.63282, 33.56506], [-117.63252, 33.5646], [-117.63244, 33.56458], [-117.63241, 33.56453], [-117.63243, 33.56448], [-117.6333, 33.56407], [-117.63336, 33.56409], [-117.63374, 33.56465]]]} | Open Access 1 | 35771 | Orange holding 20 | 23168 | 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.058 | Orange holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13485 | 13485 | 13484 | {"type": "Polygon", "coordinates": [[[-117.63608, 33.56053], [-117.63599, 33.56078], [-117.63595, 33.56079], [-117.63584, 33.561], [-117.63553, 33.56083], [-117.63503, 33.56079], [-117.63423, 33.56105], [-117.63372, 33.56095], [-117.63375, 33.56083], [-117.63376, 33.56069], [-117.63371, 33.56049], [-117.63382, 33.5605], [-117.63434, 33.56033], [-117.6345, 33.56025], [-117.63477, 33.56004], [-117.63505, 33.55994], [-117.6351, 33.55995], [-117.63526, 33.56023], [-117.63598, 33.56045], [-117.636, 33.5605], [-117.63608, 33.56053]]]} | Open Access 1 | 35770 | Orange holding 16 | 23163 | 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 | 3.721 | Orange holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13484 | 13484 | 13483 | {"type": "Polygon", "coordinates": [[[-117.63313, 33.56218], [-117.63304, 33.56249], [-117.63298, 33.56252], [-117.63183, 33.56229], [-117.6318, 33.56224], [-117.63188, 33.56194], [-117.63193, 33.5619], [-117.6331, 33.56213], [-117.63313, 33.56218]]]} | Open Access 1 | 35769 | Orange holding 18 | 23165 | 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.289 | Orange holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13483 | 13483 | 13482 | {"type": "Polygon", "coordinates": [[[-117.63393, 33.55687], [-117.63377, 33.55721], [-117.63341, 33.55741], [-117.63334, 33.55739], [-117.63329, 33.55683], [-117.63343, 33.55627], [-117.6335, 33.55627], [-117.63383, 33.55651], [-117.63393, 33.55687]]]} | Open Access 1 | 35768 | Orange holding 21 | 23169 | 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.279 | Orange holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13482 | 13482 | 13481 | {"type": "Polygon", "coordinates": [[[-117.64438, 33.54846], [-117.64365, 33.54864], [-117.64349, 33.5483], [-117.64349, 33.54828], [-117.64352, 33.54825], [-117.64417, 33.54807], [-117.64421, 33.54807], [-117.64424, 33.5481], [-117.64438, 33.54846]]]} | Open Access 1 | 35767 | Orange holding 17 | 23164 | 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.821 | Orange holding 17 | 0 | Local Other or Unknown 14 | 4 | |
393 | 393 | 392 | {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} | Open Access 1 | 35761 | Orange holding 15 | 23162 | 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.023 | Orange holding 15 | 0 | Local Other or Unknown 14 | 4 | |
392 | 392 | 391 | {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} | Open Access 1 | 35760 | Orange holding 14 | 23161 | 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.99 | Orange holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13478 | 13478 | 13477 | {"type": "Polygon", "coordinates": [[[-117.63733, 33.55174], [-117.6369, 33.55204], [-117.63667, 33.55227], [-117.63653, 33.55225], [-117.63645, 33.55234], [-117.63651, 33.55243], [-117.63629, 33.55265], [-117.63566, 33.55222], [-117.63428, 33.55282], [-117.63399, 33.55224], [-117.6338, 33.55163], [-117.63384, 33.55152], [-117.63396, 33.55146], [-117.63704, 33.55126], [-117.63716, 33.55152], [-117.63733, 33.55174]]]} | Open Access 1 | 35756 | Orange holding 13 | 23160 | 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 | 8.81 | Orange holding 13 | 0 | Local Other or Unknown 14 | 4 | |
3887 | 3887 | 3886 | {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} | Open Access 1 | 35755 | Orange holding 9 | 23176 | 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.436 | Orange holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13439 | 13439 | 13438 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | 35572 | Orange holding 3 | 23170 | 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.452 | Orange holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13438 | 13438 | 13437 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | 35571 | Orange holding 2 | 23167 | 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.227 | Orange holding 2 | 0 | Local Other or Unknown 14 | 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]);