Tagged Questions

2
votes
1answer
9 views

Install the Pgadmin3 shapefile importer plugin on a Mac(10.8)?

I'm new to GIS related things and I'm setting up a Postgre/Postgis database for geospatial queries. I'd like to import various shapefiles into the database and I found that Pgadmin3 has a shapefile ...
0
votes
0answers
20 views

NYC Building Perimeter Shapefile after 2011

I've been using the following NYC building perimeter shapefile from the DOTT for some work. This file however dates back to 2010. Is there a newer one available, and if so where? I have found this ...
1
vote
1answer
48 views

Incorrectly Projected PostGIS data in TileMill

When I bring PostGIS data in EPSG:900913 into TileMill, my layers end up on other continents. This is my workflow: (1) Save shapefiles in QGIS to EPSG:900913 (2) Import the shapefiles using PostGIS ...
0
votes
1answer
59 views

ST-Links convert Feature Class to DB Table error

I'm using ArcMap with the ST-Links SpatialKit Conversion tool to convert a Feature Class to a DB Table. But I'm getting an error: ERROR: 42601: type modifier is not allowed for type "geometry". I ...
2
votes
1answer
42 views

Force dimensionality with shp2pgsql

After invoking: shp2pgsql -W "latin1" theshape.shp > thesql.sql My console responds with: Shapefile type: PolygonZ Postgis type: MULTIPOLYGON[2] Note the shapefile type is PolygonZ. The result ...
0
votes
1answer
42 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
4
votes
2answers
170 views

GeoServer: Shapefile or PostGIS?

I'm going to build a web application, which will render around ten maps using GeoServer. I will be also changing the attribute data in the application for some layers. So, what is the recommended ...
0
votes
1answer
108 views

Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool)

I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool. However its not ...
8
votes
2answers
183 views

How can I get a shapefile from a postgis query?

My data is in a PostGIS database. I would like to generate a shapefile from a query. How can I do that?
1
vote
1answer
43 views

why sql file generated by postgis was different in notepad and pgAdminIII?

When i imported a shapefile which contains some polygons into PostGIS by command line on Win 7, a problem puzzled me: The sql file generated by shp2pgsql opened with notePad has the geom ...
4
votes
2answers
227 views

Fastest way to convert shapefile to postgis in java

I have been using geotools to read shapefiles and import them into postgis. Unfortunately, when large files are being imported, this leads to a massive lag time --8000% of shp2pgsql piped into pgsql-- ...
2
votes
0answers
84 views

Adding polygon to existing database column

I've built a database with postgreSQL with a few geometry columns. When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my DB using postgis. Now, I want to add ...
3
votes
1answer
108 views

Shapefile postgis database to be queried by GeoDjango

I would like to create a Postgres database (postgreslq-9.1 and postgis-2.0.2) storing several shapefiles but I am uncertain on how to implement it so I'm searching for some advices. I have already ...
13
votes
5answers
310 views

What in-depth spatial database systems tutorials exist?

Is there a good tutorial that explains in depth the internals of a GIS and a spatial database system such as PostGIS with examples and without any background assumption? I'm specifically looking for ...
0
votes
2answers
221 views

Error import ShapeFile shp2pgsql-gui

I'm trying to import a shape file to my PostGIS database but I can not, give a look: Importing with configuration: 12mie250gc_sir, public, geom, / ...
2
votes
1answer
170 views

How to bulk delete shapefile columns?

I have shape-file with next attribute table: - name of features, unique number for each feature of layer I must split shape-file by NAME field, but in result in attribute tables of layers should be ...
1
vote
1answer
112 views

Unable to add PostGIS table to Geoserver

I am able to add individual tables to Geoserver using, curl -u admin:geoserver -v -XPOST -H 'Content-type: text/xml' -d ...
1
vote
2answers
102 views

How to remove shapefile from PostGIS

I added a shapefile to the PostGIS using, ogr2ogr -f PostgreSQL PG:"host=server_ip user=username dbname=dbname password=password" yourshapefile.shp; Now I want to remove it. What is the command ...
1
vote
2answers
845 views

Adding shapefiles to PostGIS database

I was able to create a Postgresql database and then I executed, createlang plpgsql geospecies psql -d geospecies -f postgis.sql psql -d geospecies -f spatial_ref_sys.sql So now can I directly ...
1
vote
1answer
177 views

Edit Shapefiles Attribute data in GeoServer Programatically

I'm rendering a shapefile using GeoServer and using OpenLayers library to render it in the web browser. Now I have created the option of editing the attribute data in web browser. I want the edited ...
5
votes
1answer
254 views

Error when using pgsql2shp

I try to export geographical data from a postgis database to a shapefile with pgsql2shp. Normally this works fine, but now I receive the following error. Preparing table for user query... Done. ...
0
votes
1answer
2k views

Click a marker icon to open a pop-up, using OpenLayers

Background Looking to create a pop-up that performs an Ajax request when the user clicks a marker on an OpenLayers map. The markers, however, have different icons. The following is working code that ...
3
votes
1answer
379 views

How to save a newly created shapefile in PostGIS?

I am creating shapefile using shapefile.py and my database has records more that 65k which is the limit of the shapefile. How can I create shapefiles then? Is it possible that somehow I am able to ...
9
votes
1answer
432 views

Conflate (merge) private shapefile data with OSM data

Background Downloaded Alberta OSM data from Geofabrik and have it running on a private Linux server using PostgreSQL 9.1, PostGIS 2.0, Mapnik 2.1.0, osm2pgsql, Apache 2, mod_tile, renderd, and ...
0
votes
1answer
96 views

one row is discarded while importing shapefile into postgres

Please help me in following issue. I need to import a polyline shapefile into Postgres9.1 through shp2pgsql command.When i did like this, i got an error as "NOTICE: CREATE TABLE will create ...
3
votes
1answer
472 views

How to upload shapefile to PostGIS using cURL and GeoServer REST API

The GeoServer REST API docs here does not detail how to do this. I'd like to create a PostGIS table and corresponding featureType in GeoServer using the REST API, without having to chain requests. ...
1
vote
0answers
39 views

How to load GeoJSON files directly onto QGIS? [duplicate]

Possible Duplicate: Plugin or script to get QGIS to display geoJSON in a layer Is there a way to do this? Or is there a way i can put it onto PostGIS and then load it onto QGIS? I actually ...
4
votes
2answers
609 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 ...
3
votes
1answer
710 views

Convert KML to shapefile without losing attribute data

So I want to convert KML files to SHP shapefiles to load it onto PostGIS. Currently I'm using ogr2ogr to do the conversion for me, but it wipes out all the attribute data. How do i preserve this ...
5
votes
1answer
550 views

SQL Query to Reverse Geocoding in PostGIS

I try to do Reverse Geocode from my shapefile on the database. I'd already try with Spatialite and PostGIS to put shapefile (.shp) into it. But I'm still can't delivered my objection about reverse ...
0
votes
2answers
422 views

Storing Polygons in PostGIS (data coming from shape files)

We want to store data from shape files in PostGIS all in one table. There will be two columns in the table: boundary - The polygon data (How do we store this?) mongo_id - Links to a mongo database ...
3
votes
2answers
711 views

How to insert geometries from shapefile into existing table?

I'm running into a problem trying to figure out how I should insert a GIS coverage polygon into an existing table. I'm primarily using QGIS and the PostGIS Manager plugin to handle it. After some ...
4
votes
0answers
691 views

Union, Dissolve, Buffer — multiple layers, all in one step?

I'm a new user of Quantum GIS (1.7.3) and I need to repeat a task multiple times, so I'm wondering if there is a quicker way to do the following (with three or more polygon layers - each layer has a ...
0
votes
1answer
173 views

identifying single overlaping features from a GeoServer layer

I'm trying to use GeoServer to display features from a PostGis table the url will look similar to this. Example URL ...
5
votes
2answers
1k views

ogr2ogr kml to shp conversion created 184 shapefiles?! What am I missing?

I'm trying to convert this KML dataset of ice arenas to a shapefile using ogr2ogr (GDAL 1.8). After some initial troubleshooting to get the script running, it's creating 184 different shapefiles (736 ...
3
votes
3answers
3k views

How to extract latitude/longitude values for specific points from a shapefile?

I have obtained public crash data for the state of Minnesota. I would like to be able to programmatically extract the latitude/longitude of each crash using this data in combination with a series of ...
10
votes
5answers
501 views

Database versus Files for Solo Developer

I'm just getting started in GIS and am interested in using it to create maps of mountain biking trails in my area and nearby. I've been learning QGIS and have made enough progress to generate a decent ...
4
votes
0answers
486 views

How to create a routable road network from Ordnance Survey data?

I've been following the "Beginners Guide to pgRouting" in an attempt to create an in-house application that provides drive-time isochrones. I have a server, postgreSQL and PostGIS and pgRouting - no ...
2
votes
2answers
876 views

Setting up WMS with PostGIS, MapServer and Apache

I am trying to setup a web map service (WMS) for rendering a few shape files that I have stored in a PostGIS database. I decided to use MapServer for rendering engine and has installed it on my Ubuntu ...
2
votes
1answer
210 views

exporting lat/long points from shp file gives crazy results

i downloaded a shape file from the dept of city planning of NYC I use shp2pgsql to create a table (nybb) I use http://prj2epsg.org/search to determine my srid is 2263. which i then set. select ...
11
votes
2answers
356 views

How to clean such a bad shapefile for routing ?

I am trying to clean a shapefile to make it usable for routing with pgrouting, postgis, postgresql. Here an intersection, it seems to be connected but when we zoom …. It is not: Same here : ...
2
votes
4answers
3k views

Error importing Shapefile to PostGIS using Importer GUI

I'm trying to import a shapefile into a PostGIS database using the graphical importer. I just installed POSTGRESQL, and PostGIS. The GUI looks like this: After testing that my database worked, I ...
1
vote
4answers
2k views

ogr2ogr, convert from shp to postgis error

I am trying to import a shapefile into PostGIS using the ogr2ogr tools that are built into the FWTools package. In my import process I am receiving an error that I don't know how to deal with. ERROR ...
16
votes
5answers
2k views

Bulk load multiple shapefiles into PostGIS

I've got over a hundred data layers in shapefile format that I want to upload into a PostGIS database. They are all in the same projection, but represent different data layers so they do not have the ...
4
votes
2answers
486 views

Some objects missing after importing a .shp into PostGIS

I have a .shp file which I am trying to import into a PostGIS database using the "PostGis SHP and DBF Loader". This works smoothly but some (maybe 5%) of the records have an empty geometry field. (I ...
6
votes
5answers
2k views

Problem loading OS OpenData multipoint shapefile into PostGIS

I am trying to load the OS OpenData Strategi shapefile dataset into a PostGIS database. I have had no problems with the polyline and polygon shapefiles, but I am unable to get the point shapefiles to ...
12
votes
3answers
788 views

Centralizing shapefile data into database

I've got hundreds of shapefiles from various different GIS projects that I want to start consolidating into a single database platform, currently attempting this with Postgres / PostGIS. Hardly any ...
3
votes
2answers
1k views

How to get accurate mile markers from DOT ShapeFile?

I'm having trouble getting accurate mile markers through route traversal using PostGIS. Based on the discussion in Geocode from mile marker/milepost to latitude/longitude?, I downloaded Texas ...
5
votes
2answers
668 views

How does shp2pgsql define schema?

Can anyone explain how it is that the shp2pgsql loader for loading shapefiles into PostGIS goes about defining the schema for a table when importing a shapefile? To further explain, shapefiles are ...