Find a Flood Agent
 
Enter your zip code:
Locate nearest agent:  (miles)
   

 

 


The National Flood Insurance Program (NFIP) is managed by the Federal Emergency Management Agency (FEMA), a component of the U.S. Department of Homeland Security (DHS).

FEMA


Service Insurance Company
Web site comments, feedback, request and suggestions
Privacy Notice

 

 


Debugging Information
ColdFusion Server Standard 6,1,0,63958
Template /flood/flood_agent.cfm
Time Stamp 01-Sep-15 08:06 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 10.11.12.220
Host Name 10.11.12.220


Execution Time

Total Time Avg Time Count Template
31 ms 31 ms 1 top level C:\Inetpub\service\flood\flood_agent.cfm
31 ms 31 ms 1 CFC[ C:\Inetpub\service\flood\zipfinder.cfc | squareSearch(RADIUS = 0, ZIP = ) ] from C:\Inetpub\service\flood\flood_agent.cfm
0 ms 0 ms 1 C:\Inetpub\service\flood\Application.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
31 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qGetLL (Datasource=zip, Time=31ms, Records=0) in C:\Inetpub\service\flood\zipfinder.cfc @ 08:06:06.006
		select latitude,longitude,rlatitude,rlongitude from zip
		where zip = ?
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) =

qSquareSearch (Datasource=zip, Time=0ms, Records=0) in C:\Inetpub\service\flood\zipfinder.cfc @ 08:06:06.006
		select 	zip, state, city,
			SQRT(
					SQUARE(69.1 * (latitude - (0))) 
					+
					square(69.1 * (longitude - (0)))
				) as dist
		from 	zip
		where
			latitude between 0 AND 0
			AND
			longitude between 0 AND 0
			
		order by dist asc
		
qRefine (Datasource=, Time=0ms, Records=0) in C:\Inetpub\service\flood\zipfinder.cfc @ 08:06:06.006
		select * from qSquareSearch where dist 
			
			
			    Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0


Scope Variables

Application Variables:
applicationname=zipFinder
dsn=zip
earthradius=3956
latitudemiles=69.1
packageroot=zipfinder
pidivrad=0.0174
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=C:\Inetpub\service\flood\flood_agent.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.serviceinsuranceco.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/flood/flood_agent.cfm
PATH_TRANSLATED=C:\Inetpub\service\flood\flood_agent.cfm
QUERY_STRING=
REMOTE_ADDR=10.11.12.220
REMOTE_HOST=10.11.12.220
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/flood/flood_agent.cfm
SERVER_NAME=www.serviceinsuranceco.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Cookie Variables:
CFID=2742032
CFTOKEN=723ae52e2e426990-88CCC7B2-1708-D198-CE9E8191927C5E2E
Form Fields:
RADIUS=0
ZIP=
Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
sessionid=e0301751961441109166002
urltoken=CFID=2742032&CFTOKEN=723ae52e2e426990-88CCC7B2-1708-D198-CE9E8191927C5E2E&jsessionid=e0301751961441109166002
Debug Rendering Time: 31 ms