1. Vertabelo
  2. Ideas
0
Completed

Support of type "geometry" among the field types

Oreste Tommasi 8 years ago • updated by Leandro DE SAN JUAN 2 years ago • 3
I am using Vertabelo to design spatial databases, and I would like to have the possibility of defining a "geometry".
Completed
Agnieszka Kozubek-Krycuń (Chief Scientist) 8 years ago
If you mean types like "point", "circle", "polygon" in Postgres, they are supported by Vertabelo. They are just not listed in the data type layer. The data type layer only lists the most popular data types. You can type names like "point" into data type field and Vertabelo will accept them.
Helton Nogueira Uchoa 8 years ago
I think the answer is not complete. Spatial databases use geometry types defined by Open Geospatial Consortium (http://www.opengeospatial.org/standards/sfa). Spatial SGBDs: PostGIS, Oracle Spatial, etc.
+2
Leandro DE SAN JUAN 2 years ago

Hello,

I am using Vertabelo in order to design spatial databases, but the field type "geometry" isn't alas parsed, leading to truncated tables when generating the diagram. I've edited in many ways the original imported SQL script unsuccessfully.

Any plan to have Vertabelo deal with OGC spatial types mentioned by Helton (eg: geometry(MultiPolygon|MultiLineString|Point|etc,[spatial_ref])?

Customer support service by UserEcho