units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
351 rows where MNG_AGENCY = 27 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, GAP_STS
DES_TP >30
AGNCY_ID 19 ✖
ACCESS_TYP 4
- Open Access 191
- Unknown Access 149
- No Public Access 9
- Restricted Access 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 351 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309 | 309 | 308 | {"type": "MultiPolygon", "coordinates": [[[[-118.61084, 34.27479], [-118.61063, 34.27477], [-118.6103, 34.2747], [-118.61002, 34.27455], [-118.60985, 34.27432], [-118.60969, 34.27388], [-118.60882, 34.27411], [-118.60768, 34.27363], [-118.60854, 34.27246], [-118.61002, 34.27238], [-118.61055, 34.2723], [-118.61121, 34.27215], [-118.61124, 34.27217], [-118.6114, 34.27269], [-118.61141, 34.27284], [-118.6114, 34.27299], [-118.61132, 34.2732], [-118.61092, 34.27389], [-118.61081, 34.27412], [-118.61077, 34.27429], [-118.61077, 34.27446], [-118.61079, 34.27463], [-118.61084, 34.27479]]], [[[-118.61416, 34.27267], [-118.61344, 34.27333], [-118.61346, 34.27364], [-118.61289, 34.27408], [-118.61233, 34.27387], [-118.61196, 34.27395], [-118.61208, 34.27432], [-118.61183, 34.27461], [-118.61168, 34.27461], [-118.61157, 34.2747], [-118.61155, 34.27488], [-118.61138, 34.27494], [-118.61124, 34.27489], [-118.61114, 34.27493], [-118.61105, 34.27475], [-118.611, 34.27459], [-118.61098, 34.27435], [-118.61101, 34.27419], [-118.61111, 34.27396], [-118.61152, 34.27327], [-118.61158, 34.2731], [-118.61162, 34.27293], [-118.61161, 34.27269], [-118.61144, 34.27212], [-118.61146, 34.27209], [-118.61246, 34.27186], [-118.61282, 34.27184], [-118.61306, 34.27186], [-118.61321, 34.27194], [-118.61333, 34.27204], [-118.61343, 34.27216], [-118.61358, 34.27242], [-118.61368, 34.27252], [-118.61379, 34.27259], [-118.61393, 34.27264], [-118.61416, 34.27267]]]]} | Open Access 1 | 826 | Garden of the Gods | 29624 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 27.234 | Garden of the Gods | None 32 | |||
653 | 653 | 652 | {"type": "Polygon", "coordinates": [[[-118.76961, 34.09844], [-118.76746, 34.09841], [-118.76746, 34.09748], [-118.76959, 34.09752], [-118.76961, 34.09844]]]} | Open Access 1 | 5014 | Malibu Creek State Park - Randa House | 29629 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.parks.ca.gov/?page_id=614 | Los Angeles 6 | 5.064 | Malibu Creek SP - Randa House | None 62 | ||
806 | 806 | 805 | {"type": "Polygon", "coordinates": [[[-118.36891, 33.73931], [-118.36872, 33.73989], [-118.36801, 33.74037], [-118.3676, 33.74059], [-118.36705, 33.7408], [-118.36659, 33.74091], [-118.36593, 33.741], [-118.36518, 33.74102], [-118.36184, 33.74064], [-118.36135, 33.74054], [-118.36085, 33.74039], [-118.36043, 33.74023], [-118.35991, 33.74], [-118.36013, 33.7397], [-118.36194, 33.73906], [-118.36225, 33.73793], [-118.36307, 33.73841], [-118.36421, 33.7389], [-118.36458, 33.73893], [-118.36486, 33.73874], [-118.36576, 33.73874], [-118.36599, 33.73867], [-118.36603, 33.73842], [-118.36669, 33.73848], [-118.36759, 33.73837], [-118.36825, 33.73811], [-118.3684, 33.7379], [-118.36858, 33.73667], [-118.36844, 33.73652], [-118.36862, 33.73606], [-118.36885, 33.7361], [-118.36869, 33.73753], [-118.36863, 33.73839], [-118.36868, 33.73907], [-118.36891, 33.73931]]]} | Restricted Access 2 | 5870 | Abalone Cove Shoreline Archery Range | 29497 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 45.317 | Abalone Cove Shoreline Archery Range | None 73 | |||
1047 | 1047 | 1046 | {"type": "MultiPolygon", "coordinates": [[[[-118.52781, 34.12892], [-118.52765, 34.12897], [-118.52752, 34.12899], [-118.52699, 34.12889], [-118.5269, 34.12887], [-118.52682, 34.12882], [-118.52674, 34.12872], [-118.52724, 34.12879], [-118.52781, 34.12892]]], [[[-118.52963, 34.12976], [-118.52948, 34.12986], [-118.5294, 34.12995], [-118.52935, 34.12974], [-118.52925, 34.12956], [-118.52963, 34.12976]]]]} | Open Access 1 | 6364 | Dirt Mulholland | 18160 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.435 | Dirt Mulholland | None 95 | |||
1273 | 1273 | 1272 | {"type": "Polygon", "coordinates": [[[-118.21161, 34.50894], [-118.21051, 34.50893], [-118.21051, 34.50802], [-118.2116, 34.50803], [-118.21161, 34.50894]]]} | Unknown Access 4 | 9563 | Red Rover Mine TaxDef | 24228 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.509 | Red Rover Mine TaxDef | None 110 | |||
2511 | 2511 | 2510 | {"type": "Polygon", "coordinates": [[[-118.51605, 34.05992], [-118.51605, 34.05992], [-118.51557, 34.05983], [-118.51602, 34.0595], [-118.51598, 34.0597], [-118.516, 34.05981], [-118.51605, 34.05992]]]} | Open Access 1 | 6356 | Topanga State Park | 26410 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.parks.ca.gov/?page_id=629 | Los Angeles 6 | 0.22 | Topanga SP | 1967 | None 206 | |
2757 | 2757 | 2756 | {"type": "MultiPolygon", "coordinates": [[[[-118.59473, 34.28578], [-118.59293, 34.28578], [-118.59293, 34.285], [-118.59312, 34.285], [-118.59312, 34.28575], [-118.59473, 34.28575], [-118.59473, 34.28578]]], [[[-118.59361, 34.28526], [-118.59361, 34.28556], [-118.59351, 34.28556], [-118.59352, 34.28526], [-118.59361, 34.28526]]], [[[-118.59668, 34.28578], [-118.59486, 34.28578], [-118.59486, 34.28575], [-118.59668, 34.28575], [-118.59668, 34.28578]]], [[[-118.60597, 34.28577], [-118.60597, 34.28579], [-118.59688, 34.28578], [-118.59688, 34.28575], [-118.60597, 34.28577]]], [[[-118.60374, 34.28244], [-118.60374, 34.28248], [-118.60327, 34.28222], [-118.59971, 34.28221], [-118.59971, 34.28218], [-118.60328, 34.28219], [-118.60374, 34.28244]]], [[[-118.60598, 34.2846], [-118.6054, 34.2846], [-118.60471, 34.2841], [-118.60429, 34.28329], [-118.6043, 34.28325], [-118.60474, 34.28409], [-118.60541, 34.28457], [-118.60598, 34.28457], [-118.60598, 34.2846]]]]} | Open Access 1 | 18451 | Deer Lake Highlands | 17998 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.806 | Deer Lake Highlands | None 231 | |||
3955 | 3955 | 3954 | {"type": "Polygon", "coordinates": [[[-118.26969, 34.25985], [-118.2653, 34.25981], [-118.26529, 34.25816], [-118.26968, 34.25821], [-118.26969, 34.25985]]]} | Unknown Access 4 | 46417 | Haines Canyon | 29694 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.279 | Haines Canyon | None 341 | |||
4309 | 4309 | 4308 | {"type": "Polygon", "coordinates": [[[-118.6329, 34.27478], [-118.63179, 34.27479], [-118.63171, 34.27158], [-118.63223, 34.2712], [-118.63279, 34.2712], [-118.6329, 34.27478]]]} | Unknown Access 4 | 10272 | Rocky Peak Adj. Tax Default | 24544 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.687 | Rocky Peak Adj. Tax Default | None 381 | |||
4961 | 4961 | 4960 | {"type": "Polygon", "coordinates": [[[-118.54326, 34.04416], [-118.54305, 34.04417], [-118.54302, 34.0442], [-118.54286, 34.04405], [-118.54306, 34.04392], [-118.54313, 34.04389], [-118.54316, 34.04389], [-118.54323, 34.04403], [-118.54326, 34.04416]]]} | Unknown Access 4 | 3659 | Las Casas - Grenola | 21045 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.186 | Las Casas - Grenola | None 411 | |||
4975 | 4975 | 4974 | {"type": "Polygon", "coordinates": [[[-118.77646, 34.04802], [-118.77625, 34.04824], [-118.77619, 34.04837], [-118.77564, 34.04817], [-118.77587, 34.04802], [-118.77593, 34.04779], [-118.77646, 34.04802]]]} | Open Access 1 | 3757 | Latigo Canyon - Malibu Vista | 21080 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.581 | Latigo Canyon - Malibu Vista | 0 | None 413 | ||
5327 | 5327 | 5326 | {"type": "Polygon", "coordinates": [[[-118.54192, 34.34956], [-118.5414, 34.34944], [-118.54058, 34.34899], [-118.54043, 34.34858], [-118.53937, 34.348], [-118.54132, 34.348], [-118.5413, 34.34712], [-118.54183, 34.34712], [-118.54192, 34.34956]]]} | Unknown Access 4 | 5651 | Newhall Pass | 22727 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 6.619 | Newhall Pass | None 432 | |||
5330 | 5330 | 5329 | {"type": "Polygon", "coordinates": [[[-118.47762, 34.09991], [-118.47747, 34.10067], [-118.47689, 34.10095], [-118.47684, 34.10122], [-118.47701, 34.1017], [-118.47684, 34.10246], [-118.47688, 34.10265], [-118.47666, 34.10348], [-118.477, 34.10441], [-118.47616, 34.10495], [-118.47613, 34.10528], [-118.47733, 34.10601], [-118.47549, 34.10626], [-118.47494, 34.10574], [-118.47379, 34.1056], [-118.47368, 34.10581], [-118.47402, 34.10666], [-118.47385, 34.10673], [-118.47279, 34.10748], [-118.47253, 34.10709], [-118.47204, 34.10731], [-118.47172, 34.10689], [-118.47238, 34.10641], [-118.47217, 34.10538], [-118.47211, 34.10405], [-118.47097, 34.10235], [-118.47209, 34.10217], [-118.47193, 34.10122], [-118.47302, 34.101], [-118.47295, 34.10048], [-118.4716, 34.10007], [-118.47223, 34.09935], [-118.47174, 34.09863], [-118.47209, 34.09808], [-118.4715, 34.09792], [-118.47115, 34.09786], [-118.47103, 34.09779], [-118.47074, 34.09701], [-118.47072, 34.09663], [-118.47081, 34.09601], [-118.47031, 34.09575], [-118.47027, 34.09545], [-118.47029, 34.09527], [-118.4707, 34.09481], [-118.47027, 34.09457], [-118.46987, 34.09419], [-118.46975, 34.09362], [-118.46964, 34.09339], [-118.47033, 34.09297], [-118.47033, 34.09278], [-118.47, 34.09266], [-118.47, 34.09256], [-118.47021, 34.09235], [-118.47032, 34.09228], [-118.46992, 34.09183], [-118.46991, 34.09149], [-118.47112, 34.0906], [-118.47066, 34.09026], [-118.4705, 34.08965], [-118.47072, 34.08939], [-118.47155, 34.08927], [-118.47142, 34.08885], [-118.47219, 34.08909], [-118.4726, 34.08888], [-118.47269, 34.08929], [-118.47224, 34.09004], [-118.47283, 34.09141], [-118.47213, 34.09246], [-118.47321, 34.09396], [-118.47505, 34.09455], [-118.47492, 34.09491], [-118.47492, 34.09493], [-118.47489, 34.09498], [-118.47484, 34.09523], [-118.47485, 34.09542], [-118.47487, 34.09555], [-118.47492, 34.09569], [-118.47503, 34.0959], [-118.47514, 34.09604], [-118.47524, 34.09614], [-118.47535, 34.09623], [-118.47556, 34.09635], [-118.47571, 34.09641], [-118.47626, 34.09652], [-118.47652, 34.09686], [-118.47646, 34.09904], [-118.4772, 34.09949], [-118.47762, 34.09991]]]} | Open Access 1 | 6369 | Getty View Park & Trailhead | 29690 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 180.159 | Getty View Park & Trailhead | None 433 | |||
5467 | 5467 | 5466 | {"type": "MultiPolygon", "coordinates": [[[[-118.7371, 34.14821], [-118.73682, 34.14836], [-118.73634, 34.14855], [-118.73616, 34.14852], [-118.7357, 34.14837], [-118.73563, 34.14838], [-118.73559, 34.14843], [-118.73535, 34.14835], [-118.73448, 34.14736], [-118.73436, 34.14742], [-118.73395, 34.14693], [-118.73209, 34.14661], [-118.73173, 34.14543], [-118.73148, 34.14471], [-118.732, 34.14462], [-118.732, 34.14451], [-118.7311, 34.14255], [-118.73163, 34.14128], [-118.73169, 34.14123], [-118.73269, 34.14103], [-118.73382, 34.14184], [-118.73449, 34.14223], [-118.73474, 34.14262], [-118.73549, 34.14331], [-118.73632, 34.14342], [-118.73708, 34.14358], [-118.7371, 34.14821]]], [[[-118.7371, 34.1484], [-118.73693, 34.14849], [-118.73677, 34.14854], [-118.73661, 34.14857], [-118.73645, 34.14858], [-118.73677, 34.14846], [-118.7371, 34.14828], [-118.7371, 34.1484]]]]} | Open Access 1 | 48526 | Fran Pavley Meadow | 33240 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | https://mrca.ca.gov/parks/park-listing/fran-pavley-meadow/ | Los Angeles 6 | 72.315 | Fran Pavley Meadow | 2016 | None 441 | |
5471 | 5471 | 5470 | {"type": "Polygon", "coordinates": [[[-118.81077, 34.11086], [-118.80637, 34.11085], [-118.80651, 34.10737], [-118.81077, 34.10736], [-118.81077, 34.11086]]]} | Open Access 1 | 48527 | Ballard Mountain | 33241 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 38.205 | Ballard Mtn. | 2017 | None 442 | ||
6005 | 6005 | 6004 | {"type": "Polygon", "coordinates": [[[-118.87495, 34.0908], [-118.87495, 34.09139], [-118.87424, 34.09139], [-118.87424, 34.0908], [-118.87495, 34.0908]]]} | Open Access 1 | 657 | Freeman Donation | 19090 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.05 | Freeman Donation | None 484 | |||
6575 | 6575 | 6574 | {"type": "Polygon", "coordinates": [[[-118.87967, 34.10374], [-118.87858, 34.10373], [-118.87858, 34.10003], [-118.87967, 34.10005], [-118.87967, 34.10374]]]} | Open Access 1 | 3862 | Lebow | 21127 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.165 | Lebow | None 528 | |||
6628 | 6628 | 6627 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.6126, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | 4323 | Llano | 21388 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.253 | Llano | None 535 | |||
6649 | 6649 | 6648 | {"type": "MultiPolygon", "coordinates": [[[[-118.29844, 34.44508], [-118.29404, 34.44509], [-118.29401, 34.44186], [-118.29504, 34.44221], [-118.2953, 34.44234], [-118.29557, 34.44244], [-118.2959, 34.44251], [-118.29627, 34.44254], [-118.29669, 34.44251], [-118.29719, 34.44244], [-118.29749, 34.44236], [-118.29796, 34.44218], [-118.29818, 34.44207], [-118.2984, 34.44193], [-118.29841, 34.44299], [-118.29831, 34.4431], [-118.29828, 34.44322], [-118.2983, 34.44331], [-118.29842, 34.44357], [-118.29842, 34.44367], [-118.29836, 34.44368], [-118.29816, 34.44362], [-118.29804, 34.44363], [-118.29796, 34.44367], [-118.29791, 34.44371], [-118.29788, 34.44377], [-118.29786, 34.44384], [-118.29788, 34.4444], [-118.29792, 34.44455], [-118.29799, 34.44466], [-118.29827, 34.44495], [-118.29835, 34.445], [-118.29844, 34.44502], [-118.29844, 34.44508]]], [[[-118.29807, 34.44144], [-118.29789, 34.44157], [-118.29769, 34.44168], [-118.29739, 34.44177], [-118.29685, 34.44187], [-118.29629, 34.4419], [-118.29592, 34.44188], [-118.29555, 34.44183], [-118.29557, 34.44176], [-118.29537, 34.44172], [-118.29486, 34.44142], [-118.29807, 34.44144]]], [[[-118.29843, 34.44485], [-118.29815, 34.44456], [-118.29809, 34.44445], [-118.29806, 34.44383], [-118.29808, 34.4438], [-118.29811, 34.44378], [-118.29815, 34.44378], [-118.29831, 34.44384], [-118.29842, 34.44384], [-118.29843, 34.44485]]]]} | Unknown Access 4 | 4665 | Long-Nellus Canyon | 21446 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 32.557 | Long-Nellus Canyon | None 538 | |||
6704 | 6704 | 6703 | {"type": "Polygon", "coordinates": [[[-118.73648, 34.07426], [-118.73436, 34.0741], [-118.73435, 34.07234], [-118.73648, 34.07246], [-118.73648, 34.07426]]]} | Open Access 1 | 5002 | Malibu Bowl | 21702 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.556 | Malibu Bowl | None 543 |
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]);