[Gvsig_english] GvSig connection to Access Database

[Sara Tagaduan]

Hi Mario,

Thank you so much for your help. But my question is regarding the actual
form in which the latitude and longitude need to be introduced in the
table, so that gvsig will recognize them as coordinates. I have tried
multiple forms and nothing seems to be working. I have tried using the
symbols for degrees, minutes and seconds between the numbers, I have also
tried using points and commas to separate them.

Best regards,
Sara

On Thu, Jun 14, 2018 at 11:52 AM, Mario Carrera <mcarrera at gvsig.com> wrote:

>
> 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 at 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-municipalit
>> y-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
>> 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
>>
>> 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 listGvsig_internacional at 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
>>
>> _______________________________________________
>> Gvsig_internacional mailing list
>> Gvsig_internacional at 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
>>
>>
>
>
> _______________________________________________
> Gvsig_internacional mailing listGvsig_internacional at 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
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20180625/99d1434f/attachment.html>