1

Re: Polygons

Hi all

I was wondering about how you deal with species records exported from Recorder and then put into GIS.  At present, we have a routine written for us that exports our records into tables.  We then convert these into shapefiles in ArcCatalog using Eastings/Northings.  This provides us with point files.  We are now trying to convert these into polygons which cover the grid square that the species occupies (e.g. if the grid reference of a record is NT123456, then it will cover that 100m square, a record with a reference of NT1234567890 will cover a 1m square).  Does anyone do anything similar, and if so, how do you do this?

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

2

Re: Polygons

A year or so ago I started working on a MapInfo (MapBasic) tool to do just what you suggest, but that won't help for Arc. I have yet to find time to finish the tool, but hope to soon.

Having said that, I seem to recall that it is possible to set up a report in Recorder, then send the results to the map & then export to a shapefile. Learning about this was one of the reasons I stopped working on the tool, but again I haven't had time to investigate further.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

3

Re: Polygons

seem to recall that it is possible to set up a report in Recorder

Report Output -> Export to ESRI Shape File?

There is a thread on here somewhere about it (and what needs to be included in the report output for it to work - sample spatial ref I think), but I can't find it atm.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

4

Re: Polygons

One option might be to move Recorder to Sql Server 2008. You will the be able to create a spatial field  for the ploygons in your export table. I think that you may also then be able to link ARCGIS directly to the extract.

Mike Weideli

5

Re: Polygons

Hi Steve, I asked the same question in your previous related thread here. I haven't had chance to test Charlie's tool that he posted yet (can't install stuff here at work unfortunately).

The utility within Recorder is often very useful, but not helpful when you have processing to do to the records before sharing them with people. If I only had Arc here I'd start experimenting with genshapes...

-----------------
Teresa Frost | Wetland Bird Survey National Organiser | BTO
Other hat  | National Forum for Biological Recording Council
(Old hats  | NBN Board, ALERC Board, CBDC, KMBRC)

6

Re: Polygons

TeresaF wrote:

I haven't had chance to test Charlie's tool that he posted yet (can't install stuff here at work unfortunately).

If you do try it out, make sure you use some grid references that are in Lincolnshire...... I've got a feeling I hadn't implemented nation-wide with it :)

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

7 (edited by TeresaF 02-06-2011 08:49:13)

Re: Polygons

If I were you and I had Arc 10 (won't work with previous versions) I'd do these things:

1. Install R, StatConn DCOM and GME see http://www.spatialecology.com/gme/gmedownload.htm

2. Create a dbf file with the *midpoint* of each grid ref and the precision in metres (my spreadsheet almost does this, but you will need to change 100m to 100, 1km to 1000 etc.) in a field called "PRECISION".

3.Convert to a point shapefile spnts.shp

4. In the GME command line window type
genshapes(in="C:\data\spnts.shp", shape=4, dim="PRECISION", out="myoutput.shp");
(See http://www.spatialecology.com/gme/genshapes.htm)

It should be as simple as that, but as I don't have Arc I can't try it :(

-----------------
Teresa Frost | Wetland Bird Survey National Organiser | BTO
Other hat  | National Forum for Biological Recording Council
(Old hats  | NBN Board, ALERC Board, CBDC, KMBRC)

8 (edited by TeresaF 02-06-2011 10:18:53)

Re: Polygons

More ideas appearing over on the Alerc forum: http://forum.lrcs.org.uk/viewtopic.php?id=473

-----------------
Teresa Frost | Wetland Bird Survey National Organiser | BTO
Other hat  | National Forum for Biological Recording Council
(Old hats  | NBN Board, ALERC Board, CBDC, KMBRC)

9

Re: Polygons

Teresa you're a star.  That worked perfectly, thanks so much for putting me on to that!

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

10

Re: Polygons

In the thread on the Alerc forum I've now added another way to do this completely in ArcGIS, but it requires an ArcInfo licence.

-----------------
Teresa Frost | Wetland Bird Survey National Organiser | BTO
Other hat  | National Forum for Biological Recording Council
(Old hats  | NBN Board, ALERC Board, CBDC, KMBRC)