Cancel ENERGY STAR Logo ENERGY STAR Labeled Buildings & Plants

More Search Options: Property Manager

Select one or more items from the list below. You will be returned to the map/listing.

Please note: The managers listed on this page were reported by a representative of these facilities at the time of application for the ENERGY STAR label and may be subject to change over time.


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:46 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
189 ms 189 ms 1 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
189 ms 189 ms 1 top level /data/cf_code/estar/index.cfm
149 ms 149 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fa_showmoreoptions.cfm
149 ms 149 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_switch.cfm
124 ms 124 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
11 ms 11 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm
11 ms 11 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
3 ms 3 ms 1 /data/cf_code/estar/fbx_settings.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/act_showmoreoptions_prop_manager_id.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/lay_lb_popup.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_showmoreoptions.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/act_specialurlformat_init.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
1 ms 1 ms 2 /data/cf_code/estar/ia/val_language.cfm
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/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/dsp_showmoreoptions.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/dsp_showmoreoptions_prop_manager_id.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/lay_lb_popup_showmoreoptions.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/val_building_type_id.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_showmoreoptions_optiontype.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_acrobat_link.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_printable_link.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_layout.cfm
0 ms 0 ms 1 /data/cf_code/estar/lockoutapps.cfm
0 ms 0 ms 1 /data/coldfusion10/cfusion/CustomTags/inputfilter.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
193 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:46:43.043 - MissingInclude Exception - in /data/cf_code/estar/ia/business/labeled_buildings/val_showmoreoptions.cfm : line 43
	    Could not find the included template val_showMoreOptions_prop_manager_id.cfm.
	    
12:46:43.043 - 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:46:43.043 - 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:46:43.043
	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=45ms, Records=24350) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:46:43.043
SELECT DISTINCT
	b_id,
	floorspace
FROM allLocatorResults
getFootage (Datasource=, Time=58ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:46:43.043
SELECT SUM(floorspace) AS footage
FROM getCount
allBuildings (Datasource=, Time=7ms, Records=0) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:46:43.043
SELECT *
FROM allLocatorResults
WHERE
	1 = 1
	
	
	AND building_type_id IN (?)
			
	AND state IN (?)
		
	AND prop_manager IS NOT NULL
			
ORDER BY
	sort_building_name,
	date_approved DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 840
Parameter #2(CF_SQL_VARCHAR) = GA

getFilteredCount (Datasource=, Time=2ms, Records=0) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:46:43.043
SELECT DISTINCT
	b_id,
	floorspace
FROM allBuildings
getFilteredFootage (Datasource=, Time=1ms, Records=0) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:46:43.043
SELECT SUM(floorspace) AS footage
FROM getFilteredCount
getPropMgrs (Datasource=, Time=1ms, Records=0) in /data/cf_code/estar/ia/business/labeled_buildings/act_showmoreoptions_prop_manager_id.cfm @ 12:46:43.043
SELECT DISTINCT
	prop_manager,
	0 AS cnt
FROM allBuildings
WHERE prop_manager IS NOT NULL
ORDER BY prop_manager
getResultSum (Datasource=, Time=1ms, Records=0) in /data/cf_code/estar/ia/business/labeled_buildings/act_showmoreoptions_prop_manager_id.cfm @ 12:46:43.043
SELECT SUM(cnt) AS cnt
FROM getPropMgrs
getMenuItems (Datasource=, Time=9ms, Records=20) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:46:43.043
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.showMoreOptions&optionType=prop_manager_id&ALSO_SEARCH_ID=NONE&ZIP=&S_CODE=GA&STARTNUM=1&CITY=&BUILDING_TYPE_ID=840&STR=&MINI=&VIEW=&YEAR=&PROFILES=0&FILTER_B_ID=&OWNER_ID=
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=19822798
cftoken=ba856b0adeb06c3e-E92D7BC6-0A2B-AE40-78D74A22B73E3920
hitcount=1
lastvisit={ts '2014-07-23 12:46:43'}
timecreated={ts '2014-07-23 12:46:43'}
urltoken=CFID=19822798&CFTOKEN=ba856b0adeb06c3e-E92D7BC6-0A2B-AE40-78D74A22B73E3920
Cookie Variables:
CFID=19822798
CFTOKEN=ba856b0adeb06c3e-E92D7BC6-0A2B-AE40-78D74A22B73E3920
URL Parameters:
ALSO_SEARCH_ID=NONE
BUILDING_TYPE_ID=840
CITY=
FILTER_B_ID=
MINI=
OWNER_ID=
PROFILES=0
STARTNUM=1
STR=
S_CODE=GA
VIEW=
YEAR=
ZIP=
fuseaction=labeled_buildings.showMoreOptions
optionType=prop_manager_id
Debug Rendering Time: 23 ms