View source for Land (database table)

{{Quicklinks}}
''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
<br /><br />
The current structure of the Land table is as follows:<br />
<br />
<table>
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
<tr><td>&nbsp;</td></tr>
<tr><td>UUID</td><td>varchar(255)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
<tr><td>RegionUUID</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>LocalLandID</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>Bitmap</td><td>longblob</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>Name</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>Description</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>OwnerUUID</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>IsGroupOwned</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>Area</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>AuctionID</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>Category</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>ClaimDate</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>ClaimPrice</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>GroupUUID</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>SalePrice</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>LandStatus</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>LandFlags</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>MediaAutoScale</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>MediaTextureUUID</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>MediaURL</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>MUSICURL</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>Passhours</td><td>float</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>PassPrice</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>SnapshotUUID</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>UserLocationX</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>UserLocationY</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>UserLocationZ</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>UserLookAtX</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>UserLookAtY</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>UserLookAtZ</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
<tr><td>AuthBuyerID</td><td>varchar(255)</td><td>NO</td><td>00000000-0000-0000-0000-000000000000</td><td></td><td></td></tr>
<tr><td>OtherCleanTime</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr>
<tr><td>Dwell</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td></tr>
</table>

== UUID ==
The unique ID of the Land Parcel.

== RegionUUID ==
The UUID of the region containing this land parcel.

== LocalLandID ==
The number of the parcel.

== Bitmap ==
A block of 512 bytes (4,096 bits) of data with each bit of each byte indicating whether a 4m x 4m piece of a region (the smallest selectable) is in the parcel of land. The block of bytes starts in the bottom left corner of the region, proceeding west-east, south-north. As there are 8 bits in a byte, each byte corresponds to 8 pieces of land in a 256x256 region.

The first bit in the first byte refers to the square piece of land with corners (in region co-ordinates) at:
* (0, 0)
* (4, 0)
* (4, 4)
* (0, 4)

The first byte corresponds to a rectangle with corners at:
* (0 ,0)
* (32,0)
* (32,4)
* (0, 4)

The second byte corresponds to a rectangle with corners at:
* (32, 0)
* (64, 0)
* (64, 4)
* (32, 4)

The ninth byte thus corresponds to a rectangle with corners at:
* (0, 4)
* (32,4)
* (32,8)
* (0, 8)

To determine if a piece of land in the region belongs to the parcel, one should perform a bitwise operation on the byte, e.g.
# byte & 1
# byte & 2
# byte & 4
# byte & 8
# byte & 16
# byte & 32
# byte & 64
# byte & 128

== Name ==
The name of this land parcel.

== Description ==
A description of this land parcel.

== OwnerUUID ==
The UUID of the user who owns this land parcel.

== IsGroupOwned ==
This is set to 1 if the parcel is owned by a group. If it is not group owned it will be 0.

== Area ==
The size of the parcel (in square meters).

== AuctionID ==
To be identified.

== Category ==
This specifies the category the parcel of land is in when doing a search. A value of 0 indicates no category was set, -1 is any category, and positive numbers indicate a specific category.

== ClaimDate ==
The date the parcel of land was claimed by an avatar (ie. the date of sale).

== ClaimPrice ==
To be identified.

== GroupUUID ==
To be identified when Groups are implemented.

== SalePrice ==
If the land is for sale this is the price asked.

== LandStatus ==
''From OpenMetaverse.ParcelStatus''
* -1 : None
* 0 : Leased
* 1 : LeasePending
* 2 : Abandoned

== LandFlags ==
<table>
<caption>OpenMetaverse.ParcelFlags</caption>
<tr><th>Name</th><th align="left">Decimal</th><th align="left">Hex</th><th align="left">Description</th></tr>
<tr>
<th scope="row">None</th>
<td>0</td>
<td>0</td>
<td>No flags set</td>
</tr>
<tr>
<th scope="row">AllowFly</th>
<td>1</td>
<td>1</td>
<td>Allow avatars to fly (a client-side only restriction)</td>
</tr>
<tr>
<th scope="row">AllowOtherScripts</th>
<td>2</td>
<td>2</td>
<td>Allow foreign scripts to run</td>
</tr>
<tr>
<th scope="row">ForSale</th>
<td>4</td>
<td>4</td>
<td>This parcel is for sale</td>
</tr>
<tr>
<th scope="row">AllowLandmark</th>
<td>8</td>
<td>8</td>
<td>Allow avatars to create a landmark on this parcel</td>
</tr>
<tr>
<th scope="row">AllowTerraform</th>
<td>16</td>
<td>10</td>
<td>Allows all avatars to edit the terrain on this parcel</td>
</tr>
<tr>
<th scope="row">AllowDamage</th>
<td>32</td>
<td>20</td>
<td>Avatars have health and can take damage on this parcel.  If set, avatars can be killed and sent home here</td>
</tr>
<tr>
<th scope="row">CreateObjects</th>
<td>64</td>
<td>40</td>
<td>Foreign avatars can create objects here</td>
</tr>
<tr>
<th scope="row">ForSaleObjects</th>
<td>128</td>
<td>80</td>
<td>All objects on this parcel can be purchased</td>
</tr>
<tr>
<th scope="row">UseAccessGroup</th>
<td>256</td>
<td>100</td>
<td>Access is restricted to a group</td>
</tr>
<tr>
<th scope="row">UseAccessList</th>
<td>512</td>
<td>200</td>
<td>Access is restricted to a whitelist</td>
</tr>
<tr>
<th scope="row">UseBanList</th>
<td>1024</td>
<td>400</td>
<td>Ban blacklist is enabled</td>
</tr>
<tr>
<th scope="row">UsePassList</th>
<td>2048</td>
<td>800</td>
<td>Unknown</td>
</tr>
<tr>
<th scope="row">ShowDirectory</th>
<td>4096</td>
<td>1000</td>
<td>List this parcel in the search directory</td>
</tr>
<tr>
<th scope="row">AllowDeedToGroup</th>
<td>8192</td>
<td>2000</td>
<td>Allow personally owned parcels to be deeded to group</td>
</tr>
<tr>
<th scope="row">ContributeWithDeed</th>
<td>16384</td>
<td>4000</td>
<td>If Deeded, owner contributes required tier to group parcel is deeded to</td>
</tr>
<tr>
<th scope="row">SoundLocal</th>
<td>32768</td>
<td>8000</td>
<td>Restrict sounds originating on this parcel to the parcel boundaries</td>
</tr>
<tr>
<th scope="row">SellParcelObjects</th>
<td>65536</td>
<td>10000</td>
<td>Objects on this parcel are sold when the land is purchsaed</td>
</tr>
<tr>
<th scope="row">AllowPublish</th>
<td>131072</td>
<td>20000</td>
<td>Allow this parcel to be published on the web</td>
</tr>
<tr>
<th scope="row">MaturePublish</th>
<td>262144</td>
<td>40000</td>
<td>The information for this parcel is mature content</td>
</tr>
<tr>
<th scope="row">UrlWebPage</th>
<td>524288</td>
<td>80000</td>
<td>The media URL is an HTML page</td>
</tr>
<tr>
<th scope="row">UrlRawHtml</th>
<td>1048576</td>
<td>100000</td>
<td>The media URL is a raw HTML string</td>
</tr>
<tr>
<th scope="row">RestrictPushObject</th>
<td>2097152</td>
<td>200000</td>
<td>Restrict foreign object pushes</td>
</tr>
<tr>
<th scope="row">DenyAnonymous</th>
<td>4194304</td>
<td>400000</td>
<td>Ban all non identified/transacted avatars</td>
</tr>
<tr>
<th scope="row">LindenHome</th>
<td>8388608</td>
<td>800000</td>
<td>No comment in documentation or this one!</td>
</tr>
<tr>
<th scope="row">AllowGroupScripts</th>
<td>33554432</td>
<td>2000000</td>
<td>Allow group-owned scripts to run</td>
</tr>
<tr>
<th scope="row">CreateGroupObjects</th>
<td>67108864</td>
<td>4000000</td>
<td>Allow object creation by group members or group objects</td>
</tr>
<tr>
<th scope="row">AllowAPrimitiveEntry</th>
<td>134217728</td>
<td>8000000</td>
<td>Allow all objects to enter this parcel</td>
</tr>
<tr>
<th scope="row">AllowGroupObjectEntry</th>
<td>268435456</td>
<td>10000000</td>
<td>Only allow group and owner objects to enter this parcel</td>
</tr>
<tr>
<th scope="row">AllowVoiceChat</th>
<td>536870912</td>
<td>20000000</td>
<td>Voice Enabled on this parcel</td>
</tr>
<tr>
<th scope="row">UseEstateVoiceChan</th>
<td>1073741824</td>
<td>40000000</td>
<td>Use Estate Voice channel for Voice on this parcel.  This correspond to unchecking "Restrict voice to this parcel" in the viewer.</td>
</tr>
<tr>
<th scope="row">DenyAgeUnverified</th>
<td>2147483648</td>
<td>80000000</td>
<td>Deny Age Unverified Users</td>
</tr>
</table>

== LandingType ==
The landing point setting for the parcel: 0 is Blocked, 1 is 1anding point set, 2 is for landing allowed anywhere.

== MediaAutoScale ==
A boolean (1 or 0) indicating whether media should be stretched to fit the face of the prim it's displayed on.

== MediaTextureUUID ==
The UUID of a texture. Objects using this texture will show a video stream or web page after they click the video play arrow in their viewer.

== MediaURL ==
The URL of the video stream, or media, to be played in this land.

== MusicURL ==
The URL of the Music station to be played in this land.

== Passhours ==
The length of time that a pass to his parcel is valid.

== PassPrice ==
The cost of a pass to this parcel.

== SnapshotUUID ==
The UUID (key) on the asset table of a picture of this parcel.

== UserLocationX ==
The X co-ordinate of the parcel's landing zone (if set).

== UserLocationY ==
The Y co-ordinate of the parcel's landing zone (if set).

== UserLocationZ ==
The Z co-ordinate of the parcel's landing zone (if set).

== UserLookAtX ==
To be identified.

== UserLookAtY ==
To be identified.

== UserLookAtZ ==
To be identified.

== AuthBuyID ==
The UUID of the User authorised to buy this land.

== OtherCleanTime ==
Other residents objects in the parcel will be automatically returned after this many minutes has elapsed. Set to 0 to disable auto-return of objects.

== Dwell ==
To be identified.

[[Category:Database]]