Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,779 Posts
  • 24,924 Replies
6779 Posts
H
hadhafang
asked in Data
IFC to CityGML filtering IFMEMultiCurve

I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCDoors entities into CityGML doors i get the following error:CityGML Writer: The 'IFMEMultiCurve' geometry is invalid for the 'lod4MultiSurface' citygml_lod_name, valid geometries for 'lod4MultiSurface' are: {IFMEMultiSurface}, convertible geometries are {IFMETriangleFan, IFMEAggregate, IFMECompositeSurface, IFMEFace, IFMEMesh, IFMEDonut, IFMETriangleStrip, IFMERectangleFace, IFMEBox, IFMEBRepSolid, IFMEExtrusion, IFMEMultiSolid, IFMEMultiArea, IFMEEllipse, IFMEPolygon}.Storing feature(s) to FME feature store file `U:\Exjobb\FME BIMtoGIS my own\NyvångToCityGMLintermediat_log.ffs'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Door'Attribute(encoded: utf-8)         : `GlobalId' has value `02R5wDVnfBGx4r_HlUhMUt'Attribute(encoded: utf-8)         : `Name' has value `Door Open

172
H
6 years ago
H
h2
asked in Data
DTM to TIF transformer

Hi,I need to generate a single TIF file from multiple DTM files. Any advise please.Thank you

1141
daveatsafe
Safer
6 years ago
G
gio
asked in Data
oracle julian dates

Hi all,This works in SQL Developer.Why does this not work in a SQL Executor/Creator?select to_date(736845 + to_char(to_date ('02-01-0001'),'J'),'J') t1,to_char(to_date ('02-01-0001'),'J') t0from dualoutput:T1 T031-05-18 1721425Fme executor insists `ORA-01843: not a valid month'which is totaly not true!  It appears that the 'J', julian format is not recognised.  Is this a error or am i missing something?Don't suggest out of sql solutions, i wan't it to be done in the executor. Be aware i will issue demerits !! ;)  SQL answers required. Greets an txia for your answers.

333
G
6 years ago
lazarlubomir
Contributor
lazarlubomirContributor
asked in Data
Unpredictable behaviour of igds_snappable atrribute - DGN file V7

Hello everybody,I have met troubles with values in igds_snappable attribute of cells. In my source datafile (v7), insert point of cell is snappable, but elements of cell are not. When I open datafile in FME Data Inspector, it shows me that insert point and all elements are not snappable.If I change value of igds_snappable in Microstation for just 2 elements of cell, the insert point in FME Data Inspector is snappable, interesting...Is it bug or not? Have You ever met the same problem? I´m using FME Desktop 2017.1.2.1Thank You so much!Lubo

63
lazarlubomir
Contributor
6 years ago
D
danamos
asked in Data
Cross Section / Profile through a Point Cloud

Hi,I'm after creating a series of profiles / cross-sections using a mapinfo table containing the lines to be driven through a DEM of the LAS point cloud. The output txt file should contain x, y, z, and chainage (from the zero point of the profile, (which should increase at 0.5m spacing)), and profile_ID (derived from the mapinfo table).Any guidance on how to achieve this would be much apprieciated.

731
1
6 years ago
A
abidoua
asked in Data
Probleme : CityGML to IFC conversion

Hello beautifull people, i have to make onversion from buildings from CityGML lod2 to IFC . but i get a the end of conversion in the Data inspector NO Geometry !!! i need your help how can i do it and why does not go ? Thank you

151
daveatsafe
Safer
6 years ago
H
hugoledoux
asked in Data
What are the limitations of the CityGML reader? The doc is not clear

In the doc: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/citygml/citygml.htm?Highlight=citygmlThe part where the limitations are listed:The CityGML reader reads all parts of the Thematic and Appearance CityGML models with the exception of the Digital Terrain Models (DTMs) ImplicitGeometry and xlink:href resolution.is not really clear. Is there a comma after '(DTMs)'? Or do ImplicitGeometry are not read? (They are, I just tested!). Same for XLinks, they seem to be resolved (at least those internal to the file). So I'd like to know the limitations, if any.

40
H
6 years ago
boubcher
Contributor
boubcherContributor
asked in Data
Export GeoDB to Excel

Hello I am Looking to export the Geodatabase schema ( manay tables) without the data to an excel sheetcolumn 1: table nameColumn2: attribute nameColumn 3: attribute typeColumn 4:width

319
boubcher
Contributor
6 years ago
L
linhgg2
asked in Data
Folder path with special characther å does not work

I'm trying to upload a file from a folder with name luleå but FME change the character å with \\xE5 in the folder path and FME cant find the file and terminate the workbench.Is there something to do so fme does not change the character?

53
fmelizard
Contributor
6 years ago
D
divil
asked in Data
AGOL reader issue FME 2018.0

Hello,I've installed FME Desktop 2018.0 Database Edition.When I open an existing FME Workspace with a AGOL Reader I get the following error when I run it:ArcGIS Online Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='www.arcgis.com', port=443): Max retries exceeded with url: /sharing/generateToken?f=json (Caused by ProxyError('Cannot connect to proxy.', error('Tunnel connection failed: 407 Proxy Authentication Required',)))'A fatal error has occurred. Check the logfile above for detailsIf I try to add a Web Connection to my AGOL Account; after I enter my authentication details I get a error I am going through a proxy server.Any ideas?Thanks Helen

294
D
6 years ago
mickael
mickael
asked in Data
OSM reader issue with unorthodox level & layer values

Hello,I am having an issue with OSM values (in a FeatureReader). For some reason, there are level and layer values set to 0.5. Even if it is quite unconventional, "there is an ongoing discussion on usage of fractional values". Thing is, it seems that FME does not handle this case, I get the following error :|FATAL |Feature Type: `waysStringFormatter_OUTPUT'|FATAL |Attribute(encoded: UTF-16LE): `bridge' has value `yes'|FATAL |Attribute(string)           : `fme_feature_type' has value `highway'|FATAL |Attribute(string)           : `fme_geometry' has value `fme_line'|FATAL |Attribute(entangled: string): `fme_type' has value `fme_line'|FATAL |          entangled to [xml_type]|FATAL |Attribute(encoded: UTF-16LE): `highway' has value `footway'|FATAL |Attribute(64 bit integer)   : `id' has value `271462128'|FATAL |Attribute(encoded: UTF-16LE): `indoor' has value `yes'|FATAL |Attribute(encoded: UTF-16LE): `level' has value `0.5'|FATAL |Attribute(encoded: UTF-8)   : `roadsWidth' has value `'|FA

60
mickael
6 years ago
nicholas
Contributor
nicholasContributor
asked in Data
How to set column names for delimited text file with no header

I have a pipe-delimited text file for inputThere is no header line of column names. Data starts on the first line.How do I set column/attribute names?I tried AttributeRenamer, but FME gives column names drawn from the first line of data. I receive a new input dataset each month, and the first line of data will change. I want to be able to assign column names based upon their order, not upon the first line of data. I need this process to be repeatable with a new input dataset.

1683
takashi
Contributor
6 years ago
jurgenmack
Contributor
jurgenmackContributor
asked in Data
Has anyone tried the JDBC reader with Apache Derby?

I receive a driver not found error using the URI and when I point to the derbyclient.jar file

112
jurgenmack
Contributor
6 years ago
L
lsdanger
asked in Data
CityGML: change gml_geometry

Hello everybody,I'm using this template https://hub.safe.com/templates/citygml-create-solitaryvegetationobject-with-implicit-representation to create a CityGML file that contains trees as SolitaryVegetationObjects with implicit representation. The template works fine but doesn’t serve my purpose as I want to use the data in the 3DCityDB which doesn't support MultiGeometry features. Is there a way to change the gml_geometry?Thank you for your help.

221
daveatsafe
Safer
6 years ago
pflegpet
Contributor
pflegpetContributor
asked in Data
Read .txt file from online source

Hi, I'm trying to get the links from this URL using the CSV reader but it does not work: https://data.geo.admin.ch/ch.swisstopo-vd.amtliche-vermessung/meta.txt Using an HTTP Caller did not work either. If I paste the link in a browser it works fine. Any idea what I am doing wrong? Thank you for your help!

1184
pflegpet
Contributor
6 years ago
R
r0a0c0h
asked in Data
Call FME using HTML

Hi,I would like to know how I can call an FMW file from my clients website.Thanks

42
redgeographics
Celebrity
6 years ago
tomf
Contributor
tomfContributor
asked in Data
2018 Bookmarks - filled backgrounds and descriptions

FME 2018 seems to have removed my two preferred methods of using bookmarks: 1) Without a filled background - it's too distracting to be always on; 2) No description anymore. Much neater and compact than annotation and the 2018 examples still waste too much space. Can we please have these back as an optional behaviour? I can't even edit workspaces with description anymore!All you are encouraging me to do is to STOP using bookmarks!

43
mark2atsafe
Safer
6 years ago
S
sylwianikel
asked in Data
Fanout by fme_feature_type but remove irrelevant columns in each excel sheet

I have a problem with writing the multiple sheet output to excel but keeping only the attributes that are relevant to each sheet. For example (as you will see on the image) SAC_NAME should only be in the sheet named Special Areas of Conservation and should not be present in the sheet Wood Pasture and Parkland... and vice versa the PRIHABTXT attribute should not appear in the sheet Special Areas of Conservation... What I get now are columns of empty attributes.I tried to use PythonCaller to remove the empty attributes but it did not work, since the writing actually happens in the writer and PythingCaller is before the fan-out happens (I imagine that before fanout all is in one sheet and none of the columns is entirely empty).

192
S
6 years ago
R
raj3singh
asked in Data
Read all features from source before writing to AGOL

Hi, was wondering whether there is an option to read all the features from a feature class in a SQL Server geodatabase or SQL Server spatial table before they get written to an ArcGIS Online (AGOL) feature layer when I click the run button in the toolbar. The problem I'm running into in our environment is that part way through writing to AGOL I get an error like the following "Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `[no query]'. Provider error `(-2147467259) TCP Provider: An existing connection was forcibly closed by the remote host.".Thanks.

72
R
6 years ago
L
lopes8
asked in Data
Trouble using GEODATABASE_SDE writer

Hello,I am having issues when using the GEODATABASE_SDE writer in the below environment. I am referencing the sde connection file from a FME Server resource location and then override the credentials within the workspace. The log shows it getting to the below lines and just hanging forever. When I swap out the writer to be SDE30 it has no issues at all and completes as expected.I am at a loss as to what may be going on. I guess I could use the SDE30 writer but I would really like to understand why the more recent GEODATABASE_SDE isn't working. Last three lines of log:-FME API version of module 'GEODATABASE_SDE' matches current internal version (3.8 20170315) -An ArcGIS license is already checked out. The product checked out is 'Advanced' -Installed ArcGIS version is '10.5.1'Environment:FME Server 2017 on windows server 2012SDE database 10.5.1 on top of Oracle 12cAny help would be much appreciated!

71
L
6 years ago
R
robertdbuckley
asked in Data
remove overlaps in pointcloud ?

Is there a tool or workflow to remove or classify overlaps in a LAS file?

142
R
6 years ago
D
davidjwindle
asked in Data
file geodatabase to TAB

ESRI file geodatabase into MapInfo TAB format. Partial conversion only in that some records have data missing

51
fmelizard
Contributor
6 years ago
A
angela
asked in Data
When translating a shapefile to Postgres Geodatabase, the records get created in the writer with the mandatory attributes (Objectid, SHAPE, st_area, st_length) but none of the other attributes get populated (all show as Null). Anyone know how to fix

1816
chris_m
Participant
6 years ago
O
oharab
asked in Data
Create ECW With Latest Files

I'm trying to build an ECW from OS tiff tiles. I get the Change Only Updates so have several folders with the base data and monthly files with the quarterly changes.What I'd like to do is use the latest tile from each of the folders, but I'm not sure how! Is it as simple as sorting in date order, so the newer file are laid over the top of the older?TIABen

31
danilo_fme
Evangelist
6 years ago
L
lianaolianov
asked in Data
Geom column in spatial databases

Hello,I noticed while migrating some Shapefiles to MSSQL Spatial that there's a Geom column which is added. In which format it is encoded ? And does it countain all the spatial data required informations to restore and draw all the stored features ?thank you

634
david_r
Influencer
6 years ago

Badge winners

Show all badges
30,108
Posts
Terms & ConditionsCookie 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.