units_with_maps

Table actions

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

2 rows where COUNTY = 32, DES_TP = 19 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 2 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Historic or Cultural Area · 2 ✖

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
3004 3004 3003 {"type": "MultiPolygon", "coordinates": [[[[-119.21773, 38.26101], [-119.21772, 38.26138], [-119.21574, 38.262], [-119.21587, 38.26217], [-119.2175, 38.26167], [-119.21749, 38.26324], [-119.21747, 38.26342], [-119.21741, 38.2636], [-119.21732, 38.26377], [-119.2172, 38.26393], [-119.21705, 38.26407], [-119.21697, 38.26414], [-119.21663, 38.26433], [-119.21626, 38.26448], [-119.21587, 38.26458], [-119.21558, 38.26462], [-119.21324, 38.26461], [-119.21322, 38.26099], [-119.21773, 38.26101]]], [[[-119.21774, 38.26347], [-119.21774, 38.26467], [-119.21634, 38.26465], [-119.21661, 38.26457], [-119.2169, 38.26444], [-119.21718, 38.26428], [-119.21727, 38.26421], [-119.21742, 38.26407], [-119.21754, 38.26391], [-119.21768, 38.26365], [-119.21774, 38.26347]]]]} Open Access 1 20745 Bridgeport Ballfields / Bridgeport Cemetery 16378 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3   Mono 32 36.12 Bridgeport Ballfields / Bridgeport Cemetery 0 Local Historic or Cultural Area 19 4
10885 10885 10884 {"type": "Polygon", "coordinates": [[[-119.13709, 38.02189], [-119.13517, 38.02197], [-119.13505, 38.02141], [-119.13531, 38.02064], [-119.13597, 38.02076], [-119.13709, 38.02189]]]} Open Access 1 20771 Mono Lake Cemetery 22371 309 Mono, County of 538 County 3 County Agency 3 http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas County 3 309 Mono, County of 531 County 3 County Agency 3   Mono 32 4.074 Mono Lake Cemetery 0 Local Historic or Cultural Area 19 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]);