superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 1, MNG_AG_TYP = 1 and YR_EST = 1965
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 1 ✖
MNG_AGENCY 1
- United States Bureau of Land Management · 1 ✖
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15261 | 15261 | 15260 | {"type": "MultiPolygon", "coordinates": [[[[-118.59486, 34.52118], [-118.5948, 34.52122], [-118.59445, 34.52127], [-118.59421, 34.52144], [-118.59411, 34.52159], [-118.59372, 34.52189], [-118.59042, 34.5219], [-118.59036, 34.51825], [-118.59485, 34.51824], [-118.59486, 34.52118]]], [[[-118.60347, 34.53634], [-118.60339, 34.54007], [-118.59871, 34.54006], [-118.59885, 34.53638], [-118.60347, 34.53634]]], [[[-118.64305, 34.55924], [-118.6334, 34.55921], [-118.63325, 34.55904], [-118.63313, 34.55895], [-118.63308, 34.55888], [-118.63312, 34.55878], [-118.63332, 34.55862], [-118.63334, 34.55856], [-118.63328, 34.55848], [-118.63326, 34.55836], [-118.63331, 34.55816], [-118.63324, 34.55812], [-118.63319, 34.55806], [-118.63306, 34.55804], [-118.63288, 34.55811], [-118.63224, 34.55808], [-118.63175, 34.558], [-118.6316, 34.5579], [-118.63143, 34.5577], [-118.6314, 34.55755], [-118.63145, 34.55735], [-118.63154, 34.55716], [-118.63148, 34.55709], [-118.63126, 34.55701], [-118.63101, 34.55689], [-118.63087, 34.55674], [-118.63086, 34.55667], [-118.63091, 34.55658], [-118.63111, 34.55639], [-118.63166, 34.55604], [-118.63181, 34.55598], [-118.6319, 34.55592], [-118.63195, 34.55586], [-118.63196, 34.55582], [-118.63192, 34.55578], [-118.63184, 34.55575], [-118.63143, 34.5557], [-118.63118, 34.55562], [-118.63107, 34.55556], [-118.63094, 34.55543], [-118.63085, 34.55538], [-118.63068, 34.55546], [-118.63061, 34.55546], [-118.63055, 34.55543], [-118.63052, 34.55538], [-118.63052, 34.55517], [-118.63047, 34.55502], [-118.63047, 34.55488], [-118.63044, 34.55481], [-118.63038, 34.55472], [-118.63016, 34.55454], [-118.63014, 34.55452], [-118.63013, 34.55448], [-118.63015, 34.55445], [-118.63026, 34.55439], [-118.63031, 34.55427], [-118.63031, 34.554], [-118.63035, 34.5539], [-118.63085, 34.55351], [-118.63089, 34.55344], [-118.63088, 34.55341], [-118.63085, 34.55339], [-118.63063, 34.55335], [-118.63048, 34.5533], [-118.63025, 34.55342], [-118.62999, 34.55347], [-118.62998, 34.54746], [-118.63434, 34.54747], [-118.63451, 34.55842], [-118.64304, 34.55841], [-118.64305, 34.55924]]]]} | Open Access 1 | Castaic Lake State Recreation Area | 16945 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 211.101 | Castaic Lake SRA | 1965 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);