[Ilwis]
Description=Information per ward
Time=1239705250
Version=3.1
Class=Table
Type=Table
[Table]
Domain=wards.dom
DomainInfo=wards.dom;Byte;id;217;;
Columns=9
Records=217
Type=TableStore
[TableStore]
Data=wards.TB#
UseAs=No
Type=TableBinary
StoreTime=1176371192
Col0=minority_groups
Col1=Unemployment
Col2=Literacy_rate
Col3=Male
Col4=Female
Col5=Daytime_population
Col6=nighttime_population
Col7=Residential_population
Col8=Number_Buildings
Col9=P_Male
Col10=P_Female
Col11=P_Female
Col12=Female
Col13=Female
Col14=Female
Col15=Female
[TableView]
Columns=12
Col0=Male
StatPaneVisible=Yes
RecordView=No
ButtonWidth=6
Col1=Female
Col2=minority_groups
Col3=Unemployment
Col4=Literacy_rate
Col5=Daytime_population
Col6=Population
Col7=nighttime_population
Col8=Residential_population
Col9=Number_Buildings
Col10=P_Male
Col11=P_Female
Col12=Pop_census1
Col13=maleratio
Col14=Male
Col15=Female
[Col:minority_groups]
Description=Percentage population of minority groups
Time=1177778778
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0:40:offset=-1
ReadOnly=No
OwnedByTable=No
StoreType=Long
Stored=Yes
Type=ColumnStore
Width=17
Decimals=1
Expression=rand1*minor
NrDepObjects=0
Calc=True
Object0=Column Rand1
Object1=Column minor
Sum=1409.000000
Mean=12.252174
StdDev=9.286704
MinMax=0:40
[Col:Unemployment]
Time=1177020988
Description=Unemployment rate        
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0:71:offset=-1
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=joinavg(ward_mapping.tbt,ward_mapping.Unemployment,ward_mapping.wards)
NrDepObjects=0
Object0=Column ward_mapping.Unemployment
Object1=Column ward_mapping.wards
AggregateFunction=aggavg
ColumnAggregate=ward_mapping.Unemployment
ColumnGroupBy=ward_mapping.wards
StoreType=Long
Stored=Yes
Sum=1748.000000
Mean=15.200000
StdDev=12.901244
Width=16
MinMax=0:54
[Col:Literacy_rate]
Description=Literacy rate
Time=1177778764
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0:100:offset=-1
ReadOnly=No
OwnedByTable=No
StoreType=Long
Stored=Yes
Type=ColumnStore
Width=14
Decimals=1
Expression=Iff((Daytime_population=0),0,(100-unemployment))
NrDepObjects=0
Object0=Column Daytime_population
Calc=True
Object1=Column Unemployment
Sum=9466.000000
Mean=82.313043
StdDev=18.584263
MinMax=0:100
[Col:Male]
Time=1239505938
Description=Male population
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0.00:4756.44:0.01:offset=0
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=P_Male*Residential_population/100
NrDepObjects=0
Object0=Column P_Male
Object1=Column Residential_population
Calc=True
StoreType=Long
Stored=Yes
Width=11
Decimals=0
Sum=67115.570000
Mean=583.613652
StdDev=697.123671
MinMax=0:4756.440000000001
[Col:Female]
Time=1239505552
Description=Number of female             
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0.00:6494.37:0.01:offset=0
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=P_female*residential_population/100
NrDepObjects=0
Object0=Column P_Female
Object1=Column Residential_population
Calc=True
StoreType=Long
Stored=Yes
Width=10
Sum=73041.270000
Mean=635.141478
StdDev=744.052844
MinMax=0:5030.85
Decimals=0
[Col:Daytime_population]
Time=1239504622
Description=Daytime_population  
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0:104476497:offset=0
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=joinsum(Wards_building_map_1998.tbt,Wards_building_map_1998.Persons_day,Wards_building_map_1998.wards)
NrDepObjects=0
Object0=Column Wards_building_map_1998.Persons_day
Object1=Column Wards_building_map_1998.wards
AggregateFunction=aggsum
ColumnAggregate=Wards_building_map_1998.Persons_day
ColumnGroupBy=Wards_building_map_1998.wards
StoreType=Long
Stored=Yes
Sum=154962.000000
Mean=1347.495652
StdDev=2341.183886
Width=18
MinMax=1:13287
[Col:nighttime_population]
Time=1239504698
Description=nighttime_population  
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0:17578947:offset=0
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=joinsum(Wards_building_map_1998.tbt,Wards_building_map_1998.Persons_night,Wards_building_map_1998.wards)
NrDepObjects=0
Object0=Column Wards_building_map_1998.Persons_night
Object1=Column Wards_building_map_1998.wards
AggregateFunction=aggsum
ColumnAggregate=Wards_building_map_1998.Persons_night
ColumnGroupBy=Wards_building_map_1998.wards
StoreType=Long
Stored=Yes
Sum=147200.000000
Mean=1280.000000
StdDev=1418.755750
Width=20
MinMax=1:9224
[Col:Residential_population]
Time=1239504822
Description=Residential_population
Version=3.1
Class=Column
Domain=value.dom
DomainInfo=value.dom;Long;value;0;-9999999.9:9999999.9:0.1:offset=0;
Range=0:7065768:offset=0
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=joinsum(Wards_building_map_1998.tbt,Wards_building_map_1998.Residential_night,Wards_building_map_1998.wards)
NrDepObjects=0
Object0=Column Wards_building_map_1998.Residential_night
Object1=Column Wards_building_map_1998.wards
AggregateFunction=aggsum
ColumnAggregate=Wards_building_map_1998.Residential_night
ColumnGroupBy=Wards_building_map_1998.wards
StoreType=Long
Stored=Yes
Sum=136073.000000
Mean=1183.243478
StdDev=1380.325315
Width=12
MinMax=0:9147
[Col:Number_Buildings]
Time=1239505016
Description=Number of buildings per ward
Version=3.1
Class=Column
Domain=count.dom
DomainInfo=count.dom;Long;value;0;0:999999999:offset=0;
Range=0:28491:offset=0
ReadOnly=No
OwnedByTable=No
Type=ColumnStore
Expression=joincnt(Wards_building_map_1998.tbt,Wards_building_map_1998.Building_map_1998,Wards_building_map_1998.wards)
NrDepObjects=0
Object0=Column Wards_building_map_1998.Building_map_1998
Object1=Column Wards_building_map_1998.wards
AggregateFunction=aggcnt
ColumnAggregate=Wards_building_map_1998.Building_map_1998
ColumnGroupBy=Wards_building_map_1998.wards
Sum=28491.000000
Mean=247.747826
StdDev=239.880374
StoreType=Long
Stored=Yes
MinMax=1:1398
Width=16