All of our PostgreSQL 9.4 servers have been upgraded to 9.4.2
You can read the 9.4.2 release notes here:
http://www.postgresql.org/docs/9.4/static/release-9-4-2.html
Leaflet Studios
We will (finally) be making our Leaflet Studios available today.
The AcuGIS Leaflet Studio will be available to all AcuGIS clients (along with plugins).
The Omeka Leaflet Studio will be free for AcuGIS clients as well as for academic use.
Enrolment for the Omeka Leaflet Studio requires only a .edu email address.
We will post links and documentation a bit later today.
We hope these tools will help save you some development time as well as make a useful addition to your websites and applications.
New CSV2PGSQL Tool (GDAL)
We have added a new tool, CSV2PGSQL to the GIS Tools section of our control panel.
The UI uses GDAL to upload your CSV directly into your PostGIS database(s).
The CSV2PGSQL tool will be rolled out to all servers over the weekend.
Current options are:
PG_USE_COPY: Check to set to “YES” for using COPY for inserting data to PostGIS DB.
GEOM_TYPE:Â The GEOM_TYPE layer creation option can be set to one of “geometry”, “geography”
We will be adding additional options based on feedback.
OGR_FDW Installer
We have added an installer for the new OGR_FDW data wrapper to the control panel.
PostGIS is required to be installed on the database. The “Install OGR FDW” link will only appear if PostGIS is installed (as shown below).
So be sure to first install PostGIS:
The ogr_fdw_info tool is available via the downloads section in our support panel.
Learn more about this great new FDW and usage here: https://github.com/pramsey/pgsql-ogr-fdwÂ