units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where ACCESS_TYP = 3, COUNTY = 4 and MNG_AG_TYP = 2 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, LABEL_NAME, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 | |||
11558 | 11558 | 11557 | {"type": "MultiPolygon", "coordinates": [[[[-116.9417, 32.65977], [-116.94153, 32.66001], [-116.94146, 32.66001], [-116.94134, 32.6601], [-116.94109, 32.66002], [-116.94043, 32.66015], [-116.94013, 32.66023], [-116.93992, 32.66038], [-116.93985, 32.66099], [-116.93993, 32.66109], [-116.9397, 32.66127], [-116.93967, 32.66141], [-116.9396, 32.6615], [-116.93959, 32.66161], [-116.93963, 32.66169], [-116.93962, 32.66217], [-116.93965, 32.66241], [-116.93987, 32.66274], [-116.94009, 32.66304], [-116.94024, 32.66334], [-116.94034, 32.66367], [-116.94033, 32.66399], [-116.94054, 32.66419], [-116.9404, 32.66434], [-116.94029, 32.66436], [-116.94008, 32.66444], [-116.94005, 32.66456], [-116.94009, 32.66474], [-116.94001, 32.66501], [-116.93996, 32.66512], [-116.93976, 32.66522], [-116.9396, 32.66538], [-116.93934, 32.66555], [-116.93931, 32.66565], [-116.93918, 32.66573], [-116.93914, 32.66578], [-116.93875, 32.66581], [-116.93873, 32.6657], [-116.93858, 32.66549], [-116.93836, 32.66534], [-116.938, 32.66531], [-116.93731, 32.66566], [-116.93724, 32.66576], [-116.93717, 32.66597], [-116.93703, 32.66611], [-116.9369, 32.66631], [-116.93668, 32.66655], [-116.93668, 32.66669], [-116.93654, 32.66682], [-116.93654, 32.66609], [-116.93437, 32.66605], [-116.93437, 32.66514], [-116.93657, 32.66518], [-116.93658, 32.65806], [-116.93693, 32.65833], [-116.93729, 32.65869], [-116.93758, 32.65884], [-116.93762, 32.65906], [-116.93794, 32.6591], [-116.93841, 32.65947], [-116.93842, 32.65946], [-116.93836, 32.65931], [-116.93804, 32.65879], [-116.93796, 32.6586], [-116.93774, 32.65835], [-116.93772, 32.658], [-116.93753, 32.65766], [-116.93762, 32.65749], [-116.93789, 32.65742], [-116.93831, 32.65764], [-116.93832, 32.65762], [-116.93807, 32.65723], [-116.9378, 32.65714], [-116.93724, 32.65649], [-116.93706, 32.65639], [-116.93678, 32.65633], [-116.93682, 32.65603], [-116.93777, 32.65605], [-116.9417, 32.65977]]], [[[-116.95166, 32.66641], [-116.95161, 32.66692], [-116.95163, 32.66696], [-116.9516, 32.66703], [-116.95159, 32.66721], [-116.94962, 32.66719], [-116.94953, 32.67814], [-116.93649, 32.67798], [-116.93651, 32.67515], [-116.93667, 32.67515], [-116.93683, 32.67519], [-116.93694, 32.6752], [-116.937, 32.6752], [-116.93708, 32.67517], [-116.937, 32.67534], [-116.93703, 32.67544], [-116.93686, 32.67577], [-116.93682, 32.67622], [-116.93675, 32.6765], [-116.93679, 32.67697], [-116.93684, 32.67708], [-116.93688, 32.67715], [-116.93696, 32.67721], [-116.93752, 32.67753], [-116.93754, 32.67758], [-116.93807, 32.6779], [-116.93872, 32.67798], [-116.93913, 32.67797], [-116.93933, 32.678], [-116.9401, 32.67801], [-116.94019, 32.67798], [-116.94054, 32.6777], [-116.94082, 32.67743], [-116.94095, 32.67737], [-116.94108, 32.67716], [-116.94113, 32.67717], [-116.9413, 32.67694], [-116.94143, 32.67692], [-116.94154, 32.67667], [-116.94162, 32.67667], [-116.94173, 32.67639], [-116.94186, 32.67643], [-116.94196, 32.67616], [-116.94206, 32.67615], [-116.94218, 32.6761], [-116.94226, 32.67602], [-116.94231, 32.67586], [-116.94232, 32.67553], [-116.94247, 32.67554], [-116.94248, 32.67527], [-116.94261, 32.67524], [-116.94262, 32.67502], [-116.9427, 32.67497], [-116.9427, 32.6743], [-116.94259, 32.67397], [-116.9425, 32.67384], [-116.94237, 32.67376], [-116.9422, 32.67371], [-116.94199, 32.67373], [-116.94189, 32.67371], [-116.94183, 32.67364], [-116.94184, 32.67335], [-116.94216, 32.67292], [-116.94273, 32.67265], [-116.94281, 32.67271], [-116.94307, 32.67268], [-116.9431, 32.6727], [-116.94321, 32.67272], [-116.94386, 32.67371], [-116.94389, 32.67392], [-116.94388, 32.67401], [-116.94378, 32.67405], [-116.94361, 32.67418], [-116.94352, 32.67448], [-116.94349, 32.67461], [-116.94354, 32.67466], [-116.94361, 32.67464], [-116.94367, 32.67484], [-116.9436, 32.67485], [-116.94359, 32.67486], [-116.94364, 32.67493], [-116.94377, 32.67508], [-116.94364, 32.67528], [-116.94367, 32.67533], [-116.94377, 32.67536], [-116.94392, 32.67554], [-116.94405, 32.67567], [-116.94417, 32.67587], [-116.9444, 32.67615], [-116.94486, 32.67639], [-116.94499, 32.6764], [-116.94518, 32.67651], [-116.94561, 32.67672], [-116.94595, 32.67672], [-116.94643, 32.67668], [-116.94681, 32.67689], [-116.94765, 32.67679], [-116.94767, 32.67675], [-116.94821, 32.67687], [-116.94836, 32.67646], [-116.94841, 32.67642], [-116.94863, 32.67585], [-116.9488, 32.6756], [-116.94889, 32.6755], [-116.94905, 32.67487], [-116.94904, 32.67475], [-116.94922, 32.67465], [-116.94934, 32.67443], [-116.94939, 32.67418], [-116.94922, 32.67339], [-116.94905, 32.67322], [-116.94902, 32.6731], [-116.94906, 32.67297], [-116.94905, 32.67283], [-116.94899, 32.67268], [-116.94892, 32.67261], [-116.94877, 32.67259], [-116.94868, 32.67261], [-116.94839, 32.67254], [-116.94823, 32.67256], [-116.94812, 32.67262], [-116.94805, 32.67271], [-116.94797, 32.67256], [-116.94782, 32.67248], [-116.94781, 32.67244], [-116.94765, 32.67235], [-116.94762, 32.67222], [-116.94757, 32.67219], [-116.9474, 32.67187], [-116.9473, 32.67183], [-116.94711, 32.67171], [-116.94694, 32.67167], [-116.94687, 32.67167], [-116.94685, 32.67147], [-116.94674, 32.6711], [-116.94672, 32.67073], [-116.94623, 32.66956], [-116.94603, 32.66927], [-116.94582, 32.669], [-116.94544, 32.66843], [-116.94568, 32.66829], [-116.946, 32.66758], [-116.94619, 32.66724], [-116.94636, 32.66705], [-116.9466, 32.66689], [-116.94664, 32.66679], [-116.94665, 32.66668], [-116.94654, 32.66642], [-116.94644, 32.66624], [-116.94634, 32.66615], [-116.94631, 32.66601], [-116.94627, 32.6659], [-116.94631, 32.66543], [-116.94648, 32.66474], [-116.94674, 32.66383], [-116.94672, 32.66346], [-116.94657, 32.66294], [-116.94649, 32.66275], [-116.94638, 32.66256], [-116.94624, 32.66246], [-116.9466, 32.66252], [-116.94774, 32.66266], [-116.94797, 32.66272], [-116.94821, 32.6627], [-116.94838, 32.66276], [-116.94856, 32.66278], [-116.94865, 32.6629], [-116.94881, 32.66299], [-116.9488, 32.66337], [-116.94888, 32.66345], [-116.94893, 32.66362], [-116.94902, 32.66379], [-116.94918, 32.6639], [-116.94948, 32.66429], [-116.94966, 32.66433], [-116.94978, 32.66455], [-116.9497, 32.66458], [-116.94975, 32.66464], [-116.94956, 32.66493], [-116.94962, 32.66499], [-116.94996, 32.66495], [-116.94998, 32.665], [-116.95009, 32.66509], [-116.95012, 32.66529], [-116.95016, 32.66532], [-116.95016, 32.66563], [-116.95029, 32.66579], [-116.95029, 32.66615], [-116.95016, 32.66624], [-116.95023, 32.66633], [-116.95041, 32.66644], [-116.95078, 32.66678], [-116.95134, 32.66642], [-116.95136, 32.66638], [-116.95139, 32.66638], [-116.95153, 32.66627], [-116.95166, 32.66641]]]]} | No Public Access 3 | 46837 | Rolling Hills Ranch | 30306 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 221.546 | Rolling Hills Ranch | 0 | Local Other or Unknown 14 | 4 | |
208 | 208 | 207 | {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} | No Public Access 3 | 654 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 16.798 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
235 | 235 | 234 | {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} | No Public Access 3 | 684 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 4.055 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} | No Public Access 3 | 683 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.966 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
3891 | 3891 | 3890 | {"type": "Polygon", "coordinates": [[[-117.09429, 33.13135], [-117.094, 33.13143], [-117.09383, 33.13102], [-117.09403, 33.13085], [-117.09407, 33.13095], [-117.09412, 33.13095], [-117.09429, 33.13135]]]} | No Public Access 3 | 642 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.372 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
5007 | 5007 | 5006 | {"type": "Polygon", "coordinates": [[[-117.08308, 33.12563], [-117.083, 33.12566], [-117.08273, 33.12596], [-117.08261, 33.1257], [-117.08295, 33.12535], [-117.08308, 33.12563]]]} | No Public Access 3 | 689 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.332 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
5863 | 5863 | 5862 | {"type": "MultiPolygon", "coordinates": [[[[-117.02636, 33.16692], [-117.02637, 33.16744], [-117.0263, 33.16767], [-117.02627, 33.16768], [-117.02381, 33.1705], [-117.0228, 33.17041], [-117.02244, 33.17066], [-117.02191, 33.17075], [-117.02157, 33.17076], [-117.0211, 33.17036], [-117.02039, 33.17028], [-117.0193, 33.16949], [-117.01888, 33.1689], [-117.01829, 33.16863], [-117.0182, 33.16854], [-117.01809, 33.16833], [-117.01805, 33.16832], [-117.01805, 33.16822], [-117.01821, 33.16823], [-117.01836, 33.16851], [-117.01841, 33.16856], [-117.019, 33.16883], [-117.01907, 33.16893], [-117.01899, 33.16898], [-117.01935, 33.16949], [-117.02041, 33.17025], [-117.02111, 33.17033], [-117.02157, 33.17072], [-117.02186, 33.17071], [-117.02188, 33.17067], [-117.02237, 33.17059], [-117.02276, 33.17032], [-117.02381, 33.17041], [-117.02579, 33.16812], [-117.02611, 33.1677], [-117.02619, 33.16744], [-117.02618, 33.16691], [-117.02636, 33.16692]]], [[[-117.03026, 33.16085], [-117.02978, 33.16201], [-117.02983, 33.16203], [-117.02952, 33.16302], [-117.02949, 33.16333], [-117.02954, 33.16362], [-117.02927, 33.16475], [-117.02785, 33.16432], [-117.02829, 33.16321], [-117.02812, 33.16305], [-117.02818, 33.16299], [-117.02891, 33.16214], [-117.029, 33.16188], [-117.02906, 33.16187], [-117.02931, 33.16168], [-117.02936, 33.16148], [-117.02948, 33.16128], [-117.02963, 33.16113], [-117.02986, 33.16099], [-117.03026, 33.16085]]], [[[-117.047, 33.14542], [-117.0464, 33.14577], [-117.04613, 33.14599], [-117.04568, 33.14639], [-117.04536, 33.1466], [-117.04502, 33.14677], [-117.04494, 33.1468], [-117.04431, 33.14709], [-117.04386, 33.14733], [-117.04316, 33.14765], [-117.04287, 33.14774], [-117.04248, 33.14783], [-117.04224, 33.14786], [-117.04113, 33.1479], [-117.04094, 33.14799], [-117.04089, 33.14791], [-117.04015, 33.14791], [-117.03971, 33.14795], [-117.03949, 33.14801], [-117.03909, 33.14814], [-117.0387, 33.1484], [-117.03852, 33.14855], [-117.03758, 33.14944], [-117.03759, 33.14947], [-117.03744, 33.14963], [-117.03729, 33.14987], [-117.03692, 33.14982], [-117.03731, 33.14903], [-117.03754, 33.14905], [-117.03827, 33.14831], [-117.03842, 33.14818], [-117.03841, 33.14815], [-117.03858, 33.14803], [-117.03896, 33.14783], [-117.03932, 33.14768], [-117.03981, 33.14758], [-117.04015, 33.14756], [-117.04116, 33.14756], [-117.04121, 33.14762], [-117.04189, 33.14763], [-117.04224, 33.1476], [-117.04252, 33.14756], [-117.04277, 33.14749], [-117.043, 33.14741], [-117.04507, 33.14646], [-117.04528, 33.14635], [-117.04539, 33.14627], [-117.04584, 33.14587], [-117.04623, 33.14554], [-117.04685, 33.14517], [-117.047, 33.14542]]], [[[-117.0675, 33.13214], [-117.06677, 33.13264], [-117.06648, 33.13289], [-117.06619, 33.13307], [-117.06584, 33.13324], [-117.06561, 33.13332], [-117.06516, 33.13344], [-117.06488, 33.13347], [-117.06459, 33.13312], [-117.06483, 33.1331], [-117.06485, 33.13313], [-117.06512, 33.13308], [-117.06552, 33.13296], [-117.06601, 33.13276], [-117.06651, 33.13245], [-117.06738, 33.13176], [-117.0675, 33.13214]]], [[[-117.06901, 33.13096], [-117.06874, 33.13109], [-117.06832, 33.13136], [-117.06801, 33.13163], [-117.06802, 33.13165], [-117.06769, 33.13191], [-117.06757, 33.13154], [-117.0683, 33.13093], [-117.0688, 33.13065], [-117.06901, 33.13096]]], [[[-117.0704, 33.13036], [-117.06983, 33.13063], [-117.0698, 33.1306], [-117.06925, 33.13085], [-117.06904, 33.13054], [-117.07019, 33.13002], [-117.0704, 33.13036]]], [[[-117.07179, 33.12972], [-117.07063, 33.13026], [-117.07043, 33.12995], [-117.07073, 33.12981], [-117.07071, 33.12977], [-117.07158, 33.12938], [-117.07179, 33.12972]]], [[[-117.07317, 33.12909], [-117.07202, 33.12961], [-117.07181, 33.12927], [-117.07295, 33.12874], [-117.07317, 33.12909]]], [[[-117.07456, 33.12844], [-117.07339, 33.12896], [-117.07334, 33.1289], [-117.07432, 33.12843], [-117.07448, 33.12836], [-117.07456, 33.12844]]], [[[-117.07591, 33.12782], [-117.07479, 33.12835], [-117.07472, 33.12824], [-117.07586, 33.12772], [-117.07591, 33.12782]]], [[[-117.07746, 33.12743], [-117.07699, 33.12747], [-117.07676, 33.12751], [-117.07641, 33.12762], [-117.07616, 33.12773], [-117.07608, 33.12761], [-117.07724, 33.12709], [-117.07746, 33.12743]]], [[[-117.08144, 33.1271], [-117.08115, 33.12721], [-117.08078, 33.1273], [-117.08026, 33.12738], [-117.07774, 33.12741], [-117.07754, 33.12707], [-117.07901, 33.12707], [-117.08015, 33.12704], [-117.08067, 33.12695], [-117.08102, 33.12686], [-117.08124, 33.12678], [-117.08144, 33.1271]]], [[[-117.08226, 33.12655], [-117.08202, 33.12674], [-117.08199, 33.12672], [-117.08166, 33.12695], [-117.08146, 33.12667], [-117.08176, 33.12645], [-117.08176, 33.12644], [-117.08207, 33.12614], [-117.08226, 33.12655]]], [[[-117.08271, 33.12607], [-117.08237, 33.12643], [-117.0822, 33.12601], [-117.08225, 33.12599], [-117.08254, 33.12569], [-117.08271, 33.12607]]], [[[-117.08966, 33.12061], [-117.08939, 33.12075], [-117.08924, 33.12087], [-117.08838, 33.12158], [-117.08823, 33.12129], [-117.08922, 33.12051], [-117.08949, 33.12035], [-117.08966, 33.12061]]], [[[-117.09276, 33.11986], [-117.09207, 33.11988], [-117.09152, 33.11994], [-117.09127, 33.11998], [-117.09056, 33.12017], [-117.09021, 33.1203], [-117.08986, 33.12046], [-117.0897, 33.12024], [-117.08998, 33.12008], [-117.09025, 33.11996], [-117.09048, 33.11986], [-117.09078, 33.11978], [-117.09107, 33.11977], [-117.09148, 33.11968], [-117.09186, 33.11961], [-117.09222, 33.11958], [-117.09265, 33.11958], [-117.09276, 33.11986]]], [[[-117.09679, 33.11874], [-117.09593, 33.11947], [-117.09577, 33.11965], [-117.09533, 33.11949], [-117.09538, 33.1194], [-117.09539, 33.11936], [-117.09511, 33.11927], [-117.09567, 33.119], [-117.09571, 33.11901], [-117.09634, 33.11858], [-117.09679, 33.11874]]], [[[-117.09969, 33.11766], [-117.09946, 33.1182], [-117.0989, 33.11818], [-117.09888, 33.11815], [-117.09867, 33.11815], [-117.09837, 33.11816], [-117.09803, 33.11822], [-117.09776, 33.11828], [-117.0975, 33.11838], [-117.09728, 33.11849], [-117.09706, 33.11865], [-117.09653, 33.11844], [-117.09691, 33.11816], [-117.09712, 33.11804], [-117.09749, 33.11788], [-117.09798, 33.11774], [-117.09798, 33.11772], [-117.09829, 33.11767], [-117.09893, 33.11765], [-117.09894, 33.11768], [-117.09931, 33.11768], [-117.09969, 33.11766]]], [[[-117.1043, 33.11385], [-117.10384, 33.11409], [-117.10355, 33.11429], [-117.10326, 33.11453], [-117.10283, 33.11502], [-117.10252, 33.11554], [-117.10242, 33.11581], [-117.10218, 33.11658], [-117.10203, 33.11686], [-117.10177, 33.1172], [-117.10174, 33.11727], [-117.10161, 33.11742], [-117.10146, 33.11755], [-117.10118, 33.11774], [-117.10097, 33.11726], [-117.10097, 33.11723], [-117.10128, 33.11699], [-117.1015, 33.11676], [-117.10182, 33.11591], [-117.10195, 33.1155], [-117.10213, 33.11513], [-117.10232, 33.11481], [-117.10255, 33.11452], [-117.10257, 33.11437], [-117.10284, 33.11418], [-117.10307, 33.11393], [-117.10311, 33.11394], [-117.10358, 33.11365], [-117.1043, 33.11385]]], [[[-117.11185, 33.10955], [-117.11069, 33.11042], [-117.11039, 33.11068], [-117.11003, 33.11107], [-117.10985, 33.11132], [-117.10976, 33.11149], [-117.10961, 33.1117], [-117.10939, 33.11195], [-117.10889, 33.11244], [-117.10817, 33.11317], [-117.10811, 33.11314], [-117.10768, 33.11353], [-117.10742, 33.11388], [-117.10735, 33.11405], [-117.10729, 33.11442], [-117.10718, 33.11439], [-117.10723, 33.11402], [-117.10738, 33.11364], [-117.10735, 33.11362], [-117.1076, 33.11327], [-117.10792, 33.11298], [-117.10786, 33.11293], [-117.10723, 33.11311], [-117.10723, 33.11314], [-117.10474, 33.11367], [-117.10402, 33.11348], [-117.10445, 33.11328], [-117.10496, 33.11313], [-117.10644, 33.11287], [-117.10742, 33.11262], [-117.10777, 33.1125], [-117.10831, 33.11222], [-117.10878, 33.11189], [-117.1092, 33.11145], [-117.10968, 33.11079], [-117.10997, 33.11045], [-117.11033, 33.11011], [-117.11091, 33.10963], [-117.11124, 33.1093], [-117.11185, 33.10955]]]]} | No Public Access 3 | 192 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 62.151 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6015 | 6015 | 6014 | {"type": "Polygon", "coordinates": [[[-117.09363, 33.12972], [-117.0934, 33.12982], [-117.09332, 33.12983], [-117.09264, 33.12819], [-117.09301, 33.12807], [-117.09327, 33.1289], [-117.09363, 33.12972]]]} | No Public Access 3 | 675 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.523 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
6250 | 6250 | 6249 | {"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]} | No Public Access 3 | 1410 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 8.905 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
16217 | 16217 | 16216 | {"type": "Polygon", "coordinates": [[[-117.14604, 33.16753], [-117.14568, 33.16832], [-117.14568, 33.16839], [-117.14137, 33.16834], [-117.1414, 33.16739], [-117.14061, 33.16658], [-117.14096, 33.16596], [-117.14048, 33.16411], [-117.14004, 33.1621], [-117.14023, 33.16217], [-117.14033, 33.16218], [-117.14079, 33.16211], [-117.1411, 33.1621], [-117.14137, 33.16215], [-117.14156, 33.16223], [-117.14169, 33.16234], [-117.14177, 33.16245], [-117.14184, 33.16259], [-117.14188, 33.16273], [-117.14187, 33.16285], [-117.14183, 33.16297], [-117.14178, 33.16306], [-117.14167, 33.16317], [-117.14168, 33.16329], [-117.14171, 33.1633], [-117.14189, 33.1633], [-117.1421, 33.16337], [-117.14218, 33.16342], [-117.1423, 33.16353], [-117.14243, 33.16362], [-117.14253, 33.16364], [-117.14279, 33.16359], [-117.14292, 33.1636], [-117.14302, 33.16367], [-117.14316, 33.16387], [-117.14335, 33.16399], [-117.14343, 33.16402], [-117.14354, 33.16401], [-117.14409, 33.16385], [-117.14429, 33.16385], [-117.14558, 33.16436], [-117.14574, 33.16445], [-117.14582, 33.16446], [-117.14584, 33.16451], [-117.14584, 33.16519], [-117.14582, 33.16537], [-117.14581, 33.166], [-117.14596, 33.16649], [-117.14598, 33.16664], [-117.14597, 33.16709], [-117.14604, 33.16753]]]} | No Public Access 3 | 44872 | City of Escondido Open Space | 17311 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 63.739 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
16219 | 16219 | 16218 | {"type": "Polygon", "coordinates": [[[-117.17233, 33.2342], [-117.17202, 33.23604], [-117.17189, 33.23648], [-117.17178, 33.23675], [-117.17165, 33.23702], [-117.17032, 33.23703], [-117.1702, 33.23718], [-117.17023, 33.23751], [-117.17011, 33.23751], [-117.16988, 33.23783], [-117.16972, 33.23784], [-117.16977, 33.2384], [-117.16849, 33.23842], [-117.16846, 33.24102], [-117.16803, 33.24124], [-117.16763, 33.24094], [-117.16776, 33.24042], [-117.16769, 33.2402], [-117.16743, 33.23991], [-117.16592, 33.23931], [-117.16579, 33.23935], [-117.16431, 33.23922], [-117.16405, 33.23994], [-117.16386, 33.23992], [-117.16381, 33.23961], [-117.16384, 33.23934], [-117.15908, 33.23938], [-117.15804, 33.23852], [-117.15919, 33.23818], [-117.15945, 33.23775], [-117.15995, 33.23749], [-117.16145, 33.23719], [-117.16196, 33.23581], [-117.1627, 33.23526], [-117.16318, 33.23561], [-117.16327, 33.23494], [-117.16638, 33.23486], [-117.16638, 33.23119], [-117.16608, 33.23118], [-117.16622, 33.2307], [-117.16638, 33.23055], [-117.16638, 33.23112], [-117.16644, 33.23112], [-117.16649, 33.23108], [-117.16651, 33.23101], [-117.16644, 33.23081], [-117.16645, 33.23065], [-117.16653, 33.23046], [-117.16659, 33.23041], [-117.16665, 33.23038], [-117.16671, 33.23037], [-117.16745, 33.2305], [-117.16762, 33.2305], [-117.16779, 33.23047], [-117.1683, 33.23026], [-117.16876, 33.22996], [-117.16893, 33.22982], [-117.16899, 33.22975], [-117.1691, 33.22972], [-117.16919, 33.22975], [-117.1693, 33.22992], [-117.16944, 33.23004], [-117.16958, 33.23012], [-117.16978, 33.23017], [-117.16979, 33.23023], [-117.16989, 33.23025], [-117.16996, 33.23029], [-117.17, 33.23033], [-117.17008, 33.23044], [-117.17016, 33.23051], [-117.17022, 33.23053], [-117.17059, 33.23058], [-117.1706, 33.23248], [-117.17094, 33.2325], [-117.17188, 33.23359], [-117.17209, 33.23384], [-117.17201, 33.23419], [-117.17233, 33.2342]]]} | No Public Access 3 | 44881 | City of Oceanside Open Space | 17323 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 175.69 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
4183 | 4183 | 4182 | {"type": "MultiPolygon", "coordinates": [[[[-117.06172, 32.93278], [-117.06122, 32.93336], [-117.06087, 32.93316], [-117.06071, 32.9331], [-117.06052, 32.93306], [-117.06016, 32.93303], [-117.05996, 32.93305], [-117.05974, 32.9331], [-117.05968, 32.93308], [-117.05965, 32.93305], [-117.05923, 32.93194], [-117.05911, 32.93166], [-117.05887, 32.93122], [-117.05859, 32.93084], [-117.05859, 32.93079], [-117.05882, 32.93064], [-117.05916, 32.93101], [-117.0608, 32.93016], [-117.06098, 32.93018], [-117.0599, 32.93081], [-117.05979, 32.93128], [-117.06026, 32.93172], [-117.0606, 32.93182], [-117.06093, 32.93184], [-117.06127, 32.93176], [-117.0615, 32.93172], [-117.06153, 32.93243], [-117.06172, 32.93278]]], [[[-117.06669, 32.93294], [-117.06648, 32.93266], [-117.06644, 32.93238], [-117.06648, 32.93208], [-117.06625, 32.932], [-117.06608, 32.9318], [-117.06621, 32.93138], [-117.06616, 32.93133], [-117.06597, 32.93138], [-117.06552, 32.93156], [-117.06489, 32.93141], [-117.06501, 32.93102], [-117.06506, 32.93069], [-117.06543, 32.93045], [-117.06548, 32.93009], [-117.0652, 32.92941], [-117.06497, 32.92918], [-117.06473, 32.929], [-117.06367, 32.92871], [-117.06354, 32.92923], [-117.0635, 32.92922], [-117.06361, 32.9287], [-117.06028, 32.92779], [-117.06534, 32.92774], [-117.06556, 32.928], [-117.06579, 32.92819], [-117.06596, 32.92829], [-117.06668, 32.92866], [-117.06669, 32.93294]]], [[[-117.06581, 32.93938], [-117.06576, 32.93969], [-117.06569, 32.93966], [-117.06569, 32.93963], [-117.06539, 32.93946], [-117.06532, 32.93947], [-117.06505, 32.93936], [-117.06446, 32.93929], [-117.06429, 32.9389], [-117.06405, 32.93887], [-117.0639, 32.93843], [-117.063, 32.93833], [-117.06287, 32.93795], [-117.06274, 32.93769], [-117.06286, 32.93761], [-117.06308, 32.93783], [-117.06349, 32.93754], [-117.06399, 32.93805], [-117.06412, 32.93807], [-117.06478, 32.93895], [-117.06507, 32.93898], [-117.06505, 32.93915], [-117.06581, 32.93938]]], [[[-117.06668, 32.92848], [-117.06592, 32.92807], [-117.06573, 32.92792], [-117.06557, 32.92774], [-117.06668, 32.92773], [-117.06668, 32.92848]]]]} | No Public Access 3 | 44864 | South Poway Cornerstone | 25675 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 37.928 | South Poway Cornerstone | None 364 | |||
7819 | 7819 | 7818 | {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04501], [-117.03841, 33.04513], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03814, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03759, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04816], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03526, 33.05167], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03492, 33.05207], [-117.03493, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.031, 33.05176], [-117.03082, 33.05168], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02965, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02985, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02997, 33.05366], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02991, 33.05429], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02958, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05038], [-117.02823, 33.05039], [-117.02836, 33.05023], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04972], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03187, 33.04407], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02936, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03683], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03105, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03547], [-117.03175, 33.03535], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.0313, 33.03387], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04407], [-117.03972, 33.04402]]]} | No Public Access 3 | 45249 | City of Poway Open Space | 17327 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 193.801 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 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 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 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 | 19.773 | Neighborhood 8 Neighborhood Park | 0 | Local Park 2 | 4 | |
4196 | 4196 | 4195 | {"type": "Polygon", "coordinates": [[[-116.88012, 33.16121], [-116.87559, 33.16121], [-116.87567, 33.15391], [-116.88007, 33.1539], [-116.88011, 33.15824], [-116.88012, 33.16121]]]} | No Public Access 3 | 47685 | Pamo Watershed | 31421 | 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 | 83.475 | Pamo Watershed | 0 | Local Resource Management Area 83 | 3 | |
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | Unnamed site - San Diego, City of | 31719 | 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 | 1.217 | 0 | Local Other or Unknown 14 | 4 | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | Unnamed site - San Diego, City of | 31719 | 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 | 0.273 | 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]);