Data

Hi All, I have 3D building model in *.shp format with LOD2. I have to apply the textures and covert that model into citygml format with attribute information. Please if any have the template share with me as well idea or suggestions also......

Hi,What is the simplest way of to create an ongoing process that will import all "recently modified" records. "recent" means all rows in source where modified date > latest "Modified date" in destination.I have millions of rows in about 10 tables.Each row has a unique ID which can be used to overwrite the destination.I am planning to copy all fields and all rows (replica).Source database: MS SQL 2008B, Destination database: MongoDB.Thank you,

Hello,I implemented a changed detection on oracle table.Now I would like to be able to create a json for each change per object. For instance, for an object where changes were detected on 5 attributs, below will be the json that I would like to obtain:{ "ATTRIBUT1": { "OLD_VALUE": "OLD1", "NEW_VALUE": "NEW1" }, "ATTRIBUT2": { "OLD_VALUE": "OLD2", "NEW_VALUE": "NEW2" }, "ATTRIBUT3": { "OLD_VALUE": "OLD3", "NEW_VALUE": "NEW3" }, "ATTRIBUT4": { "OLD_VALUE": "OLD4", "NEW_VALUE": "NEW4" }, "ATTRIBUT5": { "OLD_VALUE": "OLD5", "NEW_VALUE": "NEW5" }}How can I proceed to obtain this in fme?I was tinking of the agregator to group all the changes from the same object (based on an objectid) and then build the json but I don't know how to proceed.Please keep in mind that the number  and names of attributes will change from one object to another one.Thanks,

i have to convert CityGML to IFC ! an i get no gemetry at the end ! Why ?

Dear FME-users,  I’m creating feature classes (polygons) from NetCDF-data. Among other things I use the transformer “RasterCellCoercer”, the transformation needs so much time.  I’ve 504 input and 504 output files. The geometry is always the same, just the values of the input data are different.  Do you’ve an idea how to reduce the processing time? Maybe a predefined grid?  Thank you so much and best regards.  Konrad

I have an issue currently with lidar data and a project to calculate flood areas. The Lidar data which we have received contains reflections on the water surface (specular reflections) which cause the water surface to have elevations where there are nearby trees and vegetation. In order to create a flood senario, we will therefore not be able to use the water surfaces in the lidar data. How then will we be able to create flooding estimates in the water surface height is not reliable?

i want to import and export IFC and CItygml Data via Data interoperabilty in arcscene but i get always an ERROR, EMPTY GEOMETRY

I have to determine the direction of a closed curve (a line where start and endpoint are the same) because I want to derive a gpx in the right direction (clockwise) from the polyline. Is there a way to do this? So I want to test if the polyline has a clockwise direction and, if not, reverse the direction. I tried the Polylineanalyzer and the azimuthcalculator, but both don't give me a solution.

Hi,  I am passing records from Postgis to Smallwrold. But when it takes half an hour working template I get this error.Know the cause?   How long should the Smallworld server offline the workbench  to make it happen?  Thank You

Hi,I have insert polygons into a Sql Server server table, and for some reason polygons are converted to geometry collections polygon and or curved polygons circularstringFor this reason Geoserver and or ArcMap does not work, because it cannot view these geometry typesI have tried all the coercer and filter but cannot seem to make it an polygon and or mutli polygonrunning on SQL Server 2014, worked perfectly on 2008R2How can i force it to these 2 logical types?Rudy

Hi i want to Export LandXML Surface with boundary to PDF3D or DEM or 3DS I TRY to use a DGN for the boundary but the clipper don't look to work  Is it possible to use the Boundary inside CIVIL 3D LANDXML ? 

Hello everyone,Currently I am working on making a translation from CityGML to CAD and back. However, on the way back the attributes change drastically from the original.Original<imgeo:bronhouder>source</imgeo:bronhouder><imgeo:inOnderzoek>false</imgeo:inOnderzoek>Translated<gen:stringAttribute name="bronhouder"><gen:value>source</gen:value></gen:stringAttribute><gen:stringAttribute name="inOnderzoek"><gen:value>false</gen:value></gen:stringAttribute>Both the prefixes and the structure changes and I want them to be as similar as possible. Is there a way to do this? Enclosed you can find the fmw I use.

Hello FME users, I've added a new SDE connection in my Database Connections but my connection file path inside the Esri Geodatabase (ArcSDE Geodb) Reader parameters is still showing my old connection file. I've already deleted it from my ArcCatalog folder. I'm having to click on the (...) button and select the new connection file. Anyone else have this issue, and any thoughts on how to get the new file path to show up?Thanks in advance. 

I want to convert citygml lod2 or 3 to ifc but it doesnt go i found no geometry , how can i do it please and why i get no geometry at the end ?

I'm am already way over my head on this on this one. I'm trying to create several hundred kml files each one showing a specific area and slowly orbiting abound that area to show a 360 view. I have created a sample kml in google earth. Please see the attached kml. I have also attached a copy saved as .txt so you can see the xml code the kml created. Is it possible to create similar kml files in FME. I have played around with the KMLTourBuilder and the KMLViewSetter but was unable to replicate. I'm not a programmer and can't wirte xml on my own but would like to somewhat automate the process so I don't have to create each one in the Google Earth UX. Any suggestions would be very appreciated. THANK YOU THANK YOU

I have a job that is reading from a file GDB and writing to an ArcSDE SQLServer versioned GDB.I believe I have configured the writer correctly, as the log has messages confirming that I am connecting to the correct transactional version.Connection made to server 'scggisdb1pw' for dataset 'SQLHydro' (transactional version '"BCC\\DJACQUES".DJacques_20170417') using Operating System's current user ArcSDE release: '10.0'. Underlying database: 'SQL Server'However I am getting the following error : Geodatabase Writer: Creating feature dataset 'ModelData' Geodatabase Writer: Creating feature class `ICPR_NODE' in feature dataset 'SQLHydro."BCC\\DJACQUES".ModelData' An error occurred while attempting to create the feature class 'ICPR_NODE'.  The error number from ArcObjects is: '-2147155515'. The error message from ArcObjects is: {Database user name and current user schema do not match. [SQLHydro

I'm trying to add a custom icon using the KMLStyler. The icon is saved on google drive. I used Attribute Manager to add a new attrubute called "Symbol_Icon" thats value is the google drive url link, then I used the KMLStyler to set the icon name to the newly created attribute. I'm getting the "red x" once I open the kml in google earth. Screenshots below, any suggestions?

Hi,I'am creating a workbench which uses a MSSQL database writer to delete certain records from a database. In most cases this works fine but sometimes I get the following error/Warning message:MS SQL Server Writer: Failed to write a feature of type <name of the table> to the database. Provider error `(-2147217871) Query timeout expired'. SQL Command `DELETE FROM <name of the table> WHERE <field within the table> = 6339404'Every time this error occurs there are exactly 50 seconds between opening and closing the database connection. In case the workbench runs without error the connections lasts shorter and is executed without any problem. The following changes did not solve the problem: - Change Command Timeout from 30s to 600s and even to 9000s (when executed directly in SQL server management studio the query takes about 1 minutes and 30 seconds to execute, so 600s should be more than enough). - Checked the time out settings of SQL server. They are set at d

Hi,I am new with FME. I have 3d lidar point data for a single house. Now, I would like to create 3d surface out of it. Would you please give me some advise?

Hi all I want to Check the presence of one or more layers (which I already know the names) and in each of the layers verifies the existence of one or more attributes (already known) when reading the data source.Thank for advance

This is somewhat related to another question of mine. I am using FME 2013 and connecting to Smallworld 4.3 via SpatialBiz' SBS plugin.I have had trouble getting the syntax straight to extract all elements from gt_pipe_segment that match a certain 'where'-clause (using FeatureReader). At some point then I decided to look at the results without any clause in place, and got the following results:FME returned me about 28.000 entries, while gt_pipe_segment.size is about 92.000.This problem seems to get bigger the bigger a table is. But already for a table of size roughly 1500 I had a deviation of six.Again, there was no clause in place, neither spatial nor on the attribute.Is this a known bug? Can someone confirm this? Could this be fixed in a newer version of FME/SpatialBiz? I have found another bug report on FeatureReader.  

Hi,Below screenshot show the SDE reader added and 45 features are read...But it is showing error between after the message of "translation was successful" and about to end.It is happening when "Read version differences" is set to "No".If I place "Read version differences" is set to "Yes" then reader is reading the "0 features".So I'm able to understand which setting I was left over. Could anyone kindly help me in this regard...

How to convert Revit file to 3D Max file?

I have Roofs and walls i dwg. But the walls goes 2m to deep in to ground.Is there any way I can cut the walls with a DTM-raster or TINsurface, or maybe extract new walls from roof to ground.I would also like to have every building as a solid. The floor dose not have to follow the ground. The floor could be level to the buildings lowest point at ground.Any ideas?

I am having trouble getting the syntax right for the FeatureReader using Smallworld.A small example: I would like to read all pipe segments that have certain status and a certain material (which could have been taken from an XML file, for example - here, for simplicity, I created the attributes with an AttributeCreator).I have tried every variation with and without quotiation marks, but cannot get it to run. I am using FME 2013 (upgrading is not an option, as it's not in my power) and the SpatialBiz plugin to access Smallworld.