| #Requires -RunAsAdministrator | |
| <# | |
| .Synopsis | |
| Download the OSGeo4W installer then download and install QGIS LTR (through the 'full' meta-package). | |
| .DESCRIPTION | |
| This script will: | |
| 1. change the current directory to the user downloads folder | |
| 2. download the OSGeo4W installer | |
| 3. launch it passing command-line parameters to DOWNLOAD packages required to QGIS LTR FULL |
The absolute easiest way to get a CSV into a postgresql table is to use ogr2ogr with AUTODETECT_TYPE=YES.
I learned a while back that this is what cartoDB uses to import your CSV into postgis (with a lot of other parameters added)
ogr2ogr -f PostgreSQL PG:"host=localhost user=postgres dbname=postgres password=password" docs.csv -oo AUTODETECT_TYPE=YES
| SELECT | |
| osm_id, | |
| feature_type, | |
| osm_timestamp, | |
| geometry, | |
| -- Here we are going to extract a couple of attributes from the all_tags array: | |
| (SELECT value FROM UNNEST(all_tags) WHERE key = 'name' ) AS name, | |
| (SELECT value FROM UNNEST(all_tags) WHERE key = 'addr:city') AS city | |
| FROM | |
| bigquery-public-data.geo_openstreetmap.planet_features |