6 - GIS-Lab

needmoreneedmoreΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 8 μήνες)

194 εμφανίσεις

6.3

Table
-
associated tools


When a table has been loaded, either from the “Project manager” or from the view, the

tools associated with the table will appear in the tool bar.







A new menu, called “Table”, will also be activated in the tool bar. This
can also be used
to

access the different tools.
































6.4

Adding a table from a CSV file


From version 0.5 onwards, gvSIG can read information contained in a plain text file,
whose

fields are separated by a semi
-
colon.



























To carry out this operation, go firstly to the “Project manager”. Select “Tables” and then

click on “New”. A search dialogue box will open. Click on “Add” and the file browser will
appear in a new window (select “csv string” in “Type of fi
le” to show the csv files).


























When the .csv file has been selected, click on “Open”.

If you click on
“Ok”, the data of the table you have added will be shown.


























6.5

Adding a table from a JDBC data origin


T
he contents of a data base table can be imported to gvSIG using data base managers

(PostgreSQL, MySQL, GBMS
-
HSQLDB, ODBC). gvSIG processes the information
obtained just like any other table.


Note: Oracle drivers installation is required for access to Ora
cle Spatial databases of
the

geoBD extension. Please follow the steps bellow:




Go to
Oracle Database 10g Release 2 (10.2.0.3) drivers
.




Accept the license terms.




In the next page, download the file
ojdbc14.jar

(1,545,954 bytes)
-

classes
for use
with J
DK 1.4 and 1.5.

(Registration required)




Move this file to the next folder:




Windows:




Move

the file to the
bin
\
gvSIG
\
extensiones
\
com.iver.cit.gvsig
\
lib
folder, that is in the directory where gvSIG is
installed.




Linux:




Move

the file to the
bin/gvSIG/
extensiones/com.iver.cit.gvsig/lib
folder, that is in the directory where gvSIG is
installed.


To load a table with the information obtained from a JDBC data origin you must:


Firstly, go to the "Project manager" and select "Tables". Then click on "New".



Select the “Data base” tab in the window that opens (“New table”) and configure the
data base server connection parameters:
































If

the information entered is correct, a new table will be created in gvSIG with the
information
contained in the original JDBC table.