Hot answers tagged data-import
10
The reason that you are not able to save Time related information in a shapefile is that the Shapefile format, does not support Time as an attribute. They only support Date fields. This is due to the fact that the shapefile uses an older specification of the dBase file (.dbf) to store the attribute table.
If you need to store time data, you are going to ...
10
To import shapefiles into PostGIS, you can use QGIS PostGIS Manager Plugin. It's a GUI for for shp2pgsql command line function. If you want to load KML files, you'd first have to convert those to shapefiles. This is simple: Just open the KML file in QGIS and save it again as shapefile. If you have multiple KML files, you might prefer using OGR Converter ...
9
I'll talk only about what i've seen in a professional context. A student of mine worked with an enterprise tasked to receive, validate and integrate huge quantities of spatial data, from a well known source (TeleAtlas) into their GIS. She used several workflows using FME, doing very complicated verifications and tranformations on the fly, from a format to ...
8
For a recent project working with several GBs of spatial data, I started the data loading / reprojections with FME. It worked well, but there is a learning curve.
By the end of the project I was using Python scripts to automate the reamining processes. FME can be scripted, but if you have the Python basics why complicate things further? Python gives you ...
8
My quick fix is to create the first row all with dummy values, and then delete this row/record after bringing into in ArcGIS.
This first row contains representative values or often wildly different values (e.g. alphabetic characters even if the column contains numbers that I want to be text data type) and with the largest number of characters needed for ...
7
A slight departure from the traditional CSV->ArcGIS layer could be to use ogr2ogr to create your shapefile from CSV BEFORE loading it into ArcMap.
When using OGR, you can manually create a CSVT file that describes your column types, similar to what ArcGIS attempts to do with the schema.ini file.
This post by @underdark on How to Specify Data Types of CSV ...
6
I created the following data.csv file:
AttributeID
101
101A
101B
Then I imported the data using the Table to Table tool:
Open ArcMap
Expand Catalog window
Located data.csv
Right click and select Export > To Geodatabase (single)...
Specified Output Location to be my Geodatabase (I'm using SDE on SQL Server)
Specified Output Table
Note that the field map ...
6
The clue is in the import log. Note that it says:
Failed in pgui_exec(): ERROR: type geography does not exist
LINE 10: "geog" geography(MULTIPOLYGON,4326));
^
Shapefile import failed.
So you should ensure you have a geography column named "geog", and that you are using a version of PostGIS that supports geography columns. If you do have a ...
6
QGIS and shp2pgsql (and they are FLOSS) are probably most popular for Postgres/PostGIS database as underdark already said. There are probably some FLOSS tools for MySQL and Oracle but i'm not familiar with those.
But if you have access to some commercial tools such as AutoCAD Map (via FDO) or Safe FME, you can import any spatial data to almost any spatial ...
6
You will need to do some formatting of your data to make them into polygons. Merely labeling a field as WKT will not help. If you have a lot of files (which it sounds like you do), the most effective way will be to automate your solution by writing a script.
I was going to explain how when I decided that the simplest way would be to write an example script ...
5
The ExtendedData does not have correct "name" values.
For example
<Data><displayName>System</displayName><value>Riverine</value></Data>
is not imported by GDAL and Qgis Master, while
<Data name="System"><displayName>System</displayName><value>Riverine</value></Data>
gets ...
5
With ArcGIS 10 you can create the feature class and set all field types first, then load the .csv file using ArcCatalog. Simply right-click the feature class and choose Load > Load Data. Then follow the Simple Data Loader dialog to match fields, etc. It is a simple loader in that there are not many options but it works for well-formatted data. I'm not sure ...
4
If you want to know how shp2pgsql works you can go to the source. You can download it here and the path to the code for this utility is in the postgis-1.5.1\loader\ folder.
A quick browse led me to the shp2pgsql-core.c lines 1288-1399 for the CREATE TABLE logic.
It looks like this portion (lines 1309-1360) might be what you are after:
switch ...
4
my problem is that every time and
every way i try to import this data to
a shapefile
Set your map document coordinate system to WGS84 then use the 'Add XY Data' tool to add the excel spreadsheet to the map; choose the same coordinate system and the X and Y fields.
You can add a base map from ArcGIS online for visual reference.
If this does not ...
4
QGIS can only read XLS if you have GDAL/OGR >= 1.9.0 built against the FreeXL library http://www.gdal.org/ogr/drv_xls.html
It will be easier to export to CSV and load using "add delimited text layer" if the data contains coordinates or "add vector layer" if the data contains no spatial information (and yes, that isn't very intuitive).
If you load CSV data ...
4
In a shapefile, numeric zeros are stored as text "0", while empty cells will be stored as empty strings "". However, ArcGIS interprets an empty string as a 0.
Because you cannot do anything about this, you need to use a work-around. A standard method, which is quite resistant to corruption from the GIS (or any other software), is to put an extremely ...
4
It depends on how the extract was made. Sometimes the big lakes are represented through a collection of OSM ways and if one or more ways are not within the bounding polygon, they get excluded and you don't get a full lake geometry.
I know I had some problems with Geofabrik's extracts for certain countries, since they used some imprecise border polygons to ...
4
I converted one of the wetlandfiles with globalmapper to shape: enclosed two screenshots from converted dbf-files (areas and lines):
hopefully this is what you want ..
4
To elaborate on HasT's answer, use GPSBabel to translate the GPX file to another format; I prefer to use CSV which appears as "Universal csv with field structure in first line" in GPSBabel's format dropdown.
Then in QGIS make sure you have the Add Delimited Text Layer plugin enabled and use it to add your new csv file to your map.
3
I think there is a bug in the Import Table tool because even when you explicitly specify that you want the supposedly numeric field to be text (right-click the field in the import tool window and go to Properties), it still imports the alphanumeric values as Null. As a workaround, you can put quotes around the first value for that column in the csv file. ...
3
I think import71.exe is flat out incompatible with Windows7. You could try finding the import71.exe > r-click > Troubleshoot compatibilty, which I did but without success. I didn't try every available option.
The command line ogr2ogr from the gdal utilities suite can translate the files just fine on windows 7 though:
ogr2ogr out_dir test.e00
Install ...
3
As others have mentioned, there are many tools avaliable to perform these actions, from dedicated x2y style command-line utilities through high-end Spatial ETL tools.
I personally use, and love the power of FME by Safe Software. It has paid for itself many times over in increased productivity. If proprietary/un-free software is an option for you, it's ...
3
I'd give ogr2gui (screenshots) a try, which provides a graphical wrapper around OGR, arguably the most powerful vector conversion library. In the long run, you'd help yourself becoming familiar with a command-line tools in this area, because of the great flexibility in OGR that isn't exposed through a simple GUI wrapper.
3
It's a problem with postgresql. You can solve it by editing pg_hba.conf
with
sudo nano /etc/postgresql/8.x/main/pg_hba.conf
where 8.x depend of your postgresql version (8.4 on Lucid Lynx)
You change in the column METHOD of the file the word ident by trust and save the file.
After you do a
sudo /etc/init.d/postgresql-8.x restart
Your pgrouting command ...
3
You can use Layer > Add delimited text layer
For more about this, you can read: Visualising WKT geometry string in QGIS
3
Not directly, AFAIK. There was a discussion on the gdal-dev mailist a year ago about this question.
You probably want to have a look at the las2ogr tool to get your point cloud into a format usable by QGIS.
Also, be sure to check out how GRASS handles LAS point clouds.
3
Before you start importing, you probably should read over the import guidelines on the OSM wiki and then email the Imports mailing list and as I see you're in the USA, the talk-us mailing list with any ideas and plans.
As you're probably aware, OSM data in its own xml-based format, so you'll have to convert your data to .osm.
I'm presuming that your ...
3
You can use Global Mapper software in which you can easily export/import kml/kmz files + attach data and lots of vector and raster formats..Its one of the best software..
http://www.bluemarblegeo.com/global-mapper/product/formats.php
3
A lateral solution - if you need commas every two coordinates for QuickWKT you can use a simple regular expression to create them.
Find: ([0-9\.]+ [0-9\.]+)
Replace: \1, (or $1, depending on the syntax).
So you end up with this:
<gml:Polygon xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:2154">
<gml:exterior>
...
3
TerraGo Publisher currently has a ArcGIS toolbar that does this. There is currently an ArcGIS Ideas link about adding GeoPDFs into ArcMap.
Only top voted, non community-wiki answers of a minimum length are eligible
