[Gvsig_english] GvSig connection to Access Database
Mario Carrera
mcarrera at gvsig.com
Thu Jun 14 12:52:28 CEST 2018
Hi Sara!
you can create an event layer in EPSG 4326 without problem. It's the
same than in UTM.
For that you have two options:
- Loading the CSV file from the Project manager and "Table" document,
and then from a View in 4326 you access to the "Event layer" option.
Then you select the CSV file, and "Latitude" for "Y" and "Longitude" for
"X". It's a virtual layer because it's a table, you will have to export
it to SHP format to have a point layer.
- In a View in 4326 you access to "Add layer", and from "File" you add
the CSV file. You select it at that window and accessing to Properties,
and "Geometry" tab, you can select fields for Latitude and Longitude.
It's also a virtual layer because it's a table, so you will have to
export it to SHP format to have a point layer.
Best regards,
Mario
El 13/06/18 a las 00:55, Sara Tagaduan escribió:
> Hello!
>
> I am having some trouble with creating an event layer in gvSig while
> working in EPSG 4326. To create an the layer I need to introduce the
> coordinates in the table, but the program does not recognize them. I
> think it requires latitude and longitude in the form of DMS (degrees,
> minutes, seconds). Could you please give me an example on how the
> coordinates should be introduced in the CVS file? I have watched
> several tutorials on the gvSig blog, but everything seems to be in UTM.
>
> Thank you in advance!
>
> Best regards,
> Sara
>
> On Mon, Jun 4, 2018 at 12:13 PM, Mario Carrera <mcarrera en gvsig.com
> <mailto:mcarrera en gvsig.com>> wrote:
>
>
> Hello Sara,
>
> the current Java version, Java 8, that is included in gvSIG,
> doesn't support ODBC connections. In that way it was possible to
> connect to Access databases, but it's not possible now. If there's
> an entity interested in financing that development it would be done.
>
> In addition, there's a way to load the data from the table in
> gvSIG, that is exporting to DBF or CSV files previously. They can
> be added as a point layer in gvSIG, using the coordinates of the
> table.
>
> There are two ways:
>
> 1. Event layer: Here you can see how to do it:
> https://blog.gvsig.org/2018/02/01/gis-applied-to-municipality-management-module-8-2-creation-of-point-layers-from-tables-event-layers/
> <https://blog.gvsig.org/2018/02/01/gis-applied-to-municipality-management-module-8-2-creation-of-point-layers-from-tables-event-layers/>
>
> You can export the event layer to shapefile later.
>
> 2. Adding the table as layer: For that you can access to "Add
> layer", then from the "File" tab you select the CSV or DBF file,
> and you access to the "Properties" button. At the "Geometry" tab
> you can select the fields with X and Y coordinates. Here you have
> a video about that (it's in Spanish but it will be useful to find
> the menus):
> https://youtu.be/SzIm7daWQsg?t=362
> <https://youtu.be/SzIm7daWQsg?t=362>
> You can export the CSV or DBF layer to shapefile later.
>
> The DBF file can be edited later from gvSIG directly, and you can
> edit its alphanumerical information.
>
> If you export it to shapefile you can edit it too. Here you can
> see how to do it
> https://youtu.be/obKRB3flUlM?t=338
> <https://youtu.be/obKRB3flUlM?t=338>
>
> Best regards,
> Mario
>
>
>
>
>
> El 04/06/18 a las 11:42, Sara Tagaduan escribió:
>> To whom it may concern,
>>
>> I am currently working on a project in gvSig and I am having some
>> difficulties in establishing a link between the program and a
>> Access Database. The Access file contains fields as "Site name",
>> "Site type", "Monument type" and UTM Coordinates. For every site
>> I need a point introduced at the corresponding coordinates, and
>> the site name, type and monument type as attributes.
>>
>> Is there any way I can import the information in gvSig as a table
>> without having to introduce every bit of information manually?
>> And if so, could the program update the table automatically when
>> new information is inserted in the Access file? If gvSig does not
>> support a connection with Access, what would be the best solution
>> for my problem?
>>
>> Thank you in advance.
>>
>> Best regards,
>> Sara
>>
>>
>>
>> _______________________________________________
>> Gvsig_internacional mailing list
>> Gvsig_internacional en listserv.gva.es
>> <mailto:Gvsig_internacional en listserv.gva.es>
>>
>> To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
>>
>> https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>> <https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional>
>
> --
>
> *Mario Carrera*
>
> Training, Language and Communication Manager. gvSIG Association
>
> Responsable de Formación, Internacionalización y Difusión.
> Asociación gvSIG
>
> http://www.gvsig.com <http://www.gvsig.com/>
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional en listserv.gva.es
> <mailto:Gvsig_internacional en listserv.gva.es>
>
> To see the archives, edit your preferences or unsubscribe from
> this mailing list, please access this url:
>
> https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
> <https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional>
>
>
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional en listserv.gva.es
>
> To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
>
> https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
--
*Mario Carrera*
Training, Language and Communication Manager. gvSIG Association
Responsable de Formación, Internacionalización y Difusión. Asociación gvSIG
http://www.gvsig.com <http://www.gvsig.com/>
------------ pr�xima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20180614/22a27796/attachment.html>
More information about the Gvsig_internacional
mailing list