units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where DES_TP = 4 and MNG_AGENCY = 138 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Orange, County of · 11 ✖
DES_TP 1
- Local Conservation Area · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4293 | 4293 | 4292 | {"type": "MultiPolygon", "coordinates": [[[[-117.95287, 33.64312], [-117.95276, 33.64333], [-117.95271, 33.64349], [-117.95257, 33.64351], [-117.95264, 33.64375], [-117.95069, 33.65025], [-117.95032, 33.65064], [-117.95044, 33.65129], [-117.95, 33.65229], [-117.94951, 33.65228], [-117.94959, 33.65208], [-117.94976, 33.65186], [-117.9499, 33.65093], [-117.94928, 33.65063], [-117.94927, 33.64958], [-117.94856, 33.64958], [-117.94555, 33.64794], [-117.94592, 33.64317], [-117.95287, 33.64312]]], [[[-117.9495, 33.65229], [-117.94895, 33.65432], [-117.94797, 33.65773], [-117.94798, 33.65774], [-117.94829, 33.65774], [-117.94686, 33.66245], [-117.94601, 33.66564], [-117.94331, 33.66505], [-117.94417, 33.65804], [-117.94509, 33.65806], [-117.94565, 33.65663], [-117.9479, 33.65483], [-117.949, 33.6525], [-117.94937, 33.65235], [-117.94941, 33.65231], [-117.94949, 33.65231], [-117.9495, 33.65229]]]]} | Open Access 1 | 14649 | Talbert Nature Preserve | 26171 | 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 | 185.716 | Talbert Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
8944 | 8944 | 8943 | {"type": "Polygon", "coordinates": [[[-117.6065, 33.57802], [-117.60444, 33.58313], [-117.60292, 33.58443], [-117.60349, 33.58621], [-117.60152, 33.58923], [-117.60153, 33.58954], [-117.60126, 33.58957], [-117.60003, 33.58954], [-117.59886, 33.58924], [-117.59864, 33.58915], [-117.59842, 33.58905], [-117.59742, 33.58853], [-117.59811, 33.58757], [-117.59779, 33.58641], [-117.59838, 33.58607], [-117.59904, 33.58709], [-117.60161, 33.58604], [-117.601, 33.58493], [-117.5993, 33.58458], [-117.59911, 33.58412], [-117.59841, 33.58376], [-117.5984, 33.58328], [-117.59915, 33.58292], [-117.59916, 33.58291], [-117.59845, 33.58218], [-117.59691, 33.58136], [-117.59628, 33.58146], [-117.59535, 33.58126], [-117.59468, 33.58185], [-117.59492, 33.58346], [-117.59536, 33.58488], [-117.59585, 33.58583], [-117.59587, 33.58657], [-117.59547, 33.58731], [-117.59529, 33.58713], [-117.59506, 33.58685], [-117.59494, 33.58666], [-117.59474, 33.58629], [-117.59462, 33.586], [-117.59372, 33.58359], [-117.59352, 33.58292], [-117.59343, 33.58222], [-117.5933, 33.57992], [-117.59327, 33.57957], [-117.5931, 33.57874], [-117.59284, 33.57793], [-117.59175, 33.57517], [-117.59152, 33.57466], [-117.59121, 33.57421], [-117.59102, 33.57397], [-117.59102, 33.57387], [-117.59128, 33.57367], [-117.59141, 33.57348], [-117.5915, 33.57326], [-117.59158, 33.57301], [-117.59186, 33.5727], [-117.59183, 33.57252], [-117.59189, 33.57233], [-117.59187, 33.57232], [-117.59189, 33.57226], [-117.59187, 33.57217], [-117.59196, 33.57205], [-117.59212, 33.57166], [-117.5922, 33.5713], [-117.5923, 33.57106], [-117.5926, 33.57051], [-117.59258, 33.57017], [-117.59264, 33.56983], [-117.59264, 33.56968], [-117.59259, 33.56955], [-117.5925, 33.56943], [-117.59255, 33.56941], [-117.59253, 33.56935], [-117.59248, 33.56936], [-117.59239, 33.56888], [-117.59227, 33.56861], [-117.5923, 33.56853], [-117.59218, 33.56824], [-117.59221, 33.56815], [-117.59209, 33.56792], [-117.59194, 33.56771], [-117.59188, 33.56756], [-117.59191, 33.56743], [-117.5918, 33.56687], [-117.59169, 33.5668], [-117.59154, 33.56603], [-117.5915, 33.566], [-117.59126, 33.565], [-117.59117, 33.56475], [-117.59102, 33.56452], [-117.59089, 33.56438], [-117.59085, 33.5643], [-117.59081, 33.56411], [-117.59061, 33.56381], [-117.59044, 33.56322], [-117.58997, 33.56258], [-117.59006, 33.56213], [-117.58955, 33.56143], [-117.58953, 33.56089], [-117.58895, 33.56023], [-117.58872, 33.5603], [-117.58869, 33.56017], [-117.5896, 33.55987], [-117.58984, 33.56003], [-117.58988, 33.56008], [-117.58986, 33.56021], [-117.58991, 33.5603], [-117.59022, 33.56071], [-117.59039, 33.56096], [-117.59052, 33.56121], [-117.59057, 33.5614], [-117.59065, 33.56217], [-117.59074, 33.56272], [-117.59083, 33.56285], [-117.59098, 33.56294], [-117.59101, 33.56303], [-117.59105, 33.56324], [-117.59118, 33.56348], [-117.59119, 33.56354], [-117.59116, 33.56361], [-117.59117, 33.56363], [-117.59115, 33.56364], [-117.59117, 33.56367], [-117.59154, 33.5637], [-117.5916, 33.56372], [-117.59165, 33.56388], [-117.59157, 33.56409], [-117.59159, 33.56416], [-117.59167, 33.56427], [-117.59186, 33.56442], [-117.59196, 33.56457], [-117.59201, 33.56471], [-117.59211, 33.56489], [-117.59212, 33.56493], [-117.59209, 33.56499], [-117.59218, 33.56516], [-117.59277, 33.56604], [-117.59291, 33.56615], [-117.59298, 33.56613], [-117.59332, 33.56641], [-117.59366, 33.5664], [-117.59374, 33.56666], [-117.59368, 33.56671], [-117.59367, 33.56678], [-117.59345, 33.56683], [-117.59322, 33.56683], [-117.59321, 33.56685], [-117.59303, 33.5668], [-117.59281, 33.56678], [-117.59259, 33.56682], [-117.59254, 33.56693], [-117.59255, 33.56695], [-117.59301, 33.56688], [-117.59323, 33.56694], [-117.59323, 33.56697], [-117.59303, 33.56708], [-117.59266, 33.56717], [-117.59247, 33.56714], [-117.59243, 33.56723], [-117.59243, 33.56724], [-117.59262, 33.56725], [-117.59289, 33.56724], [-117.59325, 33.56705], [-117.59329, 33.56705], [-117.59335, 33.56708], [-117.5934, 33.56719], [-117.59342, 33.56731], [-117.59299, 33.5674], [-117.5927, 33.56754], [-117.59259, 33.56763], [-117.59252, 33.56772], [-117.59256, 33.56781], [-117.59283, 33.56804], [-117.59284, 33.56806], [-117.59311, 33.56835], [-117.59328, 33.56856], [-117.59387, 33.56829], [-117.59564, 33.56823], [-117.59644, 33.56851], [-117.59728, 33.56906], [-117.59911, 33.56853], [-117.59982, 33.56826], [-117.60035, 33.56799], [-117.60094, 33.56759], [-117.60151, 33.5671], [-117.6016, 33.567], [-117.60488, 33.5695], [-117.60415, 33.57061], [-117.60392, 33.57061], [-117.60392, 33.5708], [-117.60416, 33.5708], [-117.60418, 33.57394], [-117.6065, 33.57802]], [[-117.59214, 33.57245], [-117.59214, 33.57244], [-117.59211, 33.57243], [-117.59187, 33.57269], [-117.59187, 33.57274], [-117.59189, 33.57274], [-117.59214, 33.57245]], [[-117.59201, 33.56742], [-117.5921, 33.56737], [-117.59217, 33.56731], [-117.59206, 33.56724], [-117.59194, 33.56735], [-117.59201, 33.56742]]]} | Open Access 1 | 14736 | Thomas F. Riley Wilderness Park | 32174 | 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://ocparks.com/parks/thomas | Orange 3 | 548.305 | Thomas F. Riley Wilderness Park | 0 | Local Conservation Area 4 | 2 |
6822 | 6822 | 6821 | {"type": "Polygon", "coordinates": [[[-117.62507, 33.71426], [-117.625, 33.72236], [-117.60794, 33.72201], [-117.60775, 33.71487], [-117.60784, 33.70771], [-117.61874, 33.70763], [-117.61878, 33.70996], [-117.61824, 33.70967], [-117.61753, 33.70957], [-117.61732, 33.70945], [-117.61703, 33.70906], [-117.61678, 33.70896], [-117.61663, 33.70894], [-117.61635, 33.70931], [-117.61627, 33.70933], [-117.61626, 33.70936], [-117.61636, 33.7094], [-117.61532, 33.71035], [-117.61585, 33.71073], [-117.61536, 33.71126], [-117.61536, 33.71128], [-117.62059, 33.71128], [-117.62058, 33.71484], [-117.61991, 33.71483], [-117.61888, 33.71687], [-117.61768, 33.71763], [-117.61769, 33.71764], [-117.61842, 33.71808], [-117.61985, 33.71706], [-117.62036, 33.71731], [-117.62145, 33.71663], [-117.62385, 33.71423], [-117.62507, 33.71426]]]} | Open Access 1 | 5397 | Modjeska Canyon and Tucker Wildlife Sanctuary | 29285 | 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.caopenspace.org/modjeska.html | Orange 3 | 506.269 | Modjeska Canyon and Tucker Wildlife Sanctuary | 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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);