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 [Current_Space_SystPart_LocType]		Export Report EXCEL | CSV | TEXT | XML

---

Showing page 1 of 11:  Entries 1 - 5 of  54 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
2024C	01	System Administration	CSNL	Y	102403	82438	82438	0	0	131708.8	131708.8	0	0	0.003713	0.003713	0	0	3.547178E+07
2024C	02	Texas A&M University	CS	U	62389	61571	0	61571	0	65769	0	65769	0	0.001854	0	0.001854	0	3.547178E+07
2024C	02	Texas A&M University	NBC	Y	260774.1	209781.1	200238.2	9542.9	0	285142.8	272956.1	12186.73	0	0.008038	0.007695	0.000343	0	3.547178E+07
2024C	06	Texas A&M AgriLife Research	CS	U	47	46	0	46	0	6446	0	6446	0	0.000181	0	0.000181	0	3.547178E+07
2024C	07	Texas A&M AgriLife Extension Service	CS	U	19900	19900	0	19900	0	21040	0	21040	0	0.000593	0	0.000593	0	3.547178E+07

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

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