Data

Hi There,  I'm throwing this out there in desperation. I'm trying to find a way to keep a hosted table updated within ArcGIS Online. Unfortunately, I've found that it is not possible to write data to a table service in the same way we can write to a feature service using FME. Has anyone devised a way to write rows to a table that is hosted in ArcGIS Online (or some other service)?  I suspect it will have to be done using JSON and the REST API but being a bit of a novice in this area of the cloud I'm seeking some pointers.  Any suggestions would be greatly appreciated!  Warren

Hello,  I have a workbench which reads featureclasses from parameters i.e. Oracle tables. I linked this parameter to "Feature Types To Read". Oracle Sptial Reader is used to read these feature classes and write it out to SHAPE. This works fine. Just want to know is there any other efficient way to achieve this. As I don't know how many tables I may need to pass in parameter.  Cheers, John

I am using statistics calculator to fill in the total number of features from a datasource.  I want to expand and contract that list in excel dependent on non zero.I also want a grand total at the bottom to be just below the last row. Do I need to get the max number of possible rows to use in a parameter? Do I need to create a parameter to count those rows and make that parameter the location +1 of my grand total?

Hi all, we are running a 64 bit FME Desktop on a Windows OS and a 64 bit Oracle client. Everything works until we made an update of the ArcGIS Server. After that the FME Desktop crashes if we want to create a new workbench and choose an Oracle reader. After selecting it in the list box the software shut down! So we reinstalled the Oracle Client but it didn´t help. The question ist, what happens "behind the scenes" when choosing the Oracle reader? Is there a central file (in the OS) which is used at this moment? 

Good Day,  This question continues on from a previous question of mine: https://knowledge.safe.com/questions/3794/need-hel...  The problem I'm having is that when I look at the canvas in FME after running the process, FME indicates that 433 records were written to the File Geodatabase: But when I look at the attribute table in the file geodatabase, there are 0 records in it: I don't know if there's a step or something that I am missing between AttributeExposer and the File Geodatabase Writer. Kind of learning here by trial and error.  Thanks for any help,  Chris

I am currently trying to merge two tables (one is a shape file with county polygon info and the other is a excel file with info about the county. My goal is to get the polygon info into the table with all the data. Both have essentially the same field (counties) but are named two different things. One of the files calls it counties while the other is a shape file that just calls it name and has the polygon data. What is the best way to merge these files or is it better to use ArcMap tools to do the merger?

Hi!!! I read a SDE (SQL) database and write dynamic MapInfo table (dynamic is because I want my output to be like my SDE Database).  Eveything is fine except with the "date" type attribute.  MapInfo write the date as a "DateTime" attribute. But I'd like to have a simple "Date" attirbute.  Any idea how to force "Date" and not "DateTime" on a dynamic transformation using Dynamic Properities of the  SDE Geodatabase ? thank you!

Hi, I'm trying to use FMEObjects, particularly read, modify data and write back to MSSQL database and I'm hitting a strange behaviour in 2015 version. Maybe I'm doing something wrong but.. I managed to read data OK but when I'm writing back it complains "Spatial Column 'geometry' with type 'geometry' does not exist in table 'dbo.simple_test_data'. Please specify an existing spatial column to write to". As far as I'm concerned - I have specified - here's my writer directives: Writer parameters: COMMAND_TIMEOUT=34 RETRIEVE_ALL_SCHEMAS=YES SERVER=server USER_NAME=fme_datastore_test PASSWORD=*** WHERE_CLAUSE= CLIP_TO_ENVELOPE=NO READ_CACHE_SIZE=10 ASSUME_ONE_SRID_PER_COL=YES EXPOSED_ATTRS= SPATIAL_TYPE=geometry SPATIAL_COLUMN=GEOM  Here's extract from the log: 0.1|INFORM|+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2015-10-15 16:28:03|   0.2|  0.0|INFORM|Feature Type: `dbo.simple_test_data' 201

I have a line shapefile and a nodes shapefile, I want to via the topologybuilder to get the from_node_ and to_node_. However, after this transformer, I got some extra nodes which are overlapped on the some input nodes. Those are not I wanted. Because I saw that by an intersection point of 3 lines, 2 lines have the same to_node_, but another has a different to_node_, which is overlapped.   How can I solve this problem? (I can send the data and script)  Thanks for helping!

The full answer to this might ba a bit big for here but any tips on what transformers to use and how to get things to group up would be great, I just need to get started then I can probably figure the rest out. I am trying to generate an XML fragment. So far I have got my data in the following format, 14 features with 2 attributes  Group  Name 01       01 - ID prod lights 01       01 - ID  prod buoys 01       01 - ID prod achare 02       02 - ID insert lights 02       02 - ID insert buoys 03       03 - ID move lights 03       03 - ID move buoys 03       03 - ID move achare 04       04 - ID del lights 04       04 - ID del achare 05       05 - global deletes 06       06 - decide lights 06       06 - decide buoys  The XML I am trying to generate would look like this  <ApplyActionsTask>     <label>01</label>         <action>01 - ID prod lights</action>         <action>01 - ID prod buoys</action>         <action>01 - ID prod achare</action&

I have GML like this:      <gml:featureMember>         <bt:KR_Obiekt gml:id="ID_707">             <gml:boundedBy xsi:nil="true"/>             <bt:kod>104</bt:kod>             <bt:geometriaKarto>                 <gml:LineString srsName="EPSG:2180" gml:id="ID_707">                     <gml:posList>434752.25 710532.47 434752.14 710532.44 434750.4 710531.52 434748.8 710530.31 434747.34 710528.84 434746.03 710527.19 434744.88 710525.4 434743.9 710523.53 434743.08 710521.63 434742.45 710519.77</gml:posList>                 </gml:LineString>             </bt:geometriaKarto>             <bt:label>                 <bt:KR_Label>                     <bt:tekst>10</bt:tekst>                     <bt:geometriaKarto>                         <gml:LineString srsName="EPSG:2180" gml:id="ID_707">                             <gml:posList>434

Hi all,  I have a GML geometry that I would like to convert to WKT (in order to insert it in the geometry with Z column of a PostGIS DB). Here is a geometry sample (from CityGML):    <gml:MultiSurface srsName="EPSG:4979" srsDimension="3">                     <gml:surfaceMember srsDimension="3">                         <gml:Polygon srsDimension="3">                             <gml:exterior>                                 <gml:LinearRing srsDimension="3">                                     <gml:posList srsDimension="3">41.8636830995329 12.4911723999943 0 41.8637580995329 12.4912074999943 0 41.8637078995329 12.4914008999944 0 41.8636328995329 12.4913657999944 0 41.8636830995329 12.4911723999943 0</gml:posList>                                 </gml:LinearRing>                             </gml:exterior>                         </gml:Polygon>                     </gml:surfaceMember>                     <gml:surfaceMembe

I have a table of data that has two fields that have comma separated values in them. Each value is related to each other. So the first comma separted value in Neighbour Code field is related to the first comma separated value in Neighbour Angle field and so on.... The table looks like this    How do I separate these values and create a new record for each value in the fields so the table would look like this:    Thanks  Matt  

I am writing from shapefile to swallworld. I am getting the text "fme_geometry" appended to the end of a text field when I run my conversion. I don't have have the fme_geometry format attribute exposed and even if I did there is nothing connecting it to my text attribute. When I look at the attribute in the inspection point it looks fine. Anyone seen anything like this before.  output looks something like this  blah?blah?blah?blah?blah?blah?blah?blah?blah?blah?blah ?blah?blah?blah?blah?blah?blah?blah?blahfme_geometry

Hi,  I want to make several polygon features as a single GML Surface feature. I need to convert polygons into PolygonPatches and then aggregare them into single Surface (with several polygon patches) grouped by specified attribute. How to get this done? I tried Aggregator, GeometryCoercer, different combinations, but, nothing.

Data: 1-Excel sheet with two columns ABB and NME (abbreviation and full name)  900+ records. 2-Shapefile with Attributes MUNR & MUNL. This attribute has the same abbreviated municipality names as the excel sheet.  What i'm trying to do is create two new attributes (MUNRFull & MUNLFull) on the shapefile that will have the full names.  The statement would be something along the lines of where ABB = MUNR give me the NME output as MUNRFull. where ABB = MUNL give me the NME output as MUNLFull.   

Hi, I'm trying to merge features from 2 excel files with FeatureMerger.. It works if I have a relation one to many but it does not when I have many to many relation.. any idea.. Thanks

My KML files have a Description element and the Description have either an attirbute/value pair or just a value. After the Description has been extracted and a ListExploder for each entry on the description, two stream were created - one for entries that have an attribute name/value pair and another one for entries that have a value with no attribute name.  For the name/value pair (22 entries per feature) they are split and then @Value(_list{0}) was created and (_list{1}) assigned a value to each entry.  For the value only entry (3 entries per feature), an attribute name (attr_name) is created using the element index and then another atribute using @Value(attr_name) is assigned the value of each entry.  When the attributes are merged back with the geometry, the data stream from both attribute streams appear only in the feature information window when features are identified in the inspector. he transformers don't show any attributes . When I use AtributeRenamer to make the attribut

Hi! The excel writer doc says that:"The writer feature type option to Drop Existing Sheet/Named Range is irrelevant if specifying a template sheet here, since the existing sheet will always be replaced by the template sheet." [my underline]. This is not true. The template sheet is retained, and new sheets are created after it. Fanning out data on an expression like <fieldname>.xls and using <fieldname> as sheet name, and Sheet1 as template sheet produces an excel file with two sheets, Sheet1 and <fieldname>. This is not as expected (or my misunderstanding). I have tried numerous tweaks for truncate-overwrite etc etc to no avail. Please advise. Regards, Mats.E

Im creating some tables with an oracle spatial writer but its creating them without a primary key.  I am using a sequence in oracle to increment the value but the created table does not have this ID set to primary key.  How do I get a table I am creating to set a column to be the primary key?  (Im in FME 2013)     

I have a few additional generic attributes with specific values (meaning of them are in a separate codelist)  in my CityGML dataset. Now I want to test them with the transformer "Filter" an sort them by the gml:id. Then I want to write them in an Excel-file or text file. Some attributes are also in the buildingpart with means I need a multidimensional output maybe as xml-file. How can I test only one attribute with the transformer "Filter"? My intention is to build a row of transfomers and every transformer is testing one attribute. At the end I want to write a protocol with invalid datasets. Any ideas? Best regards, Frank

I am looking to create a road outline (Open Street Map). We have gps traces for the left and right edges of the road (time stamped, as two seperate data sets). I realize that most folks would just want the centerline of the road, but we have an unique need, and we need the way paths for both sides of the road.   No need for a full workup soluiton, but if you have tips that would be good (it is a small area, only about 30 acres of road).  

How to add the result of the spatial relator as CSV in the data of requestor

Hi!  I'm using FeatureMerger to merge a Shape file and a CSV file, and outputting to a GeoJSON file. The merge works as it should, but is producing seven extra attribute columns that I don't want, even though none of the Format Attributes are selected in the Feature Type Properties settings (csv_line_number, csv_number_of_fields, csv_total_number_of_columns, multi_reader_full_id, multi_reader_id, multi_reader_keyword, multi_reader_type).  This is obviously making the GeoJSON larger than necessary. Can someone please tell me how to ensure these Format Attributes don't get written out to the final GeoJSON file?  Thanks!

Hello,  I have a bunch of shapefiles as inputs but i'm not using them all everytime, so i put them as Optional in the User Parameter. But i get this message : "Shape Reader: Failed to open dataset 'T:\\Test\\\\SHP\\test.shp' which is neither an existing file nor directory" when i run my script using a python script. Eventhough the shapefile doesn't exist, since it's set as optional, FME should ignore it, no ? How can I make it work please ?