units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 48, MNG_AGENCY = 59 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- Federal Agency · 2 ✖
MNG_AGENCY 1
- United States National Park Service · 2 ✖
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15773 | 15773 | 15772 | {"type": "Polygon", "coordinates": [[[-119.09289, 37.59811], [-119.09289, 37.59811], [-119.09173, 37.63532], [-119.08305, 37.63394], [-119.08363, 37.59717], [-119.09289, 37.59811]]]} | Open Access 1 | 16776 | Devils Postpile National Monument | 14212 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/depo/index.htm | Madera 48 | 805.97 | Devils Postpile NM | 1911 | National Monument or Landmark 80 | 3 |
| 15796 | 15796 | 15795 | {"type": "MultiPolygon", "coordinates": [[[[-119.58434, 37.5597], [-119.58166, 37.56183], [-119.55596, 37.58052], [-119.5122, 37.61176], [-119.51221, 37.61177], [-119.51267, 37.61186], [-119.51316, 37.6125], [-119.51379, 37.6128], [-119.51376, 37.61301], [-119.51356, 37.61317], [-119.5133, 37.61319], [-119.51298, 37.61303], [-119.5127, 37.61298], [-119.51232, 37.61312], [-119.51163, 37.61287], [-119.51126, 37.61266], [-119.51123, 37.61247], [-119.51121, 37.61247], [-119.5056, 37.61648], [-119.43922, 37.67121], [-119.39063, 37.71076], [-119.3636, 37.73213], [-119.30761, 37.77687], [-119.30751, 37.77665], [-119.30752, 37.77645], [-119.30763, 37.7762], [-119.3077, 37.77596], [-119.30789, 37.77522], [-119.30788, 37.77509], [-119.30784, 37.77494], [-119.30773, 37.77476], [-119.30754, 37.77466], [-119.30741, 37.77454], [-119.3071, 37.77411], [-119.30694, 37.77397], [-119.30673, 37.7738], [-119.30635, 37.77356], [-119.30616, 37.77341], [-119.30562, 37.77313], [-119.30537, 37.77288], [-119.30515, 37.77274], [-119.30501, 37.77257], [-119.30465, 37.77225], [-119.30444, 37.77203], [-119.30427, 37.77178], [-119.30407, 37.77157], [-119.30393, 37.77127], [-119.30371, 37.77091], [-119.30328, 37.77052], [-119.30272, 37.77019], [-119.30259, 37.76999], [-119.30253, 37.76955], [-119.30237, 37.76907], [-119.30225, 37.76894], [-119.3019, 37.76886], [-119.30173, 37.76879], [-119.3014, 37.76878], [-119.30102, 37.76874], [-119.30069, 37.76874], [-119.30043, 37.76867], [-119.29981, 37.76863], [-119.29942, 37.76862], [-119.29857, 37.76875], [-119.2983, 37.76869], [-119.2982, 37.7686], [-119.29811, 37.76833], [-119.29794, 37.76801], [-119.29776, 37.76778], [-119.29756, 37.7676], [-119.29737, 37.76748], [-119.29716, 37.76731], [-119.29637, 37.7669], [-119.29546, 37.76649], [-119.29519, 37.76639], [-119.29463, 37.76626], [-119.29447, 37.76624], [-119.29429, 37.76625], [-119.29413, 37.76613], [-119.2942, 37.76584], [-119.29389, 37.76517], [-119.2937, 37.76482], [-119.29364, 37.76459], [-119.29345, 37.76431], [-119.29315, 37.76407], [-119.29293, 37.76384], [-119.29261, 37.76337], [-119.29247, 37.76312], [-119.29223, 37.76283], [-119.29221, 37.76272], [-119.29232, 37.76261], [-119.29244, 37.76241], [-119.29264, 37.76224], [-119.29294, 37.76189], [-119.29311, 37.76177], [-119.29341, 37.76148], [-119.29357, 37.7614], [-119.29376, 37.76128], [-119.29414, 37.76096], [-119.29428, 37.76078], [-119.29433, 37.76062], [-119.29423, 37.76048], [-119.29396, 37.75968], [-119.29384, 37.75945], [-119.29365, 37.75914], [-119.29353, 37.75882], [-119.2931, 37.75802], [-119.29292, 37.75761], [-119.29264, 37.75732], [-119.29242, 37.75715], [-119.29223, 37.75692], [-119.29201, 37.75671], [-119.29182, 37.75661], [-119.29155, 37.75634], [-119.29131, 37.75616], [-119.29114, 37.75599], [-119.29037, 37.7555], [-119.29018, 37.75542], [-119.29005, 37.75532], [-119.2899, 37.75534], [-119.28979, 37.75528], [-119.28966, 37.75524], [-119.28956, 37.75511], [-119.28963, 37.75495], [-119.28975, 37.75476], [-119.28984, 37.75449], [-119.29011, 37.75409], [-119.29019, 37.75384], [-119.29022, 37.75363], [-119.29025, 37.75316], [-119.29024, 37.7529], [-119.29011, 37.75263], [-119.29004, 37.75216], [-119.28985, 37.75175], [-119.28968, 37.75147], [-119.28967, 37.75097], [-119.28958, 37.75053], [-119.28959, 37.75037], [-119.28973, 37.75003], [-119.28996, 37.74976], [-119.29032, 37.74947], [-119.29042, 37.74943], [-119.29058, 37.74941], [-119.29068, 37.74937], [-119.29077, 37.74929], [-119.29078, 37.74918], [-119.29068, 37.74905], [-119.29033, 37.74879], [-119.29019, 37.74857], [-119.29001, 37.74843], [-119.28986, 37.74833], [-119.28969, 37.74816], [-119.28959, 37.74783], [-119.28961, 37.74761], [-119.28958, 37.74742], [-119.28939, 37.74701], [-119.28881, 37.74631], [-119.28865, 37.74617], [-119.2878, 37.74556], [-119.28759, 37.74532], [-119.28689, 37.74514], [-119.28627, 37.74503], [-119.28583, 37.74495], [-119.2854, 37.74491], [-119.28466, 37.74478], [-119.28423, 37.74464], [-119.28393, 37.74451], [-119.28259, 37.7443], [-119.28193, 37.74413], [-119.28175, 37.74404], [-119.28161, 37.74403], [-119.28121, 37.74388], [-119.28095, 37.74371], [-119.28046, 37.74359], [-119.28031, 37.74348], [-119.28011, 37.74327], [-119.27997, 37.74318], [-119.27973, 37.74311], [-119.27952, 37.74301], [-119.27916, 37.74278], [-119.27891, 37.74271], [-119.27876, 37.74262], [-119.27867, 37.7424], [-119.27841, 37.74215], [-119.27813, 37.742], [-119.27774, 37.74187], [-119.27742, 37.74187], [-119.2772, 37.74183], [-119.27645, 37.74161], [-119.27622, 37.74151], [-119.27548, 37.74139], [-119.27459, 37.74083], [-119.27443, 37.74079], [-119.27391, 37.74052], [-119.27379, 37.74039], [-119.27299, 37.73995], [-119.27279, 37.73969], [-119.27267, 37.73947], [-119.27261, 37.73941], [-119.27177, 37.73942], [-119.27159, 37.73934], [-119.27138, 37.73937], [-119.27119, 37.73953], [-119.27106, 37.73958], [-119.27051, 37.73967], [-119.26987, 37.73969], [-119.26966, 37.73965], [-119.26908, 37.73951], [-119.26892, 37.73944], [-119.2686, 37.73941], [-119.26841, 37.73928], [-119.26831, 37.73912], [-119.26822, 37.73879], [-119.2681, 37.73853], [-119.26796, 37.73815], [-119.26787, 37.73795], [-119.26753, 37.73764], [-119.26721, 37.7373], [-119.26645, 37.73676], [-119.26586, 37.7363], [-119.26521, 37.73563], [-119.26502, 37.73551], [-119.26484, 37.73543], [-119.26447, 37.7352], [-119.26422, 37.73497], [-119.2641, 37.73481], [-119.26393, 37.73444], [-119.26374, 37.73389], [-119.26336, 37.73336], [-119.26324, 37.73326], [-119.26308, 37.73316], [-119.26294, 37.73314], [-119.26278, 37.73313], [-119.26249, 37.73324], [-119.26237, 37.73323], [-119.26211, 37.73314], [-119.26175, 37.73317], [-119.26152, 37.73312], [-119.26108, 37.73294], [-119.26089, 37.73282], [-119.26074, 37.73264], [-119.26067, 37.73244], [-119.26062, 37.73237], [-119.26041, 37.73213], [-119.26037, 37.73195], [-119.26041, 37.7316], [-119.26041, 37.73144], [-119.26029, 37.73106], [-119.26037, 37.73064], [-119.26037, 37.73045], [-119.26029, 37.73029], [-119.26013, 37.73018], [-119.26, 37.73006], [-119.25989, 37.72987], [-119.2599, 37.7297], [-119.25981, 37.72958], [-119.25962, 37.72943], [-119.25955, 37.72932], [-119.25955, 37.7292], [-119.2599, 37.72843], [-119.25995, 37.72823], [-119.25992, 37.72769], [-119.25978, 37.72719], [-119.25959, 37.72685], [-119.25914, 37.72636], [-119.25903, 37.72627], [-119.25868, 37.72607], [-119.25849, 37.72593], [-119.25803, 37.72571], [-119.25787, 37.72559], [-119.25768, 37.72539], [-119.25759, 37.72522], [-119.25755, 37.72506], [-119.25739, 37.72504], [-119.25749, 37.72504], [-119.25753, 37.72496], [-119.25901, 37.72379], [-119.25898, 37.72333], [-119.26021, 37.72106], [-119.26074, 37.71873], [-119.25991, 37.71628], [-119.25957, 37.71473], [-119.25957, 37.71468], [-119.25983, 37.71318], [-119.26066, 37.71264], [-119.26085, 37.71164], [-119.26075, 37.7107], [-119.26097, 37.70983], [-119.26156, 37.70894], [-119.2623, 37.70811], [-119.26249, 37.70701], [-119.26139, 37.70566], [-119.26084, 37.70463], [-119.26084, 37.70459], [-119.26113, 37.70378], [-119.26124, 37.70353], [-119.26246, 37.70268], [-119.2632, 37.70179], [-119.26415, 37.701], [-119.26568, 37.70022], [-119.26687, 37.70035], [-119.26812, 37.70031], [-119.27003, 37.7], [-119.27292, 37.6994], [-119.27501, 37.69926], [-119.27717, 37.69942], [-119.27877, 37.69929], [-119.28025, 37.69881], [-119.28133, 37.69743], [-119.28012, 37.69604], [-119.27989, 37.69519], [-119.27989, 37.69514], [-119.2801, 37.694], [-119.28052, 37.69265], [-119.28143, 37.69152], [-119.28256, 37.6911], [-119.28406, 37.69076], [-119.28622, 37.68989], [-119.28772, 37.68975], [-119.28989, 37.68971], [-119.29152, 37.68977], [-119.29146, 37.68933], [-119.29106, 37.68834], [-119.29091, 37.68727], [-119.29091, 37.68722], [-119.29121, 37.68635], [-119.29228, 37.68438], [-119.29299, 37.68347], [-119.29481, 37.68213], [-119.29539, 37.68156], [-119.29535, 37.68051], [-119.29368, 37.67957], [-119.293, 37.67902], [-119.29236, 37.67829], [-119.2923, 37.67747], [-119.29254, 37.67618], [-119.29356, 37.67515], [-119.29441, 37.67155], [-119.29505, 37.67076], [-119.29677, 37.66751], [-119.29796, 37.66698], [-119.29968, 37.66641], [-119.30325, 37.66506], [-119.30501, 37.66527], [-119.30777, 37.66548], [-119.30998, 37.66438], [-119.3128, 37.66404], [-119.31419, 37.66304], [-119.31523, 37.66164], [-119.31618, 37.65981], [-119.31733, 37.6583], [-119.31929, 37.65629], [-119.32153, 37.65436], [-119.32261, 37.6533], [-119.32634, 37.64947], [-119.32688, 37.64868], [-119.32746, 37.64539], [-119.32754, 37.64432], [-119.32683, 37.6437], [-119.32636, 37.64308], [-119.32619, 37.64226], [-119.32629, 37.63933], [-119.32669, 37.63804], [-119.32703, 37.63635], [-119.32755, 37.63495], [-119.32772, 37.63418], [-119.32867, 37.63294], [-119.33011, 37.63187], [-119.33445, 37.63202], [-119.33618, 37.63253], [-119.33771, 37.63226], [-119.33929, 37.63125], [-119.34047, 37.6307], [-119.3418, 37.63026], [-119.34527, 37.62989], [-119.34561, 37.62998], [-119.3472, 37.63036], [-119.34908, 37.63006], [-119.35055, 37.6296], [-119.35197, 37.62889], [-119.35453, 37.62677], [-119.35517, 37.62639], [-119.35601, 37.62686], [-119.35635, 37.62745], [-119.35752, 37.6288], [-119.36001, 37.62892], [-119.36077, 37.62912], [-119.36156, 37.62958], [-119.36257, 37.63], [-119.36412, 37.63086], [-119.3649, 37.63169], [-119.36565, 37.63214], [-119.36649, 37.63241], [-119.36807, 37.63258], [-119.37002, 37.63219], [-119.37074, 37.63219], [-119.37161, 37.63204], [-119.37161, 37.63203], [-119.36915, 37.63042], [-119.36878, 37.62944], [-119.36878, 37.62939], [-119.3691, 37.62849], [-119.36996, 37.62758], [-119.37028, 37.62656], [-119.3712, 37.62496], [-119.37203, 37.62369], [-119.37237, 37.62284], [-119.3722, 37.62151], [-119.3722, 37.62143], [-119.37294, 37.6203], [-119.37413, 37.61873], [-119.37519, 37.61796], [-119.3759, 37.61717], [-119.37771, 37.61428], [-119.37732, 37.61306], [-119.37728, 37.61212], [-119.37772, 37.61077], [-119.37854, 37.60915], [-119.37846, 37.60786], [-119.37952, 37.60627], [-119.37909, 37.60463], [-119.37884, 37.60402], [-119.37887, 37.60273], [-119.37932, 37.6015], [-119.37987, 37.60046], [-119.38079, 37.59975], [-119.38108, 37.59863], [-119.38268, 37.59634], [-119.384, 37.59516], [-119.38536, 37.59428], [-119.38607, 37.59335], [-119.38628, 37.59223], [-119.38628, 37.59015], [-119.38702, 37.589], [-119.38724, 37.58767], [-119.38662, 37.58701], [-119.38604, 37.58604], [-119.38604, 37.58476], [-119.38667, 37.58263], [-119.38748, 37.58098], [-119.38775, 37.57985], [-119.3871, 37.57865], [-119.38569, 37.57705], [-119.38451, 37.57518], [-119.38422, 37.57402], [-119.38422, 37.57396], [-119.38456, 37.57179], [-119.38563, 37.57046], [-119.38683, 37.5692], [-119.38813, 37.56764], [-119.3885, 37.56563], [-119.38902, 37.56467], [-119.39128, 37.56169], [-119.39147, 37.56063], [-119.38923, 37.5589], [-119.38864, 37.55773], [-119.38864, 37.55768], [-119.38901, 37.55632], [-119.38901, 37.55504], [-119.38936, 37.55391], [-119.38975, 37.55362], [-119.39136, 37.55291], [-119.39297, 37.55263], [-119.3945, 37.55203], [-119.39567, 37.5512], [-119.39579, 37.54977], [-119.39596, 37.54924], [-119.39817, 37.54833], [-119.39982, 37.5483], [-119.40157, 37.54759], [-119.40418, 37.54599], [-119.40605, 37.54549], [-119.40806, 37.54594], [-119.40995, 37.54765], [-119.4105, 37.5501], [-119.41143, 37.55139], [-119.41272, 37.55203], [-119.41776, 37.55333], [-119.41997, 37.55433], [-119.42073, 37.55411], [-119.42101, 37.55401], [-119.42192, 37.55244], [-119.42275, 37.55191], [-119.42336, 37.55125], [-119.42416, 37.55106], [-119.42621, 37.55101], [-119.42821, 37.5505], [-119.42933, 37.54959], [-119.43249, 37.54769], [-119.43556, 37.54556], [-119.43661, 37.54492], [-119.43869, 37.54407], [-119.4399, 37.54255], [-119.44168, 37.53964], [-119.44257, 37.53876], [-119.44474, 37.536], [-119.46681, 37.53577], [-119.52391, 37.53611], [-119.52547, 37.53467], [-119.52652, 37.53412], [-119.53084, 37.53411], [-119.5334, 37.53452], [-119.53409, 37.53395], [-119.53498, 37.53404], [-119.53621, 37.53401], [-119.53711, 37.53435], [-119.53852, 37.53509], [-119.53984, 37.53543], [-119.54194, 37.53668], [-119.54493, 37.53654], [-119.54603, 37.53618], [-119.54688, 37.53659], [-119.55151, 37.53714], [-119.5532, 37.5365], [-119.55455, 37.53623], [-119.55585, 37.53613], [-119.55727, 37.53539], [-119.5607, 37.53446], [-119.56277, 37.5353], [-119.56389, 37.53539], [-119.56417, 37.53515], [-119.56553, 37.5344], [-119.56656, 37.53437], [-119.56819, 37.53383], [-119.569, 37.53291], [-119.56986, 37.53249], [-119.57222, 37.53311], [-119.57421, 37.53329], [-119.57544, 37.53313], [-119.57653, 37.53274], [-119.5773, 37.53235], [-119.57827, 37.53208], [-119.57827, 37.50734], [-119.57823, 37.50312], [-119.57733, 37.50314], [-119.56909, 37.5032], [-119.569, 37.49627], [-119.57799, 37.49627], [-119.578, 37.49462], [-119.58296, 37.49465], [-119.58318, 37.52196], [-119.58346, 37.52617], [-119.58427, 37.53741], [-119.58427, 37.54269], [-119.58434, 37.5597]]], [[[-119.54111, 37.59422], [-119.54029, 37.59488], [-119.53939, 37.59466], [-119.5391, 37.59446], [-119.53916, 37.59398], [-119.53959, 37.59366], [-119.54023, 37.59336], [-119.54074, 37.59336], [-119.541, 37.5935], [-119.54111, 37.59422]]]]} | Open Access 1 | 16779 | Yosemite National Park | 14310 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/yose/index.htm | Madera 48 | 74949.316 | Yosemite NP | 1890 | National Park 18 | 2 |
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]);