Transformers

Hello,I need to calculate the percentage: for Example:need to get how many percent of "adresses"= Anzahl_DT have DT_DOWN under 50 (so DT_DOWN 16 and 50)the 100%= Anzahl_Privat= all adresses are 3693sum of Adresses under 50 = 1845+577I tried to built it with ExpressionEvaluator but I´ve became "null" result   the other problem here is: I do not want to have theese "missing" fields in outputhow or where can I edit them?It wa created with Esri Shape Writer and Reader; StatisticsCalculator and AttributeCreator 

I really like the capability to share a workspace in FME Server 2019.It would be really good if we could add content to the page for example so we can explain a bit more to the user.It would also be great if we could brand the self service page!Thanks

Hello all,I have a line dataset that I used the transformer chopper to break it into its start and end points.I now need to use the id of each of these points to add back onto the lines so I get a toPoint ID and a fromPoint ID on each line.I have looked at PointOnLineOverlayer but can't see how to add the IDs back to the line.Any assistance would be very much appreciated once again :)RegardsDean

Hi I have the following table after doing a database queryID overlaps Count Email0 2 1 PublicOps@sts.com0 2 1 PrivateOps@sts.com1 7 3 PublicOps@sts.com1 7 3 PrivateOps@sts.com1 7 5 PublicOps@sts.com1 7 5 PrivateOps@sts.com2 5 3 PublicOps@sts.com2 5 5 PrivateOps@sts.comFor each ID, I need to retain the records with maximum count i.e.for example above, I need to output to be ID overlaps Count Email0 2 1 PublicOps@sts.com0 2 1 PrivateOps@sts.com1 7 5 PublicOps@sts.com1 7 5 PrivateOps@sts.com2 5 5 PrivateOps@sts.com Following this, I need to join output with table 2 to determine if the count is higher than the level valuefor each ID. If it does retain in output, otherwise discard record from table 1 Table 2--------ID Level0 11 32 3  Hence output expected is: ID overlaps Count

Hello all,I am having a problem with the projection being stored against the output features.I am reading in a DWG file, setting the projection to EPSG:28354 and then writing to PostGIS.In the workbench it is showing the correct projection but if I display in data inspector or in QGIS, no projection is being stored with output data. The above image is within workbench (2019) and the coordinate system as expected.  In Data Inspector the coordinate system against the selected feature is "Unknown"Is there something additional that I need to do to get the projection to be stored with the output data?Thanks in advance for your assistance.Dean

Hi, the question ArcPy "import" statement tries to perform import action?https://knowledge.safe.com/questions/37659/arcpy-import-statement-tries-to-perform-import-act.html was raised in 2016 and doesn't appear to have a satisfactory answer.I have been experiencing the issue this week - adding import arcpy to the top of a PythonCaller. When the Workspace hits the python it hangs for 10 seconds then spits out thousands of lines (red, black and blue) around Autodesk 3DS before going on to successfully complete.While it is great that my Workspace runs successfully, it takes a couple of minutes when it should be just a few seconds.I am on FME Desktop 2018.1.1.0, ArcGIS 10.2 (Server is 10.0), running Python (ArcPy) 2.7. Environment variables are set and FME is looking at the right location in Options.Cheers,Mark 

Does anyone know how to read undefined attributes in s57 file? I have a .000 file but it contains a few undefined attributes. ESRI S57 viewer is able to read these undefined attributes but fme can't. I tried to modify the s57 attribute csv file under the fme directory by adding the undefined attribute to the list, but I got object class mismatch error when running the translation. Is it possible to read undefined attributes? any suggestions? I'm desperately in need of help to translate these undefined attributes.

hello, I use a professional licensed version of FME desktop 2019 in 32 bits. I have also instal a version of FME 64 bits (2018)I try to open a geoconcept map to extract data. I had install a the 7.3 version of geoconcept. In FMe, I can choose the map I want but when I try to open the table list in the transformer parameters, I obtain a error message : "Module 'GEOCONCEPT' is unavailable for use with this FME edition"When I check the log, It say the library was found but could not be loaded.  I dont know how solve my issueCan you help me? Thanksfully 

I have two datasets, one of tabular data and one of geometric data. I merge the two of them using a FeatureMerger (with Feature Merge Type set to "Attributes only").When I try to write the data through a ArcGisOnline Writer, I get the "ArcGIS Online Feature Service Writer: Encountered a feature without a coordinate system. All features being written must have a coordinate system". From the translation log I also get the line   Number of Coordinates: 27 -- Coordinate Dimension: 2   (294813.33947753906,5044870.2619018555)(294822.10748291016,5044891.483886719)(294829.1926879883,5044888.6036987305)(294836.28631591797,5044885.723327637)(294843.37170410156,5044882.853088379)   (294850.4735107422,5044879.972717285)(294857.5504760742,5044877.092529297)(294864.6441040039,5044874.222290039)(294871.72930908203,5044871.341918945)(294878.8065185547,5044868.461730957)   ...Skipping coordinates...   (294891.4180908203,5044838.588684082)(294884.3162841797,5044841.469116211)(294877.22271728516,5044844.

Hi All,I want to create a 2d or 3d buffered zone to signify an exlusion zone form utility services to allow visualize the risks while worling around them. Any help is welcome. Please mind that teh string line is originated by i-molel. Kind Regards

Hello, I have an legacy LRS where the line work is Spatial but the From and To are typed in manually. I wish to correct the FromKM and ToKM with correct Line measurements, and make the field 3 decimal KM. I have built the following workbench:* filter out one Roadname for sample* Extract Geometry* Get the @abs(FromKM - ToKM) * 1000 for meters* Get Geometry length* measure differenceI need to be able to use the Geometry Length to create a new from/to KM

Hello, I have this object (brepsolid). The goal is to create geometry based on its volume. I want this to look like a solid mass based on the boundaries of the cylinder. I have tried SolidBuilder but it just converts the geometry to brepsolid. Is it because I should be using enclosed spaces? I would really appreciate any ideas on handling this. Kind regards, George Floros

On a Mobile Map I have point shapefile presented as markers, but sometimes i have markers overlapping as following screenshot: Does FME capable to solve this problem or what is the alternative solution as following screenshot?  @takashi @david_r @jlutherthomas @egomm @mark2atsafe @jdh 

Hello.We are trying to convert data from Oracle Spatial to ESRI/ SQL Spatial format and not sure about setting the coord system. In Oracle, our coord system is defined by SRID 3776, but the geometry does not have the SRID assigned.FME has 2 coord systems that are very similar (CANA83-3TM114 & 3TM114-83) and, from what I can tell, neither appear to be equated to SRID 3776.When we load data into ESRI using FME, ESRI does not recognize either of those two FME's coord system (shows as 'custom') no matter which one we use and it sets the coord system SRID to 0 (zero). We WANT to set the SRID to 3776, so which coord system should we be using? Or what are we doing wrong?Thanks for any help...

What did you find most difficult and what do you think Safe could do to help users ramp up and realize their goals more quickly?

I have over a thousand raster tiles.I want to create a mosaic of only those tiles that intersect a polygon.I want the full tiles, so using the polygon as a clipper is not the right solution for me.Instead, I want to select only those tiles that intersect the polygon (shapefile) and mosaic them into a single image.

rasterbandseperated images load in with grey palette rather than their single RGB palette. Once i separate using the seperater and QC the images in FME they look fine. Red (0) looks and is displayed as red(8). However when i write out to geotiff and load into any software or even read back into FME the imagery is grey(8). This is the same for all 3 outputs. I hope i'm missing some easy step. All i'm wanting to do is to be able to produce a RGB image and then be able to have the seperate R / G / B images to look at.

Hello.I am trying to automatize, or at least making it simpler, to download multiple INSPIRE GML data from a RSS feed based on location of a defined area (polygon or coordinates) and preferably clipping the data to that same area. Then to top it all of to transform it to DWG/SHP.Datasource is this: http://geodata.nationaalgeoregister.nl/plu/atom/plu.xmlAnyone up to the task of assisting me or giving me tips on creating such an amazing workspace?

I am trying to clean our cadastral polygons, eliminating gaps, overlaps, missing vertices at intersections, etc. I have tried the Snapper, GeometryValidator and AreaGapAndOverlapCleaner transformers but some of the polygons are regenerated with additional vertices due to the adjoining polygons missing vertices at intersections, where I would have expected them to be broken and a vertex added. I need the recommended transformers, with the correct parameters, that can clean up the topology of our cadastral polygons. I also wish to retain the data of all the attribute fields, if rebuilding the polygons is necessary.The attachment shows the topological errors that I am trying to clean.

Does anyone know if there is a way to import h5py into python caller for fme 2018.1?  numpy imports fine but importing h5py produces the following error: Python Exception <ImportError>: cannot import name '_errors' Error executing string `import<space>h5py' Factory proxy not initialized PythonCaller_2(PythonFactory): PythonFactory failed to process feature A fatal error has occurred. Check the logfile above for details Error encountered while calling method `input' PythonCaller(PythonFactory): PythonFactory failed to process feature A fatal error has occurred. Check the logfile above for details Error encountered while calling method `input' PythonCreator(PythonFactory): PythonFactory failed to process feature A fatal error has occurred. Check the logfile above for details  Any and all help is greatly appreciated!

Hello everybody,Im trying to find a way how to extend line to intersection with different line. I know, its a very common issue here - I read about Extender (but it extends whole line - both ends right?), also about anchoredsnapper. But both of them have troubles... And MRF2DExtender is perfect, but paid... Is anybody here, who found reliable solution for that problem please?Thank You so much!Lubo

we have an 8 bit image which has some white areas which we would like to remove. but it would help us a lot if we knew how to make 32bit out of 8bit. Thank you  

Hi there, I have a single band raster DEM. (z-coordinates.) In my workflow i have to use this raster dataset to give overlapping polygons the 3rd Dimension. Following up, each polygon should always get the height of the smallest z-value in one of its vertices(z_min) through the 3DForcer. This is my workflow (one the whole workflow is finished:) The Input dataset are 2D and 3D Polygons. Through the DimensionExtractor I am checking if the polygon already has a third Dimension or not. If not (Failed Output of the TesterTransformer) I have to retrieve the z-coordinate from the DEM. Therefore I imported the DEM. Secondly I set my 0 values (for the area outside of my clipped area) as NoData. (-> RasterBandNoDataSetter) Then i buffered my polygons (to be on the secure side) with 1 meter. Then I clipped my raster dataset with my polygons (to increase the Performance and decrease the amount of data processed.) (-> Clipper) As next step I usded the RasterCellCoercer to create a Polygons ou

HI, my translation is always unsuccessful due to: DBF Writer: DBF file exceeds maximum size of 2 GB. yes, it is so big, but I need to translate it and a few files which are even bigger. Shape into shape.Any ideas? thanks

Hello all,Another newby question, sorry :)I have a table in PostgreSQL which is called ExaminationNumber and has a single column call ExamID.The ExamID field stores a current count of the examinations processed and is increased by one each time.I am have a reader that reads from the table and grabs the current ExamID value. I then want to update the value by one using the SQLExecutor but can't get it to work.  Can anyone let me the correct syntax or if there is a better way to go about this?