Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,682 Posts
  • 50,735 Replies
12682 Posts
F
frank_herbert
asked in Transformers
WHERE clause - exclude null values

Please can someone tell me how to write a WHERE clause in the feature reader that excludes records that do not contain a value.I have thousands of records and some of them have a Global ID - I want to keep these records.I also have records that contain NULL or no value - I want to exclude these values.I can perform this function in a Tester, but a colleague informed me having this clause built in to the feature reader instead will be much quicker. Perhaps someone can confirm this.Thanks, Frank

2172
F
2 years ago
T
timdecraeckerav
asked in Transformers
Texturing a citygml file using a mosaic image with appearance setter.

Hi everyone, I need to retexture a citygml file using one (mosaic)image file. But I am facing an issue in the last steps using the Appearance Setter. I started with the WallSurfaces and managed to calculate the (row,column) coordinates of each wall-vertex on the new single image (derived from the previous textured model that used multiple images for one building in the appearance folder). The position of a (sample) wall3D projected on the mosaic-image looks correct, attached a screenshot from QGIS. I rescaled the row column coordinates to a 0,1 scale, with (0,0) representing the lower left corner of the image, and stored them as list-attributes for each wallsurface. I used these lists to set the u,v texture coordinates with the measuresetter transformer as explained in this useful post on texturing citygml :https://community.safe.com/s/question/0D54Q000080heXzSAI/3dcitydb-texture-coordinates Afterwards I used the appearance setter, connecting the imagemosaic to the appearance input, th

1281
T
2 years ago
joe.fme
Contributor
joe.fmeContributor
asked in Transformers
How to convert a point to polygon

Hi all, I have a couple of point features which are feeding through with polygons (as the points should join to polygons, bar these 2). I've tried the GeometryCoercer and CenterPointReplacer etc but no luck. Is there something I'm missing which could create even a small polygon from a point?

1857
joe.fme
Contributor
2 years ago
M
manca_ent
asked in Transformers
Is it possible to dynamically create an output port for each attribute value in my dataset?

My dataset contains multiple points within different towns. For example, town A will have 30 datapoints and town B has 35. Can I automatically create output ports to group the relevant datapoints by each town without having to filter them all manually?

193
hkingsbury
Celebrity
2 years ago
B
byroncinnz
asked in Transformers
I am attempting to load a GML file into PostGIS via FME and get the following error: Bulk copy failed on table 'public.physical_oceanographic_map' using delimiter ':'. Error was 'ERROR: extra data after last expected column

Sample data from the gml file:` <gml:featureMember>   <nzodn:physical_oceanographic_map fid="physical_oceanographic_map.fid-4332c03c_1829f0e6782_-2349">    <nzodn:stationName>U3693</nzodn:stationName>    <nzodn:url>https://nzodn.nz/data/physical_oceanographic/sage/SAGE_CTD_data_U3693.txt</nzodn:url>    <nzodn:time_coverage_start>2004-04-07T10:50:00</nzodn:time_coverage_start>    <nzodn:time_coverage_end>2004-04-07T10:50:00</nzodn:time_coverage_end>    <nzodn:hasTemperature>true</nzodn:hasTemperature>    <nzodn:hasSalinity>true</nzodn:hasSalinity>    <nzodn:hasChlorophyllFluorescence>false</nzodn:hasChlorophyllFluorescence>    <nzodn:hasTransmissionOfLight>false</nzodn:hasTransmissionOfLight>    <nzodn:hasFluorescence>false</nzodn:hasFluorescence>    <nzodn:hasPressure>true</nzodn:hasPressure>    <nzodn:hasDissolvedOxygen>true</nzodn:hasD

171
JennaKAtSafe
Safer
2 years ago
K
kiahwarren
asked in Transformers
Does FME use AutoCAD Text Style Properties from a template file and how to set the Annotative property

I have a workspace that converts a DWG file to a new DWG utilizing a template file. However, I am unclear on how the text styles saved in the template file interact with multi text features written to the output DWG. I understand that the template file will overwrite any styling you set in the workspace for lines, polygons, and blocks. Does this also apply to text? Here are the details, In my workspace I set the text style with the property autocad_shape_name to a corresponding style in the autocad template file. Also, the multi text features are put on a layer that exists in the template file. I have been trying to modify two attributes in the text features that are found in autocad (Annotative, and Defined Width), see the image below showing these properties highlighted in AutoCAD. However, I can't seem to set these attributes at all. Theoretically, if fme utilizes text styles from a template file, the "Annotative" property should be set correctly in the ouput (it's

1169
garyb
Contributor
2 years ago
V
vcarr2005
asked in Transformers
Iterate through a table based on a list of values

I would like to iterate through a table based on a list of values. This is the process I would like to automate:Filter the table on a value then add an attribute and BulkAttributeRenamer. I have 20 values so I'd like to be able loop through the table for each value rather than have a set of transformers for every value.

824
V
2 years ago
T
tom_james
asked in Transformers
Photogrammetry model - FBX/OBJ - to Cesium 3D Tiles

Hi, I'm looking at using FME server to create our Cesium3DTilesets, rather than using the native Cesium ION on-premise tiler which we're using at the moment, so we can streamline some of our processes along with a bit of exploration. Say I have 4 OBJ photogrammetry models originally created using ContextCapture. Each OBJ file represents a building:Building1.objBuilding2.objBuilding3.objBuilding4.obj I want to create one Cesium 3D Tileset from these building objs. I also would like to add some metadata to the generated tileset.json/b3dm files to specify which .obj they were originally referenced to, e.g. the tiles batch Id could be set as the name of the original obj for example. The reason for this is to be able to distinguish which building is which when streaming the model in an application such as CesiumJS. It needs to be one tileset that is generated rather than one per obj, as one tileset is much more performant than streaming data for each separate tileset. On a small sca

1110
T
2 years ago
sigtill
Contributor
sigtillContributor
asked in Transformers
Create 3DSolid from tunnel Surface

Similar to method here: https://forums.autodesk.com/t5/civil-3d-forum/how-to-create-surface-or-solid-to-model-existing-tunnel/td-p/8551041 I have as input a underground tunnel in MESH (pointcloud also available). I want to convert this MESH to 3DSOLID DWG. One idea was to take every single polygon of the Mesh and use the Extrude in the right direction, or the 3DBufferer (takes too long) to create a solid object before writing to DWG with RealDWG-writer. However this does not seem to be very pretty or fast on large sections. Is there a better approach to generate a solid object from a tunnel with FME?

252
sigtill
Contributor
2 years ago
Z
zacharylee1204
asked in Transformers
Reproject from EPSG 2326 to EPSG 3857

Dear Sir/ Madam, So I would like to reproject my CityGML model (ground surface) from EPSG 2326 to EPSG 3857. However, I notice that the area is changed, even though they are both in meters.May I ask if is it normal? Is there any reason behind this? Thank you very much. With regards,Zach

173
Z
2 years ago
S
shweta
asked in Transformers
How to make a texture or an image as an appearance on 3d Walls or floors for KML writer files ???

I tried using Appearance setter for KMLwriter but didnt able to get the result. Appearance setter worked for CityGML output but not for KML output.

93
evieatsafe
Safer
2 years ago
A
adbot
asked in Transformers
Split road network with other road network (Attribute networks)

Hi, I have a (complete) road network containing all the "real" roads segments of the road network. I then have several "copies" of the road network but with different segments, these segments define attribute properties for the road segments. I want to split the "real" segments by multiple attribute segments.e.g.: Road 1 --------------------------------------------  5m                      10m  ---------|-----------------------------------  70km/h                 50km/h        70km/h --------------------|-------------|----------Desired output:5m           10m          10m          10m --------|-----------|-------------|---------- 70km        70km        50km/h       70km/h  Does anyone have a good solution for performing this in FME? 

82
A
2 years ago
M
mvmunicipia
asked in Transformers
How to solve "Invalid longitude value given for projection origin"?

I'm using a coordinate system that is not in FME’s Coordinate System Gallery. I added a custom coordinate system by creating a new .fme file and using the online tool. When I use it in my FME model it give me the message: "Invalid longitude value given for projection origin".My .fme file has this information:COORDINATE_SYSTEM_DEF PTRA08-UTM/ITRF93 \\  DESC_NM "PTRA08 / UTM zone 26N EPSG:5015" \\  GROUP EUROPE \\ EL_NAME GRS1980 \\  ORG_LAT 0 \\  PARM1 -27.0 \\  PROJ UTM \\  QUAD 1 \\  SCL_RED 0.9996000000 \\  SOURCE "https://www.dgterritorio.gov.pt/geodesia/sistemas-referencia/regioes-autonomas/PTRA08-UTM-ITRF93" \\  UNIT METER \\  X_OFF 500000 \\  Y_OFF 0 I think the error is in PARM1, but I think it's ok... -27

347
geomancer
Evangelist
2 years ago
D
david_farmer
asked in Transformers
DGN Styler - RGB not working?

Hi,I'm using the DGN styler to plot my data using RGB colours that I've pulled out of an mxd, I've set this to the FME colours and also tried RGB colours (multiplied the parts of the fme colour x 255) but neither seem to work. The data inspector does show the colours correctly.As a workaround I assigned my different coloured polygons to different CAD levels then set them the elements colour to 'by level' and importing a csv of by level colours. The problem is I now need to set all my elements on a single level so can only have a single colour.I've had success by assigning a colour index in the past but need to assign RGB in this instance.Any help would be much appreciated.

287
JennaKAtSafe
Safer
2 years ago
V
vijai
asked in Transformers
How can i draw the lines(desire interval) perpendicular to the longest side of the polygon?

I managed to create centerline (blue line) using suggestions by "@takashi" thanks for that., I would like to create additional lines (black line) inside the polygon, lines should be equally disturbed.  

335
evieatsafe
Safer
2 years ago
od10
Contributor
od10Contributor
asked in Transformers
Writing attributes into specfic cells in an Excel template

Hello, I have a lot of attributes that need to be input into specfic cells in an excel template. Some of these cells are merged and some are not. How would i write each individual attribute into seperate cells based on the template? Many thanks,@Takashi Iijima​ @Mark Stoakes​ @nielsgerrits​  @ebygomm​  @jkr_da​ @mark2atsafe​ @jdh​ 

123
jkr_wrk
Influencer
2 years ago
A
anhstar
asked in Transformers
Extract domain value from GDB file?

Hello everyone,I'm looking for an easy way to extract domain value from a gdb for validation.I know that you can use ArcGIS Pro to export a XML schema from a GDB, but I want to skip that step. I tried to use Schema Reader, but it doesn't give me the full domain values in the attributs.Anyone have an idea ? Thanks

41410
A
2 years ago
A
albus68
asked in Transformers
How to transfer the attributes? Why some attributes were not tranferred?

I've an ArcGIS geodatabase feature class with some attributes. I do some attribute mapping and export data in a new geodatabase feature class.Everything works fine but some of the original attributes are not transferred in the output data. I don't know why......I've used the Attribute Manager to remove and rename some attributes, then I've used the Attribute Creator and the Attribute Keeper, the last step is with a final Schema Mapper and finally the new feature class: but there are some attributes (not interested by any transformation during the process) that are missing (the fields in yellow).Any idea? Thank you  

361
redgeographics
Celebrity
2 years ago
Y
yasminvb
asked in Transformers
How to select bands in a CSAR raster file ?

The obvious transformers (Rasterselector, RasterBandRemover, RasterBandKeeper) do not give the desired output. No errors are generated but all bands of the CSAR raster file are still present after processing. The bands seem to be hidden but I can not find a way to make them available for processing.

82
Y
2 years ago
G
geo91
asked in Transformers
Light source vector definition within the SurfaceFootprointReplacer transformer

I've been trying to work out how the light source definition is actually used within the SurfaceFootprointReplacer (with shadow mode set to perpendicular) transformer without luck. My end goal would be to extract an estimated surface of a 3D shape for a hydraulic radius calculation. If I know the shape's rotation from the horizontal axis, how does this get defined by the vector parameters?Defining a point along the face didn't appear to be the right answer, nor was offsetting a point... A simplified workflow showing a cube rotated 45° is attached to illustrate the issue.

141
nampreetatsafe
Safer
2 years ago
esaka
Participant
esakaParticipant
asked in Transformers
split line at point , whic transformer is equle to ArcGIS "split line at point"

1534
evieatsafe
Safer
2 years ago
J
jamiemcc
asked in Transformers
Find rectangle in XY-MT Point cloud

Hi there, Thanks in advance for any help. I have a point cloud that is in XY-MT format. My goal is to figure out where the openings are on a 'flat surface'. I have taken the point cloud and filtered it so only the data I care about is being used (PointCloudFilter). I am now left with a point cloud that clearly shows my openings. I am looking to show the XY coordinates of the 7 openings shown on the attachment. I have tried a few of the transformations, but I am not having much luck.   Can someone point me in a direction where I may find the positions of these openings?

82
evieatsafe
Safer
2 years ago
tifffinke
tifffinke
asked in Transformers
I just upgraded to ArcGIS Pro 3.0 and upgraded Data Interoperability as well and now my existing Spatial ETL tools fail.

I just upgraded to ArcGIS Pro 3.0 and upgraded Data Interoperability (FME(R) 2022.0.0.2 (20220518 - Build 22343 - WIN64) . I have several tools built in the previous version that are now failing. The only error message I get is literally: "Error running translation". That's it. Not very helpful. Has anyone else experienced this with the Pro upgrade to 3.0?

2155
tifffinke
2 years ago
ares
Contributor
aresContributor
asked in Transformers
Combining 2 datasets with points with linebuilder with a line for each point

I have two datasets with polygons that I would like to connect with the linebuilder in order to show the distances. One with adresses, the other with corresponding numbered objects.  For each object for each adress there should be a line (or a point when these are identical) For this I would like to use a centerpointreplacer for both followed by a linebuilder (and lengthcalculator). However the linebuilder generates polygons when there are multiple objects with one adress that have the same xy as the adresses and one or more objects that have a different xy.  I tried using a sorter with both datasets (the adresses on adress, the objects on adress and number). The sorter for the objects has a group by on the adresses. However:Grouping the objects in the linebuilder by adress I get polygons. Grouping in the linebuilder by adress and number generates points only. Any thoughts?

242
ares
Contributor
2 years ago
lance
Contributor
lanceContributor
asked in Transformers
Creating a new feature class in a GEODATABASE from an ARCGISFEATURES source fails.

I am using FME Workbench 2022.1 along with ArcGIS Pro 3.0. I recently noted an issue when copying data from an AGOL MapService to a local GDB - if the feature class does not exist in the GDB, the Workbench will fail, only reporting "Error running the translation" and no further details in the log file. However, if I create a feature class in the GDB, even without any attributes, and change the writer to "Drop and Create" from "Create If Needed," the Workbench runs. Any Ideas?  Log File attached 

1032
lance
Contributor
2 years ago

Badge winners

  • FME Form Basic Training
    eskelinensarahas earned the badge FME Form Basic Training
  • Welcome Back
    rwnewcshas earned the badge Welcome Back
  • FME Form Basic Training
    rwnewcshas earned the badge FME Form Basic Training
  • Teacher (Grey)
    jkenneyhas earned the badge Teacher (Grey)
  • Welcome Back
    jkenneyhas earned the badge Welcome Back
Show all badges
30,162
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.