Data Management - Revision history

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:

Jeff: /* Data Management */

2022-02-16T16:50:26Z

Data Management

← Older revision		Revision as of 16:50, 16 February 2022
Line 2:		Line 2:
	__FORCETOC__		__FORCETOC__
	===Data Management===		===Data Management===
			The purpose of Golden Retriever is to collect data so that it can be used for analysis and action. Tools have been and will continue to be developed to aid in this . This section describes these tools.
			''Please feel free to send the Golden Retriever development team any suggestions or requests that you may have.''
			<br>
	====Databases Summary Page====		====Databases Summary Page====
	When you click on the <code>Databases</code> menu item you will get a table showing all your account's active databases. You can toggle between active and archived by clicking on whichever of "Active databases" or "Archived databases" is in blue. Golden Retriever automatically archives any dictionary/database where the newest record is older than six months.		The Database Summary Page is the first thing you'll see when you log in to Golden Retriever. Here you will be able to find your data. When you click on the <code>Databases</code> menu item you will get a table showing all your account's active databases. You can toggle between active and archived by clicking on whichever of "Active databases" or "Archived databases" is in blue. Golden Retriever automatically archives any dictionary/database where the newest record is older than six months.
	<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.

Jeff: /* Viewing Photos */

2022-02-16T15:53:18Z

Viewing Photos

← Older revision		Revision as of 15:53, 16 February 2022
Line 73:		Line 73:
	Photos can be downloaded individually by saving them when they are opened in a browser tab. To download photos in batches, use the steps shown below in [[Data_Management#Downloading_Records\|Downloading Records]] and select "Include photos".		Photos can be downloaded individually by saving them when they are opened in a browser tab. To download photos in batches, use the steps shown below in [[Data_Management#Downloading_Records\|Downloading Records]] and select "Include photos".
	Note: Photos and records can be downloaded together or separately depending on the checkboxes.		Note: Photos and records can be downloaded together or separately depending on the checkboxes.
	<br>		<br><br>

	=====Downloading Records=====		=====Downloading Records=====

Jeff: /* Viewing Photos */

2022-02-16T15:52:51Z

Viewing Photos

← Older revision		Revision as of 15:52, 16 February 2022
Line 65:		Line 65:
	Clicking on either the <code>Latitude</code> or <code>Longitude</code> will open a new tab with a Google Map of that record's GPS location.		Clicking on either the <code>Latitude</code> or <code>Longitude</code> will open a new tab with a Google Map of that record's GPS location.
	======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_Photos1n~~.png\|none]]		[[File:OS_Photos1.png\|none]]
	*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.
	*Additional photos can be uploaded into the record by clicking the <code>+Add</code> button		*Additional photos can be uploaded into the record by clicking the <code>+Add</code> button
	<br>		<br>
	Photos can be downloaded individually by saving them when they are opened in a browser tab. To download photos in batches, use the steps shown below and select "Include photos".		Photos can be downloaded individually by saving them when they are opened in a browser tab. To download photos in batches, use the steps shown below in [[Data_Management#Downloading_Records\|Downloading Records]] and select "Include photos".
	Note: Photos and records can be downloaded together or separately depending on the checkboxes.		Note: Photos and records can be downloaded together or separately depending on the checkboxes.
	<br>		<br>

Jeff: /* Viewing Photos */

2022-02-16T15:42:29Z

Viewing Photos

← Older revision		Revision as of 15:42, 16 February 2022
Line 70:		Line 70:
	*To delete photos click <code>Del</code> beside the photo name.		*To delete photos click <code>Del</code> beside the photo name.
	*Additional photos can be uploaded into the record by clicking the <code>+Add</code> button		*Additional photos can be uploaded into the record by clicking the <code>+Add</code> button
			<br>
			Photos can be downloaded individually by saving them when they are opened in a browser tab. To download photos in batches, use the steps shown below and select "Include photos".
			Note: Photos and records can be downloaded together or separately depending on the checkboxes.
	<br>		<br>

Jeff: /* Viewing Photos */

2022-02-16T15:31:59Z

Viewing Photos

← Older revision		Revision as of 15:31, 16 February 2022
Line 66:		Line 66:
	======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_Photos1n.png]]		[[File:OS_Photos1n.png\|none]]
	*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.

Jeff: /* Viewing Photos */

2022-02-16T15:30:20Z

Viewing Photos

← Older revision		Revision as of 15:30, 16 February 2022
Line 66:		Line 66:
	======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_Photos1n.png		[[File:OS_Photos1n.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.

Jeff: /* Viewing Photos */

2022-02-16T15:30:07Z

Viewing Photos

← Older revision		Revision as of 15:30, 16 February 2022
Line 65:		Line 65:
	Clicking on either the <code>Latitude</code> or <code>Longitude</code> will open a new tab with a Google Map of that record's GPS location.		Clicking on either the <code>Latitude</code> or <code>Longitude</code> will open a new tab with a Google Map of that record's GPS location.
	======Viewing Photos======		======Viewing Photos======
	The photos are located in the far right-hand column of the spreadsheet. Click on the photo names to open them in a new browser tab. To delete photos click <code>Del</code> beside the photo name.		The photos are located in the far right-hand column of the spreadsheet.
			[[File:OS_Photos1n.png
			*Click on the photo names to open them in a new browser tab.
			*To delete photos click <code>Del</code> beside the photo name.
			*Additional photos can be uploaded into the record by clicking the <code>+Add</code> button
	<br>		<br>

	=====Downloading Records=====		=====Downloading Records=====
	The records in the database may be download either in a <code>csv</code> (comma-separated values) file or in an <code>xlsx</code> file. This is the most common way to get your data.		The records in the database may be download either in a <code>csv</code> (comma-separated values) file or in an <code>xlsx</code> file. This is the most common way to get your data.

Jeff: /* Export as a Shapefile */

2021-02-08T19:37:47Z

Export as a Shapefile

← Older revision		Revision as of 19:37, 8 February 2021
Line 166:		Line 166:
	#Click <code>Generate Shapefile</code>		#Click <code>Generate Shapefile</code>
	#Monitor your email for download link or error messages.		#Monitor your email for download link or error messages.
	'''Note: To select a date range for a shapefile this must be done in the online spreadsheet filters.'''		'''''Note: To select a date range for a shapefile this must be done in the online spreadsheet filters.'''''
	<br>		<br>

Jeff: /* Export as a Shapefile */

2021-02-08T19:37:14Z

Export as a Shapefile

← Older revision		Revision as of 19:37, 8 February 2021
Line 92:		Line 92:
	<pre>{"types":"ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTReal,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString","pres": [50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,1,50,50,50,50,50,50,50,50,50,50,50,50,50]}</pre>		<pre>{"types":"ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTReal,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString,ogr.OFTString","pres": [50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,1,50,50,50,50,50,50,50,50,50,50,50,50,50]}</pre>

	which is a minified version of the following JSON:		'''Technical Description'''
			<div class="toccolours mw-collapsible mw-collapsed">
			Expand to show detailed instructions on the required format. ''Please contact the GR team if you require any help with this.''
			<div class="mw-collapsible-content">
			which is a minified version of the following JSON:

	<pre>		<pre>
Line 148:		Line 152:

	One thing to remember is you '''must define a type and precision for every column in your shapefile'''. If you don't you may encounter errors.		One thing to remember is you '''must define a type and precision for every column in your shapefile'''. If you don't you may encounter errors.
			</div></div>

			<br>
	Once you are ready simply click the <code>Generate Shapefile</code> button and the system will get to work on it. You will receive an email once your shapefile is ready for download - the download link will be valid for three hours.		Once you are ready simply click the <code>Generate Shapefile</code> button and the system will get to work on it. You will receive an email once your shapefile is ready for download - the download link will be valid for three hours.
			======Step by Step Instructions======
			#Navigate to the desired database.
			#Sort data by any required criteria (''i.e. date range, inspection type'').
			#If applicable, select a custom report.
			#Select a specific Projection if required or leave the default.
			#Select the correct Longitude and Latitude fields. ''This should default correctly unless a custom report is being used.''
			#Paste the ''Column Template'' into the Shapefile Column Template box.
			#Enter your desired file name.
			#Click <code>Generate Shapefile</code>
			#Monitor your email for download link or error messages.
			'''Note: To select a date range for a shapefile this must be done in the online spreadsheet filters.'''
	<br>		<br>