Data

I am creating features with SQLCreator on Oracle 11g. I have some complex joins and filters ... and a LOT of them to issue. So many that Oracle CPU performance goes to hell. I'm told because it can't do all that hard parsing, because there are no "bind variables" I am using FME Server 2012. There are 16 engines, each submit 2 queries per job to get the features it needs to process. At any given time there are 32 queries executing at once and by the end of an hour 250+ jobs will have to run. That is over 500 queries needing a hard parse. With CURSOR_SHARING set to EXACT, the CPU thrashes itself to death. How can I get SQLCreator to use bind variables? Or should I use a reader and parameterize all the SQL for the Reader? Do readers force bind variables? Brad

Guys, I try to create a spatialite file with Dynamic porperties. The workbench works well but when I want to add this file in QGIS (connect a spatialite table database), I have the following error message : "dbname='...sl3' table"..." (GEOMETRY) sql= is an invalide layer and cannot be loaded. But, if I drag and drop the file in QGIS, it works correctly. Does anyone kown why ? It's really annoying becose I'd like to keep the same Qgis project working with Postgis (same layout and layers, just the database changes). It must be a problem with Generic geometry ou Specific geometry Cheers

Hello I need to use a spezialized Font in order to create text characters which represent symbols with predefined symbolization. All this because Mapinfo's Font-points are not scaled usefully while zooming, so I will try to use Text instead. I have a specially defined Font and I know the number of each character in the font-table. My problem now is, that I need to create an attribute with a char-value which I cannot type in through the keyboard, as I only know the number of the font character. How can I create an attribute with a one character-value whose font-char number (e.g. 45) is in the attribute "symbol_number" ? I guess Tcl or Python may do the trick, but how ? Thanks Michael

Hello, How can i choose my tablespace when i create my spatial index with FME 2013 ? Thank you Raphael

Hi, I need to change the direction of linear element any diection into clockwise direction.I used orientor transformer,it change the direction of shape only line,linestrings directions are not chaged. any other option is there to change the directon of linestrings.

Hello, I am very new to programming and recently downloaded the trial version of this software because I saw this link: http://fmepedia.safe.com/articles/How_To/How-Do-I-Label-Google-Earth-Polygons#heading_toc_j_0 I have no idea how to use this program, and I have quite a short deadline so any help on this matter would be helpful. I have several hundred polygons on Google Earth and they must all be labeled, preferably with a placemark. Can this software do that? Many thanks in advance.

Hi....I am trying to figure out how to convert 4 band high resolution raster TIFFs to black and white raster TIFFs....I'm not have much luck searching around.....I'm using FME 2013 Pro.....any tips are greatly appreciated.....Scott

Hello, I'm trying to load a SHP file into an existing SDE Feature Dataset (MS SQL). Using SDE30; however I cant see where you can specify a Feature Dataset? It will happily write to the Root. I have found similar issues reported: https://groups.google.com/forum/#!topic/fmetalk/STzkdjCzJfo however I'm still stuck. Any assistance would be greatly apprieciated. FYI I'm not a big user of FME. FME Desktop 2012 - MS SQL Thanks

I'm relatively new to FME, so any help here would be greatly appreciated. I can link to a SQL server to pull specific information from a table. However, I don't have write-access to the server, so I want to save the results of my SQL query in a CSV file. I've tried just doing a Reader of Oracle Non Spatial to a Writer of CSV. It reads the data fine, but nothing actually gets copied into the CSV File; it is just an empty file. I'm obviously missing something here. Can anyone help? Much obliged!

Hi I am fairly new to FME products. I have received a request to translate all OS Mastermap coverage for Bath area into CAD - normally straightforward - however the client is wanting it broken down firstly into 1 KM tiles and secondly into split CAD layers. Could somebody tell me if there is a relatively easy way to this using the FME Workbench software, to be able to breakdown single files into multiple small geosquares and layers without too much difficulty? Thanks David Haycock Bath and North East Somerset

The python script is (python 2.7) : import urllib mysock = urllib.urlopen("........") outcsv = mysock.read() oFile = open("c:\\temp\\example.csv",'wb') oFile.write(outcsv) oFile.close The problem with this script is that when I run it I do not get the right rows count of the csv file. To explain the script a bit better, with this startup python script I am calling a csv file in internet. Then I just want the script to save it in my C drive. After that a reader in FME will read to start another process. For the moment I do it manually (copy and paste my link into a browser, recuperate the csv file and save it to the right place in my C drive) without using this script and I am getting the right numbers of entries. I do not understand why I am getting different numbers of rows doing it manually and automatically? Does somebody have an idea? Thanks for your help.

Hi, I am using a writer to update some non-geometry columns and one geometry. But it is only updating non-geometry columns. I have explicitly set following parameters. Writer Mode: UPDATE Target Geometry Column Name: GEOM fme_where: id Am i missing anything? Subrat.

I have a 2d dwg file.I want to convert it to a 3d one which can be used in ArcGIS10.I want some advice,examples or documentations.THANK YOU.

Hi, Anyone have any experience with converting GTFS data to shapefile (lines and points) in FME. Or any other method available. Regards, KDMUR

Hi, I try to use a free transformer GoogleGeocoder. All adresses are rejected with error : Server can't find! Any help will be rewarded ! Thanks in advance.

I'm using FME 2013 SP1, although this problem has existing in previous versions as far back as I can remember. This problem comes up whenever I try to translate from GeoMedia SQL Server data to any other format I've tried (AutoDesk MapGuide 6.5, ESRI Shape, ESRI file geodatabase, etc.): when reading in polygon features from several of my GeoMedia feature classes, I get the following errors: 2013-07-02 11:24:29| 99.6| 0.0|WARN |Invalid 'Polygon' geometry detected. Start and end point not identical. Forced closing the Polygon 2013-07-02 11:24:29| 99.6| 0.0|WARN |... Last line repeated 7 times ... Since FME is force closing the polygons *as they are read*, I have no way of identifying them in my source data so that I can fix them. Following the reader feature type with a GeometryValidator transformer doesn't help because the geometery issue is already fixed before it hits the transformer. How can I go about finding these invalid polygons?

Fellow FMEers, This must be a simple one but I’m stumped. I just started with FME Server and I want to include some documents with the zip file that downloaded by the user. I have a workspace that grabs an ArcOnline image and saves it as a JPEG in a folder. In the same workspace is a datafile reader/writer pair that copies a file (found via UNC path on the server) to the same folder as the image. When I run the workspace on my desktop I get both the image and the doc but when I publish to Server I only get the image. Any one able to guess what I’m missing? Thanks, Alan

Good Day, Not a question but rather a discovery which may be of use to some others out there. I realize there are newer versions of all the mentioned systems but for a number of reasons the client is required to utilize these. So on to the problems: 1. All Feature Types (SDE layers) are created in SDE prior to running FME so Writers are created using Import Feature Types rather than using FME to create the layers. Again this is required as part of the business process. In order for FME to recognize these tables as spatial they must be opened in ArcCatalog/ArcMap first to initialize them without doing this FME tries to insert a NULL/nil geometry and fails. 2. For one particular non-spatial Feature Type, FME kept indicating that there was a missing column although did not specify which one. Google searches indicated it was likely an underlying issue with the SDE table. To try and determine the issue, we dropped and recreated the table, removed any contraints, keys etc but still no luck.

Is there any demo available uploading file to a workspace with the REST-API and not the HTTP PUT method as described in the documentation: http://host[:port]/fmedataupload/<repository>/<workspace>/<filename>

Hi, I am using the clipper on a dataset that contains many simple polygon features and few very large and complex features. I run the clipper in parallel processing and it seems to work correctly. However, the groups that contains the complex features take hours to complete while other groups with simple feature take few minutes. In this case there is no real performance gain with the parallel processing. Do you have tips to speed up the whole process? Is it possible to divide the complex features in smaller part ?

I have two workbenches. First one will gather some feature type names and use workspace runner to call second workbench which should read only selected feature types. I found i can send these values via published parameter. But i do not know proper format of listing these names in publish parameter for 'Feature Types to Read' that can be understood by oracle spatial reader. Please let me know how to handle this problem? Thanks, Subrat

Is there any way to make the File Geodatabase reader generic? It seems to be limited to the first feature type while using "single merged feature type" mode. Individual feature types is not an appeeling option...

I have some exif GPS data that I want to plot points for. These are strings: jpeg_exif_gpslatitude (54) (59.0226) (0) jpeg_exif_gpslongitude (1) (44.0662) (0) My problem is - how do I get these into a format 2d point adder will use? I can easily strip the brackets, but then its still a string and I get this: 2013-02-18 17:01:35| 0.6| 0.0|ERROR |2DPointAdder: @Tcl2 -- failed to evaluate expression `FME_Coordinates addCoord {1 44.0662 0} {54 59.0226 0}' -- String value `1 44.0662 0' contains invalid characters and could not be converted into a float Thanks. Note: Sorry about the colour etc. That's what happens when you copy/past it seems and there's no "reset" button.

Untill FME 2012 I was able to import feature types of PostGIS tables to a PostGIS reader / writer no matter if they had a geometry column or not. Since FME 2013 this is no longer implemented, the feature types import would only indicate tables with geometry columns to be selected. In order to add non geometry tables to a workbench, one has to add an additional PostgreSQL reader / writer. This is not very agreeable. I wish the prior functionality back!

Hi, My input feature has 2 attribute (One numeric ID, Geom Point geometry). I found 2 map geometries(Multiline) for ID in db. So after fetching, sql executor generates 2 features as (ID,GEOM,MAP1) and (ID,GEOM,Map2). I used aggregator assuming that it will return me (ID,GEOM,(MAP1+MAP2)) and then trying to write into database but failing. Please suggest me how to approach this problem? Subrat