HI:
I am working on an ETL project in which parcel datasets (polygons)
are being taken from a number of counties and ingested into an
ArcSDE spatial database. We want the process to be as automated as
possible. Here is how we would like it to go: parcel data from the
counties is placed on an ftp site, then at a certain time, the data
is downloaded from the ftp site to a folder on either a computer or
server, then the data is manipulated in FME Workbench to extract the
necessary attribution and then dumped into our ArcSDE spatial
database. Once all the counties data has been initially downloaded
and put into SDE, periodically we would want the process to run, to
check for updates to the parcel data, i.e., new parcels, change of
attribution.
I have been able to successfully ETL two counties data into SDE
using FME Workbench. The problem I have run into with other
datasets is the fact that the dataset (shapefile and personal
geodatabase feature classes) have polygons with bad geometry that
Workbench does not like. I have been able to fix the geometry
problems using ArcGIS—ArcToolbox--Repair Geometry. Is their a
function in FME Workbench that will do the same thing, essentially
fixing polygons with bad geometry, such as sliver, self
intersections, and short segments?
If not, does anyone know if it is possible and how it can be done,
to do the following: once the files are ftp'd from the county, tell
ArcToolbox to check the geometry and repair if necessary and then
have FME Workbench startup and perform the ETL on the dataset and
load the finished data into SDE? Each county would have an .fmw
already created for each county, based on the initial dataset we
get. The transformers I am using in Workbench are pretty straight
forward, mostly copying and creating attributes. I am not much of a
programmer and know very little about scripts and programming
language, so I am not sure how this could be done, any help or
advice anyone would have would be greatly appreciated.
Thanks much,
Brandon
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.
Safe Software has also made slides available that outline enhancements planned
for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2
of the FME Worldwide Users Conference. To view these slides, visit
www.safe.com/2006uc.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/fme/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
