Skip to main content
Question

TINgenerator

  • March 11, 2013
  • 10 replies
  • 104 views

Hello,   After reading the doc, I realize that no output format is specified for the module TINgenerator. I found the .VRML or the .PDF3D (which does not interest me).   Are there any other format that I have missed?   Thank you.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

10 replies

david_r
Celebrity
  • March 11, 2013
Hi,

 

 

the TINGenerator outputs 3-dimensional points, lines and polygons. A great number of the output formats (writers) in FME support these basic geometry types.

 

 

What are your requirements for the final output?

 

 

David

  • Author
  • March 11, 2013
I want an output format compatible with Oracle to try to incorporate the TIN in Oracle.

 

 

The goal is to transform a LiDAR file in a TIN file with FME and then store it in Oracle.

 

 

Thx.

david_r
Celebrity
  • March 11, 2013
If you need to store your geometries in Oracle Spatial, try using the "Oracle Spatial Object" writer (short name is "ORACLE8I").

 

 

Refer to the target application requirements to see if you need all the geometries or if just the polygons suffice.

 

 

David

Forum|alt.badge.img+2
  • March 11, 2013
You'll need the Oracle Database Edition to write directly to Oracle. You can store point clouds in Oracle too!

  • Author
  • March 11, 2013
Ok, for the moment it's already possible to store the LAS file in point clouds in Oracle (SDO_PC) but I would like to store the LAS file directly in SDO_TIN in Oracle ...

david_r
Celebrity
  • March 11, 2013
If the following conditions are met:
  • Your point cloud data is already stored in Oracle
  • The amount of data is relatively large/huge
  • You need to repeat the TIN processing on a regular basis
then it might be interesting to try and generate the TIN directly in Oracle, using an SQL script and the SDO_TIN_PKG.CREATE_TIN() function. Processing the data in the database could potentially be faster by an order or magnitudes, as you would avoid extracting and loading the data each time.

 

 

David

  • Author
  • March 11, 2013
Yes the function was known, but I wanted to get in 11g rev2 directly import LAS TIN without necessarily going through the pointcloud (and using breaklines), but for this, it will apparently wait for version 12.1 of Oracle.   Thank you for your answers.

Forum|alt.badge.img
  • February 24, 2016
If you need to store your geometries in Oracle Spatial, try using the "Oracle Spatial Object" writer (short name is "ORACLE8I").

 

 

Refer to the target application requirements to see if you need all the geometries or if just the polygons suffice.

 

 

David

Hi David,

I wonder if u can help me

I do have a large point cloud; more than 11,800,000 points, and I want to generate 3D TIN for it using FME TINGenerator transformer

Can u advise the best way to do so? I tried a lot and I was not successful.

Also, it is really important for me to visualize my results in 3D in color, so what is the best software u recommend to visualize my writer/outpout 3D TIN ?

Also, I tried Raster (since, I m really after the triangulation)!

My final target is visualizing my point cloud in 3D TIN in color.

Regards,


redgeographics
Celebrity
Forum|alt.badge.img+62

Hi David,

I wonder if u can help me

I do have a large point cloud; more than 11,800,000 points, and I want to generate 3D TIN for it using FME TINGenerator transformer

Can u advise the best way to do so? I tried a lot and I was not successful.

Also, it is really important for me to visualize my results in 3D in color, so what is the best software u recommend to visualize my writer/outpout 3D TIN ?

Also, I tried Raster (since, I m really after the triangulation)!

My final target is visualizing my point cloud in 3D TIN in color.

Regards,

Hi @heikal could you maybe create a new question for this, I think that would make it easier to keep track of things. If you do, please also be a bit more specific as to what's happening. Does the TinGenerator not output anything at all, or not what you expected?


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • February 25, 2016

Hi,

Tin related object types.

http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_objrelschema.htm#CBBFDFCJ

I

According to the FME Readers and writer bible section

Oracle Spatial Relational Writer Parameters :

"Oracle Spatial directly supports composite surfaces, 3D polygons and rectangles. Writing of 3D surfaces and solids is available only for Oracle 11g. If the Oracle Spatial writer detects a version of Oracle Database older than version 11g, surface features will automatically be downgraded to a 2D representation prior to writing."

Suggesting that it can write a TIN surface.

@heikal

You can directly connect the pointcloud to the point/lines inputport and have it generate a TIN.

You can write TIN to autocad as wel and view it, to a couple of mil point-Tin wil have Autocad running into fits..lol.