calands: units_with_maps: 34 rows where ACCESS_TYP = 1, COUNTY = 37 and MNG

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

34 rows where ACCESS_TYP = 1, COUNTY = 37 and MNG_AGENCY = 467

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
2060	2060	2059	{"type": "Polygon", "coordinates": [[[-120.5026, 37.32463], [-120.50255, 37.32632], [-120.49733, 37.32619], [-120.49733, 37.32628], [-120.49619, 37.32625], [-120.49612, 37.32633], [-120.49608, 37.32681], [-120.49667, 37.32683], [-120.49656, 37.32703], [-120.49646, 37.32775], [-120.49506, 37.32776], [-120.49478, 37.32773], [-120.49448, 37.32767], [-120.49415, 37.32753], [-120.49257, 37.32679], [-120.49224, 37.32671], [-120.49198, 37.32668], [-120.49227, 37.32645], [-120.4925, 37.32639], [-120.4938, 37.32607], [-120.49499, 37.32599], [-120.49551, 37.3258], [-120.4955, 37.32517], [-120.49477, 37.32497], [-120.49422, 37.32489], [-120.49382, 37.32488], [-120.48924, 37.32491], [-120.48822, 37.32573], [-120.48823, 37.32621], [-120.48701, 37.32619], [-120.48707, 37.325], [-120.4871, 37.32472], [-120.5026, 37.32463]]]}	Open Access 1	17183	Fahrens Park	18783	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	49.713	Fahrens Park	Local Park 2	4
2061	2061	2060	{"type": "Polygon", "coordinates": [[[-120.48346, 37.28095], [-120.48345, 37.28231], [-120.48218, 37.28228], [-120.48217, 37.28092], [-120.48346, 37.28095]]]}	Open Access 1	17190	Flanagan Park	18939	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	4.228	Flanagan Park	Local Park 2	4
2069	2069	2068	{"type": "Polygon", "coordinates": [[[-120.45486, 37.32488], [-120.45107, 37.32489], [-120.45114, 37.32226], [-120.45128, 37.32237], [-120.45151, 37.32264], [-120.45184, 37.32277], [-120.45213, 37.32281], [-120.4523, 37.32277], [-120.45322, 37.32263], [-120.45421, 37.32265], [-120.4544, 37.32276], [-120.45458, 37.3229], [-120.45448, 37.32309], [-120.45444, 37.32341], [-120.45433, 37.32358], [-120.45409, 37.32381], [-120.45384, 37.32413], [-120.45368, 37.3244], [-120.45359, 37.32461], [-120.45356, 37.32471], [-120.45367, 37.32477], [-120.45419, 37.32473], [-120.45458, 37.32476], [-120.45486, 37.32488]]]}	Open Access 1	17208	Rahilly Park	24073	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	16.515	Rahilly Park	Local Park 2	4
2372	2372	2371	{"type": "Polygon", "coordinates": [[[-120.48762, 37.31278], [-120.48744, 37.31322], [-120.48708, 37.31318], [-120.48628, 37.31314], [-120.4856, 37.31321], [-120.48531, 37.31326], [-120.48449, 37.31331], [-120.48401, 37.3133], [-120.48373, 37.31327], [-120.48279, 37.31304], [-120.48243, 37.313], [-120.48224, 37.313], [-120.48161, 37.31306], [-120.4806, 37.31328], [-120.48031, 37.31333], [-120.48017, 37.31333], [-120.47897, 37.31315], [-120.4788, 37.31311], [-120.47863, 37.31304], [-120.4795, 37.31153], [-120.48011, 37.31176], [-120.48037, 37.31133], [-120.48279, 37.31222], [-120.48314, 37.31166], [-120.48462, 37.3122], [-120.48488, 37.31179], [-120.48762, 37.31278]]]}	Open Access 1	17174	Applegate Park	15542	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	25.808	Applegate Park	Local Park 2	4
2373	2373	2372	{"type": "Polygon", "coordinates": [[[-120.45084, 37.32863], [-120.45083, 37.32986], [-120.4489, 37.32986], [-120.4489, 37.32887], [-120.44895, 37.32866], [-120.44899, 37.32859], [-120.45079, 37.32859], [-120.45084, 37.32863]]]}	Open Access 1	17177	Bob Carpenter Park	16207	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	5.954	Bob Carpenter Park	Local Park 2	4
2374	2374	2373	{"type": "Polygon", "coordinates": [[[-120.46587, 37.3165], [-120.46587, 37.31737], [-120.46537, 37.31766], [-120.46535, 37.31792], [-120.46535, 37.31835], [-120.46479, 37.31836], [-120.46481, 37.31765], [-120.46481, 37.3165], [-120.46587, 37.3165]]]}	Open Access 1	17180	Burbank Park	16509	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	3.754	Burbank Park	Local Park 2	4
2378	2378	2377	{"type": "Polygon", "coordinates": [[[-120.48172, 37.28829], [-120.4811, 37.28936], [-120.478, 37.28823], [-120.48172, 37.28829], [-120.48172, 37.28829]]]}	Open Access 1	17196	Macias Park	21633	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	4.912	Macias Park	Local Park 2	4
2381	2381	2380	{"type": "Polygon", "coordinates": [[[-120.48826, 37.29263], [-120.4869, 37.29499], [-120.48565, 37.29453], [-120.48701, 37.29217], [-120.48826, 37.29263]]]}	Open Access 1	17202	McNamara Park	22059	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	8.697	McNamara Park	Local Park 2	4
2383	2383	2382	{"type": "Polygon", "coordinates": [[[-120.50168, 37.29469], [-120.50126, 37.29543], [-120.50001, 37.29497], [-120.50043, 37.29424], [-120.50168, 37.29469]]]}	Open Access 1	17213	Stephen Leonard Park	25831	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	2.699	Stephen Leonard Park	Local Park 2	4
3124	3124	3123	{"type": "Polygon", "coordinates": [[[-120.49375, 37.29584], [-120.49364, 37.29603], [-120.49319, 37.29587], [-120.4933, 37.29568], [-120.49375, 37.29584]]]}	Open Access 1	25452	Diego Rivera Park	18153	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	0.253	Diego Rivera Park	Local Park 2	4
3125	3125	3124	{"type": "Polygon", "coordinates": [[[-120.49486, 37.28895], [-120.49462, 37.28936], [-120.49421, 37.28921], [-120.49439, 37.2889], [-120.49457, 37.28897], [-120.49463, 37.28887], [-120.49486, 37.28895]]]}	Open Access 1	25453	Harriet Tubman Park	19693	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	0.447	Harriet Tubman Park	Local Park 2	4
3469	3469	3468	{"type": "Polygon", "coordinates": [[[-120.48998, 37.28962], [-120.48977, 37.29], [-120.48961, 37.28994], [-120.48982, 37.28957], [-120.48998, 37.28962]]]}	Open Access 1	25449	The Love Veasley Family Park	26287	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	0.171	The Love Veasley Family Park	Local Park 2	4
3470	3470	3469	{"type": "Polygon", "coordinates": [[[-120.50555, 37.29161], [-120.50555, 37.29165], [-120.50529, 37.29156], [-120.50523, 37.29164], [-120.50399, 37.29119], [-120.50379, 37.29152], [-120.50367, 37.29147], [-120.50412, 37.29068], [-120.50444, 37.29079], [-120.50425, 37.29113], [-120.50468, 37.29129], [-120.50468, 37.29131], [-120.5049, 37.29138], [-120.50492, 37.29138], [-120.50555, 37.29161]]]}	Open Access 1	25454	Benjamin Banneker Memorial Park	16013	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	0.968	Benjamin Banneker Memorial Park	Local Park 2	4
3571	3571	3570	{"type": "Polygon", "coordinates": [[[-120.50508, 37.29722], [-120.5047, 37.29789], [-120.5044, 37.29778], [-120.50459, 37.29745], [-120.50461, 37.29727], [-120.50487, 37.29683], [-120.50447, 37.29668], [-120.50449, 37.29664], [-120.50499, 37.29683], [-120.50508, 37.29722]]]}	Open Access 1	47307	Fredrick Douglas Park	31014	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2	https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp	Merced 37	0.898	Fredrick Douglas Park	Local Park 2	4
3611	3611	3610	{"type": "Polygon", "coordinates": [[[-120.47782, 37.29312], [-120.47757, 37.29354], [-120.47726, 37.29343], [-120.47751, 37.293], [-120.47782, 37.29312]]]}	Open Access 1	47308	E. 12th Street Neighborhood Park	31015	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2	https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp	Merced 37	0.39	E. 12th Street Neighborhood Park	Local Park 2	4
3612	3612	3611	{"type": "Polygon", "coordinates": [[[-120.4815, 37.29325], [-120.48128, 37.29362], [-120.48113, 37.29357], [-120.48134, 37.29319], [-120.4815, 37.29325]]]}	Open Access 1	47309	11th Street Neighborhood Park	31016	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2	https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp	Merced 37	0.172	11th Street Neighborhood Park	Local Park 2	4
5004	5004	5003	{"type": "Polygon", "coordinates": [[[-120.48291, 37.32505], [-120.48255, 37.32505], [-120.48249, 37.32529], [-120.48243, 37.32524], [-120.48239, 37.32506], [-120.48168, 37.32507], [-120.48162, 37.32522], [-120.48153, 37.32506], [-120.48117, 37.32506], [-120.48116, 37.326], [-120.48111, 37.32627], [-120.48086, 37.32635], [-120.48072, 37.3262], [-120.48075, 37.32506], [-120.48039, 37.32506], [-120.4803, 37.32523], [-120.48021, 37.32507], [-120.47965, 37.32507], [-120.47945, 37.32511], [-120.4794, 37.32527], [-120.47928, 37.32514], [-120.47898, 37.32519], [-120.47864, 37.32527], [-120.47865, 37.32539], [-120.47856, 37.32544], [-120.47852, 37.3253], [-120.47852, 37.32498], [-120.47961, 37.3248], [-120.48291, 37.32478], [-120.48291, 37.32505]]]}	Open Access 1	17210	Santa Fe Park	25086	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	4.44	Santa Fe Park	Local Park 2	4
6807	6807	6806	{"type": "Polygon", "coordinates": [[[-120.49516, 37.33647], [-120.49512, 37.33651], [-120.49363, 37.33653], [-120.49356, 37.33652], [-120.49344, 37.33648], [-120.49326, 37.33649], [-120.49313, 37.33654], [-120.49309, 37.33658], [-120.49305, 37.33665], [-120.49304, 37.33673], [-120.49312, 37.33691], [-120.49313, 37.33724], [-120.49308, 37.33729], [-120.49169, 37.33729], [-120.49151, 37.33731], [-120.49119, 37.3374], [-120.49074, 37.33762], [-120.49069, 37.33757], [-120.49251, 37.33673], [-120.49234, 37.33648], [-120.49227, 37.33648], [-120.49225, 37.33643], [-120.49196, 37.33608], [-120.49195, 37.33603], [-120.49192, 37.33598], [-120.49182, 37.33592], [-120.49182, 37.33566], [-120.49497, 37.33562], [-120.49505, 37.33564], [-120.49513, 37.33571], [-120.49514, 37.33579], [-120.49516, 37.33647]]]}	Open Access 1	48906	Rudolph Joseph Merino Neighborhood Park	33623	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2	https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/48/3557	Merced 37	8.806	Rudolph Joseph Merino Neighborhood Park	Local Park 2	4
7213	7213	7212	{"type": "MultiPolygon", "coordinates": [[[[-120.48044, 37.3308], [-120.48043, 37.33102], [-120.47957, 37.33103], [-120.47936, 37.33099], [-120.47933, 37.33122], [-120.47925, 37.33123], [-120.47914, 37.33095], [-120.47891, 37.33092], [-120.47889, 37.33086], [-120.47856, 37.33086], [-120.47855, 37.33077], [-120.47917, 37.3308], [-120.47927, 37.33059], [-120.47937, 37.33058], [-120.47938, 37.33085], [-120.47958, 37.33078], [-120.48044, 37.3308]]], [[[-120.4793, 37.32869], [-120.47929, 37.32887], [-120.4786, 37.32886], [-120.47861, 37.32869], [-120.4793, 37.32869]]], [[[-120.48191, 37.32963], [-120.48164, 37.32966], [-120.48163, 37.32947], [-120.48171, 37.32924], [-120.4817, 37.32878], [-120.48157, 37.32866], [-120.48138, 37.32884], [-120.48131, 37.32881], [-120.48137, 37.32859], [-120.48105, 37.32859], [-120.4808, 37.32878], [-120.48031, 37.32878], [-120.4802, 37.3288], [-120.48026, 37.32899], [-120.4802, 37.32901], [-120.48002, 37.32882], [-120.47985, 37.32888], [-120.47951, 37.32886], [-120.47952, 37.32874], [-120.48006, 37.32871], [-120.48051, 37.32863], [-120.48106, 37.32847], [-120.48106, 37.32826], [-120.48081, 37.32825], [-120.4808, 37.32818], [-120.48108, 37.32809], [-120.48095, 37.32774], [-120.48112, 37.32754], [-120.48112, 37.3274], [-120.48082, 37.32746], [-120.4808, 37.3274], [-120.48115, 37.3272], [-120.48117, 37.32678], [-120.48125, 37.32673], [-120.48112, 37.32649], [-120.48123, 37.32645], [-120.48137, 37.32642], [-120.4813, 37.3283], [-120.48191, 37.32831], [-120.48192, 37.32892], [-120.48191, 37.32963]]], [[[-120.48253, 37.33199], [-120.48223, 37.33198], [-120.48223, 37.33128], [-120.48197, 37.33132], [-120.48193, 37.33125], [-120.48216, 37.3311], [-120.48208, 37.3309], [-120.48178, 37.33097], [-120.48136, 37.33103], [-120.48067, 37.33103], [-120.48068, 37.33081], [-120.48113, 37.33081], [-120.48165, 37.33085], [-120.48203, 37.33078], [-120.48196, 37.33061], [-120.48164, 37.33053], [-120.48163, 37.33047], [-120.48189, 37.33041], [-120.48175, 37.33011], [-120.48174, 37.32983], [-120.4823, 37.32978], [-120.48241, 37.3303], [-120.48263, 37.33096], [-120.48262, 37.33118], [-120.48253, 37.33163], [-120.48253, 37.33199]]]]}	Open Access 1	48907	Santa Fe Strip Park	33624	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2	https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/26/3556	Merced 37	7.737	Santa Fe Strip Park	Local Park 2	4
7221	7221	7220	{"type": "Polygon", "coordinates": [[[-120.43929, 37.329], [-120.43929, 37.32952], [-120.43925, 37.32958], [-120.4392, 37.3296], [-120.43809, 37.3296], [-120.43785, 37.32954], [-120.4377, 37.32947], [-120.43758, 37.32938], [-120.43748, 37.32927], [-120.43739, 37.32908], [-120.43738, 37.32895], [-120.43738, 37.32783], [-120.43739, 37.32779], [-120.43743, 37.32776], [-120.43749, 37.32774], [-120.4389, 37.32774], [-120.4389, 37.329], [-120.43929, 37.329]]]}	Open Access 1	48908	Richard Bernasconi Neighborhood Park	33625	1203	Merced, City of 474	City 2	City Agency 2	http://www.cityofmerced.org/depts/parks_n_community_services/default.asp	City 2	1203	Merced, City of 467	City 2	City Agency 2		Merced 37	7.14	Richard Bernasconi Neighborhood 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]);