units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
86 rows where MNG_AGENCY = 73 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 6
- State Resource Management Area 61
- State Park 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
- State Agency 66
MNG_AGENCY 1
- California State Lands Commission · 66 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6641 | 6641 | 6640 | {"type": "Polygon", "coordinates": [[[-122.30898, 38.21963], [-122.30854, 38.22266], [-122.30777, 38.22425], [-122.30621, 38.22585], [-122.30316, 38.22649], [-122.30295, 38.22545], [-122.30208, 38.22003], [-122.29915, 38.22007], [-122.29928, 38.2196], [-122.30072, 38.21846], [-122.3028, 38.21904], [-122.30898, 38.21963]]]} | Open Access 1 | 4492 | Bull Island | 16501 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 100.348 | Bull Island | None 537 | |||
3020 | 3020 | 3019 | {"type": "Polygon", "coordinates": [[[-119.12918, 37.77888], [-119.12889, 37.77916], [-119.12872, 37.77944], [-119.12851, 37.77957], [-119.1283, 37.77961], [-119.12814, 37.77968], [-119.12769, 37.77969], [-119.12762, 37.77965], [-119.12752, 37.77968], [-119.1274, 37.7798], [-119.12735, 37.77996], [-119.12705, 37.78023], [-119.12692, 37.7803], [-119.12673, 37.78035], [-119.12679, 37.78041], [-119.12681, 37.7805], [-119.1267, 37.78064], [-119.12645, 37.78113], [-119.12613, 37.78152], [-119.12571, 37.78189], [-119.12554, 37.78217], [-119.12545, 37.78224], [-119.12537, 37.78227], [-119.12504, 37.78268], [-119.12481, 37.78285], [-119.12472, 37.7829], [-119.12465, 37.7829], [-119.12458, 37.78289], [-119.12452, 37.78284], [-119.12449, 37.78254], [-119.12444, 37.78241], [-119.12441, 37.78191], [-119.12437, 37.78163], [-119.12431, 37.78144], [-119.12427, 37.78109], [-119.12421, 37.78094], [-119.12417, 37.78078], [-119.12401, 37.78038], [-119.12394, 37.78026], [-119.12365, 37.77943], [-119.12343, 37.77889], [-119.12333, 37.77872], [-119.12321, 37.77845], [-119.12301, 37.77811], [-119.12283, 37.77778], [-119.12266, 37.77755], [-119.1226, 37.77741], [-119.12247, 37.77687], [-119.12238, 37.7767], [-119.12227, 37.77657], [-119.12215, 37.77635], [-119.12211, 37.77625], [-119.12211, 37.77612], [-119.12207, 37.77598], [-119.12195, 37.77583], [-119.12186, 37.77567], [-119.12174, 37.77551], [-119.12165, 37.77542], [-119.12163, 37.7753], [-119.12159, 37.77519], [-119.12158, 37.77504], [-119.1216, 37.775], [-119.12165, 37.77498], [-119.12178, 37.77503], [-119.12181, 37.77495], [-119.12183, 37.7748], [-119.12188, 37.77475], [-119.12194, 37.77462], [-119.12184, 37.77454], [-119.1218, 37.77447], [-119.12183, 37.77443], [-119.12189, 37.77441], [-119.12186, 37.77427], [-119.12178, 37.77419], [-119.1218, 37.77411], [-119.12184, 37.77405], [-119.12185, 37.77396], [-119.12183, 37.77384], [-119.12181, 37.77379], [-119.12184, 37.77374], [-119.12205, 37.77369], [-119.12217, 37.77363], [-119.12222, 37.77348], [-119.12225, 37.77344], [-119.12227, 37.77327], [-119.12233, 37.77324], [-119.12257, 37.77322], [-119.12275, 37.77302], [-119.12277, 37.7729], [-119.12275, 37.77282], [-119.12279, 37.77273], [-119.12286, 37.77264], [-119.12298, 37.77255], [-119.12318, 37.77251], [-119.12338, 37.7725], [-119.12368, 37.77252], [-119.12377, 37.77255], [-119.12391, 37.77265], [-119.12402, 37.77284], [-119.12402, 37.77294], [-119.12408, 37.77329], [-119.12412, 37.77336], [-119.12417, 37.77337], [-119.12431, 37.77334], [-119.12443, 37.77319], [-119.12449, 37.77316], [-119.12456, 37.77315], [-119.12465, 37.77318], [-119.12483, 37.7732], [-119.12495, 37.77314], [-119.12496, 37.77302], [-119.12493, 37.7729], [-119.12484, 37.77265], [-119.12486, 37.77244], [-119.12491, 37.77227], [-119.12501, 37.7721], [-119.12502, 37.77202], [-119.12499, 37.77164], [-119.12503, 37.77161], [-119.12512, 37.77171], [-119.12513, 37.77196], [-119.12515, 37.77204], [-119.1252, 37.77211], [-119.12531, 37.77218], [-119.12544, 37.77221], [-119.12546, 37.7722], [-119.12537, 37.77061], [-119.12555, 37.77102], [-119.12569, 37.7714], [-119.1258, 37.77175], [-119.12595, 37.77227], [-119.12604, 37.77252], [-119.12605, 37.77261], [-119.12603, 37.77286], [-119.12611, 37.77312], [-119.12623, 37.77337], [-119.12641, 37.7736], [-119.12662, 37.77382], [-119.12698, 37.77435], [-119.12664, 37.77446], [-119.12663, 37.77448], [-119.12676, 37.77471], [-119.12696, 37.77489], [-119.12726, 37.77511], [-119.12752, 37.77555], [-119.12784, 37.77583], [-119.12805, 37.77614], [-119.12843, 37.77657], [-119.12914, 37.77845], [-119.12918, 37.77888]]]} | Open Access 1 | 20776 | Silver Lake | 25487 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Mono 32 | 107.687 | Silver Lake | 0 | None 247 | ||
11562 | 11562 | 11561 | {"type": "Polygon", "coordinates": [[[-120.16674, 38.50827], [-120.15343, 38.50783], [-120.1532, 38.50427], [-120.16663, 38.5047], [-120.16674, 38.50827]]]} | Open Access 1 | 23576 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Amador 52 | 113.944 | SLC | 0 | State Resource Management Area 55 | 3 | |
16352 | 16352 | 16351 | {"type": "Polygon", "coordinates": [[[-117.3542, 33.60498], [-117.34984, 33.60488], [-117.34984, 33.60123], [-117.34548, 33.60113], [-117.3455, 33.59749], [-117.35419, 33.59768], [-117.3542, 33.60498]]]} | Open Access 1 | 44762 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Riverside 10 | 121.181 | SLC | 0 | State Resource Management Area 55 | 3 | |
16332 | 16332 | 16331 | {"type": "Polygon", "coordinates": [[[-120.85499, 39.14173], [-120.85496, 39.14255], [-120.85496, 39.14519], [-120.85489, 39.1452], [-120.8549, 39.14874], [-120.84548, 39.1481], [-120.84538, 39.14426], [-120.85019, 39.1447], [-120.85017, 39.14118], [-120.85499, 39.14173]]]} | Open Access 1 | 44761 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Placer 35 | 122.823 | SLC | 0 | State Resource Management Area 55 | 3 | |
374 | 374 | 373 | {"type": "Polygon", "coordinates": [[[-122.51401, 38.08952], [-122.50961, 38.09217], [-122.5071, 38.09337], [-122.50547, 38.08821], [-122.50462, 38.08689], [-122.50476, 38.08671], [-122.50434, 38.08636], [-122.50461, 38.086], [-122.50537, 38.08538], [-122.50578, 38.08514], [-122.50622, 38.08495], [-122.50736, 38.08466], [-122.50838, 38.08465], [-122.50977, 38.08483], [-122.5107, 38.08507], [-122.51158, 38.08542], [-122.51221, 38.08579], [-122.51271, 38.0862], [-122.51324, 38.08682], [-122.51374, 38.08778], [-122.51391, 38.08855], [-122.51402, 38.08937], [-122.51401, 38.08952]]]} | Open Access 1 | 1105 | North Antenna Field | 22804 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Marin 23 | 128.205 | North Antenna Field | None 38 | |||
11218 | 11218 | 11217 | {"type": "MultiPolygon", "coordinates": [[[[-120.15811, 38.6645], [-120.15778, 38.67173], [-120.14871, 38.67204], [-120.14897, 38.66843], [-120.15345, 38.66827], [-120.15367, 38.66465], [-120.15811, 38.6645]]], [[[-120.75259, 38.79792], [-120.75256, 38.79835], [-120.75144, 38.79968], [-120.75107, 38.79963], [-120.75082, 38.79955], [-120.75079, 38.79887], [-120.75044, 38.79879], [-120.74936, 38.79877], [-120.74903, 38.79884], [-120.74868, 38.79906], [-120.74836, 38.79945], [-120.74801, 38.79969], [-120.74748, 38.79971], [-120.74705, 38.79952], [-120.74684, 38.79907], [-120.74742, 38.79818], [-120.74848, 38.79813], [-120.74883, 38.79806], [-120.74953, 38.79765], [-120.75032, 38.79701], [-120.75107, 38.7968], [-120.75151, 38.79687], [-120.752, 38.79723], [-120.75259, 38.79792]]]]} | Open Access 1 | 21547 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | El Dorado 34 | 137.473 | SLC | 0 | State Resource Management Area 55 | 3 | |
2955 | 2955 | 2954 | {"type": "Polygon", "coordinates": [[[-120.15107, 39.37152], [-120.14729, 39.37415], [-120.14177, 39.37413], [-120.14173, 39.36683], [-120.15098, 39.36681], [-120.15107, 39.37152]]]} | Open Access 1 | 23550 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Nevada 30 | 149.239 | SLC | 0 | State Resource Management Area 55 | 3 | |
16859 | 16859 | 16858 | {"type": "Polygon", "coordinates": [[[-124.01314, 41.74416], [-124.00368, 41.74407], [-124.00368, 41.7366], [-124.01311, 41.73677], [-124.01318, 41.74044], [-124.01314, 41.74416]]]} | Open Access 1 | 23437 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Del Norte 50 | 160.655 | SLC | 0 | State Resource Management Area 55 | 3 | |
11548 | 11548 | 11547 | {"type": "Polygon", "coordinates": [[[-121.01476, 41.91316], [-121.01476, 41.9204], [-121.00504, 41.92032], [-121.00501, 41.91672], [-120.99031, 41.91664], [-120.99007, 41.91308], [-121.00499, 41.91311], [-121.00502, 41.91671], [-121.00986, 41.91674], [-121.00987, 41.91673], [-121.00986, 41.91312], [-121.01476, 41.91316]]]} | Open Access 1 | 23627 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Modoc 56 | 241.472 | SLC | 0 | State Resource Management Area 55 | 3 | |
16357 | 16357 | 16356 | {"type": "MultiPolygon", "coordinates": [[[[-119.40892, 37.09687], [-119.40888, 37.10414], [-119.40433, 37.10414], [-119.40438, 37.09688], [-119.40892, 37.09687]]], [[[-119.41801, 37.10775], [-119.41344, 37.10776], [-119.41343, 37.11139], [-119.40885, 37.1114], [-119.40887, 37.10777], [-119.41344, 37.10776], [-119.41346, 37.09687], [-119.418, 37.09686], [-119.41801, 37.10775]]]]} | Open Access 1 | 44763 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Fresno 9 | 242.067 | SLC | 0 | State Resource Management Area 55 | 3 | |
12265 | 12265 | 12264 | {"type": "Polygon", "coordinates": [[[-122.53034, 38.61119], [-122.52572, 38.61121], [-122.52574, 38.61484], [-122.52112, 38.61486], [-122.52091, 38.614], [-122.52089, 38.61399], [-122.52101, 38.61821], [-122.51659, 38.61803], [-122.51647, 38.6144], [-122.51625, 38.60714], [-122.52067, 38.60732], [-122.52401, 38.60734], [-122.53031, 38.60743], [-122.53034, 38.61119]]]} | No Public Access 3 | 25816 | California State Lands Commission | 16723 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 245.258 | SLC | 0 | State Resource Management Area 55 | 3 | |
16884 | 16884 | 16883 | {"type": "MultiPolygon", "coordinates": [[[[-122.47891, 39.46355], [-122.474, 39.46343], [-122.47401, 39.46002], [-122.47886, 39.45995], [-122.47891, 39.46355]]], [[[-122.52365, 39.42486], [-122.52357, 39.42844], [-122.5154, 39.42808], [-122.51541, 39.42447], [-122.52365, 39.42486]]], [[[-122.56097, 39.41438], [-122.55686, 39.41429], [-122.55682, 39.41062], [-122.55196, 39.41049], [-122.55189, 39.40698], [-122.55679, 39.40694], [-122.55683, 39.41061], [-122.56095, 39.41074], [-122.56097, 39.41438]]], [[[-122.60138, 39.4653], [-122.59646, 39.46527], [-122.59542, 39.45786], [-122.60048, 39.45797], [-122.60138, 39.4653]]]]} | Unknown Access 4 | 44765 | California State Lands Commission | 16726 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Glenn 55 | 273.89 | SLC | 0 | State Resource Management Area 55 | 3 | |
4992 | 4992 | 4991 | {"type": "Polygon", "coordinates": [[[-118.84108, 36.28018], [-118.83173, 36.28007], [-118.83196, 36.26719], [-118.84105, 36.2672], [-118.84108, 36.28018]]]} | Open Access 1 | 796 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Tulare 29 | 293.919 | SLC | 0 | State Resource Management Area 55 | 3 | |
16586 | 16586 | 16585 | {"type": "Polygon", "coordinates": [[[-117.15468, 34.3852], [-117.15467, 34.39963], [-117.14592, 34.39962], [-117.14596, 34.38506], [-117.15468, 34.3852]]]} | Unknown Access 4 | 44757 | California State Lands Commission | 16726 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 319.202 | SLC | 0 | State Resource Management Area 55 | 3 | |
16869 | 16869 | 16868 | {"type": "MultiPolygon", "coordinates": [[[[-121.80463, 41.52062], [-121.80457, 41.53152], [-121.79967, 41.53154], [-121.79976, 41.5206], [-121.80463, 41.52062]]], [[[-122.05397, 41.95202], [-122.05393, 41.95558], [-122.0491, 41.95564], [-122.04913, 41.95206], [-122.05397, 41.95202]]], [[[-122.29062, 41.35254], [-122.28926, 41.35254], [-122.28578, 41.35187], [-122.28578, 41.35109], [-122.29062, 41.35203], [-122.29062, 41.35254]]], [[[-122.31147, 41.65609], [-122.31143, 41.66351], [-122.30659, 41.66351], [-122.30662, 41.65593], [-122.31147, 41.65609]]], [[[-122.60156, 41.79319], [-122.6014, 41.79493], [-122.60121, 41.79669], [-122.59643, 41.79669], [-122.59673, 41.79316], [-122.60156, 41.79319]]], [[[-122.60748, 41.78608], [-122.60728, 41.78787], [-122.60469, 41.78785], [-122.60488, 41.78609], [-122.60748, 41.78608]]], [[[-122.65645, 41.74349], [-122.65358, 41.74347], [-122.65355, 41.74344], [-122.65353, 41.74201], [-122.65374, 41.74206], [-122.65389, 41.74155], [-122.65554, 41.7416], [-122.65559, 41.74155], [-122.65573, 41.74155], [-122.6557, 41.7416], [-122.6559, 41.74217], [-122.65645, 41.74349]]], [[[-123.27162, 41.26636], [-123.27159, 41.27003], [-123.26708, 41.27003], [-123.26717, 41.26635], [-123.27162, 41.26636]]]]} | Open Access 1 | 44760 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Siskiyou 28 | 350.629 | SLC | 0 | State Resource Management Area 55 | 3 | |
16880 | 16880 | 16879 | {"type": "MultiPolygon", "coordinates": [[[[-122.60218, 41.62156], [-122.60209, 41.62517], [-122.59735, 41.62525], [-122.59742, 41.62172], [-122.60218, 41.62156]]], [[[-122.61167, 41.61024], [-122.61157, 41.61766], [-122.60237, 41.61794], [-122.60228, 41.61055], [-122.61167, 41.61024]]], [[[-122.67244, 41.57781], [-122.66285, 41.57775], [-122.66278, 41.57415], [-122.65795, 41.57412], [-122.6578, 41.57051], [-122.67231, 41.5706], [-122.67244, 41.57781]]], [[[-122.66953, 41.66923], [-122.66481, 41.66926], [-122.66449, 41.66176], [-122.66922, 41.66168], [-122.66953, 41.66923]]]]} | Open Access 1 | 44759 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Siskiyou 28 | 475.994 | SLC | 0 | State Resource Management Area 55 | 3 | |
16891 | 16891 | 16890 | {"type": "MultiPolygon", "coordinates": [[[[-122.75035, 38.76503], [-122.75035, 38.76503], [-122.74817, 38.76717], [-122.74814, 38.76676], [-122.74807, 38.76521], [-122.74817, 38.76505], [-122.75035, 38.76503]]], [[[-122.75762, 38.76313], [-122.75758, 38.76479], [-122.75762, 38.76849], [-122.75294, 38.7685], [-122.75283, 38.76525], [-122.75305, 38.76502], [-122.75747, 38.76305], [-122.75762, 38.76313]]], [[[-122.76703, 38.75963], [-122.76683, 38.76144], [-122.76222, 38.7614], [-122.76213, 38.76211], [-122.76077, 38.7614], [-122.76221, 38.7614], [-122.76237, 38.75967], [-122.76703, 38.75963]]], [[[-122.77626, 38.77836], [-122.77159, 38.77837], [-122.77162, 38.77496], [-122.77624, 38.775], [-122.77626, 38.77836]]], [[[-122.77642, 38.76292], [-122.77476, 38.76161], [-122.77464, 38.7615], [-122.77634, 38.76151], [-122.77642, 38.76292]]], [[[-122.8185, 38.7887], [-122.80464, 38.78848], [-122.80413, 38.78531], [-122.80411, 38.78496], [-122.80877, 38.78502], [-122.80862, 38.78126], [-122.81327, 38.78139], [-122.81331, 38.78199], [-122.81338, 38.78509], [-122.81805, 38.78516], [-122.8185, 38.7887]]], [[[-122.83116, 38.83153], [-122.82669, 38.83149], [-122.82662, 38.82805], [-122.82226, 38.82797], [-122.82246, 38.82457], [-122.83084, 38.82465], [-122.831, 38.82796], [-122.82867, 38.82621], [-122.82715, 38.82745], [-122.83099, 38.83025], [-122.8311, 38.83017], [-122.83116, 38.83153]]], [[[-122.84006, 38.7912], [-122.83894, 38.79259], [-122.83459, 38.79034], [-122.83574, 38.78897], [-122.84006, 38.7912]]], [[[-122.86484, 38.82163], [-122.8606, 38.82726], [-122.85748, 38.82389], [-122.854, 38.82085], [-122.85544, 38.81893], [-122.85815, 38.81524], [-122.86172, 38.81827], [-122.86456, 38.82131], [-122.86484, 38.82163]]]]} | Open Access 1 | 44755 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Sonoma 16 | 537.395 | SLC | 0 | State Resource Management Area 55 | 3 | |
14330 | 14330 | 14329 | {"type": "Polygon", "coordinates": [[[-121.35088, 40.9054], [-121.35078, 40.90893], [-121.34677, 40.90892], [-121.34658, 40.91981], [-121.34648, 40.91985], [-121.33442, 40.91971], [-121.33131, 40.91966], [-121.33175, 40.90581], [-121.33418, 40.90581], [-121.33418, 40.90513], [-121.35088, 40.9054]]]} | Restricted Access 2 | 44318 | California State Lands Commission | 16725 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Shasta 27 | 539.61 | SLC | 0 | State Resource Management Area 55 | 3 | |
14618 | 14618 | 14617 | {"type": "Polygon", "coordinates": [[[-115.71453, 35.03003], [-115.71447, 35.04386], [-115.69802, 35.04386], [-115.69803, 35.03], [-115.71453, 35.03003]]]} | Restricted Access 2 | 44845 | California State Lands Commission | 16725 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 570.632 | SLC | 0 | State Resource Management Area 55 | 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]);