units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 59, MNG_AG_TYP = 1 and SUID_NMA = 14297
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AG_TYP 1
- Federal Agency · 1 ✖
MNG_AGENCY 1
- United States National Park Service · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7561 | 7561 | 7560 | {"type": "MultiPolygon", "coordinates": [[[[-118.76195, 34.04539], [-118.76162, 34.05645], [-118.75743, 34.05644], [-118.75751, 34.0541], [-118.75697, 34.05387], [-118.7567, 34.05352], [-118.75623, 34.05348], [-118.75578, 34.05333], [-118.75579, 34.05272], [-118.75336, 34.0527], [-118.75341, 34.05089], [-118.74916, 34.05088], [-118.74927, 34.04267], [-118.74335, 34.04274], [-118.74317, 34.04179], [-118.74338, 34.04174], [-118.74354, 34.04162], [-118.74377, 34.04151], [-118.74396, 34.04136], [-118.74394, 34.03908], [-118.7446, 34.03731], [-118.74363, 34.03578], [-118.74238, 34.03586], [-118.74269, 34.03421], [-118.7428, 34.03421], [-118.74306, 34.03428], [-118.74309, 34.03423], [-118.74346, 34.03434], [-118.74358, 34.03442], [-118.74407, 34.03486], [-118.74399, 34.03495], [-118.74431, 34.03523], [-118.74466, 34.03565], [-118.74469, 34.03574], [-118.74464, 34.0359], [-118.74464, 34.03602], [-118.7447, 34.0362], [-118.7448, 34.03632], [-118.74487, 34.03638], [-118.74501, 34.03645], [-118.74523, 34.0365], [-118.74544, 34.03649], [-118.74566, 34.03643], [-118.74583, 34.03643], [-118.74598, 34.03647], [-118.74632, 34.0366], [-118.74658, 34.0369], [-118.74664, 34.03696], [-118.74685, 34.0371], [-118.74712, 34.03722], [-118.74738, 34.03728], [-118.74753, 34.0373], [-118.74784, 34.0373], [-118.74788, 34.03728], [-118.74788, 34.03721], [-118.74887, 34.03715], [-118.74971, 34.03701], [-118.75006, 34.03706], [-118.75046, 34.03721], [-118.75048, 34.0372], [-118.75132, 34.03756], [-118.75193, 34.03777], [-118.75212, 34.03786], [-118.75228, 34.038], [-118.75229, 34.03802], [-118.75374, 34.03975], [-118.75379, 34.03986], [-118.75395, 34.04055], [-118.75397, 34.04079], [-118.75387, 34.0415], [-118.75383, 34.04158], [-118.75363, 34.04178], [-118.7536, 34.04184], [-118.7536, 34.04194], [-118.75374, 34.0423], [-118.75374, 34.04233], [-118.75373, 34.0424], [-118.7536, 34.04259], [-118.75361, 34.04261], [-118.75374, 34.0426], [-118.75383, 34.0425], [-118.75387, 34.04239], [-118.75387, 34.04227], [-118.75373, 34.04191], [-118.75373, 34.04186], [-118.75394, 34.04165], [-118.75399, 34.04155], [-118.7541, 34.04084], [-118.75408, 34.04051], [-118.75394, 34.03988], [-118.7539, 34.03978], [-118.75383, 34.03967], [-118.75232, 34.03787], [-118.75226, 34.03782], [-118.75203, 34.03769], [-118.75138, 34.03746], [-118.75165, 34.03746], [-118.75166, 34.03744], [-118.7506, 34.03705], [-118.75085, 34.03708], [-118.7512, 34.03724], [-118.75136, 34.03727], [-118.75164, 34.03727], [-118.75195, 34.03722], [-118.75212, 34.03717], [-118.75231, 34.03708], [-118.75254, 34.03688], [-118.75267, 34.0367], [-118.75274, 34.03663], [-118.75288, 34.03657], [-118.75325, 34.03647], [-118.7535, 34.03632], [-118.75357, 34.0363], [-118.75386, 34.0363], [-118.75397, 34.03627], [-118.7543, 34.03612], [-118.75497, 34.03603], [-118.75512, 34.03605], [-118.7554, 34.03611], [-118.75552, 34.0361], [-118.75559, 34.03608], [-118.75598, 34.03589], [-118.75644, 34.03559], [-118.7566, 34.03551], [-118.75688, 34.03543], [-118.75708, 34.03541], [-118.75709, 34.04256], [-118.76194, 34.0425], [-118.76195, 34.04539]]], [[[-118.7616, 34.06711], [-118.75823, 34.06712], [-118.75823, 34.06678], [-118.75945, 34.06511], [-118.75943, 34.06139], [-118.76153, 34.06139], [-118.7616, 34.06711]]], [[[-118.75754, 34.0743], [-118.75338, 34.07449], [-118.75323, 34.06713], [-118.75741, 34.06712], [-118.75754, 34.0743]]]]} | Open Access 1 | 7241 | Solstice Canyon | 14297 | 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/solsticecanyon.htm | Los Angeles 6 | 664.536 | Solstice Canyon | 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]);