calands: units_with_maps: 18 rows where ACCESS_TYP = 1, COUNTY = 9 and MNG

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

18 rows where ACCESS_TYP = 1, COUNTY = 9 and MNG_AGENCY = 227

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
650	650	649	{"type": "Polygon", "coordinates": [[[-119.55793, 36.70659], [-119.55742, 36.70665], [-119.55736, 36.70639], [-119.55787, 36.70633], [-119.55793, 36.70659]]]}	Open Access 1	5005	Brehler Square	16348	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.342	Brehler Square	Local Park 2	4
684	684	683	{"type": "Polygon", "coordinates": [[[-119.55782, 36.71066], [-119.5568, 36.71078], [-119.55654, 36.70916], [-119.55755, 36.70903], [-119.55768, 36.70985], [-119.55776, 36.71025], [-119.55782, 36.71066]]]}	Open Access 1	5180	Sanger Park	25029	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	4.119	Sanger Park	Local Park 2	4
773	773	772	{"type": "Polygon", "coordinates": [[[-119.5519, 36.71753], [-119.54989, 36.71755], [-119.54989, 36.71592], [-119.5519, 36.7159], [-119.5519, 36.71753]]]}	Open Access 1	5034	Cesar Chavez Park	17099	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	8.027	Cesar Chavez Park	Local Park 2	4
778	778	777	{"type": "Polygon", "coordinates": [[[-119.56757, 36.70218], [-119.56564, 36.70219], [-119.56545, 36.7022], [-119.56545, 36.70126], [-119.566, 36.70128], [-119.56757, 36.70129], [-119.56757, 36.70218]]]}	Open Access 1	5059	Greenwood Park	19488	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	4.693	Greenwood Park	Local Park 2	4
1821	1821	1820	{"type": "Polygon", "coordinates": [[[-119.55015, 36.70314], [-119.54831, 36.70337], [-119.54807, 36.70231], [-119.54992, 36.70206], [-119.55015, 36.70314]]]}	Open Access 1	13864	Faller Park	18836	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	4.974	Faller Park	Local Park 2	4
3307	3307	3306	{"type": "Polygon", "coordinates": [[[-119.55896, 36.70194], [-119.55845, 36.702], [-119.55836, 36.70146], [-119.55886, 36.7014], [-119.55896, 36.70194]]]}	Open Access 1	48237	Galoostian Park	32795	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.676	Galoostian Park	Local Park 2	4
3323	3323	3322	{"type": "Polygon", "coordinates": [[[-119.55823, 36.70605], [-119.55806, 36.70607], [-119.55799, 36.70574], [-119.55816, 36.70572], [-119.55823, 36.70605]]]}	Open Access 1	48241	Sam Gutierrez Park	32799	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.145	Sam Gutierrez Park	Local Park 2	4
4317	4317	4316	{"type": "Polygon", "coordinates": [[[-119.56205, 36.69122], [-119.56182, 36.69155], [-119.56176, 36.69169], [-119.56172, 36.69187], [-119.56172, 36.69212], [-119.56167, 36.69216], [-119.56118, 36.69217], [-119.56117, 36.69118], [-119.56202, 36.69118], [-119.56205, 36.69122]]]}	Open Access 1	48247	Catherine Park	32810	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	1.557	Catherine Park	Local Park 2	4
5267	5267	5266	{"type": "Polygon", "coordinates": [[[-119.57202, 36.71036], [-119.572, 36.71146], [-119.56979, 36.71145], [-119.56979, 36.71118], [-119.57163, 36.71036], [-119.57202, 36.71036]]]}	Open Access 1	5076	Jenni Park	20388	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	4.105	Jenni Park	Local Park 2	4
5963	5963	5962	{"type": "Polygon", "coordinates": [[[-119.5626, 36.70623], [-119.56221, 36.70623], [-119.56221, 36.70595], [-119.5626, 36.70595], [-119.5626, 36.70623]]]}	Open Access 1	48245	Civic Center Park	32800	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.261	Civic Ctr. Park	Local Park 2	4
6747	6747	6746	{"type": "Polygon", "coordinates": [[[-119.54741, 36.69454], [-119.54701, 36.6948], [-119.54683, 36.69498], [-119.54676, 36.6951], [-119.54671, 36.69523], [-119.54669, 36.69535], [-119.5467, 36.69551], [-119.54537, 36.69551], [-119.54538, 36.69359], [-119.54672, 36.69359], [-119.54669, 36.69231], [-119.54738, 36.69231], [-119.54741, 36.69454]]]}	Open Access 1	5093	John F Kennedy Park	20436	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	10.475	John F Kennedy Park	Local Park 2	4
6752	6752	6751	{"type": "Polygon", "coordinates": [[[-119.56084, 36.69569], [-119.56077, 36.69571], [-119.55876, 36.6957], [-119.55876, 36.69465], [-119.56081, 36.69468], [-119.56084, 36.69569]]]}	Open Access 1	5117	Lincoln Park	21271	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	5.283	Lincoln Park	Local Park 2	4
9301	9301	9300	{"type": "Polygon", "coordinates": [[[-119.57408, 36.69451], [-119.57404, 36.69586], [-119.57131, 36.69585], [-119.5713, 36.69449], [-119.57408, 36.69451]]]}	Open Access 1	15497	Rotary Park	24695	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	9.129	Rotary Park	Local Park 2	4
11511	11511	11510	{"type": "Polygon", "coordinates": [[[-119.57971, 36.70417], [-119.57968, 36.7042], [-119.57953, 36.70418], [-119.57918, 36.70408], [-119.57894, 36.70405], [-119.57891, 36.70402], [-119.57891, 36.7038], [-119.5797, 36.70379], [-119.57971, 36.70417]]]}	Open Access 1	48215	Audry Park	32755	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.636	Audry Park	Local Park 2	4
11513	11513	11512	{"type": "Polygon", "coordinates": [[[-119.54752, 36.70767], [-119.54752, 36.70767], [-119.54749, 36.70896], [-119.54747, 36.70878], [-119.54743, 36.70866], [-119.54738, 36.70854], [-119.54729, 36.70842], [-119.54713, 36.70825], [-119.54676, 36.70799], [-119.54658, 36.70779], [-119.54752, 36.70767]]]}	Open Access 1	48216	Sanger Skate Park	32756	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2	https://www.ci.sanger.ca.us/Facilities/Facility/Details/Sanger-Skate-Park-11	Fresno 9	1.139	Sanger Skate Park	Local Recreation Area 3	4
11533	11533	11532	{"type": "Polygon", "coordinates": [[[-119.54486, 36.70648], [-119.54482, 36.70651], [-119.54449, 36.70651], [-119.54409, 36.70657], [-119.54394, 36.70635], [-119.54438, 36.70628], [-119.54482, 36.70626], [-119.54486, 36.70648]]]}	Open Access 1	48238	Medrano Park	33385	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.484	Medrano Park	Local Park 2	4
11535	11535	11534	{"type": "Polygon", "coordinates": [[[-119.55396, 36.70525], [-119.55347, 36.70532], [-119.55338, 36.7049], [-119.55387, 36.70483], [-119.55396, 36.70525]]]}	Open Access 1	48239	Sanger Youth Center	32797	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	0.522	Sanger Youth Ctr.	Local Recreation Area 3	4
13367	13367	13366	{"type": "Polygon", "coordinates": [[[-119.56516, 36.71472], [-119.56512, 36.71475], [-119.56462, 36.71475], [-119.56419, 36.71469], [-119.56403, 36.71468], [-119.56388, 36.7147], [-119.56374, 36.71474], [-119.56358, 36.71482], [-119.56175, 36.71607], [-119.56161, 36.71611], [-119.5616, 36.7161], [-119.56505, 36.71374], [-119.56506, 36.71397], [-119.56515, 36.71397], [-119.56516, 36.71472]]]}	Open Access 1	35451	Sanger holding 1	25028	1315	Sanger, City of 231	City 2	City Agency 2	http://www.ci.sanger.ca.us/parks-rec.asp	City 2	1315	Sanger, City of 227	City 2	City Agency 2		Fresno 9	2.274	Sanger holding 1	Local Other or Unknown 14	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]);