units_with_maps

Table actions

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

1 row where COUNTY = 10 and DES_TP = 82

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Resource Management 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
14887 14887 14886 {"type": "MultiPolygon", "coordinates": [[[[-115.84467, 33.44136], [-115.84378, 33.44134], [-115.84249, 33.44141], [-115.84235, 33.43774], [-115.83853, 33.43771], [-115.83832, 33.43152], [-115.8344, 33.43151], [-115.83435, 33.4269], [-115.8523, 33.42677], [-115.85247, 33.42767], [-115.85237, 33.43948], [-115.85237, 33.44124], [-115.86815, 33.44098], [-115.86949, 33.44092], [-115.8695, 33.44116], [-115.87012, 33.44116], [-115.87012, 33.45559], [-115.88728, 33.45568], [-115.8871, 33.46767], [-115.88724, 33.47011], [-115.88471, 33.47014], [-115.88271, 33.46908], [-115.88261, 33.46664], [-115.87832, 33.4667], [-115.87833, 33.46522], [-115.8784, 33.46311], [-115.87517, 33.46304], [-115.86993, 33.4594], [-115.87011, 33.45559], [-115.8638, 33.45578], [-115.85927, 33.45337], [-115.85227, 33.45336], [-115.85221, 33.44921], [-115.85218, 33.44525], [-115.85209, 33.44125], [-115.84467, 33.44136]]], [[[-115.90481, 33.48469], [-115.90028, 33.48473], [-115.89998, 33.48472], [-115.89915, 33.48471], [-115.89558, 33.48097], [-115.89542, 33.47805], [-115.89149, 33.47779], [-115.89145, 33.47414], [-115.88874, 33.47413], [-115.88731, 33.47291], [-115.88727, 33.47025], [-115.90459, 33.47015], [-115.90454, 33.48114], [-115.90481, 33.48469]]]]} Open Access 1 45425 Salton Sea 28206 103 United States Bureau of Reclamation 369 Federal 1 Federal Agency 1 http://www.usbr.gov/ Other Federal 13 103 United States Bureau of Reclamation 364 Federal 1 Federal Agency 1   Riverside 10 1996.182 Salton Sea 0 Resource Management Area 82 3

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