units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 59, MNG_AG_TYP = 1 and SUID_NMA = 29181
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AG_TYP 1
- Federal Agency · 2 ✖
MNG_AGENCY 1
- United States National Park Service · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1113 | 1113 | 1112 | {"type": "Polygon", "coordinates": [[[-118.73237, 34.1556], [-118.72864, 34.16793], [-118.72334, 34.1679], [-118.71987, 34.16808], [-118.71693, 34.16827], [-118.71754, 34.16666], [-118.71792, 34.16425], [-118.71807, 34.16345], [-118.71825, 34.16307], [-118.71827, 34.16239], [-118.71803, 34.16186], [-118.71696, 34.16009], [-118.71788, 34.15822], [-118.72595, 34.15819], [-118.7262, 34.15786], [-118.72658, 34.15744], [-118.72709, 34.15699], [-118.72775, 34.15653], [-118.72802, 34.15639], [-118.72858, 34.15613], [-118.72906, 34.15595], [-118.72947, 34.15583], [-118.72989, 34.15574], [-118.7304, 34.15566], [-118.73095, 34.15561], [-118.73237, 34.1556]]]} | Open Access 1 | 7082 | Cheeseboro and Palo Comado Canyons | 29181 | 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/cheeseboropalocomado.htm | Los Angeles 6 | 337.167 | Cheeseboro and Palo Comado Canyons | 0 | National Recreation Area 54 | 3 |
6915 | 6915 | 6914 | {"type": "MultiPolygon", "coordinates": [[[[-118.76116, 34.21338], [-118.75137, 34.21576], [-118.75136, 34.21575], [-118.75013, 34.21604], [-118.74178, 34.21116], [-118.73201, 34.20859], [-118.72439, 34.19622], [-118.72327, 34.196], [-118.72145, 34.19322], [-118.71982, 34.19311], [-118.71961, 34.19118], [-118.72, 34.19074], [-118.71899, 34.18925], [-118.71886, 34.18763], [-118.71927, 34.18714], [-118.71891, 34.18415], [-118.71921, 34.1828], [-118.7204, 34.18299], [-118.72099, 34.18194], [-118.72014, 34.18161], [-118.71936, 34.18209], [-118.71689, 34.18046], [-118.71619, 34.17737], [-118.71474, 34.17481], [-118.7164, 34.17137], [-118.71647, 34.17044], [-118.71664, 34.16909], [-118.71639, 34.16834], [-118.72834, 34.16794], [-118.72822, 34.17173], [-118.72811, 34.17317], [-118.7283, 34.17549], [-118.72838, 34.17739], [-118.73083, 34.17923], [-118.73281, 34.1814], [-118.73399, 34.18169], [-118.73559, 34.18232], [-118.73556, 34.18263], [-118.73552, 34.18375], [-118.73512, 34.18418], [-118.73519, 34.18473], [-118.73559, 34.18635], [-118.73524, 34.18738], [-118.73513, 34.18809], [-118.73481, 34.18829], [-118.73403, 34.18887], [-118.73415, 34.19222], [-118.7348, 34.19327], [-118.73572, 34.19364], [-118.73533, 34.19471], [-118.73556, 34.19519], [-118.7359, 34.19539], [-118.73664, 34.19545], [-118.73673, 34.19594], [-118.73678, 34.19598], [-118.73683, 34.19615], [-118.74374, 34.20107], [-118.75502, 34.20902], [-118.76116, 34.21338]]], [[[-118.72863, 34.16793], [-118.72863, 34.16793], [-118.7284, 34.16793], [-118.72863, 34.16793], [-118.72863, 34.16793]]]]} | Open Access 1 | 5807 | Cheeseboro and Palo Comado Canyons | 29181 | 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/cheeseboropalocomado.htm | Ventura 8 | 1805.93 | Cheeseboro and Palo Comado Canyons | 0 | National Recreation Area 54 | 3 |
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]);