calands: units_with_maps: 2 rows where ACCESS_TYP = 1 and UNIT

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

2 rows where ACCESS_TYP = 1 and UNIT_NAME = "Arroyo Pescadero"

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
1106	1106	1105	{"type": "MultiPolygon", "coordinates": [[[[-118.01025, 33.96928], [-118.00905, 33.97078], [-118.0088, 33.97086], [-118.00826, 33.97078], [-118.00887, 33.97002], [-118.00795, 33.9695], [-118.00792, 33.9694], [-118.00843, 33.96896], [-118.00845, 33.96883], [-118.00937, 33.96935], [-118.00969, 33.96896], [-118.01025, 33.96928]]], [[[-118.01077, 33.9639], [-118.01053, 33.9642], [-118.01004, 33.96394], [-118.01029, 33.9636], [-118.01076, 33.96386], [-118.01077, 33.9639]]]]}	Open Access 1	6522	Arroyo Pescadero	28934	1380	Whittier, City of 291	City 2	City Agency 2	http://www.cityofwhittier.org/depts/prcs/default.asp	City 2	1380	Whittier, City of 287	City 2	City Agency 2	http://www.habitatauthority.org/trails/	Los Angeles 6	6.285	Arroyo Pescadero		None 100
15282	15282	15281	{"type": "MultiPolygon", "coordinates": [[[[-118.01566, 33.97164], [-118.01565, 33.97527], [-118.01129, 33.97522], [-118.01115, 33.98076], [-118.01084, 33.98063], [-118.01028, 33.98102], [-118.00999, 33.982], [-118.01005, 33.9824], [-117.9948, 33.9824], [-117.99477, 33.9823], [-117.99471, 33.9822], [-117.99452, 33.98203], [-117.99442, 33.98198], [-117.99428, 33.98195], [-117.99397, 33.98193], [-117.99359, 33.98169], [-117.99375, 33.97568], [-117.99376, 33.97516], [-117.9848, 33.97512], [-117.98554, 33.97458], [-117.98606, 33.97426], [-117.98662, 33.97397], [-117.98857, 33.97305], [-117.98896, 33.97284], [-117.98942, 33.97254], [-117.98976, 33.97228], [-117.99001, 33.97207], [-117.99024, 33.97185], [-117.99173, 33.97028], [-117.9921, 33.96997], [-117.99243, 33.96974], [-117.99382, 33.9689], [-117.99382, 33.96927], [-117.99384, 33.96928], [-117.9948, 33.96871], [-117.99517, 33.96823], [-117.99565, 33.96816], [-117.99626, 33.96747], [-117.99656, 33.96738], [-117.99668, 33.96732], [-117.99694, 33.96746], [-117.99761, 33.96689], [-117.99784, 33.9669], [-117.9991, 33.9668], [-118.00017, 33.9661], [-118.00034, 33.9661], [-118.00104, 33.96561], [-118.00152, 33.96516], [-118.00193, 33.96458], [-118.00592, 33.96477], [-118.00774, 33.96578], [-118.00796, 33.96556], [-118.00827, 33.96532], [-118.00839, 33.96528], [-118.00875, 33.96504], [-118.00875, 33.96502], [-118.00951, 33.96456], [-118.00958, 33.96441], [-118.0098, 33.96413], [-118.0099, 33.96386], [-118.00989, 33.96384], [-118.01017, 33.96353], [-118.01029, 33.9636], [-118.01004, 33.96394], [-118.01053, 33.9642], [-118.00966, 33.9653], [-118.0101, 33.96556], [-118.00944, 33.96637], [-118.00857, 33.96682], [-118.00824, 33.96752], [-118.00951, 33.96824], [-118.00918, 33.96867], [-118.00952, 33.96888], [-118.00921, 33.96926], [-118.00846, 33.96884], [-118.00843, 33.96896], [-118.00792, 33.9694], [-118.00795, 33.9695], [-118.00887, 33.97002], [-118.00827, 33.97078], [-118.0088, 33.97086], [-118.00905, 33.97078], [-118.01025, 33.96928], [-118.01347, 33.97108], [-118.01348, 33.97164], [-118.01566, 33.97164]]], [[[-117.99476, 33.9824], [-117.99357, 33.98241], [-117.99359, 33.98173], [-117.99379, 33.98188], [-117.99396, 33.98196], [-117.99427, 33.98198], [-117.9945, 33.98206], [-117.99468, 33.98222], [-117.99473, 33.98231], [-117.99476, 33.9824]]]]}	Open Access 1	46392	Arroyo Pescadero	29674	2332	Puente Hills Habitat Preservation Authority 849	Special District 4	Conservation District 31	http://www.habitatauthority.org	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6		Los Angeles 6	812.555	Arroyo Pescadero	0	None 1345

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