Coordinate display rules - Revision history

Alnaucler at 17:08, 26 May 2017

2017-05-26T17:08:22Z

@@ Line 1: / Line 1: @@
 This query shows the different combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' used in the database.
 # Verify that all combinations are correct, if not they need to be corrected.
@@ Line 69: / Line 68: @@
 LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) <> 2
 and coordformat = 'Degrees:Decimal Minutes'
 </pre>
 {{NavBox Upgrade}}
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Alnaucler at 21:56, 5 December 2016

2016-12-05T21:56:38Z

← Older revision		Revision as of 23:56, 5 December 2016
Line 1:		Line 1:
			{{Rewrite \| This pages needs to be updated with Distance/Bearing checks.}}
	This query shows the different combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' used in the database.		This query shows the different combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' used in the database.
	# Verify that all combinations are correct, if not they need to be corrected.		# Verify that all combinations are correct, if not they need to be corrected.

Evinek at 06:43, 21 August 2015

2015-08-21T06:43:04Z

← Older revision		Revision as of 08:43, 21 August 2015
Line 55:		Line 55:
	This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains 2 ''':''' when coordformat is ''Degrees:Decimal Minutes''		This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains 2 ''':''' when coordformat is ''Degrees:Decimal Minutes''
	<pre>		<pre>
	~~ELECT~~		SELECT
	geopoint.coordrefsys,		geopoint.coordrefsys,
	geopoint.userinputformat,		geopoint.userinputformat,

Alnaucler at 16:29, 24 November 2014

2014-11-24T16:29:37Z

← Older revision		Revision as of 18:29, 24 November 2014
Line 36:		Line 36:
	</pre>		</pre>

	This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains ''':''' when coordformat is ''Degrees:Minutes:Seconds~~'' OR ''Degrees:Decimal Minutes~~''		This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains 4 ''':''' when coordformat is ''Degrees:Minutes:Seconds''
	<pre>		<pre>
	SELECT		SELECT
	~~geopoint.longitude,~~
	~~geopoint.latitude,~~
	geopoint.coordrefsys,		geopoint.coordrefsys,
			geopoint.userinputformat,
	geopoint.coordformat,		geopoint.coordformat,
			geopoint.userenteredcoord,
			LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) AS occ

			FROM
			geopoint
			WHERE
			geopoint.userenteredcoord LIKE '%:%' and
			LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) <> 4
			and coordformat = 'Degrees:Minutes:Seconds'
			</pre>

			This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains 2 ''':''' when coordformat is ''Degrees:Decimal Minutes''
			<pre>
			ELECT
			geopoint.coordrefsys,
	geopoint.userinputformat,		geopoint.userinputformat,
	geopoint.userenteredcoord		geopoint.coordformat,
			geopoint.userenteredcoord,
			LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) AS occ

	FROM		FROM
	geopoint		geopoint
	WHERE		WHERE
	userenteredcoord ~~NOT~~ LIKE '%:%'		geopoint.userenteredcoord LIKE '%:%' and
	~~AND~~ (~~coordformat =~~ '~~Degrees~~:~~Minutes:Seconds~~' OR coordformat = 'Degrees:Decimal Minutes')		LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) <> 2
			and coordformat = 'Degrees:Decimal Minutes'
	</pre>		</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 09:01, 23 September 2014

2014-09-23T09:01:25Z

← Older revision		Revision as of 11:01, 23 September 2014
Line 1:		Line 1:
	This query ~~identifies coordinates where~~ the combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' is not ~~correctly set~~.		This query shows the different combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' used in the database.
			# Verify that all combinations are correct, if not they need to be corrected.
			# Verify that you have prj files for all used non-standard coordinate systems e.g. ''Kandawala''.
	<pre>		<pre>
	SELECT		SELECT

Alnaucler at 15:57, 15 July 2014

2014-07-15T15:57:39Z

← Older revision		Revision as of 17:57, 15 July 2014
Line 1:		Line 1:
	This query identifies coordinates where ''userinputformat'' is not correctly set.		This query identifies coordinates where the combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' is not correctly set.
	<pre>		<pre>
	SELECT		SELECT
			geopoint.coordrefsys,
			geopoint.coordformat,
	geopoint.userinputformat,		geopoint.userinputformat,
	Count(geopoint.geopoint_guid)		Count(geopoint.geopoint_guid)
Line 7:		Line 9:
	geopoint		geopoint
	GROUP BY		GROUP BY
			geopoint.coordrefsys,
			geopoint.coordformat,
	geopoint.userinputformat		geopoint.userinputformat
	~~HAVING~~		ORDER BY
	(geopoint.~~userinputformat <> 'X and Y' AND~~		geopoint.coordrefsys ASC,
	~~geopoint.userinputformat <> 'MGRS' AND~~		geopoint.coordformat ASC,
	geopoint.~~userinputformat <> 'Bearing and distance') OR~~		geopoint.userinputformat ASC
	geopoint.userinputformat ~~is null~~
	</pre>		</pre>

Alnaucler at 14:41, 14 July 2014

2014-07-14T14:41:23Z

← Older revision		Revision as of 16:41, 14 July 2014
Line 44:		Line 44:
	WHERE		WHERE
	userenteredcoord NOT LIKE '%:%'		userenteredcoord NOT LIKE '%:%'
	AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes'		AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes')
	</pre>		</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 14:38, 14 July 2014

2014-07-14T14:38:59Z

← Older revision		Revision as of 16:38, 14 July 2014
Line 28:		Line 28:
	WHERE		WHERE
	userenteredcoord LIKE '%:%'		userenteredcoord LIKE '%:%'
	AND coordformat = 'Decimal Degrees')		AND coordformat = 'Decimal Degrees'
	</pre>		</pre>

Line 44:		Line 44:
	WHERE		WHERE
	userenteredcoord NOT LIKE '%:%'		userenteredcoord NOT LIKE '%:%'
	AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes')		AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes'
	</pre>		</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 12:18, 12 July 2014

2014-07-12T12:18:11Z

← Older revision		Revision as of 14:18, 12 July 2014
Line 15:		Line 15:
	</pre>		</pre>

	This query identifies coordinates where the ''userenteredcoord'' contains ''':''' ~~and the ''userinputformat'~~' ~~and/or~~ '~~'coordformat~~'' ~~are wrong~~		This query identifies coordinates where the ''userenteredcoord'' contains ''':''' when coordformat is ''Decimal Degrees''
	<pre>		<pre>
	SELECT		SELECT
Line 28:		Line 28:
	WHERE		WHERE
	userenteredcoord LIKE '%:%'		userenteredcoord LIKE '%:%'
	AND (coordformat = 'Decimal Degrees'		AND coordformat = 'Decimal Degrees')
	~~OR geopoint.userinputformat <> 'X and Y~~')
	</pre>		</pre>

Alnaucler at 12:16, 12 July 2014

2014-07-12T12:16:22Z

← Older revision		Revision as of 14:16, 12 July 2014
Line 32:		Line 32:
	</pre>		</pre>

	This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains ''':''' ~~and the~~ ''~~userinputformat~~'' ~~and/or~~ ''~~coordformat~~'' ~~are wrong~~		This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains ''':''' when coordformat is ''Degrees:Minutes:Seconds'' OR ''Degrees:Decimal Minutes''
	<pre>		<pre>
	SELECT		SELECT
Line 45:		Line 45:
	WHERE		WHERE
	userenteredcoord NOT LIKE '%:%'		userenteredcoord NOT LIKE '%:%'
	AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes'		AND (coordformat = 'Degrees:Minutes:Seconds' OR coordformat = 'Degrees:Decimal Minutes')
	~~OR geopoint.userinputformat <> 'X and Y~~')
	</pre>		</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]