calands: units_with_maps: 1 row where ACCESS_TYP = 1 and SUID

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

1 row where ACCESS_TYP = 1 and SUID_NMA = 14219

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
16090	16090	16089	{"type": "Polygon", "coordinates": [[[-118.75338, 34.07449], [-118.74918, 34.07468], [-118.74905, 34.06713], [-118.74903, 34.06346], [-118.74927, 34.06345], [-118.74935, 34.06348], [-118.74943, 34.06353], [-118.74951, 34.06364], [-118.74963, 34.06373], [-118.75017, 34.06398], [-118.75031, 34.06401], [-118.75074, 34.06406], [-118.75082, 34.0641], [-118.75083, 34.06419], [-118.75066, 34.06433], [-118.75064, 34.06438], [-118.75064, 34.06447], [-118.75066, 34.06452], [-118.75065, 34.06456], [-118.7505, 34.06477], [-118.75045, 34.06487], [-118.75046, 34.065], [-118.75048, 34.06506], [-118.75051, 34.06511], [-118.75062, 34.0652], [-118.75078, 34.06526], [-118.7509, 34.06526], [-118.75097, 34.06524], [-118.75153, 34.06497], [-118.7516, 34.06497], [-118.75165, 34.065], [-118.7519, 34.06549], [-118.75197, 34.06556], [-118.75207, 34.0656], [-118.75251, 34.06555], [-118.75257, 34.0656], [-118.75272, 34.06593], [-118.75277, 34.06598], [-118.75285, 34.06602], [-118.75296, 34.06602], [-118.75316, 34.06595], [-118.75321, 34.06595], [-118.75324, 34.06794], [-118.75319, 34.06799], [-118.75317, 34.06807], [-118.75319, 34.06813], [-118.75325, 34.06821], [-118.75334, 34.07273], [-118.75328, 34.07283], [-118.75327, 34.07292], [-118.75329, 34.073], [-118.75335, 34.07314], [-118.75338, 34.07449]]]}	Open Access 1	12313	Gage Open Space	14219	108	United States National Park Service 102	Federal 1	Federal Agency 1	http://www.nps.gov/	National Park Service 12	108	United States National Park Service 59	Federal 1	Federal Agency 1		Los Angeles 6	103.318	Gage OS	0	Recreation Management Area 49	4

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