Run the following script to setup the Chicago parks tables:

ChicagoParksSetup.sql

/************************** 

 Source:

 City of Chicago

 https://data.cityofchicago.org/

 *************************/

SET NOCOUNT ON

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'ChicagoParks') AND type in (N'U'))

 DROP TABLE ChicagoParks

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'ChicagoRegions') AND type in (N'U'))

 DROP TABLE ChicagoRegions

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'ChicagoBikeRacks') AND type in (N'U'))

 DROP TABLE ChicagoBikeRacks

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'ChicagoCommunities') AND type in (N'U'))

 DROP TABLE ChicagoCommunities

GO

CREATE TABLE ChicagoBikeRacks

(

 RackID DECIMAL(6, 0) NOT NULL,

 WardNumber DECIMAL(3, 0) NULL,

 CommunityAreaNumber DECIMAL(3, 0) NOT NULL,

 Latitude DECIMAL(9, 6) NOT NULL,

 Longitude DECIMAL(9, 6) NOT NULL,

 CONSTRAINT PK_RackID PRIMARY KEY CLUSTERED (RackID) 

)

GO

CREATE TABLE ChicagoCommunities

(

 CommunityAreaNumber DECIMAL(3, 0) NOT NULL,

 CommunityName VARCHAR(30) NULL,

 CONSTRAINT PK_CommunityAreaNumber PRIMARY KEY CLUSTERED (CommunityAreaNumber)

)

GO

CREATE TABLE ChicagoParks

(

 ParkNumber DECIMAL(6, 0) NOT NULL,

 ParkName VARCHAR(50) NULL,

 StreetAddress VARCHAR(50) NULL,

 City VARCHAR(50) NULL,

 State char(2) NULL,

 ZipCode VARCHAR(5) NULL,

 Acres DECIMAL(7, 2) NULL,

 CPDAcres DECIMAL(7, 2) NULL,

 WardNumber DECIMAL(3, 0) NOT NULL,

 CommunityAreaNumber DECIMAL(3, 0) NOT NULL,

 Region VARCHAR(3) NOT NULL,

 JrBaseball DECIMAL(5, 0) NULL,

 SrBaseball DECIMAL(5, 0) NULL,

 Softball DECIMAL(5, 0) NULL,

 Football DECIMAL(5, 0) NULL,

 Artificial DECIMAL(5, 0) NULL,

 BasketballCourt DECIMAL(5, 0) NULL,

 Backboards DECIMAL(5, 0) NULL,

 HandRaquetBall DECIMAL(5, 0) NULL,

 Tennis DECIMAL(5, 0) NULL,

 Volleyball DECIMAL(5, 0) NULL,

 Horseshoes DECIMAL(5, 0) NULL,

 IceSkating DECIMAL(5, 0) NULL,

 SkatePark DECIMAL(5, 0) NULL,

 RollerHockeyCourt DECIMAL(5, 0) NULL,

 Playground DECIMAL(5, 0) NULL,

 SaPlayground DECIMAL(5, 0) NULL,

 Track DECIMAL(5, 0) NULL,

 FieldHouse DECIMAL(5, 0) NULL,

 DogFriendlyArea DECIMAL(5, 0) NULL,

 FitnessCenter DECIMAL(5, 0) NULL,

 Beach DECIMAL(5, 0) NULL,

 SprayPool DECIMAL(5, 0) NULL,

 WaterPlayground DECIMAL(5, 0) NULL,

 PoolOutdoor DECIMAL(5, 0) NULL,

 Natatorium DECIMAL(5, 0) NULL,

 ShapeLength FLOAT NULL,

 ShapeArea FLOAT NULL,

 CONSTRAINT PK_Parks PRIMARY KEY CLUSTERED (ParkNumber)

)

GO

CREATE TABLE ChicagoRegions

(

 Region VARCHAR(3) NOT NULL,

 RegionDescription VARCHAR(30) NULL,

 CONSTRAINT PK_Region PRIMARY KEY CLUSTERED (Region)

)

GO

INSERT ChicagoRegions (Region, RegionDescription) VALUES ('C', 'Central');

INSERT ChicagoRegions (Region, RegionDescription) VALUES ('C_S', 'Central_South');

INSERT ChicagoRegions (Region, RegionDescription) VALUES ('L', 'Lakefront');

INSERT ChicagoRegions (Region, RegionDescription) VALUES ('N', 'North');

INSERT ChicagoRegions (Region, RegionDescription) VALUES ('N_C', 'North_Central');

INSERT ChicagoRegions (Region, RegionDescription) VALUES ('S', 'South');

GO

INSERT ChicagoCommunities VALUES (1, 'Rogers Park');

INSERT ChicagoCommunities VALUES (2, 'West Ridge');

INSERT ChicagoCommunities VALUES (3, 'Uptown');

INSERT ChicagoCommunities VALUES (4, 'Lincoln Square');

INSERT ChicagoCommunities VALUES (5, 'North Center');

INSERT ChicagoCommunities VALUES (6, 'Lake View');

INSERT ChicagoCommunities VALUES (7, 'Lincoln Park');

INSERT ChicagoCommunities VALUES (8, 'Near North Side');

INSERT ChicagoCommunities VALUES (9, 'Edison Park');

INSERT ChicagoCommunities VALUES (10, 'Norwood Park');

INSERT ChicagoCommunities VALUES (11, 'Jefferson Park');

INSERT ChicagoCommunities VALUES (12, 'Forest Glen');

INSERT ChicagoCommunities VALUES (13, 'North Park');

INSERT ChicagoCommunities VALUES (14, 'Albany Park');

INSERT ChicagoCommunities VALUES (15, 'Portage Park');

INSERT ChicagoCommunities VALUES (16, 'Irving Park');

INSERT ChicagoCommunities VALUES (17, 'Dunning');

INSERT ChicagoCommunities VALUES (18, 'Montclare');

INSERT ChicagoCommunities VALUES (19, 'Belmont Cragin');

INSERT ChicagoCommunities VALUES (20, 'Hermosa');

INSERT ChicagoCommunities VALUES (21, 'Avondale');

INSERT ChicagoCommunities VALUES (22, 'Logan Square');

INSERT ChicagoCommunities VALUES (23, 'Humboldt Park');

INSERT ChicagoCommunities VALUES (24, 'West Town');

INSERT ChicagoCommunities VALUES (25, 'Austin');

INSERT ChicagoCommunities VALUES (26, 'West Garfield Park');

INSERT ChicagoCommunities VALUES (27, 'East Garfield Park');

INSERT ChicagoCommunities VALUES (28, 'Near West Side');

INSERT ChicagoCommunities VALUES (29, 'North Lawndale');

INSERT ChicagoCommunities VALUES (30, 'South Lawndale');

INSERT ChicagoCommunities VALUES (31, 'Lower West Side');

INSERT ChicagoCommunities VALUES (32, 'Loop');

INSERT ChicagoCommunities VALUES (33, 'Near South Side');

INSERT ChicagoCommunities VALUES (34, 'Armour Square');

INSERT ChicagoCommunities VALUES (35, 'Douglas');

INSERT ChicagoCommunities VALUES (36, 'Oakland');

INSERT ChicagoCommunities VALUES (37, 'Fuller Park');

INSERT ChicagoCommunities VALUES (38, 'Grand Boulevard');

INSERT ChicagoCommunities VALUES (39, 'Kenwood');

INSERT ChicagoCommunities VALUES (40, 'Washington Park');

INSERT ChicagoCommunities VALUES (41, 'Hyde Park');

INSERT ChicagoCommunities VALUES (42, 'Woodlawn');

INSERT ChicagoCommunities VALUES (43, 'South Shore');

INSERT ChicagoCommunities VALUES (44, 'Chatham');

INSERT ChicagoCommunities VALUES (45, 'Avalon Park');

INSERT ChicagoCommunities VALUES (46, 'South Chicago');

INSERT ChicagoCommunities VALUES (47, 'Burnside');

INSERT ChicagoCommunities VALUES (48, 'Calumet Heights');

INSERT ChicagoCommunities VALUES (49, 'Roseland');

INSERT ChicagoCommunities VALUES (50, 'Pullman');

INSERT ChicagoCommunities VALUES (51, 'South Deering');

INSERT ChicagoCommunities VALUES (52, 'East Side');

INSERT ChicagoCommunities VALUES (53, 'West Pullman');

INSERT ChicagoCommunities VALUES (54, 'Riverdale');

INSERT ChicagoCommunities VALUES (55, 'Hegewisch');

INSERT ChicagoCommunities VALUES (56, 'Garfield Ridge');

INSERT ChicagoCommunities VALUES (57, 'Archer Heights');

INSERT ChicagoCommunities VALUES (58, 'Brighton Park');

INSERT ChicagoCommunities VALUES (59, 'McKinley Park');

INSERT ChicagoCommunities VALUES (60, 'Bridgeport');

INSERT ChicagoCommunities VALUES (61, 'New City');

INSERT ChicagoCommunities VALUES (62, 'West Elsdon');

INSERT ChicagoCommunities VALUES (63, 'Gage Park');

INSERT ChicagoCommunities VALUES (64, 'Clearing');

INSERT ChicagoCommunities VALUES (65, 'West Lawn');

INSERT ChicagoCommunities VALUES (66, 'Chicago Lawn');

INSERT ChicagoCommunities VALUES (67, 'West Englewood');

INSERT ChicagoCommunities VALUES (68, 'Englewood');

INSERT ChicagoCommunities VALUES (69, 'Greater Grand Crossing');

INSERT ChicagoCommunities VALUES (70, 'Ashburn');

INSERT ChicagoCommunities VALUES (71, 'Auburn Gresham');

INSERT ChicagoCommunities VALUES (72, 'Beverly');

INSERT ChicagoCommunities VALUES (73, 'Washington Heights');

INSERT ChicagoCommunities VALUES (74, 'Mount Greenwood');

INSERT ChicagoCommunities VALUES (75, 'Morgan Park');

INSERT ChicagoCommunities VALUES (76, 'O''Hare');

INSERT ChicagoCommunities VALUES (77, 'Edgewater');

GO

INSERT ChicagoParks VALUES (2, 'MCGUANE (JOHN)', '2901 S POPLAR AVE', 'CHICAGO', 'IL', '60608', 9.78, 10.00, 11, 60, 'C', 2, 1, 1, 1, 0, 2, 4, 0, 5, 1, 4, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 2687.50274362, 426072.758426);

INSERT ChicagoParks VALUES (3, 'ARMOUR (PHILIP) SQUARE', '3309 S SHIELDS AVE', 'CHICAGO', 'IL', '60616', 8.21, 10.00, 11, 34, 'C', 1, 1, 2, 1, 0, 0, 0, 2, 2, 1, 2, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 2392.14512778, 357645.146453);

INSERT ChicagoParks VALUES (4, 'FULLER (MELVILLE)', '331 W 45TH ST', 'CHICAGO', 'IL', '60609', 11.25, 10.50, 3, 37, 'C', 0, 1, 2, 1, 0, 3, 6, 0, 2, 2, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 2855.36907871, 489992.934532);

INSERT ChicagoParks VALUES (5, 'CORNELL (PAUL) SQUARE', '1809 W 50TH ST', 'CHICAGO', 'IL', '60609', 8.19, 8.29, 16, 61, 'C', 2, 0, 0, 1, 0, 2, 4, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 2389.51032012, 356853.081395);

INSERT ChicagoParks VALUES (6, 'RUSSELL (MARTIN) SQUARE', '3045 E 83RD ST', 'CHICAGO', 'IL', '60617', 10.05, 11.47, 7, 46, 'S', 2, 1, 0, 1, 0, 2, 4, 0, 3, 2, 1, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 2775.51968349, 437881.133257);

INSERT ChicagoParks VALUES (7, 'SHERMAN (JOHN)', '1307 W 52ND ST', 'CHICAGO', 'IL', '60609', 53.69, 60.60, 16, 61, 'S', 3, 0, 0, 3, 0, 2, 4, 2, 2, 1, 0, 0, 0, 0, 3, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 16038.4022875, 2338578.04314);

INSERT ChicagoParks VALUES (8, 'OGDEN (WILLIAM)', '6500 S RACINE AVE', 'CHICAGO', 'IL', '60636', 57.05, 60.54, 17, 67, 'S', 7, 2, 0, 4, 0, 4, 8, 0, 4, 1, 0, 0, 0, 0, 3, 0, 1, 1, 0, 1, 0, 0, 1, 1, 0, 8360.71662127, 2484958.85649);

INSERT ChicagoParks VALUES (9, 'HAMILTON (ALEXANDER)', '513 W 72ND ST', 'CHICAGO', 'IL', '60621', 28.42, 29.95, 17, 68, 'S', 0, 4, 2, 1, 0, 2, 4, 0, 8, 4, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 4531.47435967, 1238052.46817);

INSERT ChicagoParks VALUES (10, 'MARQUETTE (JACQUES)', '6734 S KEDZIE AVE', 'CHICAGO', 'IL', '60629', 296.58, 322.68, 18, 66, 'S', 0, 2, 0, 5, 1, 4, 8, 0, 16, 2, 4, 0, 0, 0, 2, 0, 1, 2, 0, 0, 0, 1, 0, 0, 0, 49198.4284249, 12919080.9184);

INSERT ChicagoParks VALUES (11, 'CALUMET', '9801 S AVENUE G', 'CHICAGO', 'IL', '60617', 155.21, 198.98, 10, 52, 'S', 4, 3, 5, 10, 0, 2, 4, 0, 16, 2, 4, 0, 0, 0, 1, 0, 1, 1, 0, 1, 2, 0, 0, 0, 0, 36795.0643783, 6760919.24715);

INSERT ChicagoParks VALUES (12, 'BESSEMER (HENRY)', '8930 S MUSKEGON AVE', 'CHICAGO', 'IL', '60617', 18.44, 22.88, 7, 46, 'S', 4, 2, 4, 1, 1, 2, 4, 2, 4, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 4129.37760333, 803067.313846);

INSERT ChicagoParks VALUES (13, 'PALMER (POTTER)', '200 E 111TH ST', 'CHICAGO', 'IL', '60628', 38.43, 40.48, 9, 49, 'S', 5, 2, 2, 1, 0, 2, 4, 0, 9, 0, 0, 0, 0, 1, 1, 0, 0, 3, 0, 1, 0, 0, 0, 1, 0, 5156.79114277, 1674187.25972);

INSERT ChicagoParks VALUES (14, 'DAVIS (NATHAN) SQUARE', '4430 S MARSHFIELD AVE', 'CHICAGO', 'IL', '60609', 8.13, 8.29, 37, 25, 'C', 0, 0, 0, 0, 1, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 2380.00626018, 354012.792128);

INSERT ChicagoParks VALUES (15, 'GRAND CROSSING', '7655 S INGLESIDE AVE', 'CHICAGO', 'IL', '60619', 18.90, 0.32, 8, 69, 'S', 0, 1, 2, 1, 0, 2, 4, 0, 6, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 3842.69386104, 823082.445174);

INSERT ChicagoParks VALUES (16, 'TRUMBULL (LYMAN)', '2400 E 105TH ST', 'CHICAGO', 'IL', '60617', 18.04, 18.52, 10, 51, 'S', 0, 1, 3, 1, 0, 2, 4, 0, 2, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 3728.26082426, 785838.650355);

INSERT ChicagoParks VALUES (17, 'MANN (JAMES)', '3035 E 130TH ST', 'CHICAGO', 'IL', '60633', 18.86, 20.00, 10, 55, 'S', 3, 1, 3, 1, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 1, 3840.19996644, 821525.044949);

INSERT ChicagoParks VALUES (18, 'TULEY (MURRAY)', '501 E 90TH PL', 'CHICAGO', 'IL', '60619', 18.69, 20.19, 6, 44, 'S', 0, 1, 3, 2, 0, 2, 4, 0, 13, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 3829.91895693, 814221.118898);

INSERT ChicagoParks VALUES (19, 'JACKSON (ANDREW)', '6401 S STONY ISLAND AVE', 'CHICAGO', 'IL', '60637', 501.93, 542.89, 5, 42, 'S', 0, 3, 2, 5, 0, 5, 10, 0, 20, 3, 0, 0, 0, 0, 6, 0, 1, 1, 0, 1, 2, 0, 1, 0, 0, 92140.9735346, 21864269.1551);

INSERT ChicagoParks VALUES (21, 'WASHINGTON (GEORGE)', '5531 S DR MARTIN LUTHER KING J', 'CHICAGO', 'IL', '60615', 323.00, 366.84, 8, 46, 'S', 6, 7, 4, 3, 0, 8, 16, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 2, 0, 1, 0, 2, 0, 1, 0, 53959.278487, 14069686.7895);

INSERT ChicagoParks VALUES (22, 'GAGE (GEORGE)', '2415 W 55TH ST', 'CHICAGO', 'IL', '60632', 26.53, 29.22, 14, 63, 'S', 2, 3, 2, 1, 0, 1, 2, 2, 8, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 9652.01000603, 1155766.8548);

INSERT ChicagoParks VALUES (23, 'MCKINLEY (WILLIAM)', '2210 W PERSHING RD', 'CHICAGO', 'IL', '60609', 69.74, 69.28, 11, 59, 'C', 0, 3, 2, 1, 0, 3, 6, 0, 10, 1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 11953.8762062, 3037974.0521);

INSERT ChicagoParks VALUES (24, 'GRANT (ULYSSES)', '331 E RANDOLPH ST', 'CHICAGO', 'IL', '60602', 256.57, 324.70, 42, 32, 'C', 2, 0, 14, 0, 0, 0, 0, 0, 18, 6, 0, 1, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 67760.3311825, 11176051.9513);

INSERT ChicagoParks VALUES (26, 'FOSTER (J. FRANK)', '1440 W 84TH ST', 'CHICAGO', 'IL', '60620', 25.20, 23.20, 21, 71, 'S', 1, 2, 2, 1, 0, 4, 8, 0, 8, 0, 4, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 1, 0, 1, 4259.74384184, 1097544.95218);

INSERT ChicagoParks VALUES (27, 'BURNHAM (DANIEL)', '425 E MCFETRIDGE DR', 'CHICAGO', 'IL', '60615', 473.37, 609.29, 4, 41, 'C_S', 0, 1, 1, 1, 0, 7, 14, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0, 1, 0, 0, 2, 0, 0, 0, 0, 165709.1157, 20620144.9202);

INSERT ChicagoParks VALUES (29, 'AVALON', '1215 E 83RD ST', 'CHICAGO', 'IL', '60619', 27.50, 27.84, 8, 45, 'S', 5, 2, 6, 2, 0, 1, 3, 0, 6, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 1, 1, 0, 4993.94812678, 1198058.42536);

INSERT ChicagoParks VALUES (33, 'RAINEY (EDWARD)', '4350 W 79TH ST', 'CHICAGO', 'IL', '60652', 14.04, 18.31, 13, 70, 'S', 2, 2, 0, 1, 0, 0, 0, 0, 3, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 3219.26127222, 611572.065947);

INSERT ChicagoParks VALUES (34, 'NORTHERLY ISLAND', '1400 S LYNN WHITE DR', 'CHICAGO', 'IL', '60605', 109.36, 91.20, 2, 33, 'C', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 14605.4804793, 4763644.77187);

INSERT ChicagoParks VALUES (40, 'GOMPERS (SAMUEL)', '4222 W FOSTER AVE', 'CHICAGO', 'IL', '60630', 38.24, 38.69, 39, 13, 'N', 3, 0, 0, 1, 0, 1, 2, 0, 5, 0, 3, 0, 0, 1, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 11936.2940929, 1665579.84148);

INSERT ChicagoParks VALUES (41, 'FIELD (EUGENE)', '5100 N RIDGEWAY AVE', 'CHICAGO', 'IL', '60625', 17.24, 15.78, 39, 14, 'N', 1, 1, 1, 1, 0, 1, 2, 0, 4, 2, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 9310.35991605, 751154.398631);

INSERT ChicagoParks VALUES (42, 'KIWANIS', '3315 W CARMEN AVE', 'CHICAGO', 'IL', '60625', 1.55, 2.05, 39, 13, 'N', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1204.16577725, 67385.1286186);

INSERT ChicagoParks VALUES (45, 'ADA (SAWYER GARRETT)', '11250 S ADA ST', 'CHICAGO', 'IL', '60643', 15.23, 15.25, 34, 75, 'S', 2, 2, 0, 1, 0, 2, 4, 0, 4, 0, 4, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 3695.74539311, 663524.926849);

INSERT ChicagoParks VALUES (46, 'BOHN (HENRY)', '1978 W 111TH ST', 'CHICAGO', 'IL', '60643', 1.30, 1.27, 19, 75, 'S', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1122.10603183, 56741.3717749);

INSERT ChicagoParks VALUES (47, 'CRESCENT', '2230 W 108TH PL', 'CHICAGO', 'IL', '60643', 5.18, 5.27, 19, 75, 'S', 0, 0, 1, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1974.16677398, 225701.279197);

INSERT ChicagoParks VALUES (48, 'KENNEDY (DENNIS)', '11320 S WESTERN AVE', 'CHICAGO', 'IL', '60655', 18.49, 18.16, 19, 75, 'S', 3, 2, 1, 1, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 3812.95165998, 805304.182694);

INSERT ChicagoParks VALUES (49, 'PROSPECT GARDENS', '10970 S PROSPECT AVE', 'CHICAGO', 'IL', '60643', 2.89, 2.75, 19, 75, 'S', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1700.99372726, 125804.467777);

INSERT ChicagoParks VALUES (50, 'ALMOND', '2234 W 115TH ST', 'CHICAGO', 'IL', '60643', 0.74, 0.20, 19, 75, 'S', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 662.030910216, 32268.6038883);

INSERT ChicagoParks VALUES (57, 'MONUMENT', '6700 N AVONDALE AVE', 'CHICAGO', 'IL', '60631', 1.60, 0.98, 41, 9, 'N', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1071.16803516, 69747.7757767);

INSERT ChicagoParks VALUES (59, 'ORIOLE', '5430 N OLCOTT AVE', 'CHICAGO', 'IL', '60656', 19.44, 18.57, 41, 10, 'N', 4, 2, 1, 2, 0, 2, 4, 0, 3, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 4542.70975638, 846980.371044);

INSERT ChicagoParks VALUES (60, 'OLYMPIA', '6566 N AVONDALE AVE', 'CHICAGO', 'IL', '60631', 9.75, 10.19, 41, 9, 'N', 1, 2, 0, 1, 0, 2, 4, 0, 3, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 2757.46956952, 424546.916254);

INSERT ChicagoParks VALUES (61, 'BROOKS (OSCAR)', '7046 N HARLEM AVE', 'CHICAGO', 'IL', '60631', 8.79, 8.78, 41, 9, 'N', 2, 0, 0, 1, 0, 0, 0, 0, 2, 1, 6, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 3398.03645678, 382885.528697);

INSERT ChicagoParks VALUES (62, 'EDISON (THOMAS ALVA)', '6755 N NORTHWEST HWY', 'CHICAGO', 'IL', '60631', 0.81, 0.71, 34, 9, 'N', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 713.577603241, 30642.5459538);

INSERT ChicagoParks VALUES (65, 'FERNWOOD', '10436 S WALLACE ST', 'CHICAGO', 'IL', '60628', 12.33, 12.33, 21, 49, 'S', 1, 1, 0, 1, 0, 2, 4, 0, 4, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 1, 2952.82958054, 536975.600097);

INSERT ChicagoParks VALUES (66, 'EUCLID', '9800 S PARNELL AVE', 'CHICAGO', 'IL', '60628', 5.93, 5.63, 45, 73, 'S', 2, 0, 0, 1, 0, 2, 4, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 2411.82865345, 258432.411331);

INSERT ChicagoParks VALUES (70, 'FOREST GLEN', '5073 W BERWYN AVE', 'CHICAGO', 'IL', '60630', 0.43, 0.31, 39, 12, 'N', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 630.191311021, 18523.6970808);

INSERT ChicagoParks VALUES (75, 'HOLLYWOOD', '3312 W THORNDALE AVE', 'CHICAGO', 'IL', '60659', 6.49, 6.48, 35, 13, 'N', 0, 0, 2, 0, 0, 2, 4, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 2153.62878825, 282773.68571);

INSERT ChicagoParks VALUES (80, 'ATHLETIC FIELD', '3546 W ADDISON ST', 'CHICAGO', 'IL', '60618', 4.33, 3.56, 35, 16, 'N', 0, 2, 3, 1, 0, 1, 2, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 2, 0, 0, 0, 1927.80577388, 188685.822799);

INSERT ChicagoParks VALUES (81, 'AVONDALE', '3516 W SCHOOL ST', 'CHICAGO', 'IL', '60618', 1.18, 1.17, 35, 21, 'N', 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 1030.7299573, 51245.4322222);

INSERT ChicagoParks VALUES (82, 'JENSEN (CHRIST)', '4600 N LAWNDALE AVE', 'CHICAGO', 'IL', '60625', 2.65, 2.55, 39, 14, 'N', 1, 0, 0, 0, 0, 1, 2, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1633.75355353, 115537.744363);

INSERT ChicagoParks VALUES (83, 'INDEPENDENCE', '3945 N SPRINGFIELD AVE', 'CHICAGO', 'IL', '60618', 8.82, 7.86, 39, 16, 'N', 0, 0, 3, 1, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 1, 2467.88727341, 384131.116556);

INSERT ChicagoParks VALUES (84, 'KILBOURN', '3501 N KILBOURN AVE', 'CHICAGO', 'IL', '60641', 11.42, 11.93, 30, 16, 'N', 3, 0, 0, 1, 1, 2, 4, 0, 4, 1, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 3426.10540734, 497579.621888);

INSERT ChicagoParks VALUES (85, 'KOLMAR', '4143 N KOLMAR AVE', 'CHICAGO', 'IL', '60641', 1.02, 0.87, 38, 16, 'N', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 900.398312882, 44554.3677328);

INSERT ChicagoParks VALUES (86, 'MAYFAIR', '4550 W SUNNYSIDE AVE', 'CHICAGO', 'IL', '60630', 3.00, 2.49, 45, 16, 'N', 2, 0, 0, 1, 0, 2, 4, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1440.30356479, 130728.55062);

INSERT ChicagoParks VALUES (90, 'NORTH MAYFAIR', '4537 W CARMEN AVE', 'CHICAGO', 'IL', '60630', 0.33, 0.56, 39, 14, 'N', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 485.580803461, 14289.5175575);

INSERT ChicagoParks VALUES (91, 'ROSEDALE', '6312 W ROSEDALE AVE', 'CHICAGO', 'IL', '60646', 3.07, 2.55, 45, 10, 'N', 0, 0, 1, 0, 0, 1, 3, 0, 2, 1, 0, 0, 0, 0, 2, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1475.93884178, 133595.137471);

INSERT ChicagoParks VALUES (93, 'GLADSTONE (WILLIAM)', '5421 N MENARD AVE', 'CHICAGO', 'IL', '60630', 1.74, 1.17, 45, 11, 'N', 1, 0, 0, 0, 0, 2, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1296.27333177, 75709.1944632);

INSERT ChicagoParks VALUES (94, 'JEFFERSON (THOMAS) MEML.', '4822 N LONG AVE', 'CHICAGO', 'IL', '60630', 7.34, 7.16, 45, 11, 'N', 0, 1, 1, 1, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 2336.65327595, 319557.859714);

INSERT ChicagoParks VALUES (95, 'ROBERTS (DANIEL) SQUARE', '5230 W ARGYLE ST', 'CHICAGO', 'IL', '60630', 4.53, 3.67, 45, 11, 'N', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1883.46910456, 197249.37437);

INSERT ChicagoParks VALUES (100, 'LINCOLN (ABRAHAM)', '2045 N Lincoln Park West', 'CHICAGO', 'IL', '60614', 991.38, 1216.25, 43, 7, 'N_C', 7, 6, 2, 5, 3, 2, 6, 0, 30, 163, 14, 0, 1, 0, 10, 0, 0, 3, 4, 1, 8, 1, 0, 0, 0, 278506.039504, 43184544.5761);

INSERT ChicagoParks VALUES (103, 'CHASE (SALMON)', '4701 N ASHLAND AV', 'CHICAGO', 'IL', '60640', 4.52, 4.09, 47, 3, 'N', 0, 0, 2, 1, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1901.42868603, 196730.763212);

INSERT ChicagoParks VALUES (104, 'EMMERSON (LOUIS)', '1820 W GRANVILLE AVE', 'CHICAGO', 'IL', '60660', 2.36, 2.34, 50, 2, 'N', 0, 0, 0, 0, 0, 1, 2, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1848.41609755, 102590.470125);

INSERT ChicagoParks VALUES (105, 'GOUDY (WILLIAM) SQUARE', '1255 N ASTOR ST', 'CHICAGO', 'IL', '60610', 0.60, 0.46, 43, 8, 'C', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 644.63755274, 26274.0308925);

INSERT ChicagoParks VALUES (106, 'HAMLIN (HANNIBAL)', '3035 N HOYNE AVE', 'CHICAGO', 'IL', '60618', 9.08, 8.16, 32, 5, 'N', 2, 2, 0, 1, 0, 2, 4, 0, 2, 1, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 2498.85401856, 395383.737173);

INSERT ChicagoParks VALUES (107, 'LAKE SHORE', '254 E CHICAGO AVE', 'CHICAGO', 'IL', '60611', 5.69, 5.79, 42, 8, 'C', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 2744.99869071, 247758.642438);

Here is an ERD of the tables:

Write a single query that shows the all the Chicago parks that have at least two basketball courts, at least two football fields, and at least one outdoor pool. Order the results by the park's name. Include the following columns in your results:

Park's name

Number of basketball courts

Number of football fields

Number of outdoor pools

Region Description

Community Name

Screenshot #4: Chicago Parks Query