New answers tagged

1

Can you store your labels in a separate table? Then just filter them out in FME (maybe a GeometryFilter transformer) and don't write to that table. You would need to ensure Overwrite Existing Database is set to No, but that all the tables have Drop Table set to Yes. As long as you don't write any features to the label table, it won't get dropped or ...


1

You should be able to make use of the Insert/Delete/Update options in FME database writers. For example, here's the dialog for PostGRES database (didn't see it for Spatialite). Note in that dialog there is also an attribute called fme_db_operation which you can populate somewhere in your workflow. I'm not sure if it is supported for Spatialite, however....


2

The simplest solution is to join the two sides together by dragging connections from each input to each output (click on the yellow arrow and drag a line from it to the equivalent red one). Then press the green run button on the toolbar and the translation will run. Quicker way to generate it in the future is to start with the empty canvas and press Ctrl+G. ...


1

The above answer is correct that FME won't save the current state of a translation if you stop it. Once a translation is started you have to see it through to the finish. I will file an enhancement request with the developers to see what they think. But I'd also like to discuss or suggest a few other options. 1) Have you had anyone check your workspace to ...


0

FME has the option of calling startup and shutdown Python scripts. It sounds like you could move the two halves of your Python inside an FME workbench along with the workbench.


3

I tried to pause a translation and exit FME, and it warned that the translation would stop. When I reopened FME, it restarted the translation from the beginning. My understanding is that the translation state and some data is stored in RAM, and it is lost when you close the application, and definitely lost when you reboot. This could be an idea for a ...


4

Yes, the NeighborFinder transformer finds the closest 'candidate' to each 'base'. Additionally, I would try a custom transformer we have called the PolylineAnalyzer. This transformer will tell you the overall bearing of each feature. If the bearing of the features you are matching are not within (say) 5 to 10 degrees of each other then it's likely to be ...


2

Have you thought about using the Dynamics CRM Web API to query the service using a GET request? You could use Python in a startup script or a PythonCaller (depending on how you need to process the data), using the adal library to authenticate, then use something like requests or urllib to send REST requests and get JSON back, which you could then parse to ...


5

NeighborFinder will do what you need. New = base, old = candidate. Parameters: 1 candidate to find, distance 5m. The only challenge is to prevent matching the wrong candidate at intersections. Snipping off first and last point of both the base & candidate features should do the job. ======= update 20160620 As Mark suggested adding the AzimuthCalculator ...


0

To me - since SQL Server doesn't seem to have a problem - the probable reason is a geometry that QGIS doesn't handle. The most likely of these is a GeometryCollection So, is the incoming data in any sort of group, and is that group homogeneous (ie all the same geometry type)? If it does not form homogeneous groups of geometry then a GeometryCollection would ...


3

In your Navigator Window where your Reader is shown scroll down to Parameters your will find Features to Read. Set Max Features to Read to 100.


0

Please see my solution below, I'm sure I could amalgamate this into a more elegant solution. Step 1 involved creating a view of the distance for every school to every childminder CREATE OR REPLACE VIEW education.vw_childminder_distance AS SELECT all_schools."Dfes", all_schools."UPRN", all_schools."NAME", childminders.title, childminders.ofsted_urn, ...


3

For FME it's best to have FME2015 or newer, because it has a new option for "Number of Neighbors to Find": Here I find the nearest three parks to a specific location. Notice I set Neighbors to Find = 3 and set a list name as ParkList. That list will contain the attributes of the three closest parks. I saved the above workspace as a template for FME 2016 ...


2

From what I understand from your question, I think you're trying to split a road segment based on To/From attributes you have in an excel file. You're on the right track with the snipper. The first thing you should do is use the MeasureGenerator transformer. You can create a measure for each road in your dataset. I suggest using a unique identifier in the ...


1

You can judge the existence of the result dataset and only when the dataset does not exist for processing. You can use FileExistenceChecker and NoFeaturesTester, they can from the FME HUB for download. Will you want to undertake the processing of connected to NoFeatruesTester NOINPUT port will be able to achieve your goal.



Top 50 recent answers are included