superunits_with_maps

Table actions

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

5 rows where LAYER = 3, MNG_AGENCY = 345 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 5 ✖

MNG_AGENCY 1

  • Imperial, County of · 5 ✖

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
7886 7886 7885 {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} Open Access 1 Palo Verde County Park   23359 302 Imperial, County of 345 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 13.919 Palo Verde County Park  
11812 11812 11811 {"type": "Polygon", "coordinates": [[[-116.01947, 32.74748], [-116.01802, 32.74819], [-116.01696, 32.74871], [-116.01696, 32.74748], [-116.01947, 32.74748]]]} Open Access 1 Ocotillo Community Park   28449 302 Imperial, County of 345 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 3.973 Ocotillo Community Park 2007
14005 14005 14004 {"type": "Polygon", "coordinates": [[[-115.69029, 32.78595], [-115.68677, 32.78484], [-115.68075, 32.78206], [-115.68075, 32.78136], [-115.68028, 32.78091], [-115.67977, 32.7807], [-115.67682, 32.77663], [-115.67557, 32.77482], [-115.67435, 32.77444], [-115.67435, 32.77433], [-115.67607, 32.77424], [-115.67688, 32.77433], [-115.67741, 32.77427], [-115.68059, 32.77846], [-115.68065, 32.77892], [-115.68081, 32.77894], [-115.6808, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-115.69029, 32.78595]], [[-115.68079, 32.78029], [-115.68077, 32.78029], [-115.68076, 32.78077], [-115.68078, 32.78079], [-115.68079, 32.78029]]]} Open Access 1 Sunbeam Lake Park https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam 32576 302 Imperial, County of 345 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 154.407 Sunbeam Lake Park  
14006 14006 14005 {"type": "Polygon", "coordinates": [[[-115.69473, 32.7933], [-115.69278, 32.7933], [-115.69278, 32.79285], [-115.6934, 32.79284], [-115.69339, 32.79247], [-115.69472, 32.79247], [-115.69473, 32.7933]]]} Open Access 1 Robert Bates Memorial Park http://www.seeleywaterdistrict.com/updates/robert-bates-memorial-park-upgrades 32577 302 Imperial, County of 345 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 3.527 Robert Bates Memorial Park  
14406 14406 14405 {"type": "MultiPolygon", "coordinates": [[[[-114.72351, 33.36382], [-114.72351, 33.36382], [-114.72214, 33.36582], [-114.7221, 33.36382], [-114.72351, 33.36382]]], [[[-114.73058, 33.37111], [-114.72656, 33.37111], [-114.7265, 33.36719], [-114.72216, 33.36718], [-114.72215, 33.36635], [-114.72389, 33.36382], [-114.73052, 33.36382], [-114.73058, 33.37111]]], [[[-114.73064, 33.37842], [-114.72848, 33.37842], [-114.72845, 33.3749], [-114.73062, 33.3749], [-114.73064, 33.37842]]], [[[-114.74359, 33.38218], [-114.74357, 33.38602], [-114.73924, 33.38605], [-114.73926, 33.38223], [-114.74359, 33.38218]]], [[[-114.75277, 33.39501], [-114.75277, 33.39725], [-114.75115, 33.39723], [-114.75113, 33.39677], [-114.74792, 33.39672], [-114.74793, 33.39445], [-114.7506, 33.39452], [-114.75062, 33.39407], [-114.75223, 33.39411], [-114.75224, 33.39499], [-114.75277, 33.39501]]]]} Open Access 1 Unnamed Site - Imperial, County of   33710 302 Imperial, County of 345 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 202.853    

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