Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,310 Posts
  • 26,856 Replies
7310 Posts
inovacaogis
 Data
alanaliberti
Contributor
alanalibertiContributor
 Data
christian_b
 Data
sobanmughal
 Data
brajnilam
 Data
update xml columns with multiple if conditions

i am trying to update xml column in oracle and getting errors which i am not able to resolve . need some help hereif the data exists there and $t/row/c178[@m=82]='USA' then only update the value or do nothing    update USER.TABLE t1set t1.xmlrecord=XMLQuery('copy $t := . modify (if fn:exists /row/c2 then replace value of node $t/row/c2 with concat("firstname",$t/row/@id) else(),if fn:exists /row/c3 then replace value of node $t/row/c3 with concat("lastname",$t/row/@id) else(),if fn:exists /row/c178[@m=83] and $t/row/c178[@m=82]='USA' then replace value of node $t/row/c178[@m=83] with ("NEW YORK") else() ,if fn:exists /row/c4 and $t/row/c178[@m=82]='USA' then replace value of node $t/row/c4 with ("Manhattan")else() ,if fn:exists /row/c5 and $t/row/c178[@m=82]='USA' then replace value of node $t/row/c5 with concat ("NY 10036, USA.",$t/row/@id) else(),)return $t'passing t1.xmlrecordreturnin

1501
cezhang
 Data
gauripearl
 Data
maartenwdod
 Data
chris2
 Data
Transforming ArcSDE MSSQL data to FGDB

Hi,I'm trying to create a dynamic workspace to create file geodatabase extracts of data out of ArcSDE. Ideally, I would like to make use of change detection in some form, so that data that hasn't changed doesn't get processed for no reason. Even more ideally, I'd like to query the database system tables to quickly narrow down what objects have experienced any change (I have some ideas on how to satisfy the second part, but haven't gotten to it yet).The SDE extracts in FGDB form will end up on a network share and be replicated out to the users.This article is pretty much what I want to do, I think.https://knowledge.safe.com/articles/1157/dynamic-workflow-tutorial-destination-schema-as-a.htmlI have to presume that I don't know the schema, nor the quality of the data, in an effort to make this flexible for the many SDE databases we're running this for.My workspace looks like this: Where I'm getting stuck, right now anyway, is applying the delete operation t

723
jovitaatsafe
Safer
harmen_kampinga
harmen_kampinga
 Data
cainostroza
 Data
mr_fme
Enthusiast
mr_fmeEnthusiast
 Data
asabhinavgreats
 Data
gauripearl
 Data
atle_hoidalen
atle_hoidalen
 Data
Unwanted result using the pointcloudsurfacebuilder with poisson construction mode

Hi guys,I have this point cloud that I have filtered and clipped so that only vegetation areas remain. These areas I want to build a mesh of so that I can import this as a 3D-model into another software. I use the pointcloudsurfacebuilder for this purpose. Using construction mode "simple triangulation", everything works fine, a separate mesh is created for eache area of vegetation.This mesh is quite coarse so I want to use constrouction mode "poisson" instead. This creates a much smoother mesh, only problem is that it also creates a rectancular surface around the whole extents of my pointcloud thus making the mesh useless for me.Anyone here who can help me sort this issue? See attached screenshots of both results.  

1278
atle_hoidalen
gerenciaitssa
 Data
bo
Contributor
boContributor
 Data
till
 Data
saving a single polygon as dxf from an array of polygons.

Dear Users,  I am trying to save a single polygon as a dxf file with a given file name out an array of polygons. My Array is 28 rows by 350 columns, this makes 9800 polygons.  Rows are numbered +14 to -14. they are divided by a centre line, north of this line numbers are positive, south of this line numbers are negative. Columns are labelled Alphabetically, i.e.: A, B, C ... Y, Z, AA, AB, AC ... AY, AZ, BA, BB, BC and so on until ML.  My goal is to save each polygon in a separate dxf file. the name of the file should correspond with the "coordinate" within the array, i.e. "AA_+01" , "BO_-13" , "ML_+11". I am completely new to the FME environment and I ahve no idea where to start this task. I do believe that this action is relatively straight-forward for an experienced user.I am grateful for any help regarding this task.  Kind regards,Till  

411
redgeographics
VIP
destest
 Data
gisuser
Participant
gisuserParticipant
 Data
Writing a GBD relationship class

Hi FME Experts, I am trying to write a Geodatabase relationship class between feature class and stand-alone table but it could not be created, it gives me a below error :"Unable to create table/feature class/relationship class of type 'geodb_invalid'. Creation of this type is not currently supported by FME, and must be done through Esri toolsGeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures(SortFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsSome error has occurred closing the pipeline factory, see previous warningTransaction #1 rolled back. Rerun translation specifying transaction #0 for the keyword 'TRANSACTION'Some error has occurred closing the pipeline factory, see previous warningA fatal error has occurred. Check the logfile above for details" Note :I have followed the steps and recommendation points in the article https://knowledge.safe.com/art

2011
fgiron
Enthusiast
bozboswell
Contributor
bozboswellContributor
 Data
Reading a featureservice using credentials or using token

I am trying to simply read a featureservice that I need to make periodic downloads of. This featureservice needs authentication. I can pull a token using part of this example (arcgis-server-feature-service-reader-token-authent) but I cannot seem to figure out how to hold the token as a parameter to feed to "ESRI ArcGIS Server Feature Service" transformer. I have also tried using a FeatureReader (using username/password) but am having issues not seeing the attributes. I do not fully understand using lists (if that is the issue).So, I need some help with either being able to create a token and save as parameter to feed to another transformer or pull attributes from the featureservice using a FeatureReader transformer.If you have any suggestions, I would be very appreciative.

4352
bozboswell
Contributor
gauripearl
 Data
milovanovstevan
 Data
CityGML textures and TIN Relief issues

Hello FME Community!I'm having following issues: my transformation schema generates CityGML Feature Type TIN Relief, and I want to drape ortophoto image over it. Also, i have generated buildings and want to drape roof textures over the roofs from the same ortophoto image. When I try to open draped TIN relief within the transformation schema (with an inspector in the end) it works. However, when i want to open cityGML later, the textures don't show. Also, TIN Relief refuses to import into 3d city database. SRID for the data is 31277.I am uploading my schema, data and generated cityGML that I'm getting from the schema (https://mega.nz/#!hY9QRIyT!0rfDxD5mvrMFr0hoZyUp8PjCrebtuDUYhglsIMH-NAA). I need help with this issue and maybe correct the schema in order to make TIN Relief available to import to database with textures. If anyone has an idea how to add only roof textures to RoofSurface from the ortophoto i'd appreciate help with that too.Thank you in advance,Stevan

2766
eliseb
 Data
linasster
 Data
Show more activity

Badge Winners

Show all badges

Community Stats

32,869
Posts
124,720
Replies
41,486
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.