User contributions
From ecology
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 09:24, 9 May 2008 (diff | hist) . . (10,976 bytes) . . RADAR (→COVERAGE_DIAGRAM)
- 09:19, 9 May 2008 (diff | hist) . . (10,961 bytes) . . RADAR (→Description of tables in RADAR scheme in Flysafe database)
- 09:18, 9 May 2008 (diff | hist) . . (140 bytes) . . Flysafe Data Model (→Flysafe Data Model)
- 09:18, 9 May 2008 (diff | hist) . . (19 bytes) . . Medium Power Radar (Medium Power Radar moved to RADAR) (current)
- 09:18, 9 May 2008 (diff | hist) . . (10,934 bytes) . . m RADAR (Medium Power Radar moved to RADAR)
- 09:16, 9 May 2008 (diff | hist) . . (10,934 bytes) . . RADAR (→RADAR scheme in Flysafe database)
- 09:15, 9 May 2008 (diff | hist) . . (10,909 bytes) . . RADAR (→RADAR)
- 09:13, 9 May 2008 (diff | hist) . . (10,848 bytes) . . RADAR (→RADAR)
- 09:13, 9 May 2008 (diff | hist) . . (10,842 bytes) . . RADAR (→Data model for Motion Analyses images collected with ROBIN-system)
- 09:11, 9 May 2008 (diff | hist) . . (260 bytes) . . E-Ecology Documentation and Guidance (→FlySafe Documentation Wiki)
- 09:09, 9 May 2008 (diff | hist) . . (66 bytes) . . Usage (New page: == Database Issues == * Connecting to the Flysafe database )
- 09:09, 9 May 2008 (diff | hist) . . (empty) . . Database (→Database Issues) (current)
- 09:07, 9 May 2008 (diff | hist) . . (295 bytes) . . E-Ecology Documentation and Guidance (New page: == FlySafe Documentation Wiki == Usage Flysafe Data Model Services == Getting started == New to MediaWiki? Print out this [[Media:MediaWikiRefCard.pdf|quick refere...)
- 09:00, 9 May 2008 (diff | hist) . . (21 bytes) . . MediaWiki:Mainpage (New page: Flysafe documentation) (current)
- 08:51, 9 May 2008 (diff | hist) . . (10,807 bytes) . . RADAR (→TRACK_RESULT)
- 08:50, 9 May 2008 (diff | hist) . . (10,817 bytes) . . RADAR (→TRACK_RESULT)
- 08:42, 9 May 2008 (diff | hist) . . (10,320 bytes) . . RADAR (→MA-images)
- 15:34, 7 May 2008 (diff | hist) . . (10,331 bytes) . . RADAR (→Quality parameters:)
- 15:34, 7 May 2008 (diff | hist) . . (10,334 bytes) . . RADAR (→BEAM)
- 15:20, 7 May 2008 (diff | hist) . . (9,861 bytes) . . RADAR (→RADAR)
- 15:14, 7 May 2008 (diff | hist) . . (9,941 bytes) . . RADAR (→Data model for MA images collected by ROBIN4 system .)
- 15:10, 7 May 2008 (diff | hist) . . (10,004 bytes) . . RADAR (→Data Model for RADAR scheme)
- 15:02, 7 May 2008 (diff | hist) . . (68 bytes) . . RADAR (New page: == Data Model for RADAR scheme == Image : Radar_datamodel.png )
- 15:01, 7 May 2008 (diff | hist) . . (27 bytes) . . File:Radar datamodel.png (Data model for radar scheme) (current)
- 14:28, 7 May 2008 (diff | hist) . . (10,515 bytes) . . Argos Data Model (→GPS Data Model)
- 14:23, 7 May 2008 (diff | hist) . . (9,962 bytes) . . Argos Data Model (→Table MEASUREMENT)
- 14:22, 7 May 2008 (diff | hist) . . (10,546 bytes) . . Argos Data Model (→Table MEASUREMENT)
- 14:20, 7 May 2008 (diff | hist) . . (10,535 bytes) . . Argos Data Model (→GPS Data Model)
- 14:19, 7 May 2008 (diff | hist) . . (10,538 bytes) . . Argos Data Model (→GPS Data Model)
- 14:16, 7 May 2008 (diff | hist) . . (10,450 bytes) . . Argos Data Model (→GPS Data Model)
- 12:05, 6 May 2008 (diff | hist) . . (152 bytes) . . Flysafe Data Model
- 11:49, 6 May 2008 (diff | hist) . . (38 bytes) . . File:Connect flysafe.doc (uploaded a new version of "Image:Connect flysafe.doc": <!-- Connecting to the FlySafe database via Access or other relational database programs Judy Shamoun-Baranes Last updated: December 11, 2007 General Information The Flysafe database is a spatial postgreSQL (http://www.postgresql.org/). PGAdmin can be used to browse and query data. If you use pgadmin you do not need to set up an ODBC connection. Database can also be called from other programs by installing an ODBC driver for postgreSQL and establishing a "User Data Source" http://www.postgresql.org/ftp/odbc/versions/msi/ In order to access the database your IP address must be sent to Bart Heupers who will provide a user name and password. For organizations an IP range can also be given. Flysafe server information server : flysafe-pps.grid.sara.nl port 5432 ssl required The tracking data can be found in schema "gps". However these instructions can be followed for any of the data included in the flysafe database. Setting up an ODBC connection ODBC (Open Database connectivity) is a standard method of sharing data between databases and other programs. ODBC drivers use SQL to gain access to data from sources outside the program. Therefore, in order to connect between your database and other programs you must set up an ODBC connection. Step 1: Download and install an ODBC driver for postgreSQL. http://www.postgresql.org/ftp/odbc/versions/msi/ Step 2: Set up ODBC connection Do the following: 1. go to start | Control panel | Administrative tools | Data sources (ODBC) 2. go to User DSN (first tab in Data sources) 3. click ADD 4. in window create new data source select PostgreSQL ANSI click FINSH 5. The ODBC Driver setup window opens. Data source name: give your data source a name (eg GPS). Keep it simple, easily identifiable, this is the name you will use to identify your database from other applications, this will be the ODBC driver name. 6. In the same window fill in the following information: database flysafe, Server flysafe-pps.grid.sara.nl, User Name your user name, SSL Mode require, Port 5432, Password your password. When the window is completed click SAVE 7. Back in the User DSN window you should now see your ODBC driver you just named, click OK After completing these steps many other programs will now recognize your database and be able to communicate with it Connecting to Access You can now connect to the database via access. You have two options. One is to import the data, once this is done your database is not automatically updated but does not require a link to the database. The second option (described below) is to create a dynamic link to the database (you must be connected to the network) in this case you are always viewing data that is in the actual SARA database. 1. Open a new database in Access 2. go to file | Get external data | Link tables 3. in files of type select ODBC databases 4. in select data source click on tab Machine Data Source 5. select the data source name you created when setting up the ODBC connection (eg GPS) click OK 6. Select the tables you want to import click OK You now have access to your selected tables in the database. Have fun. --> <!-- -->) (current)
- 11:07, 6 May 2008 (diff | hist) . . (7 bytes) . . MediaWiki:MainPage (New page: FlySafe) (current)
- 11:05, 6 May 2008 (diff | hist) . . (210 bytes) . . MediaWiki:Sidebar (New page: * navigation ** mainpage|mainpage ** portal-url|portal ** currentevents-url|currentevents ** recentchanges-url|recentchanges ** randompage-url|randompage ** helppage|help <!-- ** sitesuppo...) (current)
- 10:02, 6 May 2008 (diff | hist) . . (297 bytes) . . Main Page (current)
- 09:58, 29 April 2008 (diff | hist) . . (3,858 bytes) . . Setting up a connection to the e-Ecology database (New page: = Connecting to the FlySafe database via Access or other relational database programs= Judy Shamoun-Baranes Last updated: December 11, 2007 =General Information= The Flysafe database is...)
- 09:54, 29 April 2008 (diff | hist) . . (66 bytes) . . Database
- 09:53, 29 April 2008 (diff | hist) . . (55 bytes) . . Database
- 09:53, 29 April 2008 (diff | hist) . . (59 bytes) . . Database
- 09:49, 29 April 2008 (diff | hist) . . (51 bytes) . . Database (New page: == Database Issues == Connect_flysafe.doc )
- 09:48, 29 April 2008 (diff | hist) . . (323 bytes) . . Main Page
- 09:46, 29 April 2008 (diff | hist) . . (38 bytes) . . File:Connect flysafe.doc (How to connect to the Flysafe database)
- 09:43, 29 April 2008 (diff | hist) . . (52 bytes) . . Argos Data Model
- 09:42, 29 April 2008 (diff | hist) . . (29 bytes) . . Argos Data Model
- 09:42, 29 April 2008 (diff | hist) . . (29 bytes) . . Argos Data Model
- 09:41, 29 April 2008 (diff | hist) . . (75 bytes) . . Argos Data Model (New page: https://flysafe-pps.grid.sara.nl/wiki/images/f/fc/Gps_datamodel.png )
- 09:38, 29 April 2008 (diff | hist) . . (62 bytes) . . Flysafe Data Model (New page: == Flysafe Data Model== * Medium Power Radar * GPS)
- 09:35, 29 April 2008 (diff | hist) . . (empty) . . File:Gps datamodel.png (current)
- 08:35, 29 April 2008 (diff | hist) . . (291 bytes) . . Main Page
- 08:34, 29 April 2008 (diff | hist) . . (290 bytes) . . Main Page
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
