Data

Hi,  Is it possible to specify an existing output folder on Google Drive when writing to a Google Fusion table? It always ends up in the root folder (My Drive) for me. I would like to write the table to an existing shared folder to avoid having to share the table when it's written.  /mats

Hi, I am using FME2014 and I am using this documentation : http://fmepedia.safe.com/articles/How_To/Working-with-Geodatabase-Subtypes-and-Domains  At the step 3 of reading domain values in the documentation, I click on VIEW of the coded_domain (DIAMETER) and I have my list of coded domain values from my GDB. Exemple :  http://fmepedia.safe.com/servlet/rtaImage?eid=ka1a0000000cwS9&feoid=00N30000007dMlC&refid=0EM30000000TpzI What I want to do is to export this list into something else like Excel. I have hundreds of coded domain values into my GDB, each of them connected to Feature Class. I would like to export the coded domain values (code and description for each of them) from all the FC I would choose to read into FME.  You think it is possible?  Thank you!

Hello, I'm doing a straigth-forward conversion of Oracle SDO_GEOMETRY from srid 294914 (old national coord.base) to srid 3067 (new national coord.base) using just Oracle reader and writer.  Is there any way to reduce the number decimals in the output, at the moment converting from   3385034.91; 6678837.36  (east; north) produces   384911.612948413; 6676033.80278682  Best solution would be to have some parameter in the writer to round or cut  to a desired number of decimals .  I assume that using some transformer (like CoordinateRounder) between reader and writer would substantially increase the execution time ?  Esko  

Hi  I have a huge set of Las files and I just want to pick out one or more of the files and cut out a pre-defined area. The area will be defined by the user, a published parameter. I do area on area overlay, the customer defined area over a square grid to catch one or more id numbers. Know I drop the geometry and just use the attribute in this part of the workbench. Couse I figured it would take longer time to do a spatial intersection in the next part of the workbench. I use the feature reader transformer and specify the feature type to read to the attribute above (Id number).  I have defined the directory and dataset is set to *.las. I’m having problems though when I run the work bench it doesn’t fetch the Las files. The attribute is defined as 70875_7620 so I tried 70875_7620.las and no deferens.   THe transformer runs when I use the spatial intersection mode that’s way I figured out it  must be the attribute.   Any Ideas?   Tofia :)  

Hi, I have started to use new writer format INSPIRE GML. I have also watched webinar on following subject recently. Since this is a first time I am working with mapping to INSPIRE schemas, I am a little bit dizzy with whole bunch of features and attributes. Still worst problem I have is with mapping geometry. I had to do a test with Hydro theme and featureType Crossing (geometry line). I used GeometryExtractor (GML 3.2.1. geometry encoding) for this purpose. Mapped '_geometry' to 'geometry' with AttributeCopier, but 'geometry' attribute is empty (missing) at the end. If i check the output values after GeometryExtractor with Inspector, there is a geometry value. So obviously I haven't mapped _geometry correctly with corresponding attribute on writer as Dean suggested in webinar (geometry attribute should be used for polygons only, correct?) I also mapped it with all possible xml_geometry datatype on writer, nothing. what do I do wrong?

Hello,  I am wondering what coordinate system I should be using to convert a csv file of survey data to an ESRI shp file?  The data looks like this:   135 5580767 458060.914 562.143 GF  Columns 2,3,4 are Northing, Easting, Elevation.  Any suggestions would be much appreciated.  Cheers!

Hi,    I've got an CSV file with 'hidden' XY in a column.  It's like this: <gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="urn:ogc:def:crs:EPSG::28992" srsDimension="2"><gml:pos>240664.000 488240.000</gml:pos></gml:Point>    I want the two coordinates to be seperate columns in the new (point) shape.  How do I do that?    Thanks for any help!

Good morning to all   I am running a process using schema mapper  to load data into an existing feature class. The problem that I am seeing in the translation is that FME is generating extra attributes that are not part of the schema of the featureclass that I am     When reviewing the log this is what I see:   "Value of feature type parameter 'GEODB_OBJECT_ID_NAME' for table/feature class 'Bridge' has been changed from 'OBJECTID' to 'OBJECTID_1' as it conflicted with user field name. Value of feature type parameter 'GEODB_SHAPE_NAME' for table/feature class 'Bridge' has been changed from 'SHAPE' to 'SHAPE_1' as it conflicted with user field name."    I added an attribute remover for the input files so that they didnt transfer over but I still get  the OBJECT and OBJECT_1, SHAPE_Area1, SHAPE_Lenght1.    Any thoughts?   

Hi. How to make hatch patterns with 3 different colours. I use DWGStyler and a template file, but I can't find any option to set these.    

I'm using FME desktop workstation and application server to write output kmzs to our client server. For some reason, kmz files exceeding 5 kB in size result in empty files with 1 kB file size, regardless of whether executing at the desktop or from the server. However when writing to a kml to the same client server or writing to the desktop, it works fine as usual.    The user account used is able to write large files to the server location. The application log files show nothing unusual. There didn't appear to be a user permission issue. The service account looked fine.  Where else should I look to troubleshoot?   

how do i get FME to create the spatial index on a SQL Server SDE database -- documentation references GRID 0 - but there is no parameter for it in FME2014?

Hi:     I have a layer with zoning, and a cadastre layer - the boundaries dont match up so i was trying to user a negative buffer to shrink the parcel a bit to eliminate most of the missmatches - but then i am getting too many null buffers.  trying to do it with a spatial relator and a matcher and it is getting overly complicated.  So time to rethink how i am doing it. What is the best way to copy the zoning text attribute from the zoning layer to a parcel layer on top of it - there are parcels with multiple zones? Thanks,    Mike   

Hello!    This is serious failure I have here: after installing FME 2014 I cannot get my Oracle connection working properly. All the previous workspaces will crash if I try to save them over. I figured out that the problem starts even if I try to add "Oracle Spatial Object" type reader on the blank workspace, it crashes:      It's weird that with 2014 beta I did not have that problem - I changed all my 30 or so workspaces, to use 2014 (2013 SP3 was our previous, still working with Oracle). But the database <null> support that came out with 2014 was a crucial benefit for us, so switching back would be really annoying.    What could cause the FME 2014 to crash workspaces with Oracle Spatial reader?   And, it is weird that using "Oracle Non-Spatial" reader is not causing crash...    With regards,  Raivo Alla  Estonian Land Board 

Hi, I have a feature class of polygons that I would like to convert to a text layer in the DGN file with one of the attributes as the text shown. I have played about with GeometryCoercer and tried  changing the format attibutes (igds_type and igds_text_elements{}.igds_text_string) but cant get text to display in the place of polygons. Has anyone managed to do this?

Hello All,  Just a quick query re the new GME Tables format. I've managed to connect successfully to our GME instance, list our projects, list our tables, and retrieve features. Unfortunately, the list of available tables seems to be limited to 100.  Has anyone had any luck in working out how to retrieve tables beyond that first 100?  I've tried manually entering the assetIds as a workaround, but with no success.  Cheers,  Keith

Before I proceed in my FME training I wanted to see if it is possible to create FME workspaces where it would require for it to ask for an input GIS file (Mapinfo TAB) and for it to run various processes (conversion, reprojection, renaming) based on where it is coming from.  I would need this to be a reoccuring tool that I would run for different folders at different times.  For example I have different folders that store different GIS files based on the specific geographic area it is in.  I have many of these folders that I run the same processes at different times based on which area I happen to be working in that day.  So I wanted to know if I could open an FME workspace and have it ask for an input file, then runs the process I set up for it to do based on the folder it is from? output file names would need to be custom to where its coming from everytime.  I am basically trying to decide if I need to learn FME, or Mapbasic to create mbx tools. Or can FME do anything a programing la

Dear All ,   We need to combine all the attributes from AttributePivoter into another feature class , we used FeatureMerger to combine the attributes but we are not getting all the attribute from AttributePivoter  . if we write AttributePivoter to excel directly it is working fine , but now we need to use the excel output into the same feature class . so what is the way to get it in one shot   1) AttributePivoter  with FeatureMerger  but not getting all the attribute 2) or  if we write it to excel how can we use this execl as input again on the same work bench  3) or call another workbench from the same workbench to read the output excel file and merge it with another feature .   Thanks,

Hello Everyone  I have multiple Geomedia text  features that I would like to split by a mapsheet border.  Example: if 182 Street NW crosses the boundary  where 182 is inside and Street NW is outside I would get two labels back  182 | Street NW. Any ideas I'm using FME 2013 SP 3  Cheers  Ron

Hi all, As you can see, I have a quite complex question. Some genereal information: I'm using Windows Server 2012 FME Desktop and Server 2013  ArcGIS Server 10.2 What I want to do: Using a Web Harvesting program, which searches on a OpenData-Site for accessible WMS Service, which I want to integrate in my WebMap. The WebHarvesting program stores all WMS links in a txt file. The links look like this: http://gateway.hamburg.de/OGCFassade/DE_HH_WMS_INSPIRE_A3_4_Bodennutzung_lokal.aspx?SERVICE=WMS&REQUEST=GetCapabilities&VERSION=1.3.0  Now I want to use FME Desktop, which reads/parsed the line and after that, FME should publish these links to the FME or ArcGIS Server Rest Interface.  So....firstly my question would be: Is this possible? And secondly: If it is possible, how to realize it?   Regards!

I often need to convert large numbers of layers from TAB to DWG CAD format. Is there a way of doing this on bulk or looping a workflow to repete an action over a list of inputs.  If i need to convert TAB to SHP all i need to do is put them into the 'generate workspace' and it makes a workspace with the correct number of reader and writer feature types and copies across the attributes. HOWEVER, I cant do this with TAB to DWG files as it asks for the destination folder AND file name then merges all the input layers together into one file. I have therefore had to translate each file separately (and when you have about 60 files this takes ages)  Now I want to go one step further and add a clip function. I have 32 TAB files which i need to clip by a boundary and then write each file to DWG. Currently the only way i can see of doing this is making a workspace with 32 reader feature types, 32 clippers and 32 writer feature types (remembering each time to say copy attributes from reade

Hi,    I have a process that converts a DWG to PNG tiles. The last transfomer before the writer is a RasterBandPropertiesExtractor to check what will be written. This shows that each tile is RGB24 bit (red8, green8, blue8) also the tiles that are completely filled with background (255,255,255).  But when the PNG tiles are written the tiles with only background are converted to a 1bit image instead of a 24bit image.    Is there a way to force RGB24 tiles like you can with the tiff writer?    Regards,  Rob

Hi, I'm trying to use a gdb file with FME 2013 but am getting this error:  |ERROR |Geodatabase Error (-2147220965): This release of the GeoDatabase is either invalid or out of date. |ERROR |Could not open File Geodatabase dataset `D:/flood/GDB/uFMfSW_Banded_Vector_SK00.gdb' for reading.  I'm using the "Esri Geodatabase (File Geodatabase API)" reader. I do have ArcGIS 10.1 installed on the same machine, but for some reason FME isn't picking it up so I can't use the ArcObjects one.  How do I read this?

Hi,  I am trying to convert a CSV file (no header, just X Y and Z columns) into either a LAS or POD file format.  However I keep getting the error:  "Failed to obtain point cloud from feature.  Only features with point cloud geometry are expected"  Is there a step that I'm missing here?  Thanks, 

I am trying to build some 3D planes from XYZ centre points.  I have generated the planes using sector generator coerced these as polygons then 3d Forced them @ZValue  rotated them CLOCKWISE them using ) and I am stuck trying to get the resultant planes to rotate/tilt on their Z axis about their @ZValue centre using an @Value(Dip)  can someone please provide a screenshot of a 3DAffiner example of a Z-axis affine of say 10 degrees   AND  a 3DRotator example of a custom axis example OR z-axis example to apply a 10 degrees to each plane element? the help file for these two transformers are for irony and i am unable to debug why nothing is tilting.  Kind Regards, Steve 

Hey!  I am trying to convert XML informations (30K non geospatial elements) into formated PDF for each of my elements (30K).  What would be the best way to do that?     - I am able to create a table for all my elements, but I don't see the way to create a formated PDF each elements.  - I checked out about the XSLTProcessor, but It doesn't seems to be useful to create a formated PDF. Am I wrong?  Anyway if you have better ideas I'm wide open!  Thanks