units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 3, GAP_STS = 2 and MNG_AGENCY = 4
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5384 | 5384 | 5383 | {"type": "MultiPolygon", "coordinates": [[[[-116.68414, 32.63592], [-116.68408, 32.63754], [-116.68186, 32.63754], [-116.68193, 32.63587], [-116.68414, 32.63592]]], [[[-116.73738, 32.62107], [-116.72053, 32.62112], [-116.72052, 32.62207], [-116.72052, 32.62295], [-116.7117, 32.62354], [-116.71149, 32.62647], [-116.70719, 32.6268], [-116.70737, 32.63295], [-116.69486, 32.63301], [-116.6948, 32.63927], [-116.69518, 32.64285], [-116.69112, 32.64286], [-116.69177, 32.64642], [-116.68717, 32.64646], [-116.68654, 32.64172], [-116.68619, 32.63925], [-116.68626, 32.63596], [-116.68515, 32.63593], [-116.6852, 32.63414], [-116.68522, 32.63386], [-116.68629, 32.63392], [-116.68627, 32.63595], [-116.69052, 32.63602], [-116.6907, 32.62656], [-116.69491, 32.62661], [-116.69487, 32.61949], [-116.69897, 32.61962], [-116.69898, 32.61612], [-116.70769, 32.61631], [-116.71809, 32.61565], [-116.71841, 32.61579], [-116.71976, 32.61606], [-116.72042, 32.61573], [-116.72048, 32.61573], [-116.7205, 32.61766], [-116.72724, 32.61758], [-116.72721, 32.61799], [-116.72733, 32.61851], [-116.72734, 32.61863], [-116.7274, 32.6188], [-116.72749, 32.61894], [-116.7276, 32.61905], [-116.72772, 32.61914], [-116.72798, 32.61926], [-116.72822, 32.61931], [-116.72844, 32.61931], [-116.72863, 32.61927], [-116.72879, 32.61922], [-116.72899, 32.6191], [-116.72916, 32.61894], [-116.72964, 32.61831], [-116.73109, 32.61792], [-116.73167, 32.61772], [-116.73243, 32.61755], [-116.73313, 32.61755], [-116.73314, 32.61739], [-116.73495, 32.61697], [-116.73551, 32.61686], [-116.73599, 32.6168], [-116.73648, 32.61676], [-116.737, 32.61675], [-116.73737, 32.61677], [-116.73738, 32.62107]]], [[[-116.73102, 32.61755], [-116.72988, 32.61781], [-116.72962, 32.6179], [-116.72943, 32.61801], [-116.72935, 32.61808], [-116.72835, 32.61869], [-116.72789, 32.61859], [-116.72763, 32.61823], [-116.72768, 32.61763], [-116.72773, 32.61758], [-116.73102, 32.61755]]], [[[-116.73736, 32.61645], [-116.73617, 32.61654], [-116.73521, 32.61659], [-116.73314, 32.61707], [-116.73303, 32.61407], [-116.73736, 32.61399], [-116.73736, 32.61645]]]]} | No Public Access 3 | 7400 | MSCP Open Space Preserve Land | 22572 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1276.75 | MSCP OSP Land | 0 | Local Conservation Area 4 | 2 | |
| 7953 | 7953 | 7952 | {"type": "MultiPolygon", "coordinates": [[[[-116.95582, 33.09367], [-116.95482, 33.09407], [-116.95304, 33.09459], [-116.95185, 33.09475], [-116.95079, 33.09468], [-116.94644, 33.09467], [-116.94635, 33.09069], [-116.95067, 33.09066], [-116.95146, 33.09064], [-116.95215, 33.09074], [-116.95268, 33.09087], [-116.95322, 33.09107], [-116.95366, 33.09136], [-116.95423, 33.09182], [-116.95582, 33.09367]]], [[[-116.96354, 33.09], [-116.96328, 33.0901], [-116.96266, 33.09026], [-116.96248, 33.09039], [-116.96176, 33.09047], [-116.96159, 33.09052], [-116.96148, 33.09059], [-116.96126, 33.09065], [-116.96084, 33.09068], [-116.9606, 33.09061], [-116.96027, 33.09065], [-116.95962, 33.09077], [-116.95925, 33.09081], [-116.95875, 33.0907], [-116.95847, 33.09082], [-116.95834, 33.09099], [-116.95834, 33.09114], [-116.95816, 33.09119], [-116.95783, 33.09142], [-116.95655, 33.09153], [-116.95586, 33.09154], [-116.95554, 33.09157], [-116.95504, 33.09156], [-116.95511, 33.09141], [-116.95514, 33.09127], [-116.95509, 33.08796], [-116.95505, 33.08774], [-116.95503, 33.08773], [-116.95502, 33.08757], [-116.95499, 33.08605], [-116.95502, 33.08596], [-116.9551, 33.08587], [-116.95544, 33.08564], [-116.95577, 33.08548], [-116.95587, 33.08545], [-116.95736, 33.08523], [-116.96048, 33.08484], [-116.96078, 33.08475], [-116.96235, 33.08411], [-116.96281, 33.08397], [-116.9634, 33.08386], [-116.96354, 33.09]]], [[[-117.02348, 33.08538], [-117.02157, 33.08742], [-117.02158, 33.08743], [-117.02264, 33.08743], [-117.02206, 33.08791], [-117.02174, 33.08824], [-117.02153, 33.08848], [-117.02053, 33.08982], [-117.02044, 33.09001], [-117.02038, 33.09019], [-117.02034, 33.09042], [-117.02035, 33.09063], [-117.0116, 33.09079], [-117.0116, 33.09094], [-117.01156, 33.09095], [-117.01158, 33.09175], [-117.01257, 33.09174], [-117.01255, 33.09092], [-117.01578, 33.09088], [-117.02036, 33.09079], [-117.02093, 33.09749], [-117.01991, 33.09827], [-117.01977, 33.09836], [-117.01938, 33.09855], [-117.01901, 33.09866], [-117.01878, 33.09871], [-117.01757, 33.09878], [-117.01756, 33.09866], [-117.01585, 33.09866], [-117.01584, 33.09821], [-117.01414, 33.09824], [-117.01388, 33.09797], [-117.01286, 33.09673], [-117.01275, 33.09663], [-117.01257, 33.09647], [-117.01226, 33.09626], [-117.01195, 33.09609], [-117.01165, 33.09596], [-117.01115, 33.09581], [-117.01065, 33.09572], [-117.0102, 33.0957], [-117.00977, 33.09572], [-117.00692, 33.09541], [-117.00447, 33.09477], [-116.99519, 33.09143], [-116.99507, 33.09161], [-116.99469, 33.09146], [-116.99422, 33.09121], [-116.99378, 33.09095], [-116.99262, 33.09003], [-116.99214, 33.08948], [-116.99193, 33.08891], [-116.99171, 33.08772], [-116.99157, 33.08724], [-116.9913, 33.08679], [-116.99107, 33.08645], [-116.99085, 33.08621], [-116.99067, 33.08606], [-116.99029, 33.0859], [-116.99001, 33.08583], [-116.98977, 33.08579], [-116.9897, 33.08577], [-116.98927, 33.08577], [-116.98878, 33.0858], [-116.98836, 33.08591], [-116.98818, 33.08598], [-116.98706, 33.08657], [-116.98639, 33.08686], [-116.98418, 33.08765], [-116.98363, 33.08788], [-116.98249, 33.0883], [-116.98225, 33.08836], [-116.98176, 33.08844], [-116.981, 33.08851], [-116.98052, 33.0886], [-116.97455, 33.09021], [-116.97207, 33.09097], [-116.97147, 33.09108], [-116.96921, 33.09146], [-116.96875, 33.09156], [-116.96831, 33.09172], [-116.96602, 33.09259], [-116.96559, 33.09271], [-116.96443, 33.09296], [-116.96415, 33.09304], [-116.96378, 33.0932], [-116.96371, 33.0913], [-116.96365, 33.084], [-116.96374, 33.08388], [-116.96792, 33.08311], [-116.9694, 33.08286], [-116.97034, 33.08223], [-116.97079, 33.08174], [-116.97174, 33.08094], [-116.97235, 33.08027], [-116.97262, 33.08004], [-116.97365, 33.07856], [-116.97394, 33.07792], [-116.97407, 33.07751], [-116.97438, 33.07592], [-116.97443, 33.07579], [-116.97455, 33.07551], [-116.97467, 33.07534], [-116.97491, 33.07512], [-116.97515, 33.07497], [-116.97774, 33.07378], [-116.97812, 33.07362], [-116.97826, 33.07361], [-116.97841, 33.0737], [-116.9786, 33.07378], [-116.97881, 33.07407], [-116.97921, 33.07418], [-116.97937, 33.07439], [-116.97951, 33.07453], [-116.97976, 33.07462], [-116.97994, 33.0747], [-116.98001, 33.07477], [-116.98008, 33.07494], [-116.98024, 33.07506], [-116.9804, 33.07511], [-116.98055, 33.07519], [-116.98062, 33.07528], [-116.98066, 33.07535], [-116.98078, 33.07546], [-116.98108, 33.07554], [-116.98122, 33.0756], [-116.98136, 33.07578], [-116.98162, 33.07593], [-116.9817, 33.07605], [-116.98183, 33.07617], [-116.98216, 33.0763], [-116.98226, 33.07636], [-116.98236, 33.07647], [-116.98249, 33.07656], [-116.98264, 33.07661], [-116.98283, 33.07669], [-116.983, 33.07678], [-116.98317, 33.07691], [-116.9833, 33.07696], [-116.9836, 33.07695], [-116.98371, 33.07709], [-116.98393, 33.07715], [-116.98413, 33.07722], [-116.98429, 33.07734], [-116.98463, 33.07768], [-116.9849, 33.07774], [-116.98502, 33.07782], [-116.98518, 33.07787], [-116.98533, 33.07787], [-116.98568, 33.07779], [-116.98582, 33.07784], [-116.98623, 33.07783], [-116.98639, 33.07788], [-116.98656, 33.0779], [-116.98673, 33.07786], [-116.98678, 33.07773], [-116.98671, 33.07765], [-116.98672, 33.07752], [-116.9868, 33.07746], [-116.98706, 33.07735], [-116.98754, 33.07724], [-116.98767, 33.07725], [-116.98781, 33.07721], [-116.99018, 33.0768], [-116.99224, 33.0764], [-116.99598, 33.07552], [-116.99606, 33.07634], [-116.9963, 33.07624], [-116.99652, 33.07647], [-116.9968, 33.07652], [-116.99702, 33.07647], [-116.99718, 33.07663], [-116.9974, 33.07698], [-116.99742, 33.07707], [-116.99744, 33.0771], [-116.99757, 33.07712], [-116.99761, 33.07716], [-116.9976, 33.07724], [-116.99764, 33.07727], [-116.99768, 33.07728], [-116.9978, 33.07724], [-116.99797, 33.07726], [-116.99801, 33.07723], [-116.99802, 33.07719], [-116.99795, 33.0771], [-116.99797, 33.07704], [-116.998, 33.07702], [-116.99803, 33.07701], [-116.99815, 33.07703], [-116.99818, 33.077], [-116.99818, 33.07697], [-116.9982, 33.07695], [-116.99823, 33.07695], [-116.99826, 33.077], [-116.9983, 33.07701], [-116.99833, 33.07699], [-116.99836, 33.07694], [-116.99837, 33.07657], [-116.99841, 33.07652], [-116.99844, 33.07652], [-116.99856, 33.07657], [-116.99869, 33.07658], [-116.99873, 33.0766], [-116.99876, 33.07663], [-116.99882, 33.07676], [-116.99887, 33.07679], [-116.99925, 33.07673], [-116.99938, 33.07678], [-116.99953, 33.07675], [-116.99962, 33.0768], [-116.99978, 33.07683], [-116.99993, 33.07682], [-117.00003, 33.07679], [-117.00036, 33.07661], [-117.00039, 33.07648], [-117.0005, 33.07635], [-117.00052, 33.0763], [-117.00051, 33.07621], [-117.00046, 33.07615], [-117.00056, 33.07613], [-117.00056, 33.07611], [-117.00059, 33.0761], [-117.0007, 33.07609], [-117.00085, 33.07602], [-117.0009, 33.07601], [-117.00108, 33.07605], [-117.00114, 33.07604], [-117.00125, 33.07598], [-117.0013, 33.07597], [-117.00136, 33.07599], [-117.00154, 33.07612], [-117.00156, 33.07616], [-117.00154, 33.07622], [-117.0016, 33.07641], [-117.0016, 33.07651], [-117.00163, 33.07656], [-117.0019, 33.0766], [-117.00199, 33.07661], [-117.00207, 33.07658], [-117.00214, 33.07654], [-117.00219, 33.07648], [-117.00263, 33.07638], [-117.00267, 33.0764], [-117.0027, 33.07647], [-117.00273, 33.07649], [-117.00277, 33.07651], [-117.00285, 33.07652], [-117.00296, 33.07633], [-117.0031, 33.07626], [-117.00323, 33.07624], [-117.00362, 33.07603], [-117.00365, 33.076], [-117.00365, 33.07593], [-117.00367, 33.07591], [-117.00371, 33.0759], [-117.0044, 33.07587], [-117.00451, 33.07589], [-117.00453, 33.07592], [-117.00455, 33.07598], [-117.00504, 33.07626], [-117.00516, 33.07636], [-117.00554, 33.07643], [-117.00577, 33.07652], [-117.0059, 33.07653], [-117.00603, 33.07649], [-117.00612, 33.07649], [-117.00618, 33.07647], [-117.00639, 33.07648], [-117.00646, 33.07647], [-117.0066, 33.07637], [-117.00664, 33.07637], [-117.00676, 33.07641], [-117.00686, 33.07642], [-117.00697, 33.07641], [-117.00723, 33.07651], [-117.00734, 33.07649], [-117.00739, 33.07649], [-117.00747, 33.07656], [-117.00768, 33.07666], [-117.00787, 33.07679], [-117.00798, 33.0769], [-117.00804, 33.07692], [-117.00811, 33.0769], [-117.00817, 33.07679], [-117.00821, 33.07676], [-117.00824, 33.07677], [-117.00827, 33.0768], [-117.00826, 33.07693], [-117.00828, 33.077], [-117.00833, 33.07702], [-117.00853, 33.07703], [-117.00857, 33.07705], [-117.00864, 33.07713], [-117.00873, 33.07716], [-117.00873, 33.0772], [-117.00878, 33.07724], [-117.00899, 33.07725], [-117.00905, 33.07721], [-117.00909, 33.07721], [-117.00928, 33.07731], [-117.00956, 33.07739], [-117.00983, 33.07751], [-117.01021, 33.07771], [-117.01029, 33.07778], [-117.01069, 33.07796], [-117.01107, 33.07807], [-117.01126, 33.07814], [-117.01151, 33.07816], [-117.01157, 33.07822], [-117.01169, 33.07836], [-117.01186, 33.07847], [-117.01196, 33.0785], [-117.01205, 33.0785], [-117.01229, 33.0786], [-117.01257, 33.07864], [-117.0126, 33.07868], [-117.01263, 33.07892], [-117.01272, 33.07911], [-117.01282, 33.07923], [-117.01294, 33.0793], [-117.01306, 33.07942], [-117.01315, 33.07961], [-117.01321, 33.07969], [-117.01327, 33.07983], [-117.01353, 33.08011], [-117.01361, 33.08027], [-117.01375, 33.08043], [-117.01381, 33.08047], [-117.01385, 33.08067], [-117.01387, 33.08074], [-117.01426, 33.0812], [-117.01444, 33.08131], [-117.01466, 33.08137], [-117.01473, 33.08142], [-117.01486, 33.08146], [-117.01514, 33.0815], [-117.01517, 33.08153], [-117.01513, 33.0816], [-117.01512, 33.08217], [-117.01516, 33.08228], [-117.0153, 33.08243], [-117.01535, 33.08251], [-117.01554, 33.08265], [-117.01568, 33.08269], [-117.01595, 33.08279], [-117.01696, 33.08292], [-117.01708, 33.08292], [-117.01715, 33.08304], [-117.01722, 33.0831], [-117.01771, 33.08323], [-117.018, 33.08346], [-117.0183, 33.08373], [-117.01871, 33.08401], [-117.01906, 33.08415], [-117.01915, 33.08416], [-117.01925, 33.08415], [-117.01937, 33.0841], [-117.01964, 33.08382], [-117.02348, 33.08538]]], [[[-117.04573, 33.05118], [-117.04474, 33.05152], [-117.04308, 33.05231], [-117.04264, 33.05248], [-117.04235, 33.05247], [-117.04168, 33.0524], [-117.04068, 33.05248], [-117.03994, 33.05259], [-117.03939, 33.05276], [-117.03893, 33.05306], [-117.03777, 33.05392], [-117.03596, 33.05543], [-117.03554, 33.05592], [-117.03532, 33.05631], [-117.03461, 33.05664], [-117.03313, 33.05669], [-117.03288, 33.05676], [-117.03146, 33.05755], [-117.03104, 33.05785], [-117.03071, 33.05826], [-117.03042, 33.05879], [-117.0303, 33.05931], [-117.03009, 33.06176], [-117.02991, 33.06209], [-117.02961, 33.06223], [-117.0289, 33.06216], [-117.02787, 33.0621], [-117.02767, 33.06227], [-117.02746, 33.06242], [-117.02506, 33.06248], [-117.02505, 33.0624], [-117.02479, 33.06227], [-117.02487, 33.06213], [-117.02472, 33.06195], [-117.0244, 33.06179], [-117.02414, 33.06155], [-117.02314, 33.06163], [-117.02315, 33.05985], [-117.02333, 33.0597], [-117.02364, 33.05989], [-117.02443, 33.05987], [-117.02456, 33.05975], [-117.0244, 33.05901], [-117.02419, 33.05874], [-117.02449, 33.05856], [-117.02518, 33.05849], [-117.02568, 33.05815], [-117.02604, 33.05765], [-117.02602, 33.05749], [-117.0262, 33.05753], [-117.0265, 33.05739], [-117.02634, 33.05727], [-117.02661, 33.05718], [-117.02686, 33.05741], [-117.02742, 33.05708], [-117.0277, 33.05679], [-117.02843, 33.05665], [-117.02954, 33.05553], [-117.02958, 33.05524], [-117.0301, 33.0548], [-117.03009, 33.05449], [-117.0299, 33.05429], [-117.03015, 33.05422], [-117.03029, 33.05385], [-117.02996, 33.05366], [-117.03029, 33.05355], [-117.03004, 33.0532], [-117.02984, 33.0532], [-117.02993, 33.05302], [-117.02977, 33.05283], [-117.02965, 33.05276], [-117.02974, 33.05267], [-117.0298, 33.0525], [-117.03005, 33.05247], [-117.03018, 33.05235], [-117.0302, 33.05221], [-117.03078, 33.05199], [-117.03082, 33.05168], [-117.03101, 33.05176], [-117.03118, 33.0519], [-117.03121, 33.05205], [-117.03142, 33.05222], [-117.03152, 33.05235], [-117.03161, 33.05254], [-117.03172, 33.0526], [-117.0317, 33.05276], [-117.0319, 33.05323], [-117.0322, 33.05358], [-117.03251, 33.05366], [-117.033, 33.0536], [-117.0332, 33.0535], [-117.03354, 33.05395], [-117.03372, 33.05402], [-117.03405, 33.05399], [-117.03449, 33.05379], [-117.03491, 33.05349], [-117.03525, 33.05341], [-117.03546, 33.0533], [-117.03564, 33.05294], [-117.03564, 33.05265], [-117.03535, 33.05209], [-117.03485, 33.05208], [-117.03535, 33.05196], [-117.03535, 33.05175], [-117.03524, 33.05167], [-117.03551, 33.05159], [-117.03641, 33.0508], [-117.03686, 33.05007], [-117.03774, 33.05005], [-117.03825, 33.04912], [-117.03828, 33.04894], [-117.03825, 33.0486], [-117.03806, 33.04819], [-117.03781, 33.04825], [-117.03778, 33.04815], [-117.0377, 33.04817], [-117.03771, 33.04806], [-117.03789, 33.048], [-117.03797, 33.04745], [-117.03783, 33.04722], [-117.03758, 33.04699], [-117.03792, 33.04698], [-117.03823, 33.04682], [-117.03827, 33.04668], [-117.03818, 33.04641], [-117.03828, 33.04624], [-117.03836, 33.04591], [-117.03826, 33.04578], [-117.03812, 33.04572], [-117.03844, 33.04562], [-117.03865, 33.04535], [-117.03859, 33.04512], [-117.03841, 33.04514], [-117.03845, 33.04501], [-117.03888, 33.04486], [-117.03937, 33.04445], [-117.03971, 33.04401], [-117.04105, 33.04401], [-117.04157, 33.04309], [-117.04233, 33.04332], [-117.04263, 33.04361], [-117.04274, 33.04392], [-117.04283, 33.0445], [-117.04287, 33.04508], [-117.04275, 33.04535], [-117.0423, 33.04567], [-117.04217, 33.04582], [-117.04212, 33.04608], [-117.04216, 33.04637], [-117.04233, 33.04665], [-117.04244, 33.04696], [-117.04253, 33.04747], [-117.04249, 33.04797], [-117.04251, 33.04826], [-117.04266, 33.04849], [-117.04288, 33.04872], [-117.04303, 33.04893], [-117.04315, 33.04923], [-117.04325, 33.04936], [-117.04357, 33.04962], [-117.04393, 33.05005], [-117.04408, 33.0502], [-117.04493, 33.05066], [-117.04573, 33.05118]]], [[[-117.05859, 33.05956], [-117.05757, 33.06226], [-117.05563, 33.06168], [-117.0535, 33.06157], [-117.05357, 33.06152], [-117.05377, 33.0612], [-117.05441, 33.06034], [-117.05446, 33.06023], [-117.05125, 33.05968], [-117.05065, 33.05914], [-117.05014, 33.05897], [-117.04971, 33.05899], [-117.04874, 33.05944], [-117.04812, 33.05927], [-117.04759, 33.05946], [-117.04664, 33.05961], [-117.04531, 33.05939], [-117.04494, 33.05966], [-117.04454, 33.05944], [-117.04367, 33.05998], [-117.04365, 33.06001], [-117.04331, 33.06018], [-117.04328, 33.06016], [-117.043, 33.0603], [-117.04262, 33.06128], [-117.0418, 33.06111], [-117.04125, 33.06103], [-117.04012, 33.06164], [-117.04003, 33.06213], [-117.03961, 33.06241], [-117.04003, 33.06278], [-117.03928, 33.06259], [-117.03881, 33.0629], [-117.03852, 33.06421], [-117.03838, 33.06427], [-117.0381, 33.06477], [-117.03821, 33.0651], [-117.03838, 33.06525], [-117.03895, 33.06536], [-117.03958, 33.06568], [-117.03956, 33.06579], [-117.03915, 33.06596], [-117.0391, 33.06614], [-117.03922, 33.06632], [-117.04003, 33.06676], [-117.04116, 33.06729], [-117.04118, 33.06744], [-117.04717, 33.06795], [-117.04656, 33.06986], [-117.04698, 33.07029], [-117.04731, 33.07026], [-117.04765, 33.07057], [-117.04808, 33.07081], [-117.0489, 33.07108], [-117.0484, 33.0721], [-117.04609, 33.07141], [-117.04559, 33.07145], [-117.04311, 33.07185], [-117.04282, 33.07192], [-117.04218, 33.07216], [-117.03988, 33.07309], [-117.0393, 33.0733], [-117.03849, 33.07364], [-117.03832, 33.07374], [-117.03798, 33.07398], [-117.03586, 33.07557], [-117.03566, 33.0758], [-117.03504, 33.07661], [-117.0352, 33.0767], [-117.03512, 33.07682], [-117.03516, 33.07693], [-117.03535, 33.07726], [-117.03542, 33.07733], [-117.03554, 33.07738], [-117.0355, 33.07751], [-117.0355, 33.07756], [-117.03553, 33.07762], [-117.03551, 33.07768], [-117.03545, 33.07771], [-117.03541, 33.07778], [-117.03544, 33.07788], [-117.03536, 33.07784], [-117.03526, 33.07784], [-117.03518, 33.07789], [-117.03511, 33.07797], [-117.03508, 33.07809], [-117.03507, 33.07821], [-117.03505, 33.07826], [-117.03505, 33.07835], [-117.03507, 33.07853], [-117.03511, 33.07866], [-117.03518, 33.0788], [-117.0353, 33.07897], [-117.03551, 33.07909], [-117.03671, 33.07938], [-117.03669, 33.07955], [-117.0364, 33.07966], [-117.03621, 33.07981], [-117.03613, 33.0799], [-117.03606, 33.08003], [-117.03598, 33.0803], [-117.03592, 33.0806], [-117.0359, 33.0807], [-117.03591, 33.08082], [-117.03588, 33.08115], [-117.03592, 33.08134], [-117.03598, 33.08151], [-117.03611, 33.08165], [-117.03607, 33.08182], [-117.03605, 33.08195], [-117.03595, 33.08188], [-117.03581, 33.08194], [-117.03566, 33.08205], [-117.03559, 33.08214], [-117.03554, 33.08223], [-117.03551, 33.08249], [-117.03552, 33.08265], [-117.03545, 33.08273], [-117.03542, 33.08286], [-117.03536, 33.08295], [-117.03533, 33.08304], [-117.03534, 33.0831], [-117.03539, 33.08318], [-117.03548, 33.08323], [-117.03519, 33.0833], [-117.03482, 33.08344], [-117.03475, 33.08342], [-117.03467, 33.08325], [-117.03454, 33.08311], [-117.03444, 33.08303], [-117.03422, 33.08293], [-117.03405, 33.08289], [-117.03387, 33.08288], [-117.03335, 33.08297], [-117.03322, 33.08303], [-117.0332, 33.08306], [-117.03271, 33.08334], [-117.03236, 33.08361], [-117.03172, 33.08418], [-117.03152, 33.08445], [-117.03139, 33.0848], [-117.0313, 33.08498], [-117.03127, 33.08518], [-117.03084, 33.08578], [-117.03053, 33.08602], [-117.03046, 33.0863], [-117.03055, 33.0865], [-117.03028, 33.08685], [-117.03019, 33.08718], [-117.03027, 33.08737], [-117.0305, 33.08756], [-117.03043, 33.08769], [-117.03023, 33.08768], [-117.03001, 33.08774], [-117.02998, 33.08767], [-117.03006, 33.08758], [-117.03001, 33.08742], [-117.02979, 33.08737], [-117.02966, 33.08696], [-117.02952, 33.08681], [-117.02916, 33.0867], [-117.02892, 33.08655], [-117.02873, 33.08647], [-117.02874, 33.08631], [-117.02848, 33.086], [-117.02844, 33.08585], [-117.02831, 33.08574], [-117.02899, 33.08572], [-117.02925, 33.08569], [-117.02957, 33.08556], [-117.02979, 33.08542], [-117.03139, 33.08398], [-117.03158, 33.08379], [-117.03169, 33.08363], [-117.03178, 33.08349], [-117.03207, 33.08293], [-117.03247, 33.08224], [-117.03246, 33.08223], [-117.03215, 33.08223], [-117.03207, 33.08235], [-117.03131, 33.08381], [-117.03044, 33.08458], [-117.02963, 33.08533], [-117.02935, 33.08548], [-117.02901, 33.08556], [-117.02709, 33.08556], [-117.02673, 33.08561], [-117.0266, 33.08559], [-117.02638, 33.08541], [-117.02638, 33.08503], [-117.0261, 33.08468], [-117.02623, 33.08433], [-117.02624, 33.08403], [-117.02618, 33.08386], [-117.02608, 33.08387], [-117.02551, 33.08449], [-117.02538, 33.08494], [-117.02522, 33.08509], [-117.02595, 33.08277], [-117.02682, 33.08186], [-117.02721, 33.08219], [-117.02802, 33.08213], [-117.02841, 33.08182], [-117.02851, 33.08092], [-117.03037, 33.0801], [-117.0322, 33.07908], [-117.03352, 33.07734], [-117.03439, 33.07544], [-117.03481, 33.0738], [-117.03515, 33.07233], [-117.03469, 33.07098], [-117.03403, 33.06897], [-117.03427, 33.06795], [-117.03566, 33.06463], [-117.0371, 33.06203], [-117.03735, 33.06144], [-117.03801, 33.06062], [-117.03923, 33.06013], [-117.04084, 33.0588], [-117.04282, 33.05782], [-117.04736, 33.05696], [-117.05139, 33.05688], [-117.05425, 33.05741], [-117.05782, 33.05908], [-117.05859, 33.05956]]], [[[-117.06694, 33.05289], [-117.06691, 33.05291], [-117.06677, 33.05292], [-117.06622, 33.05292], [-117.0659, 33.05294], [-117.06563, 33.053], [-117.06537, 33.05315], [-117.06499, 33.05345], [-117.06476, 33.05359], [-117.06456, 33.05368], [-117.06416, 33.05379], [-117.06221, 33.05389], [-117.06179, 33.0539], [-117.06119, 33.05386], [-117.06016, 33.05373], [-117.05927, 33.05359], [-117.05868, 33.0535], [-117.0581, 33.05337], [-117.05782, 33.05328], [-117.05745, 33.05312], [-117.05767, 33.05277], [-117.05793, 33.05268], [-117.05823, 33.05251], [-117.05831, 33.05226], [-117.05831, 33.05219], [-117.05819, 33.05207], [-117.0583, 33.05195], [-117.0583, 33.05177], [-117.05823, 33.05162], [-117.05834, 33.05158], [-117.05873, 33.05165], [-117.05897, 33.05159], [-117.05916, 33.0514], [-117.05926, 33.05112], [-117.05928, 33.05101], [-117.05946, 33.05074], [-117.05944, 33.05067], [-117.05962, 33.05044], [-117.05968, 33.05029], [-117.05968, 33.05012], [-117.05961, 33.05], [-117.0597, 33.0499], [-117.05974, 33.04936], [-117.05962, 33.0492], [-117.05972, 33.04909], [-117.05976, 33.0488], [-117.05964, 33.04865], [-117.05965, 33.04848], [-117.05958, 33.0481], [-117.05946, 33.04772], [-117.05929, 33.04755], [-117.05954, 33.04765], [-117.05968, 33.04775], [-117.05988, 33.04804], [-117.05987, 33.04825], [-117.05992, 33.04837], [-117.06015, 33.04848], [-117.06015, 33.0487], [-117.06023, 33.04891], [-117.06032, 33.04896], [-117.06035, 33.04912], [-117.06051, 33.04918], [-117.0604, 33.04926], [-117.06044, 33.04972], [-117.06061, 33.05026], [-117.06082, 33.05075], [-117.06091, 33.05092], [-117.061, 33.051], [-117.06095, 33.05113], [-117.06101, 33.05129], [-117.0614, 33.05154], [-117.06145, 33.05169], [-117.0616, 33.05194], [-117.06213, 33.05231], [-117.0627, 33.05257], [-117.06307, 33.05289], [-117.06388, 33.05308], [-117.06427, 33.0531], [-117.06452, 33.05306], [-117.06477, 33.05297], [-117.06496, 33.05285], [-117.06536, 33.05234], [-117.0655, 33.05227], [-117.06584, 33.05222], [-117.06627, 33.05225], [-117.06644, 33.05202], [-117.06694, 33.05289]]]]} | No Public Access 3 | 47724 | San Pasqual Valley Agricultural and Open Space Preserve | 31512 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sdrp.org/wordpress/ | San Diego 4 | 3061.554 | San Pasqual Valley Agricultural and OSP | 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]);