cameras table schema

EstherJensen · ‎01-24-2017

I need assistance with filling out the camera table schema for the ortho mapping workspace. I am using old scanned aerial photos made with different cameras and have limited information to fill in the table. I am mainly wandering what to put into the A0, A1, A2, B0, B1, B2 columns. What I would need is some sort of camera software that does this for me. Is there something like that a part of the Ortho mapping tools?

regards Esther

CodyBenkelman · ‎01-24-2017

See the spreadsheet available here FrameCameraParameterCalculator

It will show you the proper values for the affine parameters based on your image scan parameters

You didn't mention whether or not you have the metadata for the Frames table. If you have a large number of images, please look at the workflow we published in this Group on ArcGIS Online for historical imagery (LINK). If you have more than a handful of images, this should be helpful to streamline your data ingest process.

EstherJensen · ‎01-27-2017

Thank you for the prompt response.

I do have some information for the Frames table (or can create it) but am still struggling with the angles (omega, phi and kappa). They are angles of the camera but in what scale should they be calculated, since I do not always know the "paper" or film size?

I hope I get this to work, it looks promising.

EstherJensen · ‎01-27-2017

I get an error when I try to create the ortho workspace:

2017-01-28T00:10:52.731: Synchronizing crawled data source items
2017-01-28T00:10:52.763: Synchronizing items associated with raster type instance 'Scanned Aerial Imagery' [ID: 1].
2017-01-28T00:10:52.836: Error: 80042019: Could not build mosaic dataset item. [ID: 1, URI: 'W:\tmp\skafta\upprettar\1960\frame_table_DMA1960.csv|1']
2017-01-28T00:10:52.840: Error: 8004207f: Unable to load camera information using the specified CameraID. [0]
2017-01-28T00:10:52.851: Error: 80042019: Could not build mosaic dataset item. [ID: 2, URI: 'W:\tmp\skafta\upprettar\1960\frame_table_DMA1960.csv|3']
2017-01-28T00:10:52.855: Error: 8004207f: Unable to load camera information using the specified CameraID. [0]
2017-01-28T00:10:52.865: Error: 80042019: Could not build mosaic dataset item. [ID: 3, URI: 'W:\tmp\skafta\upprettar\1960\frame_table_DMA1960.csv|4']
2017-01-28T00:10:52.870: Error: 8004207f: Unable to load camera information using the specified CameraID. [0]
2017-01-28T00:10:52.878: Error: 80042019: Could not build mosaic dataset item. [ID: 4, URI: 'W:\tmp\skafta\upprettar\1960\frame_table_DMA1960.csv|5']
2017-01-28T00:10:52.882: Error: 8004207f: Unable to load camera information using the specified CameraID. [0]
2017-01-28T00:10:53.016: Error: 8004205e: 4 mosaic dataset items could not be built.
2017-01-28T00:10:53.042: Removing invalid mosaic dataset items
2017-01-28T00:10:53.069: Removing unreferenced raster type and overview instances
2017-01-28T00:10:53.080: Removed 4 mosaic dataset items and 1 unreferenced raster type instances.
2017-01-28T00:10:53.184: Removing broken mosaic dataset items.
2017-01-28T00:10:53.202: Removed 0 mosaic dataset items and 0 unreferenced raster type instances.
2017-01-28T00:10:53.302: Completed synchronization: 4 items selected, 0 items synchronized.
ERROR 999999: Error executing function.
Failed to execute (AddRastersToMosaicDataset).
Failed at 28 January 2017 00:10:55 (Elapsed Time: 8.26 seconds)

I only have names of some cameras and in this particular case the camera info is in this table (yellow):

EstherJensen · ‎02-17-2017

I managed to get beyond this error but then I get a new one:

2017-02-17T17:53:54.347: Completed crawling 2 data source items. Added 2 mosaic dataset items.
2017-02-17T17:53:54.374: Synchronizing crawled data source items
2017-02-17T17:53:54.401: Synchronizing items associated with raster type instance 'Scanned Aerial Imagery' [ID: 1].
2017-02-17T17:54:42.522: Error: 8004201a: Insufficient information from raster dataset. Could not update mosaic dataset item. [ID: 1, URI: 'frame_table.csv|1']
2017-02-17T17:54:42.527: Error: 8004200a: Could not update raster value for the raster dataset. [B21-B-5886]
2017-02-17T17:54:42.534: Error: 80040213: The coordinates or measures are out of bounds.
2017-02-17T17:54:48.144: Error: 8004201a: Insufficient information from raster dataset. Could not update mosaic dataset item. [ID: 2, URI: 'frame_table.csv|2']
2017-02-17T17:54:48.163: Error: 8004200a: Could not update raster value for the raster dataset. [B21-B-5887]
2017-02-17T17:54:48.171: Error: 80040213: The coordinates or measures are out of bounds.
2017-02-17T17:54:48.184: Removing invalid mosaic dataset items
2017-02-17T17:54:48.230: Removing unreferenced raster type and overview instances
2017-02-17T17:54:48.240: Removed 2 mosaic dataset items and 1 unreferenced raster type instances.
2017-02-17T17:54:48.365: Completed synchronization: 2 items selected, 0 items synchronized.
ERROR 999999: Error executing function.
Failed to execute (AddRastersToMosaicDataset).
Failed at 17 February 2017 17:54:50 (Elapsed Time: 1 minutes 1 seconds)