1 Reply by SteveHannah

  • SteveHannah
  • Veteran
  • Offline
  • From: Midlothian
  • Registered: 02-09-2010
  • Posts: 84

Re: Export to GIS

I was wondering how other people exported their records out of recorder and into GIS, specifically ESRI ArcView.  Things like what fields are exported would be useful.

Regards
Steve

-----------------------------------------------------------------------
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre

SteveHannah's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Export to GIS

From my experience typically

1. A unique index numeric field which allows ArcGIs to access and query the table
2. Taxon_Occurence_key
3. Date_Recorded (usually vague date start)
4. Recorder Vague date
5, Scientific name
6. Common Name
7. Taxon Group (Recorder not taxonomic group)
8. Grid Ref
9 Eastings
10. Northings
11. Confidential
12. Recorder (as a concatenated string)
13. Determiner
14. Determiner Role
15 Determination Type
16. Abundance (as a concatenated string)
17. Site Name (Location hierarchy)
18. Location Name (from sample)
19. Record Type
20 Sample Type
21. National Designation (varies, but usual a concatenated string of designation kinds)
22. Local Designations

Mike Weideli

MikeWeideli's Website

3 Reply by Frederic Piesschaert (edited by Frederic Piesschaert 03-12-2010 11:14:15)

  • Frederic Piesschaert
  • Member
  • Offline
  • Registered: 25-11-2009
  • Posts: 29

Re: Export to GIS

one issue with exporting to shape-files is the restricted field length (10 characters) in ArcView. If you have several abundance data that you want to include (e.g. abundance of adult male, abundance of adult female), the field names are transformed to taxon_ab_1, taxon_ab_2 etc. It would be very useful if the export wizard allowed to rename the field names to something more meaningful before exporting. Or am I overlooking something?

Frederic