units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, DES_TP = 18, MNG_AG_TYP = 1 and UNIT_NAME = "Pinnacles National Park"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 2 ✖
MNG_AGENCY 1
DES_TP 1
- National Park · 2 ✖
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4903 | 4903 | 4902 | {"type": "MultiPolygon", "coordinates": [[[[-121.20745, 36.43012], [-121.20677, 36.44425], [-121.2023, 36.44428], [-121.20196, 36.4553], [-121.20193, 36.45526], [-121.20192, 36.45522], [-121.1951, 36.4481], [-121.19152, 36.44434], [-121.19127, 36.44414], [-121.191, 36.44386], [-121.18795, 36.44147], [-121.1855, 36.43948], [-121.18318, 36.43771], [-121.17649, 36.43236], [-121.1736, 36.43003], [-121.17067, 36.42778], [-121.15598, 36.4161], [-121.17112, 36.41562], [-121.1713, 36.40838], [-121.18915, 36.40841], [-121.18877, 36.41571], [-121.18882, 36.41572], [-121.18916, 36.42285], [-121.19811, 36.42286], [-121.19848, 36.43005], [-121.20745, 36.43012]]], [[[-121.23434, 36.48834], [-121.23336, 36.48835], [-121.23274, 36.49533], [-121.23203, 36.49533], [-121.23197, 36.49446], [-121.23218, 36.4937], [-121.23215, 36.4926], [-121.23223, 36.49105], [-121.23163, 36.48986], [-121.23103, 36.48836], [-121.22993, 36.48836], [-121.22851, 36.47347], [-121.22852, 36.47329], [-121.2329, 36.4733], [-121.23434, 36.48834]]]]} | Open Access 1 | 23077 | Pinnacles National Park | 14264 | 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/pinn/index.htm | Monterey 14 | 2529.077 | Pinnacles NP | 2013 | National Park 18 | 2 |
15801 | 15801 | 15800 | {"type": "MultiPolygon", "coordinates": [[[[-121.24459, 36.50282], [-121.24435, 36.51005], [-121.23996, 36.51007], [-121.23966, 36.51731], [-121.23062, 36.5172], [-121.22987, 36.53167], [-121.22988, 36.53168], [-121.23887, 36.53184], [-121.23882, 36.53546], [-121.22982, 36.53532], [-121.22978, 36.53894], [-121.23428, 36.53902], [-121.23419, 36.54626], [-121.23868, 36.54633], [-121.23878, 36.53908], [-121.24346, 36.53906], [-121.2434, 36.54632], [-121.23869, 36.54633], [-121.2386, 36.54994], [-121.22957, 36.54981], [-121.22931, 36.55703], [-121.22476, 36.55697], [-121.22462, 36.56058], [-121.22005, 36.56052], [-121.21991, 36.56492], [-121.21537, 36.56499], [-121.21547, 36.56054], [-121.21091, 36.56055], [-121.21129, 36.55329], [-121.20222, 36.5533], [-121.19776, 36.55326], [-121.19795, 36.54962], [-121.19347, 36.5496], [-121.19362, 36.54596], [-121.1937, 36.54233], [-121.19822, 36.54233], [-121.19836, 36.53506], [-121.19386, 36.53505], [-121.19393, 36.53142], [-121.18497, 36.53143], [-121.18468, 36.5423], [-121.1667, 36.54224], [-121.16217, 36.54218], [-121.16229, 36.53492], [-121.15776, 36.53485], [-121.15782, 36.53121], [-121.1533, 36.53114], [-121.15323, 36.53478], [-121.1487, 36.53472], [-121.1487, 36.53446], [-121.14854, 36.53451], [-121.14826, 36.53398], [-121.14765, 36.53372], [-121.14661, 36.53314], [-121.14639, 36.53289], [-121.14618, 36.53262], [-121.14611, 36.53224], [-121.14611, 36.53201], [-121.14566, 36.53124], [-121.14532, 36.53058], [-121.14486, 36.53014], [-121.14443, 36.5297], [-121.1443, 36.52945], [-121.14415, 36.52885], [-121.14423, 36.52789], [-121.14413, 36.52747], [-121.14384, 36.52705], [-121.14305, 36.52627], [-121.14148, 36.52441], [-121.14123, 36.52425], [-121.14066, 36.52402], [-121.14025, 36.52375], [-121.14, 36.52338], [-121.13997, 36.52294], [-121.13989, 36.52271], [-121.13976, 36.52247], [-121.13918, 36.52208], [-121.1389, 36.52156], [-121.13829, 36.52083], [-121.13828, 36.52072], [-121.13886, 36.51762], [-121.13694, 36.5176], [-121.13667, 36.51687], [-121.13639, 36.51636], [-121.13635, 36.51601], [-121.13665, 36.51533], [-121.13705, 36.51499], [-121.13724, 36.51469], [-121.13733, 36.51406], [-121.13749, 36.51224], [-121.13745, 36.51186], [-121.1373, 36.51144], [-121.1373, 36.511], [-121.13748, 36.51048], [-121.13768, 36.51029], [-121.13766, 36.5101], [-121.13781, 36.50977], [-121.13811, 36.50924], [-121.13823, 36.50891], [-121.13952, 36.508], [-121.1396, 36.5078], [-121.13955, 36.50762], [-121.13933, 36.50635], [-121.13919, 36.50592], [-121.13924, 36.50568], [-121.13933, 36.50537], [-121.13931, 36.50519], [-121.13922, 36.50499], [-121.13939, 36.50415], [-121.13946, 36.50367], [-121.13919, 36.50295], [-121.13933, 36.50248], [-121.13938, 36.5021], [-121.1395, 36.50185], [-121.14, 36.50133], [-121.14012, 36.50113], [-121.14001, 36.50088], [-121.14007, 36.50046], [-121.14042, 36.50013], [-121.14068, 36.50002], [-121.14086, 36.49985], [-121.14086, 36.49942], [-121.14098, 36.49906], [-121.14174, 36.49811], [-121.14227, 36.49726], [-121.1437, 36.49608], [-121.1443, 36.49566], [-121.1452, 36.49536], [-121.14616, 36.49495], [-121.14709, 36.49362], [-121.14765, 36.49318], [-121.14854, 36.4926], [-121.14924, 36.49206], [-121.14949, 36.49134], [-121.14963, 36.4908], [-121.14998, 36.49057], [-121.15095, 36.48985], [-121.15184, 36.48904], [-121.15243, 36.48876], [-121.15336, 36.48815], [-121.15336, 36.48813], [-121.15316, 36.48813], [-121.15235, 36.48867], [-121.15175, 36.48895], [-121.15085, 36.48977], [-121.1499, 36.49048], [-121.14951, 36.49074], [-121.14936, 36.49132], [-121.14912, 36.492], [-121.14845, 36.49252], [-121.14756, 36.49309], [-121.14698, 36.49355], [-121.14606, 36.49487], [-121.14514, 36.49526], [-121.14422, 36.49557], [-121.14361, 36.496], [-121.14216, 36.49719], [-121.14162, 36.49806], [-121.14085, 36.49901], [-121.14073, 36.4994], [-121.14072, 36.49981], [-121.14062, 36.49992], [-121.14033, 36.50004], [-121.13994, 36.50041], [-121.13987, 36.50089], [-121.13997, 36.50112], [-121.13988, 36.50128], [-121.13938, 36.5018], [-121.13925, 36.50207], [-121.1392, 36.50246], [-121.13905, 36.50295], [-121.13933, 36.50368], [-121.13925, 36.50413], [-121.13908, 36.505], [-121.13917, 36.50521], [-121.13919, 36.50536], [-121.1391, 36.50565], [-121.13905, 36.50593], [-121.1392, 36.50637], [-121.13941, 36.50764], [-121.13946, 36.50779], [-121.13941, 36.50794], [-121.13811, 36.50885], [-121.13798, 36.5092], [-121.13768, 36.50973], [-121.13753, 36.51008], [-121.13754, 36.51025], [-121.13736, 36.51043], [-121.13716, 36.51098], [-121.13716, 36.51145], [-121.13732, 36.51188], [-121.13735, 36.51224], [-121.1372, 36.51405], [-121.1371, 36.51466], [-121.13694, 36.51493], [-121.13653, 36.51527], [-121.13621, 36.516], [-121.13626, 36.51639], [-121.13654, 36.51691], [-121.1368, 36.5176], [-121.13597, 36.51759], [-121.1359, 36.51704], [-121.13556, 36.51667], [-121.13524, 36.51683], [-121.13504, 36.51755], [-121.13405, 36.51727], [-121.13254, 36.51702], [-121.13068, 36.51684], [-121.1295, 36.51686], [-121.1285, 36.51708], [-121.1279, 36.51724], [-121.12739, 36.51714], [-121.12592, 36.51678], [-121.12452, 36.51607], [-121.12373, 36.51549], [-121.12325, 36.51516], [-121.12212, 36.51475], [-121.12132, 36.51431], [-121.12026, 36.51355], [-121.11927, 36.51298], [-121.11686, 36.51154], [-121.11611, 36.51124], [-121.11492, 36.51036], [-121.11439, 36.51007], [-121.11325, 36.50935], [-121.1127, 36.50874], [-121.11206, 36.50828], [-121.11105, 36.50773], [-121.11057, 36.50749], [-121.11009, 36.50688], [-121.10989, 36.5066], [-121.10955, 36.50631], [-121.10889, 36.50621], [-121.10824, 36.50621], [-121.1079, 36.50583], [-121.10749, 36.50561], [-121.1067, 36.5051], [-121.10583, 36.50442], [-121.10525, 36.50423], [-121.10472, 36.50395], [-121.10319, 36.50194], [-121.10272, 36.50116], [-121.10155, 36.49996], [-121.10083, 36.49903], [-121.13197, 36.49913], [-121.13216, 36.49546], [-121.13674, 36.49553], [-121.13714, 36.48819], [-121.12991, 36.48818], [-121.12749, 36.48821], [-121.126, 36.48817], [-121.11888, 36.48811], [-121.11885, 36.48839], [-121.11564, 36.48837], [-121.11614, 36.49173], [-121.11404, 36.49171], [-121.11402, 36.49201], [-121.11167, 36.49197], [-121.11118, 36.48828], [-121.10804, 36.4882], [-121.1081, 36.48454], [-121.11254, 36.48463], [-121.11266, 36.47733], [-121.1171, 36.47743], [-121.11717, 36.47378], [-121.12611, 36.47384], [-121.13057, 36.47389], [-121.13068, 36.47022], [-121.13516, 36.47028], [-121.14391, 36.47028], [-121.14405, 36.46306], [-121.14469, 36.46306], [-121.1447, 36.46292], [-121.14478, 36.46268], [-121.1448, 36.46255], [-121.14479, 36.46233], [-121.14481, 36.46199], [-121.14485, 36.46162], [-121.14497, 36.46115], [-121.14497, 36.46089], [-121.14521, 36.45998], [-121.14533, 36.4597], [-121.14561, 36.4592], [-121.14628, 36.45822], [-121.14674, 36.45765], [-121.14718, 36.45721], [-121.1475, 36.45704], [-121.14794, 36.45681], [-121.14848, 36.45661], [-121.14849, 36.45588], [-121.14941, 36.45588], [-121.14948, 36.45567], [-121.1497, 36.45558], [-121.15015, 36.45548], [-121.15062, 36.45545], [-121.15089, 36.4554], [-121.15116, 36.45542], [-121.15139, 36.45537], [-121.1521, 36.45508], [-121.15214, 36.45256], [-121.15283, 36.4526], [-121.1535, 36.45254], [-121.15415, 36.45111], [-121.15387, 36.45053], [-121.15285, 36.45008], [-121.15284, 36.45005], [-121.15265, 36.44993], [-121.15222, 36.44959], [-121.15205, 36.44925], [-121.1521, 36.44899], [-121.15238, 36.44853], [-121.1525, 36.44819], [-121.15255, 36.44795], [-121.15246, 36.44776], [-121.1523, 36.44759], [-121.15196, 36.44695], [-121.15193, 36.44667], [-121.15197, 36.44631], [-121.15212, 36.44602], [-121.15288, 36.44558], [-121.1529, 36.4456], [-121.15377, 36.44515], [-121.15375, 36.4448], [-121.15289, 36.44481], [-121.15303, 36.43052], [-121.15749, 36.43045], [-121.15759, 36.41965], [-121.15758, 36.41964], [-121.15311, 36.41976], [-121.15313, 36.41617], [-121.15591, 36.4161], [-121.16554, 36.42371], [-121.16961, 36.42696], [-121.1736, 36.43003], [-121.17649, 36.43236], [-121.18318, 36.43771], [-121.1855, 36.43948], [-121.18795, 36.44147], [-121.191, 36.44386], [-121.1951, 36.4481], [-121.20193, 36.45522], [-121.20182, 36.45908], [-121.20627, 36.45903], [-121.20583, 36.47364], [-121.21484, 36.47358], [-121.22391, 36.47328], [-121.22852, 36.47329], [-121.22851, 36.47347], [-121.22993, 36.48835], [-121.23103, 36.48835], [-121.23163, 36.48986], [-121.23223, 36.49105], [-121.23215, 36.4926], [-121.23218, 36.4937], [-121.23197, 36.49446], [-121.23203, 36.49532], [-121.23274, 36.49533], [-121.23178, 36.50274], [-121.24024, 36.50282], [-121.24459, 36.50282]], [[-121.15013, 36.50067], [-121.14993, 36.50217], [-121.15252, 36.50215], [-121.15253, 36.50066], [-121.15013, 36.50067]], [[-121.15753, 36.48814], [-121.15596, 36.48814], [-121.15523, 36.49527], [-121.15991, 36.49537], [-121.1599, 36.49277], [-121.16037, 36.48828], [-121.15753, 36.48814]]], [[[-121.14827, 36.53427], [-121.14507, 36.53528], [-121.14462, 36.53446], [-121.14546, 36.53416], [-121.14611, 36.53403], [-121.14628, 36.53382], [-121.14649, 36.53369], [-121.14704, 36.53351], [-121.14758, 36.53381], [-121.14815, 36.53406], [-121.14827, 36.53427]]]]} | Open Access 1 | 18547 | Pinnacles National Park | 14264 | 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/pinn/index.htm | San Benito 38 | 24001.115 | Pinnacles NP | 2013 | 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]);