calands: units_with_maps: 5 rows where DES_TP = 3 and MNG

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

5 rows where DES_TP = 3 and MNG_AGENCY = 326

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
7468	7468	7467	{"type": "Polygon", "coordinates": [[[-117.17186, 33.58817], [-117.17183, 33.58826], [-117.17163, 33.58838], [-117.17032, 33.58931], [-117.17034, 33.58934], [-117.17035, 33.58943], [-117.17025, 33.58954], [-117.16981, 33.58985], [-117.16963, 33.59001], [-117.16933, 33.59032], [-117.16911, 33.59059], [-117.16721, 33.59059], [-117.1671, 33.58461], [-117.16875, 33.58397], [-117.16822, 33.58131], [-117.16898, 33.58084], [-117.16936, 33.58054], [-117.16969, 33.58023], [-117.1703, 33.57954], [-117.17055, 33.5793], [-117.17085, 33.57906], [-117.17128, 33.57943], [-117.17143, 33.5796], [-117.17156, 33.57979], [-117.17156, 33.58], [-117.17162, 33.5802], [-117.17165, 33.58037], [-117.17165, 33.58302], [-117.17156, 33.58303], [-117.17156, 33.58371], [-117.17161, 33.58392], [-117.17169, 33.58411], [-117.17178, 33.58427], [-117.17198, 33.58456], [-117.17208, 33.58477], [-117.17215, 33.58502], [-117.17218, 33.58522], [-117.17216, 33.58551], [-117.17209, 33.58576], [-117.17199, 33.58597], [-117.17178, 33.58631], [-117.17168, 33.58652], [-117.17162, 33.58668], [-117.17157, 33.58698], [-117.17157, 33.58729], [-117.17162, 33.58762], [-117.17172, 33.5879], [-117.17186, 33.58817]]]}	Open Access 1	48447	Los Alamos Hills Sports Park	33152	1391	Murrieta, City of 329	City 2	City Agency 2	http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA	City 2	1391	Murrieta, City of 326	City 2	City Agency 2	Riverside 10	100.636	Los Alamos Hills Sports Park	Local Recreation Area 3	4
7597	7597	7596	{"type": "MultiPolygon", "coordinates": [[[[-117.22221, 33.54749], [-117.22073, 33.54861], [-117.21897, 33.54699], [-117.21941, 33.54668], [-117.21955, 33.54662], [-117.21987, 33.54665], [-117.2202, 33.54656], [-117.22029, 33.54648], [-117.22065, 33.54637], [-117.22161, 33.54644], [-117.22161, 33.54667], [-117.2217, 33.54685], [-117.22176, 33.54708], [-117.22221, 33.54749]]], [[[-117.22279, 33.54811], [-117.22136, 33.5492], [-117.22085, 33.54874], [-117.22226, 33.54767], [-117.2223, 33.54766], [-117.22279, 33.54811]]], [[[-117.22382, 33.54626], [-117.22228, 33.54743], [-117.22191, 33.54709], [-117.22182, 33.54694], [-117.2218, 33.54683], [-117.22184, 33.54663], [-117.22178, 33.54645], [-117.22192, 33.54646], [-117.2223, 33.54634], [-117.22307, 33.54616], [-117.22355, 33.54601], [-117.22382, 33.54626]]], [[[-117.22344, 33.54591], [-117.22303, 33.54604], [-117.22264, 33.54612], [-117.22238, 33.54527], [-117.22242, 33.54525], [-117.2226, 33.54513], [-117.22344, 33.54591]]], [[[-117.22405, 33.54715], [-117.22295, 33.54799], [-117.22246, 33.54754], [-117.22248, 33.5475], [-117.22355, 33.54669], [-117.22405, 33.54715]]]]}	Open Access 1	48452	Murrieta Equestrian Park	33165	1391	Murrieta, City of 329	City 2	City Agency 2	http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA	City 2	1391	Murrieta, City of 326	City 2	City Agency 2	Riverside 10	20.623	Murrieta Equestrian Park	Local Recreation Area 3	4
10729	10729	10728	{"type": "Polygon", "coordinates": [[[-117.1804, 33.56326], [-117.18038, 33.5638], [-117.17812, 33.56374], [-117.17802, 33.5637], [-117.17809, 33.56352], [-117.17634, 33.56183], [-117.17657, 33.56166], [-117.17692, 33.56134], [-117.17717, 33.56151], [-117.17741, 33.56171], [-117.1775, 33.56165], [-117.17861, 33.56269], [-117.1804, 33.56326]]]}	Open Access 1	19946	Alta Murrieta Sports Park	15418	1391	Murrieta, City of 329	City 2	City Agency 2	http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA	City 2	1391	Murrieta, City of 326	City 2	City Agency 2	Riverside 10	9.771	Alta Murrieta Sports Park	Local Recreation Area 3	4
10739	10739	10738	{"type": "Polygon", "coordinates": [[[-117.20326, 33.57243], [-117.20225, 33.57341], [-117.20195, 33.57373], [-117.20174, 33.574], [-117.20157, 33.57426], [-117.20142, 33.57453], [-117.20127, 33.57485], [-117.20118, 33.5749], [-117.20045, 33.57472], [-117.20015, 33.57462], [-117.1999, 33.57452], [-117.1994, 33.57426], [-117.19906, 33.57404], [-117.19884, 33.57386], [-117.20118, 33.57207], [-117.20032, 33.57135], [-117.19978, 33.57111], [-117.1998, 33.57108], [-117.20135, 33.57177], [-117.20137, 33.57176], [-117.20142, 33.57136], [-117.20163, 33.57136], [-117.20326, 33.57243]]]}	Open Access 1	19960	California Oaks Sports Park	16720	1391	Murrieta, City of 329	City 2	City Agency 2	http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA	City 2	1391	Murrieta, City of 326	City 2	City Agency 2	Riverside 10	18.707	California Oaks Sports Park	Local Recreation Area 3	4
16328	16328	16327	{"type": "Polygon", "coordinates": [[[-117.21238, 33.55493], [-117.21088, 33.55607], [-117.21015, 33.55539], [-117.21164, 33.55425], [-117.21238, 33.55493]]]}	Open Access 1	24646	Community Center/Hunt Field	17567	1391	Murrieta, City of 329	City 2	City Agency 2	http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA	City 2	1391	Murrieta, City of 326	City 2	City Agency 2	Riverside 10	4.726	Community Ctr./Hunt Field	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]);