Data Management - Revision history

Justin: /* Viewing Photos */

2026-06-03T19:31:07Z

Viewing Photos

← Older revision		Revision as of 19:31, 3 June 2026
Line 68:		Line 68:
	======Viewing Photos======		======Viewing Photos======
	The photos are located in the far right-hand column of the spreadsheet.		The photos are located in the far right-hand column of the spreadsheet.
	[[File:~~AddPhotos~~.png]]		[[File:AddPhoto.png\|none\|thumb]]
	*Click on the photo names to open them in a new browser tab.		*Click on the photo names to open them in a new browser tab.
	*To delete photos click <code>Del</code> beside the photo name.		*To delete photos click <code>Del</code> beside the photo name.

Justin: /* Viewing Photos */

2026-06-03T19:29:02Z

Viewing Photos

← Older revision		Revision as of 19:29, 3 June 2026
Line 68:		Line 68:
	======Viewing Photos======		======Viewing Photos======
	The photos are located in the far right-hand column of the spreadsheet.		The photos are located in the far right-hand column of the spreadsheet.
	[[File:~~Photos~~.png]]		[[File:AddPhotos.png]]
	*Click on the photo names to open them in a new browser tab.		*Click on the photo names to open them in a new browser tab.
	*To delete photos click <code>Del</code> beside the photo name.		*To delete photos click <code>Del</code> beside the photo name.

Justin: /* Viewing Photos */

2026-06-03T19:25:40Z

Viewing Photos

← Older revision		Revision as of 19:25, 3 June 2026
Line 68:		Line 68:
	======Viewing Photos======		======Viewing Photos======
	The photos are located in the far right-hand column of the spreadsheet.		The photos are located in the far right-hand column of the spreadsheet.
	[[File:~~OS_Photos1~~.png~~\|none~~]]		[[File:Photos.png]]
	*Click on the photo names to open them in a new browser tab.		*Click on the photo names to open them in a new browser tab.
	*To delete photos click <code>Del</code> beside the photo name.		*To delete photos click <code>Del</code> beside the photo name.

Justin: /* Search Records */

2026-06-03T17:43:15Z

Search Records

← Older revision		Revision as of 17:43, 3 June 2026
Line 49:		Line 49:
	======Search Records======		======Search Records======
	At the bottom of the online spreadsheet are options to view, sort, search, add, edit and delete records.		At the bottom of the online spreadsheet are options to view, sort, search, add, edit and delete records.
	[[File:~~SearchRecords~~.png\|none\|frame\|Caption:Click <code>Find</code> to view for all records from February 14th by the inspector Bob]]		[[File:Bar.png\|none\|frame\|Caption:Click <code>Find</code> to view for all records from February 14th by the inspector Bob]]
	Clicking on the search button (magnifying glass icon) will bring up the search window where you can search by multiple criteria.		Clicking on the search button (magnifying glass icon) will bring up the search window where you can search by multiple criteria.

	======Editing Records======		======Editing Records======

Justin: /* Database View */

2026-06-03T17:16:08Z

Database View

← Older revision		Revision as of 17:16, 3 June 2026
Line 44:		Line 44:
	*Download and Export Options		*Download and Export Options
	*Option to Delete Both the Database and Dictionary (''available to Admin's only'')		*Option to Delete Both the Database and Dictionary (''available to Admin's only'')
	<br>[[File:~~SortingRecords~~.png\|none\|frame]]<br>		<br>[[File:data.png\|none\|frame]]<br>
	======Viewing and Sorting Records======		======Viewing and Sorting Records======
	Columns can be moved and resized as required. clicking on a heading will sort the current list by the data in that column (database field).		Columns can be moved and resized as required. clicking on a heading will sort the current list by the data in that column (database field).

Justin: /* Last Record Uploaded */

2026-06-03T17:07:05Z

Last Record Uploaded

← Older revision		Revision as of 17:07, 3 June 2026
Line 25:		Line 25:
	[[File:Screenshot5.png\|thumb\|none\|Caption:Follow link to map of record's location]]		[[File:Screenshot5.png\|thumb\|none\|Caption:Follow link to map of record's location]]
	In addition to the timestamp of the last upload record, one other field may be shown (set in the ''Dictionary Creator'') such as crew name or inspector name. This can assist with keeping track of where your crews are currently working. By default the unique device id will be shown but any other field in the dictionary may be used - '''''Refer to the Dictionary Creator instructions on this'''''.		In addition to the timestamp of the last upload record, one other field may be shown (set in the ''Dictionary Creator'') such as crew name or inspector name. This can assist with keeping track of where your crews are currently working. By default the unique device id will be shown but any other field in the dictionary may be used - '''''Refer to the Dictionary Creator instructions on this'''''.
	[[File:~~LastLocationMap~~.png\|thumb\|none]]		[[File:Map.png\|thumb\|none]]

	=====Records Today=====		=====Records Today=====

Justin: /* Last Record Uploaded */

2026-06-03T17:05:08Z

Last Record Uploaded

← Older revision		Revision as of 17:05, 3 June 2026
Line 23:		Line 23:
	=====Last Record Uploaded=====		=====Last Record Uploaded=====
	Shows the most recent record uploaded. Clicking on the date will bring up a map showing the most recent record's GPS location.		Shows the most recent record uploaded. Clicking on the date will bring up a map showing the most recent record's GPS location.
	[[File:~~LastRecordUploaded~~.png\|thumb\|none\|Caption:Follow link to map of record's location]]		[[File:Screenshot5.png\|thumb\|none\|Caption:Follow link to map of record's location]]
	In addition to the timestamp of the last upload record, one other field may be shown (set in the ''Dictionary Creator'') such as crew name or inspector name. This can assist with keeping track of where your crews are currently working. By default the unique device id will be shown but any other field in the dictionary may be used - '''''Refer to the Dictionary Creator instructions on this'''''.		In addition to the timestamp of the last upload record, one other field may be shown (set in the ''Dictionary Creator'') such as crew name or inspector name. This can assist with keeping track of where your crews are currently working. By default the unique device id will be shown but any other field in the dictionary may be used - '''''Refer to the Dictionary Creator instructions on this'''''.
	[[File:LastLocationMap.png\|thumb\|none]]		[[File:LastLocationMap.png\|thumb\|none]]

Justin: /* Databases Summary Page */

2026-06-03T16:26:42Z

Databases Summary Page

← Older revision		Revision as of 16:26, 3 June 2026
Line 9:		Line 9:
	<br>This table gives you basic statistics of what data (total records, etc.)		<br>This table gives you basic statistics of what data (total records, etc.)
	is in each dictionary.		is in each dictionary.
	[[File:DatabasesTable.png\|~~thumb~~\|~~none~~]]		[[File:DatabasesTable.png\|center\|1000px\|Table showing all Active databases]]
	=====Name=====		=====Name=====
	The dictionary/database name		The dictionary/database name

Justin: /* Databases Summary Page */

2026-06-03T16:05:31Z

Databases Summary Page

← Older revision		Revision as of 16:05, 3 June 2026
Line 9:		Line 9:
	<br>This table gives you basic statistics of what data (total records, etc.)		<br>This table gives you basic statistics of what data (total records, etc.)
	is in each dictionary.		is in each dictionary.
	[[File:DatabasesTable.png\|none~~\|Caption:Table showing all Active databases~~]]		[[File:DatabasesTable.png\|thumb\|none]]
	=====Name=====		=====Name=====
	The dictionary/database name		The dictionary/database name

Jeff: /* Export as a Shapefile */

2022-02-16T17:39:21Z

Export as a Shapefile

← Older revision		Revision as of 17:39, 16 February 2022
Line 92:		Line 92:

	=====Export as a Shapefile=====		=====Export as a Shapefile=====
	Golden Retriever gives you the option to download a shapefile of your data. This shapefile makes it easy for your utility customer to import the collected data directly into their GIS system. There are many GPS coordinate formats available. For simplicity sake Golden Retriever system has a select few options - contact us if you require additional formats and we will add them to the list.		Golden Retriever gives you the option to download a shapefile of your data. This shapefile makes it easy for your utility customer to import the collected data directly into their GIS system. You can export the entire database or just a portion of it. To limit the records exported, first filter the data in the online spreadsheet to only show the required records (by date, circuit, inspection type, etc.).
			[[file:OS_ExportShapefile1.png\|border]] <br>
			There are many GPS coordinate formats available. For simplicity sake Golden Retriever system has a select few options - contact us if you require additional formats and we will add them to the list. First, select the desired 'Projection' for your GPS coordinates.
			[[file:OS_ExportShapefile2.png\|thumb\|none]] <br>
			Next you will need to confirm which fields containing the ''latitude'' and ''longitude'' coordinates and set a name for the shapefile. By default Latitude and Longitude are selected as these fields contain the coordinates collected by the Golden Retriever app.

	'''''Note: If you have performed any data filtering in the above online spreadsheet those filters will be reflected in the created shapefile.'''''		'''''Note: If you have performed any data filtering in the above online spreadsheet those filters will be reflected in the created shapefile.'''''

	There is a text entry box ~~labeled~~ "''Shapefile column template''". By default the shapefile will be created with each column being defined as a "String" without any defined precision on the field. Most of the time this will be more than fine however you may find the GIS you plan to add the shapefile to has certain column requirements. Such as a particular column needing to be of type "Integer" with a precision(length) of 10 digits. When you try to add the shapefile your GIS throws an error that the column is not in the correct format. In such cases you are able to paste a string into this text entry box to tell the shapefile creator to uses your specified column types and precision.		There is a text entry box labelled "''Shapefile column template''". By default the shapefile will be created with each column being defined as a "String" without any defined precision on the field. Most of the time this will be more than fine however you may find the GIS you plan to add the shapefile to has certain column requirements. Such as a particular column needing to be of type "Integer" with a precision(length) of 10 digits. When you try to add the shapefile your GIS throws an error that the column is not in the correct format. In such cases you are able to paste a string into this text entry box to tell the shapefile creator to uses your specified column types and precision.

	You must make sure your column template string is in the following format:		You must make sure your column template string is in the following format: