1
vote
0answers
49 views

How To Bulk Export Shapefiles Into Microsoft SQL Server using QGIS or PostGIS

Hey all thanks so much in advance for your help I have been researching this issue for a while. I have found two popularly suggested ways to preform this task: ogr2ogr - just take a shapefile and use ...
1
vote
1answer
34 views

Using ArcGIS for Server and ArcSDE for importing shapefiles?

Is there a way to use ArcGIS Server web services to perform the task below? I have .NET ArcObjects code to import shapefiles to Spatial DB which works on ArcGIS for Desktop. This code used ArcSDE to ...
3
votes
2answers
219 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
2answers
66 views

Unable to load shapefile as feature class into geodatabase file, with only 3 of the fields

I'm trying to automate importing census boundary shapefiles to feature class in a Geodatabase File, but somehow could not get it to work with this code: ### ======================== load boundary ...
2
votes
3answers
146 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 ...
0
votes
0answers
35 views

Openstreet map loosing information

I succesfully created a shapefile from openstreetmap with the OpenStreetMap tool in QGIS 2.2. When I try to create a polyline layer, it says that there are 8000 values in the db file for the property ...
0
votes
0answers
58 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 ...
0
votes
2answers
96 views

Robust importing of shapefile into spatialite database?

I am trying to import shapefiles into a spatialite database using spatialite-gui. I am having problems with the types of the variables since spatialite-gui has no obvious way to handle shapes which ...
0
votes
1answer
103 views

Selecting a valid format file

There has been an error when uploading a shapefile I want to start with some imported data. Upload a file. Please, select a valid format file # when upload a zip file: Oops! There has been an ...
0
votes
0answers
89 views

Import csv file and use “toggle editing” and “field calculator” without Saving it as a Shapefile.

I am importing a .csv file in QGIS and I have also made the *.csvt file where I have specified my data types. I still cannot use "Toggle editing" and "field calculator".Whether I must save it as a ...
1
vote
1answer
2k views

Importing shapefiles to SQL Server

I often use the brilliant SQL Server 2008 Spatial Tools to import shapefiles into SQL Server 2008. This works absolutely fine but it leaves me wondering, how do Microsoft expect end users of SQL ...
0
votes
0answers
132 views

Grass won't import shapefiles

I have a problem involving the import vector data command, specifically importing shape files. I installed QGIS on a pc at work and there I could import shape files into GRASS GIS 6.4.3RC2 (which is ...
1
vote
0answers
131 views

How can I add data to a shp file attribute table from arcobjects?

I have a code that selects row data from a listview table in VB.net. I have declared that data as a variable and I can see it if I ask it to dispay a message box (see code below). Now I would like to ...
0
votes
2answers
566 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, / ...
1
vote
1answer
408 views

Is the PostGIS Shapefile Import Manager able to upload to phpmyadmin or only pgadmin III?

After trying to import a shapefile into pgadmin III with no success I was wondering how to successfully upload it, but also if it is possible to upload to phpmyadmin instead. In any case, how exactly ...
2
votes
1answer
4k views

How to import shp2pgsql?

I want to import shape file into PostGIS. There is 1 database postgres in it but no table added yet. I am using this command: shp2pgsql -I -s 4326 districts.shp districts | psql -d postgres -U ...
1
vote
0answers
102 views

I've converted a kml to shp and want to import it to pgsql database, but no geometry column [closed]

As the title explains, I have a shapefile whose attribute table has no geometry column specifying the location of points. Rendered in QGIS, it looks fine, so the geometry data is obviously there. ...
0
votes
0answers
71 views

Trouble with making shapefile from xls file

Using DIVA GIS, each time I attempt to import some species data from an xls file to be plotted onto a map, the program becomes very slow and eventually becomes unresponsive. My dataset originally ...
2
votes
2answers
247 views

Problem with Coordinate Tolerances when I export my .shp files to .mdb

When I export my shapefile to a personal geodatabase using ArcMap, the result is not the same as the original database. I do not know how to solve this problem.
3
votes
2answers
3k views

Import Shapefile to Postgres

I am trying to import a shapefile to Postgres using the following: shp2pgsql c:\location\water_areas.shp water > water.sql I am receiving the following message: c:\location\water_areas.shp: ...
3
votes
3answers
497 views

How can I import only a subset of the polygons in a Shapefile using QGIS?

I have a shapefile that is covering a huge area, with lots of polygons. The area I'm insteresting in is small and limited. Is there any way to only import (using "add vector layer") the polygons from ...
2
votes
5answers
4k 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 ...
10
votes
4answers
33k views

Opening and extracting data from Shapefiles?

We are in need of US highway data. We found it for Florida at the state GIS website. We downloaded the data for Florida highway intersections from here (this is a zip file). How do we use these ...
5
votes
2answers
825 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 ...