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

learn more… | top users | synonyms (1)

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
717 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
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 ...
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 ...
4
votes
1answer
231 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 ...
3
votes
1answer
504 views

How to manage the osmosis command line?

This refer to this post : Read Here I'm in trouble when using osmosis command line to export data from planet-latest.osm.bz2 directly to osm2pgsql using some criteria to select what to transfer. I ...
1
vote
2answers
42 views

Import error:No module named _gdal

I have installed python 2.5.1 and FWTools2.4.7 in my laptop(Windows 7) when i run my pythonscript in FWTools i get following error Import error:No module named _gdal can any one suggest how to solve ...
1
vote
1answer
582 views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
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 ...
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? ...
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 ...
4
votes
2answers
752 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
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 ...
3
votes
1answer
989 views

Error importing XML workspace document to file geodatabase

Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
2
votes
2answers
205 views

Some data Loss when Import PGDB Table from Excel

When import table from excel some data were loss. i was try to change field type but i cant solve this error. I have attached an example image to show the problem.
2
votes
3answers
1k views

Batch convert ArcGIS 9x files to 10

I would like to convert all mxd's in a directory and it's subdirectories to ArcGIS 10 mxd's. This is so that I can then run python to automate some updates within them. Is this possible? This is my ...
5
votes
1answer
790 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 ...
2
votes
2answers
102 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 ...
2
votes
1answer
240 views

pyQgis in stand alone script, vector loading error

I am trying to use the Qgis functions in a stand alone Python script. I m running Mountain Lion OS, 2.7 Python & the Qgis 2.0.1 Dufour. My main problem is that I cannot get started - I cannot ...
2
votes
1answer
321 views

importing coordinates via a csv file does not work

I tried to manually add point data via a CSV file to an empty project in QGIS 1.8.0. The points do show up all right with the correct coordinates, but already the scale is not correct (using the ...
2
votes
2answers
1k views

Importing Lat/Long coordinates as CSV file & only displaying single point in QGIS

I am using QGIS and trying to import Lat/Long coordinates as delimited text layer. All points show up in my attribute table, however, only one point is displayed on the map? Any ideas?
2
votes
3answers
5k views

How to import shapefiles into MS SQL 2008 and then view that data using QGIS?

I'm a QGIS users but not a database person and I need some help on the DB side. I'm currently in the need to import several shape files into MSSQL 2008 and I have no clue how to do that and my IT guy ...
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 ...
2
votes
1answer
512 views

How to import SpatiaLite data into GRASS?

How can I import SpatiaLite tables into GRASS? Are there any restrictions I should be aware of? How does GRASS cope with columns that don't have a specific type (Sqlite tends to create such columns ...
1
vote
0answers
106 views

problem in using schema.ini to force ArcMap recognize field types

I have a folder of csv files (500+), and created a very long schema.ini file to force ArcMap recognize field types as I want. However, for some reason, ArcMap can read some CSV files properly; but ...
1
vote
0answers
2k views

Error when importing shapefile to Postgis database

I was trying to import shp to postgis database and i get the following error: Importing with configuration: adresy92, public, geom, C:\Users\tomek\Desktop\adresy92, mode=c, dump=1, simple=0, ...
1
vote
0answers
1k views

Importing XML file in ArcGIS failed

I have created a model in Enterprise Architect (in ArcGIS technology). Inside I have several point, polygon, line feature classes and a couple of domains which correspond to them. From the level of ...
1
vote
2answers
556 views

How to import .flt files into GRASS?

I am trying to import a raster file (.flt) into GRASS. The raster file (.flt) was generated from HEC-RAS. The said raster format cannot be imported into GRASS (it shows the error "file not ...
1
vote
1answer
3k views

Importing Leica total station .GSI file data into ArcGIS Desktop 9.x?

I have a total station data file (test.gsi) that was collected with a Leica 1200. How can I import the data to ArcGIS 9.x and plot points with the point name given by the total station observer. ...
0
votes
0answers
123 views

Why are some values missing from the imported CSV?

Bit of a strange one: i'm importing a CSV where the rows are the WKT data for regularly progressing rectangles from a grid, then the rectangle name, then values (ranging between 2 & 254). When I ...
0
votes
3answers
750 views

OpenLayers With UK Ordnance Survey Maps

How do I use UK ordnance survey maps with OpenLayers API without committing myself to using the OpenSpace API. I need to have generic OpenLayers code only.