Questions tagged [import]

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

Filter by
Sorted by
Tagged with
46
votes
8answers
140k views

Importing DWG into QGIS project?

I have a lot of DWG files like basemap, and water and wastewater network. How do I import these files into my QGIS project?
39
votes
4answers
12k views

How to migrate from ArcGIS for Desktop to QGIS? [closed]

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 ...
33
votes
10answers
16k views

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

I am interested in the pros and cons of various spatial ETL (extract, transform, load) tools. If you have used the items listed here (or add your own), I seek your opinions and experiences. In ...
26
votes
10answers
43k views

Converting KML to shapefile without losing attributes using QGIS?

I have a KML file with hundreds of points. To each point there is information, such as Name, Power, Age (it's a map of hydroenergy powerplants). If I import that KML file to QGIS, this information is ...
18
votes
4answers
70k 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 ...
18
votes
5answers
20k views

Is it possible to georeference an existing, un-georeferenced pdf?

I was wondering if there was anyway to georeference a pdf directly without first converting it to an image. I have access to ArcGIS 10.1 but haven't been able to find any information that would ...
16
votes
6answers
17k views

Preparing CSV files for use in ArcGIS Desktop?

How do I prepare CSV files for use in ArcGIS Desktop. I ask because I have some troubles using CSV files because ArcGIS attributes wrong field types to my columns and also misinterprets special ...
13
votes
1answer
18k 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 ...
13
votes
2answers
15k 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 ...
12
votes
5answers
12k views

Setting up 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.
12
votes
4answers
21k 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 ...
12
votes
1answer
1k views

Why the order of imports matters in a standalone PyQGIS processing script?

I've come across a weird issue while running standalone PyQGIS processing scripts. The order of imports in the script affects its normal execution. You can reproduce the problem by opening a Python ...
11
votes
5answers
3k views

Seeking tools for uploading GIS data to 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?
11
votes
4answers
14k 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 ...
11
votes
1answer
15k views

Importing shapefiles to SQL Server [closed]

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 ...
10
votes
1answer
2k 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
1answer
21k views

How to import using shp2pgsql?

I want to import shapefile into PostGIS. There is one 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 ...
9
votes
2answers
746 views

Add an Excel file with a list of coordinates to QGIS as a layer?

I've added delimited text layers to QGIS before with columns consisting latitude and longitude separately. But Now I have an Excel file like: station no parcel no parcel coordinates 63 ...
9
votes
6answers
5k views

QGIS won't read table columns in CSV import on Mac OS

I am trying to import a CSV file into QGIS, but it ends up looking like my print screen below (program is in Swedish but in the preview window you can see how QGIS won't read my data correctly). I can'...
9
votes
2answers
9k views

Importing .svg images to use as Symbols in ArcMap?

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.
8
votes
3answers
15k views

Import GeoJSON into PostGIS

I want to import GeoJSON avaliable in the following dump into PostGIS but I am not able to import it. I already imported geousa data available in this public dump into MongoDB smoothly. Let me know is ...
8
votes
2answers
8k views

Importing large dataset with osm2psql? [closed]

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 OSM data ...
8
votes
3answers
5k 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
5answers
16k 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 15 minute intervals. When I import the file and save it as a shapefile the time column is not read properly and ...
7
votes
1answer
4k 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. ...
7
votes
2answers
6k views

Looking for an open-source Java based GeoTIFF library

I have written many programs for reading and writing various types of spatial data in the past but I must admit that the GeoTIFF format has often gotten the better of me. It's such a flexible format ...
7
votes
3answers
6k 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
4answers
3k 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 ...
7
votes
2answers
1k 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 ...
7
votes
1answer
10k 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 ...
7
votes
1answer
2k views

Difference between raster() and readGDAL()?

I am new in working with rasters and after having trouble working with them i'd like to know the difference between those two import functions. for example i did this library(raster) s<-...
7
votes
3answers
3k views

Getting ArcMap to recognize csv column as float and not int? [duplicate]

I am trying to show a .csv file (2 columns, 291 rows) in ArcMap 10.2 using Catalog window to drag the .csv file into ArcMap. The second column of the .csv is a floating point number (range is [0-1]), ...
7
votes
3answers
4k views

Importing OSM Data into MongoDB?

Can anyone tell me how to import OSM data in mongoDB step by step ? This is the link to the data http://download.geofabrik.de/europe/germany/baden-wuerttemberg/karlsruhe-regbez.html https://gis....
7
votes
2answers
1k views

QGIS DB Manager Import layer/file Oracle not working - Error 8 Loading of the layer failed

QGIS 2.12.0 - DB Manager 0.1.20 - Windows 7 - Oracle 11g 11.2.0.3.0 Import vector layer Shapefile as well as a layer (vector) and with every possible combinations of settings, the results are the ...
7
votes
0answers
256 views

Is it possible to open MapGIS files ( .WL, .WP & .WT ) in QGIS or other GIS? [closed]

We received some files from clients located in China created in a program called MapGIS. I was wondering if anybody knows how to make QGIS or any other GIS program, excluding MapGIS, open these files? ...
6
votes
4answers
4k views

Header row in Excel is not header row when imported into ArcMap?

I am importing an Excel table with X/Y coordinates to plot on a map (point data). The original Excel table has a header row as its top row..The row is 'frozen' in Excel. When I import the table and ...
6
votes
3answers
26k views

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 ...
6
votes
1answer
307 views

Descrambling scrambled coordinates?

I've got a data set that comes with coordinates, however they seem to have gotten scrambled somewhere along the way of data-collection, data-entering and data-export. For some of the places the actual ...
6
votes
1answer
7k views

Using ArcPy outside of 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
2answers
106 views

Import unknown CSV file format in QGIS

I have a CSV data sheet that I would like to import in QGIS as a set of polygons. The CSV file contains a column of geometries with long lines of data (see example below). Can somebody tell me how I ...
6
votes
2answers
234 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: PROJCS["NAD_1983_StatePlane_California_II_FIPS_0402_Feet",...
6
votes
2answers
2k 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 ...
6
votes
3answers
14k 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?
6
votes
3answers
5k 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 ...
6
votes
1answer
434 views

Laspy exception: “Invalid format”

I am attempting to open a couple of las files in laspy, however one of them has file version 6.0 (although it does not show up as such in lasinfo - I may be missing something). Digging through the ...
6
votes
0answers
119 views

Importing csv into QGIS [duplicate]

Very basic question, just started to use QGIS. I've been trying to import my own csv file with lat/long into QGIS. No luck, thought it was my excel file that was not with the proper format. I tried ...
5
votes
3answers
3k 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 ...
5
votes
3answers
7k views

How do I import UK Environment Agency Lidar data (.asc) into QGIS

I have downloaded Lidar data from the UK Environment Agency as ESRI ASCII files but being a complete novice as far as GIS is concerned I do not know how to view them. Quantum GIS was recommended to me ...
5
votes
3answers
2k 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
3k 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 ...