Skip to main content

Data

Using readers and writers to extract and load data.

  • 6,955 Posts
  • 25,596 Replies
6955 Posts
geckosolutions
Contributor
geckosolutionsContributor
asked in Data
FME Ingesting AGOL json

Hi Everyone, I have this “open” dataset provided by the City of Toronto. I am using a few from the city that are provided in this manner. The only way to bring it into ArcPro and then extract it to a geodatabase is to use the json address and add by url, then use the ‘feature to point’ geoprocessing tool to extract the data to points in gdb format, then use as needed. I need to get this layer into FME from the live feed so I can analyze it and then push it out via other format(s), one of which is AGOL feature layer. For some reason I have been unable to bring it into my FME script via any JSON reader or HTTP caller and I’m wondering if anyone else here will have more luck. The link I am working with is as follows: https://gis.toronto.ca/arcgis/rest/services/cot_geospatial2/MapServer/64 The json link is: https://gis.toronto.ca/arcgis/rest/services/cot_geospatial2/MapServer/64?f=pjson If anyone has the steps to bring the content into FME (geometry and attributes) to have it available for

152
geckosolutions
Contributor
B
bramvr
asked in Data
Optimizing i3s (slpk) LOD

I'm converting 3D data from Postgres to an Esri Indexed 3D Scene Layer (slpk). I'm converting this to an i3s service on Azure (not ArcGIS Online). When loading this as an external layer in ArcGIS Online, the LOD seems totally random, buildings are being visualised but not the way I'd like to see (not based on distance). Is there a way of optimizing this in FME?

44315
vince_j
Contributor
jakethepainter
Contributor
jakethepainterContributor
asked in Data
Error reading KML: Could not determine the root kml file of

I'm trying to read some USFS wildland fire data. There's a link to the kml on their website: http://www.wfas.net/google-earth/wfas_nfdr.kmz When I use the url in the kml reader, it downloads it to a temp file location successfully (I can see it there) and it's unzipped. It's got a folder structure about 5 deep. Then I get FATAL |KML: Could not determine the root kml file of `C:\\Users\\xxx\\AppData\\Local\\Temp\\FME_OGCKML_KMZ_1562607566639_14376' If I go to the temp file location and navigate down to the kml, I can read it in no problem. C:\\Users\\xxx\\AppData\\Local\\Temp\\FME_OGCKML_KMZ_1562607566639_14376\\fsfiles\\office\\wfas2\\dir-obs\\wfas_nfdr.kml

287
deanhowell
Influencer
creinier
Contributor
creinierContributor
asked in Data
Data sources in an ArcGIS project (aprx)

I’m working on a data inventory project and need to figure out what data sources are being used in a large number of aprx’s. Is there a way to determine the data sources of an ArcGIS project by directing a workbench to an aprx file path?

233
creinier
Contributor
simeon.simic
Contributor
simeon.simicContributor
asked in Data
Coordinate system

Hi everyone, i have few questions about coordinate systems1. How can i know in which coordinate system is file that i upload2. And how can i reproject that coordinate system into 32634(I have been trying with reprojector but it’s not exactly right when i add project in qgis on my map)3.Which ever coordinate system i tried, it never is 100% match So i need help if someone can tell me what should i do? Thank you in advanced

111
redgeographics
Celebrity
adnanyazdani
Contributor
adnanyazdaniContributor
asked in Data
Field Type - Time only

Hi Experts I would like to suggestion and Guidance Does FME Form has Time as field type I’m using FME 2024 Thanks

306
crutledge
Enthusiast
joy
Enthusiast
joyEnthusiast
asked in Data
Black screen FME Form 2023 and FME Form 2024

Hello everyone, At our organization we work on a virtual machine. When you log on into a virtual machine, you share the virtual machine with other users. Since a few weeks we encounter sometimes black screens when trying to use FME form 2023 or FME form 2024. I googled and the problem is quite similar to Known Issue: FME Workbench 2023 Opens as a Blank Window on a Virtual Machine – FME Support Center, instead it's a black screen. The article mentions about OpenGL versions, however the specs for all our virtual machines should be the same, so I think the cause is different. When you encounter the black screen, you can only hover over the black screen and can't do much else. When you close FME Form and try to open a new FME Form sesssion, you still get a black screen. The only workaround is to log off and log into a new virtual machine where this problem doesn't occur. We already did some troubleshooting and we know one thing for sure It's possible that fme form 2023/2024 initially worke

282
joy
Enthusiast
joy
Enthusiast
joyEnthusiast
asked in Data
[FME Form 2024.2.] Losing Database- and webconnection on new machines

Hello everyone, We just upgraded to FME Form 2024.2.1 and we currently encounter one problem. For the users, the personal database- and web connections were inititally not migrated. Thus we sent first a mail to the users that they coud export the database- and webconnections in FME Form 2023 and then import the exported file in FME Form 2024. It looked like it solved the problem, however when the users logged in the next day on an new machine, they lost all their personal database- and webconnections. We read the following link: Changes to Connection Storage in FME Form 2024 – FME Support Center and it became clear to us that's due to the new way that personal database- and webconnections are stored. They are stored in fme_userconnection.data and the machineID is hardcoded in this file. In our organization we work on a virtual machine and thus also everytime we log into a new machine. It's now clear why the database- and webconnections are not visible in FME Form 2024. I was wondering

1007
joy
Enthusiast
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Data
Accessing Annotation Class Names and Text Symbols from GDB

would like to know if FME can read annotation classes and text symbol information that are defined in the Feature Class properties (e.g., in a File Geodatabase or Enterprise Geodatabase). Specifically: Can FME access Annotation Class Names? Is it possible to read text symbol properties like font, size, color, or placement defined in the annotation feature class?

240
jugoslaviaa
Enthusiast
lorinda
Contributor
lorindaContributor
asked in Data
Using the Metadata Updater for Revision Date

Hi, I’m finding that the date shown for data updates on ArcGIS Online Hub is misleading and not showing the date that we are actually updating the data, has anyone used the Metadata Updater to update any of the dates in metadata? I don’t see it listed in the dropdowns for the updater. Or should I be using the XMLUpdater? Thanks, Lorinda

132
hkingsbury
Celebrity
aashnaparikh
Contributor
aashnaparikhContributor
asked in Data
Duplicate Features Division

Hi, Based on the sample table, I want to implement a logic. Same name, different policy # and same address - Goes to file 2 Same name, different address and different policy number - The first record goes to file 1 and rest of the records go to file 2. All the manual should again go to the file 2. Policy Number New/ Renewal/ Manual Name Address To process Split 123 New John Chris 123 Oxford St Y File 1 110 New Mary Jane 45 Caron ave Y File 1 111 New Mary Jane 360 Caron ave N File 2 112 Renewal Kent Bryan 333 Queen St Y File 1 113 Renewal Kayla Jan 333 Queen St Y File 1 114 Renewal Jung Chen 5 Queen St Y File 1 115 Renewal Jung Chen 5 King St N File 2 116 Manual Ray Ban 5 abc st N File 2 116 Manual Kan Can 6 xyz st N File 2 116 Manual Harry Potter 8 niagara st N File 2 116 Manual Rob Smith 9 India St N File 2 116 Manual Tony Stark 10 peter st N File 2 116 Manual John Snow 11 sandwich st N File 2 2000 New Melanie Joy 275 Rankin Avenue N File 2 2001 New Melanie Joy 275 Rankin Avenue N Fil

594
aashnaparikh
Contributor
crutledge
Enthusiast
crutledgeEnthusiast
asked in Data
fme_geometry undefined when writing to fgdb

I am having trouble writing a few rasters to a raster fgdb. Most are fine but a generate errors of undefined. But previous definition seems fine. bit of a stumper. don’t think it’s a projection issue. Any thoughts? Error on write for 1 or 2 rasters Previous step has all as fme_aggregate and fme_type as raster.

422
crutledge
Enthusiast
dollargis
Contributor
dollargisContributor
asked in Data
FME 2021 Compatibility with Postgres 14

We are using FME 2021 and planning to bump postgres version to 14. Are there known issues with that combination? I have tried to find a compatibility sheet for FME Desktop/Server and Postgres and/or other Software, but did not succeed.

2015
natalieatsafe
Safer
jlw_tyrens
Contributor
jlw_tyrensContributor
asked in Data
STAC Asset Reader

Hi guys! I'm trying to understand how the STAC Asset reader works. In my case, I have a URL to an item, but when I try to access it, it complains that I don't have authentication. When I then check the "Use authentication" box, I only get options related to AWS, and not the service I created. I've used the URL to retrieve data via Radiant Earth Stac browser with my credentials and it works there. Has anyone used this reader to extract data from sources other than the default ones?

774
kailinatsafe
Safer
sunita22
Contributor
sunita22Contributor
asked in Data
data source CSV file each day populated with date stamp, my requirement need to load CSV each day to SQL server

data source CSV file each day populated with date stamp, my requirement need to load CSV each day to SQL server

242
takashi
Supporter
ifawzi
Participant
ifawziParticipant
asked in Data
Reading CSV files with different schemas and writing to SQL server.

Hi, I am new to FME, and I am trying to build an FME workspace that reads multiple .csv files from a folder and write each file to separate table in SQL server. Each CSV file: has different schema should became it is own SQL table Here is what I tried so far: I used Directory and File Pathnames reader I used Feature Reader The <Generic> port of Feature Reader shows no data, I am assuming because the schema of each is different. the <initiator> port give me the correct file name and path.

172
crutledge
Enthusiast
dsign-world
Contributor
dsign-worldContributor
asked in Data
What are valid values for a custom schema's data types in a dynamic wokspace?

The website Dynamic Workflows: Destination Schema is Derived from a Lookup Table > Creating a Table-Based Schema > Geometry Type tells me that valid values for the `geometry_type` column are the values from the `fme_type` format attribute. It provides the full list of values under this link. The link is incorrect. This is the list of FME internal data types. These are NOT valid values from the `fme_type` format attribute and these are NOT values from the `geometry_type` column in the screenshot above in the tutorial. Where is the correct list of values for the `geometry_type` column or the `fme_type` attribute?

351
AliAtSafe
Safer
joku041199
Contributor
joku041199Contributor
asked in Data
Reading an Excel file exposing all available columns automatically (To create Web App)

Hey Everybody, In my work, I generally get the question from clients to build a FME Server Web Application. Often, the question involves a MS Excel file, which needs to be analyses and converted to points/lines/polygons (GIS). Mostly, I use a Creator to kick-off the Workspace and a FeatureReader to load in the Excel. Also, I force the FeatureReader to have one single output port (Generic) and load in the Excel file using a User Parameter when kicking off the Workspace. This means that I need to Expose all attributes individually in the Workspace. However, this limits the flexibility. When I want to create a Web App from the Workspace, the input Excel always needs to have the same columns (so a Template Excel as input). An potential extra column is therefore not exposed an not in the result of the Workspace. However, in some cases, it is for my clients not possible to always use an Excel Template. Or they want to add additional information. My question therefore is, is it possible to dy

395
crutledge
Enthusiast
simeon.simic
Contributor
simeon.simicContributor
asked in Data
dwg coordinate system

I am reading dwg file, but i cant set him the right coordinate systemThe file i am reading is from autocad 2012In autoCad coordinate system is set to EPSG : 31277, i dont have that system in my fme workbench Thank you in advanced

70
simeon.simic
Contributor
fionasin
Contributor
fionasinContributor
asked in Data
Method for forcing decimal points between numeric characters in a string?

I have various values in a 'code' field. A sample would be: A33, B111W, B12, C3V etc, etc. This issue is, there should be decimal points between all numbers, i.e, these should correctly read: A3.3, B1.1.1W, B1.2, C3V. There does not need to be points between the letters. I can string replace “33” with “3.3” and continue to do that for all values if I have to, but I’m hoping that there is a more efficient way of capturing these values and using regex or something to force decimal points between the numerical characters. I’m not well adept at using the stringformatter, but maybe there is something there?

262
fionasin
Contributor
caracadrian
Contributor
caracadrianContributor
asked in Data
Autodesk AutoCAD DWG/DXF repairing polyline on read

I am trying to create a workspace that identifies consecutive duplicate point in DWG polylines. and outputs their coordinates for future review. As per my example, Autodesk AutoCAD DWG/DXF (normal reader or FeatureReader) does some autorepair on the features while reading. The DWG feature has 12 vertex in AutoCAD but only 7 in FME. Please see attached sample feature in dwg format. I want FME to read the same geometrie that AutoCAD gives. Using FME 2024.2.1.0 build 24801

403
caracadrian
Contributor
emerson_styles
Contributor
emerson_stylesContributor
asked in Data
Output excel file hiding column names (row 1)

I am writing data to an excel file but when I open the written file, the first row of the file (that includes the column headings) is hidden and I have to manually expand it to show the headings. Is there a way to fix this in the writer at all?

7569
phoeffler
Contributor
brendanneal
Contributor
brendannealContributor
asked in Data
Snowflake database connection with keypair not recognising schema

Hi, I have and issue trying to connect to snowflake DB using keypair authentication, it is not recognising my schema. I'm using FME(R) 2024.1.2.1 (20240906 - Build 24624 - WIN64). I can connect fine in DBeaver using the keypairs. I'm using the advance JDBC settings to add the parameters in a new snowflake database connection. The error I get is ' C OM.safe.fme.jdbc.TranslationFailureException: java.lang.IllegalStateException: Connection established with no current schema. Make sure that schema 'dbo' specified in connection settings exists and is accessible by the user ‘. I know you need to have the case correct in the parameter I have checked with the DBA and have been told that the schema is definitely lowercase. I can’t show all the jdbc connection string, but this is the schema bit ‘ schema=dbo ’ so it is passing the lowercase parameter. Again, I am using the lowercase in DBeaver and connecting fine. I’ve also tried the scheme DBO, “dbo”, “DBO”. There is another schema in the databa

314
brendanneal
Contributor
bruno
Contributor
brunoContributor
asked in Data
IfcZone writing

Hello to all,3 months ago, kailin told me that the 2024 version did not allow writing zones. I would like to know if it is the case now. If not, what is the planned schedule because for the moment we are blocked for the enrichment of our models Best regards Bruno

222
bruno
Contributor
aawad.93
Contributor
aawad.93
asked in Data
ChangeDetector Still Flagging Geometry Changes Even with Lenient Matching and Vector Tolerance

Hello everyone, I’m working in FME 2023.2 and using the ChangeDetector to compare features coming from PostGIS and ArcGIS Online (AGOL). Visually, the geometries look identical (no edits were actually made), but the ChangeDetector keeps reporting that a large number of features have updated geometry. I’ve already tried: Turning on Lenient Geometry Matching in the ChangeDetector Setting Vector Tolerance to a small value (like 0.0001 - Takes more time) While that helped reduce the count somewhat, I’m still seeing a substantial amount of features flagged as updated when they shouldn’t be. I suspect it might have to do with differences in ring orientation, vertex ordering, or the presence of Z/M values, but I’m not certain how best to address these discrepancies so the ChangeDetector recognizes that there hasn’t really been a change. Any suggestions or advice on how to make the geometry truly match (or be treated as unchanged) would be greatly appreciated. Thanks in advance!

684
crystalatsafe
Safer

Helpful Members This Week

Badge Winners

  • Socializer (Ice Breaker)
    cbrienhas earned the badge Socializer (Ice Breaker)
  • Conversationalist
    cbrienhas earned the badge Conversationalist
  • Welcome Back
    tdunhas earned the badge Welcome Back
  • Socializer (Ice Breaker)
    nateneufeldhas earned the badge Socializer (Ice Breaker)
  • Conversationalist
    nateneufeldhas earned the badge Conversationalist
Show all badges

Popular Tags

Community Stats

31,043
Posts
117,693
Replies
38,824
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.