Transformers

please guide to how convert geotif to table as reade by postgres sql

I have one track stored in MID/MIF, and a couple of points from other source. It is something like bus route with list of stops. All what I need is to know, how far from the very first stop each other bus stop is. Looks like it is a task for a LengthToPointCalculator, but I can not achieve right way how to use it.:( From what I am starting: I use two MID/MIF readers as sources - one for route, another for stops. Then I use CoordinateExtractor to get X and Y as attributes for each point. And after some alchemy we reach that LengthToPointCalc. I do not want to explain all variants I've tried, but in any case I got only zero as lengths. There are no problem to get length between every pair of sequential bus stops. But I can not imagine how to sum it after that. I will appreciate any help!

Hi allI have an interesting task of joining 2 datasets: One dataset is a table with house numbers, the table has roadids, housenumbers (including letters) and an attribute that shows if the house number is an even number og uneven.The second datasat contains roadids that matches the first dataset but instead of specific house numbers the second dataset contains 2 attributes: house_number_from and house_number_to, the second dataset also has an attribute telling if the intervals are even or uneven numbers.The second dataset also has a district_id attribute.I have to join these datasets to get the district_id joined on the first dataset. I somehow have to determine if the adresses in the first datasets fall between the intervals in the second grouped by the roadidI have attached both datasets here:does anyone have an idae how to go about this?

Google kml writer creates duplicate <multigeometry> tag for multi-part or multipolygons. Is this expected ?I have attached a sample kml that has a duplicate <multigeometry> tag which seems rather redundant

Dear all,I am currently trying to expand an existing ASCII file with a single row. I have an ASCII file with X, Y, Z, R, G, B and an Intensity (Scalar field). My second ASCII file has the same X, Y, Z and Intensity but instead of R, G and B one single row, named Scalar field #2.I have both files imported as readers in CSV and connected them with an Aggregator. Now I get an ASCII file which has everything I want: X, Y, Z, R, G, B, Intensity and Intensity 2. My problem is, this task takes +40 hours, since I'm dealing with over 40.000.000 data points each row.  Is there a chance to just copy X, Y, Z, R, G, B and Scalar field from ASCII 1 to a file and extend it with Scalar field #2 from ASCII 2? Do I really have to Aggregate the whole process?Thank you in advance!

Hi,I am working on a use case of dissolving features that are touching (or share a common boundary) and also based on certain attribute criteria that these features need to fulfill. While I was successful in doing that (I can say that by seeing samples of the output), I was also hoping if I could distinguish the actual dissolved features so that I have an accurate account of where the change happened, especially for a large dataset (a million polygons)If someone can let me know that would be greatly helpful to test my work. Thanks very much in advance

Hi,as you can see in the attached screenshot, I have a dataset that consists of lines partly with the same geometry. The selected feature on the left side is partly identical to the one on the right (and can be seen as a "segment"). I only want to keep the feature on the right side, because the line on the left is obsolete and a "duplicate". How can I identify these "duplicates", that are "segments" of other lines to keep them out of my dataset? Thanks a lot for your help in advance!

Hi,I will find how many different ID are for one GARDSNR and BRUKSNR.I've correct answer with Cumulative (3), but in Complete and Summary Count is 5 (sholud be 3):Parameters used for StatisticsCalculator:Group by: GARDSNR BRUKSNRAttribute to analyse: IDTotal Count attribute: CountThanks in advantage:)  

I've been working with the mapnik rasterizer tool looking to rasterize polygon geometry. Each time I try to create my output I get large blank areas on my raster. Please see image attached. When I inspect the vector data it appears fine with no missing data. Thanks for the help!!

Hi,One column has 4 values 2, 12 324, 56987 (data type is number)When I use filter in Inspector (Table View) to find records with value 2 I got 3 results (2, 12 and 324)Earlier versions of Fme gave me just one result: 2.Is it a method to find just records with value 2?Thanks in advantage:)

Hi guys,I have a lookup table contains values in different fields (column), example as below.Is there a way I can make the all values become field names then give yes/no in each fields of the feature class? Feature Class Field 1 Field 2 Field 3 contour_height_pts surveydate elevation vert_datum contour_minor surveydate elevation vert_datum contour_major surveydate elevation vert_datum Drainage feature linetype instaldate modifydate Culvert linetype instaldate modifydateThank you 

I am looking at translation the local government information model into Postgis.The local government information model is delivered as an XML workspace document.I will greatly appreciate any insights into how I might accomplish this.

I need to organise a number of point objects that represent various built features like fireplaces, campsites and such. In their raw format the points are stacked on top of each other and we have so far arranged them in a nice group and then moved that somewhere appropriate, like over a lake or so. Finaly we ad a pointer that poins to the actual location. I would like to see if it would be posible to use FME to automate part of this process.I picture a system where points that are within a certain distance from each other get grouped together and then placed in a grid of 2, 3 or 4. The final symbols are in set size so we know the distance between the points for the scales we work in. The main goal here is to align the final symbols nicesly verticaly and horisontaly. Is there a way to do this?In the next step I would like to ad a pointer that points to midpoint of the point cluster above. What it the recomended method to do this?

HiI have 2 feature class namely community and parcel . I need to find out the overlap polygon with some tolerance say 0.1 sq.m. Kindly let me know how to find the same.Regards,K.Jayakumar

When passing approx. 1.300.000 features to the statistics calculator for calculating max features within groups of features, I receive this error:StatisticsCalculator_InputProcessor(TeeFactory): Cloned 1282424 input feature(s) into 1282424 output feature(s)<br>StatisticsCalculator_UnneededInputNuker(TeeFactory): Cloned 1282424 input feature(s) into 0 output feature(s)StatisticsCalculator_CompleteOutputter(SortFactory): Output 0 feature(s) without doing any sortingPython Exception <TypeError>: Overflow error for setAttribute().@Python failed to execute function `StatisticsCalculator.summarizeStatistics'StatisticsCalculator_SummaryCreator(CreationFactory): StatisticsCalculator_SummaryExploder: @Python execution failedCould it be a memory failure? And if so, can I circumvent this be eg. dividing my features into the groups that I already am trying to fetch the max value for? And how would i do that?Edit: When I lower the features to, say 800.000, the statistics calculator runs

Hello,I want to make a FME model in which the slope along bicycle routes is determined, as well as the direction of the slope (uphill/downhill). My idea: - dividing the network in small parts of +/- 50 metres long (LineDivider)- define the elevation of the start- and endpoint of the lines, as well as the direction - calculate the slope in between these points + directionAnyone who can help me with this?

I'm extracting data nightly from JSON services of which have no validation. These datasets have over 100 columns. Is there way to import a schema into the attribute validator so for every column it would test data type and max length? It would take forever to test data type, structure and max length for every column in every dataset, but my fme processes keep failing.

Hi,Is there an easy way way to mange the configuration files path? We are migrating our network shared drives where resides these configuration and we want to avoid to re-install FME Server. Regards.Etienne

I have a workbench that works for 300k entries but seems to run out memory for 1500k entries. The problem happens at the StatisticsCalculator level where I ask to calculte a mean using a group by an attribute. Does someone have an idea on how I can proceed in order to move further.. Thanks.

Folks,This is a question of cleanup and an answer here will decide what technology is best for dealing with this issue.I have a number of Mapinfo tables that should contain typical simple multi-SEGMENT polylines.However due to some sort of conversion or creation error some of the objects are mutli-SECTION polylines. For those unfamiliar with this object type what I mean is a series of LINES that don't perfectly start/end at the next line in the chain have been aggregated into a single object. For Mapinfo's pupose this looks like a single polyline but doesn't have the same properties. Each SECTION maintains it's individual "sub-geometry" within the multi-SECTION polyline.Now what's happening is that when these objects are converted via FME to DWG the only aggregate type DWG supports is a thing called a block. Now what I'm getting is few 100 blocks mixed with a few 1000 true polylines.As an aside the recipient of the DWG didn't know what these oddly

Is there a function or method for returning the date of the last Saturday of any given month? Input attribute would be formatted 'April 2018' or 'September 2019'. I'm currently doing this by manually inputting the correct dates in an AttributeCreator conditional statement. I'm looking for a method that would not require conitinual maintenance.

Hello,I meet with the problem.After I convert the revit rvt to rvz format,and then using FME to convert rvz to cesium b3dm format.The result can be view in cesium but the components are not separated but joined together.When I selected one of components of the model,the more components be selected.Therefore I want to know how to resolve this problem.Thanks a lot!