units_with_maps

Table actions

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

1 row where DES_TP = 39, MNG_AGENCY = 47 and YR_EST = 1949

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 1 ✖

DES_TP 1

  • State Recreation Area · 1 ✖

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
16643 16643 16642 {"type": "MultiPolygon", "coordinates": [[[[-120.71064, 37.41137], [-120.71033, 37.41164], [-120.71023, 37.41171], [-120.71021, 37.41179], [-120.71045, 37.41221], [-120.71068, 37.41275], [-120.71082, 37.41315], [-120.71082, 37.41343], [-120.7108, 37.4138], [-120.71073, 37.414], [-120.71042, 37.41446], [-120.71023, 37.41462], [-120.70997, 37.41468], [-120.7098, 37.41468], [-120.70954, 37.4146], [-120.70927, 37.41459], [-120.70905, 37.4147], [-120.70879, 37.41547], [-120.70862, 37.41609], [-120.70839, 37.41633], [-120.70804, 37.41653], [-120.70761, 37.41651], [-120.70716, 37.41646], [-120.7068, 37.41639], [-120.70668, 37.41632], [-120.70707, 37.41615], [-120.70789, 37.41564], [-120.70829, 37.41431], [-120.70867, 37.41332], [-120.70864, 37.41249], [-120.70893, 37.41152], [-120.70876, 37.41146], [-120.70886, 37.41135], [-120.71064, 37.41137]]], [[[-120.71347, 37.41563], [-120.71346, 37.41689], [-120.7131, 37.41716], [-120.71202, 37.4173], [-120.7119, 37.41785], [-120.71141, 37.41845], [-120.71067, 37.41842], [-120.70995, 37.41796], [-120.70744, 37.41669], [-120.70763, 37.41672], [-120.70816, 37.41674], [-120.70862, 37.41648], [-120.70889, 37.41618], [-120.70908, 37.41553], [-120.70932, 37.41478], [-120.70954, 37.4148], [-120.7098, 37.41488], [-120.71006, 37.41488], [-120.71041, 37.4148], [-120.71068, 37.41458], [-120.71099, 37.41408], [-120.71109, 37.41383], [-120.71113, 37.41313], [-120.71073, 37.41215], [-120.71053, 37.4118], [-120.71053, 37.41174], [-120.71057, 37.41167], [-120.71074, 37.41152], [-120.71079, 37.41143], [-120.7109, 37.41135], [-120.71224, 37.41135], [-120.71239, 37.41375], [-120.71347, 37.41563]]]]} Open Access 1 16885 McConnell State Recreation Area 1628 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=554 Merced 37 66.96 McConnell SRA 1949 State Recreation Area 39 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]);