Hot answers tagged etl
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
I think you are almost there: If you post your workspace (or screenshot would be easier to follow) What I think you are missing is the BoundsExtractor for your polygon (rather than the vertices) http://docs.safe.com/fme/html/FME_Transformers/Default.htm#Transformers/boundsextractor.htm *2014 FME Desktop used here (looks different to 2013)
X-Ray arcmap add in have a tool for reorder fields of Geodatabes format
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 ...
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 ...
Try importing the toolbox to catalog before running it from the same instance in ArcMap maybe. http://help.arcgis.com/EN/arcgisdesktop/10.0/help/index.html#//00vp00000013000819.htm
Although my answer is a bit late, it might be of help to others. 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 ...
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 ...
Only top voted, non community-wiki answers of a minimum length are eligible