Hi everybody. Thank Jason for answering.
In fact, I’m working with cadastral data. My current database is PotgreSQL_PostGIS. We receive updates several times per year; I should integrate them in the DB. We are doing that manually each time we receive an update. It’s really hard: especially managing topological constraints for our needs (surveyors, architects, managers, etc. are using our DB). So, I was thinking we should be able to do update integration with FME. This is how we do it. Everything in our DB is polygon or line. Updates are coming to inform us that one polygon (lets say it is P) was replaced by other (one or often more than one: p1, p2, …). Each update file contains descriptive data (.txt file) and geometrical data (.dxf file). I should deactivate P and send its data to a history_Table. Data of new polygons (p1,p2, …) must replace previous data of P. So, I’m looking to extract data of the polygon P and replacing them with those of p1, p2,.. I must do the same process for each line of P and p1, p2,... That’s what I’m trying to do. I hope it’s clear. Please, if not tell me and I’ll send you more details. It’s easy to do with Java, or other programming language. But, FME should also do that : very challenging and interesting. Thanks. Abel. ----- Original Message ---- From: Jason Birch <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, July 26, 2007 6:43:32 PM Subject: RE: [fme] Extract and Copy data from a database table It should be. Are you sure you don't want to do this with straight SQL instead? It's easier... It's not too hard in FME though. Basically, you add the PostGIS database as both source data set and destination data set, exposing the appropriate source and destination tables as feature types. Then you use some kind of filter (depending on what rows you want to copy to the other table) by adding an appropriate transformer in the workspace or in the select/where parameters of the source table's feature type. If I understood you incorrectly, and you want to transfer all of the rows, then it's as easy as adding the source and destination feature types and connecting a line between them, and possibly remapping the column names. Perhaps explain your problem in more detail if this doesn't make sense? Jason -----Original Message----- From: abel.ludba Subject: [fme] Extract and Copy data from a database table Hello I'm working with PostgreSQL- PostGIS database. I'd like to extract data (some lines) from a table and copy it into other table. Is it possible to do that with FME? If yes, can you please tell me how? Thanks. Abel. For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl. blogspot. com. Love FME? Then open your diary to March 6-7, 2008 and write this... "Second Worldwide FME User Conference - Must Attend!" See http://www.safe. com/company/ fmeuc2008/ index.php for more details. Yahoo! Groups Links Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail at http://mrd.mail.yahoo.com/try_beta?.intl=ca
