Automatically Maintained Fields

Top  Previous 

 

The following 9 attribute fields can't be directly edited like the other fields. WallsMap will fill them automatically when appropriate. The location and timestamp fields have specific names ending in an underscore, which tells WallsMap to treat them in a special way. They can also be useful in non-TSS projects, although other GIS programs will treat them as ordinary fields. The TSSID field, on the other hand, is a normal field that has been set read-only and identified as the key field in the shapefile's template component. For newly-added records the TSSID field will remain blank until the data manager uses the Compare with Other Layers function to create a new database snapshot. Once assigned, the TSSID will not be reused, even if the record is eventually deleted.

 

TSSID

Tooltip:

Unique TSS identifier assigned separately, blank for new shapefile records


Type:

7 chars (3-letter county abbreviation followed by 4 digits)


Notes:

Can also be blank if the feature is new, in which case a TSSID is assigned automatically

when the updated shapefile is processed. At least this field should be included in shapefiles prepared to satisfy data requests.

CREATED_

Tooltip:

UTC timestamp with editor's name, filled automatically when a new record is saved


Type:

45 chars


Notes:

Formatted as "yyyy-mm-dd hh:mm:ss name"

WallsMap prompts for the name if one hasn't been established for the session or saved as a program setting on the computer. Many records have "TSS-Export" as the editor's name since they were established prior to July 2009 when timestamping was fully implemented.

UPDATED_

Tooltip:

UTC timestamp with editor's name, filled automatically when either a new record or an edited record is saved


Type:

45 chars


Notes:

Formatted as "yyyy-mm-dd hh:mm:ss name"

As for the CREATED_ field, WallsMap prompts for the name if one hasn't been established.

LATITUDE_

Tooltip:

Latitude in shapefile's native datum, maintained automatically


Type:

11 chars (6 decimal places)


Notes:

You change location via the map or by using the edit boxes at the top of the Selected Points dialog.

LONGITUDE_

Tooltip:

Longitude in shapefile's native datum, maintained automatically


Type:

11 chars (6 decimal places)


Notes:

Same as above

EASTING_

Tooltip:

UTM easting in meters and in shapefile's native datum, maintained automatically


Type:

11 chars (2 decimal places)


Notes:

The shapefile's native coordinate system can be either Lat/Long or UTM

NORTHING_

Tooltip:

UTM northing in meters and in shapefile's native datum, maintained automatically


Type:

11 chars (2 decimal places)


Notes:

Same as above

ZONE_

Tooltip:

UTM zone (13N, 14N, or 15N), maintained automatically


Type:

3 chars


Notes:

Same as above

DATUM_

Tooltip:

Shapefile's native datum, either NAD27 or WGS84


Type:

5 chars


Notes:

Normally the datum will be WGS84. The native datum can differ from that of the map being viewed.