units_with_maps

Table actions

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

2 rows where MNG_AG_TYP = 1 and PARK_URL = "http://www.fws.gov/refuge/stone_lakes/"

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • Federal Agency · 2 ✖
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
15825 15825 15824 {"type": "MultiPolygon", "coordinates": [[[[-121.47105, 38.35012], [-121.46407, 38.35017], [-121.46402, 38.34546], [-121.46413, 38.34545], [-121.46394, 38.33939], [-121.46876, 38.33911], [-121.47105, 38.35012]]], [[[-121.50976, 38.36471], [-121.50932, 38.36497], [-121.50925, 38.36406], [-121.50915, 38.36315], [-121.50902, 38.36224], [-121.50827, 38.35776], [-121.50809, 38.35774], [-121.50777, 38.35581], [-121.50794, 38.35579], [-121.50791, 38.35561], [-121.50801, 38.35559], [-121.50705, 38.34985], [-121.50695, 38.34984], [-121.50694, 38.34981], [-121.50132, 38.34978], [-121.50101, 38.34974], [-121.50054, 38.34973], [-121.50024, 38.34969], [-121.49774, 38.34967], [-121.49781, 38.34858], [-121.49885, 38.34766], [-121.49929, 38.34611], [-121.49096, 38.34607], [-121.49092, 38.34239], [-121.4909, 38.34231], [-121.49076, 38.32093], [-121.49636, 38.32096], [-121.49638, 38.32055], [-121.5012, 38.32057], [-121.50242, 38.32787], [-121.50369, 38.32788], [-121.50491, 38.3352], [-121.50497, 38.33521], [-121.50872, 38.3577], [-121.50867, 38.35771], [-121.50944, 38.36211], [-121.50967, 38.36368], [-121.50976, 38.36471]]], [[[-121.50109, 38.35764], [-121.50084, 38.36476], [-121.49622, 38.36469], [-121.49609, 38.37119], [-121.49574, 38.37128], [-121.49544, 38.37129], [-121.48983, 38.37282], [-121.48916, 38.37298], [-121.48893, 38.36986], [-121.48853, 38.36862], [-121.48864, 38.36598], [-121.48843, 38.36472], [-121.4885, 38.36472], [-121.48871, 38.36596], [-121.48899, 38.36595], [-121.4888, 38.36472], [-121.48899, 38.36186], [-121.49096, 38.35817], [-121.49308, 38.35702], [-121.50107, 38.35702], [-121.50106, 38.35763], [-121.50109, 38.35764]]], [[[-121.50184, 38.41602], [-121.50166, 38.41632], [-121.50152, 38.41663], [-121.50144, 38.41695], [-121.5014, 38.41728], [-121.50142, 38.42955], [-121.50134, 38.42957], [-121.50133, 38.43045], [-121.50142, 38.43046], [-121.50142, 38.43053], [-121.48891, 38.43054], [-121.48947, 38.429], [-121.48964, 38.42828], [-121.48955, 38.42756], [-121.48888, 38.42657], [-121.48787, 38.4259], [-121.48769, 38.42587], [-121.48733, 38.42418], [-121.4871, 38.42222], [-121.48676, 38.42107], [-121.4859, 38.41689], [-121.4858, 38.41654], [-121.48563, 38.41606], [-121.48585, 38.41604], [-121.50086, 38.41604], [-121.50184, 38.41602]]]]} Open Access 1 21636 Stone Lakes National Wildlife Refuge 1758 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 http://www.fws.gov/refuge/stone_lakes/ Sacramento 41 1878.711 Stone Lakes NWR 1994 National Wildlife Refuge 105 2
15844 15844 15843 {"type": "MultiPolygon", "coordinates": [[[[-121.50142, 38.43053], [-121.50116, 38.4307], [-121.50116, 38.43311], [-121.49772, 38.43419], [-121.49635, 38.43742], [-121.49086, 38.43957], [-121.48897, 38.43056], [-121.48891, 38.43054], [-121.50142, 38.43053]]], [[[-121.50288, 38.31759], [-121.50237, 38.31765], [-121.50282, 38.32038], [-121.50191, 38.32038], [-121.50147, 38.31774], [-121.50137, 38.31774], [-121.49836, 38.29949], [-121.49887, 38.29944], [-121.49888, 38.29943], [-121.49573, 38.28032], [-121.49674, 38.28031], [-121.50288, 38.31759]]]]} No Public Access 3 44499 Stone Lakes National Wildlife Refuge 31515 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 http://www.fws.gov/refuge/stone_lakes/ Sacramento 41 288.103 Stone Lakes NWR 1994 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]);