calands: units_with_maps: 5 rows where ACCESS_TYP = 2, COUNTY = 10 and DES

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

5 rows where ACCESS_TYP = 2, COUNTY = 10 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
10713	10713	10712	{"type": "Polygon", "coordinates": [[[-117.39344, 33.69094], [-117.39311, 33.69099], [-117.39309, 33.69136], [-117.39312, 33.69339], [-117.39168, 33.69308], [-117.39162, 33.69302], [-117.39148, 33.69276], [-117.39126, 33.69278], [-117.39021, 33.69283], [-117.39021, 33.69131], [-117.3903, 33.69123], [-117.39046, 33.69122], [-117.39065, 33.69119], [-117.39135, 33.69095], [-117.39212, 33.69088], [-117.39237, 33.69083], [-117.39261, 33.69074], [-117.39301, 33.69048], [-117.39325, 33.6904], [-117.39331, 33.69043], [-117.39339, 33.69069], [-117.39344, 33.69094]]]}	Restricted Access 2	19872	Summer Lake Park	31649	2326	Elsinore Unified School District 954	Special District 4	School District 14	http://www.leusd.k12.ca.us/	Special District 4	1389	Lake Elsinore, City of 183	City 2	City Agency 2		Riverside 10	15.756	Summer Lake Park	Local Park 2	4
10715	10715	10714	{"type": "Polygon", "coordinates": [[[-117.37796, 33.68413], [-117.377, 33.68522], [-117.37602, 33.68457], [-117.37627, 33.68425], [-117.3764, 33.68423], [-117.37651, 33.68416], [-117.37655, 33.68405], [-117.37676, 33.68385], [-117.37693, 33.68398], [-117.37718, 33.6839], [-117.37729, 33.68369], [-117.37796, 33.68413]]]}	Restricted Access 2	19874	Machado Park	31594	2326	Elsinore Unified School District 954	Special District 4	School District 14	http://www.leusd.k12.ca.us/	Special District 4	1389	Lake Elsinore, City of 183	City 2	City Agency 2	http://www.lake-elsinore.org/city-hall/city-departments/community-services/parks/machado-park#ad-image-0	Riverside 10	3.781	Machado Park	Local Park 2	4
13454	13454	13453	{"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82177], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.82089], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82032], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]}	Restricted Access 2	35667	Thousand Palms Community Park	31650	2318	Palm Springs Unified School District 1058	Special District 4	School District 14	http://www.psusd.us/	Special District 4	315	Riverside, County of 165	County 3	County Agency 3		Riverside 10	16.4	Thousand Palms Community Park	Local Park 2	4
14009	14009	14008	{"type": "Polygon", "coordinates": [[[-116.3736, 33.7155], [-116.3736, 33.71665], [-116.37357, 33.71669], [-116.37171, 33.71671], [-116.37166, 33.71668], [-116.37165, 33.7155], [-116.3736, 33.7155]]]}	Restricted Access 2	39070	Washington Charter School Park	31654	1240	Palm Desert, City of 215	City 2	City Agency 2	http://www.cityofpalmdesert.org/Index.aspx?page=174	City 2	1240	Palm Desert, City of 211	City 2	City Agency 2		Riverside 10	5.945	Washington Charter School Park	Local Park 2	4
14230	14230	14229	{"type": "Polygon", "coordinates": [[[-117.21517, 33.55612], [-117.21408, 33.55696], [-117.21341, 33.55748], [-117.21339, 33.55643], [-117.21366, 33.55642], [-117.21366, 33.55608], [-117.2134, 33.55607], [-117.2134, 33.55585], [-117.2142, 33.55523], [-117.21517, 33.55612]]]}	Restricted Access 2	44109	Murrieta Elementary School Park	31631	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	5.132	Murrieta Elementary School 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]);