ZIPS Local Home
 Keyword:  ZipCode:

All Cities in DC

DC City List

Choose a city in DC to search.
Jump to cities that start with: W
W
Washington

HOME  MAJOR CITIES  CATEGORIES  ABOUT US 
©2008-2010 ZipsLocal.com
6

Queries

sitevars (Records=1, Time=0ms)
SQL = 
select *
		from	sitevars where siteid = 4

GetStateName (Records=1, Time=0ms)
SQL = 
SELECT	State, StateName
	FROM	States
	WHERE	State='DC'

GetCities (Records=1, Time=16ms)
SQL = 
SELECT		City, Left(City,1) as l1, LOCID
	FROM		zipcoords
	WHERE		StateCode='DC'
	GROUP BY	City, LOCID
	ORDER BY	Left(City,1), City

Execution Time

47 milliseconds
16 msD:\WEBSITES\ZIPSLOCAL\ALLCITIES.CFM
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SEARCHBOX.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SERVERID.CFM
31 msSTARTUP, PARSING, & SHUTDOWN

Parameters
URL Parameters:

MODE=
OVERRIDE_DEBUG_MODE=DEBUG
STATECODE=DC

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Websites\ZipsLocal\allcities.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=close
HTTP_COOKIE=CFCLIENT_MAGICYELLOW=FAVORITES%3D%23SOURCE%3DNA%23; CFID=117256757; CFTOKEN=35934870; CFGLOBALS=HITCOUNT%3D2%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+07%3A48%3A42%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+07%3A47%3A23%27%7D%23
HTTP_HOST=www.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/DC-allcities.html
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/allcities.cfm
PATH_TRANSLATED=D:\Websites\ZipsLocal\allcities.cfm
QUERY_STRING=StateCode=DC
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/allcities.cfm
SERVER_NAME=www.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI