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 2 of 10:  Entries 6 - 10 of  46 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
2019A	28	Texas A&M Engineering Experiment Station	CSNL	Y	14400.05	14244.05	7693.05	0	6551	16209.52	9156.617	0	7052.898	0.000495	0.000279	0	0.000215	3.272285E+07
2019A	28	Texas A&M Engineering Experiment Station	NBC	Y	1686	1686	1686	0	0	2045	2045	0	0	0.000062	0.000062	0	0	3.272285E+07
2019A	97	College of Veterinary Medicine	CS	Y	646122.3	646122.3	597509.9	48612.45	0	1164118	1084365	79753.07	0	0.035575	0.033137	0.002437	0	3.272285E+07
2019A	99	Non TAMU System Organization Units	CS	Y	1094628	985976.2	0	985954.2	22	1444988	0	1444870	117.4497	0.044158	0	0.044154	0.000003	3.272285E+07
2019A	01	System Administration	CSL	Y	55915	55915	55825	90	0	56503	56407.27	95.73493	0	0.001726	0.001723	0.000002	0	3.272285E+07

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

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