Tag Info

Hot answers tagged

21

To be honest the time frame you mentioned for the migration sounds really tight, especially if you want to research, test, evaluate and deploy! We have recently migrated from using ArcGIS as our desktop client to QGIS. While everything you have mentioned sounds possible the biggest issue I have found is managing the storage of Raster datasets, but like Nick ...


19

1) Analyse the areas outlined with the polygons and added buffers to some of them. Buffers are supported. For further help, we'd need to know what "analyse the areas" means. 2) Answer questions like: Does this kind of fish (represented by a layer of points) always occur near a certain rock type (represented by polygons or points). You can check if ...


14

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 ...


13

You can download and use QGIS which is a simple and effective free G.I.S. software. http://www.qgis.org


11

Previous MXDs should load, no need for conversion. However, it will save to 10.0 when you save your updates. However: import arcpy import glob import os for pathname, directories, filenames in os.walk(r"c:\startdir"): for filename in filenames: if filename.lower().endswith(".mxd"): mxd = ...


11

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

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 ...


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 ...


10

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 ...


9

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 ...


8

It is possible that there is something wrong with resolution and tolerance in PGDB. Take a look at sections X,y resolution and X,y tolerance in this topic. Try increasing these values. What coordinate system are you using? What values are set for resolution and tolerance?


8

Have you tried -W "latin1" flag? Sometimes the default encoding (UTF-8) doesn't work well. Maybe you'll have better luck with latin1 encoding: shp2pgsql -I -s 4326 -W "latin1" districts.shp districts | psql -d postgres -U postgres There's a useful cheat-sheet available here. Hope it helps..


7

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 ..


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 ...


7

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 ...


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

arcpy (actually arcgisscripting which it wraps) extends a specific version of python. At arcgis 10.0 you need to run with python26. I'd make sure all the versions are matching. Instead of doing this C:\> test.py Do this C:\> C:\python26\Desktop10.0\python.exe test.py Then you know it's starting the correct version of python. If that second ...


6

In ArcPy, you can do a table to table conversion, which supports csv. from ESRI: "For file input (.csv or .txt), the first row of the input file is used as the field names on the output table. Field names cannot contain spaces or special characters (such as $ or *), and you will receive an error if the first row of input file contains spaces or special ...


6

The message you are getting is that 'type geography does not exist' This either means you did not install postgis correctly or you are using an older version? Geography data type was introduced in version 1.5


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

You can direct your .py script or interactive interpreter to the location of your arcpy installation. This would be achieved using the sys library and an append method on your sys.path import sys sys.path.append("path to arcpy") "path to arcpy" is usually: "C:\\Program Files (x86)\\ArcGIS\\Desktop10.0\\arcpy" However, I am not familiar with accessing ...


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

ERROR: **function addGeometrycolumn**(unknown, unknown, unknown, unknown,unknown, integer) does not exist It seems that PostGIS is not yet installed. PostGIS is an extension of Postgres which allows the use of geographic files. Install it and your import will work fine.


5

I think you'll be happier with CAD software than with a GIS. QGIS has a toolset called CADTools but you'll have difficulties importing any PDF or SVG.


5

You can use the DataInteroperability (DI) - Import/Export tool (using IGPTool) for the same. The extension is enabled by default for ArcEditor for certain formats (including CSV and GML) and allows data to be read/written. I've done a similar export (to GML) some time back and it works perfectly!


5

I did call ESRI support about this and their answer wasn't encouraging, but it did explain the problem. Paraphrasing ESRI: The problem is that ArcGIS Desktop, being 32-bit software, is limited to using 4GB of RAM at the most. The text file has to be processed in RAM before being stored as a table, so at some poing during processing ArcGIS was hitting the RAM ...


5

Have you tried kml2shp? http://www.zonums.com/kml2shp.html They have a new online converter as well: http://www.zonums.com/online/kml2shp.php


5

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


5

Using FME 2012 (SP4) Load the Reader KML Select a Writer (Shapefile) connect the items and on the write select (copy attributes from feature types) Run the workspace


5

I have seen this behaviour in other software when the number of entries in a row doesn't match the number of field headers, or the data type changes at one line (ie a string field finding a numeric entry or visa versa). You would be advised to examine the rows carefully, particularly if you are using a spreadsheet to create the *.csv since mixed data types ...



Only top voted, non community-wiki answers of a minimum length are eligible