world_safe_locs

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO
MapID	int	unsigned		YES	NULL
LocX	float			YES	NULL
LocY	float			YES	NULL
LocZ	float			YES	NULL
Facing	float			YES	NULL
TransportSpawnId	bigint	unsigned		YES	NULL
Comment	varchar(255)			YES	NULL

 

Description of fields

ID

Unique identifier, as of today ID 7582 is last (leaked) entry since this used to be a shipped DB2 file.
New (custom) IDs should be used per expansion as followed:

Expansion	ID range start	ID range end
Battle for Azeroth (8.x)	80000	89999
Shadowlands (9.x)	90000	99999
Dragonflight (10.x)	100000	109999
The War Within (11.x)	110000	119999

 

MapID

MapID of the location
 

LocX

X coordinate of the location
 

LocY

Y coordinate of the location
 

LocZ

Z coordinate of the location
 

Facing

Facing coordinate of the location in degrees

Note:
Radians to degrees: Radians / (2 * PI() / 360) (you can use this snippet in SQL)

Alternative in Python you can use this gist.
 

TransportSpawnId

- no description -
 

Comment

The usage of the location and where it is (as in zone/map name)