units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 1, MNG_AGENCY = 44 and UNIT_NAME = "Castle Rock National Wildlife Refuge"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15849 | 15849 | 15848 | {"type": "Polygon", "coordinates": [[[-124.25085, 41.76226], [-124.25081, 41.76229], [-124.25077, 41.7623], [-124.25072, 41.76226], [-124.25067, 41.76226], [-124.25064, 41.76227], [-124.25063, 41.76234], [-124.2506, 41.7624], [-124.25053, 41.76244], [-124.25041, 41.76247], [-124.25008, 41.7625], [-124.24997, 41.76247], [-124.24989, 41.76242], [-124.24986, 41.76236], [-124.24985, 41.76218], [-124.24981, 41.7621], [-124.24977, 41.76208], [-124.24975, 41.76208], [-124.24967, 41.76225], [-124.2496, 41.76235], [-124.24939, 41.76252], [-124.24929, 41.76254], [-124.24919, 41.76254], [-124.24898, 41.76245], [-124.24892, 41.76245], [-124.24886, 41.76246], [-124.24882, 41.76254], [-124.24875, 41.76257], [-124.24867, 41.76257], [-124.24867, 41.76249], [-124.2485, 41.76245], [-124.2484, 41.76239], [-124.24826, 41.76225], [-124.24809, 41.76225], [-124.24794, 41.76218], [-124.24782, 41.76218], [-124.24772, 41.76218], [-124.24762, 41.76223], [-124.24755, 41.76224], [-124.24747, 41.76224], [-124.24739, 41.76214], [-124.2474, 41.76205], [-124.24737, 41.76198], [-124.24733, 41.76191], [-124.2472, 41.76179], [-124.24741, 41.76173], [-124.24752, 41.76169], [-124.24757, 41.76161], [-124.24754, 41.76147], [-124.24759, 41.76135], [-124.24759, 41.76108], [-124.24765, 41.76105], [-124.24783, 41.76103], [-124.24787, 41.76096], [-124.24787, 41.76078], [-124.24789, 41.76073], [-124.24797, 41.76074], [-124.24801, 41.76076], [-124.24806, 41.76076], [-124.24812, 41.76069], [-124.24817, 41.76068], [-124.24827, 41.76072], [-124.24833, 41.76071], [-124.24845, 41.76065], [-124.24853, 41.76064], [-124.24863, 41.7605], [-124.24875, 41.76027], [-124.24895, 41.76025], [-124.24904, 41.76021], [-124.24916, 41.76019], [-124.24919, 41.76022], [-124.24921, 41.76028], [-124.24919, 41.76034], [-124.24902, 41.76039], [-124.24899, 41.76046], [-124.24899, 41.76053], [-124.24898, 41.76057], [-124.24885, 41.76061], [-124.24881, 41.76065], [-124.24883, 41.76068], [-124.24896, 41.7608], [-124.24895, 41.76087], [-124.24893, 41.76093], [-124.24895, 41.76098], [-124.24918, 41.76115], [-124.24926, 41.76115], [-124.2495, 41.76104], [-124.24972, 41.76097], [-124.24983, 41.7609], [-124.24985, 41.76084], [-124.25011, 41.7606], [-124.25018, 41.76058], [-124.25023, 41.76058], [-124.25044, 41.76078], [-124.25059, 41.76078], [-124.25077, 41.76069], [-124.25089, 41.76069], [-124.25099, 41.76072], [-124.25115, 41.76078], [-124.25131, 41.76089], [-124.25145, 41.76104], [-124.25155, 41.76118], [-124.25158, 41.76131], [-124.25154, 41.76152], [-124.25148, 41.76161], [-124.25138, 41.76169], [-124.25124, 41.76177], [-124.25107, 41.76181], [-124.25087, 41.76198], [-124.25081, 41.76205], [-124.25085, 41.76221], [-124.25085, 41.76226]]]} | No Public Access 3 | 29382 | Castle Rock National Wildlife Refuge | 16954 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Del Norte 50 | 13.708 | Castle Rock NWR | 1979 | National Wildlife Refuge 105 | 2 |
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]);