Data

I'm trying convert Census block shapefiles (see link: https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2017&layergroup;=Blocks+%282010%29) into KMLs that can be opened easily in GE. The Census Bureau has readily available state-by-state KMLs for tracts and block groups, but for blocks (the smallest unit), they only offer downloads in the form of very, very large shapefiles. Any suggestions?

After reading the metadata from SDE, the geodb_metadata_string has been updated along with a new geodb_type attribute set to geodb_metadata. How to configure the FeatureWriter or ArcSDE writer to accept metadata changes.

How can I expose the "table name" parameter in the dialog box of the Oracle reader as an attribute I can use in a writer (to force it lowercase)?

I would like to try translating an ArcGIS layer file generated in ArcGIS 10.5 (32bit version) into MapInfo format using FME 64bit version however, the option is greyed out and the only reason I can relate this to is that the ArcGIS I am running is 32bit? Is there a way around this or should I try downloaded the FME 64bit version. I currently only have a trial license because I want to work out if this works before we buy a license. Regards Sandi

Hello,Is there a way to convert LiDAR Cloud Point (.las) to DEM Raster With Spectrum Colors Based On Elevation Values?I see the following post (https://knowledge.safe.com/articles/1345/creating-a-raster-from-a-point-cloud.html), but just hope the expert may show me how to colorize the raster image with Spectrum Color like following image:Thanks a lot,Reno

I need to create a single shapefile file involving the 3 polygons like the one in the image below, how can I do it? 

Hi All,I have a customer who has enquired if FME Server can be used to validate document templates within SharePoint and be alerted when a new document is uploaded. I don't have the customers full list of requirement but in advance of the meeting I was wondering has anyone done anything like this before in SharePoint?

I have created a workbench that includes a DatabaseJoiner transformer that I want to pass a specific file too that will change each day (basically the file has the days date as its filename). However if I do this, I then cannot join on a field as the transformer reads the Dataset as a text string.I did try an alternative to this using FeatureReaders (excel and generic) and passing them the dataset, however that has its own problems identifying the data fields.What might be the best way to avoid these issues?

Hello everyoneIs it possible to get FME to check the last refresh date of a materialized view in Oracle, so we could then get it to send out notification if any haven't been refreshed in a certain period?

Hi everyone,Does anyone know how to convert DEM/DTM gray8 tif to rgb32 tif with the desired elevation color scheme by using FME Desktop?Gray8RGB32I know a lot of online GIS software may do it on the fly...but I am using MapGuide which seems allowing me to change the color scheme of my gray8 dem tif.Thanks a lot,Reno

Version 2018 of FME supports LAZ 1.1, 1.2, 1.3 but not LAZ 1.4 that was released on https://laszip.org/

I would like to change the name of my data download zip (FME_xxxxxxx.zip) to something else. Is it possible to change this on the FME cloud instance?So how or where can i edit the file layout configuration file that can manage [AUTO_FILE_PREFIX <file_prefix> \\]?If searched for it but could only find solution that needed the terminal on a FME Server that was not FME Cloud.FME Engines  Filename: fmeEngineConfig.txt  Location: <FMEServerDir>\\Server\\  Purpose: Configure the FME Engines, including subsections, pre and post commands, and success and failure responses. For details, see Configuration File Layout.Info i foundhttps://knowledge.safe.com/questions/3809/zip-file-name-fmeserver-download.html http://docs.safe.com/fme/2018.1/html/FME_Server_Documentation/Content/ReferenceManual/config_file_layout.htm http://docs.safe.com/fme/2018.1/html/FME_Server_Documentation/Content/ReferenceManual/fme_server_config_files.htm https://knowledge.safe.com/questions/31991/create-a-custom

A JSON file stored PNG images in byte[] text format. How do I convert them into PNG?

I have created a prototype workspace to create a 3D minecraft world by combining the 2D surface feature data from an orienteering map and a Lidar point cloud for the topography.Here is what the source map looks like And here is the resultant minecraft world -This workspace generated a Minecraft map of our local intermediate school which I have just created an orienteering map for. I have tried the workspace out on other urban orienteering maps (including one with lakes and tramways) and it worked pretty well, but it probably needs a bit more work for forest Orienteering maps.There is still work to do on this template. I would welcome comments and contributions on how to improve it. All features are not yet modelled. More clipping needs to be done for overlapping features. Z data needs to be built into railways. But I'd call it a good start (from a GIS beginner), and it potentially opens up a world of "virtual orienteering"!I have uploaded an example template here --> h

We have SDE connected with an Oracle backend databaseThe proposal is to use FME Oracle Non-spatial reader, FME for update required tabular data and FME to write the record with updated tabular via FME Oracle Non-spatial writer. Geometry will never change just updating tabular dataYes, I could use FME SDE Reader but when I looking a 400,000 spatial with tabular records, it's slowQUESTION, will this damage the spatial record?

Hello,I need to read 124 SDE GDSs to access and report a table that is common to all of them 'Tracts'.I tried the information in the following URL, but it is not working: https://knowledge.safe.com/articles/20203/how-to-read-all-feature-classes-from-multiple-esri.htmlAny help would be appreciated.Brian

Hello: I have multiple csv files that have the same number of attributes but some of the attributes have different spellings for the same attributes. Instead of adding multiple csv readers and eventually loading them into one (1) table in Oracle after some subsequent transformations, is there a way to bring the multiple files together and give the attributes the same name for the like fields?Below is a sample of what the file(s) would look like:

Hi there,I've taken some tips form this thread on how to generate a PNG from my WMS layer:https://knowledge.safe.com/questions/69989/requesting-wmswfs-and-saving-as-image-in-a-file.htmlIt works pretty good but it generates a PNG containing my entire WMS layer, where I just need a specific area based on a polygon I have. I've tried using the clipper but then the PNG writer generates no output (I'm guessing the clipper is only vector based) and I'm not sure what other transformers I can use to clip my WMS data. Rasters in general is a pretty new area for me in FME.Any advice will be greatly appreciated!

Using FME Desktop 2017.1.0.0 (20170731 - Build 17539 - WIN64) reading an Excel xlsx file on Windows fails and returns the following error:...|ERROR |Excel Reader: Could not open file '...\input.xlsx', file is too large. Try switching to 64-bit FME, or exporting the Excel file to CSV. If the file is exported to CSV, formulas and formatting will be lost...The file is 47KB, has 2 sheets with a couple of rows and columns. The data is imported with a Query from 2 csv files, what might cause the problem.Converting to CSV is not an option as this is part of an repetitive automatized process.Copy pasting the data to a new excel document / saving the file as xls solved the problem. But I would like to keep the source data original as I want to integrate this in FME server / external application.I did discuss this issue earlier with @Mark2AtSafe on StackExchange when the forum was down, but wanted to register the topic at the right place. 

I am trying to convert MS SQL server database to Oracle and all of the table and columns are lowercase and being converted with double quotes around them. Is there a way in FME to prevent this?

hello thereat the end of a transformation process, we have an attribute name msg_ar we want to write as text into a PDF file , I used the PDF formatter and the PDF styler but no success Please any idea Thanks

I tried Safe suggestions to set both Workbench and its tool > FME option to the ArcGIS Pro python version but still get the following python error message. Please help. Thanks.Loaded module 'GeometryValidationFactory' from file 'E:\\Program Files\\FME\\plugins/GeometryValidationFactory.dll'FME API version of module 'GeometryValidationFactory' matches current internal version (3.8 20180209)Loaded module 'PythonFactory' from file 'E:\\Program Files\\FME\\plugins/PythonFactory.dll'FME API version of module 'PythonFactory' matches current internal version (3.8 20180209)The ArcGIS Python 3.6 interpreter could not be found. Please ensure the proper ArcGIS is installed with an architecture matching FME's(PythonFactory): A Python installation could not be detected. PythonFactory could not initializeA Python installation could not be detected. PythonFactory could not initializeClosing the Geodatabase readerA fatal error has occurred. Chec

How can I define a simple Oracle spacial reader and writer containing some Oracle SDO_GEOMETRY fields. The fields are not shown among the other attributes. I just want to copy them, no conversion etc.

My workspace contains 3 writers and they are all included in the "Include Writers in Download" option when publishing my workspace to FME Server. I expect all the files written by the 3 writers to be included by the file written by the FILECOPY Writer isn't. What is happening?

I am using FME 2017 and would like to carry out a relatively simple geoprocessing task. I have DEM TIF tiles and DOM TIF tiles in 2 different directories which both have the same names and the same extents. I would like to subtract the DEM from the DOM for each tile and save the new tile in a 3rd directory named "NORMALIZED".So my process is simply the following:1. Iterate through Directory "DOM" and for each filename find and subtract the same file in directory "DEM". 2. Save the result in Directory "NORMALIZED" How would I achieve this?