Mapping and Space Information webREPORTS v7

Select tables Archive_Inv_Bldgs Archive_Inv_OrgUnits Archive_Inv_Rooms Archive_RmInv_SystPart_FCode Archive_Space_Bldg Archive_Space_Bldg_Flr Archive_Space_Bldg_Flr_Rm Archive_Space_Bldg_OrgUnit Archive_Space_Bldg_OrgUnit_SystPart Archive_Space_Bldg_SystPart ARCHIVE_SPACE_SYSTPART_LOCTYPE Current_Inv_Bldgs Current_Inv_OrgUnits Current_Inv_Rooms Current_RmInv_SystPart_FCode Current_Space_Bldg Current_Space_Bldg_Flr Current_Space_Bldg_Flr_Rm Current_Space_Bldg_OrgUnit Current_Space_Bldg_OrgUnit_SystPart Current_Space_Bldg_SystPart Current_Space_SystPart_LocType	Select fields you wish to display  Year  SystPart  SystPartName  LocType  IsBldg  SF  ASF  E&G  Non E&G  Unclass  Gross  Gross E&G  Gross Non E&G  Gross Unclass  SP Total % of Total Gross  SP E&G % of Total Gross  SP Non E&G % of Total Gross  SP Unclass % of Total Gross  Total Gross	Add criteria to display Where Show AllYearSystPartSystPartNameLocTypeIsBldgSFASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassSP Total % of Total GrossSP E&G % of Total GrossSP Non E&G % of Total GrossSP Unclass % of Total GrossTotal Gross Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearSystPartSystPartNameLocTypeIsBldgSFASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassSP Total % of Total GrossSP E&G % of Total GrossSP Non E&G % of Total GrossSP Unclass % of Total GrossTotal Gross Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearSystPartSystPartNameLocTypeIsBldgSFASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassSP Total % of Total GrossSP E&G % of Total GrossSP Non E&G % of Total GrossSP Unclass % of Total GrossTotal Gross Condition  containsis equal tois less thanis greater thanstarts withends with Value
Show SQL SQL = Select * From [Archive_Space_SystPart_LocType] Order By [SystPart]		Export Report EXCEL | CSV | TEXT | XML

---

Showing page 1 of 253:  Entries 1 - 5 of  1261 Records...

Page Size

Year	SystPart	SystPartName	LocType	IsBldg	SF	ASF	E&G	Non E&G	Unclass	Gross	Gross E&G	Gross Non E&G	Gross Unclass	SP Total % of Total Gross	SP E&G % of Total Gross	SP Non E&G % of Total Gross	SP Unclass % of Total Gross	Total Gross
2007C	01	System Administration	NBC	Y	9017.68	8828.68	8828.68	0	0	11774.88	11774.88	0	0	0.000439	0.000439	0	0	2.677635E+07
2007C	01	System Administration	CS	Y	121948	120764	105182	15582	0	196556.9	175244.6	21312.29	0	0.00734	0.006544	0.000795	0	2.677635E+07
2008A	01	System Administration	CS	Y	121948	120764	105182	15582	0	196451.2	175138.9	21312.29	0	0.007336	0.00654	0.000795	0	2.677844E+07
2008A	01	System Administration	NBC	Y	8402.08	8213.08	8213.08	0	0	10940.61	10940.61	0	0	0.000408	0.000408	0	0	2.677844E+07
2008C	01	System Administration	CS	Y	121853	120669	105087	15582	0	196324.5	175006.4	21318.09	0	0.007339	0.006542	0.000797	0	2.67478E+07

Result Page: 1  2  3  4  5  6  7  8  9  10  ... 253  Next

Records to be used as unofficial reference only. Not official records.