branches - query
RESULTSET
branches - query
  BRANCH_ADDRESS BRANCH_CITY BRANCH_CODE BRANCH_DISPLAY_NAME BRANCH_ID BRANCH_LOCATION_CODE BRANCH_NAME BRANCH_STATE BRANCH_ZIP PROGRAM_LOCATION_CODE STATE_CODE
1 101 E. Main St. Ash Grove AGR Ash Grove Branch Library 1 a Ash Grove Missouri 65604 apr MO
2 81 S. Orchard Blvd. Fair Grove FGR Fair Grove Branch Library 3 f Fair Grove Missouri 65648 fpr MO
3 4653 S. Campbell Ave. Springfield TLC The Library Center 12 c The Library Center Missouri 65810 cpr MO
4 3263 E. Chestnut Expressway Springfield LEE Library Express East 22 v Library Express East Missouri 65802 vpr MO
5 3872 W. Chestnut Expressway Springfield LEW Library Express West 18 x Library Express West Missouri 65802 xpr MO
6 2535 N. Kansas Expressway Springfield LST The Library Station 4 k The Library Station Missouri 65803 kpr MO
7 397 E. Central St. Springfield MID Midtown Carnegie Branch Library 6 d Midtown Carnegie Missouri 65802 dpr MO
8 4653 S. Campbell Ave. Springfield OTR Mobile Library 7 o Outreach Missouri 65810 opr MO
9 128 Park Central Square Springfield PRK Park Central Branch Library 8 e Park Central Missouri 65806 epr MO
10 921 N. Lindsey Ave. Republic REP Republic Branch Library 9 r Republic Missouri 65738 rpr MO
11 3260 E. Battlefield Road Springfield PC Ruby by Price Cutter Plus Book Stop 16 y Ruby by Price Cutter Plus Book Stop Missouri 65804 ypr MO
12 2214 Brentwood Boulevard Springfield BWD Schweitzer Brentwood Branch Library 2 b Schweitzer Brentwood Missouri 65804 bpr MO
13 101 S. State Highway 125 Strafford STR Strafford Branch Library 11 t Strafford Missouri 65757 tpr MO
14 304 E. Jackson St. Willard WLD Willard Branch Library 14 w Willard Missouri 65781 wpr MO
CACHED false
EXECUTIONTIME 0
SQL SELECT b.branch_id, b.branch_name, b.branch_display_name, b.branch_code, b.branch_location_code, a.branch_address, a.branch_city, a.branch_state, a.state_code, a.branch_zip, CASE WHEN LEN(b.branch_location_code) = 1 THEN b.branch_location_code + 'pr' WHEN LEN(b.branch_location_code) >= 3 THEN LEFT(b.branch_location_code,3) END AS program_location_code FROM tblBranch b JOIN tblBranchAddress a ON a.branch_id = b.branch_id AND a.address_type IN ('street','virtual') ORDER BY replace(b.branch_name,'The ','')
branches - struct
a
branches - struct
ADDRESS 101 E. Main St.
CODE AGR
LOCATION_CODE a
NAME Ash Grove Branch Library
NAME_MEDIUM Ash Grove Branch
PROGRAM_LOCATION_CODE apr
b
branches - struct
ADDRESS 2214 Brentwood Boulevard
CODE BWD
LOCATION_CODE b
NAME Schweitzer Brentwood Branch Library
NAME_MEDIUM Schweitzer Brentwood Branch
PROGRAM_LOCATION_CODE bpr
c
branches - struct
ADDRESS 4653 S. Campbell Ave.
CODE TLC
LOCATION_CODE c
NAME Library Center
NAME_MEDIUM Library Center
PROGRAM_LOCATION_CODE cpr
d
branches - struct
ADDRESS 397 E. Central St.
CODE MID
LOCATION_CODE d
NAME Midtown Carnegie Branch Library
NAME_MEDIUM Midtown Carnegie Carnegie Branch
PROGRAM_LOCATION_CODE dpr
e
branches - struct
ADDRESS 128 Park Central Square
CODE PRK
LOCATION_CODE e
NAME Park Central Branch Library
NAME_MEDIUM Park Central Branch
PROGRAM_LOCATION_CODE epr
f
branches - struct
ADDRESS 81 S. Orchard Blvd.
CODE FGR
LOCATION_CODE f
NAME Fair Grove Branch Library
NAME_MEDIUM Fair Grove Branch
PROGRAM_LOCATION_CODE fpr
k
branches - struct
ADDRESS 2535 N. Kansas Expressway
CODE LST
LOCATION_CODE k
NAME Library Station
NAME_MEDIUM Library Station
PROGRAM_LOCATION_CODE kpr
none
branches - struct
ADDRESS [empty string]
CODE none
NAME none
NAME_MEDIUM none
o
branches - struct
ADDRESS 4653 S. Campbell Ave.
CODE OTR
LOCATION_CODE o
NAME Mobile Library
NAME_MEDIUM Outreach
PROGRAM_LOCATION_CODE opr
prall
branches - struct
ADDRESS [empty string]
CODE prall
NAME all Area Libraries
NAME_MEDIUM all Area Libraries
prhyp
branches - struct
ADDRESS [empty string]
CODE none
NAME virtual and in person
NAME_MEDIUM none
proff
branches - struct
ADDRESS [empty string]
CODE proff
NAME Offsite
NAME_MEDIUM Offsite
r
branches - struct
ADDRESS 921 N. Lindsey Ave.
CODE REP
LOCATION_CODE r
NAME Republic Branch Library
NAME_MEDIUM Republic Branch
PROGRAM_LOCATION_CODE rpr
t
branches - struct
ADDRESS 101 S. State Highway 125
CODE STR
LOCATION_CODE t
NAME Strafford Branch Library
NAME_MEDIUM Strafford Branch
PROGRAM_LOCATION_CODE tpr
v
branches - struct
ADDRESS 3263 E. Chestnut Expressway
CODE LEE
LOCATION_CODE v
NAME Library Express East
NAME_MEDIUM Library Express East
PROGRAM_LOCATION_CODE vpr
w
branches - struct
ADDRESS 304 E. Jackson St.
CODE WLD
LOCATION_CODE w
NAME Willard Branch Library
NAME_MEDIUM Willard Branch
PROGRAM_LOCATION_CODE wpr
x
branches - struct
ADDRESS 3872 W. Chestnut Expressway
CODE LEW
LOCATION_CODE x
NAME Library Express West
NAME_MEDIUM Library Express West
PROGRAM_LOCATION_CODE xpr
y
branches - struct
ADDRESS 3260 E. Battlefield Road
CODE PC
LOCATION_CODE y
NAME Ruby by Price Cutter Plus Book Stop
NAME_MEDIUM Ruby by Price Cutter Plus Book Stop
PROGRAM_LOCATION_CODE ypr
Program
Search Options

KIDS

STORYTIME AT DOLING PARK

Offsite Doling Park, 301 E. Talmage St.
For Infants-Age 6 With An Adult Caregiver.

Gather 'round for a storytime in the park! Join your favorite children's librarians from the Library Station for a weekly, outdoor storytime featuring stories, songs and activities. Meet near the large pavilion behind the Family Center. Provided in partnership with the Springfield-Greene County Park Board.

View All Progams