calands: units_with_maps: 3 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG

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

3 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 231

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
1774	1774	1773	{"type": "Polygon", "coordinates": [[[-117.67073, 33.63992], [-117.67031, 33.64036], [-117.66935, 33.64163], [-117.66896, 33.6421], [-117.66848, 33.64251], [-117.66885, 33.64158], [-117.66945, 33.64111], [-117.66954, 33.64096], [-117.66992, 33.64057], [-117.67033, 33.63966], [-117.67051, 33.63963], [-117.67073, 33.63982], [-117.67073, 33.63992]]]}	Open Access 1	7165	City of Lake Forest Open Space	17318	1167	Lake Forest, City of 235	City 2	City Agency 2	http://www.lakeforestca.gov/depts/cs/city_parks/default.asp	City 2	1167	Lake Forest, City of 231	City 2	City Agency 2		Orange 3	2.46	City of Lake Forest OS	0	Local Recreation Area 3	4
6645	6645	6644	{"type": "Polygon", "coordinates": [[[-117.67345, 33.6375], [-117.67294, 33.63791], [-117.6725, 33.63784], [-117.67208, 33.63789], [-117.67167, 33.63814], [-117.67156, 33.63826], [-117.67133, 33.63887], [-117.67176, 33.63918], [-117.67131, 33.63947], [-117.67099, 33.6397], [-117.67087, 33.6397], [-117.67077, 33.63963], [-117.67119, 33.63911], [-117.67151, 33.63824], [-117.67164, 33.63811], [-117.67205, 33.63786], [-117.67219, 33.6375], [-117.67245, 33.6373], [-117.67302, 33.63779], [-117.67342, 33.63747], [-117.67345, 33.6375]]]}	Open Access 1	4657	City of Lake Forest Open Space	17318	1167	Lake Forest, City of 235	City 2	City Agency 2	http://www.lakeforestca.gov/depts/cs/city_parks/default.asp	City 2	1167	Lake Forest, City of 231	City 2	City Agency 2		Orange 3	1.902	City of Lake Forest OS	0	Local Recreation Area 3	4
9989	9989	9988	{"type": "Polygon", "coordinates": [[[-117.65864, 33.66425], [-117.65842, 33.66497], [-117.65853, 33.665], [-117.65847, 33.66516], [-117.65838, 33.66514], [-117.65817, 33.66558], [-117.65757, 33.66543], [-117.65723, 33.66615], [-117.65658, 33.66736], [-117.65606, 33.66707], [-117.65557, 33.66674], [-117.65503, 33.6663], [-117.65503, 33.66621], [-117.65489, 33.6661], [-117.65478, 33.6661], [-117.65431, 33.66572], [-117.65377, 33.66536], [-117.65339, 33.66514], [-117.65288, 33.6649], [-117.65284, 33.66481], [-117.653, 33.66444], [-117.65313, 33.66407], [-117.65324, 33.6637], [-117.65332, 33.66332], [-117.65343, 33.66342], [-117.65379, 33.66356], [-117.65404, 33.66361], [-117.65417, 33.66354], [-117.65435, 33.6635], [-117.65449, 33.66343], [-117.65459, 33.66335], [-117.65479, 33.66312], [-117.65494, 33.66283], [-117.65495, 33.66247], [-117.65501, 33.66234], [-117.6551, 33.66185], [-117.65509, 33.6618], [-117.65506, 33.66176], [-117.65499, 33.66171], [-117.65485, 33.66168], [-117.65482, 33.66164], [-117.65481, 33.66159], [-117.65484, 33.66155], [-117.65505, 33.66138], [-117.65531, 33.66114], [-117.65554, 33.66104], [-117.65564, 33.6611], [-117.65574, 33.66102], [-117.6557, 33.66098], [-117.65578, 33.66093], [-117.65583, 33.66087], [-117.65588, 33.66078], [-117.65588, 33.66072], [-117.65586, 33.66069], [-117.65579, 33.66063], [-117.65559, 33.66053], [-117.65557, 33.66048], [-117.65568, 33.66038], [-117.65632, 33.66031], [-117.65652, 33.66013], [-117.65669, 33.66003], [-117.65696, 33.65992], [-117.65716, 33.65989], [-117.65736, 33.65988], [-117.65765, 33.65991], [-117.65784, 33.65997], [-117.65802, 33.66005], [-117.65859, 33.66037], [-117.65923, 33.66092], [-117.65931, 33.66101], [-117.65937, 33.66111], [-117.6594, 33.66123], [-117.6594, 33.66134], [-117.65934, 33.66151], [-117.65819, 33.66297], [-117.65793, 33.66386], [-117.65794, 33.66387], [-117.65837, 33.66381], [-117.65835, 33.66409], [-117.65864, 33.66425]]]}	Open Access 1	47969	Lake Forest Sports Park	32259	1167	Lake Forest, City of 235	City 2	City Agency 2	http://www.lakeforestca.gov/depts/cs/city_parks/default.asp	City 2	1167	Lake Forest, City of 231	City 2	City Agency 2	http://lfsportspark.com/	Orange 3	66.103	Lake Forest Sports Park	2014	Local Recreation Area 3	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]);