0
votes
2answers
25 views

Import shapefiles on my postgis table using R

Using R, I would like to import shapefiles that are in a directory on a geometric table i have on postgresql / postgis. What is the instruction that allows me to do it? EDIT: here is my code to ...
1
vote
0answers
11 views

Merge polygon based on other line shape file PostGIS

I have a polygon shape file and a line shape file. I would like to merge two polygons which shares the same border along with line shape. Finally the line should be removed in polygon shape file. In ...
2
votes
2answers
84 views

Importing .shp to postgreSQL

I want to import a shp file to postgreSQL. First I create sql file and then run PostgreSQL. To create sql file, I run this command in windows cmd: shp2pgsql -s 4326 worldCountries.shp worldcountries ...
1
vote
1answer
40 views

Postgres/PostGIS: Dissolve multiple fields with COUNT (Point shape)

I have loaded point .shp feature classes into Postgres 9.3 db, and enabled postgis,plpgsql,postgis_topology extensions. I'm looking to dissolve multiple fields within a single table 'TABLE1' and add ...
1
vote
1answer
35 views

How to use pgsql2shp when PostGIS extensions installed in a separate schema as geometry

I have the PostGIS extension (postgis functions and spatial_ref_sys table) added to a specific schema called postgis. I'm wanting to run the pgsql2shp utility with a select query on geometries stored ...
1
vote
4answers
49 views

PostGIS importing shapefile error w/ official manager

I'm having some trouble when trying to import an shapefile of the Sao Paulo Brazil's state (I downloaded it from the web and I'm using the own PostGis manager to import it). Here's an image! The ...
1
vote
1answer
97 views

Mapnik + OpenStreetMap + Shapefile with Raster Images + Mod Tile + PostGIS

I am new to GIS. I have a Shapefile (.shp, .shx and .pbf). The .pbf file contains path to PNG files located on my machine only. I was able to save the Shp data to PostGis via Shape2Gis tool. Now ...
2
votes
2answers
66 views

How to rename PostgreSQL/PostGIS columns while importing Shapefiles?

I discovered shp2psql to successfully import geospatial data from ESRI Shapefiles into PostgreSQL/PostGIS. Now I would like to automatically rename the target column names. Is there any mechanism ...
1
vote
0answers
28 views

Debugging ogr2ogr “AddGeometryColumn failed” and “Terminating translation prematurely after failed translation of layer”

As noted in the title, I'm getting the following error: ERROR 1: AddGeometryColumn failed for layer pretty_polys, layer creation has failed. ERROR 1: Terminating translation prematurely after failed ...
0
votes
0answers
17 views

shp2pgql: how to omit the git column?

I am importing a series of shapefiles with shp2pqsql that already have a unique identifier attribute. Since shp2pqsql creates a new column called gid I am ending up with two unique identifiers per ...
1
vote
1answer
45 views

shape file into DataSet in postGIS using openJUMP, but getting error

I am new to this field and I want to save my shape file into DataSet in postGIS using openJUMP, but I'm getting an error...can anybody tell me solution for this?
0
votes
0answers
25 views

How do I break up a shape file into contiguous area?

I've got a shapefile which is a union of non-contiguous shapes. I'd like to be able to break them up into individual groups. For example, suppose I have a polygon of the entire US, currently only ...
0
votes
1answer
47 views

Geometry to Shapefile

From importing the shapefile to postgis, its geometry is added to the database postgresql. The question, how can I load the shapefile in the Visual Basic.Net using the geometry in the database ?
1
vote
1answer
26 views

shp2pgsql data appent without gid

I have a shape file, I opened it in QGIS that has columns in attribute table named CITY_NAME, POPULATION and I have a database table in Posqgresql that has columns named gid (primary key), ...
0
votes
0answers
45 views

PGSQL2SHP Commnad switch column type

I work with Postgis. I have table CREATE TABLE centerline ( gid serial NOT NULL, l_from integer, l_to integer, r_add_pre character varying(15), r_to integer ... } Export this table with ...
2
votes
1answer
43 views

When I publish a layer(shapefile or postgis) with TileMill, 200 meters moves

I hope someone can help me. Not if you know the TileMill application I'm working with her to publish layers look more beautiful. Well, first I have posted directly loading the shp file., But when ...
0
votes
1answer
97 views

Import Shapefile on postgis doesn't show in QGIS

I'm currently working on a project about a database and some shapefiles. The database is built on PostGis with tables including some dots as geometry type columns. Once imported them on QGIS, I can ...
1
vote
0answers
39 views

PostGIS automatically creating geometries after importing using QGIS DB Manager

I have a shapefile consisting of linestrings, in which some of the features have null geometry. Yet, after importing it to PostGIS, using QGIS' DB Manager, a geometry is created for those features ...
12
votes
0answers
312 views

How to query OSM for all beaches facing west? - QGIS preferred

I want to identify all beaches on this planet (or a given subset of it) that are facing westwards (+/- 20-30 degrees). My idea is to use OSM as the data source. Extracting all polygons that have the ...
0
votes
2answers
71 views

QGIS Connection PostGIS and shapefile

I'm working on QGIS with a database created in PostGIS and a shapefile. Inside the database, I have geometry type data about location of some points, instead on the shapefile there some selected ...
1
vote
1answer
65 views

Trouble using ogr2ogr w/ -s_srs to combine inconsistent EPSG files into my postgis DB

I'm having trouble combining shapefiles from TIGER and different local governments into a single postgis db to query legislative locations. I've imported all data to multipolygon geom, but found some ...
0
votes
1answer
55 views

How to solve an instalation problem requiring “liblwgeom” to work with “shp2pgsql”

I am trying to import shape file to postgis. I have problem configuring shp2pgsql. I am getting this error : dyld: Library not loaded: @loader_path/../lib/liblwgeom-2.1.1.dylib Referenced from: ...
2
votes
0answers
53 views

PostGIS does not export shortest path to Shapefile

I am trying to draw a bunch of lines overlaying the globe map in a WGS84 projection. To this effect I have created a PostGIS DB with a table that has one column containing linestring data. My problem ...
1
vote
1answer
82 views

Update postgres/postgis point data attribute from another enclosed polygon shapefile in QGIS

I have a placename point table in postgis with 'district' column. a districts polygon shapefile with district name in 'Name' column. See the image below. I would like to update the 'district' ...
0
votes
1answer
114 views

CartoDB st_makeline with geography datatype

Hi I am using an online cartodb account to try and create a shapefile based on flight routes between one airport and another. So far, I have uploaded my lat/long points for each connected airport, ...
3
votes
1answer
205 views

Importing multiple shapefiles into single PostGIS table

I have a folder full of shapefiles that I want to import into a single PostGIS table. This table should have the following columns: id, filename, multipolygon I can bulk import all shapefiles using ...
0
votes
3answers
294 views

How to import shp2pgsql on mac?

I am using EnterpriseDB to run Postgis. when I run "shp2pgsql" on got an error message. ~ macbook$ shp2pgsql -bash: shp2pgsql: command not found ~ macbook$ which shp2pgsql I read that I should ...
3
votes
3answers
290 views

Best choice for building static maps: PostGIS, SpatiaLite or Shapefile?

I usually build static topographic maps, which are mostly printed. I'm often using OSM and rasterfiles (mainly different DEMs). The areas I'm mapping seldom exceeds 20.000 km². I'm using exclusively ...
2
votes
3answers
137 views

How to get a bbox selection of huge shapefile as GeoJSON?

I have a 4.29 GB Shapefile from which I want to extract features as GeoJSON, defined by a bounding box. This should be as fast as possible, because I want to use it in a web application. My first ...
0
votes
2answers
144 views

Problem Importing shapefile into postgresql with simple geometries

I have a Line Type shapefiles to be imported to postgis database on my postgresql, I'm using the SHP loader, I checked the "Generate simple geometries instead of MULTI Geometries" options so that the ...
2
votes
2answers
86 views

shp2pgsql mangles date field — quotes data as if it were char or varchar

I'm attempting to import a shapefile into postgis via shp2pgsql. Among the fields in the shapefile's .dbf file is a date field with format yyyymmdd, which is a valid date format for postgresql. ...
2
votes
1answer
78 views

PostGIS ST_Contains query returns null

I have a shapefile of all US States that I've imported into a table with a multipolygon geometry column. (SRID 4326) I perform a spatial query based on lat/lon to return the state abbreviation. This ...
0
votes
1answer
126 views

error of data conversion value getting while importing shapefile in shp2pgsql-gui on ubuntu

Connecting: host=localhost port=5432 user=postgres dbname=tremblement_de_terre Connection succeeded. Connecting: host=localhost port=5432 user=postgres dbname=tremblement_de_terre ...
0
votes
1answer
70 views

Missing a Geom field in PostGis

I am working in a Database preaparation for that I exported a shapefile from Qgis to PostGis.The Problem is this: In Qgis I can see a Polygon feature but when the same polygon feature is exported to ...
1
vote
1answer
116 views

Load partial shapefile into Postgis / GeoDjango project

I have a shapefile with Canadian postal codes, but am only looking to load a small subset of the data. I can load the entire data file and use SQL or Django queries to prune the data, but the load ...
2
votes
3answers
847 views

Postgis shapefile loader 2.1 error: dbf file can not be opened

The .shp, .dbf and the rest of files are fine, I open them in QGIS, AGOL with no problem. In fact, I've tried 3 different layers, and get always the same error. Anyone can please help, as I really ...
2
votes
1answer
159 views

Fast zipcode detection from latitude/longitude

I need a way to get the zipcode of a lat/long pair fast (<10 ms), and at a high rate (thousands of qps) I've loaded a shapefile from the US Census Bureau into a mysql database with spatial ...
0
votes
1answer
125 views

Can I use GeoTools with Gradle?

I am going to implement shapefile uploading from a webform, and ingestion into PostGIS. One problem I am having is that my project is using Gradle for dependency management. I am unfamiliar with ...
1
vote
2answers
2k views

Exporting shapefile to PostGIS database in QGIS

How do I export a vector shapefile to PostGIS database? I am asking what format I have to export it.
1
vote
0answers
34 views

How to load or query data directly to R from a PostGIS database using RPostgreSQL and rgdal [duplicate]

Is it possible to load/query a shapefile to R, which is stored in a postgres/postgis database? I've built up a connection to my postgres database via DBI, RPostgreSQL and I want to make some ...
0
votes
1answer
155 views

Polygon grid shape file for landmass

I am interested in generating a polygon grid shape file for the landmass of the world. What I have presently is two tables in postgreSQL. Table 1: Coastal area shapefile ...
0
votes
2answers
248 views

How to convert shp to PostGIS dump?

Given a file my_file.shp such those from Gadm e.g. US administrative divisions, where the coordinate reference system is latitude/longitude with WGS84 datum. Input could actually be: Shapefile, ...
5
votes
1answer
189 views

Maritime route prediction avoiding land masses

I am working on a project where the following functions have to be implemented: Predicting the locations of the ships (in maritime environment) at a future time. (Can be done with Kalman filter, IMM ...
0
votes
1answer
424 views

OS Vectormap GML files into PostGIS

I am having difficulty in efficiently dealing with OS Vectormap data that comes in GML format. In the past I used the Plugin for QGIS (OS GML Tools) to batch convert folders of compressed GML (.GZ) ...
0
votes
0answers
160 views

How does geoserver determine what SRID to pass to PostGIS [OPERATION ON MIXED SRID GEOMETRIES]

We are using Geoserver to render some data onto maps in a web application. The map shapes are read by Geoserver from a postgis database. The shapes are imported into postgis using the ogr2ogr utility. ...
2
votes
2answers
152 views

Extract PostGIS line features to GPX

I have a request to provide GPX files of certain trails (around 100) that are present in OpenStreetMap. Given a local PostGIS install with OSM data, I think the process would be something like: ...
6
votes
1answer
228 views

Importing a shapefile into Postgres: Can I use Multiple CPU Cores?

I'm importing some shapefiles into Postgres/PostGIS. I'm using Windows 8 and the shapefile importer/exporter GUI. It maxes out one CPU core. I'm wondering if there is a way I can use multiple cores ...
2
votes
1answer
304 views

Help building SQL query to get a list of streets of a city

From two layers in PostGIS (osm_places and osm_roads), I would need to have the roads belonging to a certain city. It would be fair enough to get the street names of all streets in a radius of X ...
2
votes
0answers
289 views

Geoserver - empty native SRS field

I'm converting layers from shape files to postgis with the below command: shp2pgsql -s 22175 -c -W "latin1" path/file.dbf' table_name db_name | psql -d db_name Next, I add this layer to the ...
2
votes
2answers
317 views

Use FME to delete records from PostGIS before loading new records

I have some shapefiles. Each shapefile contains the data on a topic for a county. I have data for 26 counties. In the filename of the shapefile, the county ID is given. I load these shapefiles into ...