calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES

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

1 row where ACCESS_TYP = 1, DES_TP = 1405 and LAYER = 9

Search:

descending

This data as json, copyable, CSV (advanced)

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
16457	16457	16456	{"type": "MultiPolygon", "coordinates": [[[[-118.80898, 34.00167], [-118.80844, 34.00168], [-118.80836, 34.00194], [-118.80839, 34.00212], [-118.80832, 34.00218], [-118.8085, 34.00262], [-118.80779, 34.00333], [-118.80764, 34.00318], [-118.80753, 34.00313], [-118.80741, 34.00309], [-118.80721, 34.00309], [-118.80709, 34.00312], [-118.80699, 34.00317], [-118.8068, 34.00334], [-118.80494, 34.00517], [-118.80356, 34.0046], [-118.80388, 34.00424], [-118.8039, 34.00424], [-118.80434, 34.00367], [-118.80467, 34.00312], [-118.80476, 34.00286], [-118.80492, 34.00255], [-118.80497, 34.00249], [-118.80498, 34.00229], [-118.80497, 34.00221], [-118.8049, 34.0021], [-118.80488, 34.00191], [-118.80483, 34.00167], [-118.80481, 34.00149], [-118.80483, 34.00124], [-118.80486, 34.0011], [-118.80492, 34.00097], [-118.805, 34.0009], [-118.80511, 34.00052], [-118.80516, 34.00041], [-118.80533, 34.00029], [-118.80561, 34.00019], [-118.8058, 34.00015], [-118.80622, 34.00019], [-118.80646, 34.0001], [-118.8066, 34.00006], [-118.80683, 34.00012], [-118.80712, 34.00026], [-118.80747, 34.00048], [-118.80755, 34.00051], [-118.80783, 34.00078], [-118.80801, 34.00088], [-118.80854, 34.00135], [-118.80874, 34.00148], [-118.80898, 34.00167]]], [[[-118.81723, 34.01059], [-118.81678, 34.01091], [-118.81662, 34.01076], [-118.81653, 34.01093], [-118.8164, 34.01069], [-118.81631, 34.01073], [-118.81614, 34.01041], [-118.81637, 34.01031], [-118.81671, 34.01008], [-118.81723, 34.01059]]]]}	Open Access 1	8716	Point Dume State Beach	30686	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	378	Los Angeles County Department of Beaches and Harbors, County of 827	County 3	County Agency - Other 8	http://www.parks.ca.gov/?page_id=623	Los Angeles 6	34.961	Point Dume SB	1958	None 1405

Advanced export

JSON shape: default, array, newline-delimited

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