<div dir="ltr">I was just testing my SQL Server database. <div><br></div><div>I put the data into the server with a Geom.STSrid with value 0<div><br></div><div>My data is inserted at 0,0 because it was a floor plan.</div><div>I still created a spatial index around the extents of the floor plan (i.e. -1000,-1000,1000,1000)</div><div><br></div><div>If I choose LOCAL_CS["Non-Earth (Meter)",LOCAL_DATUM["Local Datum",0],UNIT["Meter", 1],AXIS["X",EAST],AXIS["Y",NORTH]] or XY-M in MapGuide Maestro, the data appears fine in my preview.</div><div><br></div><div><br></div><div><br></div><div><br></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Nov 3, 2020 at 11:53 AM _Jon_ <<a href="mailto:jrizzo@langan.com">jrizzo@langan.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I face a similar quandry to the original poster as I work with the same type<br>
of data. I do not wish to use LL because floor plan data has values<br>
exceeding the range and there are occasions when we need to translate units. <br>
Do you happen to know of any coordinate systems for M, FT or IN that have<br>
ranges that include 0,0 but ranges that go into the thousands?<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html</a><br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a></blockquote></div>