Content Comparison

...

Grundläggande konfiguration för dataslag BAL och för applikationen BAL

Config_bal_msql.zip konfiguration för Weave och BAL applikationen anpassad för SQL Server databas. Denna packas upp i "workspace" katalogen

Plugin.zip innehåller de plugin som driver BAL applikationen. Dessa packas upp i "plugin" katalogen

Attachments

upload	false

Lägg till följande rader i configuration/config.ini

<?xml version="1.0" encoding="UTF-8"?> <config xmlns="urn:com.cohga.server.config#1.0" xmlns:acl="urn:com.cohga.server.acl#1.0" xmlns:arcgisws="urn:com.cohga.server.map.arcgis.ws#1.0" xmlns:arcims="urn:com.cohga.server.map.arcims#1.0" xmlns:attrs="urn:com.cohga.server.userattributes.dd#1.0" xmlns:birt="urn:com.cohga.server.report.birt#1.0" xmlns:cache="urn:com.cohga.server.cache#1.0" xmlns:client="urn:com.cohga.html.client#1.0" xmlns:data="urn:com.cohga.server.data.database#1.0" xmlns:edit="urn:com.cohga.spatial.edit#1.0" xmlns:entity="urn:com.cohga.server.entity#1.0" xmlns:index="urn:com.cohga.server.index#1.0" xmlns:jdbc="urn:com.cohga.server.datasource.jdbc#1.0" xmlns:mapper="urn:com.cohga.server.spatial.mapper#1.0" xmlns:options="urn:com.cohga.server.options#1.0" xmlns:parameter="urn:com.cohga.server.parameter#1.0" xmlns:pool="urn:com.cohga.server.pool#1.0" xmlns:search="urn:com.cohga.server.search.database#1.0" xmlns:spatial="urn:com.cohga.server.spatial.geotools#1.0" xmlns:toc="urn:com.cohga.server.map.toc#1.0" xmlns:wms="urn:com.cohga.server.map.wms#1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bal="urn:se.viamap.lantmateriet.bal">  <entity:entity id =

Code Block

language	xmltext
title	BAL konfiguration
collapse	true

config.ini

se.viamap.lantmateriet.bal.client@:start,\
se.viamap.lantmateriet.bal.client.theme.ikartan@:start,\
se.viamap.lantmateriet.bal.provider@:start,\
org.hibernate@:start,\

Konfiguration av BAL appliktionen

Code Block

language	xml
title	BAL konfiguration
collapse	true

	<bal:config id="bal.sqlserver" acl="acl.bal.read">        
        <datasource>ds.bal.msql.bal</datasource>
        <!--<hibernate.hbm2ddl.auto>create</hibernate.hbm2ddl.auto>-->
        <!--<hibernate.hbm2ddl.auto>create-drop</hibernate.hbm2ddl.auto>-->
        <crs>EPSG:3010</crs>
        <!--schedule>0 0 0,15,30,45</schedule-->
        <test>true</test>
        <municipalities>
			<municipality>
				<municipality>Gävle</municipality>
					<forceContinueImportOnConstraintViolation>true</forceContinueImportOnConstraintViolation>
					<username>gavl0005</username>
					<password>xxxxxxxxxxxxxxxx</password>
					<responsibleParty>Viamap</responsibleParty>
					<executingParty>Viamap</executingParty>
					<addressplace entity="entity.bal.msql.addresses" label = "_Adresser" acl="acl.bal.read"/>
  
 
   	<mapper:mapper id="mapper.bal.msql.adresses">
		<spatialEngine>spatialengine.bal.msql.bal</spatialEngine>
		<mapping>
			<entity>entity.bal.msql.addresses</entity>
			<table>ADDRESS_PLACE</table>
			<key>objectId</key>
		</mapping>	
	</mapper:mapper>



<data:data id="d.bal.msql.address_place" label="Adress" entity="entity.bal.msql.addresses" datadefinition="dd.bal.msql.address_place" >
	<column id="address_area" width="130"  align="left"  />
	<column id="designation_number" width="20"  align="right"  />
	<column id="designation_number_letter" width="20"  align="left"  />
	<column id="post_code" width="50"  align="left"  />
	<column id="post_town" width="150"  align="left"  />
	<column id="adressarea" hidden="true"  />
</data:data>

<data:datadefinition id='dd.bal.msql.address_place'>
	<datasourcedataconnection key='objectId' table='address_place' datasource='ds.bal.msql.bal'>
		<join type='left' table='address_area' on='address_area.objectid = address_place.address_area_reference' />
		<join type="left" table="part_of_municipality" on="part_of_municipality.objectid = address_area.part_of_municipality_reference"  />
		<parameter name='adressarea'                           label='Id'                           column='address_area.assigned_name'                             type='string'/>        
		<parameter name='address'           label='Adress'           column="(COALESCE(address_area.assigned_name, '') + ' ') + COALESCE(address_place.designation_number, '') + COALESCE(address_place.designation_number_letter, '')" /> 
		<parameter name='post_code'                    label='Postnummer'                   column='address_place.post_code'                      type='int'/>        
		<parameter name='post_town'                    label='Post Town'                    column='address_place.post_town'/>                                        
		<parameter name='part_of_municipality'         label='Kommundel'                    column='part_of_municipality.assigned_name'/>                                        
		<parameter name='real_property_key'            label='Fastighet'            		column='address_place.real_property_key'>
			<dataset>dd.list.bal.msql.properties.name</dataset>
			<valuecolumn>value5</valuecolumn>
			<labelcolumn>label5</labelcolumn>
			<pagesize>0</pagesize>				
		</parameter>                               
		<parameter name='address_type'                 label='Adresstyp'                 	column='address_place.address_type'                   type='int'>
			<dataset>dd.bal.msql.adressplatstyp</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<pagesize>0</pagesize>				
		</parameter>       
		<parameter name='position_kind'                label='BelÃ¤genhet'                	column='address_place.position_kind'                  type='int' />
       
		<parameter name='location_address_status'      label='BelÃ¤genhetstatus'      		column='address_place.location_address_status'        type='int'/>     
		<parameter name='object_status'                label='Objektstatus'                	column='address_place.object_status'                  type='int' />       
		<parameter name='common_name'                  label='Gemensamt namn'                  column='address_place.common_name'/>                                      
		<parameter name='farm_address_area_reference'  label='GÃ¥rdsadress'  column='address_place.farm_address_area_reference'/>                   
		<parameter name='object_version'               label='Objektversion'               column='address_place.object_version'                 type='int'/>        
		<parameter name='version_valid_from'           label='GÃ¤ller frÃ¥n'           column='address_place.version_valid_from'             type='date'/> 
		<parameter name='idap'                           label='Id'                           column='address_place.objectid'                             type='int'/>        

		<parameter name='created_at'                   label='Created At'                   column='address_place.created_at'                     type='date'/>   
		<parameter name='last_sync'                    label='Last Sync'                    column='address_place.last_sync'                      type='date'/>   
		<parameter name='objectid'                     label='Objectid'                     column='address_place.objectid'/>                                         
		<parameter name='updated_at'                   label='Updated At'                   column='address_place.updated_at'                     type='date'/>   
 
		<parameter name='designation_value'            label='Designation Value'            column='address_place.designation_value'/>                                
	
</datasourcedataconnection>
</data:datadefinition>


	<data:data id="d.group.bal.msql.adressarea" label="Summa adressomrÃ¥den" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.adressarea" />
	<data:datadefinition id="dd.group.bal.msql.adressarea">
		<groupdataconnection datadefinition="dd.bal.msql.address_place">
			<parameter  name="adressarea"  label="adressarea" column ="adressarea" />   		
			<parameter  name="count" label="Antal" column ="count(adressarea)" type='int'/>	
			<group column="adressarea"/>
			<sort parameter="count"/>
		</groupdataconnection>
	</data:datadefinition>	

	<data:data id="d.group.bal.msql.part_of_municipality" label="Summa komundelar" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.part_of_municipality" />
	<data:datadefinition id="dd.group.bal.msql.part_of_municipality">
		<groupdataconnection datadefinition="dd.bal.msql.address_place">
			<parameter  name="part_of_municipality"  label="Kommundelar" column ="part_of_municipality" />   		
			<parameter  name="count" label="Antal" column ="count(part_of_municipality)" type='int'/>	
			<group column="part_of_municipality"/>
			<sort parameter="count"/>
		</groupdataconnection>
	</data:datadefinition>	


	<data:data id="d.group.bal.msql.position_kind" label="Summa belÃ¤genhet" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.position_kind" />
	<data:datadefinition id="dd.group.bal.msql.position_kind">
		<groupdataconnection datadefinition="dd.bal.msql.address_place">
			<parameter  name="position_kind"  label="BelÃ¤genhet" column ="position_kind" />   		
			<parameter  name="count" label="Antal" column ="count(position_kind)" type='int' />	
			<group column="position_kind"/>
			<sort parameter="count"/>
		</groupdataconnection>
	</data:datadefinition>	

	<data:data id="d.group.bal.msql.location_address_status" label="Summa belÃ¤genhetsstatus" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.location_address_status" />
	<data:datadefinition id="dd.group.bal.msql.location_address_status">
		<groupdataconnection datadefinition="dd.bal.msql.address_place">
			<parameter  name="location_address_status"  label="BelÃ¤genhetsstatus" column ="location_address_status" />   		
			<parameter  name="count" label="Antal" column ="count(location_address_status)" type='int' />	
			<group column="location_address_status"/>
			<sort parameter="count"/>
		</groupdataconnection>
	</data:datadefinition>	

<data:data id="d.bal.msql.addresses.dwellings" label="LÃ¤genheter" entity="entity.bal.msql.addresses" datadefinition="dd.bal.msql.addresses.dwellings" />
<data:datadefinition id='dd.bal.msql.addresses.dwellings'>
	<datasourcedataconnection key='objectid' table='dbo.address_place' datasource='ds.bal.msql.bal'>
		<join type='left' table='dbo.address_area' on='dbo.address_area.objectid = address_place.address_area_reference' />
		<join type="left" table="dbo.part_of_municipality" on="dbo.part_of_municipality.objectid = dbo.address_area.part_of_municipality_reference"  />
		<join type='inner' table='dbo.entrance' on='entrance.address_place_reference = address_place.objectid' />
		<join type='inner' table='dbo.dwelling' on='dwelling.entrance_reference = entrance.objectid' />
		<parameter name='fastighet'  label='Fastighet'  column='address_place.real_property_key'>                      
			<dataset>dd.list.bal.msql.properties.name</dataset>
			<valuecolumn>value5</valuecolumn>
			<labelcolumn>label5</labelcolumn>
			<pagesize>0</pagesize>				
		</parameter>        
		<parameter name='address'           label='Adress'           column="(COALESCE(dbo.address_area.assigned_name, '') + ' ') + COALESCE(dbo.address_place.designation_number, '') + COALESCE(dbo.address_place.designation_number_letter, '')" /> 
		<parameter name='post_code'                    label='Postnummer'                   column='dbo.address_place.post_code'                      type='int'/>        
		<parameter name='post_town'                    label='Post Town'                    column='dbo.address_place.post_town'/>                                        
		<parameter name='dwelling_number'			       label='LÃ¤genhet'					column='dwelling.dwelling_number'/>                           
		<parameter name='dwelling_category'			       label='Kategori'					column='dwelling.dwelling_category'>
			<dataset>dd.bal.msql.dewllingcategory</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<pagesize>0</pagesize>						
		</parameter>                           
		<parameter name='collection_method'			       label='Insamling'					column='dwelling.collection_method'>
			<dataset>dd.bal.collectionmethod</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<pagesize>0</pagesize>						
		</parameter>                           
		<parameter name='type_of_kitchen'			       label='KÃ¶kstyp'					column='dwelling.type_of_kitchen'>
			<dataset>dd.bal.typeofkitchen</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<pagesize>0</pagesize>						
		</parameter>                           
 		<parameter name='common_kitchen'			       label='Gemensamt kÃ¶k'					column='dwelling.common_kitchen'>
			<dataset>dd.bal.commonkitchen</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<pagesize>0</pagesize>						
		</parameter>                           
  		<parameter name='useful_floor_space'			       label='Bostadsyta'					column='dwelling.useful_floor_space'  type='float'/>
   		<parameter name='number_of_rooms'			       label='Antal rum'					column='dwelling.number_of_rooms'  type='integer'/>
                        
       <sort parameter="address"/>
       <sort parameter="dwelling_number"/>
</datasourcedataconnection>
</data:datadefinition>

	<data:data id="d.group.bal.msql.number_of_rooms" label="Summa antal rum" entity="entity.bal.msql.addresses" datadefinition="dd.group.bal.msql.number_of_rooms" >
		<column id="sum">
		<format xsd:type="xsd:string">0,000.00</format>
		</column>
	</data:data>
	<data:datadefinition id="dd.group.bal.msql.number_of_rooms">
		<groupdataconnection datadefinition="dd.bal.msql.addresses.dwellings">
			<parameter  name="number_of_rooms"  label="Antal rum" column ="number_of_rooms" />   		
			<parameter  name="sum" label="Suma yta" column ="sum(useful_floor_space)" type='float' />	
			<parameter  name="count" label="Antal" column ="count(number_of_rooms)" type='int' />	
			<group column="number_of_rooms"/>
			<sort parameter="count"/>
		</groupdataconnection>
	</data:datadefinition>	

<data:data id="d.bal.msql.address_place_geometry" label="Adress geometri" entity="entity.bal.msql.addresses" datadefinition="dd.bal.msql.address_place_geometry" >
	<column id="x">
	<format xsd:type="xsd:string">0,000.00</format>
	</column>
	<column id="y">
	<format xsd:type="xsd:string">0,000.00</format>
	</column>
	<column id="address_area" width="130"  align="left"  />
	<column id="designation_number" width="20"  align="right"  />
	<column id="designation_number_letter" width="20"  align="left"  />
	<column id="post_code" width="50"  align="left"  />
	<column id="post_town" width="150"  align="left"  />
</data:data>
<data:datadefinition id='dd.bal.msql.address_place_geometry'>
	<datasourcedataconnection key='objectid' table='dbo.address_place' datasource='ds.bal.msql.bal'>
		<join type='left' table='dbo.address_area' on='address_area.objectid = address_place.address_area_reference' />
		<parameter name='address_area'			       label='Address'					column='address_area.assigned_name'/>                           
		<parameter name='designation_number'           label='N'           column='address_place.designation_number'/>                               
		<parameter name='designation_number_letter'    label='B'    column='address_place.designation_number_letter'/>                        
		<parameter name='post_code'                    label='Postnummer'                    column='address_place.post_code'                      type='int'/>        
		<parameter name='post_town'                    label='Postort'                    column="address_place.post_town"/>                                        
		<parameter name='horizontal_coordinate_system' label='Kordinatsystem i plan' column='address_place.horizontal_coordinate_system'>
			<dataset>dd.bal.msql.kordinatsystem_sweden</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<pagesize>0</pagesize>						
		</parameter>                     
		<parameter name='x'     label='Ã–stlig koordinat'     column='shape.STX'/>                       
		<parameter name='y'     label='Nordlig koordinat'     column='shape.STY'/>                       
        <sort parameter="address_area"/>
        <sort parameter="designation_number"/>
        <sort parameter="designation_number_letter"/>
	</datasourcedataconnection>
</data:datadefinition>

<data:datadefinition id="dd.bal.msql.kordinatsystem_sweden">
    <inlinedataconnection>
        <parameter type="string" name="value1" label="Key" />
        <parameter type="string" name="label1" label="Label" />
        <row>
            <cell>9ec23aad-8fd1-b149-0a90-c9f6355c3b56</cell>
            <cell>SWEREF 99 TM</cell>
        </row>
        <row>
            <cell>9d2d5841-a337-abc9-0a90-c9f6355c3b56</cell>
            <cell>SWEREF 99 16 30 </cell>
        </row>
     </inlinedataconnection>
</data:datadefinition>

<data:datadefinition id='dd.list.bal.msql.common_name'>
	<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
		<parameter name='value1'         column='common_name' 			type='string'/>                                  
		<parameter name='label1'         column='common_name'   type='string'/>     
	</datasourcedataconnection>
</data:datadefinition>


<data:datadefinition id='dd.bal.msql.address_place.locationaddressstatus'>
	<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
		<parameter name='label1'         column='location_address_status'   type='string'/>     
		<parameter name='value1'         column='location_address_status' 			type='string'/>                                  
	</datasourcedataconnection>
</data:datadefinition>

<data:datadefinition id='dd.bal.msql.address_place.positionkind'>
	<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
		<parameter name='label1'         column='position_kind'   type='string'/>     
		<parameter name='value1'         column='position_kind' 			type='string'/>                                  
	</datasourcedataconnection>
</data:datadefinition>

<data:datadefinition id='dd.bal.msql.adressplatstyp'>
	<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
		<parameter name='label1'         column='address_type'   type='string'/>     
		<parameter name='value1'         column='address_type' 			type='string'/>                                  
	</datasourcedataconnection>
</data:datadefinition>

<data:datadefinition id='dd.bal.msql.objectstatus'>
	<datasourcedataconnection table='dbo.address_place' datasource='ds.bal.msql.bal' prefix="DISTINCT">
		<parameter name='label1'         column='object_status'   type='string'/>     
		<parameter name='value1'         column='object_status' 			type='string'/>                                  
	</datasourcedataconnection>
</data:datadefinition>

<data:datadefinition id='dd.bal.msql.dewllingcategory'>
	<datasourcedataconnection table='dbo.dwelling' datasource='ds.bal.msql.bal' prefix="DISTINCT">
		<parameter name='label1'         column='dwelling_category'   type='string'/>     
		<parameter name='value1'         column='dwelling_category' 			type='string'/>                                  
	</datasourcedataconnection>
</data:datadefinition>

 <search:attribute id="sa.bal.adresses">
		<entity>entity.bal.msql.addresses</entity>
		<displayName>Adresser</displayName>
		<description>Adresser</description>
		<dataSource>ds.bal.msql.bal</dataSource>
		<table>dbo.address_place</table>
		<key>objectId</key>

	<parameter id ="properties"  label="Fastigheter">
		<dataset>dd.list.bal.msql.properties.name</dataset>
		<parameter id ="kommun">
			<promptText>Kommun</promptText>
			<controltype>listbox</controltype>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<column>municipality</column>
			<dataType>string</dataType> 
		</parameter>


		<parameter id ="property">
			<promptText>Ligger pÃ¥ fastighet</promptText>
			<controltype>listbox</controltype>
			<valuecolumn>value5</valuecolumn>
			<labelcolumn>label5</labelcolumn>
			<column>real_property_key</column>
			<dataType>string</dataType> 
		</parameter>
	</parameter>



	<parameter id ="adress" label="Gatuadress">
			<dataset>dd.list.bal.msql.address_place</dataset>

		<parameter id ="posttown">
			<promptText>Postort</promptText>
            <column>post_town</column>
			<valuecolumn>posttown</valuecolumn>
			<labelcolumn>posttown</labelcolumn>
			<dataType>string</dataType> 
		</parameter>

		<parameter id ="area">
			<promptText>Gata eller gÃ¥rdsadress</promptText>
			<controltype>listbox</controltype>
			<from table='dbo.address_area' />
			<where clause = 'address_area.objectid = address_place.address_area_reference' />
			<where>
				<clause>
					<![CDATA[address_area.assigned_name = '${area}' ]]>
				</clause>
			</where>
			<valuecolumn>area</valuecolumn>
			<labelcolumn>area</labelcolumn>
			<dataType>string</dataType> 
		</parameter>

		<parameter id ="number">
			<promptText>Nummer</promptText>
			<controltype>listbox</controltype>
			<where>
				<clause>
					<![CDATA[COALESCE(designation_number,'') +  COALESCE(designation_number_letter,'') = '${number}' ]]>
				</clause>
			</where>
			<valuecolumn>number</valuecolumn>
			<labelcolumn>number</labelcolumn>
			<dataType>string</dataType> 
		</parameter>	

	</parameter>



	<parameter id ="area" label="Andra adressomrÃ¥den">

		<parameter id ="common_name">
			<promptText>Vanligt namn</promptText>
			<controltype>listbox</controltype>
			<dataset>dd.list.bal.msql.common_name</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<column>common_name</column>
			<dataType>string</dataType> 
		</parameter>

		<parameter id ="farm_address_area">
			<promptText>GÃ¥rdsadress</promptText>
			<controltype>listbox</controltype>
			<dataset>dd.list.bal.msql.farm_address_area</dataset>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<column>farm_address_area_reference</column>
			<dataType>string</dataType> 
		</parameter>
	</parameter>

	<parameter id ="ovrigt" label="Andra adressuppgifter">
		<parameter id ="locationaddressstatus">
			<promptText>BelÃ¤genhetsstatus</promptText>
			<controltype>listbox</controltype>
			<dataset>dd.bal.msql.address_place.locationaddressstatus</dataset>
			<where>
				<clause>
					<![CDATA[location_address_status = '${locationaddressstatus}' ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>string</dataType> 
			<allowblank>true</allowblank>
			<defaultValue></defaultValue>
		</parameter>

		<parameter id ="positionkind">
			<promptText>AdresspunktlÃ¤ge</promptText>
			<controltype>listbox</controltype>
			<dataset>dd.bal.msql.address_place.positionkind</dataset>
			<where>
				<clause>
					<![CDATA[position_kind = '${positionkind}' ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>string</dataType> 
		</parameter>

		<parameter id ="adresstyp">
			<promptText>Adresstyp</promptText>
			<controltype>listbox</controltype>
			<dataset>dd.bal.msql.adressplatstyp</dataset>
			<where>
				<clause>
					<![CDATA[address_type = '${adresstyp}' ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>string</dataType> 
		</parameter>

		<parameter id ="objectstatus">
			<promptText>Objektstatus</promptText>
			<controltype>listbox</controltype>
			<dataset>dd.bal.msql.objectstatus</dataset>
			<where>
				<clause>
					<![CDATA[object_status = '${objectstatus}' ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>string</dataType> 
		</parameter>
	</parameter>

	<parameter id ="dewelling" label="LÃ¤genhetsuppgifter">
		<parameter id ="dewllingcategory">
			<promptText>LÃ¤genhetstyp</promptText>
			<controltype>listbox</controltype>
			<from table='dbo.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='dbo.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<dataset>dd.bal.msql.dewllingcategory</dataset>
			<where>
				<clause>
					<![CDATA[dwelling_category = '${dewllingcategory}' ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>string</dataType> 
		</parameter>

		<parameter id ="collectionmethod">
			<promptText>Insamlingsmetod</promptText>
			<controltype>listbox</controltype>
			<from table='bal.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='bal.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<dataset>dd.bal.collectionmethod</dataset>
			<where>
				<clause>
					<![CDATA[collection_method = ${collectionmethod} ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>integer</dataType> 
		</parameter>



		<parameter id ="type_of_kitchen">
			<promptText>Typ av kÃ¶k</promptText>
			<controltype>listbox</controltype>
			<from table='bal.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='bal.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<dataset>dd.bal.typeofkitchen</dataset>
			<where>
				<clause>
					<![CDATA[type_of_kitchen = ${type_of_kitchen} ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>integer</dataType> 
		</parameter>

		<parameter id ="common_kitchen">
			<promptText>Gemensamt kÃ¶k</promptText>
			<controltype>listbox</controltype>
			<from table='bal.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='bal.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<dataset>dd.bal.commonkitchen</dataset>
			<where>
				<clause>
					<![CDATA[common_kitchen = ${common_kitchen} ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>integer</dataType> 
		</parameter>

		<parameter id ="number_of_rooms">
			<promptText>Antal rum</promptText>
			<controltype>listbox</controltype>
			<from table='bal.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='bal.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<dataset>dd.bal.numberofrooms</dataset>
			<where>
				<clause>
					<![CDATA[number_of_rooms ${number_of_rooms} ]]>
				</clause>
			</where>
			<valuecolumn>value1</valuecolumn>
			<labelcolumn>label1</labelcolumn>
			<dataType>integer</dataType> 
		</parameter>
	</parameter>

	<parameter id ="bostadsyta" label="Bostadsyta">
		<parameter id ="max_useful_floor_space">
			<promptText>Bostadsyta stÃ¶rre/lika med kvm</promptText>
			<controltype>textbox</controltype>
			<from table='bal.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='bal.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<where>
				<clause>
					<![CDATA[useful_floor_space >= ${max_useful_floor_space} ]]>
				</clause>
			</where>
			<dataType>float</dataType> 
		</parameter>

		<parameter id ="min_useful_floor_space">
			<promptText>Bostadsyta mindre/lika med kvm</promptText>
			<controltype>textbox</controltype>
			<from table='bal.entrance' />
			<where clause = 'entrance.address_place_reference = address_place.objectid' />
			<from table='bal.dwelling' />
			<where clause = 'dwelling.entrance_reference = entrance.objectid' />
			<where>
				<clause>
					<![CDATA[useful_floor_space <= ${min_useful_floor_space} ]]>
				</clause>
			</where>
			<dataType>float</dataType> 
		</parameter>
	</parameter>


	<parameter id ="id">
		<promptText>ID</promptText>
		<controltype>textbox</controltype>
		<valuecolumn>value1</valuecolumn>
		<labelcolumn>label1</labelcolumn>
		<column>id</column>
		<dataType>integer</dataType> 
	</parameter>

        <cache disable="true" />
  </search:attribute>  

	
</config>

...

/>
					<building entity="entity.bal.msql.buildings"/>
					<measure entity="entity.bal.survey" />
					<property>
						<data>
							<dataset>dd.list.bal.msql.properties.list.name</dataset>
							<valuecolumn>value2</valuecolumn>
							<labelcolumn>label2</labelcolumn>
						</data>
						<entity>entity.bal.msql.properties</entity>
						<!--
						<spatialengine>spatialengine.bal.msql.properties</spatialengine>
						<table>FASTIGHETER_GAVLE</table>
						<key>fnr_fds</key>
						-->
						<labelcolumn>beteckning</labelcolumn>
						<discriminatorColumn>detaljtyp</discriminatorColumn>
						<propertyAttribute3d>3DFASTIGH,3DSAMF</propertyAttribute3d>
						<propertyAttribute2d>FASTIGHET,SAMF</propertyAttribute2d>
						<filter><![CDATA[fnr_fds IS NOT NULL]]></filter>
					</property>
			</municipality>
        </municipalities>
    </bal:config>

Förklaringar:

XML tagg	Förklaring
bal:config id	Unikt id för bal-konfigurationen. Flera konfigurationer kan användas
datasource	Hänvisar till Weave datakälla där BAL databasen finns
crs	ESPG:<SRID> anger projektion för databasens geometrikolumner
test	Anger om konfigurationen avser testdabas eller inte
schedule	Anges om synkronisering mot Lanmäteriet ska skem med viss tidsintervall
municipalities	Omslutande tag för alla kommuner som konfiguration innehåller
municipality	Omslutande för en enskild kommun
municipality	Anger namnet för specifik kommun
forceContinueImportOnConstraintViolation	Används enbart när test-databas ska laddas som innehåller oigentligheter
username, passworld	Inloggning mot Lantmäteriet
responsibleParty	Ansvarig kommun (eller vid test, leverantör)
executingParty	Systemleverantör
building entity	Hänvisning till Weave dataslag för byggnader
measure entity	Hänvisning till Weave dataslag för mätdata-lager
property data	Hänvisning till Weave datadefinition för att slå upp ID och beteckning för fastigheter
property entity	Hänvisning till Weave dataslag för fastigheter
property spatialengine	Hänvisning till Weave spatial koppling för fastigheter
property table	Tabellnamn för fastigheter
poperty key	Kolunmnamn för fastighetsnyckel
property labelcolumn	Anges för sökning på fastighteters namn
property discriminatorColumn	Anger vilken kolumn som betecknar detaljtyp
propertyAttribute3d	Anger de detaljtyper som betecknar 3D fasigheter
propertyAttribute2d	Anger de detaljtyper som betecknar 2D fasigheter
property filter	Filter för att sortera bort icke fastigheter

Omstart av Weave

När BAL konfirutionen är klar och plugin är tillagda startas Weave servern om.

Konsolkommandon

Använ Weav admin eller om Weave är startad i konsolläge så kan denna användas

Testa med "ss bal" och "ss hibenate" för att se att alla plugin är aktiva.

Följande bal-kommnadon (som också visas i konsolen)

bal list - returns a list of available bal engines
bal desc <balengine> - describe the bal engine
bal import <balengine> <municipality key> <type> - imports data located in workspace/bal/import/<municipality code>
bal update <balengine> <municipality key> <type> - does the same as import, but update the entity if it already exist. New records will be inserted
bal sync <balengine> (<municipality key> or all) type - Synchronize data with Lantmäteriet. Valid types are 'full', 'fetch', and 'send'

Importera data första gången en fil nedladdad från Lantnäteriet

Första gången ska den "lokala" databasen fyllas med data från den nationella databasen hos Lanmäteriet. De skickar filer för nedladdning som läggs in under Weave workspace/bal/import/<kommunkod>. Med konsol-kommandot

bal import <config id> <kommunkod> all

så importeras filerna och lagras i den lokala databasen

Weave konfigurationen för BAL

Konfigurationen som kommer med vid installtioen innhåller konfiguratio för att bekvämt komma igång. Följande ingår:

Datakällor

BAL databasen
Fastighetsdatabas
Koppling till datakälla för mätlager

Dataslag

BAL fastigheter - Det dataslag som BAL jobbar med
Byggnader - Dataslag för stöd till BAL för att visulisera enkilda objekt och för att analyser
Adresser - Dataslag för stöd till BAL för att visulisera enkilda objekt och för att analyser
Mätlager - Dataslag som BAL använder för att hämta geometrier. Detta lager ägas avv någon annan appliktion som mätaren använder och kan bara läsas av BAL

Frågor, listor, rapporter och kartlager

För samtliga dataslag finns kopplade frågor, listor och kartlager.

Version	Old Version 2	New Version Current
Changes made by	Sven-Ola Svensson	Sven-Ola Svensson
Saved on	2018-10-15	2018-10-15