1. Vertabelo
  2. Idées
0
Terminé

Support of type "geometry" among the field types

Oreste Tommasi il y a 10 ans • mis à jour par Leandro DE SAN JUAN il y a 4 ans • 3
I am using Vertabelo to design spatial databases, and I would like to have the possibility of defining a "geometry".
Terminé
Agnieszka Kozubek-Krycuń (Chief Scientist) il y a 10 ans
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 il y a 10 ans
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 il y a 4 ans

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])?

Service d'assistance aux clients par UserEcho