units_with_maps

Table actions

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

2 rows where COUNTY = 12, DES_TP = 8 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 2 ✖

DES_TP 1

  • State Conservation 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
45 45 44 {"type": "Polygon", "coordinates": [[[-121.58017, 38.00647], [-121.57962, 38.00489], [-121.5792, 38.00424], [-121.57866, 38.00373], [-121.578, 38.00325], [-121.5773, 38.00297], [-121.5765, 38.00275], [-121.57532, 38.00267], [-121.57437, 38.00274], [-121.57366, 38.00284], [-121.57299, 38.00288], [-121.57271, 38.00292], [-121.57084, 38.00265], [-121.56985, 38.00228], [-121.56934, 38.002], [-121.56923, 38.00168], [-121.56976, 38.00083], [-121.57043, 38.0001], [-121.57105, 37.99959], [-121.57179, 37.99931], [-121.57271, 37.99929], [-121.57361, 37.99936], [-121.57459, 37.99948], [-121.57536, 37.99977], [-121.57739, 37.99957], [-121.57899, 37.99906], [-121.57922, 37.99895], [-121.57943, 37.99902], [-121.57968, 38.00053], [-121.57966, 38.0016], [-121.57979, 38.0027], [-121.5798, 38.00342], [-121.57997, 38.00413], [-121.58015, 38.00529], [-121.58017, 38.00647]]]} Open Access 1 104 Rhode Island Wildlife Area 30492 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/Lands/Places-to-Visit/Rhode-Island-WA Contra Costa 12 85.271 Rhode Island Wildlife Area 2002 State Conservation Area 8 2
16588 16588 16587 {"type": "Polygon", "coordinates": [[[-122.08502, 38.04767], [-122.08408, 38.04783], [-122.08258, 38.04779], [-122.08257, 38.0478], [-122.08277, 38.048], [-122.08063, 38.04867], [-122.08033, 38.04836], [-122.07995, 38.04829], [-122.07934, 38.04871], [-122.07613, 38.04893], [-122.07593, 38.04866], [-122.07562, 38.04889], [-122.07444, 38.04899], [-122.07363, 38.04926], [-122.07293, 38.04945], [-122.07168, 38.05038], [-122.07142, 38.05098], [-122.07146, 38.05109], [-122.07226, 38.05157], [-122.07223, 38.05179], [-122.07158, 38.05184], [-122.07135, 38.05202], [-122.0715, 38.05227], [-122.07133, 38.05262], [-122.07098, 38.0527], [-122.07105, 38.05304], [-122.07066, 38.05347], [-122.07052, 38.05352], [-122.07034, 38.05351], [-122.06961, 38.05324], [-122.06941, 38.05294], [-122.06871, 38.05258], [-122.06851, 38.0523], [-122.06696, 38.05237], [-122.0668, 38.05227], [-122.06662, 38.05251], [-122.0662, 38.05266], [-122.06621, 38.0528], [-122.06593, 38.05282], [-122.06539, 38.05309], [-122.05623, 38.03898], [-122.05668, 38.03862], [-122.0702, 38.03475], [-122.07035, 38.03502], [-122.07606, 38.0387], [-122.07679, 38.03882], [-122.08121, 38.04194], [-122.08247, 38.04615], [-122.08282, 38.04611], [-122.08283, 38.04609], [-122.0817, 38.04174], [-122.08277, 38.04078], [-122.08346, 38.04144], [-122.08338, 38.04163], [-122.08502, 38.04767]]]} Open Access 1 25330 Point Edith Wildlife Area 30488 209 California State Lands Commission 75 State 5 State Agency 5 http://www.slc.ca.gov/ Other State 5 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Contra Costa 12 727.388 Point Edith Wildlife Area 1985 State Conservation Area 8 2

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