units_with_maps

Table actions

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

1 row where AGNCY_LEV = 5, AGNCY_WEB = "http://www.parks.ca.gov/" and DES_TP = 850

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 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
9826 9826 9825 {"type": "MultiPolygon", "coordinates": [[[[-121.91219, 36.56857], [-121.91123, 36.5683], [-121.91108, 36.56762], [-121.91105, 36.56707], [-121.91065, 36.5649], [-121.91017, 36.56418], [-121.91037, 36.56395], [-121.91008, 36.56346], [-121.90961, 36.56327], [-121.90942, 36.56284], [-121.90903, 36.56204], [-121.90847, 36.56144], [-121.90782, 36.56089], [-121.90742, 36.56071], [-121.90669, 36.55928], [-121.90585, 36.55863], [-121.90484, 36.55822], [-121.90469, 36.55735], [-121.90429, 36.55682], [-121.90401, 36.55626], [-121.90434, 36.55495], [-121.90465, 36.55341], [-121.90432, 36.5527], [-121.90501, 36.55087], [-121.90518, 36.55003], [-121.90553, 36.54902], [-121.90565, 36.54784], [-121.90602, 36.54689], [-121.90573, 36.545], [-121.90586, 36.54402], [-121.90582, 36.54395], [-121.90574, 36.54391], [-121.90573, 36.54384], [-121.90686, 36.54383], [-121.90735, 36.54379], [-121.90776, 36.54368], [-121.90808, 36.54357], [-121.9082, 36.54356], [-121.90833, 36.54361], [-121.90835, 36.54401], [-121.90845, 36.54417], [-121.90749, 36.54437], [-121.90728, 36.54489], [-121.90728, 36.5453], [-121.90764, 36.54636], [-121.90754, 36.54714], [-121.90769, 36.54835], [-121.90765, 36.55077], [-121.90574, 36.55393], [-121.90528, 36.55507], [-121.90512, 36.55553], [-121.90513, 36.55641], [-121.90548, 36.55669], [-121.90526, 36.55693], [-121.9069, 36.558], [-121.90756, 36.55788], [-121.90788, 36.5581], [-121.90869, 36.55849], [-121.90912, 36.55886], [-121.90924, 36.55913], [-121.90953, 36.55941], [-121.91054, 36.56218], [-121.91149, 36.56218], [-121.9114, 36.56234], [-121.91133, 36.56256], [-121.91128, 36.56273], [-121.91123, 36.563], [-121.91121, 36.56336], [-121.91124, 36.56362], [-121.91128, 36.5638], [-121.91141, 36.56414], [-121.91153, 36.56439], [-121.9123, 36.56549], [-121.91244, 36.56573], [-121.91258, 36.56606], [-121.91262, 36.56623], [-121.91267, 36.56649], [-121.91267, 36.56685], [-121.91262, 36.56719], [-121.91254, 36.56745], [-121.9123, 36.56813], [-121.91219, 36.56857]]], [[[-121.90999, 36.53947], [-121.90993, 36.53961], [-121.9083, 36.54156], [-121.90802, 36.54224], [-121.90795, 36.54252], [-121.90803, 36.54259], [-121.90813, 36.54329], [-121.90818, 36.54335], [-121.90755, 36.54355], [-121.90716, 36.54364], [-121.90679, 36.54365], [-121.90641, 36.54363], [-121.9051, 36.54372], [-121.90508, 36.54348], [-121.90594, 36.54347], [-121.90601, 36.54346], [-121.90607, 36.54342], [-121.9061, 36.54337], [-121.90638, 36.54271], [-121.90698, 36.54197], [-121.9082, 36.54074], [-121.90952, 36.53918], [-121.90989, 36.53936], [-121.90997, 36.53941], [-121.90999, 36.53947]]], [[[-121.91235, 36.53624], [-121.9118, 36.53681], [-121.91158, 36.53712], [-121.91134, 36.53758], [-121.91109, 36.53814], [-121.911, 36.53829], [-121.91077, 36.53861], [-121.91026, 36.53919], [-121.91022, 36.53923], [-121.91014, 36.53923], [-121.90973, 36.53901], [-121.91205, 36.53616], [-121.91228, 36.5362], [-121.91235, 36.53624]]]]} No Public Access 3 16787 Hatton Canyon 19737 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   Monterey 14 126.188 Hatton Canyon 2002 None 850  

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