<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<br>
<br>
Hi Sara, <br>
<br>
if you want to use latitude and longitude values in a CSV file to be
recognized by gvSIG, you should have them as a decimal value in
decimal degrees (not degrees, minutes and seconds).<br>
<br>
The decimals separator to be used will depend on the language you
select in the "Regional configuration" option. "English"
configuration usually uses "." and "Spanish" uses ",". Make sure
that the decimal separator you use is not the same than the field
separator in the CSV. Normally with the regional configuration in
English you will not have problems with the field separator.<br>
<br>
About using decimal degrees, you can find more information on:<br>
<br>
<a class="moz-txt-link-freetext" href="https://www.rapidtables.com/convert/number/degrees-minutes-seconds-to-degrees.html">https://www.rapidtables.com/convert/number/degrees-minutes-seconds-to-degrees.html</a><br>
<br>
To load the CSV in gvSIG you must load it as a layer, and in the
"Add layer" dialog, access to Properties button.<br>
It adjusts the values of regional configuration and fields separator
as it corresponds, and you have to press on "Preview".<br>
When you see the preview table correctly, in the "Geometry" tab
select "Columns with values for X, Y, Z", and select the field
Longitude for X and Latitude for Y.<br>
<br>
I attach an example of a CSV file with geographic coordinates if you
want to check it. <br>
<br>
Let us know if it works. <br>
<br>
Best regards,<br>
Mario<br>
<br>
<br>
<div class="moz-cite-prefix">El 25/06/18 a las 11:53, Sara Tagaduan
escribió:<br>
</div>
<blockquote type="cite"
cite="mid:CAAooY8gPUszSQto1H8V14YynE2hpcyNtXXn+XeDrZXHzxXnyZQ@mail.gmail.com">
<div dir="ltr">Hi Mario,
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Best regards,</div>
<div>Sara</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Jun 14, 2018 at 11:52 AM, Mario
Carrera <span dir="ltr"><<a
href="mailto:mcarrera@gvsig.com" target="_blank"
moz-do-not-send="true">mcarrera@gvsig.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> <br>
Hi Sara!<br>
<br>
you can create an event layer in EPSG 4326 without
problem. It's the same than in UTM. <br>
<br>
For that you have two options: <br>
<br>
- 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. <br>
<br>
- 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. <br>
<br>
Best regards, <br>
Mario <br>
<br>
<br>
<br>
<div class="m_-8500992563338115194moz-cite-prefix">El
13/06/18 a las 00:55, Sara Tagaduan escribió:<br>
</div>
<div>
<div class="h5">
<blockquote type="cite">
<div dir="ltr">Hello!
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thank you in advance!</div>
<div><br>
</div>
<div>Best regards,</div>
<div>Sara</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Jun 4, 2018 at
12:13 PM, Mario Carrera <span dir="ltr"><<a
href="mailto:mcarrera@gvsig.com"
target="_blank" moz-do-not-send="true">mcarrera@gvsig.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> <br>
Hello Sara, <br>
<br>
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. <br>
<br>
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. <br>
<br>
There are two ways: <br>
<br>
1. Event layer: Here you can see how to do
it: <a
class="m_-8500992563338115194m_5348759563145733506moz-txt-link-freetext"
href="https://blog.gvsig.org/2018/02/01/gis-applied-to-municipality-management-module-8-2-creation-of-point-layers-from-tables-event-layers/"
target="_blank" moz-do-not-send="true">https://blog.gvsig.org/2018/02<wbr>/01/gis-applied-to-municipalit<wbr>y-management-module-8-2-<wbr>creation-of-point-layers-from-<wbr>tables-event-layers/</a>
<br>
You can export the event layer to shapefile
later. <br>
<br>
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): <br>
<a
class="m_-8500992563338115194m_5348759563145733506moz-txt-link-freetext"
href="https://youtu.be/SzIm7daWQsg?t=362"
target="_blank" moz-do-not-send="true">https://youtu.be/SzIm7daWQsg?t<wbr>=362</a><br>
You can export the CSV or DBF layer to
shapefile later. <br>
<br>
The DBF file can be edited later from gvSIG
directly, and you can edit its
alphanumerical information. <br>
<br>
If you export it to shapefile you can edit
it too. Here you can see how to do it <br>
<a
class="m_-8500992563338115194m_5348759563145733506moz-txt-link-freetext"
href="https://youtu.be/obKRB3flUlM?t=338"
target="_blank" moz-do-not-send="true">https://youtu.be/obKRB3flUlM?t<wbr>=338</a>
<br>
<br>
Best regards, <br>
Mario <br>
<br>
<br>
<br>
<br>
<br>
<div
class="m_-8500992563338115194m_5348759563145733506moz-cite-prefix">El
04/06/18 a las 11:42, Sara Tagaduan
escribió:<br>
</div>
<blockquote type="cite">
<div>
<div class="m_-8500992563338115194h5">
<div dir="ltr">To whom it may concern,
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Thank you in advance.</div>
<div><br>
</div>
<div>Best regards,</div>
<div>Sara </div>
<div><br>
</div>
</div>
<br>
<fieldset
class="m_-8500992563338115194m_5348759563145733506mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<pre>______________________________<wbr>_________________
Gvsig_internacional mailing list
<a class="m_-8500992563338115194m_5348759563145733506moz-txt-link-abbreviated" href="mailto:Gvsig_internacional@listserv.gva.es" target="_blank" moz-do-not-send="true">Gvsig_internacional@listserv.g<wbr>va.es</a>
To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
<a class="m_-8500992563338115194m_5348759563145733506moz-txt-link-freetext" href="https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank" moz-do-not-send="true">https://listserv.gva.es/cgi-bi<wbr>n/mailman/listinfo/gvsig_inter<wbr>nacional</a><span class="m_-8500992563338115194HOEnZb"><font color="#888888">
</font></span></pre>
<span class="m_-8500992563338115194HOEnZb"><font
color="#888888"> </font></span></blockquote>
<span class="m_-8500992563338115194HOEnZb"><font
color="#888888"> <br>
<div
class="m_-8500992563338115194m_5348759563145733506moz-signature">--
<br>
<p
style="margin-bottom:0cm;line-height:100%"><font
face="Verdana, sans-serif"><font
style="font-size:10pt" size="2"><b>Mario
Carrera</b> </font></font> </p>
<p
style="margin-bottom:0cm;line-height:100%"><font
face="Verdana, sans-serif"><font
style="font-size:10pt" size="2">Training,
Language and Communication
Manager. gvSIG Association </font></font>
</p>
<p
style="margin-bottom:0cm;line-height:100%"><font
face="Verdana, sans-serif"><font
style="font-size:10pt" size="2">Responsable
de Formación,
Internacionalización y Difusión.
Asociación gvSIG </font></font>
</p>
<p
style="margin-bottom:0cm;line-height:100%"><a
href="http://www.gvsig.com/"
target="_blank"
moz-do-not-send="true"><font
face="Verdana, sans-serif"><font
style="font-size:10pt"
size="2">http://www.gvsig.com</font></font></a>
</p>
</div>
</font></span></div>
<br>
______________________________<wbr>_________________<br>
Gvsig_internacional mailing list<br>
<a
href="mailto:Gvsig_internacional@listserv.gva.es"
target="_blank" moz-do-not-send="true">Gvsig_internacional@listserv.g<wbr>va.es</a><br>
<br>
To see the archives, edit your preferences or
unsubscribe from this mailing list, please
access this url:<br>
<br>
<a
href="https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://listserv.gva.es/cgi-bi<wbr>n/mailman/listinfo/gvsig_inter<wbr>nacional</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset
class="m_-8500992563338115194mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>_________________
Gvsig_internacional mailing list
<a class="m_-8500992563338115194moz-txt-link-abbreviated" href="mailto:Gvsig_internacional@listserv.gva.es" target="_blank" moz-do-not-send="true">Gvsig_internacional@listserv.<wbr>gva.es</a>
To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
<a class="m_-8500992563338115194moz-txt-link-freetext" href="https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank" moz-do-not-send="true">https://listserv.gva.es/cgi-<wbr>bin/mailman/listinfo/gvsig_<wbr>internacional</a>
</pre>
</blockquote>
<br>
<div class="m_-8500992563338115194moz-signature">-- <br>
<p style="margin-bottom:0cm;line-height:100%"><font
face="Verdana, sans-serif"><font
style="font-size:10pt" size="2"><b>Mario
Carrera</b> </font></font> </p>
<p style="margin-bottom:0cm;line-height:100%"><font
face="Verdana, sans-serif"><font
style="font-size:10pt" size="2">Training,
Language and Communication Manager. gvSIG
Association </font></font> </p>
<p style="margin-bottom:0cm;line-height:100%"><font
face="Verdana, sans-serif"><font
style="font-size:10pt" size="2">Responsable de
Formación, Internacionalización y Difusión.
Asociación gvSIG </font></font> </p>
<p style="margin-bottom:0cm;line-height:100%"><a
href="http://www.gvsig.com/" target="_blank"
moz-do-not-send="true"><font face="Verdana,
sans-serif"><font style="font-size:10pt"
size="2">http://www.gvsig.com</font></font></a>
</p>
</div>
</div>
</div>
</div>
<br>
______________________________<wbr>_________________<br>
Gvsig_internacional mailing list<br>
<a href="mailto:Gvsig_internacional@listserv.gva.es"
moz-do-not-send="true">Gvsig_internacional@listserv.<wbr>gva.es</a><br>
<br>
To see the archives, edit your preferences or unsubscribe
from this mailing list, please access this url:<br>
<br>
<a
href="https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://listserv.gva.es/cgi-<wbr>bin/mailman/listinfo/gvsig_<wbr>internacional</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<!--'"--><br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Gvsig_internacional mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a>
To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
<a class="moz-txt-link-freetext" href="https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">https://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a>
</pre>
</blockquote>
</body>
</html>