Database fields in category Metadata

Label Description
id
datadxny
Row identifier within datadxny table
tblorder
datadxny
Order in which this table should appear in some presentations
tblname
datadxny
Name of the table
number
datadxny
Order in which this field occurs in the RDBMS
label
datadxny
Label of the field in the RDBMS
category
datadxny
General category of information provided by the contents of the field
short_desc
datadxny
Descriptive name of the field used in some presentations, not constrained by rules affecting the label
description
datadxny
Longer description of the purpose and contents of the field
link
datadxny
URL providing more information about the field
origin
datadxny
Abbreviation of an organization, data set, or other entity responsible for defining the field
sqltype
datadxny
Data type of the field as used in the RDBMS
dbftype
datadxny
Data type of the field when expressed in DBF
width
datadxny
Field width when expressed in DBF
prec
datadxny
Precision of the field (places to right of decimal) when expressed in DBF, only for numeric fields
units
datadxny
Units of measure of the field values

datadxny
Data dictionary, explaining tables and fields
gid
points
Row identifier in the table
id
points
Point identifier
map_number
points
Numbered location on the map (plates)
notes
points
Notes about the digitizing process
desc_id
points
Record in the descriptions table providing more detail for this point
id
descriptions
Table row number
map_number
descriptions
Location number on map
source
descriptions
Source of information
point_id
descriptions
Record in the points table providing coordinates for this site