units_with_maps

Table actions

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

5 rows where COUNTY = 20 and MNG_AGENCY = 345

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • Imperial, County of · 5 ✖

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
1333 1333 1332 {"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 7580 Palo Verde County Park 23359 302 Imperial, County of 348 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 302 Imperial, County of 345 County 3 County Agency 3   Imperial 20 13.919 Palo Verde County Park 0 Local Park 2 4
4828 4828 4827 {"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.75114, 33.39677], [-114.74792, 33.39672], [-114.74793, 33.39445], [-114.75061, 33.39452], [-114.75062, 33.39407], [-114.75223, 33.39411], [-114.75223, 33.395], [-114.75277, 33.39501]]]]} Open Access 1 49012 Unnamed Site - Imperial, County of 33710 302 Imperial, County of 348 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 302 Imperial, County of 345 County 3 County Agency 3   Imperial 20 202.814   0 Local Other or Unknown 14 4
5232 5232 5231 {"type": "Polygon", "coordinates": [[[-115.67682, 32.77663], [-115.67556, 32.77481], [-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.68079, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-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.68079, 32.78028], [-115.68077, 32.78028], [-115.68076, 32.78078], [-115.68079, 32.78081], [-115.68079, 32.78028]]]} Open Access 1 48074 Sunbeam Lake Park 32576 302 Imperial, County of 348 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 302 Imperial, County of 345 County 3 County Agency 3 https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam Imperial 20 154.391 Sunbeam Lake Park 0 Local Park 2 4
5233 5233 5232 {"type": "Polygon", "coordinates": [[[-115.69473, 32.7933], [-115.69278, 32.7933], [-115.69278, 32.79285], [-115.69341, 32.79284], [-115.69339, 32.79247], [-115.69472, 32.79247], [-115.69473, 32.7933]]]} Open Access 1 48075 Robert Bates Memorial Park 32577 302 Imperial, County of 348 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 302 Imperial, County of 345 County 3 County Agency 3 http://www.seeleywaterdistrict.com/updates/robert-bates-memorial-park-upgrades Imperial 20 3.525 Robert Bates Memorial Park 0 Local Park 2 4
14960 14960 14959 {"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 45623 Ocotillo Community Park 28449 302 Imperial, County of 348 County 3 County Agency 3 http://www.icpds.com/?pid=1048 County 3 302 Imperial, County of 345 County 3 County Agency 3   Imperial 20 3.974 Ocotillo Community Park 2007 Local Park 2 4

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