units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where MNG_AGENCY = 101 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, YR_EST, GAP_STS
DES_TP 11
- Local Park 68
- Local Conservation Area 37
- Local Recreation Area 7
- Local Other or Unknown 4
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
LAYER 4 ✖
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 123
MNG_AGENCY 1
- San Diego, County of · 123 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
575 | 575 | 574 | {"type": "Polygon", "coordinates": [[[-116.55091, 32.68226], [-116.5509, 32.68904], [-116.54671, 32.68903], [-116.54666, 32.69624], [-116.54247, 32.69617], [-116.54246, 32.69264], [-116.53813, 32.69259], [-116.53815, 32.68901], [-116.53404, 32.68893], [-116.53398, 32.69617], [-116.53815, 32.6962], [-116.53809, 32.71037], [-116.53398, 32.71042], [-116.53382, 32.71605], [-116.53385, 32.72189], [-116.52947, 32.72189], [-116.52952, 32.72556], [-116.52511, 32.72556], [-116.5252, 32.71823], [-116.52073, 32.71818], [-116.52069, 32.71598], [-116.52077, 32.71459], [-116.51671, 32.71461], [-116.5166, 32.70729], [-116.50784, 32.70735], [-116.50786, 32.71104], [-116.50351, 32.71109], [-116.5035, 32.71481], [-116.49896, 32.71499], [-116.4951, 32.71505], [-116.4951, 32.71112], [-116.49937, 32.71107], [-116.49957, 32.6966], [-116.50366, 32.69661], [-116.50364, 32.70018], [-116.50784, 32.70019], [-116.508, 32.69288], [-116.51156, 32.6929], [-116.51245, 32.69289], [-116.51259, 32.68983], [-116.51262, 32.68937], [-116.51405, 32.68937], [-116.51423, 32.68936], [-116.51428, 32.6885], [-116.51487, 32.68809], [-116.51478, 32.68764], [-116.51501, 32.68738], [-116.515, 32.68715], [-116.51517, 32.68685], [-116.51506, 32.68635], [-116.51528, 32.68609], [-116.51576, 32.68605], [-116.51581, 32.68607], [-116.51608, 32.68574], [-116.51671, 32.68596], [-116.51671, 32.68474], [-116.51678, 32.68255], [-116.51675, 32.68254], [-116.51675, 32.68218], [-116.52375, 32.68219], [-116.52543, 32.68216], [-116.52542, 32.67813], [-116.53399, 32.67817], [-116.534, 32.67113], [-116.53823, 32.67113], [-116.5382, 32.67463], [-116.54239, 32.67461], [-116.54239, 32.67817], [-116.54667, 32.67819], [-116.5467, 32.68224], [-116.55091, 32.68226]], [[-116.534, 32.67817], [-116.53399, 32.67818], [-116.53399, 32.68219], [-116.53814, 32.68223], [-116.53816, 32.6782], [-116.534, 32.67817]]]} | Open Access 1 | 3446 | Lake Morena County Park | 10398 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LakeMorena.html | San Diego 4 | 3278.988 | Lake Morena County Park | 0 | Local Park 2 | 4 |
7603 | 7603 | 7602 | {"type": "MultiPolygon", "coordinates": [[[[-117.14805, 33.08584], [-117.14789, 33.0859], [-117.14775, 33.08597], [-117.14704, 33.08645], [-117.14671, 33.08662], [-117.14508, 33.08435], [-117.13959, 33.08443], [-117.13958, 33.08442], [-117.13958, 33.08754], [-117.13651, 33.08756], [-117.12968, 33.08756], [-117.12962, 33.09117], [-117.12315, 33.09115], [-117.12313, 33.08756], [-117.11888, 33.08755], [-117.11889, 33.08746], [-117.11885, 33.08602], [-117.1189, 33.08492], [-117.11888, 33.08399], [-117.11911, 33.08376], [-117.11915, 33.08376], [-117.11941, 33.08344], [-117.11939, 33.08342], [-117.1194, 33.08339], [-117.11947, 33.0833], [-117.11965, 33.083], [-117.11982, 33.08265], [-117.11992, 33.08237], [-117.12041, 33.08055], [-117.12047, 33.08025], [-117.12056, 33.07972], [-117.12075, 33.07971], [-117.12076, 33.07899], [-117.12108, 33.07898], [-117.12106, 33.07836], [-117.12084, 33.07835], [-117.1211, 33.07661], [-117.12112, 33.07652], [-117.12116, 33.07652], [-117.1212, 33.07624], [-117.12126, 33.07623], [-117.12136, 33.07562], [-117.12131, 33.0756], [-117.12133, 33.07547], [-117.1213, 33.07546], [-117.12141, 33.07449], [-117.12151, 33.07448], [-117.12178, 33.07265], [-117.1219, 33.07198], [-117.12179, 33.07194], [-117.12245, 33.06783], [-117.12255, 33.06782], [-117.12257, 33.06767], [-117.12265, 33.06739], [-117.12276, 33.06717], [-117.1229, 33.06695], [-117.12283, 33.06691], [-117.1229, 33.06681], [-117.12305, 33.06665], [-117.12318, 33.06653], [-117.12349, 33.06632], [-117.12368, 33.06617], [-117.12387, 33.06596], [-117.12401, 33.06571], [-117.12412, 33.0657], [-117.12411, 33.06544], [-117.12415, 33.06519], [-117.12415, 33.06479], [-117.12423, 33.06438], [-117.12603, 33.06455], [-117.12788, 33.06455], [-117.12814, 33.0646], [-117.12826, 33.0646], [-117.12862, 33.06454], [-117.12897, 33.06451], [-117.12907, 33.06454], [-117.12925, 33.06468], [-117.12939, 33.06474], [-117.12952, 33.06476], [-117.1298, 33.06475], [-117.13004, 33.06483], [-117.13017, 33.06485], [-117.1304, 33.06485], [-117.13053, 33.06486], [-117.13064, 33.0649], [-117.13091, 33.06506], [-117.12933, 33.06755], [-117.1271, 33.06756], [-117.12711, 33.07295], [-117.12718, 33.0802], [-117.13631, 33.08017], [-117.13631, 33.08116], [-117.13629, 33.08152], [-117.13633, 33.08392], [-117.13957, 33.08391], [-117.13955, 33.08019], [-117.14401, 33.08032], [-117.14803, 33.08027], [-117.14803, 33.08388], [-117.14805, 33.08584]]], [[[-117.13193, 33.06024], [-117.1319, 33.06349], [-117.13096, 33.06498], [-117.13069, 33.06483], [-117.13055, 33.06478], [-117.13042, 33.06477], [-117.1302, 33.06477], [-117.13006, 33.06475], [-117.1298, 33.06467], [-117.12954, 33.06467], [-117.12941, 33.06466], [-117.12927, 33.06459], [-117.12914, 33.06448], [-117.129, 33.06443], [-117.12886, 33.06443], [-117.12866, 33.06445], [-117.12833, 33.06451], [-117.12823, 33.06452], [-117.12769, 33.06443], [-117.12734, 33.0643], [-117.12689, 33.06409], [-117.12647, 33.06398], [-117.12639, 33.06391], [-117.12638, 33.06383], [-117.12642, 33.06376], [-117.12671, 33.06361], [-117.12679, 33.06353], [-117.12685, 33.06345], [-117.12688, 33.06336], [-117.12692, 33.0627], [-117.1271, 33.06259], [-117.12723, 33.06248], [-117.12759, 33.06209], [-117.12771, 33.06199], [-117.12786, 33.06191], [-117.12802, 33.06185], [-117.12849, 33.06178], [-117.12867, 33.06172], [-117.12883, 33.06164], [-117.12904, 33.06148], [-117.12933, 33.06112], [-117.12945, 33.06102], [-117.12965, 33.06092], [-117.13193, 33.06024]]]]} | Open Access 1 | 7314 | Del Dios Highlands Preserve | 10675 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DelDiosHighlands.html | San Diego 4 | 781.705 | Del Dios Highlands Preserve | 0 | Local Conservation Area 4 | 2 |
10540 | 10540 | 10539 | {"type": "MultiPolygon", "coordinates": [[[[-117.28114, 33.24587], [-117.27999, 33.24648], [-117.27883, 33.24704], [-117.27844, 33.24717], [-117.27838, 33.24725], [-117.27771, 33.24745], [-117.27761, 33.24739], [-117.27442, 33.24794], [-117.27425, 33.24786], [-117.27408, 33.24798], [-117.26954, 33.24542], [-117.26942, 33.24486], [-117.26917, 33.24468], [-117.26871, 33.24458], [-117.26838, 33.24438], [-117.26735, 33.2444], [-117.26689, 33.24414], [-117.26694, 33.24409], [-117.26694, 33.24408], [-117.26645, 33.24381], [-117.26633, 33.24367], [-117.26618, 33.24356], [-117.26492, 33.24287], [-117.26477, 33.24282], [-117.26461, 33.2428], [-117.2604, 33.24049], [-117.26279, 33.23744], [-117.26095, 33.23645], [-117.26139, 33.23589], [-117.2617, 33.23593], [-117.26219, 33.23606], [-117.26365, 33.23667], [-117.26381, 33.23676], [-117.26399, 33.2369], [-117.26483, 33.23772], [-117.26451, 33.23866], [-117.26492, 33.24094], [-117.2679, 33.24199], [-117.27121, 33.24204], [-117.27195, 33.24009], [-117.27198, 33.2401], [-117.27215, 33.24016], [-117.27244, 33.24033], [-117.27245, 33.24027], [-117.27461, 33.24129], [-117.27559, 33.24173], [-117.27764, 33.2426], [-117.27809, 33.24285], [-117.27835, 33.24303], [-117.27858, 33.24322], [-117.28102, 33.24561], [-117.28111, 33.24573], [-117.28114, 33.24587]]], [[[-117.26948, 33.24546], [-117.26942, 33.24554], [-117.26756, 33.24451], [-117.26834, 33.24449], [-117.26866, 33.24467], [-117.2691, 33.24478], [-117.26929, 33.24492], [-117.26941, 33.24544], [-117.26948, 33.24546]]], [[[-117.27395, 33.24807], [-117.27379, 33.24819], [-117.27228, 33.24873], [-117.27202, 33.24821], [-117.27134, 33.24784], [-117.27202, 33.24698], [-117.27395, 33.24807]]], [[[-117.29046, 33.25156], [-117.28943, 33.25295], [-117.28119, 33.24865], [-117.27759, 33.25321], [-117.27759, 33.25323], [-117.27813, 33.25354], [-117.27522, 33.25726], [-117.2719, 33.25544], [-117.27381, 33.25404], [-117.27556, 33.25218], [-117.27848, 33.25062], [-117.27889, 33.25023], [-117.27889, 33.24929], [-117.27884, 33.24886], [-117.27846, 33.24877], [-117.2784, 33.24775], [-117.27907, 33.24748], [-117.27963, 33.24723], [-117.28142, 33.24634], [-117.28154, 33.24631], [-117.28164, 33.24633], [-117.28174, 33.24652], [-117.28199, 33.24684], [-117.28207, 33.24682], [-117.28274, 33.24639], [-117.28388, 33.24579], [-117.28413, 33.24577], [-117.2844, 33.24588], [-117.28537, 33.24634], [-117.28704, 33.24588], [-117.28887, 33.24809], [-117.29046, 33.25156]]]]} | Open Access 1 | 18746 | Guajome Regional Park | 10695 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Guajome.html | San Diego 4 | 385.428 | Guajome RP | 0 | Local Park 2 | 4 |
828 | 828 | 827 | {"type": "Polygon", "coordinates": [[[-116.60586, 33.035], [-116.60569, 33.04233], [-116.60489, 33.0424], [-116.60129, 33.04245], [-116.60127, 33.04251], [-116.60002, 33.04253], [-116.5987, 33.0425], [-116.59842, 33.04233], [-116.59829, 33.04218], [-116.59813, 33.04195], [-116.59794, 33.04155], [-116.59784, 33.04137], [-116.59773, 33.04123], [-116.59756, 33.04106], [-116.59713, 33.04074], [-116.59716, 33.03891], [-116.5931, 33.03889], [-116.59285, 33.03891], [-116.59281, 33.0403], [-116.59279, 33.04249], [-116.58846, 33.04249], [-116.58844, 33.04973], [-116.58419, 33.04971], [-116.58417, 33.05062], [-116.57558, 33.05059], [-116.57561, 33.04971], [-116.57569, 33.0497], [-116.57555, 33.04248], [-116.58428, 33.04247], [-116.58426, 33.03632], [-116.58423, 33.03631], [-116.58416, 33.02825], [-116.58831, 33.02827], [-116.5925, 33.02826], [-116.59259, 33.02534], [-116.59252, 33.02528], [-116.59264, 33.02518], [-116.59278, 33.02511], [-116.59294, 33.02507], [-116.59311, 33.02506], [-116.59328, 33.02508], [-116.59344, 33.02513], [-116.59395, 33.02547], [-116.59409, 33.02551], [-116.59424, 33.02553], [-116.59439, 33.02552], [-116.59468, 33.02542], [-116.59704, 33.02542], [-116.59708, 33.02825], [-116.6015, 33.0282], [-116.60473, 33.02811], [-116.60482, 33.03499], [-116.60586, 33.035]], [[-116.58847, 33.0389], [-116.58852, 33.03726], [-116.58788, 33.03725], [-116.58785, 33.03796], [-116.58784, 33.03889], [-116.58847, 33.0389]], [[-116.5927, 33.03902], [-116.59271, 33.03901], [-116.59269, 33.03895], [-116.59071, 33.03894], [-116.58907, 33.03895], [-116.58908, 33.03902], [-116.5927, 33.03902]]]} | Open Access 1 | 5368 | William Heise County Park | 10697 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/WilliamHeise.html | San Diego 4 | 1012.3 | William Heise County Park | 0 | Local Park 2 | 4 |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 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 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
16302 | 16302 | 16301 | {"type": "MultiPolygon", "coordinates": [[[[-116.91232, 32.61566], [-116.91095, 32.61568], [-116.91078, 32.61199], [-116.91216, 32.61202], [-116.91232, 32.61566]]], [[[-116.92778, 32.59728], [-116.92778, 32.60065], [-116.92354, 32.60066], [-116.92353, 32.60446], [-116.91928, 32.60446], [-116.91927, 32.59916], [-116.91929, 32.59695], [-116.92727, 32.59688], [-116.92727, 32.59728], [-116.92778, 32.59728]]], [[[-117.01006, 32.5909], [-117.01004, 32.591], [-117.01004, 32.59112], [-117.00954, 32.59112], [-117.00907, 32.59125], [-117.00888, 32.59122], [-117.00852, 32.59242], [-117.0079, 32.59229], [-117.00821, 32.59118], [-117.00749, 32.59106], [-117.00674, 32.59097], [-117.00673, 32.5933], [-117.00575, 32.59319], [-117.00519, 32.59186], [-117.00499, 32.5913], [-117.00654, 32.59136], [-117.00653, 32.59076], [-117.01006, 32.5909]]], [[[-117.00998, 32.57781], [-117.00992, 32.57971], [-117.00881, 32.57966], [-117.0088, 32.57777], [-117.00998, 32.57781]]], [[[-117.04076, 32.58623], [-117.04076, 32.58745], [-117.03739, 32.58748], [-117.03758, 32.58632], [-117.03796, 32.58675], [-117.04076, 32.58623]]], [[[-117.04924, 32.58651], [-117.04737, 32.58651], [-117.04737, 32.58542], [-117.0474, 32.58535], [-117.04789, 32.58533], [-117.04863, 32.58602], [-117.04894, 32.58578], [-117.04924, 32.58577], [-117.04924, 32.58651]]], [[[-117.05639, 32.58743], [-117.05004, 32.58738], [-117.05005, 32.58643], [-117.05174, 32.5869], [-117.05397, 32.58692], [-117.05549, 32.58712], [-117.05639, 32.58743]]], [[[-117.0608, 32.58744], [-117.06077, 32.5878], [-117.06076, 32.58781], [-117.06057, 32.58744], [-117.0608, 32.58744]]], [[[-117.06677, 32.58746], [-117.06677, 32.58881], [-117.06244, 32.5888], [-117.06243, 32.58871], [-117.06125, 32.58863], [-117.06121, 32.58857], [-117.06114, 32.58842], [-117.0611, 32.58825], [-117.06109, 32.58778], [-117.06112, 32.58761], [-117.06118, 32.58744], [-117.06677, 32.58746]]], [[[-117.07163, 32.58838], [-117.07163, 32.5884], [-117.07115, 32.5884], [-117.07115, 32.58747], [-117.07134, 32.58747], [-117.07135, 32.58748], [-117.07146, 32.58789], [-117.07163, 32.58838]]], [[[-117.08349, 32.58715], [-117.08349, 32.58795], [-117.08132, 32.58885], [-117.07725, 32.58886], [-117.07724, 32.5875], [-117.07475, 32.5875], [-117.07475, 32.58693], [-117.07542, 32.5865], [-117.07542, 32.5863], [-117.07608, 32.58629], [-117.07607, 32.5852], [-117.07476, 32.5852], [-117.07476, 32.58448], [-117.07508, 32.58448], [-117.07508, 32.58432], [-117.07576, 32.5843], [-117.07577, 32.58432], [-117.07626, 32.58432], [-117.07627, 32.58423], [-117.07709, 32.58411], [-117.07748, 32.58407], [-117.07749, 32.58404], [-117.07804, 32.58404], [-117.07806, 32.58472], [-117.07866, 32.58472], [-117.07868, 32.58632], [-117.07973, 32.58632], [-117.07973, 32.58659], [-117.07981, 32.5866], [-117.07981, 32.58717], [-117.08035, 32.58717], [-117.08073, 32.58726], [-117.08126, 32.58729], [-117.08165, 32.58722], [-117.08268, 32.58714], [-117.08349, 32.58715]]]]} | Open Access 1 | 485 | Otay Valley Regional Park | 10739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 246.744 | Otay Valley RP | 0 | Local Park 2 | 4 |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
16429 | 16429 | 16428 | {"type": "MultiPolygon", "coordinates": [[[[-117.08193, 32.54359], [-117.08193, 32.54404], [-117.08176, 32.54414], [-117.08156, 32.5442], [-117.08155, 32.54359], [-117.08193, 32.54359]]], [[[-117.07141, 32.54461], [-117.07128, 32.54463], [-117.07119, 32.54462], [-117.07116, 32.54459], [-117.07116, 32.54444], [-117.07129, 32.54455], [-117.07141, 32.54461]]], [[[-117.07302, 32.54484], [-117.07156, 32.54449], [-117.07146, 32.54445], [-117.07129, 32.54433], [-117.07124, 32.54426], [-117.07116, 32.54411], [-117.07119, 32.54305], [-117.07115, 32.54289], [-117.0711, 32.54274], [-117.07131, 32.54285], [-117.07146, 32.54295], [-117.07173, 32.54316], [-117.07189, 32.54332], [-117.07205, 32.54351], [-117.07215, 32.54367], [-117.07302, 32.54484]]], [[[-117.08194, 32.5453], [-117.08157, 32.5453], [-117.08156, 32.54434], [-117.08174, 32.5443], [-117.08193, 32.54421], [-117.08194, 32.5453]]], [[[-117.10157, 32.53695], [-117.10155, 32.54306], [-117.10157, 32.54478], [-117.10121, 32.54501], [-117.10092, 32.54514], [-117.1002, 32.54563], [-117.09998, 32.54581], [-117.09956, 32.546], [-117.09935, 32.54605], [-117.09903, 32.54607], [-117.09874, 32.54603], [-117.0985, 32.54596], [-117.09686, 32.54563], [-117.09677, 32.54557], [-117.09665, 32.54552], [-117.09639, 32.54545], [-117.09605, 32.54544], [-117.0959, 32.54547], [-117.09562, 32.54548], [-117.09537, 32.54545], [-117.09509, 32.54536], [-117.09495, 32.54528], [-117.09482, 32.54519], [-117.0947, 32.5451], [-117.09458, 32.54496], [-117.09353, 32.54441], [-117.09332, 32.54436], [-117.0931, 32.54435], [-117.09292, 32.54438], [-117.09278, 32.54442], [-117.09276, 32.54356], [-117.08828, 32.54358], [-117.08812, 32.54352], [-117.08642, 32.54351], [-117.08408, 32.54353], [-117.08407, 32.54252], [-117.08272, 32.54252], [-117.08272, 32.54354], [-117.08084, 32.54355], [-117.08084, 32.54437], [-117.08016, 32.54452], [-117.08013, 32.54355], [-117.07795, 32.54357], [-117.07796, 32.54485], [-117.07627, 32.54486], [-117.07627, 32.5459], [-117.07563, 32.54584], [-117.07424, 32.54583], [-117.07411, 32.5458], [-117.07399, 32.54576], [-117.07389, 32.5457], [-117.07377, 32.5456], [-117.07228, 32.5436], [-117.07219, 32.54344], [-117.07199, 32.5432], [-117.07178, 32.54301], [-117.07153, 32.54281], [-117.07128, 32.54267], [-117.0711, 32.54258], [-117.07112, 32.54], [-117.07334, 32.53999], [-117.07946, 32.53946], [-117.08409, 32.53926], [-117.08506, 32.54025], [-117.08758, 32.54023], [-117.08759, 32.53999], [-117.08846, 32.53953], [-117.09009, 32.53933], [-117.09193, 32.53891], [-117.09453, 32.53864], [-117.09532, 32.53862], [-117.09568, 32.53891], [-117.0965, 32.53891], [-117.09718, 32.53853], [-117.09849, 32.53814], [-117.10007, 32.53686], [-117.10157, 32.53695]]], [[[-117.10585, 32.54377], [-117.10584, 32.54731], [-117.10576, 32.54732], [-117.10576, 32.54377], [-117.10585, 32.54377]]], [[[-117.1016, 32.54732], [-117.09288, 32.54732], [-117.09285, 32.54664], [-117.09285, 32.54512], [-117.09284, 32.54473], [-117.09281, 32.54459], [-117.09291, 32.54455], [-117.09314, 32.54451], [-117.09328, 32.54452], [-117.09344, 32.54456], [-117.0936, 32.54463], [-117.0937, 32.54471], [-117.09445, 32.54508], [-117.09457, 32.54521], [-117.09471, 32.54534], [-117.09486, 32.54544], [-117.09503, 32.54552], [-117.09532, 32.54561], [-117.09558, 32.54565], [-117.09582, 32.54565], [-117.09608, 32.5456], [-117.09636, 32.54561], [-117.0966, 32.54568], [-117.09678, 32.54579], [-117.09844, 32.54612], [-117.09853, 32.54616], [-117.09872, 32.5462], [-117.09893, 32.54623], [-117.09923, 32.54623], [-117.09938, 32.54621], [-117.09968, 32.54614], [-117.09987, 32.54607], [-117.10013, 32.54592], [-117.10031, 32.54577], [-117.1007, 32.54551], [-117.10099, 32.5453], [-117.1013, 32.54516], [-117.10157, 32.54498], [-117.1016, 32.54732]]], [[[-117.0885, 32.54724], [-117.08629, 32.54721], [-117.0863, 32.54538], [-117.08739, 32.54537], [-117.08736, 32.54369], [-117.08806, 32.54369], [-117.08816, 32.5437], [-117.08825, 32.54378], [-117.08837, 32.54396], [-117.08845, 32.54413], [-117.0885, 32.54724]]], [[[-117.09384, 32.55778], [-117.09383, 32.55815], [-117.09285, 32.55815], [-117.09285, 32.55777], [-117.09384, 32.55778]]], [[[-117.10606, 32.5586], [-117.10571, 32.55859], [-117.1057, 32.55838], [-117.10148, 32.55833], [-117.10149, 32.5583], [-117.10605, 32.5583], [-117.10606, 32.5586]]], [[[-117.09275, 32.55093], [-117.09268, 32.55815], [-117.08418, 32.55813], [-117.08419, 32.55448], [-117.08437, 32.55447], [-117.08438, 32.55436], [-117.08437, 32.55435], [-117.08419, 32.55436], [-117.08418, 32.55418], [-117.08419, 32.55089], [-117.09275, 32.55093]]], [[[-117.06228, 32.5546], [-117.06228, 32.55681], [-117.06223, 32.55707], [-117.06211, 32.55742], [-117.06201, 32.55751], [-117.06188, 32.55756], [-117.06118, 32.55754], [-117.06066, 32.55742], [-117.06009, 32.55724], [-117.0596, 32.55707], [-117.05707, 32.55606], [-117.05613, 32.55565], [-117.05614, 32.5551], [-117.05646, 32.55509], [-117.05644, 32.55455], [-117.05809, 32.55454], [-117.05811, 32.55279], [-117.06225, 32.55457], [-117.06228, 32.5546]]], [[[-117.10139, 32.55833], [-117.10137, 32.56011], [-117.09925, 32.56009], [-117.09927, 32.55832], [-117.10139, 32.55833]]], [[[-117.08409, 32.5564], [-117.07974, 32.5564], [-117.07974, 32.55815], [-117.07532, 32.55815], [-117.07531, 32.56004], [-117.07196, 32.56004], [-117.07211, 32.55984], [-117.07172, 32.55962], [-117.0716, 32.55962], [-117.0716, 32.55957], [-117.07158, 32.55954], [-117.07152, 32.55949], [-117.07149, 32.55949], [-117.07052, 32.55891], [-117.06727, 32.55688], [-117.06725, 32.55689], [-117.06718, 32.55682], [-117.06694, 32.5567], [-117.06676, 32.55665], [-117.06675, 32.55646], [-117.06643, 32.55659], [-117.06601, 32.55672], [-117.06533, 32.55684], [-117.0647, 32.5569], [-117.06405, 32.5569], [-117.06355, 32.55686], [-117.06302, 32.55678], [-117.06256, 32.55666], [-117.06255, 32.55664], [-117.06256, 32.55265], [-117.06254, 32.55195], [-117.06259, 32.55166], [-117.06266, 32.55143], [-117.0628, 32.55118], [-117.06505, 32.54927], [-117.06956, 32.5526], [-117.06963, 32.55256], [-117.07039, 32.5532], [-117.07057, 32.55332], [-117.07085, 32.55347], [-117.07108, 32.55356], [-117.07109, 32.55348], [-117.0711, 32.55348], [-117.0713, 32.55354], [-117.07152, 32.55356], [-117.0718, 32.55356], [-117.07193, 32.55355], [-117.07197, 32.55366], [-117.07212, 32.55364], [-117.07199, 32.55317], [-117.07187, 32.55319], [-117.07188, 32.55328], [-117.07179, 32.55329], [-117.07154, 32.55329], [-117.07135, 32.55327], [-117.07109, 32.55321], [-117.07108, 32.55314], [-117.07093, 32.55309], [-117.07074, 32.55298], [-117.06992, 32.55231], [-117.06995, 32.55225], [-117.0655, 32.54887], [-117.06764, 32.54711], [-117.06956, 32.54545], [-117.06988, 32.54523], [-117.07016, 32.54509], [-117.07046, 32.54496], [-117.07089, 32.54483], [-117.07135, 32.54476], [-117.0718, 32.54475], [-117.07227, 32.5448], [-117.07289, 32.54495], [-117.07304, 32.545], [-117.0732, 32.5451], [-117.07326, 32.54516], [-117.07364, 32.54568], [-117.07378, 32.5458], [-117.07399, 32.54591], [-117.07414, 32.54596], [-117.07427, 32.54598], [-117.07543, 32.54598], [-117.07543, 32.54677], [-117.07335, 32.54678], [-117.07273, 32.54673], [-117.07243, 32.54667], [-117.07191, 32.54654], [-117.07163, 32.54643], [-117.0711, 32.5462], [-117.07111, 32.54673], [-117.07148, 32.54689], [-117.07188, 32.54702], [-117.07247, 32.54716], [-117.07334, 32.54725], [-117.07542, 32.54723], [-117.07543, 32.54718], [-117.08085, 32.54719], [-117.08397, 32.54717], [-117.08397, 32.55408], [-117.08326, 32.55408], [-117.08325, 32.55454], [-117.08408, 32.55455], [-117.08409, 32.5564]]], [[[-117.08408, 32.55826], [-117.08407, 32.56117], [-117.07896, 32.56115], [-117.07542, 32.56117], [-117.07541, 32.55826], [-117.08408, 32.55826]]]]} | Open Access 1 | 45085 | Tijuana River Valley Regional Park | 13879 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 1321.284 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
763 | 763 | 762 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00081, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.0002, 32.74539], [-117.00067, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | 4973 | Bancroft Park | 15792 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | San Diego 4 | 4.676 | Bancroft Park | 0 | Local Park 2 | 4 |
6709 | 6709 | 6708 | {"type": "MultiPolygon", "coordinates": [[[[-116.91484, 32.86884], [-116.91485, 32.87034], [-116.91482, 32.87063], [-116.91469, 32.87097], [-116.91454, 32.87121], [-116.91438, 32.87142], [-116.91412, 32.87164], [-116.91342, 32.87076], [-116.91262, 32.87037], [-116.91096, 32.87045], [-116.91023, 32.86652], [-116.91402, 32.86599], [-116.91456, 32.86881], [-116.91484, 32.86884]]], [[[-116.91825, 32.86993], [-116.91733, 32.87197], [-116.91627, 32.87239], [-116.91504, 32.87239], [-116.91426, 32.87179], [-116.91425, 32.87177], [-116.91446, 32.87159], [-116.91462, 32.87141], [-116.91477, 32.8712], [-116.91487, 32.87103], [-116.91497, 32.87078], [-116.91502, 32.87058], [-116.91505, 32.87035], [-116.91505, 32.8701], [-116.91599, 32.87019], [-116.91531, 32.87033], [-116.91536, 32.87052], [-116.91825, 32.86993]]]]} | Open Access 1 | 5036 | Cactus Park | 16651 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cactus.html | San Diego 4 | 61.039 | Cactus Park | 0 | Local Park 2 | 4 |
601 | 601 | 600 | {"type": "Polygon", "coordinates": [[[-116.86232, 33.04283], [-116.86091, 33.04362], [-116.85968, 33.04204], [-116.8611, 33.04126], [-116.86164, 33.04196], [-116.86161, 33.04199], [-116.86171, 33.04211], [-116.86175, 33.04209], [-116.86232, 33.04283]]]} | Open Access 1 | 4174 | Collier Park | 17519 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Collier.html | San Diego 4 | 8.145 | Collier Park | 0 | Local Park 2 | 4 |
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-116.94512, 32.75532], [-116.94511, 32.75706], [-116.94501, 32.75707], [-116.94501, 32.75859], [-116.94202, 32.75855], [-116.94197, 32.75818], [-116.94278, 32.7581], [-116.94286, 32.75813], [-116.94295, 32.75812], [-116.94301, 32.75808], [-116.94303, 32.75805], [-116.94303, 32.758], [-116.94301, 32.75794], [-116.94294, 32.75789], [-116.94297, 32.75783], [-116.94254, 32.75687], [-116.94212, 32.75672], [-116.94171, 32.75665], [-116.94122, 32.7557], [-116.94096, 32.75447], [-116.94109, 32.75444], [-116.94116, 32.75429], [-116.94127, 32.75428], [-116.94133, 32.75425], [-116.94136, 32.7542], [-116.94165, 32.75423], [-116.94281, 32.75501], [-116.94287, 32.75503], [-116.94512, 32.75532]]]} | Open Access 1 | 5000 | Damon Lane Park | 17902 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DamonLane.html | San Diego 4 | 29.5 | Damon Lane Park | 0 | Local Park 2 | 4 |
843 | 843 | 842 | {"type": "Polygon", "coordinates": [[[-116.9683, 32.73338], [-116.9683, 32.73465], [-116.96616, 32.73505], [-116.9659, 32.73378], [-116.96606, 32.73382], [-116.96615, 32.73378], [-116.96618, 32.73375], [-116.96619, 32.73366], [-116.96615, 32.73359], [-116.96606, 32.73356], [-116.96598, 32.73356], [-116.96587, 32.73363], [-116.96582, 32.73336], [-116.9683, 32.73338]]]} | Open Access 1 | 4978 | Del Parque Park | 18044 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 8.751 | Del Parque Park | 0 | Local Park 2 | 4 | |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | 5304 | Don Dussault Park | 18203 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DonDussault.html | San Diego 4 | 0.746 | Don Dussault Park | 0 | Local Park 2 | 4 |
10581 | 10581 | 10580 | {"type": "Polygon", "coordinates": [[[-116.94463, 32.99593], [-116.94441, 32.9987], [-116.94439, 32.99875], [-116.94439, 32.99899], [-116.94433, 32.9996], [-116.94028, 32.99968], [-116.93617, 32.99969], [-116.93612, 32.99608], [-116.94463, 32.99593]]]} | Open Access 1 | 18841 | Dos Picos Park | 18228 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DosPicos.html | San Diego 4 | 78.103 | Dos Picos Park | 0 | Local Park 2 | 4 |
6772 | 6772 | 6771 | {"type": "MultiPolygon", "coordinates": [[[[-116.85271, 32.89302], [-116.85016, 32.89317], [-116.85014, 32.89281], [-116.84423, 32.89275], [-116.84295, 32.89205], [-116.84351, 32.8922], [-116.84518, 32.89238], [-116.84573, 32.89242], [-116.84616, 32.89241], [-116.84661, 32.89238], [-116.84788, 32.89222], [-116.8482, 32.89215], [-116.84849, 32.89204], [-116.84878, 32.89189], [-116.84902, 32.89172], [-116.84923, 32.89151], [-116.84936, 32.89135], [-116.84947, 32.89115], [-116.84995, 32.89012], [-116.85271, 32.89302]]], [[[-116.85018, 32.88908], [-116.85003, 32.88947], [-116.84931, 32.89106], [-116.84921, 32.89122], [-116.84905, 32.89144], [-116.84886, 32.89162], [-116.84863, 32.89178], [-116.8484, 32.8919], [-116.84815, 32.89199], [-116.84785, 32.89205], [-116.8466, 32.89221], [-116.84599, 32.89225], [-116.84526, 32.89223], [-116.84343, 32.89201], [-116.84478, 32.88919], [-116.84558, 32.8872], [-116.84609, 32.88674], [-116.84638, 32.88601], [-116.84995, 32.88843], [-116.85002, 32.8885], [-116.85007, 32.88858], [-116.85018, 32.88908]]]]} | Open Access 1 | 5237 | El Monte Park | 18518 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElMonte.html | San Diego 4 | 87.505 | El Monte Park | 0 | Local Park 2 | 4 |
6705 | 6705 | 6704 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00109, 32.76047], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | 5007 | Eucalyptus Park | 18739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Eucalyptus.html | San Diego 4 | 6.737 | Eucalyptus Park | 0 | Local Park 2 | 4 |
6795 | 6795 | 6794 | {"type": "MultiPolygon", "coordinates": [[[[-117.23538, 33.37666], [-117.23537, 33.37797], [-117.23496, 33.37797], [-117.23496, 33.37696], [-117.23431, 33.37695], [-117.23431, 33.37662], [-117.2353, 33.37661], [-117.23535, 33.37663], [-117.23538, 33.37666]]], [[[-117.23748, 33.37662], [-117.23725, 33.37715], [-117.23745, 33.37724], [-117.23724, 33.37765], [-117.23639, 33.37765], [-117.23639, 33.37853], [-117.23556, 33.37853], [-117.23557, 33.37665], [-117.23562, 33.37661], [-117.23748, 33.37662]]]]} | Open Access 1 | 5294 | Fallbrook Park and Community Center | 18835 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/FallbrookCommunityCenter.html | San Diego 4 | 8.565 | Fallbrook Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 |
6812 | 6812 | 6811 | {"type": "Polygon", "coordinates": [[[-117.08786, 33.07997], [-117.08663, 33.08481], [-117.0855, 33.08398], [-117.08509, 33.08399], [-117.08483, 33.08422], [-117.08478, 33.08422], [-117.08463, 33.08428], [-117.0845, 33.08425], [-117.08444, 33.08419], [-117.08339, 33.0828], [-117.08329, 33.08262], [-117.08314, 33.08231], [-117.083, 33.08184], [-117.08296, 33.08162], [-117.08294, 33.08128], [-117.08302, 33.08086], [-117.08394, 33.08103], [-117.084, 33.08091], [-117.08399, 33.0809], [-117.08305, 33.08074], [-117.0832, 33.08033], [-117.08426, 33.07827], [-117.08433, 33.07802], [-117.0844, 33.07797], [-117.08441, 33.07795], [-117.08443, 33.07795], [-117.08542, 33.07814], [-117.08571, 33.07944], [-117.08628, 33.07986], [-117.08671, 33.07998], [-117.08786, 33.07997]]]} | Open Access 1 | 5367 | Felicita Park | 18866 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Felicita.html | San Diego 4 | 51.878 | Felicita Park | 0 | Local Park 2 | 4 |
12137 | 12137 | 12136 | {"type": "Polygon", "coordinates": [[[-116.86437, 32.84792], [-116.86395, 32.84801], [-116.86323, 32.84819], [-116.86121, 32.84874], [-116.86081, 32.84886], [-116.86032, 32.84905], [-116.85989, 32.84924], [-116.85946, 32.84947], [-116.85905, 32.84973], [-116.85909, 32.84962], [-116.85783, 32.84867], [-116.85712, 32.84965], [-116.85469, 32.84965], [-116.85468, 32.8487], [-116.85753, 32.84505], [-116.86185, 32.84502], [-116.86186, 32.84501], [-116.86171, 32.84478], [-116.8618, 32.84476], [-116.86312, 32.84505], [-116.86228, 32.84564], [-116.86362, 32.84766], [-116.86437, 32.84792]]]} | Open Access 1 | 25128 | Flinn Springs County Park | 18950 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/FlinnSprings.html | San Diego 4 | 75.51 | Flinn Springs County Park | 0 | Local Park 2 | 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]);