units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where AGNCY_TYP = 1, DES_TP = 105 and UNIT_NAME = "Castle Rock National Wildlife Refuge"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • National Wildlife Refuge · 1 ✖

ACCESS_TYP 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
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

CSV options: 

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]);