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

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

5 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 165

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
567	567	566	{"type": "Polygon", "coordinates": [[[-116.28545, 33.64926], [-116.27605, 33.6493], [-116.27598, 33.64886], [-116.27585, 33.64695], [-116.27557, 33.64484], [-116.27553, 33.64464], [-116.2754, 33.64431], [-116.27531, 33.64417], [-116.27517, 33.64399], [-116.2749, 33.64373], [-116.27445, 33.64342], [-116.27439, 33.64335], [-116.27436, 33.64326], [-116.27435, 33.64317], [-116.27438, 33.64308], [-116.27467, 33.64262], [-116.27478, 33.64236], [-116.27486, 33.64209], [-116.27489, 33.64208], [-116.27489, 33.64181], [-116.27485, 33.64155], [-116.27478, 33.64134], [-116.27444, 33.6407], [-116.27435, 33.64045], [-116.2741, 33.63907], [-116.27415, 33.63896], [-116.27423, 33.6389], [-116.27463, 33.63883], [-116.27495, 33.63873], [-116.27516, 33.63865], [-116.2755, 33.63848], [-116.2757, 33.63841], [-116.27604, 33.63834], [-116.27679, 33.6383], [-116.27679, 33.63793], [-116.27606, 33.63794], [-116.27575, 33.63799], [-116.27547, 33.63807], [-116.27523, 33.63815], [-116.27487, 33.63832], [-116.27471, 33.63838], [-116.27451, 33.63844], [-116.27408, 33.63852], [-116.27397, 33.63856], [-116.27385, 33.63862], [-116.27376, 33.6387], [-116.27369, 33.6388], [-116.27365, 33.63888], [-116.27322, 33.63867], [-116.273, 33.63852], [-116.27277, 33.63831], [-116.27259, 33.63807], [-116.27246, 33.63778], [-116.27241, 33.63747], [-116.27242, 33.63233], [-116.27236, 33.63209], [-116.27227, 33.63189], [-116.27213, 33.6317], [-116.27194, 33.63152], [-116.27176, 33.6314], [-116.27151, 33.63128], [-116.27134, 33.63123], [-116.27114, 33.6312], [-116.26991, 33.63119], [-116.26969, 33.63117], [-116.26945, 33.63112], [-116.2691, 33.63099], [-116.26892, 33.63089], [-116.26877, 33.63079], [-116.26854, 33.63057], [-116.26836, 33.63031], [-116.26811, 33.63031], [-116.26811, 33.62777], [-116.26796, 33.62763], [-116.26793, 33.62282], [-116.26835, 33.62284], [-116.26846, 33.62308], [-116.26867, 33.62343], [-116.26903, 33.62371], [-116.26946, 33.62391], [-116.27001, 33.62436], [-116.27227, 33.62528], [-116.27348, 33.62589], [-116.27578, 33.62758], [-116.28097, 33.62756], [-116.28101, 33.63121], [-116.28107, 33.64207], [-116.28542, 33.64205], [-116.28545, 33.64926]]]}	Open Access 1	3338	Lake Cahuilla Recreation Area	9500	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/parks/lake-cahuilla/lake-cahuilla-recreation-area-home/	Riverside 10	566.48	Lake Cahuilla Rec. Area	Local Recreation Area 3	4
6265	6265	6264	{"type": "Polygon", "coordinates": [[[-117.53184, 33.83651], [-117.52781, 33.83658], [-117.52781, 33.83602], [-117.52859, 33.836], [-117.52865, 33.83597], [-117.52865, 33.83594], [-117.52861, 33.83541], [-117.52852, 33.83513], [-117.52837, 33.83487], [-117.52794, 33.83501], [-117.52726, 33.83357], [-117.52752, 33.83343], [-117.5276, 33.83344], [-117.52778, 33.83335], [-117.5278, 33.83328], [-117.52925, 33.83254], [-117.53, 33.83352], [-117.53166, 33.83607], [-117.53184, 33.83651]]]}	Open Access 1	48877	El Cerrito Sports Park	33598	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580	Riverside 10	26.334	El Cerrito Sports Park	Local Recreation Area 3	4
6278	6278	6277	{"type": "Polygon", "coordinates": [[[-117.46707, 33.74589], [-117.46683, 33.74759], [-117.46525, 33.74744], [-117.46517, 33.7471], [-117.46503, 33.74677], [-117.46348, 33.7442], [-117.46334, 33.744], [-117.4632, 33.74382], [-117.4632, 33.74376], [-117.46365, 33.74339], [-117.46373, 33.74335], [-117.46383, 33.74332], [-117.46405, 33.74329], [-117.46541, 33.7433], [-117.46601, 33.74403], [-117.46707, 33.74589]]]}	Open Access 1	48881	Deleo Regional Sports Park	33602	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	https://rivcoccsd.org/new-page-2	Riverside 10	24.913	Deleo Reg. Sports Park	Local Recreation Area 3	4
6566	6566	6565	{"type": "Polygon", "coordinates": [[[-117.08361, 33.58364], [-117.0836, 33.58803], [-117.08006, 33.59822], [-117.08147, 33.59823], [-117.08148, 33.60003], [-117.08081, 33.60004], [-117.08089, 33.60146], [-117.08085, 33.60184], [-117.08358, 33.60186], [-117.08358, 33.60197], [-117.08081, 33.60196], [-117.08067, 33.60225], [-117.08053, 33.60245], [-117.07925, 33.60384], [-117.07965, 33.60551], [-117.07797, 33.60552], [-117.07755, 33.60378], [-117.07755, 33.60366], [-117.07759, 33.60346], [-117.0777, 33.60325], [-117.07777, 33.60316], [-117.07898, 33.60186], [-117.07898, 33.60185], [-117.06635, 33.60189], [-117.06628, 33.59819], [-117.05773, 33.59814], [-117.04902, 33.59818], [-117.04883, 33.61249], [-117.03161, 33.61285], [-117.01468, 33.61301], [-117.01468, 33.60891], [-117.01458, 33.60247], [-117.01446, 33.59845], [-117.01477, 33.58748], [-117.01474, 33.58014], [-117.01467, 33.57292], [-117.01468, 33.56634], [-117.01848, 33.56629], [-117.01848, 33.56572], [-117.03106, 33.56554], [-117.03111, 33.57278], [-117.04895, 33.5727], [-117.06647, 33.57272], [-117.07725, 33.5727], [-117.07727, 33.57634], [-117.08343, 33.57634], [-117.08347, 33.57664], [-117.08348, 33.57699], [-117.08345, 33.58362], [-117.08361, 33.58364]]]}	Open Access 1	3485	Lake Skinner Recreation Area	9501	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/parks/lake-skinner/lake-skinner-home/	Riverside 10	6079.529	Lake Skinner Rec. Area	Local Recreation Area 3	4
14862	14862	14861	{"type": "Polygon", "coordinates": [[[-116.25953, 33.85477], [-116.25847, 33.85477], [-116.25854, 33.85444], [-116.25847, 33.85432], [-116.25869, 33.85385], [-116.25883, 33.85385], [-116.25953, 33.85422], [-116.25953, 33.85477]]]}	Open Access 1	48284	Indio Hills Community Center and Park	32855	315	Riverside, County of 169	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	1.979	Indio Hills Community Ctr. and Park	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]);