To bring data from one computer system or application into another.

learn more… | top users | synonyms (1)

35
votes
4answers
7k views

How to migrate from ArcGIS for Desktop to QGIS?

Our lab has about 10 projects in ArcGIS 9 (a couple are made in ArcGIS 10) that includes the following in each: A georeferenced (WGS1984 geographical projection) raster seafloor image, representing ...
22
votes
9answers
4k views

Seeking options for Spatial ETL (Extract, Transform, Load)?

I am interested in the pro's and con's of various spatial ETL (extract, transform, load) tools. If you have used the items listed here (or add your own), please share your opinions and experiences. ...
13
votes
9answers
16k views

How to convert KML to shapefile without losing attributes?

I'm new to QGIS and all geoinformation itself but have to work on some difficult stuff. I have a KML file with hundreds of points. To each point there is information, such as Name, Power, Age (it's a ...
12
votes
2answers
7k views

How can I sucessfully import 3D surface and features from ArcGIS 10 into Sketchup 8?

What are the steps required to successfully export an entire 3D model (composed of TIN surfaces, 3D polygons, 3D polylines and 3D points) from ArcGIS 10 to Sketchup 8? Preferably, I would like the ...
11
votes
4answers
35k 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 ...
10
votes
5answers
1k views

What tools are available for uploading gis data to a database?

I would like a nice graphical tool that allows me to take standard gis data such as shp files and kml files and upload them to a database such as PostGIS, MySql or Oracle. Are there any such tools? ...
10
votes
1answer
827 views

Integrating geolocated Twitter posts in ArcGIS for Desktop?

Is it possible to integrate the lat/long data included with Twitter posts (those few that have it enabled of course) into an ArcGIS Desktop environment? I've seen Twitter applications on ArcGIS ...
9
votes
3answers
3k views

Preparing CSV files for use in ArcGIS for Desktop?

I wonder if there are any recomendations how to properly prepare CSV files for use in ArcGIS for Desktop. I ask because I have some troubles using CSV files because ArcGIS attributes wrong field types ...
8
votes
4answers
4k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
8
votes
2answers
4k views

Is there a way to add a PDF to ArcMap as data?

I receive a lot of PDF maps (vector, image, with georeference and without) and I am having to convert them to an image file before I can add them to ArcMap and georeference. I can't see any obvious ...
8
votes
3answers
1k views

How to fix “Unable to initialize ODBC connection to DSN for ALC_AV_CO”?

So I am new to the QGIS community, and I have been trying to bring in some rather large access databases with little to no success. I have windows 7, so I've gone in through administrative tools/Data ...
7
votes
3answers
3k views

How to import/export geographic information (gml or csv file) to geodatabase?

I am searching for C#/Java libraries that can import and export geographic information (gml/csv file formats) from and to geodatabases. If not yet available, is there other way to do this task? Any ...
7
votes
1answer
3k views

using arcpy outside arcmap

There may be something I'm missing, but is it possible to use the arcpy module outside arcmap? My situation is that we have one license on a computer which is shared over a network. I need to do ...
6
votes
1answer
112 views

Postgis 2.1 Inconsistent with spatialreference.org

The County of Napa, California, uses a projection "NAD_1983_StatePlane_California_II_FIPS_0402_Feet"; for example their roads.prj file has: ...
5
votes
4answers
5k views

Importing data from excel and maintaining the time format

I am trying to import a file from Excel which is a GPS data set of consecutive points at 15minute intervals. When I import the file and save it as a shape file the time column is not read properly and ...
5
votes
3answers
1k views

How to read Alphanumeric value when importing csv location file to ArcGIS?

So I am importing a csv file to ArcGIS and it has a bunch of alphanumeric values.. e.g. Attribute ID contains values such as 101, 101A, 101B etc ...the problem is when i am importing the csv to ...
5
votes
3answers
7k views

How to import info from mdb file into a project?

I need to import info on a QGIS project. The info are in a MDB file (population, mean age, number of cars and so on: one record per region) that is written to be connected with a region shape from an ...
5
votes
2answers
815 views

How to batch import GDAL supported raster files into GRASS?

I am trying to import some GDAL supported raster files into a binary raster map layer using the r.in.gdal module from QGis Grass tool. As I have multiple files to import, I would like to batch import ...
5
votes
3answers
789 views

Convert Ordnance Survey NTF data to QGIS compatible format

Is there a way of converting Ordnance Survey NTF data to QGIS that will correctly import the data and build polygons? QGIS will read the data as is, but it imports the polygons only as ...
5
votes
2answers
216 views

OSM Country import - missing border-near lakes, rivers

I'm importing a country (e.g Switzerland) from the cloudmade OSM branch and I'm failing to get the bordercrossing lakes on display. The same issue came up, when I tried to import the geofabrik .dpf ...
5
votes
1answer
4k views

Import polylines and polygons into QGIS from CSV

I'm assuming this is a simple question, though my efforts have not yet found the answer! I want to import a large number of polylines and/ or polygons into one one or more QGIS layers in order to ...
5
votes
2answers
850 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 ...
5
votes
1answer
2k views

QGIS and SQL Server Spatial Tables Performance

I'm trying to get a SQL Server 2008 R2 spatial database up and running to streamline the production of maps using QGIS. Currently I just have a handful of spatial tables (a postcode level point table ...
5
votes
1answer
369 views

PLT track in PostGIS

What are the best practices for importing and aggregating tracks (in my case in 'plt' format) in a PostGIS table, grouped by user. Are there any tools/db models/tutorials available?
4
votes
3answers
2k views

Why would “import arcpy” hang Python script run from DOS/cmd prompt?

I have a very small test script (test.py) that I use to see if Python is installed and ready to use ArcPy. All it contains is: print "Starting" import os print "OS imported" import arcpy print "ArcPy ...
4
votes
2answers
2k views

QGIS import polygons in CSV

QGIS 1.8 on Mac: I'm hoping to migrate several dozen local maps from my 30 year old Win3.1 plotting system to QGIS. Polygons are in X,Y (CSV), first point repeated at the end to close it, with ...
4
votes
1answer
771 views

Setting geometry types importing to PostGIS with OGR

I'm using ogr2ogr to import data into a PostGIS database. Each dataset I need to import has (theoretically) the same exact data structure, but it appears that they are not the same geometry types. ...
4
votes
2answers
726 views

GPS-Plugin and Garmin data

I am an avalanche specialist and I use a GPS Garmin 62 for fieldwork. I for example use waypoints to measure snow depth in avalanches for volume calculations. When I add a waypoint in the garmin ...
4
votes
2answers
2k views

Importing data with empty cells without GIS replacing the empty cell with 0

I am importing data from excel into ArcGIS 10. The data are columns of GPS data, associated date and time, and a unique point identifier. For some of the rows the GPS data is missing and so the Lat ...
4
votes
1answer
189 views

Why does ogr2ogr silently skip some rows?

I have a CSV file called office_locations.csv that contains point data. I want to load it into a SQL Server geospatial database using ogr2ogr. The CSV file is encoded in UTF-8. It contains a header ...
4
votes
2answers
1k views

Importing .svg images to use as Symbols in ArcMap 10.1

I have several .svg files that I want to use as symbols in ArcMap 10.1. However, I do not see any import feature or the sort to use these .svg pictures. Thanks
4
votes
3answers
1k views

How to preserve non-ASCII characters in ogr2ogr import?

I want to import a list of international place names and their locations into a SQL Server database using ogr2ogr. The source data is a CSV file encoded in UTF-8. I've prepared a five-record sample ...
4
votes
2answers
894 views

How to setup PyCharm to reference ArcPy?

How would I setup PyCharm to recognize import ArcPy? I'd like to use PyCharm to develop and debug geoprocessing tool.
4
votes
1answer
494 views

Using the Processing Framework in QGIS 2.0

I am writing a plugin for QGIS 2.0, and I want to use the processing framework to call some functions. When I open the pyhton console inside QGIS, I am able to call it like this: >> import ...
4
votes
1answer
272 views

Is there a way to select what to import from planet-latest.osm.bz2 to database?

Is there a way to select what to import from planet-latest.osm.bz2 to database? I want to do something like : osm2pgsql ... --place='city' --admin_level='2' My goal is to use only cities and ...
4
votes
1answer
503 views

Importing multiple shapefiles with tablespace and inheritance defined

In the UK we are very fortunate to have the Ordnance Survey who provide the whole of Britain in vector format. The data is provided as over 60 tiles, each of which contains something like 16 ...
3
votes
1answer
5k 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 ...
3
votes
4answers
414 views

Tools for planning a building

I'm planning to build a cabin, and I'd like to combine all the GIS data available from my home country with my own measurements for placing and the cabin layout. That is, I need a tool which can: ...
3
votes
3answers
219 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 ...
3
votes
2answers
342 views

Most reliable way to import large dataset with osm2psql

I know my question is similar to slow import via osm2pgsql to postgresql database and Optimizing osm2pgsql imports for OSM data but as we currently have quite some problems importing a large set of ...
3
votes
2answers
532 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 ...
3
votes
1answer
320 views

Retrieve geographic coordinates from OSM imported data

We have just finished importing OSM data into our PostGIS (Postgresql) database. And we are having difficulty understanding the geometry of various shapes imported. We run a query to retrieve the ...
3
votes
2answers
575 views

How do you read GeoTiff-file in SAGA GIS Program?

I'm very new with all GIS-stuff and I got advice that SAGA GIS would be a good program to start with. I would like to read a GeoTiff-file in SAGA, but I can't find an "import file"-function x) Any ...
3
votes
1answer
136 views

Import CSV: Is there a cap for number of row

I am trying to import several CSV files which contain more than 1,000 rows respectively. However, but only 129 records were only imported each file. Can't see any options that deal with this? I am ...
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
517 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 ...
3
votes
2answers
281 views

Question about Import 71 and file permission in ArcGIS

I am making a map for my thesis. While using ArcGIS, I must use Import71 to convert some .e00 files (In this particular case, political boundaries and Hydrography networks). When I select my output ...
3
votes
1answer
225 views

How can I preserve date field format when importing to QGIS?

I have a slight learning curve working here, is there a work around to importing spread sheet data without changing the type of data in the fields? i am importing some water test data along the rio ...
3
votes
1answer
863 views

How to change data type in Excel file before creating feature class?

I am trying to import data from Excel spreadsheets where each point coordinate has a 'datetime' timestamp (e.g. "2012-06-01 14:45:32") associated to it. When I check the table properties ArcGIS 10 ...
3
votes
3answers
514 views

Why do XLS files cause Error: “.. is not a valid or recognized data source”

In QGIS, I am trying to add some non-spatial data (in .xls file) that I want to use to join to some spatial data. Adding the file, either from 'add vector' or dragging file onto project I get the ...