calands: units_with_maps: 23 rows where DES_TP = 2 and MNG

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

23 rows where DES_TP = 2 and MNG_AGENCY = 512

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
2366	2366	2365	{"type": "Polygon", "coordinates": [[[-120.86852, 37.05834], [-120.8685, 37.05835], [-120.86824, 37.05832], [-120.86805, 37.05827], [-120.8679, 37.05819], [-120.86778, 37.05804], [-120.86758, 37.05772], [-120.86761, 37.05771], [-120.86852, 37.05834]]]}	Open Access 1	17156	Airport Park	15303	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.388	Airport Park	Local Park 2	4
3507	3507	3506	{"type": "Polygon", "coordinates": [[[-120.8508, 37.05224], [-120.8508, 37.05236], [-120.85041, 37.05236], [-120.85041, 37.05213], [-120.8508, 37.05224]]]}	Open Access 1	25980	Little Page Park	21351	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.165	Little Page Park	Local Park 2	4
4247	4247	4246	{"type": "Polygon", "coordinates": [[[-120.87444, 37.048], [-120.87444, 37.04918], [-120.87437, 37.04924], [-120.87215, 37.04924], [-120.87213, 37.0491], [-120.87216, 37.04795], [-120.87438, 37.04795], [-120.87444, 37.048]]]}	Open Access 1	48321	Oliveira Park	32885	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	7.201	Oliveira Park	Local Park 2	4
6545	6545	6544	{"type": "Polygon", "coordinates": [[[-120.82205, 37.06929], [-120.82203, 37.0704], [-120.8194, 37.07034], [-120.81944, 37.06924], [-120.82205, 37.06929]]]}	Open Access 1	25982	Verona Park	27005	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	7.1	Verona Park	Local Park 2	4
7451	7451	7450	{"type": "Polygon", "coordinates": [[[-120.84796, 37.06232], [-120.84785, 37.06248], [-120.84776, 37.06256], [-120.84764, 37.06262], [-120.84752, 37.06266], [-120.84726, 37.06269], [-120.84715, 37.06267], [-120.84697, 37.06263], [-120.84676, 37.06256], [-120.84659, 37.06246], [-120.84645, 37.06237], [-120.84632, 37.06225], [-120.84626, 37.06214], [-120.84624, 37.06204], [-120.84624, 37.0619], [-120.84627, 37.06181], [-120.84634, 37.06169], [-120.84641, 37.06162], [-120.84796, 37.06232]]]}	Open Access 1	48443	Henry Miller Plaza	33148	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	2.492	Henry Miller Plaza	Local Park 2	4
9080	9080	9079	{"type": "Polygon", "coordinates": [[[-120.83167, 37.06186], [-120.83167, 37.06285], [-120.83164, 37.06345], [-120.8315, 37.06346], [-120.83099, 37.06346], [-120.82896, 37.06343], [-120.82894, 37.06181], [-120.83167, 37.06186]]]}	Open Access 1	17165	Talbott Park	26173	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	10.697	Talbott Park	Local Park 2	4
9974	9974	9973	{"type": "Polygon", "coordinates": [[[-120.83251, 37.0478], [-120.8325, 37.04919], [-120.83102, 37.0492], [-120.83096, 37.04915], [-120.83095, 37.04844], [-120.83092, 37.04831], [-120.83088, 37.04825], [-120.83085, 37.04816], [-120.83131, 37.04813], [-120.83133, 37.04778], [-120.83251, 37.0478]]]}	Open Access 1	17160	College Green Park	17503	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	5.007	College Green Park	Local Park 2	4
9976	9976	9975	{"type": "Polygon", "coordinates": [[[-120.86345, 37.06099], [-120.86343, 37.06202], [-120.86271, 37.06203], [-120.86293, 37.06176], [-120.86305, 37.06159], [-120.86338, 37.06099], [-120.86345, 37.06099]]]}	Open Access 1	17162	Big Page Park	16084	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.921	Big Page Park	Local Park 2	4
11942	11942	11941	{"type": "Polygon", "coordinates": [[[-120.84713, 37.04245], [-120.84713, 37.04345], [-120.84567, 37.04345], [-120.84567, 37.04249], [-120.84573, 37.04244], [-120.84713, 37.04245]]]}	Open Access 1	24559	Cresthills Park	17807	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	3.569	Cresthills Park	Local Park 2	4
11943	11943	11942	{"type": "Polygon", "coordinates": [[[-120.86657, 37.05677], [-120.86547, 37.0568], [-120.86547, 37.0568], [-120.86569, 37.05635], [-120.86618, 37.05655], [-120.86657, 37.05677]]]}	Open Access 1	24560	Wolfsen Park	33697	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.633	Wolfsen Park	Local Park 2	4
11950	11950	11949	{"type": "Polygon", "coordinates": [[[-120.81874, 37.06099], [-120.81873, 37.06123], [-120.81853, 37.06124], [-120.81852, 37.06151], [-120.8182, 37.0615], [-120.81821, 37.0609], [-120.81853, 37.06082], [-120.81856, 37.06088], [-120.81862, 37.06093], [-120.81874, 37.06099]]]}	Open Access 1	24566	Rancho Dos Amigos Park	24142	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.665	Rancho Dos Amigos Park	Local Park 2	4
11951	11951	11950	{"type": "Polygon", "coordinates": [[[-120.84485, 37.07714], [-120.84483, 37.07869], [-120.84364, 37.07869], [-120.84367, 37.07737], [-120.84365, 37.07719], [-120.84371, 37.07714], [-120.84485, 37.07714]]]}	Open Access 1	24567	Ranchwood Park	24183	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	4.494	Ranchwood Park	Local Park 2	4
11952	11952	11951	{"type": "Polygon", "coordinates": [[[-120.84517, 37.06501], [-120.84392, 37.06683], [-120.84248, 37.0662], [-120.84374, 37.06437], [-120.84517, 37.06501]]]}	Open Access 1	24568	Little League Park	21349	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	8.359	Little League Park	Local Park 2	4
11953	11953	11952	{"type": "Polygon", "coordinates": [[[-120.83199, 37.08099], [-120.83182, 37.08135], [-120.83169, 37.08146], [-120.83194, 37.08167], [-120.83168, 37.08187], [-120.83138, 37.08166], [-120.83116, 37.08181], [-120.83116, 37.08263], [-120.82995, 37.08262], [-120.82989, 37.08257], [-120.82991, 37.08075], [-120.82996, 37.08071], [-120.83118, 37.08072], [-120.83118, 37.08099], [-120.83199, 37.08099]]]}	Open Access 1	24569	Skylark Park	25536	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	7.202	Skylark Park	Local Park 2	4
12268	12268	12267	{"type": "Polygon", "coordinates": [[[-120.81962, 37.06595], [-120.81952, 37.06616], [-120.81949, 37.06634], [-120.81768, 37.06633], [-120.81768, 37.06535], [-120.81776, 37.0653], [-120.81793, 37.0653], [-120.81825, 37.06533], [-120.81846, 37.06537], [-120.81867, 37.06545], [-120.81888, 37.06555], [-120.81917, 37.06575], [-120.81931, 37.06583], [-120.81962, 37.06595]]]}	Open Access 1	25979	Jo Lin Park	20416	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	3.746	Jo Lin Park	Local Park 2	4
12274	12274	12273	{"type": "Polygon", "coordinates": [[[-120.88074, 37.0513], [-120.88052, 37.05153], [-120.88038, 37.05151], [-120.88026, 37.05154], [-120.8802, 37.05146], [-120.8801, 37.05143], [-120.88012, 37.05135], [-120.88008, 37.05123], [-120.88029, 37.05101], [-120.88074, 37.0513]]]}	Open Access 1	48789	Neighborhood Park	33512	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2	http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf	Merced 37	0.508	Neighborhood Park	Local Park 2	4
12314	12314	12313	{"type": "Polygon", "coordinates": [[[-120.85118, 37.05874], [-120.85101, 37.05897], [-120.85057, 37.05878], [-120.85048, 37.05889], [-120.85003, 37.05869], [-120.85107, 37.05869], [-120.85118, 37.05874]]]}	Open Access 1	25975	Catholic Park	16978	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.408	Catholic Park	Local Park 2	4
12317	12317	12316	{"type": "Polygon", "coordinates": [[[-120.83791, 37.07101], [-120.8379, 37.0712], [-120.83756, 37.07144], [-120.83712, 37.07102], [-120.8372, 37.07098], [-120.83724, 37.0709], [-120.83757, 37.07092], [-120.83791, 37.07101]]]}	Open Access 1	25978	Davis Park	17952	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.618	Davis Park	Local Park 2	4
12321	12321	12320	{"type": "Polygon", "coordinates": [[[-120.84144, 37.04562], [-120.84101, 37.04582], [-120.84084, 37.04572], [-120.84096, 37.04555], [-120.84092, 37.04526], [-120.84126, 37.04521], [-120.84129, 37.04531], [-120.84144, 37.04562]]]}	Open Access 1	25983	Presidential Park	23989	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.542	Presidential Park	Local Park 2	4
13313	13313	13312	{"type": "Polygon", "coordinates": [[[-120.87486, 37.05002], [-120.87486, 37.05031], [-120.87472, 37.05043], [-120.87464, 37.0504], [-120.87454, 37.05043], [-120.8745, 37.05038], [-120.87432, 37.05028], [-120.87433, 37.04996], [-120.87486, 37.05002]]]}	Open Access 1	35378	Village Park	33696	1189	Los Banos, City of 519	City 2	City Agency 2	http://www.losbanos.org/city-government/departments/public-works/	City 2	1189	Los Banos, City of 512	City 2	City Agency 2		Merced 37	0.507	Village 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]);