[Gvsig_english] gvSIG, geoBD and oracle spatial: possibility to setgeometry column?

[Juan Lucas Dominguez Rubio]

Hello, Wolfgang
 
No. Currently it's not possible to decide the name of the geometry column when you export a layer to Oracle Spatial. As you know, the user is asked in two different dialogs for the table name and whether the coordinate system of the view should be stored.
 
I think it would be a good idea to merge those dialogs and create a big dialog where the user could decide:
 
- table name
- whether to save the coordinate system of the view or not
- name of the geometry column
- table's bounding box (choose between: copy the layer's full extent, or compute the full extent of the features. Sometimes layers have a wrong full extent)
- tolerance (this is also in the table's metadata, usually set to a very small number, and has a special treatment when the coordinate system is in degrees)
- perhaps, the user could also make some decision about the dimensions of the geometries. For example, if you have a 3D shapefile but you only want 2D geometries in Oracle, or maybe you have a 2D shapefile and you want to add a Z value for each vertex somehow... well, maybe this is going too far ;)
 
I hope my response was not too long !!
Regards,
 
 
 
Juan Lucas Domínguez Rubio
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Wolfgang Qual
Enviado el: vie 25/04/2008 9:09
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] gvSIG, geoBD and oracle spatial: possibility to setgeometry column?



Hi list,
just a very short question: is it possible to set the name of the geometry column when exporting a (shapefile)layer to an Oracle Database? AFAIK, gvSIG sets the name of that column to "geometry". However, other applications call it "the_geom" or "geom". Short answer would be great!
Best regards,
Wolfgang


--
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf@gmx
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5812 bytes
Desc: not available
Url : http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20080425/6f73c72b/attachment.bin