Hello,
I am new to SpatialWare (MS SQL) and I am having a little trouble figuring
out the syntax to do a coordinate conversion on a point.
When I get a geocode back from MapMarker in NAD, I want to convert it to
the Cartesian projection I am using for my map so I can plot it and get an
accurate distance among other things.
I have tried a couple of different methods but here is my best attempt:
exec sp_spatial_query
'HG_GetString(HG_CSTransform(ST_Spatial(ST_Point(-119.690103,35.920309)),
''Longitude / Latitude (NAD 27 for Continental US)'', ''Equal-Area
Projection (United States)''))'
I am getting the error: Syntax error detected at line 110: syntax error at
'HG_GetString'
Or am I trying to solve my problem in the wrong way?
Also, are there any suggestions for the best projection to use for
California state-wide maps?
Brad Mathews
CTO, Cypress Technology Solutions, Inc.
www.CypressSolutions.com
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
