Using readers and writers to extract and load data.
Recently active
Hi everybody, I am trying to figure out how to write metadata to ArcGIS Online Feature Service (update existing). I am able to read metadata from SDE using the "geodb_metadata_string" format parameter when setting the feature read mode to "Metadata" on the reader, but not being able to write to ArcGIS Online. Is this even possible? ?Thank you.
I'm doing a fairly straightforward IFC conversion. It runs once correctly and then every time I try it again, it errors out with the below messages. When I create a new writer it works, but also only once. What's up with that?Dataset template source `<Unused>' for writer GEODATABASE_FILE_1 could not be located Dataset template source `<Unused>' for writer GEODATABASE_FILE_1 could not be located f_72(CreationFactory): Dataset template source `<Unused>' for writer GEODATABASE_FILE_1 could not be located Dataset template source `<Unused>' for writer GEODATABASE_FILE_1 could not be located
I create Point Clouds from Drone photography using Pix4D. It outputs both .XYZ and .LAS files. Pix4D also generates contours but I am not satisfied with the output - it's too generalized. I want to create highly detailed contours from the Pix4D point cloud output. I also want to optimize them with the FME Curvefitter transformer and output to an AutoCAD DWG. I have tried several processes using the PointCloudXYZ reader and also the PointCloudCoercer but have not been successful creating an AutoCAD Polyline output that can be Curvefit. Can you give me some pointers?
I have a spreadsheet with two worksheets (sheet1 and sheet2). I have a second spreadsheet which lists all the records that need to be removed from both worksheets, the new edited output will be in sheet1_v2 and sheet2_v2.How would you advise I move forward with this?Many thanks
HiI have a workspace that extrudes texture files (appearance) from my CityGML buildings, puts them together and creates a simple single texture atlas image file to improve performance when viewing the photorealistic model. The source CityGML file is a textured building with multiple texture image files, one image for each surface. The problem is that FME's CityGML writer always writes by default it's "own" appearance module (if the source file had textures) to the output CityGML file and copies the texture coordinates and imageURI parametres from source, which in this case is a CityGML file with a reference to multiple texture files instead of one texture atlas raster image. I only want to modify the existing appearance module, which i managed to do, but the writer still writes out appearance module to the CityGML file. As a result i have a CityGML file with two different appearance module where the other module references to my newly created texture atlas image with
This is just a quick note to inform you that we will be releasing a new search tool for the Knowledge Center in the next 1-2 weeks.Built on the Coveo platform, this tool includes a machine learning component and will auto-tune results and rankings over time to ensure users are receiving the most relevant results based on queries and clicks. We will also be adding more sources in the near future and have plans to roll this out across our other websites in time.A preview is available now at https://search.safe.com/ and we’re looking forward to seeing some real world data in the system. When we officially release, the search will be integrated into the main search field across the Knowledge Center, but for now we’d appreciate it if you could click over and give it a try.
As I have seen in https://knowledge.safe.com/articles/1070/thinning-and-combining-point-clouds.html It is possible to do points cloud thinning in FME. My problem is that I don't want to thin them by any of offered possibilities. In places with similar altitude, I would like to delete more points, and in places with higher elevation differences I would like to keep more points. For beginning I am extracting coordinates but I am not sure how to use that for filtering and thinning the las point cloud. Thank you all in advance for all the help.Dejan
When I attempt a simple conversion of a MrSID file to an ECW via a reader and writer (something I've done successfully many times) I am getting the following results/error: Command-line to run this workspace: C:\\apps\\FME\\fme.exe C:\\Users\\DOUGBL~1\\AppData\\Local\\Temp\\wb-xlate-1519219239276_15664 --SourceDataset_MRSID "C:\\MapData\\Williamson County\\SID\\Williamson_Co_2014.sid" --DestDataset_ECW "C:\\MapData\\Williamson County\\ECW" Starting translation...FME 2016.1.0.0 (20160419 - Build 16492 - WIN32)FME_HOME is 'C:\\apps\\FME\\'FME Professional Edition (node locked-crc)Serial Number: H8U9-DF32-16TZPermanent License.Machine host name is: DESKTOP-5NGB2S9START - ProcessID: 14816, peak process memory usage: 29096 kB, current process memory usage: 29088 kBFME Configuration: Command line arguments are `C:\\apps\\FME\\fme.exe' `C:\\Users\\DOUGBL~1\\AppData\\Local\\Temp\\wb-xlate-1519219239276_15664' `LOG_STANDARDOUT&#
I have an ~80gb file that i need to split into around 15 files geographically into 25x100 strips. https://knowledge.safe.com/articles/1100/tiling-point-cloud-data.html is helpful but FME will still read the whole file in one go. i only have 16-32GB of RAM (depending on computer im using) and so the computer will fall over. how can i split this file geographically and get around FME reading the whole file in one go?
CREATE OR REPLACE TRIGGER invoice_before_delete BEFORE DELETE ON prj_invoice_work_exe FOR EACH ROW DECLARE v_username varchar2(10); BEGIN SELECT user INTO v_username FROM dual; INSERT INTO prj_invoice_work_exe1 ( PIE_PIN_ID,PIE_TDT_ID,PIE_ID,PIE_QTY_EXECUTED,PIE_UNIT_PRICE,PIE_NET_PRICE,PIE_INVOICED_AMOUNT,PIE_UNT_CODE,PIE_HST_UNIT_PRICE, PIE_HST_TOTAL_QTY,PIE_HST_TOTAL_BILLED_QTY,PIE_HST_ALLOW_TO_BILL_QTY,PIE_HST_PRCT_OF_COMPLETION,PIE_HST_QTY_COMPLETED, PIE_PWR_ID,PIE_DISCOUNT,PIE_DOWN_PAYMENT_RECOVERY,PIE_BOQ_DISCOUNT,PIE_BOQ_DOWN_PAYMENT,PIE_UNT_PRICE_BFR_DISCOUNT, PIE_TOTAL_PRICE_BFR_DISCOUNT ) VALUES ( :old.PIE_PIN_ID,old.PIE_TDT_ID,old.PIE_ID,old.PIE_QTY_EXECUTED,old.PIE_UNIT_PRICE,old.PIE_NET_PRICE,old.PIE_INVOICED_AMOUNT,old.PIE_UNT_CODE,old.PIE_HST_UNIT_PRICE, old.PIE_HST_TOTAL_QTY,old.PIE_HST_TOTAL_BILLED_QTY,old.PIE_HST_ALLOW_TO_BILL_QTY,old.PIE_HST_PRCT_OF_COMPLETION,old.PIE_HST_QTY_COMPLETED, old.PIE_PWR_ID,old.PIE_DISCOUNT,old.PIE_DOWN_PAYMENT_
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?