calands: units_with_maps: 15 rows where ACCESS_TYP = 1, AGNCY_LEV = 2 and MNG

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

15 rows where ACCESS_TYP = 1, AGNCY_LEV = 2 and MNG_AGENCY = 555

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
2928	2928	2927	{"type": "Polygon", "coordinates": [[[-117.21419, 33.78669], [-117.21416, 33.78846], [-117.2131, 33.78845], [-117.21308, 33.78667], [-117.21419, 33.78669]]]}	Open Access 1	19871	Bob Long Park	16210	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2		Riverside 10	4.867	Bob Long Park	0	Local Park 2	4
3650	3650	3649	{"type": "Polygon", "coordinates": [[[-117.22792, 33.78575], [-117.22791, 33.7858], [-117.22716, 33.78583], [-117.22716, 33.78652], [-117.22629, 33.78652], [-117.22625, 33.78652], [-117.22623, 33.78649], [-117.22622, 33.78562], [-117.22627, 33.78556], [-117.22768, 33.78556], [-117.22769, 33.78574], [-117.22792, 33.78575]]]}	Open Access 1	48805	Russel Stewart Park/Cesar Chavez Library	33527	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parklist.html	Riverside 10	2.684	Russel Stewart Park/Cesar Chavez Library		None 305
6235	6235	6234	{"type": "Polygon", "coordinates": [[[-117.22851, 33.7902], [-117.22628, 33.7902], [-117.22628, 33.78801], [-117.22746, 33.788], [-117.22746, 33.78956], [-117.22846, 33.78956], [-117.22851, 33.7902]]]}	Open Access 1	1291	Banta Beatty Park	15802	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2		Riverside 10	8.216	Banta Beatty Park	0	Local Park 2	4
6801	6801	6800	{"type": "Polygon", "coordinates": [[[-117.23225, 33.7922], [-117.23211, 33.79221], [-117.23212, 33.7938], [-117.23068, 33.7938], [-117.22974, 33.79171], [-117.22954, 33.79115], [-117.2294, 33.7907], [-117.23224, 33.79069], [-117.23225, 33.7922]]]}	Open Access 1	5316	Metz Park	22190	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2		Riverside 10	17.209	Metz Park	0	Local Park 2	4
10711	10711	10710	{"type": "Polygon", "coordinates": [[[-117.22146, 33.82254], [-117.22143, 33.82281], [-117.22083, 33.82283], [-117.22084, 33.82245], [-117.21981, 33.8224], [-117.21975, 33.82263], [-117.21946, 33.82262], [-117.21943, 33.82277], [-117.21756, 33.82281], [-117.21749, 33.82274], [-117.21749, 33.81948], [-117.21758, 33.8194], [-117.21784, 33.81938], [-117.21788, 33.81979], [-117.21803, 33.81998], [-117.22078, 33.82232], [-117.22109, 33.82246], [-117.22146, 33.82254]]]}	Open Access 1	19869	Paragon Park	23409	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2		Riverside 10	15.394	Paragon Park	0	Local Park 2	4
10712	10712	10711	{"type": "Polygon", "coordinates": [[[-117.2226, 33.80668], [-117.2226, 33.80688], [-117.22237, 33.80757], [-117.22235, 33.80829], [-117.22118, 33.80829], [-117.22116, 33.80616], [-117.22126, 33.80614], [-117.22129, 33.80604], [-117.22131, 33.80534], [-117.22174, 33.80533], [-117.22166, 33.8049], [-117.22196, 33.80489], [-117.22201, 33.80552], [-117.22209, 33.80563], [-117.22225, 33.80566], [-117.22231, 33.80668], [-117.2226, 33.80668]]]}	Open Access 1	19870	Copper Creek Park	17628	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2		Riverside 10	8.861	Copper Creek Park	0	Local Park 2	4
11995	11995	11994	{"type": "MultiPolygon", "coordinates": [[[[-117.22935, 33.73821], [-117.22866, 33.73876], [-117.22889, 33.73903], [-117.22865, 33.73916], [-117.22836, 33.73929], [-117.22809, 33.73937], [-117.22782, 33.73942], [-117.22778, 33.73931], [-117.22785, 33.73923], [-117.22788, 33.73912], [-117.22786, 33.739], [-117.22777, 33.73885], [-117.22769, 33.73834], [-117.22762, 33.73819], [-117.2276, 33.73807], [-117.22764, 33.73797], [-117.22773, 33.73786], [-117.22792, 33.73777], [-117.22805, 33.73767], [-117.22826, 33.73759], [-117.22875, 33.73753], [-117.22881, 33.73782], [-117.2292, 33.73766], [-117.22927, 33.73772], [-117.22909, 33.73802], [-117.22935, 33.73821]]], [[[-117.22935, 33.73999], [-117.22899, 33.7404], [-117.22885, 33.74048], [-117.22861, 33.74056], [-117.22832, 33.74058], [-117.22815, 33.74057], [-117.22794, 33.73959], [-117.22815, 33.73954], [-117.22854, 33.73942], [-117.22876, 33.73932], [-117.22902, 33.73918], [-117.22927, 33.73946], [-117.22922, 33.73973], [-117.22923, 33.73983], [-117.22935, 33.73999]]]]}	Open Access 1	24653	Monument Ranch Park	22447	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2		Riverside 10	8.557	Monument Ranch Park	0	Local Park 2	4
14708	14708	14707	{"type": "MultiPolygon", "coordinates": [[[[-117.22872, 33.7773], [-117.22831, 33.77731], [-117.22788, 33.77723], [-117.22683, 33.7766], [-117.22871, 33.77659], [-117.22872, 33.7773]]], [[[-117.22872, 33.77766], [-117.22872, 33.77766], [-117.22856, 33.77755], [-117.22872, 33.77754], [-117.22872, 33.77766]]]]}	Open Access 1	45055	Mercado Park	28049	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.parks.ca.gov/?Page_id=26463	Riverside 10	2.35	Mercado Park	0	Local Park 2	4
14901	14901	14900	{"type": "Polygon", "coordinates": [[[-117.20331, 33.82801], [-117.20331, 33.82811], [-117.20305, 33.82823], [-117.2028, 33.82828], [-117.2009, 33.82829], [-117.20067, 33.82826], [-117.20056, 33.82829], [-117.20006, 33.82829], [-117.20006, 33.82684], [-117.20188, 33.82684], [-117.20231, 33.82709], [-117.20266, 33.82735], [-117.20304, 33.82769], [-117.20331, 33.82801]]]}	Open Access 1	45453	Liberty Park	28258	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/liberty-park.html	Riverside 10	9.984	Liberty Park	0	Local Park 2	4
14902	14902	14901	{"type": "Polygon", "coordinates": [[[-117.19176, 33.83854], [-117.19139, 33.83854], [-117.1914, 33.83929], [-117.19101, 33.83918], [-117.19081, 33.83909], [-117.19065, 33.83899], [-117.19043, 33.83883], [-117.19007, 33.83847], [-117.19007, 33.83839], [-117.19066, 33.83797], [-117.19092, 33.83773], [-117.1911, 33.83751], [-117.1912, 33.83748], [-117.19144, 33.83755], [-117.19169, 33.83758], [-117.1917, 33.83847], [-117.19176, 33.83854]]]}	Open Access 1	45454	Frank Eaton Memorial Park	28257	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/frank-eaton-park.html	Riverside 10	4.423	Frank Eaton Memorial Park	0	Local Park 2	4
14903	14903	14902	{"type": "Polygon", "coordinates": [[[-117.21216, 33.83907], [-117.20865, 33.83908], [-117.20865, 33.8374], [-117.21216, 33.83739], [-117.21216, 33.83907]]]}	Open Access 1	45455	Morgan Park	28256	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/morgan-park.html	Riverside 10	14.952	Morgan Park	0	Local Park 2	4
14904	14904	14903	{"type": "Polygon", "coordinates": [[[-117.1894, 33.82787], [-117.18909, 33.82788], [-117.18908, 33.8279], [-117.18702, 33.8279], [-117.18699, 33.8278], [-117.1869, 33.82772], [-117.1869, 33.8267], [-117.18897, 33.82669], [-117.18898, 33.82733], [-117.18935, 33.82734], [-117.1894, 33.82742], [-117.18942, 33.82749], [-117.18942, 33.82778], [-117.1894, 33.82787]]]}	Open Access 1	45456	May Ranch Park	28255	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/may-ranch-park.html	Riverside 10	6.905	May Ranch Park	0	Local Park 2	4
14905	14905	14904	{"type": "Polygon", "coordinates": [[[-117.20841, 33.79369], [-117.20708, 33.79371], [-117.20708, 33.79261], [-117.2084, 33.79258], [-117.20841, 33.79369]]]}	Open Access 1	45458	Patriot Park	28261	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/patriot-park.html	Riverside 10	3.698	Patriot Park	0	Local Park 2	4
14906	14906	14905	{"type": "Polygon", "coordinates": [[[-117.23464, 33.77386], [-117.23309, 33.77386], [-117.23308, 33.77214], [-117.23463, 33.77213], [-117.23464, 33.77386]]]}	Open Access 1	45459	Rotary Park	28260	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/rotary-park.html	Riverside 10	6.795	Rotary Park	0	Local Park 2	4
14907	14907	14906	{"type": "Polygon", "coordinates": [[[-117.21722, 33.79009], [-117.21716, 33.79014], [-117.21519, 33.79015], [-117.21519, 33.78843], [-117.21609, 33.78842], [-117.21662, 33.78887], [-117.21678, 33.78905], [-117.2169, 33.7892], [-117.21702, 33.78939], [-117.21712, 33.78963], [-117.21718, 33.78985], [-117.21722, 33.79009]]]}	Open Access 1	45460	Skydive Baseball Park	28259	1388	Perris, City of 563	City 2	City Agency 2	http://cityofperris.org/residents/parks.html	City 2	1388	Perris, City of 555	City 2	City Agency 2	http://www.cityofperris.org/residents/parks/parks/skydive-park.html	Riverside 10	7.227	Skydive Baseball Park	0	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]);