units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 54 and PARK_URL = "http://www.nps.gov/samo/planyourvisit/solsticecanyon.htm"
This data as json, copyable, CSV (advanced)
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 |
8305 | 8305 | 8304 | {"type": "Polygon", "coordinates": [[[-118.77471, 34.06273], [-118.7747, 34.06488], [-118.77445, 34.06486], [-118.77447, 34.06468], [-118.77443, 34.0646], [-118.77436, 34.06455], [-118.77319, 34.06472], [-118.77312, 34.06476], [-118.77306, 34.06483], [-118.77302, 34.0649], [-118.77301, 34.06505], [-118.77293, 34.06506], [-118.77242, 34.06439], [-118.77233, 34.06435], [-118.77224, 34.06435], [-118.77199, 34.06442], [-118.77192, 34.06441], [-118.77186, 34.06437], [-118.77183, 34.06424], [-118.77177, 34.06418], [-118.77149, 34.06407], [-118.77142, 34.06401], [-118.77141, 34.06391], [-118.77168, 34.06353], [-118.7717, 34.06346], [-118.77171, 34.06334], [-118.77166, 34.0632], [-118.77133, 34.0626], [-118.77132, 34.06224], [-118.7713, 34.06224], [-118.7712, 34.06249], [-118.77144, 34.06331], [-118.77142, 34.06333], [-118.77135, 34.06332], [-118.77109, 34.06287], [-118.77101, 34.06282], [-118.77093, 34.06281], [-118.77087, 34.06283], [-118.77053, 34.06302], [-118.77043, 34.06312], [-118.77033, 34.06328], [-118.77027, 34.06335], [-118.77025, 34.06184], [-118.77242, 34.06182], [-118.77243, 34.06271], [-118.77471, 34.06273]]]} | Open Access 1 | 12728 | Upper Solstice Canyon | 14300 | 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 | 20.51 | Upper 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]);