This example follows on from the MySQL employee data example

Backend Data

This uses postgres as pointed to by Postgres samples

Follow the instructions to install postgres, & create the progres table for UK land registry data

The actual data can be retrieved via the 'single file' option from https://data.gov.uk/dataset/land-registry-monthly-price-paid-data, 

 

GaianDB configuration

NOTE - Replace LSQL_PWD with the password you are using !. Also change jdbc URLs according to port, server, schema etc

Finally make sure the postgresql driver is in gaianDB's classpath (change launchGaianServer.sh)


# UK land registry data

VLANDREG_DEF=transaction_id varchar(40), price integer, transfer_date date, postcode varchar (10), property_type char, newly_built boolean, duration char,  paon varchar(8), saon varchar(40), street varchar (50), locality varchar (24), city varchar (20), district varchar (20), country varchar (20), category char, status char

LSQL_DB_DRIVER=org.postgresql.Driver

LSQL_DB_URL=jdbc:postgresql://localhost:5432/landreg?currentSchema=public

LSQL_USR=gaiandb

LSQL_PWD=XXXX

 

VLANDREG_DS0_CONNECTION=LSQL land_registry_price_paid_uk

VLANDREG_DS0_URL=jdbc:postgresql://localhost:5432/landreg?currentSchema=public

VLANDREG_DS0_C1=transaction

VLANDREG_DS0_C2=price

VLANDREG_DS0_C3=transfer_date

VLANDREG_DS0_C4=postcode

VLANDREG_DS0_C5=property_type

VLANDREG_DS0_C6=newly_built

VLANDREG_DS0_C7=duration

VLANDREG_DS0_C8=paon

VLANDREG_DS0_C9=saon

VLANDREG_DS0_C10=street

VLANDREG_DS0_C11=locality

VLANDREG_DS0_C12=city

VLANDREG_DS0_C13=district

VLANDREG_DS0_C14=county

VLANDREG_DS0_C15=ppd_category_type

VLANDREG_DS0_C16=record_status


  • No labels