calands: units_with_maps: 11 rows where ACCESS_TYP = 1, AGNCY_NAME = 114 and DES

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

11 rows where ACCESS_TYP = 1, AGNCY_NAME = 114 and DES_TP = 2

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	DES_TP	GAP_STS
2987	2987	2986	{"type": "Polygon", "coordinates": [[[-117.57957, 33.91794], [-117.57954, 33.91868], [-117.57869, 33.91868], [-117.57869, 33.91804], [-117.57887, 33.91791], [-117.57901, 33.91776], [-117.57904, 33.91774], [-117.57908, 33.91774], [-117.57957, 33.91794]]]}	Open Access 1	19853	Pacer Park	23290	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	1.81	Pacer Park	Local Park 2	4
3949	3949	3948	{"type": "Polygon", "coordinates": [[[-117.55804, 33.95506], [-117.55383, 33.95686], [-117.55383, 33.95718], [-117.54956, 33.95724], [-117.54958, 33.95672], [-117.54972, 33.95606], [-117.54998, 33.95533], [-117.55028, 33.95456], [-117.55059, 33.95387], [-117.55111, 33.95285], [-117.55167, 33.95202], [-117.55193, 33.95167], [-117.55217, 33.95146], [-117.55281, 33.95103], [-117.55304, 33.95085], [-117.55325, 33.95063], [-117.55343, 33.95039], [-117.55356, 33.95016], [-117.55371, 33.95016], [-117.55372, 33.94999], [-117.5559, 33.94996], [-117.5559, 33.94815], [-117.55799, 33.94815], [-117.55795, 33.94909], [-117.55796, 33.95169], [-117.55804, 33.95506]]]}	Open Access 1	47426	Silverlakes Park	31143	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2	http://silverlakespark.com/	Riverside 10	123.732	Silverlakes Park	Local Park 2	4
5216	5216	5215	{"type": "Polygon", "coordinates": [[[-117.58908, 33.91975], [-117.58908, 33.91975], [-117.58848, 33.92029], [-117.58833, 33.91958], [-117.58856, 33.91936], [-117.58908, 33.91975]]]}	Open Access 1	19852	Sundance Park	25988	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	0.891	Sundance Park	Local Park 2	4
6697	6697	6696	{"type": "Polygon", "coordinates": [[[-117.57934, 33.9283], [-117.57931, 33.92864], [-117.57932, 33.92971], [-117.57929, 33.92995], [-117.57923, 33.93017], [-117.57918, 33.9303], [-117.57908, 33.93047], [-117.57892, 33.93067], [-117.57852, 33.93108], [-117.57798, 33.93108], [-117.57797, 33.93107], [-117.57667, 33.93109], [-117.57666, 33.92704], [-117.578, 33.92701], [-117.578, 33.92753], [-117.57865, 33.92801], [-117.57919, 33.92828], [-117.57934, 33.9283]]]}	Open Access 1	4977	Wayne Makin Park	27322	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	23.137	Wayne Makin Park	Local Park 2	4
6941	6941	6940	{"type": "Polygon", "coordinates": [[[-117.56288, 33.93152], [-117.56288, 33.9323], [-117.55781, 33.9323], [-117.55797, 33.93125], [-117.5615, 33.93124], [-117.56196, 33.9313], [-117.56288, 33.93152]]]}	Open Access 1	5842	Neil Snipes Park	22688	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	12.899	Neil Snipes Park	Local Park 2	4
7724	7724	7723	{"type": "Polygon", "coordinates": [[[-117.54835, 33.92287], [-117.5476, 33.92282], [-117.54731, 33.92303], [-117.54724, 33.92331], [-117.54672, 33.92277], [-117.5462, 33.9221], [-117.5472, 33.9217], [-117.5477, 33.92212], [-117.54835, 33.92287]]]}	Open Access 1	7963	Parmenter Park	23470	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	3.997	Parmenter Park	Local Park 2	4
8933	8933	8932	{"type": "Polygon", "coordinates": [[[-117.58943, 33.92238], [-117.5882, 33.9224], [-117.5882, 33.92215], [-117.58814, 33.92214], [-117.58808, 33.92203], [-117.58883, 33.9217], [-117.58943, 33.92238]]]}	Open Access 1	14680	Ted Brooks Park	26211	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	1.443	Ted Brooks Park	Local Park 2	4
14108	14108	14107	{"type": "Polygon", "coordinates": [[[-117.54569, 33.90209], [-117.54445, 33.90209], [-117.54445, 33.90174], [-117.54434, 33.90165], [-117.54437, 33.90159], [-117.54453, 33.90165], [-117.54522, 33.90169], [-117.54556, 33.90179], [-117.54565, 33.90193], [-117.54569, 33.90209]]]}	Open Access 1	39189	Norco Hills Park	22787	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	1.231	Norco Hills Park	Local Park 2	4
14109	14109	14108	{"type": "Polygon", "coordinates": [[[-117.52809, 33.93125], [-117.528, 33.93143], [-117.52794, 33.93163], [-117.52794, 33.93222], [-117.5279, 33.93225], [-117.52763, 33.93226], [-117.52763, 33.93173], [-117.52734, 33.93172], [-117.52734, 33.93126], [-117.52809, 33.93125]]]}	Open Access 1	39190	Hawks Crest Park	19749	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	1.194	Hawks Crest Park	Local Park 2	4
14110	14110	14109	{"type": "Polygon", "coordinates": [[[-117.53259, 33.92547], [-117.53229, 33.92572], [-117.53218, 33.92582], [-117.53208, 33.92624], [-117.53199, 33.9263], [-117.53178, 33.92636], [-117.53172, 33.92633], [-117.53165, 33.92633], [-117.53163, 33.92548], [-117.53259, 33.92547]]]}	Open Access 1	39191	Ridge Ranch Park	24349	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	1.254	Ridge Ranch Park	Local Park 2	4
14642	14642	14641	{"type": "Polygon", "coordinates": [[[-117.58128, 33.91188], [-117.58118, 33.912], [-117.58105, 33.9121], [-117.58069, 33.91233], [-117.58062, 33.91233], [-117.58002, 33.91165], [-117.58058, 33.9113], [-117.58128, 33.91188]]]}	Open Access 1	44889	Kips Korner Park	20676	1395	Norco, City of 114	City 2	City Agency 2	http://www.norco.ca.us/depts/parks/default.asp	City 2	1395	Norco, City of 111	City 2	City Agency 2		Riverside 10	1.721	Kips Korner Park	Local Park 2	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]);