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

learn more… | top users | synonyms (1)

33
votes
4answers
6k 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 ...
20
votes
2answers
3k views

Spatial ETL comparisons

I am hoping some of you experts out there can list the pro's and con's of various spatial ETL (extract, transform, load) tools. If you have used these items listed here (or add your own), please ...
12
votes
9answers
14k 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
6k 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 ...
10
votes
1answer
718 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
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? ...
9
votes
4answers
31k views

How to open the Shape files and extract the data from these files?

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) . We do not know how to ...
8
votes
3answers
2k 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
3k 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
3answers
952 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 ...
7
votes
1answer
2k 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 ...
6
votes
1answer
102 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
4k 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
2answers
699 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
2answers
199 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
2answers
800 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
810 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
338 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
1k 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
3answers
707 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 ...
4
votes
2answers
649 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
1k 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
172 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
1answer
3k 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 ...
4
votes
2answers
690 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
2answers
877 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
1answer
395 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
2answers
758 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
1answer
233 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
484 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
4answers
402 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
2answers
99 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
2answers
412 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
132 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
489 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
259 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
601 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. ...
3
votes
1answer
202 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
815 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
485 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 ...
3
votes
2answers
218 views

What program(s) can I use to edit a boundary?

So i've got some shapefiles imported into my Sql Server 2008 Database. A number of these boundaries need to get 'cleaned up'. As such I need to do the following :- Export them from Sql Server 2008. ...
3
votes
2answers
1k views

JPG file all black when added as raster in QGIS

I add a new raster layer in the latest QGIS and select a JPG file, but it is all black. I tried adding the TIF version of the same image and that worked. What is it with the JPG, and how should I ...
3
votes
4answers
940 views

How to import polygons from OSM to QGIS?

I am trying to import Polygons from OSM to QGIS 2.0, but so far I have no idea how to do that. E. g.: Kisterseg auf Tatabanya in HU: http://www.openstreetmap.org/?relation=1027806 Is there any fast ...
3
votes
1answer
1k views

How to import LAS to QGIS? [duplicate]

I need to import LAS files to Qgis. I´ve never worked with Qgis till now. Could anybody explain me this problem to the details? I´ve installed Quantum GIS v. 1.8.0. Thanks
3
votes
1answer
385 views

How to Create a Version 10 File Geodatabase from an XML from ArcGIS 9.2?

A client has given me an XML document for the schema of an ArcGIS 9.2 Geodatabase. The final goal will be to create a version 10 version of the geodatabase but the client doesn't have version 10 yet. ...