2
votes
2answers
131 views

Import CSV file into Postgis DB with Location-field formatting?

I am working to import CSV into table in my Postgis Database. First, I created the table Create Table test ( name varchar, created_date Date, location double precision ); When I excuted the ...
0
votes
1answer
99 views

PostGIS import csv encoding problem

I want to import csv into PostGIS database, I receive error massage: alpha=# COPY project FROM '/home/alpha/database/project.csv' DELIMITERS ',' CSV; ERROR: invalid byte sequence for encoding ...
0
votes
0answers
280 views

GRIB Files as Point Data or Raster in Postgres/PostGis Database and display with Geoserver

This is a conceptual question, trying to establish the best approach to the problem! I have read this post already! I want to be able to update weather data on a 2 or 3 times daily from Grib2 files ...
2
votes
2answers
237 views

How do I plot data stored in an attribute table (really in a database) in qgis

I have a csv of UK postcodes from Ordnance Survey that looks like SE1 0AA,10,531869,179427,E92000001,E19000003,E18000007,E09000028,E05000536 When I import to QGIS using 'Add Delimited Text Layer', ...
2
votes
1answer
359 views

How to create a point table from a remote csv file?

The current approach that I am using to load a csv file into a PostGIS enabled database on a server is the following: -- create table CREATE TABLE points( id int, lat double precision, lng double ...
5
votes
2answers
836 views

Loading data onto PostGIS using KML files with attibute data

So, I have a kml file which contains 317 data points (317 polygons and the respective 317 names). The kml file also contains attribute data which pops up in a bubble on Google earth with about 12 ...