The Stack Overflow podcast is back! Listen to an interview with our new CEO.
37

I do it all the time for my clients. Dump your data to FileGDB or Shapefiles then execute the following command: For ESRI Shapefiles: ogr2ogr -f "PostgreSQL" PG:"dbname=mydbname user=postgres" myshapefile.shp For FileGDB: ogr2ogr -f "PostgreSQL" PG:"dbname=mydbname user=postgres" myFileGDB.gdb For FileGDB, you need to make sure that the FileGDB ...


11

I love open-source but FME easily wins out against the opensource ETL's as best I can tell. It's actually quite cheap for maintenance and support too (at least compared to most other corporate solutions we have for things). If you're looking for translations between formats then OGR may do it (with some piping into GDAL for transformations). Of course, that'...


7

The QGIS "Table Manager" Plugin now also has the ability to perform this task easily with no command line necessary.


7

I haven't tried this so can't verify it works, but the File Geodatabase API may allow you to export the data from file Geodatabase to SHP (and thence PostGIS). The documentation says: With the API you can... Read and write data


7

I have had a look around on their website and elsewhere. It has been three years since the last blog posting (February 5th, 2013) when version 2.5 of GeoKettle was announced. The mailing list for developers on sourceforge.net does not have any entries after December 2012. The mailing list for english speaking users had its last entry in september 2014. Last ...


6

In QGIS you can now use the processing toolbox (Ctl+Alt+T) and go to QGIS geoalgorithms > Vector table tools > Refactor fields. From there you'll have all the tools to edit your table structure.


6

Most of the simple operations can be carried out by these open source utilities ogr2ogr for vector gdal_translate and gdalwarp for raster Get FWtools http://fwtools.maptools.org/ and give it a try.


6

I did a comparison of various tools about a year back that also contains most of the options mentioned in this thread. As a more direct answer, I use FME a lot due to its versatility. However, when I work with complex data structures such as in CityGML, INSPIRE GML or bigger database models, I use HALE, an open source app developed for ETL and particularly ...


6

autocad map 3d will easily geo-reference your dwg/dxf files and allow conversion to 12 gis formats. Unless you add FME desktop also (FME extsion for ArcGIS). Then with FME extended to arcmap and autocad you have all ~275 formats. But doing it through map3d you have access to some particularly useful tools. (i.e. select by layer, color, linetype, or even ...


6

It seems to me that the main problem for you is to introduce some order to your tons of DWG/DXF files with information (in several layers). Regardless of choosing software/tool I can recommend you to describe your data. Here is some thoughts: You should develop some kind of unique codes for all types of your features. It can be one attribute or several or ...


5

The Esri file geodatabase API only works with file geodatabases created using 10.x - the older versions will not work with GDAL, QGIS or anything else that depends on the open file geodatabase API. The old Personal Geodatabases depend on MS Access and there are readers and code available. If you have a 10.x file geodatabase you can read layer from ...


5

If you look at blah238s duplicate link you find more information. I would say that Talend Open Studio and Pentaho GeoKettle is the most prominent open source solutions one can choose. Of these two Talend targets more than just ETL and GeoKettle a little more easy to use as far as I have read. My municipality is about to give GeoKettle a go to write a GML ...


5

FME is probably the best product to use in this space. After that it's GDAL/OGR. Another open source product in this space is geokettle - http://www.spatialytics.org/projects/geokettle/ although I have never used it in anger (being lucky enough to have both the other products mentioned). If none of those generic options work, you probably want to use a ...


5

No experience with MSSQL but for PostgreSQL it works by selecting the datatype serial and the index PrimaryKey. See screenshot. I suspect the datatype should be identity with index PrimaryKey. See also this documentation. Big StackExchange fan but you will have better chances getting a good answer on the Safe Software forum. Lots of knowledge and activity.


4

X-Ray arcmap add in have a tool for reorder fields of Geodatabes format


4

Use the JSON Reader and then use a VertexCreator transformer. This transformer (which was previously called the 2DPointReplacer) will let you convert the X/Y coordinate values into a true spatial feature. Then you can simply write the data to your Geodatabase Writer. Make sure the Allowed Geometries field is set to geodb_point


4

Is this probably due to configuration issues? Assuming you are on Windows, usually you can map your webdav resource as a drive in Windows Explorer as e.g. described here https://www.webdavsystem.com/server/access/windows/map_drive/ (same applies for Win10). Done so, you should be able to read and write to the maped drive as to a normal file system folder. ...


3

It sounds like you have some major batch processing and therefore, I would be inclided to script this. Doing this all by hand might be feasible but a pain. At least with a script, if you muck something up you can just correct the script and re-run. Also, you have a chance to unify a lot of the non-standard naming etc by using regular expressions and ...


3

Used Geokettle religiously for a small project high learning curve unless you used to an Eclipse UI... Really powerful as its compiled against GDAL1.10 support all geo types... What I liked was its support for both stored data and data via services... I used it to recreate and sync ArcGIS server datasets on a local postgis instance via ESRI json to GeoJSON......


3

QGIS (at least since the current version 2.6) now also has an integrated model builder. Through this toolbox you can access hunderds of algorythms (GDAL, GRASS, SAGA, vectortools, etc). You can also add you own script. I must admit I have not used it extensively, but if I was looking for a model builder I would consider it worthy of investigation.


3

Yo the best way to do it is to use Field Mappings. I've been struggling with this feature of ESRI software for years, but I'm finally content with this solution. Basically, you can just make a copy of your Feature Class with the fields permanently reordered using arcpy.FieldMappings. All of the data is carried over as well. Once the script is complete, just ...


3

I have had a similar issue, and the fastest way to permanently reorder data fields, if you already have QGIS, is to use the 'Table Manager' plugin as previously suggested. It is simple to install plugins and is user-friendly, as described on the page below: http://www.qgistutorials.com/en/docs/using_plugins.html It allows you to move the attributes in a ...


3

Feature Class to Feature Class now can perform this in 10.5 using the GP Tool Field Mapping section.


3

It looks like the output (convert-to-text) function is defined for the BOX2DF internal type, so you should be able to convert it to text and then to BOX2D with string manipulation: SELECT replace(mybox2df::text, '2DF', '')::box2d To get the native PostgreSQL box type, I think you'd need to break out some regular expressions: CREATE OR REPLACE FUNCTION ...


3

I think @buddiebubba is correct. Here's what my SQL Server definition looks like: Note that it's a dynamic translation. The Feature Type also has a parameter like this: By setting that to NO I cause SQL Server to increment that attribute, which it does nicely. However, I do get a warning message in the FME log: Microsoft SQL Server Spatial Writer: Data ...


2

FWIW work is going on to create a GDB to postgis loader. This depends on latest GDAL trunk which has GDB bindings. Haven't had a chance to compile and try myself but hope to before PostGIS 2.0 is out. check out - http://trac.osgeo.org/postgis/browser/spike/pramsey/postgis2fgdb You can probably give Paul a buzz on PostGIS newsgroup to find out where he is ...


2

While I have not tried it yet myself, I did just come across this tutorial (which is shapefile-->PostGIS) that uses the open-source geoETL software called "Spatial Data Integrator". I'm not sure if it supports Esri GDB or not, but it might be worth investigating further to see if you can use this product to make the similar conversion from GDB to PostGIS ...


2

To convert your CAD files to GIS, you'll need to add georeference information to your cad files. If your CAD files are in some recognizable coordinate system, you can assign those to your files, otherwise you'll have to 'manually' georeference the CAD file to translate the local coordinates to a projected coordinate system. I found this nice guide [PDF] at ...


2

SubstringExtractor should work too Category: Strings Extracts a substring from the source attribute. The substring is taken from the range of characters specified. Character indexes start at 0 for the first character. A negative index is used to indicate the position relative to the end of the string (-1 is the last character, -2 the second last, and ...


2

Try the Regular Expressions. It has been some time since I've used FME, but I know a while back they had a Regular Expressions Transformer (or the AttributeSplitter had a Regular Expressions option). You should be able to use a regular expression to match some form of pattern. For example, the address: 123 abc st, Sesame Street could be matched by the ...


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