units_with_maps

Table actions

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

1 row where COUNTY = 49 and DES_TP = 39

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
6768 6768 6767 {"type": "MultiPolygon", "coordinates": [[[[-122.01758, 39.22092], [-122.01585, 39.22164], [-122.01612, 39.21947], [-122.01658, 39.2185], [-122.01659, 39.21843], [-122.01758, 39.22092]]], [[[-122.01676, 39.21799], [-122.01582, 39.21993], [-122.01572, 39.22078], [-122.01573, 39.2209], [-122.01552, 39.22089], [-122.01553, 39.22148], [-122.0154, 39.22199], [-122.01579, 39.22203], [-122.01586, 39.22236], [-122.01615, 39.22344], [-122.01628, 39.22437], [-122.01615, 39.22489], [-122.01602, 39.22473], [-122.01425, 39.22597], [-122.01415, 39.2261], [-122.01488, 39.22943], [-122.01523, 39.23092], [-122.01532, 39.23122], [-122.01535, 39.23159], [-122.01533, 39.23161], [-122.01528, 39.23179], [-122.01525, 39.23184], [-122.0088, 39.23564], [-122.00871, 39.23553], [-122.0087, 39.23542], [-122.00859, 39.23547], [-122.0085, 39.23512], [-122.00849, 39.2346], [-122.00805, 39.23379], [-122.00662, 39.23429], [-122.00562, 39.23468], [-122.00429, 39.23538], [-122.00397, 39.23547], [-122.00384, 39.23559], [-122.00384, 39.23567], [-122.00388, 39.23571], [-122.00346, 39.23593], [-122.00337, 39.23583], [-122.00324, 39.2356], [-122.00301, 39.23529], [-122.0028, 39.23505], [-122.00258, 39.23486], [-122.00256, 39.23474], [-122.00231, 39.23453], [-122.0019, 39.23406], [-122.00172, 39.23391], [-122.00145, 39.23378], [-122.0012, 39.2336], [-122.00092, 39.23347], [-122.00056, 39.23336], [-122.00006, 39.23314], [-121.99962, 39.23301], [-121.9993, 39.23281], [-121.99902, 39.23246], [-121.99894, 39.23231], [-121.99887, 39.232], [-121.99888, 39.23153], [-121.99892, 39.23128], [-121.99936, 39.23068], [-121.99959, 39.23053], [-121.99998, 39.23034], [-122.00033, 39.23027], [-122.00096, 39.2302], [-122.00105, 39.2302], [-122.00122, 39.23016], [-122.00226, 39.23018], [-122.00244, 39.23024], [-122.00316, 39.23032], [-122.00351, 39.23031], [-122.00381, 39.23026], [-122.00426, 39.23013], [-122.00437, 39.23012], [-122.00452, 39.23007], [-122.00512, 39.22975], [-122.00526, 39.22964], [-122.00544, 39.22941], [-122.0056, 39.22934], [-122.00581, 39.22919], [-122.00682, 39.22873], [-122.00721, 39.22847], [-122.00737, 39.22829], [-122.00752, 39.22819], [-122.00763, 39.22809], [-122.0078, 39.22766], [-122.00813, 39.22729], [-122.00821, 39.22707], [-122.00821, 39.22687], [-122.00804, 39.22639], [-122.00807, 39.22609], [-122.00799, 39.22584], [-122.0079, 39.22564], [-122.0079, 39.22537], [-122.00786, 39.22514], [-122.00772, 39.22475], [-122.0076, 39.22402], [-122.00756, 39.22366], [-122.00774, 39.22353], [-122.00775, 39.2224], [-122.0078, 39.222], [-122.00794, 39.22168], [-122.0081, 39.22148], [-122.00831, 39.22127], [-122.0087, 39.22108], [-122.00945, 39.22068], [-122.00996, 39.22048], [-122.01041, 39.22028], [-122.01099, 39.21992], [-122.01146, 39.21948], [-122.01182, 39.21904], [-122.01241, 39.21794], [-122.01248, 39.21736], [-122.01256, 39.21723], [-122.01266, 39.21715], [-122.01676, 39.21799]]]]} Open Access 1 5220 Colusa-Sacramento River State Recreation Area 1484 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/default.asp?page_id=461 Colusa 49 364.237 Colusa-Sacramento River SRA 1955 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]);