The new column can be added or removed from the layer attribute table.

You can access the layer structure through the Layer properties:

  1. Double click the layer you want to edit or go to Layer tab and click Edit Layer.
  2.  

    cr8editlyr

     

  3. In the Attribute tab choose Edit attributes option.
  4. NMT_Add_New_Column1

  5. Set column name and data type.
  6. Note: When naming the fields:

    • Start with a letter or an underscore (_).
    • Use only English alphabet letters, digits and undescores.
    • Use only lower case.
  7. Click Add button, Close and Save.

 

Note: if you want to attach photos to the newly created column, set String column type.

To see changes in the Data Grid:

  1. Go under Layer Properties and under Display tab click Clear layer tiles button.
  2. Click Save.
  3. Click Refresh Data Grid button.

recache1

Adding Length and Area fields

Length and Area fields are automatically populated fields that display length of the line feature or area of the polygon feature. Values in those can’t be edited as they are automatically generated.

Values displayed in the data grid use units of the map. If the projection uses meters, the values displayed in data grid will also be in meters. If the projection of the map uses degrees, the numbers in the columns will also show degrees units. Map Projection can be checked in Map Properties, Under Advanced tab.

Area and length units can’t be changed unless the layer is reprojected to the projection with desired units. Please note that Area/Length columns have to be removed from layer (Layer Properties – Attributes tab – Edit layer) and added again in order to display the new units.

Note: layer has to be imported into Database. Only layers added to a map from Database can be edited and display area and length.

To add Length column:

  1. Select a database line layer.
  2. Go under the Layer Properties – Attributes tab.
  3. Click Edit attributes button.
  4. From the drop down menu select Length field.
  5.  

    Length1

     

  6. Click Add button, Close and Save.
  7. To see changes in the Data Grid:

  8. Go under Layer Properties and under Display tab click Recache button.
  9. Click Save.
  10. Click Refresh Data Grid button.

To add Area column select a database polygon layer and repeat steps above. Select Area from the drop down menu.

 

Length2

 

Column alias

In the Attribute tab you can also assign alias to layers columns. If you have created column under one name and you wish that other appear in the data grid, type in the alias and that will be visible name for selected column.

 

cr8editlyr1

 

Click Save and refresh Data Grid.

Changing column order

To reorder columns order hold and drag the dots next to the layer name.

 

cr8editlyr2

 

 

Click Save and refresh Data Grid to see changes.

You can also access database layer structure through the Database Manager.

Under the Tools tab, choose the Database Manager and it will open the list of all layers imported into the database on your GIS Cloud account.

To make changes on the specific layer select layer and under the Actions drop-down select Edit fields. Edit option will guide you to the same panel for structural changes like to one we have entered over the Layer properties.