units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where DES_TP = 83, LAYER = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
MNG_AGENCY 4
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 6 ✖
DES_TP 1
- Local Resource Management Area · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
916 | 916 | 915 | {"type": "MultiPolygon", "coordinates": [[[[-118.43796, 34.0918], [-118.43779, 34.09194], [-118.43779, 34.09194], [-118.43776, 34.09182], [-118.4379, 34.09171], [-118.43796, 34.0918]]], [[[-118.43996, 34.09207], [-118.43949, 34.09221], [-118.43945, 34.09215], [-118.43993, 34.092], [-118.43996, 34.09207]]], [[[-118.4388, 34.09299], [-118.4388, 34.09299], [-118.43854, 34.0932], [-118.4385, 34.09311], [-118.43873, 34.09293], [-118.4388, 34.09299]]], [[[-118.43918, 34.09335], [-118.43904, 34.0935], [-118.43885, 34.09333], [-118.43861, 34.0933], [-118.43891, 34.09306], [-118.43896, 34.09309], [-118.43918, 34.09335]]], [[[-118.43859, 34.09335], [-118.43839, 34.09353], [-118.43818, 34.09356], [-118.43852, 34.09335], [-118.43859, 34.09335]]], [[[-118.43946, 34.09359], [-118.43931, 34.09374], [-118.43922, 34.09367], [-118.43937, 34.09352], [-118.43946, 34.09359]]], [[[-118.43968, 34.09372], [-118.43954, 34.09387], [-118.43941, 34.09382], [-118.43957, 34.09366], [-118.43968, 34.09372]]], [[[-118.43918, 34.09413], [-118.43894, 34.0943], [-118.43871, 34.09407], [-118.43895, 34.0939], [-118.43918, 34.09413]]], [[[-118.44126, 34.09536], [-118.44086, 34.09542], [-118.44084, 34.09536], [-118.44124, 34.09529], [-118.44126, 34.09536]]], [[[-118.4393, 34.09542], [-118.4392, 34.09542], [-118.43917, 34.09519], [-118.43928, 34.09519], [-118.4393, 34.09542]]], [[[-118.43957, 34.09573], [-118.43956, 34.09581], [-118.43926, 34.09589], [-118.43923, 34.09583], [-118.43957, 34.09573]]], [[[-118.43955, 34.09667], [-118.43924, 34.09675], [-118.43921, 34.09669], [-118.43953, 34.0966], [-118.43955, 34.09667]]], [[[-118.43963, 34.09686], [-118.43931, 34.09695], [-118.43929, 34.09688], [-118.43961, 34.0968], [-118.43963, 34.09686]]], [[[-118.4408, 34.09686], [-118.44049, 34.09701], [-118.44047, 34.097], [-118.44026, 34.09707], [-118.44077, 34.09682], [-118.4408, 34.09686]]], [[[-118.43979, 34.09724], [-118.43947, 34.09734], [-118.43934, 34.09702], [-118.43966, 34.09692], [-118.43979, 34.09724]]], [[[-118.44267, 34.09767], [-118.44241, 34.09784], [-118.4421, 34.09752], [-118.44236, 34.09735], [-118.44267, 34.09767]]], [[[-118.44053, 34.09803], [-118.43983, 34.09823], [-118.43959, 34.09764], [-118.44031, 34.0977], [-118.44043, 34.09781], [-118.44046, 34.0979], [-118.44014, 34.098], [-118.44016, 34.09806], [-118.4405, 34.09797], [-118.44053, 34.09803]]], [[[-118.44157, 34.09821], [-118.44154, 34.09841], [-118.44143, 34.09845], [-118.44146, 34.09825], [-118.44157, 34.09821]]], [[[-118.44195, 34.09862], [-118.44174, 34.09871], [-118.44169, 34.09867], [-118.44167, 34.09864], [-118.44189, 34.09853], [-118.44195, 34.09862]]], [[[-118.44239, 34.09894], [-118.44224, 34.09901], [-118.44193, 34.09886], [-118.44213, 34.09877], [-118.44239, 34.09894]]], [[[-118.4408, 34.09858], [-118.4406, 34.09872], [-118.44061, 34.09873], [-118.44069, 34.09875], [-118.4406, 34.09903], [-118.44044, 34.099], [-118.44052, 34.09871], [-118.44045, 34.0987], [-118.44036, 34.09897], [-118.44009, 34.09886], [-118.43999, 34.09862], [-118.44034, 34.09852], [-118.44024, 34.09826], [-118.44059, 34.09816], [-118.44063, 34.09833], [-118.4407, 34.09842], [-118.44035, 34.09852], [-118.44036, 34.09857], [-118.44073, 34.09848], [-118.4408, 34.09858]]], [[[-118.44373, 34.09901], [-118.4435, 34.09909], [-118.44343, 34.09897], [-118.44339, 34.09893], [-118.44366, 34.09885], [-118.44373, 34.09901]]], [[[-118.4459, 34.09942], [-118.44585, 34.0994], [-118.4457, 34.09882], [-118.44575, 34.09883], [-118.4459, 34.09942]]], [[[-118.44188, 34.10001], [-118.44164, 34.10007], [-118.44161, 34.09999], [-118.44186, 34.09992], [-118.44188, 34.10001]]], [[[-118.4413, 34.10001], [-118.44112, 34.10008], [-118.44101, 34.09986], [-118.44119, 34.0998], [-118.4413, 34.10001]]], [[[-118.44521, 34.10007], [-118.44493, 34.10034], [-118.44483, 34.10026], [-118.44509, 34.10001], [-118.44521, 34.10007]]], [[[-118.44201, 34.10027], [-118.44198, 34.10044], [-118.44179, 34.10058], [-118.44168, 34.10047], [-118.44181, 34.10037], [-118.44184, 34.10024], [-118.44201, 34.10027]]], [[[-118.44162, 34.10024], [-118.44141, 34.10039], [-118.44117, 34.10057], [-118.44123, 34.10031], [-118.44122, 34.10029], [-118.44161, 34.10018], [-118.44162, 34.10024]]], [[[-118.44635, 34.10035], [-118.44624, 34.10068], [-118.44605, 34.10063], [-118.44615, 34.10031], [-118.44635, 34.10035]]], [[[-118.44164, 34.10049], [-118.44144, 34.10065], [-118.44154, 34.10076], [-118.44129, 34.10093], [-118.44119, 34.10083], [-118.44112, 34.10087], [-118.44105, 34.10069], [-118.44114, 34.10067], [-118.44153, 34.10038], [-118.44164, 34.10049]]], [[[-118.44645, 34.10138], [-118.44618, 34.1014], [-118.44614, 34.10106], [-118.44641, 34.10104], [-118.44645, 34.10138]]], [[[-118.44163, 34.10156], [-118.44154, 34.10156], [-118.44143, 34.10128], [-118.44114, 34.1012], [-118.44151, 34.10115], [-118.44155, 34.10133], [-118.44158, 34.10133], [-118.44163, 34.10156]]], [[[-118.44219, 34.10134], [-118.44198, 34.10157], [-118.44195, 34.10153], [-118.44191, 34.10154], [-118.44189, 34.10129], [-118.44219, 34.10134]]], [[[-118.4437, 34.1016], [-118.44368, 34.10166], [-118.44335, 34.1016], [-118.44334, 34.10166], [-118.44366, 34.10174], [-118.44361, 34.10186], [-118.4433, 34.1018], [-118.44328, 34.10183], [-118.44297, 34.10164], [-118.44304, 34.10155], [-118.4431, 34.10136], [-118.44341, 34.10143], [-118.44338, 34.10153], [-118.4437, 34.1016]]], [[[-118.44344, 34.10211], [-118.44334, 34.10223], [-118.44276, 34.10189], [-118.44288, 34.10174], [-118.44319, 34.10193], [-118.44318, 34.10196], [-118.44344, 34.10211]]], [[[-118.4426, 34.10177], [-118.44252, 34.10241], [-118.44229, 34.10246], [-118.4423, 34.10236], [-118.44201, 34.10167], [-118.44236, 34.10144], [-118.44233, 34.10171], [-118.4426, 34.10177]]], [[[-118.4438, 34.10269], [-118.44312, 34.10271], [-118.44311, 34.10262], [-118.44346, 34.10266], [-118.44356, 34.10255], [-118.44379, 34.10253], [-118.4438, 34.10269]]], [[[-118.44347, 34.10283], [-118.44313, 34.10284], [-118.44313, 34.10278], [-118.44347, 34.10276], [-118.44347, 34.10283]]], [[[-118.44382, 34.10303], [-118.44351, 34.10305], [-118.4435, 34.10309], [-118.44315, 34.10311], [-118.44314, 34.10304], [-118.44349, 34.10303], [-118.44349, 34.10292], [-118.44382, 34.1029], [-118.44382, 34.10303]]], [[[-118.44215, 34.10332], [-118.44198, 34.10347], [-118.44185, 34.10318], [-118.44192, 34.10313], [-118.44215, 34.10332]]], [[[-118.443, 34.10348], [-118.44294, 34.10353], [-118.44246, 34.10314], [-118.44258, 34.10304], [-118.44282, 34.10323], [-118.44277, 34.10329], [-118.443, 34.10348]]], [[[-118.44282, 34.10363], [-118.44271, 34.10372], [-118.44247, 34.10352], [-118.44259, 34.10343], [-118.44282, 34.10363]]], [[[-118.44817, 34.10376], [-118.44804, 34.10418], [-118.44797, 34.10416], [-118.44799, 34.10416], [-118.44812, 34.10371], [-118.44817, 34.10376]]], [[[-118.44546, 34.10437], [-118.44515, 34.1045], [-118.44512, 34.10444], [-118.44542, 34.10431], [-118.44546, 34.10437]]], [[[-118.44414, 34.1046], [-118.44414, 34.10484], [-118.44404, 34.10484], [-118.44405, 34.1046], [-118.44414, 34.1046]]], [[[-118.44673, 34.10513], [-118.44636, 34.10515], [-118.44635, 34.10509], [-118.44672, 34.10505], [-118.44673, 34.10513]]], [[[-118.44498, 34.10562], [-118.44473, 34.10554], [-118.44481, 34.10537], [-118.44491, 34.10552], [-118.44498, 34.10562]]], [[[-118.44462, 34.10531], [-118.44446, 34.10563], [-118.4438, 34.10543], [-118.44338, 34.10538], [-118.44321, 34.10497], [-118.44345, 34.10498], [-118.44346, 34.10516], [-118.44417, 34.10517], [-118.44462, 34.10531]]], [[[-118.45316, 34.10567], [-118.45288, 34.10572], [-118.45215, 34.10592], [-118.45189, 34.10592], [-118.45135, 34.10538], [-118.45315, 34.10538], [-118.45316, 34.10567]]], [[[-118.45182, 34.10592], [-118.4506, 34.10592], [-118.45012, 34.1058], [-118.45003, 34.10592], [-118.4496, 34.10592], [-118.44948, 34.10536], [-118.45127, 34.10538], [-118.45182, 34.10592]]], [[[-118.44912, 34.10596], [-118.449, 34.10596], [-118.44901, 34.10569], [-118.44906, 34.10569], [-118.44912, 34.10596]]], [[[-118.44957, 34.10607], [-118.44914, 34.10606], [-118.44913, 34.10601], [-118.44955, 34.10601], [-118.44957, 34.10607]]], [[[-118.44358, 34.10592], [-118.44329, 34.10611], [-118.44311, 34.10591], [-118.4434, 34.10572], [-118.44358, 34.10592]]], [[[-118.4496, 34.10623], [-118.44918, 34.10622], [-118.44917, 34.10617], [-118.44959, 34.10617], [-118.4496, 34.10623]]], [[[-118.45316, 34.10573], [-118.45316, 34.10623], [-118.45161, 34.10651], [-118.45191, 34.10598], [-118.45216, 34.10597], [-118.45289, 34.10578], [-118.45316, 34.10573]]], [[[-118.45183, 34.10598], [-118.45154, 34.10652], [-118.45006, 34.10653], [-118.44974, 34.10652], [-118.44961, 34.10598], [-118.45007, 34.10598], [-118.45015, 34.10586], [-118.4506, 34.10597], [-118.45183, 34.10598]]], [[[-118.44967, 34.10655], [-118.44925, 34.10655], [-118.44923, 34.10644], [-118.44965, 34.10644], [-118.44967, 34.10655]]], [[[-118.44701, 34.1067], [-118.44699, 34.10688], [-118.44653, 34.10685], [-118.44654, 34.10674], [-118.44666, 34.10675], [-118.44668, 34.10668], [-118.44701, 34.1067]]], [[[-118.45316, 34.10629], [-118.45316, 34.10678], [-118.45314, 34.1068], [-118.45135, 34.10696], [-118.45158, 34.10658], [-118.45316, 34.10629]]], [[[-118.44954, 34.10701], [-118.44925, 34.10721], [-118.44908, 34.10717], [-118.44916, 34.10692], [-118.44954, 34.10701]]], [[[-118.4515, 34.10658], [-118.45126, 34.10697], [-118.45031, 34.10736], [-118.44994, 34.10687], [-118.44981, 34.10685], [-118.44975, 34.10658], [-118.4515, 34.10658]]], [[[-118.45311, 34.10738], [-118.45163, 34.10751], [-118.45134, 34.10702], [-118.45307, 34.10686], [-118.4529, 34.107], [-118.45288, 34.10705], [-118.45288, 34.10709], [-118.45291, 34.10715], [-118.45308, 34.10728], [-118.45311, 34.10734], [-118.45311, 34.10738]]], [[[-118.45157, 34.10752], [-118.45071, 34.10787], [-118.45036, 34.10742], [-118.45127, 34.10704], [-118.45157, 34.10752]]], [[[-118.45315, 34.10763], [-118.45299, 34.10795], [-118.45196, 34.10804], [-118.45166, 34.10756], [-118.45312, 34.10742], [-118.45315, 34.10763]]], [[[-118.4519, 34.10806], [-118.4511, 34.10838], [-118.45075, 34.10793], [-118.4516, 34.10758], [-118.4519, 34.10806]]], [[[-118.45298, 34.10804], [-118.45297, 34.10805], [-118.45297, 34.10842], [-118.4529, 34.10849], [-118.45277, 34.10852], [-118.45267, 34.10857], [-118.45261, 34.10863], [-118.45257, 34.10874], [-118.45236, 34.10869], [-118.45229, 34.10869], [-118.45216, 34.10877], [-118.45204, 34.10874], [-118.45181, 34.10879], [-118.45171, 34.10883], [-118.45159, 34.10895], [-118.4515, 34.10897], [-118.45114, 34.10844], [-118.45195, 34.1081], [-118.45298, 34.108], [-118.45298, 34.10804]]], [[[-118.44595, 34.10907], [-118.44591, 34.10913], [-118.44571, 34.10895], [-118.44579, 34.1089], [-118.44595, 34.10904], [-118.44595, 34.10907]]], [[[-118.45323, 34.1084], [-118.45322, 34.10951], [-118.45244, 34.10954], [-118.45242, 34.10882], [-118.45255, 34.10885], [-118.45264, 34.10883], [-118.45269, 34.10879], [-118.45272, 34.10869], [-118.45278, 34.10864], [-118.45292, 34.10861], [-118.45302, 34.10855], [-118.45309, 34.10847], [-118.45311, 34.1084], [-118.45323, 34.1084]]], [[[-118.45145, 34.10899], [-118.45124, 34.10902], [-118.45097, 34.10916], [-118.45065, 34.10927], [-118.45041, 34.10925], [-118.45037, 34.10922], [-118.45025, 34.10908], [-118.45017, 34.10904], [-118.45006, 34.10905], [-118.44997, 34.10909], [-118.44991, 34.10918], [-118.44965, 34.10917], [-118.44958, 34.1092], [-118.44949, 34.1093], [-118.44942, 34.10954], [-118.44931, 34.10908], [-118.44937, 34.10904], [-118.44961, 34.1088], [-118.44902, 34.1078], [-118.44924, 34.10729], [-118.44979, 34.10689], [-118.44989, 34.10692], [-118.45065, 34.1079], [-118.45036, 34.10801], [-118.45038, 34.10806], [-118.45068, 34.10795], [-118.45108, 34.10846], [-118.45145, 34.10899]]], [[[-118.44924, 34.10961], [-118.44899, 34.10981], [-118.44894, 34.10975], [-118.44917, 34.10956], [-118.44924, 34.10961]]], [[[-118.45238, 34.10955], [-118.45209, 34.10955], [-118.45111, 34.10984], [-118.45114, 34.10967], [-118.45106, 34.10924], [-118.4513, 34.10912], [-118.45151, 34.10909], [-118.45166, 34.10903], [-118.4518, 34.10891], [-118.45203, 34.10886], [-118.45218, 34.10888], [-118.45233, 34.1088], [-118.45236, 34.10881], [-118.45238, 34.10955]]], [[[-118.45108, 34.10967], [-118.45104, 34.10985], [-118.45043, 34.1098], [-118.44981, 34.10944], [-118.44962, 34.10932], [-118.44968, 34.10928], [-118.44989, 34.10929], [-118.44997, 34.10928], [-118.45002, 34.10925], [-118.45005, 34.10918], [-118.45009, 34.10915], [-118.45016, 34.10916], [-118.45025, 34.10927], [-118.45033, 34.10934], [-118.45058, 34.10938], [-118.45072, 34.10937], [-118.451, 34.10927], [-118.45108, 34.10967]]], [[[-118.45241, 34.11002], [-118.45153, 34.11032], [-118.45097, 34.11041], [-118.4511, 34.10991], [-118.4521, 34.10961], [-118.45238, 34.1096], [-118.45241, 34.11002]]], [[[-118.45102, 34.10991], [-118.4509, 34.11041], [-118.45034, 34.11033], [-118.45012, 34.11033], [-118.44987, 34.11036], [-118.45003, 34.10989], [-118.45027, 34.10976], [-118.45041, 34.10985], [-118.45102, 34.10991]]], [[[-118.44879, 34.11046], [-118.4484, 34.11054], [-118.44836, 34.11051], [-118.44871, 34.11039], [-118.44879, 34.11046]]], [[[-118.45322, 34.10957], [-118.45322, 34.11055], [-118.45251, 34.11077], [-118.45245, 34.10959], [-118.45322, 34.10957]]], [[[-118.45244, 34.11076], [-118.45213, 34.11064], [-118.45115, 34.11092], [-118.45098, 34.11047], [-118.45155, 34.11037], [-118.45241, 34.11007], [-118.45244, 34.11076]]], [[[-118.45108, 34.11093], [-118.45002, 34.11122], [-118.44993, 34.11102], [-118.4495, 34.11113], [-118.44939, 34.11097], [-118.44936, 34.11097], [-118.44927, 34.11084], [-118.44921, 34.11062], [-118.44885, 34.11068], [-118.44884, 34.11062], [-118.44918, 34.11055], [-118.44913, 34.11031], [-118.44921, 34.11018], [-118.44925, 34.11019], [-118.4495, 34.10989], [-118.44945, 34.10967], [-118.4495, 34.10965], [-118.44954, 34.1096], [-118.4496, 34.10938], [-118.4502, 34.10974], [-118.44998, 34.10987], [-118.44978, 34.11043], [-118.45017, 34.11038], [-118.45044, 34.11039], [-118.4509, 34.11047], [-118.45108, 34.11093]]], [[[-118.45247, 34.11125], [-118.45222, 34.11118], [-118.45136, 34.11146], [-118.45117, 34.11096], [-118.45213, 34.1107], [-118.45244, 34.11082], [-118.45247, 34.11125]]], [[[-118.45322, 34.11149], [-118.45254, 34.11127], [-118.45251, 34.11082], [-118.45322, 34.1106], [-118.45322, 34.11149]]], [[[-118.44819, 34.11152], [-118.44785, 34.11152], [-118.44783, 34.11145], [-118.44817, 34.11145], [-118.44819, 34.11152]]], [[[-118.45129, 34.11147], [-118.45071, 34.11166], [-118.45012, 34.11211], [-118.4497, 34.11147], [-118.44966, 34.11138], [-118.4511, 34.11098], [-118.45129, 34.11147]]], [[[-118.44658, 34.11198], [-118.44617, 34.11209], [-118.44604, 34.11179], [-118.44644, 34.11167], [-118.44658, 34.11198]]], [[[-118.45323, 34.11154], [-118.45322, 34.11255], [-118.45267, 34.11255], [-118.4526, 34.11239], [-118.45259, 34.11228], [-118.45254, 34.11133], [-118.45323, 34.11154]]], [[[-118.45259, 34.11255], [-118.45099, 34.11255], [-118.45082, 34.11215], [-118.45249, 34.11174], [-118.45254, 34.1124], [-118.45259, 34.11255]]], [[[-118.45249, 34.11169], [-118.45075, 34.11211], [-118.45092, 34.11255], [-118.45023, 34.11255], [-118.45015, 34.11216], [-118.45074, 34.11172], [-118.45221, 34.11124], [-118.45231, 34.11126], [-118.45247, 34.11132], [-118.45249, 34.11169]]], [[[-118.45016, 34.11255], [-118.44983, 34.11256], [-118.4499, 34.11222], [-118.44958, 34.11197], [-118.44987, 34.11184], [-118.45008, 34.11217], [-118.45016, 34.11255]]], [[[-118.44952, 34.11287], [-118.44917, 34.11287], [-118.44912, 34.11274], [-118.44906, 34.11273], [-118.44901, 34.11261], [-118.44941, 34.11261], [-118.44952, 34.11287]]], [[[-118.44636, 34.11274], [-118.44582, 34.11289], [-118.44573, 34.11265], [-118.44599, 34.11258], [-118.446, 34.11256], [-118.44593, 34.11242], [-118.44566, 34.1125], [-118.44553, 34.11217], [-118.44607, 34.11202], [-118.44636, 34.11274]]], [[[-118.45303, 34.11363], [-118.45226, 34.11363], [-118.45186, 34.1126], [-118.45262, 34.1126], [-118.45303, 34.11363]]], [[[-118.4522, 34.11363], [-118.45143, 34.11363], [-118.45101, 34.11261], [-118.45178, 34.11261], [-118.4522, 34.11363]]], [[[-118.45136, 34.11363], [-118.45066, 34.11363], [-118.45025, 34.11261], [-118.45095, 34.11261], [-118.45136, 34.11363]]], [[[-118.45059, 34.11363], [-118.4499, 34.11363], [-118.44948, 34.11261], [-118.45018, 34.11261], [-118.45059, 34.11363]]], [[[-118.44982, 34.11363], [-118.44948, 34.11362], [-118.4494, 34.11342], [-118.44975, 34.11342], [-118.44982, 34.11363]]], [[[-118.45322, 34.11392], [-118.45288, 34.1131], [-118.45269, 34.1126], [-118.45322, 34.11261], [-118.45322, 34.11392]]], [[[-118.44859, 34.11416], [-118.44826, 34.11425], [-118.44822, 34.11412], [-118.44853, 34.11403], [-118.44859, 34.11416]]], [[[-118.45323, 34.11496], [-118.45282, 34.11495], [-118.45234, 34.11383], [-118.45272, 34.11382], [-118.45268, 34.11368], [-118.45306, 34.11368], [-118.45323, 34.11409], [-118.45323, 34.11496]]], [[[-118.45274, 34.11496], [-118.45197, 34.11496], [-118.45145, 34.11368], [-118.45222, 34.11368], [-118.45274, 34.11496]]], [[[-118.45191, 34.11496], [-118.45121, 34.11496], [-118.45078, 34.11393], [-118.45074, 34.11379], [-118.45068, 34.11368], [-118.45139, 34.11368], [-118.45191, 34.11496]]], [[[-118.45114, 34.11496], [-118.45044, 34.11496], [-118.44992, 34.11368], [-118.45062, 34.11368], [-118.45114, 34.11496]]], [[[-118.45037, 34.11496], [-118.44967, 34.11497], [-118.4492, 34.11379], [-118.44945, 34.11379], [-118.44941, 34.11368], [-118.44985, 34.11368], [-118.45037, 34.11496]]], [[[-118.44961, 34.11496], [-118.44926, 34.11496], [-118.44901, 34.11504], [-118.44897, 34.11495], [-118.44922, 34.11486], [-118.44902, 34.11437], [-118.44876, 34.11443], [-118.4487, 34.11427], [-118.44894, 34.11419], [-118.44888, 34.11403], [-118.44863, 34.11409], [-118.44855, 34.11392], [-118.4488, 34.11385], [-118.44884, 34.11393], [-118.44918, 34.11393], [-118.44961, 34.11496]]], [[[-118.44903, 34.11525], [-118.44895, 34.11525], [-118.44884, 34.11545], [-118.44858, 34.11535], [-118.44864, 34.1152], [-118.44829, 34.11516], [-118.44822, 34.115], [-118.44896, 34.11509], [-118.44903, 34.11525]]], [[[-118.44916, 34.11557], [-118.44894, 34.11549], [-118.44904, 34.11529], [-118.44904, 34.11529], [-118.44916, 34.11557]]], [[[-118.44999, 34.11592], [-118.44962, 34.11574], [-118.44924, 34.1156], [-118.44904, 34.11509], [-118.44927, 34.11502], [-118.44963, 34.11502], [-118.44974, 34.11529], [-118.4494, 34.11529], [-118.44939, 34.11531], [-118.44942, 34.11536], [-118.44977, 34.11536], [-118.44999, 34.11592]]], [[[-118.45318, 34.11603], [-118.45241, 34.11603], [-118.452, 34.11502], [-118.45276, 34.11501], [-118.45318, 34.11603]]], [[[-118.45235, 34.11603], [-118.45164, 34.11603], [-118.45124, 34.11502], [-118.45193, 34.11501], [-118.45235, 34.11603]]], [[[-118.45158, 34.11602], [-118.45087, 34.11602], [-118.45047, 34.11502], [-118.45116, 34.11501], [-118.45158, 34.11602]]], [[[-118.45081, 34.11602], [-118.45021, 34.11602], [-118.45008, 34.11596], [-118.44987, 34.11543], [-118.4502, 34.11543], [-118.45019, 34.11536], [-118.44984, 34.11536], [-118.4497, 34.11502], [-118.45039, 34.11502], [-118.45081, 34.11602]]], [[[-118.44821, 34.11627], [-118.44801, 34.11633], [-118.44793, 34.11613], [-118.44813, 34.11608], [-118.44821, 34.11627]]], [[[-118.44956, 34.11654], [-118.44947, 34.11652], [-118.44935, 34.11619], [-118.44905, 34.11611], [-118.44904, 34.11612], [-118.44916, 34.11643], [-118.44877, 34.11632], [-118.44839, 34.11541], [-118.44888, 34.11559], [-118.44902, 34.11591], [-118.44895, 34.11589], [-118.44897, 34.11597], [-118.44939, 34.11612], [-118.44956, 34.11654]]], [[[-118.4485, 34.11652], [-118.44839, 34.1165], [-118.44811, 34.11657], [-118.44803, 34.11638], [-118.4484, 34.11628], [-118.4485, 34.11652]]], [[[-118.45261, 34.11668], [-118.45198, 34.11685], [-118.45167, 34.11609], [-118.45237, 34.11609], [-118.45261, 34.11668]]], [[[-118.44812, 34.11679], [-118.44801, 34.11681], [-118.44792, 34.11658], [-118.44804, 34.11659], [-118.44812, 34.11679]]], [[[-118.45192, 34.11687], [-118.45129, 34.11705], [-118.4509, 34.11608], [-118.4516, 34.11609], [-118.45192, 34.11687]]], [[[-118.45123, 34.11707], [-118.45064, 34.11723], [-118.45052, 34.11694], [-118.4508, 34.11686], [-118.45074, 34.11671], [-118.4507, 34.11664], [-118.45043, 34.11672], [-118.45017, 34.11608], [-118.45083, 34.11608], [-118.45123, 34.11707]]], [[[-118.44868, 34.11712], [-118.44837, 34.11721], [-118.44834, 34.11715], [-118.44865, 34.11706], [-118.44868, 34.11712]]], [[[-118.45037, 34.1169], [-118.45009, 34.11698], [-118.45023, 34.11734], [-118.44999, 34.11741], [-118.44966, 34.11663], [-118.44996, 34.1167], [-118.44997, 34.11669], [-118.44994, 34.11665], [-118.44964, 34.11656], [-118.4493, 34.11575], [-118.44962, 34.11587], [-118.44982, 34.11632], [-118.4501, 34.11624], [-118.45037, 34.1169]]], [[[-118.44992, 34.11743], [-118.4493, 34.1176], [-118.4488, 34.11638], [-118.44958, 34.1166], [-118.44992, 34.11743]]], [[[-118.44913, 34.11736], [-118.44883, 34.11744], [-118.44884, 34.11751], [-118.44853, 34.1176], [-118.4485, 34.11754], [-118.44881, 34.11745], [-118.44878, 34.11738], [-118.4491, 34.1173], [-118.44913, 34.11736]]], [[[-118.45298, 34.11758], [-118.45236, 34.11775], [-118.45201, 34.1169], [-118.45263, 34.11673], [-118.45298, 34.11758]]], [[[-118.45223, 34.11764], [-118.45193, 34.11772], [-118.45198, 34.11786], [-118.45167, 34.11794], [-118.45132, 34.1171], [-118.45194, 34.11692], [-118.45223, 34.11764]]], [[[-118.44854, 34.11782], [-118.44823, 34.1179], [-118.44818, 34.11777], [-118.44848, 34.11769], [-118.44854, 34.11782]]], [[[-118.4516, 34.11796], [-118.45129, 34.11805], [-118.45121, 34.11786], [-118.45093, 34.11794], [-118.45078, 34.11758], [-118.45106, 34.11749], [-118.45094, 34.11721], [-118.45125, 34.11712], [-118.4516, 34.11796]]], [[[-118.45088, 34.11816], [-118.45035, 34.11831], [-118.45001, 34.11747], [-118.45026, 34.11739], [-118.45029, 34.11746], [-118.45056, 34.11739], [-118.45088, 34.11816]]], [[[-118.45028, 34.11833], [-118.44966, 34.1185], [-118.44932, 34.11766], [-118.44994, 34.11748], [-118.45028, 34.11833]]], [[[-118.45321, 34.11815], [-118.4529, 34.11824], [-118.45301, 34.1185], [-118.4527, 34.11858], [-118.45238, 34.1178], [-118.453, 34.11763], [-118.45321, 34.11815]]], [[[-118.4496, 34.11852], [-118.44929, 34.1186], [-118.44923, 34.11848], [-118.44892, 34.11856], [-118.44869, 34.11798], [-118.44931, 34.1178], [-118.44944, 34.11813], [-118.4496, 34.11852]]], [[[-118.44883, 34.11852], [-118.44852, 34.1186], [-118.44847, 34.11848], [-118.44878, 34.11839], [-118.44883, 34.11852]]], [[[-118.45184, 34.11854], [-118.45123, 34.11869], [-118.45103, 34.11818], [-118.45162, 34.11802], [-118.45184, 34.11854]]], [[[-118.45265, 34.11866], [-118.45203, 34.11884], [-118.45169, 34.118], [-118.45231, 34.11782], [-118.45265, 34.11866]]], [[[-118.44891, 34.11871], [-118.4486, 34.1188], [-118.44855, 34.11867], [-118.44886, 34.11858], [-118.44891, 34.11871]]], [[[-118.45196, 34.11886], [-118.45137, 34.11902], [-118.45127, 34.11876], [-118.45186, 34.1186], [-118.45196, 34.11886]]], [[[-118.45313, 34.11981], [-118.45242, 34.11981], [-118.45205, 34.1189], [-118.45268, 34.11872], [-118.45313, 34.11981]]], [[[-118.45236, 34.11981], [-118.4517, 34.11981], [-118.45139, 34.11908], [-118.45199, 34.11892], [-118.45226, 34.11956], [-118.45195, 34.11964], [-118.45197, 34.11972], [-118.45201, 34.11978], [-118.45231, 34.1197], [-118.45236, 34.11981]]], [[[-118.45147, 34.1196], [-118.45119, 34.11967], [-118.45124, 34.11981], [-118.45096, 34.1198], [-118.45085, 34.11953], [-118.45037, 34.11837], [-118.45062, 34.11829], [-118.45068, 34.11843], [-118.45096, 34.11836], [-118.45119, 34.11894], [-118.45092, 34.11902], [-118.45101, 34.11924], [-118.45104, 34.11931], [-118.45132, 34.11924], [-118.45147, 34.1196]]], [[[-118.45089, 34.1198], [-118.45019, 34.1198], [-118.44972, 34.11862], [-118.45002, 34.11853], [-118.44999, 34.11847], [-118.45031, 34.11838], [-118.45089, 34.1198]]], [[[-118.45013, 34.1198], [-118.44943, 34.11979], [-118.44936, 34.11966], [-118.44899, 34.11874], [-118.4493, 34.11866], [-118.44937, 34.11879], [-118.44967, 34.1187], [-118.44975, 34.1189], [-118.44945, 34.11898], [-118.44944, 34.11899], [-118.4495, 34.11911], [-118.44981, 34.11903], [-118.45013, 34.1198]]], [[[-118.44936, 34.11979], [-118.44901, 34.1198], [-118.44891, 34.11957], [-118.44861, 34.11966], [-118.44857, 34.11959], [-118.44888, 34.1195], [-118.44885, 34.11944], [-118.44855, 34.11952], [-118.44849, 34.1194], [-118.44841, 34.1192], [-118.44872, 34.11911], [-118.44862, 34.11886], [-118.44894, 34.11876], [-118.44936, 34.11979]]], [[[-118.46342, 34.12677], [-118.46342, 34.12736], [-118.46304, 34.12725], [-118.46325, 34.12684], [-118.46342, 34.12677]]], [[[-118.46323, 34.12068], [-118.46278, 34.12168], [-118.46185, 34.12279], [-118.46181, 34.12377], [-118.46161, 34.12422], [-118.46162, 34.12484], [-118.46102, 34.12512], [-118.46079, 34.12568], [-118.46088, 34.12641], [-118.46173, 34.12648], [-118.46248, 34.12709], [-118.46263, 34.12713], [-118.46262, 34.12718], [-118.46254, 34.12731], [-118.46251, 34.1274], [-118.46252, 34.12752], [-118.46257, 34.12763], [-118.46257, 34.12775], [-118.46254, 34.12784], [-118.46246, 34.12794], [-118.4624, 34.128], [-118.46228, 34.12805], [-118.46225, 34.128], [-118.4622, 34.12802], [-118.46209, 34.12803], [-118.46153, 34.12797], [-118.46123, 34.12799], [-118.46089, 34.12808], [-118.46075, 34.1281], [-118.46056, 34.12808], [-118.46024, 34.12799], [-118.46016, 34.12799], [-118.46004, 34.12804], [-118.45999, 34.12808], [-118.45995, 34.12814], [-118.45994, 34.12827], [-118.46, 34.12849], [-118.46013, 34.12873], [-118.46014, 34.12908], [-118.46007, 34.12913], [-118.45996, 34.12915], [-118.4597, 34.12919], [-118.45938, 34.12921], [-118.45928, 34.12924], [-118.45916, 34.12931], [-118.4591, 34.12939], [-118.45906, 34.12946], [-118.45905, 34.12957], [-118.4591, 34.12969], [-118.45956, 34.1302], [-118.45272, 34.12991], [-118.44861, 34.11985], [-118.45329, 34.11987], [-118.45329, 34.11982], [-118.45319, 34.11982], [-118.45274, 34.1187], [-118.45329, 34.11855], [-118.4533, 34.11818], [-118.4527, 34.11672], [-118.45328, 34.11655], [-118.45329, 34.1165], [-118.45328, 34.1165], [-118.45267, 34.11666], [-118.45244, 34.11609], [-118.45328, 34.11609], [-118.45329, 34.11608], [-118.45329, 34.11605], [-118.45326, 34.11604], [-118.45315, 34.11578], [-118.45284, 34.11502], [-118.4533, 34.115], [-118.45329, 34.10835], [-118.45311, 34.10834], [-118.4531, 34.1082], [-118.45312, 34.10795], [-118.45326, 34.10771], [-118.45328, 34.10757], [-118.45324, 34.10733], [-118.45322, 34.10727], [-118.45314, 34.10717], [-118.45301, 34.10707], [-118.45323, 34.10689], [-118.45329, 34.10679], [-118.45329, 34.10535], [-118.45216, 34.10532], [-118.44947, 34.10531], [-118.44946, 34.10527], [-118.44967, 34.10504], [-118.45015, 34.10498], [-118.45066, 34.10477], [-118.45118, 34.10462], [-118.45143, 34.10446], [-118.45168, 34.10394], [-118.45332, 34.10349], [-118.45467, 34.10349], [-118.45455, 34.10391], [-118.45455, 34.10396], [-118.45464, 34.10415], [-118.45475, 34.10427], [-118.4549, 34.10434], [-118.45538, 34.10441], [-118.45581, 34.10456], [-118.4562, 34.10478], [-118.45672, 34.10518], [-118.45683, 34.10523], [-118.45701, 34.10528], [-118.4576, 34.10528], [-118.45815, 34.10533], [-118.45829, 34.1053], [-118.45843, 34.10525], [-118.45849, 34.1052], [-118.45852, 34.10538], [-118.45992, 34.10539], [-118.46141, 34.11072], [-118.4616, 34.11147], [-118.46219, 34.11217], [-118.46136, 34.11278], [-118.46138, 34.11346], [-118.46249, 34.11468], [-118.46282, 34.11568], [-118.46222, 34.11624], [-118.4626, 34.11722], [-118.46292, 34.11798], [-118.46301, 34.11943], [-118.46323, 34.12068]]]]} | No Public Access 3 | 6392 | Stone Canyon Reservoir & Watershed | 25864 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | Los Angeles 6 | 746.516 | Stone Canyon Reservoir & Watershed | 0 | Local Resource Management Area 83 | 3 |
1645 | 1645 | 1644 | {"type": "Polygon", "coordinates": [[[-121.27757, 37.98952], [-121.27753, 37.98957], [-121.27653, 37.98983], [-121.2759, 37.98828], [-121.27639, 37.98797], [-121.27641, 37.98792], [-121.27642, 37.98777], [-121.27646, 37.98766], [-121.2765, 37.9876], [-121.2766, 37.98751], [-121.27663, 37.98751], [-121.27678, 37.98768], [-121.2769, 37.98789], [-121.27757, 37.98952]]]} | Open Access 1 | 47779 | Shady Forest | 31579 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 4.969 | Shady Forest | 0 | Local Resource Management Area 83 | 3 | |
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 | |
12311 | 12311 | 12310 | {"type": "Polygon", "coordinates": [[[-124.06293, 40.8633], [-124.06168, 40.86382], [-124.06167, 40.86462], [-124.05849, 40.86458], [-124.05808, 40.86461], [-124.05816, 40.86823], [-124.05666, 40.86826], [-124.05695, 40.86793], [-124.056, 40.86703], [-124.05661, 40.86662], [-124.05655, 40.86628], [-124.05593, 40.86594], [-124.05562, 40.86552], [-124.05559, 40.8648], [-124.05405, 40.86469], [-124.05273, 40.86514], [-124.05237, 40.86543], [-124.05212, 40.86571], [-124.05251, 40.86676], [-124.05205, 40.86678], [-124.05186, 40.86676], [-124.05124, 40.86658], [-124.0522, 40.8645], [-124.05184, 40.86447], [-124.05103, 40.86453], [-124.05046, 40.86427], [-124.05034, 40.86406], [-124.04936, 40.86388], [-124.04936, 40.86398], [-124.04909, 40.86398], [-124.04906, 40.86381], [-124.0482, 40.86377], [-124.04815, 40.86218], [-124.04621, 40.86218], [-124.0462, 40.86111], [-124.04623, 40.8611], [-124.04619, 40.86003], [-124.04329, 40.86005], [-124.04329, 40.85365], [-124.04388, 40.85362], [-124.04389, 40.85358], [-124.05275, 40.85358], [-124.05275, 40.85386], [-124.05268, 40.85387], [-124.05261, 40.8544], [-124.05296, 40.85444], [-124.05292, 40.85476], [-124.05565, 40.855], [-124.05558, 40.8563], [-124.05483, 40.85629], [-124.0548, 40.8571], [-124.05575, 40.85701], [-124.05572, 40.85733], [-124.05572, 40.85752], [-124.0561, 40.85751], [-124.05611, 40.85765], [-124.05672, 40.85764], [-124.05673, 40.85781], [-124.05783, 40.8578], [-124.05794, 40.86208], [-124.06258, 40.86195], [-124.06259, 40.86217], [-124.06228, 40.8623], [-124.06293, 40.8633]]]} | Open Access 1 | 46883 | Sunny Brae Forest | 30365 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/190/City-Forests | Humboldt 45 | 342.381 | Sunny Brae Forest | 0 | Local Resource Management Area 83 | 3 |
13180 | 13180 | 13179 | {"type": "Polygon", "coordinates": [[[-124.07492, 40.87037], [-124.07461, 40.87119], [-124.07397, 40.87105], [-124.0737, 40.87112], [-124.07367, 40.87137], [-124.07234, 40.87141], [-124.07235, 40.8723], [-124.07129, 40.87238], [-124.07056, 40.87281], [-124.0682, 40.87301], [-124.06744, 40.87317], [-124.06677, 40.87295], [-124.06378, 40.87317], [-124.06381, 40.87372], [-124.06444, 40.87406], [-124.06534, 40.87462], [-124.06537, 40.87559], [-124.06714, 40.87566], [-124.06821, 40.87656], [-124.06822, 40.87759], [-124.0653, 40.87896], [-124.06241, 40.87839], [-124.06239, 40.8784], [-124.0624, 40.87901], [-124.06237, 40.88], [-124.06555, 40.88184], [-124.06606, 40.88233], [-124.06712, 40.88074], [-124.06768, 40.8814], [-124.06846, 40.88182], [-124.06902, 40.88199], [-124.07094, 40.88148], [-124.07235, 40.88141], [-124.0722, 40.88199], [-124.07224, 40.88215], [-124.07251, 40.88258], [-124.07253, 40.88301], [-124.07212, 40.88302], [-124.0721, 40.88305], [-124.06825, 40.883], [-124.06812, 40.88314], [-124.06791, 40.88307], [-124.06779, 40.88306], [-124.06763, 40.88299], [-124.06229, 40.88293], [-124.0575, 40.88284], [-124.05761, 40.87934], [-124.0432, 40.87927], [-124.04326, 40.8719], [-124.04336, 40.86838], [-124.04635, 40.86837], [-124.05141, 40.86833], [-124.05143, 40.86674], [-124.0518, 40.86688], [-124.05202, 40.86692], [-124.0521, 40.86691], [-124.05214, 40.86695], [-124.05213, 40.86832], [-124.05283, 40.86832], [-124.05285, 40.87227], [-124.05337, 40.87223], [-124.06248, 40.87221], [-124.06249, 40.87019], [-124.06309, 40.86987], [-124.06369, 40.86962], [-124.06409, 40.86941], [-124.06445, 40.86926], [-124.06465, 40.86922], [-124.06486, 40.86915], [-124.06589, 40.86866], [-124.06606, 40.86862], [-124.06629, 40.86862], [-124.06665, 40.86874], [-124.0669, 40.86879], [-124.06714, 40.86879], [-124.06781, 40.86875], [-124.06879, 40.86889], [-124.06915, 40.8689], [-124.06946, 40.86887], [-124.06977, 40.8688], [-124.0709, 40.86834], [-124.07478, 40.86835], [-124.07413, 40.87001], [-124.0745, 40.87028], [-124.07492, 40.87037]]]} | Open Access 1 | 35163 | Arcata Community Forest | 295 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/departments/environmental-services/city-forests/trail-map | Humboldt 45 | 635.854 | Arcata Community Forest | 0 | Local Resource Management Area 83 | 3 |
14362 | 14362 | 14361 | {"type": "MultiPolygon", "coordinates": [[[[-123.96881, 40.76594], [-123.96843, 40.77321], [-123.96403, 40.77343], [-123.96412, 40.76959], [-123.95934, 40.76956], [-123.95942, 40.76594], [-123.96881, 40.76594]]], [[[-124.02575, 40.80099], [-124.0257, 40.80435], [-124.0238, 40.80431], [-124.02377, 40.80399], [-124.02352, 40.8035], [-124.01846, 40.80341], [-124.01846, 40.80343], [-124.01876, 40.8037], [-124.02005, 40.80424], [-124.01847, 40.8042], [-124.01839, 40.80273], [-124.01563, 40.8027], [-124.01563, 40.79911], [-124.01105, 40.79908], [-124.01102, 40.7955], [-124.00601, 40.79549], [-124.006, 40.7955], [-124.00618, 40.80264], [-124.00165, 40.80259], [-124.00144, 40.79549], [-123.99235, 40.79551], [-123.99251, 40.79172], [-123.98774, 40.79175], [-123.98815, 40.78049], [-123.96805, 40.78043], [-123.96824, 40.77693], [-123.9731, 40.77694], [-123.97319, 40.77324], [-123.98792, 40.77331], [-123.98804, 40.777], [-123.99277, 40.777], [-123.99283, 40.78058], [-124.00117, 40.78074], [-124.00195, 40.78074], [-124.00191, 40.78596], [-124.00542, 40.78861], [-124.00615, 40.78861], [-124.00608, 40.79181], [-124.00847, 40.79184], [-124.01352, 40.79551], [-124.01594, 40.79552], [-124.01841, 40.79731], [-124.01843, 40.79731], [-124.01843, 40.79552], [-124.02091, 40.79553], [-124.02089, 40.79914], [-124.02336, 40.79915], [-124.02336, 40.80097], [-124.02575, 40.80099]]]]} | Open Access 1 | 47021 | Jacoby Creek Forest | 30669 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1249.576 | Jacoby Creek Forest | 0 | Local Resource Management Area 83 | 3 |
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]);