superunits_with_maps

Table actions

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

3 rows where MNG_AGENCY = 25 and YR_EST = 1973

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 3 ✖

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
6707 6707 6706 {"type": "Polygon", "coordinates": [[[-122.84215, 38.09048], [-122.83042, 38.09521], [-122.83018, 38.09487], [-122.82977, 38.09435], [-122.82933, 38.09384], [-122.82886, 38.09336], [-122.82817, 38.09274], [-122.82763, 38.09231], [-122.82705, 38.09189], [-122.82604, 38.09126], [-122.82504, 38.09074], [-122.82139, 38.08918], [-122.82227, 38.08715], [-122.82274, 38.08375], [-122.82367, 38.08274], [-122.82541, 38.08212], [-122.82633, 38.08241], [-122.82694, 38.08241], [-122.82704, 38.0815], [-122.8264, 38.08039], [-122.82589, 38.0802], [-122.82596, 38.08008], [-122.82604, 38.07989], [-122.82605, 38.07977], [-122.82605, 38.07957], [-122.82661, 38.0794], [-122.82704, 38.08011], [-122.83048, 38.07864], [-122.84215, 38.09048]]]} Open Access 1 Tomales Bay Ecological Reserve https://www.wildlife.ca.gov/Lands/Places-to-Visit/Tomales-Bay-ER 32326 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 442.98 Tomales Bay ER 1973
13134 13134 13133 {"type": "MultiPolygon", "coordinates": [[[[-120.24728, 40.54136], [-120.24253, 40.54135], [-120.24248, 40.53404], [-120.24723, 40.53404], [-120.24728, 40.54136]]], [[[-120.3123, 40.54134], [-120.30921, 40.5413], [-120.30917, 40.534], [-120.3103, 40.53399], [-120.31145, 40.53815], [-120.3123, 40.54134]]], [[[-120.32825, 40.5447], [-120.32733, 40.54475], [-120.32705, 40.54483], [-120.3267, 40.545], [-120.32351, 40.54499], [-120.3235, 40.5461], [-120.32317, 40.54631], [-120.32225, 40.54713], [-120.32193, 40.54748], [-120.32178, 40.54769], [-120.32164, 40.54809], [-120.32147, 40.54847], [-120.32131, 40.5486], [-120.31482, 40.54858], [-120.31444, 40.54721], [-120.31409, 40.54622], [-120.31394, 40.54563], [-120.31397, 40.54136], [-120.31285, 40.54132], [-120.312, 40.53818], [-120.3111, 40.53515], [-120.31085, 40.534], [-120.32348, 40.53401], [-120.32347, 40.53764], [-120.32563, 40.53765], [-120.32682, 40.5377], [-120.32822, 40.53766], [-120.32825, 40.5447]]], [[[-120.32352, 40.54861], [-120.32159, 40.5486], [-120.32166, 40.54853], [-120.32185, 40.54814], [-120.32199, 40.54774], [-120.32211, 40.54757], [-120.32242, 40.54723], [-120.32333, 40.54642], [-120.3235, 40.54632], [-120.32352, 40.54861]]], [[[-120.32825, 40.545], [-120.32795, 40.545], [-120.32709, 40.545], [-120.32739, 40.54491], [-120.32825, 40.54487], [-120.32825, 40.545]]]]} Open Access 1 Biscar Wildlife Area https://www.wildlife.ca.gov/Lands/Places-to-Visit/Biscar-WA 30417 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 552.259 Biscar Wildlife Area 1973
15377 15377 15376 {"type": "Polygon", "coordinates": [[[-120.94296, 37.11466], [-120.94318, 37.11526], [-120.9431, 37.11962], [-120.94307, 37.12234], [-120.94301, 37.12458], [-120.94301, 37.12928], [-120.94293, 37.13488], [-120.9429, 37.1384], [-120.94007, 37.13838], [-120.93724, 37.1384], [-120.93717, 37.14381], [-120.92371, 37.14377], [-120.92363, 37.14496], [-120.92348, 37.14886], [-120.92334, 37.15134], [-120.92319, 37.15482], [-120.92308, 37.15733], [-120.92307, 37.15834], [-120.90781, 37.15825], [-120.90514, 37.15822], [-120.90541, 37.15092], [-120.90528, 37.15093], [-120.90021, 37.15091], [-120.89745, 37.15092], [-120.89781, 37.14368], [-120.90571, 37.14368], [-120.90635, 37.13006], [-120.9064, 37.12916], [-120.90653, 37.12915], [-120.90672, 37.12493], [-120.90689, 37.12342], [-120.90689, 37.1213], [-120.90715, 37.11711], [-120.90715, 37.11549], [-120.9072, 37.11453], [-120.90707, 37.11451], [-120.90728, 37.10736], [-120.93218, 37.1073], [-120.93427, 37.10566], [-120.93427, 37.10331], [-120.93527, 37.1042], [-120.93599, 37.10488], [-120.93659, 37.10542], [-120.93624, 37.10627], [-120.93416, 37.10802], [-120.93406, 37.11461], [-120.94296, 37.11466]]]} Open Access 1 Volta Wildlife Area https://www.wildlife.ca.gov/Lands/Places-to-Visit/Volta-WA 30513 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 3793.086 Volta Wildlife Area 1973

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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