[Opensim-users] How do I get to local position “514/434/21” from global position in tables “884/59/21”

[Luisillo Contepomi]

Thank you very much for your prompt reply Fred.

Please excuse my English. I did not know how to explain myself.

I need to deduce many sURL (the local coordinates) starting from the 
global ones that are in the tables.

I rephrase the question :
How can I get the "local" position = “514/434/21” knowing the "global" 
positions that are in the tables = “884/59/21” ?

Luisillo Contepomi

El 10/10/24 a las 21:20, Fred Beckhusen escribió:
> Wrong question to ask.  These are not possible to get the answer you want from that table.  Its the local cordinate, and is not global.
> 
> The region.ini  have Location = 1000,996 in "region" table locX 256000
> locY 254976 locZ null.
> 
> For global, divide by 256 to get the lower left coordinate of the region.
> 
> These a local coordinates :
> 
> X = 884.666
> Y = 59.6383
> Z = 21.0327
> 
> 
> X i is  884 meters inside of  the region at 1000,996, so the global X is
> 
> Global X = 1000*256  + 884.666 = 256884.555
> Global Y is 996 * 256 + 59.6383 and so on
> Global Z is  21.0327  as it starts at 0.
> 
> Fred
> 
> 
> 
> ________________________________
> From: opensim-users-bounces at opensimulator.org <opensim-users-bounces at opensimulator.org> on behalf of opensim-users-request at opensimulator.org <opensim-users-request at opensimulator.org>
> Sent: Thursday, October 10, 2024 7:00 AM
> To: opensim-users at opensimulator.org <opensim-users at opensimulator.org>
> Subject: Opensim-users Digest, Vol 110, Issue 1
> 
> Send Opensim-users mailing list submissions to
>          opensim-users at opensimulator.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>          http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> or, via email, send a message with subject or body 'help' to
>          opensim-users-request at opensimulator.org
> 
> You can reach the person managing the list at
>          opensim-users-owner at opensimulator.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Opensim-users digest..."
> 
> 
> Today's Topics:
> 
>     1. The relationship between the data indicated in the table land
>        or ossearch_parcels and ossearch_all_parcels "landingpoint" and
>        the "real" landingpoint on the parcel (Luisillo Contepomi)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 9 Oct 2024 19:55:40 +0200
> From: Luisillo Contepomi <luisillocontepomi at gmail.com>
> To: opensim-users at opensimulator.org
> Subject: [Opensim-users] The relationship between the data indicated
>          in the table land or ossearch_parcels and ossearch_all_parcels
>          "landingpoint" and the "real" landingpoint on the parcel
> Message-ID: <4876adee-34b1-4efc-92d2-4143150c2824 at gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> 
> Hi all,
> I am spending time for days with this issue any help will be greatly
> appreciated.
> 
> I am doing my webs for the grid totally new updating to mysqli and php7
> 
> I found a problem with locations for create surl
> 
> The region.ini  have Location = 1000,996 in "region" table locX 256000
> locY 254976 locZ null.
> 
> a parcel named "recreo" is in the world /514/434/21
> 
> table=land
> --------------
> SELECT `UserLocationX`,`UserLocationY`,`UserLocationZ` FROM `land` WHERE
> `Name` like '%recreo%';
> 884.666 59.6383 21.0327
> 
> table=os_search_allparcels
> --------------------------
> SELECT `landingpoint` FROM `os_search_allparcels` WHERE `parcelname`like
> '%recreo%';
> 884.666/59.6383/21.0327
> 
> table=os_search_parcels
> ----------------------------------
> SELECT `landingpoint` FROM `os_search_parcels` WHERE `parcelname`like
> '%recreo%';
> 884.666/59.6383/21.0327
> 
> the same location numbers into three tables but
> teleports to the indicated position are in middle of nowhere in the ocean.
> all regions are 1024x1024
> 
> in the world the real position is
> hop://grid.contepomi.net:8002/Colegio_Hotaru/514/434/21
> 
> Now my question is What is the mathematical relationship between the
> position on the tables and the actual position of the landing point
> marked on the plot?
> 
> How can obtain this "514/434/21" from the data in tables as "884/59/21" ?
> 
> Best regards,
> Luisillo Contepomi
> 
> 
> ------------------------------
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> 
> 
> End of Opensim-users Digest, Vol 110, Issue 1
> *********************************************
>