Start Over Reset Search
Show as a Map - Up to 500 Facilities Show as List
ENERGY STAR Labeled Buildings & Plants
ENERGY STAR Logo Advanced Search
Print this page
1-1 of 1 Facilities. Labeled Buildings represent 1,377,947 square feet.
Loading. Please Wait.
Hospital (General Medical & Surgical) SFHMC
Facility Type: Hospital (General Medical & Surgical)
114 WOODLAND ST, HARTFORD, CT
Map It! | Full Profile


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:45 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 192.168.15.110
Host Name 192.168.15.110


Execution Time

Total Time Avg Time Count Template
163 ms 163 ms 1 top level /data/cf_code/estar/index.cfm
162 ms 162 ms 1 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
126 ms 126 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fa_showmap.cfm
126 ms 126 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_switch.cfm
95 ms 95 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm
21 ms 21 ms 1 /data/cf_code/estar/ia/fbx_layouts.cfm
12 ms 12 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm
10 ms 10 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
8 ms 8 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm
5 ms 5 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/dsp_showmap_list.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
2 ms 2 ms 1 /data/cf_code/estar/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/Application.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/lay_lb_popup.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/lay_lb_popup_showmap.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/dsp_acrobat_link.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/dsp_printable_link.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/dsp_trail.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/metadata/metadata.wddx
0 ms 0 ms 1 /data/cf_code/estar/OnRequestEnd.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_cache_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_debug_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_layoutoption_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_message_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_specialurlformat_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/fbx_circuits.cfm
0 ms 0 ms 2 /data/cf_code/estar/fbx_server.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_js_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_layout_pick.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagecrumb_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagetitle_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/fbx_settings.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/act_showmap.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_layouts.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_createqstring.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_normalizevalue.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_building_type_id.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_showmap.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/view_showmap.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_devnotes.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_email_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_footer.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_footer_links.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_googletagmanager.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_photo.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sections.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sitesearch_textbox.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_slogan.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/lay_english_default.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/lay_english_standard.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_language.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_layout.cfm
0 ms 0 ms 1 /data/cf_code/estar/lockoutapps.cfm
0 ms 0 ms 1 /data/coldfusion10/cfusion/CustomTags/inputfilter.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
165 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:45:53.053 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template ia/business/fbx_Layouts.cfm.
	    
12:45:53.053 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template fbx_Layouts.cfm.
	    


SQL Queries

allLocatorResults (Datasource=PMULAB_PMU, Time=19ms, Records=24350, Cached Query) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:45:53.053
	SELECT
		b_id,
		sort_building_name,
		building_name,
		building_type_id,
		building_type,
		bt_id,
		nvl(owner,'N/A') as owner,
		prop_manager,
		address1,
		address2,
		city,
		state,
		state_name,
		zip,
		formatted_zip,
		spp,
		property_type_id,
		property_type_name,
		property_type,
		plantyears,
		ratings_desc,
		yearBuilt,
		floorspace,
		hasFullProfile_tf,
		latitude,
		longitude,
		date_approved,
		approx_yn,
		federal_bldg_yn,
		pin_offset_yn		
	FROM
		mv_bldg_loc_result
	WHERE
		building_type_id != '23'
getCount (Datasource=, Time=44ms, Records=24350) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:45:53.053
SELECT DISTINCT
	b_id,
	floorspace
FROM allLocatorResults
getFootage (Datasource=, Time=29ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:45:53.053
SELECT SUM(floorspace) AS footage
FROM getCount
allBuildings (Datasource=, Time=7ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:45:53.053
SELECT *
FROM allLocatorResults
WHERE
	1 = 1
	
	
	AND b_id IN (?)

	
ORDER BY
	sort_building_name,
	date_approved DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = b_21960

getFilteredCount (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:45:53.053
SELECT DISTINCT
	b_id,
	floorspace
FROM allBuildings
getFilteredFootage (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:45:53.053
SELECT SUM(floorspace) AS footage
FROM getFilteredCount
getStates (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap.cfm @ 12:45:53.053
SELECT DISTINCT
	state,
	state_name,
	0 AS cnt
FROM allBuildings
ORDER BY state_name
getResultSet (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:45:53.053
SELECT *
FROM allBuildings
getMinLat (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:45:53.053
SELECT MIN(latitude) AS lat
FROM getResultSet
getMaxLat (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:45:53.053
SELECT MAX(latitude) AS lat
FROM getResultSet
getMinLong (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:45:53.053
SELECT MIN(longitude) AS long
FROM getResultSet
getMaxLong (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_showmap_getboundingbox.cfm @ 12:45:53.053
SELECT MAX(longitude) AS long
FROM getResultSet
qProfile (Datasource=PMULAB_PMU, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:45:53.053
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 21960

getMenuItems (Datasource=, Time=8ms, Records=20) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:45:53.053
SELECT *
FROM menuItems
ORDER BY
  itemGroup,
  itemOrder


Scope Variables

Application Variables:
applicationname=lb
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=/data/cf_code/estar/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
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=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energystar.gov
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/data/cf_code/estar/index.cfm
QUERY_STRING=fuseaction=labeled_buildings.showMap&BUILDING_TYPE_ID=ALL&ZIP=&S_CODE=ALL&STARTNUM=1&CITY=&OWNER_ID=&STR=&MINI=&VIEW=&YEAR=2003&PROFILES=0&PAGE=1&filter_b_id=b_21960
REMOTE_ADDR=192.168.15.110
REMOTE_HOST=192.168.15.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.energystar.gov
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=
WEB_SERVER_API=
Client Variables:
cfid=19822703
cftoken=2a696c7fb4369170-E925D40A-BA30-24BF-E71DF1DD4F9742D8
hitcount=1
lastvisit={ts '2014-07-23 12:45:53'}
timecreated={ts '2014-07-23 12:45:53'}
urltoken=CFID=19822703&CFTOKEN=2a696c7fb4369170-E925D40A-BA30-24BF-E71DF1DD4F9742D8
Cookie Variables:
CFID=19822703
CFTOKEN=2a696c7fb4369170-E925D40A-BA30-24BF-E71DF1DD4F9742D8
URL Parameters:
BUILDING_TYPE_ID=ALL
CITY=
MINI=
OWNER_ID=
PAGE=1
PROFILES=0
STARTNUM=1
STR=
S_CODE=ALL
VIEW=
YEAR=2003
ZIP=
filter_b_id=b_21960
fuseaction=labeled_buildings.showMap
Debug Rendering Time: 45 ms