Coder Social home page Coder Social logo

nsw-property-sales-scripts's Introduction

nsw-property-sales-scripts

UNIX scripts to work with NSW Property Sales data.

  • Download data make download
  • Extract make unzip
  • Load into PostgreSQL make pgschema load sales
  • Export to CSV make csv

Matching to NSW Property

  • Download a static NSW Property database from https://s3.amazonaws.com/data.openaddresses.io/runs/489246/cache.zip
  • unzip cache.zip
  • ogr2ogr -f PostgreSQL PG:dbname=geo /vsizip/cache.zip/NSW_Property_Sept18.geojson -nln nsw_property
  • `psql -c 'CREATE INDEX property_id_idx ON psi.sales (property_id);'
  • `psql -c 'CREATE INDEX propid_idx ON nsw_property (propid);'
  • psql -c 'CREATE TABLE sales_geometry AS SELECT sales.*, ST_Centroid(nsw_property.wkb_geometry) AS geometry FROM psi.sales_top sales LEFT OUTER JOIN nsw_property ON (sales.property_id = nsw_property.propid);'

nsw-property-sales-scripts's People

Contributors

andrewharvey avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.