units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where DES_TP = 49 and MNG_AGENCY = 59
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- United States National Park Service · 8 ✖
DES_TP 1
- Recreation Management Area · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7009 | 7009 | 7008 | {"type": "MultiPolygon", "coordinates": [[[[-118.69717, 34.09626], [-118.69708, 34.09636], [-118.69685, 34.09655], [-118.69422, 34.09857], [-118.69401, 34.09877], [-118.69383, 34.09898], [-118.69368, 34.09919], [-118.69353, 34.09945], [-118.69353, 34.09626], [-118.69717, 34.09626]]], [[[-118.70229, 34.09625], [-118.7001, 34.09625], [-118.7001, 34.0973], [-118.69892, 34.09625], [-118.69902, 34.09624], [-118.69892, 34.09614], [-118.69887, 34.09599], [-118.69889, 34.0958], [-118.69888, 34.09569], [-118.69891, 34.09558], [-118.69792, 34.09557], [-118.69791, 34.09987], [-118.69364, 34.09988], [-118.69378, 34.09954], [-118.69393, 34.09928], [-118.69405, 34.09911], [-118.69432, 34.09881], [-118.69463, 34.09856], [-118.69719, 34.09659], [-118.69738, 34.0964], [-118.6975, 34.09623], [-118.69761, 34.09596], [-118.69765, 34.09574], [-118.69765, 34.09559], [-118.69762, 34.09544], [-118.69755, 34.09522], [-118.69791, 34.09509], [-118.69791, 34.09264], [-118.70227, 34.09264], [-118.70229, 34.09625]]]]} | Open Access 1 | 6490 | King Gillette Ranch | 14239 | 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/samo/planyourvisit/kinggilletteranch.htm | Los Angeles 6 | 77.512 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
7269 | 7269 | 7268 | {"type": "Polygon", "coordinates": [[[-118.70012, 34.09988], [-118.69791, 34.09987], [-118.69791, 34.09626], [-118.69892, 34.09625], [-118.7001, 34.0973], [-118.70012, 34.09988]]]} | Restricted Access 2 | 6493 | Diamond X Ranch | 29655 | 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 | Los Angeles 6 | 18.578 | Diamond X Ranch | 0 | Recreation Management Area 49 | 4 | |
7422 | 7422 | 7421 | {"type": "Polygon", "coordinates": [[[-118.38785, 34.12636], [-118.38735, 34.12646], [-118.3872, 34.12645], [-118.38703, 34.12639], [-118.38696, 34.12634], [-118.38625, 34.12553], [-118.38623, 34.12548], [-118.38621, 34.12538], [-118.38608, 34.12528], [-118.38595, 34.12532], [-118.38595, 34.12535], [-118.38592, 34.1254], [-118.38578, 34.12542], [-118.38565, 34.12549], [-118.3851, 34.12621], [-118.38496, 34.12631], [-118.38478, 34.12638], [-118.38434, 34.12643], [-118.38426, 34.12643], [-118.38419, 34.12642], [-118.38413, 34.12638], [-118.38408, 34.12634], [-118.384, 34.12619], [-118.3839, 34.12609], [-118.38377, 34.12603], [-118.38359, 34.12603], [-118.38349, 34.12605], [-118.38337, 34.12613], [-118.38332, 34.12618], [-118.38308, 34.12651], [-118.38298, 34.12659], [-118.38285, 34.12665], [-118.38266, 34.12667], [-118.38149, 34.12656], [-118.38129, 34.12653], [-118.38131, 34.12649], [-118.38131, 34.12642], [-118.38128, 34.12634], [-118.3812, 34.12626], [-118.38096, 34.12612], [-118.38089, 34.12604], [-118.38087, 34.12598], [-118.38119, 34.12546], [-118.38102, 34.125], [-118.38138, 34.12466], [-118.38142, 34.12465], [-118.38142, 34.12462], [-118.38136, 34.12456], [-118.38126, 34.12452], [-118.38043, 34.1245], [-118.38034, 34.12447], [-118.37998, 34.12422], [-118.3798, 34.12415], [-118.37959, 34.12415], [-118.3794, 34.12424], [-118.37936, 34.12422], [-118.3792, 34.12375], [-118.37929, 34.12375], [-118.37942, 34.12372], [-118.37959, 34.12372], [-118.37969, 34.12367], [-118.37984, 34.12367], [-118.37997, 34.1237], [-118.38059, 34.1239], [-118.38067, 34.12389], [-118.38074, 34.12385], [-118.38075, 34.12382], [-118.38075, 34.12376], [-118.38069, 34.1237], [-118.38062, 34.12368], [-118.3805, 34.12373], [-118.3804, 34.12374], [-118.38016, 34.12366], [-118.38007, 34.1231], [-118.38026, 34.12322], [-118.38049, 34.12332], [-118.38071, 34.12335], [-118.38091, 34.12334], [-118.38106, 34.1233], [-118.38119, 34.12325], [-118.38139, 34.1231], [-118.3815, 34.12296], [-118.38154, 34.12286], [-118.38158, 34.1227], [-118.38165, 34.12265], [-118.38179, 34.12264], [-118.38202, 34.12279], [-118.38226, 34.12287], [-118.38248, 34.12289], [-118.38268, 34.12287], [-118.38287, 34.12281], [-118.38309, 34.12269], [-118.38322, 34.12258], [-118.38332, 34.12241], [-118.38339, 34.12238], [-118.38346, 34.12237], [-118.38472, 34.12246], [-118.38491, 34.12246], [-118.38504, 34.12244], [-118.38529, 34.12236], [-118.38552, 34.12221], [-118.38568, 34.12204], [-118.38574, 34.12192], [-118.38579, 34.12178], [-118.38586, 34.12172], [-118.38598, 34.12171], [-118.38629, 34.1218], [-118.38642, 34.12188], [-118.38646, 34.12195], [-118.38679, 34.12306], [-118.38691, 34.12326], [-118.38705, 34.1234], [-118.38729, 34.12354], [-118.38757, 34.12362], [-118.38784, 34.12363], [-118.38785, 34.12597], [-118.38775, 34.12605], [-118.38785, 34.12636]]]} | Open Access 1 | 6860 | Fryman Canyon Park | 14218 | 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 | Los Angeles 6 | 64.912 | Fryman Canyon Park | 0 | Recreation Management Area 49 | 4 | |
8231 | 8231 | 8230 | {"type": "Polygon", "coordinates": [[[-118.77876, 34.11244], [-118.77774, 34.11333], [-118.77749, 34.11315], [-118.77722, 34.11301], [-118.77658, 34.11278], [-118.77649, 34.11274], [-118.77632, 34.1126], [-118.77602, 34.11226], [-118.77585, 34.11215], [-118.77572, 34.11211], [-118.7755, 34.1121], [-118.77301, 34.1124], [-118.7749, 34.11069], [-118.77876, 34.11244]]]} | Open Access 1 | 12558 | Peter Strauss Ranch | 14262 | 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/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 14.272 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
8883 | 8883 | 8882 | {"type": "Polygon", "coordinates": [[[-118.78111, 34.11396], [-118.78093, 34.11395], [-118.78079, 34.11396], [-118.77889, 34.11435], [-118.77869, 34.11434], [-118.7785, 34.11428], [-118.77842, 34.11422], [-118.77833, 34.11414], [-118.778, 34.11361], [-118.77788, 34.11347], [-118.77774, 34.11333], [-118.77875, 34.11245], [-118.77875, 34.11243], [-118.7761, 34.11124], [-118.77607, 34.1074], [-118.78036, 34.10736], [-118.78039, 34.11317], [-118.78104, 34.11347], [-118.78111, 34.11396]]]} | Open Access 1 | 14517 | Peter Strauss Ranch | 14262 | 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/samo/planyourvisit/straussranch.htm | Los Angeles 6 | 61.91 | Peter Strauss Ranch | 0 | Recreation Management Area 49 | 4 |
13149 | 13149 | 13148 | {"type": "Polygon", "coordinates": [[[-122.42687, 37.8088], [-122.42684, 37.80881], [-122.42683, 37.80906], [-122.4268, 37.8093], [-122.42674, 37.80949], [-122.42667, 37.80967], [-122.42657, 37.80986], [-122.42642, 37.81007], [-122.42629, 37.81021], [-122.42615, 37.81034], [-122.42596, 37.81048], [-122.42576, 37.81058], [-122.42552, 37.81068], [-122.42532, 37.81074], [-122.42511, 37.81078], [-122.4249, 37.8108], [-122.42466, 37.81079], [-122.42446, 37.81075], [-122.42432, 37.81066], [-122.42427, 37.81059], [-122.42427, 37.81054], [-122.4243, 37.81048], [-122.42439, 37.81041], [-122.42449, 37.8104], [-122.4246, 37.81043], [-122.42466, 37.81049], [-122.42469, 37.81059], [-122.42474, 37.81063], [-122.42506, 37.81062], [-122.42535, 37.81056], [-122.42559, 37.81047], [-122.42582, 37.81035], [-122.42604, 37.81019], [-122.4262, 37.81003], [-122.42631, 37.80989], [-122.42649, 37.80957], [-122.42657, 37.80936], [-122.42661, 37.80919], [-122.42663, 37.80901], [-122.42663, 37.80883], [-122.42445, 37.8091], [-122.42439, 37.80887], [-122.42208, 37.80883], [-122.42194, 37.80818], [-122.42192, 37.80817], [-122.42162, 37.80788], [-122.42154, 37.80749], [-122.42086, 37.80757], [-122.4207, 37.80673], [-122.42249, 37.8065], [-122.42259, 37.80647], [-122.42486, 37.80619], [-122.42485, 37.80609], [-122.4257, 37.80598], [-122.4267, 37.80795], [-122.42687, 37.8088]]]} | Open Access 1 | 35096 | Aquatic Park | 14191 | 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/safr/planyourvisit/aquaticparkcove.htm | San Francisco 13 | 33.068 | Aquatic Park | 1972 | Recreation Management Area 49 | 4 |
14320 | 14320 | 14319 | {"type": "Polygon", "coordinates": [[[-118.71107, 34.10391], [-118.71093, 34.10397], [-118.71061, 34.10414], [-118.71032, 34.10426], [-118.70981, 34.10444], [-118.70927, 34.1046], [-118.70646, 34.10285], [-118.707, 34.10227], [-118.70735, 34.10227], [-118.70735, 34.10256], [-118.70733, 34.10264], [-118.7075, 34.10269], [-118.70754, 34.10261], [-118.70867, 34.10291], [-118.71101, 34.10229], [-118.71099, 34.10357], [-118.71107, 34.10363], [-118.71107, 34.10391]]]} | Open Access 1 | 44376 | King Gillette Ranch | 14239 | 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/samo/planyourvisit/kinggilletteranch.htm | Los Angeles 6 | 15.376 | King Gillette Ranch | 0 | Recreation Management Area 49 | 4 |
16090 | 16090 | 16089 | {"type": "Polygon", "coordinates": [[[-118.75338, 34.07449], [-118.74918, 34.07468], [-118.74905, 34.06713], [-118.74903, 34.06346], [-118.74927, 34.06345], [-118.74935, 34.06348], [-118.74943, 34.06353], [-118.74951, 34.06364], [-118.74963, 34.06373], [-118.75017, 34.06398], [-118.75031, 34.06401], [-118.75074, 34.06406], [-118.75082, 34.0641], [-118.75083, 34.06419], [-118.75066, 34.06433], [-118.75064, 34.06438], [-118.75064, 34.06447], [-118.75066, 34.06452], [-118.75065, 34.06456], [-118.7505, 34.06477], [-118.75045, 34.06487], [-118.75046, 34.065], [-118.75048, 34.06506], [-118.75051, 34.06511], [-118.75062, 34.0652], [-118.75078, 34.06526], [-118.7509, 34.06526], [-118.75097, 34.06524], [-118.75153, 34.06497], [-118.7516, 34.06497], [-118.75165, 34.065], [-118.7519, 34.06549], [-118.75197, 34.06556], [-118.75207, 34.0656], [-118.75251, 34.06555], [-118.75257, 34.0656], [-118.75272, 34.06593], [-118.75277, 34.06598], [-118.75285, 34.06602], [-118.75296, 34.06602], [-118.75316, 34.06595], [-118.75321, 34.06595], [-118.75324, 34.06794], [-118.75319, 34.06799], [-118.75317, 34.06807], [-118.75319, 34.06813], [-118.75325, 34.06821], [-118.75334, 34.07273], [-118.75328, 34.07283], [-118.75327, 34.07292], [-118.75329, 34.073], [-118.75335, 34.07314], [-118.75338, 34.07449]]]} | Open Access 1 | 12313 | Gage Open Space | 14219 | 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 | Los Angeles 6 | 103.318 | Gage OS | 0 | Recreation Management Area 49 | 4 |
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]);