Using readers and writers to extract and load data.
Recently active
Hello I'm currently working with legal parcels and I Would like to know how I can turn these areas into centered points so I can use them further in different applications. Specifically the neighborfinder to find its location on existing streets.
Hi All, I have a KML data which has many folder . Each folder is having different set of geometry eg route1 ,route 2 with other attributes . also each folder has unique number which i want to link to route information . herewith i have attached the screen shot of the KML highlighting the information which i am trying to fetch . Also attaching the KML file . Things i have tried : i mange to do the geometry extraction with KML description for each route but unable to link the route to the folder number . Any suggestion on this ? Thank you in advance.
Hi everyone, this should be a simple thing to do, but I can't find how (or even it is not possible). Thanks!
I downloaded some soil data from here. Included in the data is an ESRI shapefile and a .style file, which I can open in ArcMap to style my layer. However, I can't figure out how to open this file in FME. There doesn't seem to be the right format in the reader. Since I want to do this multiple times, I want to figure out how to automate the styling progress with FME to let's say create a kml-file with the correct styling in the end. Is there a way to open this file in FME?
While converting a DWG file into shapefile, using FME's workspace transformations, all the metadata of the DWG is lost. Inside the DWG , for each feature, there are a lot of metadata for example –LayerHandleColorTextEtc. It is expected that this information will be persevered and will be available inside the SHP file as attributes. Right now, as default, the attribute table of the SHP file is empty. It's a "stopshow" for us...Help will be greatly appreciated, Michael
I have a .pdf with a list of files/folders that I want to copy from a disc with a heap of folders. I need the folders that match pdf list on the disc extracted out and put into a new folder. What work flow would I use to do this. I am very new to using fme. I have been playing around with file directory reader and the filenamePartExtractor transformer but have not had any luck. All advice welcome, my Internet search hasn't helped me much.
Hi everyone, really need help. I used FME to convert IFC to citygml. I imported a 3D citygml into 3Dcitymodel, and when I try to export it in KML or also in citygml again, it seems to be 2D! Why?
I have a large e57 point cloud and I hope to view it in the Potree viewer.After transforming e57 format into the LAS format, the Potree converters (I tried potree 1.7, 2.0 and entwine) all crashed on the LAS file from FME, without much useful error reported. I was using all default options in FME (one reader to read in e57, on LAS writer to write the file), no parameter adjusted. Entwine reportedMaximal extents: [(-2147483648, -2147483648, -2147483648), (2147483647, 2147483647, 2147483647)]Scaled bounds: [(-2147483648, -2147483648, -2147483648), (-2147483648, -2147483648, -2147483648)]Encountered an error: Bounds are too large for the selected scale(PoTree converter just crashed without output) I'm aware that both Potree and Entwine are single-man open-source projects so this might well be their problem instead of anything to do with FME. However, if anyone has experience in e57->las for large LiDAR clouds; and/or PoTree viewer then please let me know - (I might not been solving
Is there currently any way to get FME to work with ESRI enterprise geodatabase objects that have Arcade expressions? We'd really like to customize our feature popups and Arcade is the only language to code them in in ArcPro. But if we do that, it appears we can no longer use FME to translate data into the features. (We get same message "The item does not have a definition" as we got when we tried to run an FME translation last year after adding an attribute rule to a feature using Arcade in ArcPro.)Here's an example (Note that we added custom popups to FireServiceConnection yesterday.):2019-03-19 09:58:26| 41.9| 0.6|ERROR |An error occurred while attempting to open the table, feature class or relationship class 'sde.FireServiceConnection'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.}I saw an idea https://knowledge.safe.com/content/idea/76658/add-readerwriter-support-fo
Looking to share experiences with AWS Redshift and now with the new spatial support if you have tackled that yet.
Has anyone ever tried to create texture atlases in FME? I'm thinking about trying to try this, however, I don't want to recreate the wheel or start a process which is just not worth it (performance-wise). If anyone has had a go at this I would really appreciate any tips of comments Thanks in advance!
Hey there, I have a few workspaces that make use of the Esri File Geodatabases readers and writers. Processing a huge amount of data comes with some issues. In the past i had noticed a huge slowdown of my performance once i hit the last few transformers in the line. Last week i noticed the log line that comes up during the negative performance switch. The line states: Optimizing Memory Usage (something something)Ram usage stabilizes from ~2,7 GB down to about 2,4GB and does not rise anymore. I have more than 10GB of available space left but it will not use more, probably because its the 32bit version. After that point, i will only be able to process around 5-10 objects a second! This is extremely slow if compared to before that point, which was around the thousands a second or even more. I am looking for a solution to this issue and came up with the following idea:If i export the data from the file geodatabase in FME 32bit to something supported by FME 64bit, do the processing on that
I'm attempting to write to a version in an ArcGIS SDE database with a SQL Server Backend. I have created a version in the database and I want FME to write directly to it. I'm selecting the "Override Version" box. However, when I click the button to load the versions in the writer, I get the following error:The log shows this:Creating reader for format: Esri Geodatabase (ArcSDE Geodb)Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE'FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20190820)Unable to open the Geodatabase reader because the 'DATASET' keyword was not foundA fatal error has occurred. Check the logfile above for detailsThis error only seems to occur for me in 2019.2. I have tried it in 2018.1 and I can successfully read the versions that exist in the database. Is this a bug in 2019.2? What could be causing this error?
I have two featureWriter fed by same feature. I want to write on a PostgreSQL database. I specify one with a schemas (Table Qualifier) and the other not.After that I want to use the result who was write to manage my foreign keys. The summary is the same (2 features written). Is it normal that when I specify a table qualifier, any of my feature can't be used after the FeatureWriter ?
Hi, the doc for Trimble Sketchup says version 2015 or earlier is supported, so 2016 and later are not supported?
Good day I have an image dataset which I would like to do content conversion. As it stands y=-y, x=-x. How do I go about it to make x=x, y=y?It's my first time to use FME. I have tried to locate the scaler function but couldn't find it?
I need to relate text values (annotations) to lines. In the example bellow, there are 3 lines and 2 annotations. The longest line (two segments) should get value "PEd100" and the other one should get PE32. Annotations aren't related to lines by common attribute, just placed near the lines.In this case both geometry and annotations are on the same layer, but it's not always the case. Any ideas?
It appears I now need to add all the _match_id(s) with their correlating unique _line_id by length.. Any tips on how to do this? Thanks in advance, Fred
So, I've read some of the earlier responses to similar questions but I don't know that I gleaned a definitive answer for this.The setup is in Oracle there are ArcGIS generated views of Versioned spatial data tables Eg. TableName_EVW and that View has SHAPE as an ST_Geometry (instead of Oracle's own SDO_Geometry).Yes, I know I can read this with the SDE Reader, but I need to get around SDE at the moment as it is misbehaving in the Covid world of VPNs whereas direct connection via native Oracle works MUCH better.So:All the FME Oracle Readers tried recognise the SHAPE field, but the Reader log tells me that it is skipping over the SHAPE field (presumably because it isn't SDO_Geometry data type)........despite that the log also tells me it recognises the Data Type as ST_Geometry. So the Readers by default return the non-spatial fields, and no geometries because it skips over the SHAPE field.SQLCreator/SQLExecutor methods don't work that well either. Same result even
Using FME version 2019.2.3.1 it appears that if the MITAB writer format is selected within a FeatureWriter that non-standard CRS's default to an arbitrary "LL" CRS based on WGS84.When tested not using the FeatureWriter this doesn't appear to occur. The FeatureWriter does not allow setting of output Coord. System from an attribute therefore I am required to rely on "Same as source". I do have a MITAB workspace resource but again I cannot set the Coord. System as a Parameter and only as an Attribute in my use case.Is this a limitation on the FeatureWriter or on the MITAB writer and MapInfo format itself when it comes to very new Projections?
This some détails.Our Bloc "Orientage Crosse" has an custom orientation (Print Screen 1)Print Screen 1The dwg source has some block "Orientage Crosse" with a rotation and Angle1 (Print Screen 2 to Print Screen 6). In FME with the readers, the name of the block it's not "Orientage Crosse" but a specifi name like *U365, *U400,... (cf Print Screen 7 to Print Screen 10).The oriention and the Angle1 don't have the expected values. If my block hasn't angle1 like in print Screen 1, we don't have the problem. Someone can help me? Print Screen 2 Print Screen 3Print Screen 4Print Screen 5Print Screen 6Print Screen 7Print Screen 8Print Screen 9Print Screen 10
Can gINT (.gpj) files be read into FME? If not, are there workarounds? If not, are there any future plans to add it ?
Since upgrading fme workbench to 2020.0, when I click on a feature writer with an excel format, it takes 30 seconds for the feature writer to open. Making any changes after it opens from there is painfully slow. Windows (windows 10) resource monitor shows fme desktop as being unresponsive for a bit while it's loading. Has anybody else experienced this?
Does anyone know how to create a multi-layer KMZ/KML with a dynamic schema? Whenever I try It seems to only properly create the first layer with the correct schema and layer - everything else just becomes a placemark? I want to use the Schema From Schema Feature option in the output feature type. Has anyone got this working? If I create layers manually then FME will create multiple layers and schema definitions in the output doc.kml. If I use dynamic then I only get the first layer defined. I can merge all feature into a single layer for the file and the result looks great in Google Earth but the issue is there is one Schema in the output doc so when reading in with FME there is only one layer and one mega Schema.
I have some tables in a spatialite database, and I want to truncate the tables.It seems there is no TRUNCATE command in sqlite/spatialite so I've used 'DELETE FROM <my table>' in SQL Exector.I get a rejected feature with the following log message (in red text)."SPATIALITE reader: In ExecuteSQL(): sqlite3_step(DELETE FROM boundaries): SQL logic error or missing databaseSPATIALITE reader: Unable to execute SQL statement 'DELETE FROM boundaries'SPATIALITE reader: Unable to read feature type '__fme_execute_sql_results__'A fatal error has occurred. Check the logfile above for details."I can execute the same command using SQLExecutor on an Oracle database, so the issue seems to be with the spatiaLite reader/writer format.I've also tried 'DROP TABLE <my table>', but it returns the same rejection message.Reading some documentation online, it seems you cannot delete on views in sqlite/spatialite, but I'm trying to access a tabl