units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where LAYER = 9 and MNG_AG_LEV = 6 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
DES_TP 4
MNG_AGENCY 3
MNG_AG_TYP 2
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4103 | 4103 | 4102 | {"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59605], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12845, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} | Restricted Access 2 | 47041 | Santa Ines Mission Mill | 30693 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Santa Barbara 7 | 40.009 | Santa Ines Mission Mill | None 356 | ||
8965 | 8965 | 8964 | {"type": "MultiPolygon", "coordinates": [[[[-119.69816, 34.42266], [-119.69776, 34.42304], [-119.69749, 34.4229], [-119.69762, 34.42271], [-119.6973, 34.42248], [-119.69723, 34.42254], [-119.69702, 34.42239], [-119.69735, 34.42208], [-119.69816, 34.42266]]], [[[-119.69831, 34.4219], [-119.69791, 34.42227], [-119.69736, 34.42187], [-119.69751, 34.42172], [-119.69769, 34.42185], [-119.69793, 34.42163], [-119.69799, 34.42166], [-119.69805, 34.42158], [-119.69825, 34.42169], [-119.69815, 34.42178], [-119.69831, 34.4219]]], [[[-119.69897, 34.42326], [-119.69864, 34.42357], [-119.69857, 34.42352], [-119.69836, 34.42374], [-119.69813, 34.42358], [-119.69809, 34.42361], [-119.69771, 34.42334], [-119.69831, 34.42277], [-119.69897, 34.42326]]], [[[-119.69884, 34.42203], [-119.69859, 34.42227], [-119.69834, 34.4221], [-119.69845, 34.42199], [-119.69859, 34.42209], [-119.69873, 34.42195], [-119.69884, 34.42203]]], [[[-119.69995, 34.42208], [-119.69969, 34.42232], [-119.69984, 34.42244], [-119.69966, 34.42265], [-119.69937, 34.42247], [-119.6993, 34.42255], [-119.69935, 34.42259], [-119.69915, 34.42282], [-119.69916, 34.42285], [-119.69897, 34.42303], [-119.69844, 34.42265], [-119.69944, 34.42171], [-119.69995, 34.42208]]]]} | Open Access 1 | 14784 | El Presidio de Santa Barbara State Historic Park | 30636 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.parks.ca.gov/?page_id=608 | Santa Barbara 7 | 5.916 | El Presidio de Santa Barbara SHP | 1966 | State Historic or Cultural Area 132 | 4 |
5042 | 5042 | 5041 | {"type": "MultiPolygon", "coordinates": [[[[-123.70756, 39.31534], [-123.70732, 39.32435], [-123.70281, 39.32434], [-123.70273, 39.3279], [-123.7025, 39.3425], [-123.69791, 39.34255], [-123.68153, 39.34249], [-123.68164, 39.3389], [-123.69333, 39.33887], [-123.69345, 39.33522], [-123.69803, 39.33521], [-123.69818, 39.32792], [-123.69856, 39.31365], [-123.70475, 39.31359], [-123.70436, 39.31314], [-123.70756, 39.31534]]], [[[-123.69822, 39.31365], [-123.69382, 39.31371], [-123.6938, 39.3109], [-123.69419, 39.31055], [-123.69429, 39.31043], [-123.69437, 39.31029], [-123.69446, 39.31008], [-123.69455, 39.30974], [-123.69464, 39.30901], [-123.69474, 39.30875], [-123.69489, 39.30843], [-123.69504, 39.30817], [-123.69517, 39.30802], [-123.69534, 39.30792], [-123.69559, 39.30783], [-123.69587, 39.30779], [-123.69613, 39.30778], [-123.69641, 39.30782], [-123.69686, 39.30795], [-123.69749, 39.30819], [-123.69783, 39.30836], [-123.6979, 39.30841], [-123.69794, 39.30848], [-123.69797, 39.30863], [-123.69798, 39.30885], [-123.69796, 39.30913], [-123.69789, 39.30968], [-123.69772, 39.31065], [-123.69747, 39.31136], [-123.69745, 39.31158], [-123.69749, 39.31212], [-123.69754, 39.31234], [-123.69771, 39.31269], [-123.69809, 39.31316], [-123.69821, 39.31328], [-123.69822, 39.31365]]]]} | Open Access 1 | 45367 | Mendocino Woodlands State Park | 30663 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3373 | Mendocino Woodlands Camp Association 772 | Non Profit 6 | Non Profit - Other 20 | http://www.parks.ca.gov/?page_id=443 | Mendocino 24 | 650.541 | Mendocino Woodlands SP | 1977 | State Park 15 | 4 |
16658 | 16658 | 16657 | {"type": "MultiPolygon", "coordinates": [[[[-123.0767, 38.55966], [-123.07524, 38.56305], [-123.07437, 38.56486], [-123.07367, 38.56642], [-123.06127, 38.56613], [-123.06033, 38.56614], [-123.05927, 38.56941], [-123.05928, 38.56942], [-123.06811, 38.56953], [-123.0656, 38.57548], [-123.0656, 38.57549], [-123.07418, 38.5755], [-123.0737, 38.58223], [-123.07323, 38.58793], [-123.07326, 38.59136], [-123.07328, 38.59164], [-123.06893, 38.59167], [-123.06487, 38.59217], [-123.06484, 38.58862], [-123.06013, 38.5894], [-123.05375, 38.59049], [-123.05371, 38.59053], [-123.04864, 38.5921], [-123.04906, 38.58871], [-123.04896, 38.58724], [-123.04865, 38.58717], [-123.04817, 38.58735], [-123.04811, 38.58705], [-123.048, 38.58702], [-123.04751, 38.58359], [-123.04619, 38.58372], [-123.04608, 38.58326], [-123.04515, 38.57978], [-123.04057, 38.58003], [-123.04009, 38.57801], [-123.03605, 38.57804], [-123.03545, 38.57806], [-123.03599, 38.58033], [-123.02847, 38.5852], [-123.02017, 38.58505], [-123.01617, 38.58502], [-123.01617, 38.58183], [-123.01616, 38.58182], [-123.01404, 38.58186], [-123.01408, 38.58499], [-123.01078, 38.58499], [-123.01081, 38.58112], [-123.00233, 38.58073], [-122.9969, 38.58289], [-122.99333, 38.58121], [-122.99325, 38.57872], [-122.99077, 38.57226], [-122.99085, 38.56825], [-122.99564, 38.56827], [-122.99546, 38.5595], [-122.99521, 38.55207], [-122.99771, 38.55212], [-122.99779, 38.54973], [-122.99803, 38.54973], [-122.99804, 38.54952], [-123.00149, 38.54949], [-123.00119, 38.5451], [-123.00904, 38.54512], [-123.00904, 38.55225], [-123.01367, 38.5522], [-123.01405, 38.5578], [-123.01385, 38.55838], [-123.01394, 38.55945], [-123.01757, 38.55941], [-123.03507, 38.55804], [-123.03549, 38.55803], [-123.03965, 38.55824], [-123.0395, 38.55891], [-123.03949, 38.55907], [-123.03875, 38.56183], [-123.04774, 38.5622], [-123.04865, 38.5587], [-123.04878, 38.5478], [-123.05671, 38.54794], [-123.05731, 38.54793], [-123.07134, 38.54861], [-123.07136, 38.54868], [-123.07204, 38.55945], [-123.0767, 38.55966]], [[-123.01966, 38.57379], [-123.01965, 38.5738], [-123.0202, 38.5778], [-123.02021, 38.58327], [-123.02844, 38.5831], [-123.02804, 38.57314], [-123.01966, 38.57379]]], [[[-123.07594, 38.54551], [-123.07147, 38.54555], [-123.07145, 38.54385], [-123.07153, 38.54362], [-123.07153, 38.54357], [-123.07158, 38.54349], [-123.07171, 38.54336], [-123.07186, 38.54325], [-123.07185, 38.54196], [-123.07588, 38.54192], [-123.07594, 38.54551]]]]} | Open Access 1 | 17520 | Austin Creek State Recreation Area | 30575 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3371 | Stewards of the Coast and Redwoods 1112 | Non Profit 6 | Non Profit - Conservation 12 | http://www.parks.ca.gov/?page_id=452 | Sonoma 16 | 5650.514 | Austin Creek SRA | 1964 | State Recreation Area 39 | 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]);