1 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: xporting to shapefile - unknown co-ordinate system error

I am getting a repeated error when I try to build a shapefile from the report wizrd of an unknown spatial system.


Exception path:
ESpatialRefError : The spatial reference system cannot be recognised.

Last event\actions:
  actReportWizard invoked
  TfrmFilterResult created
  TfrmRuckSack deactivated
  TfrmFilterResult activated
  TdlgWizard created
  TfrmFilterResult deactivated
  TfrmRuckSack activated
  TfrmRuckSack deactivated
  TfrmFilterResult activated

Operating System : Windows XP  5.01.2600  Service Pack 2
Physical Memory available : 2,060,520 KB

DLLs loaded:
  advapi32.dll (5.1.2600.2180)
  comctl32.dll (5.82.2900.2180)
  comdlg32.dll (6.0.2900.2180)
  gdi32.dll (5.1.2600.2180)
  gdiplus.dll (5.1.3102.2180)
  HHCtrl.ocx (5.2.3790.1194)
  kernel32.dll (5.1.2600.2180)
  mpr.dll (5.1.2600.2180)
  MS5.Dll (5.0.0.12)
  MS5User.Dll (5.0.0.4)
  odbc32.dll (3.525.1117.0)
  ole32.dll (5.1.2600.2180)
  oleaut32.dll (5.1.2600.2180)
  shell32.dll (6.0.2900.2180)
  user32.dll (5.1.2600.2180)
  version.dll (5.1.2600.2180)
  winmm.dll (5.1.2600.2180)
  winspool.drv (5.1.2600.2180)


As the report is a polygon search of a known area... I wonder what is going on.

Presumably the polygon search has to base its query on the (Sample) Grid references that exist.
So if it can find the records in the first place - whats different about reading them again when building a shapefile?

If their are corruptions in the database - where should I be looking? At the Lat Long values or (I assume) the Sample Spatial Reference.

I seem to be able to plot the results reliably on the Base map - and it is able to convert that to a shapefile - albeit in a triangle form - the fourth vector being missed out.

So, lots of unresolved issues with the (our) Shapefile export. 

Are other folk able to use the export facility reliably or are the problems similar? Is this our problem or the programs problem?

ta

MAtt

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: xporting to shapefile - unknown co-ordinate system error

This is a problem that I've come across before (you seem to be hitting a few of those lately). It seems to be caused by certain grid references. I reported it to Lynn, but I'm not sure how far she got in reproducing it. Hopefully it'll get fixed in the next version.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: xporting to shapefile - unknown co-ordinate system error

Just an update;

I dug out the Sample.Spatial_ref and checked for anomalies (spaces everywhere), corrected them and repopulated the sample table with them.
This would seem to be working fine.

So thats solved for now.

Can I prod the triangle issue again.
When we do export to .shp - it builds a triangle rather than a square (SW,NW,NE corners).  Is this what others are experiencing or is it an anomaly here.
If it is a triangle - pretty though it is - how is that useful?


M

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: xporting to shapefile - unknown co-ordinate system error

Matt, that's similar to a bug I found and reported, but in my case it was plotting four points in the polygon (i.e., three faces, E, S and W) and then not closing it, so when I removed the colour, it looked like a square without a top. To fix it I think I ran the repair geometry tool in ArcGIS which just closed off the square. Don't think that will work if you have a triangle, though.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

5 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: xporting to shapefile - unknown co-ordinate system error

See, I think I had that configuration originally - an open square, and thought that it was workable despite being wrong, but it seems to have shifted to a triangle now.

More shrugging.

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

6 Reply by TeresaF

  • TeresaF
  • Veteran
  • Offline
  • From: BTO
  • Registered: 12-05-2008
  • Posts: 171

Re: xporting to shapefile - unknown co-ordinate system error

Thanks for the tip about using the Arc repair geometry tool Charles. I wondered why the bottom of my squares were disappearing after exporting tetrads from Recorder 6!

I've now got a lovely layer of tetrads all correctly labelled on my lookup map template, so I don't have to put my poor little brain to work anymore working out what tetrads are in our search areas. :cool:

Although we still aren't using 6 here yet, I'm already finding it helpful just as a tool for slinging in data and then re-exporting to shapefiles and google earth.

Hope our open squares don't start turning into triangles too. :o

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