units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 2 and DES_TP = 49 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY 4
MNG_AG_TYP 1
DES_TP 1
- Recreation Management Area · 5 ✖
ACCESS_TYP 1
- Restricted Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4135 | 4135 | 4134 | {"type": "Polygon", "coordinates": [[[-122.52305, 38.05524], [-122.52194, 38.05549], [-122.52181, 38.05532], [-122.52157, 38.05523], [-122.52156, 38.0552], [-122.52157, 38.05504], [-122.52156, 38.05494], [-122.52152, 38.05472], [-122.52145, 38.05448], [-122.52158, 38.05436], [-122.52177, 38.05425], [-122.52233, 38.05409], [-122.52305, 38.05524]]]} | Restricted Access 2 | 47183 | United States Coast Guard Park | 30875 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Marin 23 | 3.383 | United States Coast Guard Park | 0 | Recreation Management Area 49 | 4 | |
5852 | 5852 | 5851 | {"type": "Polygon", "coordinates": [[[-121.90637, 36.35669], [-121.90633, 36.35676], [-121.90633, 36.35686], [-121.90629, 36.35697], [-121.90629, 36.35703], [-121.90621, 36.35721], [-121.90613, 36.35728], [-121.90605, 36.35742], [-121.90597, 36.35746], [-121.90593, 36.35753], [-121.90584, 36.3576], [-121.9058, 36.35767], [-121.90564, 36.35774], [-121.90559, 36.35781], [-121.90551, 36.35785], [-121.90547, 36.35792], [-121.90535, 36.35803], [-121.90526, 36.35817], [-121.90518, 36.35824], [-121.90514, 36.35831], [-121.90498, 36.35845], [-121.90481, 36.35845], [-121.90468, 36.35849], [-121.9045, 36.3585], [-121.90434, 36.35864], [-121.9043, 36.35871], [-121.90422, 36.35875], [-121.90418, 36.35882], [-121.90409, 36.35885], [-121.90397, 36.35896], [-121.90389, 36.35907], [-121.90368, 36.35921], [-121.90351, 36.35935], [-121.90343, 36.35939], [-121.90339, 36.35946], [-121.90322, 36.3596], [-121.90318, 36.35967], [-121.9032, 36.36026], [-121.90325, 36.36033], [-121.90325, 36.3604], [-121.90339, 36.3606], [-121.90361, 36.36087], [-121.90361, 36.36094], [-121.9037, 36.36094], [-121.90409, 36.36107], [-121.90418, 36.36114], [-121.90444, 36.36127], [-121.9047, 36.36147], [-121.90475, 36.36157], [-121.90476, 36.36188], [-121.9046, 36.36202], [-121.90426, 36.36217], [-121.90405, 36.36218], [-121.90388, 36.36225], [-121.90379, 36.36225], [-121.90375, 36.36232], [-121.9035, 36.36247], [-121.90342, 36.36254], [-121.90333, 36.36258], [-121.90325, 36.36271], [-121.90317, 36.36279], [-121.90301, 36.363], [-121.90297, 36.3631], [-121.90284, 36.36324], [-121.90276, 36.36338], [-121.9026, 36.36356], [-121.90235, 36.36391], [-121.90223, 36.36412], [-121.9022, 36.36423], [-121.90221, 36.36478], [-121.90226, 36.36488], [-121.90227, 36.36502], [-121.90245, 36.36529], [-121.90258, 36.36546], [-121.90259, 36.36553], [-121.90268, 36.3657], [-121.9027, 36.36626], [-121.90266, 36.36633], [-121.90266, 36.3664], [-121.90258, 36.36657], [-121.90258, 36.36664], [-121.9025, 36.36678], [-121.90242, 36.36685], [-121.90234, 36.36699], [-121.90236, 36.36741], [-121.9024, 36.36748], [-121.9024, 36.36754], [-121.90245, 36.36761], [-121.90245, 36.36768], [-121.9025, 36.36775], [-121.9025, 36.36782], [-121.90255, 36.36789], [-121.90263, 36.36795], [-121.90272, 36.36809], [-121.90282, 36.36815], [-121.90284, 36.36822], [-121.9031, 36.36862], [-121.90316, 36.36876], [-121.90317, 36.36906], [-121.90316, 36.36923], [-121.9031, 36.36949], [-121.90306, 36.36957], [-121.90304, 36.36975], [-121.903, 36.36982], [-121.90298, 36.3701], [-121.90297, 36.37017], [-121.90299, 36.3704], [-121.90304, 36.37048], [-121.90307, 36.3706], [-121.8997, 36.37056], [-121.89579, 36.3698], [-121.89585, 36.36624], [-121.88699, 36.36665], [-121.88768, 36.35894], [-121.87939, 36.35881], [-121.87942, 36.35196], [-121.87442, 36.352], [-121.87452, 36.34856], [-121.87239, 36.34857], [-121.86962, 36.34855], [-121.86981, 36.34513], [-121.87945, 36.3451], [-121.89703, 36.34523], [-121.8972, 36.34544], [-121.89653, 36.35301], [-121.90369, 36.35314], [-121.90372, 36.35323], [-121.90364, 36.35334], [-121.90343, 36.35336], [-121.90334, 36.35342], [-121.90324, 36.35358], [-121.90323, 36.35373], [-121.90334, 36.35398], [-121.90343, 36.35415], [-121.90343, 36.35423], [-121.90358, 36.35463], [-121.90358, 36.35472], [-121.90371, 36.35495], [-121.90374, 36.35521], [-121.90383, 36.35537], [-121.90416, 36.35584], [-121.90419, 36.35592], [-121.9042, 36.35608], [-121.90424, 36.35616], [-121.9044, 36.35634], [-121.90462, 36.3565], [-121.90471, 36.35652], [-121.90505, 36.3565], [-121.90534, 36.35639], [-121.90546, 36.35637], [-121.90588, 36.3564], [-121.9061, 36.35646], [-121.90634, 36.35656], [-121.90637, 36.35669]]]} | Restricted Access 2 | 186 | Brazil Ranch | 16339 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Monterey 14 | 1184.534 | Brazil 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 | |
10252 | 10252 | 10251 | {"type": "Polygon", "coordinates": [[[-121.86631, 36.59322], [-121.85952, 36.59448], [-121.85921, 36.5945], [-121.85903, 36.59448], [-121.85883, 36.59442], [-121.85868, 36.59434], [-121.85851, 36.59421], [-121.85843, 36.59412], [-121.85764, 36.59307], [-121.85748, 36.59291], [-121.85732, 36.59282], [-121.85709, 36.59273], [-121.85687, 36.5927], [-121.85665, 36.5927], [-121.85663, 36.59253], [-121.85822, 36.59018], [-121.86078, 36.58966], [-121.86079, 36.58964], [-121.86073, 36.58945], [-121.86357, 36.58887], [-121.86307, 36.58725], [-121.86422, 36.58747], [-121.86449, 36.58758], [-121.86472, 36.58774], [-121.86485, 36.58787], [-121.86495, 36.588], [-121.86501, 36.58812], [-121.86518, 36.58858], [-121.86586, 36.58955], [-121.86628, 36.59047], [-121.86634, 36.59125], [-121.86631, 36.59322]]]} | Restricted Access 2 | 17943 | Monterey Pines Golf Course | 33062 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 102.653 | Monterey Pines GC | 0 | Recreation Management Area 49 | 4 | |
15677 | 15677 | 15676 | {"type": "MultiPolygon", "coordinates": [[[[-117.10566, 32.79376], [-117.10471, 32.79491], [-117.10095, 32.79737], [-117.09926, 32.79946], [-117.09919, 32.80154], [-117.09938, 32.80248], [-117.10023, 32.80247], [-117.10057, 32.80525], [-117.09796, 32.8068], [-117.09627, 32.80827], [-117.09628, 32.80812], [-117.09632, 32.80799], [-117.0964, 32.80786], [-117.09665, 32.8076], [-117.09673, 32.80748], [-117.09679, 32.80731], [-117.09688, 32.80696], [-117.09698, 32.80677], [-117.09716, 32.80655], [-117.0972, 32.80644], [-117.09722, 32.80635], [-117.09721, 32.8062], [-117.09717, 32.80608], [-117.09689, 32.8056], [-117.09685, 32.80547], [-117.09686, 32.80531], [-117.09697, 32.8051], [-117.09705, 32.80484], [-117.097, 32.8045], [-117.097, 32.80439], [-117.09705, 32.80422], [-117.09705, 32.80407], [-117.097, 32.80394], [-117.09683, 32.80359], [-117.0968, 32.80341], [-117.09682, 32.80323], [-117.09692, 32.80297], [-117.09692, 32.80282], [-117.09688, 32.80262], [-117.09684, 32.8025], [-117.09599, 32.80251], [-117.09513, 32.8006], [-117.09522, 32.79697], [-117.09603, 32.7952], [-117.10024, 32.79307], [-117.10151, 32.79253], [-117.10383, 32.79159], [-117.10383, 32.7909], [-117.10444, 32.79089], [-117.10491, 32.79081], [-117.10498, 32.79113], [-117.10499, 32.79133], [-117.1049, 32.79146], [-117.10488, 32.79161], [-117.10515, 32.79234], [-117.10517, 32.79254], [-117.10517, 32.79275], [-117.10513, 32.79294], [-117.10508, 32.7931], [-117.105, 32.79328], [-117.10502, 32.79346], [-117.10508, 32.7935], [-117.10522, 32.79349], [-117.10566, 32.79376]]], [[[-117.09604, 32.80847], [-117.09592, 32.80858], [-117.09529, 32.80942], [-117.09358, 32.81096], [-117.09346, 32.8143], [-117.09266, 32.81502], [-117.09264, 32.81504], [-117.09251, 32.81505], [-117.0881, 32.8155], [-117.08204, 32.8097], [-117.08135, 32.80787], [-117.08322, 32.8068], [-117.0853, 32.80616], [-117.09164, 32.80733], [-117.09602, 32.80672], [-117.09604, 32.80847]]]]} | Restricted Access 2 | 12871 | Admiral Baker Golf Course | 31857 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | https://www.golfnow.com/courses/1027561-admiral-baker-golf-course-north-course-details | San Diego 4 | 409.719 | Admiral Baker GC | 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]);