calands: superunits_with_maps: 9 rows where ACCESS_TYP = 1 and MNG

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

9 rows where ACCESS_TYP = 1 and MNG_AGENCY = 222

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME
1925	1925	1924	{"type": "Polygon", "coordinates": [[[-118.14718, 33.96609], [-118.14712, 33.96647], [-118.14626, 33.96637], [-118.14632, 33.96599], [-118.14718, 33.96609]]]}	Open Access 1	Bell Gardens Skate Park	15973	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	0.846	Bell Gardens Skate Park
1926	1926	1925	{"type": "Polygon", "coordinates": [[[-118.14779, 33.96666], [-118.14653, 33.96905], [-118.14636, 33.96903], [-118.14574, 33.96873], [-118.14515, 33.96857], [-118.14451, 33.96848], [-118.14396, 33.96847], [-118.14355, 33.96862], [-118.14334, 33.96843], [-118.14472, 33.96729], [-118.14589, 33.96643], [-118.14633, 33.96643], [-118.14769, 33.96663], [-118.14779, 33.96666]]]}	Open Access 1	Bell Gardens Veterans Park	15974	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	15.747	Bell Gardens Veterans Park
3446	3446	3445	{"type": "Polygon", "coordinates": [[[-118.15515, 33.96751], [-118.15498, 33.96776], [-118.15456, 33.96756], [-118.15464, 33.96745], [-118.15515, 33.96751]]]}	Open Access 1	Darwell Park	17932	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	0.258	Darwell Park
3911	3911	3910	{"type": "Polygon", "coordinates": [[[-118.13578, 33.97095], [-118.13573, 33.97131], [-118.13556, 33.97129], [-118.1354, 33.97125], [-118.13522, 33.97117], [-118.13518, 33.97112], [-118.13518, 33.97109], [-118.13521, 33.97105], [-118.13551, 33.97089], [-118.13555, 33.97093], [-118.13578, 33.97095]]]}	Open Access 1	Hannon Park	19644	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	0.422	Hannon Park
5544	5544	5543	{"type": "Polygon", "coordinates": [[[-118.15253, 33.95835], [-118.15242, 33.95897], [-118.15215, 33.95902], [-118.14896, 33.96015], [-118.1485, 33.95921], [-118.14857, 33.95917], [-118.14838, 33.95879], [-118.1518, 33.95694], [-118.15197, 33.95717], [-118.15187, 33.95827], [-118.15253, 33.95835]]]}	Open Access 1	John Anson Ford Park	20427	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	16.872	John Anson Ford Park
5626	5626	5625	{"type": "Polygon", "coordinates": [[[-118.17025, 33.95555], [-118.17024, 33.95602], [-118.17013, 33.95601], [-118.17003, 33.95606], [-118.17004, 33.95617], [-118.16923, 33.95659], [-118.16909, 33.95662], [-118.17025, 33.95555]]]}	Open Access 1	Julia Russ Asmus Park	20517	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	0.755	Julia Russ Asmus Park
6702	6702	6701	{"type": "Polygon", "coordinates": [[[-118.16696, 33.97193], [-118.16688, 33.97253], [-118.16625, 33.97247], [-118.16632, 33.97187], [-118.16696, 33.97193]]]}	Open Access 1	Marlow Park	21881	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	0.981	Marlow Park
12453	12453	12452	{"type": "Polygon", "coordinates": [[[-118.15556, 33.95835], [-118.15538, 33.95925], [-118.15264, 33.95897], [-118.15242, 33.95897], [-118.15252, 33.95836], [-118.15187, 33.95828], [-118.15197, 33.95717], [-118.1518, 33.95694], [-118.15268, 33.95647], [-118.15296, 33.95675], [-118.15505, 33.95697], [-118.15527, 33.9572], [-118.15526, 33.95753], [-118.15531, 33.95757], [-118.15543, 33.95776], [-118.15532, 33.9583], [-118.15556, 33.95835]]]}	Open Access 1	Bell Gardens Sports Center at Ford Park	29495	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	19.002	Bell Gardens Sports Ctr. at Ford Park
12457	12457	12456	{"type": "Polygon", "coordinates": [[[-118.16062, 33.9611], [-118.16055, 33.96157], [-118.16034, 33.96154], [-118.16041, 33.96108], [-118.16062, 33.9611]]]}	Open Access 1	Gallant Park	29499	1023	Bell Gardens, City of 222	City 2	City Agency 2	http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx	City 2	0.256	Gallant Park

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);