The process of loading external data to a software package.
19
votes
2answers
2k 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 ...
9
votes
5answers
994 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
3answers
427 views
How to best prepare CSV files for use in ArcGIS?
I wonder if there are any recomendations how to properly prepare CSV files for use in ArcGIS. I ask because I have some troubles using CSV files because ArcGIS attributes wrong field types to my ...
8
votes
2answers
163 views
Integrating geolocated Twitter posts in ArcGIS
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 Online ...
8
votes
1answer
366 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 ...
5
votes
8answers
6k 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 ...
5
votes
3answers
2k 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
640 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
676 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
178 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 ...
4
votes
2answers
188 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
353 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
139 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 ...
4
votes
2answers
327 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
649 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
1k 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
1answer
359 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
285 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
14k 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 ...
3
votes
3answers
314 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
1answer
509 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
153 views
Stitching thousand of 32 bit Tiff without geographic information
I'm working on a project which goes beyond my knowledges, I need your help.
I'm working with FLIR movies (thermal imagery recorded from plane), and I have to find a way to make a Tiff containing the ...
3
votes
1answer
396 views
Can an htm file be imported into Trimble's Data Dictionary Editor?
We've received several data dictionary files from other entities and they all are in *.htm format. We were hoping to not reinvent the wheel, as these are massive data dictionaries, so does anyone know ...
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 ...
2
votes
2answers
178 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 ...
2
votes
3answers
2k 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
1answer
3k views
how can i convert an excel table to a shapefile with correct scale in arcmap?
i know that there is already one similar question to this one but my problem is different and none of the provided answers did resolve my problem.
i've an excel table with some rows and in each row ...
2
votes
3answers
606 views
Is it possible to import an autocad feature to a feature layer without exporting to .shp/.dwg
Does anyone know if it is possible to import a feature (point, line or polygon) drawn in Autocad directly to a feature layer in ArcMap, so in essence a "feature sucker", rather then exporting the ...
2
votes
1answer
422 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 ...
2
votes
1answer
221 views
How does Quantum Gis work with Arcgis .xml files?
I'm not familiar to quantum gis, so can anyone explain if it is possible to import/export xml files in quantum gis? If it is possible, how can I do that?
I exported some . xml recordset and workspace ...
2
votes
1answer
278 views
How to specify which component of a file is imported when using a PluginDataSource?
In my application a plug-in datasource has been implemented to read specifically formatted files containing a mix of data types, including geometry in the form of polygons, lines, and points. Using ...
2
votes
1answer
74 views
Problem with SPIT (error while importing layers to POSTGIS)
I was attempting to import a polyline roads layer into postgis, using both SPIT in QGIS 1.7 and postGIS GUI for this purpose. I have received errors through both processes as described here:
SPIT
...
1
vote
1answer
142 views
How can I import geometries from an invalid GML quickly?
I have the following gml geometry :
<gml:Polygon xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:2154">
<gml:exterior>
<gml:LinearRing>
<gml:posList ...
1
vote
1answer
134 views
How to import datasets into OpenStreetMap?
A coworker of mine was recently given permission to import our local county government's GIS data into OpenStreetMap. I've made single edits on the OpenStreetMap site before, but I have never imported ...
1
vote
1answer
227 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 ...
1
vote
1answer
983 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
2answers
408 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
2k views
How do I import Total Station Data (.gsi files) into ArcGIS?
I have a Total Station Data file (test.gsi) that was collected with a Leica 1200.
How can I import the data to ArcGIS and plot points with the point name given by the totalstation observer. After ...
1
vote
1answer
215 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
1answer
185 views
How to import GEBCO bathymetry into QGIS?
I'm experiencing problems with the import of bathymetry data in QGIS, which I downloaded freely from GEBCO or NOAA. The problem is that if I import the grid (either with .nc or .asc extension, or if I ...
1
vote
1answer
236 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 ...
1
vote
2answers
549 views
Import and Plot MS Excel file in ArcGIS (v9.3) ModelBuilder
I am trying to create a tool using ArcGIS ModelBuilder (v9.3) that will allow me to import an Excel file, and output it as a shapefile in a coordinate system of my choice - or, if choosing the CRS is ...
1
vote
1answer
23 views
How to open a .k format (I think it is made with IDRISI product) with open source software
I just received a .k file which I know it was made with a IDRISI software (i do not know which). I serched the web and I did not find many information on this format a part for a very essencial page ...
1
vote
0answers
62 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 ...
1
vote
0answers
120 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. ...
1
vote
1answer
56 views
Why would a map lost the coordinate system when I use it in ArcGis?
I have a file in AutoCad with ETRS89 coordinates, and when I use the same map in ArcGIS it loses coordinates. With other files do not happen.
1
vote
2answers
272 views
ArcGIS Data Interoperability Quick Import - problem with copying original attributes from DGN file
I am new to DI extension and I wanted to ask you why "Qucik Import" tool doesn't allow me to copy the original attributes from my DGN file. When I check the results in geodatabase I is some new ...
0
votes
2answers
528 views
osm2pgrouting connection failed
I'm importing data from my OSM file to a postgresql database using osm2pgrouting. I followed everything in from here and it went smoothly, until I try using osm2pgrouting. This is what happens:
...
0
votes
2answers
799 views
Unable to Import Data
I am following this tutorial,
but i am not able to get the right username and password to import data. How do I know what the username password is? By default I see tomcat6 as database and username ...
0
votes
0answers
10 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 ...
