· MapUnitDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by MapUnitID for each record. Domain: 427 = the DataSetID for the MapUnits table.
· MConf: Character, width 16. For polygons of type “Rock Volume Map Unit” (ID = 2406) or “Surficial Map Unit” (ID = 2405), this field contains a text string that indicates the subjective confidence of the person making the map unit classification in the assignment of the material within the polygon to a particular rock volume or surficial geologic map unit. Otherwise the field does not contain a value. Domain: ‘low’, ‘standard’, or ‘high’.
·
Label: Character, width 50. This field contains
strings that are equivalent to the geologic map unit labels on the default map
visualization. This attribute represents the default classification of each
polygon to a particular rock unit and is included to make symbolizing and viewing
the default map visualization relatively simple. The label is queried if the
classification confidence is low. In addition, map labels with Tertiary,
Pennsylvanian, Precambrian, Cambrian, Paleozoic, or Mesozoic geologic age
prefixes are shown using their corresponding special font symbols included in
the AZGSArial font (included with this database, /support/fonts/Azgsa___.ttf).
When shown in the default ArcView font, as in ArcView tables, these special
characters are displayed as follows: _files/image002.jpg){kind=small}
= ² (Alt-0178) ; _files/image004.jpg){kind=small}
= ³ (Alt-0179); _files/image006.jpg){kind=small}
= ¹ (Alt-0185); _files/image008.jpg){kind=small}
= º (Alt-0186); _files/image010.jpg){kind=small}
= ¼ (Alt-0188); and _files/image012.jpg){kind=small}
= ¾ (Alt-0190). Domain: Free text.
· Name: Character, width 255. This field contains strings that are equivalent to the geologic map unit names in the map explanation on the default map visualization. This is a redundant field added to simplify the use of the dataset in non-relational database environments. Domain: Free text.
Arc Attributes
· ObjectID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies each feature in the RoskGeo arc coverage. Each feature has a different value. Domain: >0 and <1016, no duplicates.
· DataSetID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies the RoskGeo arc coverage. All features in the dataset have the same value. Domain: 422 = the DataSetID for this table in the DataSetAZ dataset.
· Accuracy: Integer, width 8. This field contains an integer value that represents the spatial uncertainty in the location of a feature, in meters. For example, a value of 10 for a line feature indicates that the geologic entity represented by the line on the default map visualization is within 10 meters of the mapped feature’s actual location on the ground. At present this uncertainty combines the geologic uncertainty in the accuracy of location (e.g. for a gradational or poorly exposed contact), and the numerical uncertainty in the computer representation of the line location resulting from accumulated calculation and digitizing errors. The uncertainty must be greater than the numerical precision of the X,Y coordinates that locate a point (i.e. the accuracy cannot exceed the precision). This value determines the line style that represents the line by using standard solid, dashed, and dotted lines. For most existing maps, this length will be based on standard map accuracy, i.e. the geologic entity is located within the width of the line shown on a map for a solid line. In this data set, location uncertainties are qualitatively estimated. A value of 0 indicates that accuracy is not defined, as in the case of cartographic lines. Domain: >numerical precision of data and <108.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each object. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID for each record. Domain: 18 = the DataSetID for the TrackingRecord table.
· ConceptID: Integer, width 16. This field contains an integer value that specifies the concept used to identify the kind of spatial feature represented by this record. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: See Table 5.
Table 5. Classification concept code values used in the RoskGeo.aat table.
|
ConceptID |
Name |
|
7 |
Contact,
not classified, timing not specified |
|
58 |
Fault,
High-angle, normal separation |
|
596 |
Fault,
Generic high-angle, separation unknown |
|
642 |
Mapping
boundary surface |
|
2423 |
Contact,
intraformational, timing not specified |
· ConceptDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by ConceptID for each record. Domain: 1 = the DataSetID for the ClassificationConcept table.
· CConf: Character, width 16. This field contains a text string that subjectively describes the identification confidence by which an object has been classified. Domain: ‘low’, ‘standard’, or ‘high’.
· CartoObjID: Integer, width 16. This field contains an integer value that identifies the cartographic symbolization for each spatial object on the default map visualization. It is a foreign key that links to the CartoObjID field of the CartographicObject table in the RoskrugeWaterman database. Domain: See Table 6.
Table 6. Cartographic object codes used in RoskGeo.aat table.
|
CartoObjID |
Name |
|
53 |
Null
line symbol |
|
54 |
0.5pt
dashed black line (24K) (Approximate contact) |
|
55 |
0.5
pt solid black line (24K) (Accurate contact) |
|
59 |
1.5pt
dashed black line (24K) (Approximate fault) |
|
60 |
1.5pt
solid black line with queries (24K) (Queried accurate fault) |
|
61 |
1.5pt
solid black line (24K) (Accurate fault) |
|
65 |
2.5pt
solid black line (24K) (Map neat line) |
|
67 |
0.75pt
dotted black line (24K) (Concealed contact) |
|
68 |
0.5pt
solid black line with queries (24K) (Queried accurate contact) |
|
71 |
0.5pt
black line with dash-dot pattern (24K) (Scratch contact) |
· CartoObjDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by CartoObjID for each record. Domain: 21 = the DataSetID for the CartographicObject table.
· Label: Character, width 50. This field, when used, contains strings that identify line features that have a label associated with them, as in the case of named faults. Domain: Free text.
· Name: Character, width 255. This field contains strings that identify the default classification of each type of line and is included for simplification purposes. Features not shown on the default map visualization are indicated here as being hidden. Domain: Free text.
Roskruge Point Coverage
The RoskPnt coverage is a point coverage that represents geologic spatial features located at a distinct point (structural measurement stations, rock samples collection stations...).
Point Attributes
· ObjectID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies each feature in the RoskPnt point coverage. Each feature has a different value. Domain: >0 and <1016, no duplicates.
· DataSetID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies the RoskPnt point coverage. All features in the dataset have the same value. Domain: 424 = the DataSetID for this table in the DataSetAZ dataset.
· Accuracy: Integer, width 8. This field contains an integer value that represents the spatial uncertainty in the location of a feature, in meters. For example, a value of 10 for a point feature indicates that location of the point recorded in the database is within 10 meters of the mapped feature’s actual location on the ground. At present this uncertainty combines the geologic uncertainty in the accuracy of location (e.g. for a gradational or poorly exposed contact), and the numerical uncertainty in the computer representation of the line location resulting from accumulated calculation and digitizing errors. The uncertainty must be greater than the numerical precision of the X,Y coordinates that locate a point (i.e. the accuracy cannot exceed the precision). A value of 0 indicates that accuracy is not defined. Domain: >numerical precision of data and <108.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each object. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· ConceptID: Integer, width 16. This field contains an integer value that specifies the concept used to identify the kind of spatial feature represented by this record. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: 3340 = Field Observation Station.
· ConceptDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by ConceptID. Domain: 1 = the DataSetID for the ClassificationConcept table.
· CConf: Character, width 16. This field contains a text string that subjectively describes the accuracy (classification confidence) for the classification of this object. Domain: ‘low’, ‘standard’, or ‘high’.
· CartoObjID: Integer, width 16. This field contains an integer value that identifies the cartographic symbolization for each spatial object on the default map visualization. It is a foreign key that links to the CartoObjID field of the CartographicObject table in the RoskrugeWaterman database. Domain: See Table 7.
Table 7. Cartographic object codes used in the RoskPnt.pat table.
|
CartoObjID |
Name |
|
52 |
Null point symbol |
|
2055 |
Inclined bedding symbol - color black (24K) |
|
2056 |
Approximate inclined bedding symbol - color black (24K) |
|
2057 |
Inclined crenulated or warped bedding symbol - color black (24K) |
|
2058 |
Inclined bedding w/tops known symbol - color black (24K) |
|
2059 |
Overturned bedding symbol - color black (24K) |
|
2060 |
Overturned bedding w/tops known symbol - color black (24K) |
|
2062 |
Vertical bedding symbol - color black (24K) |
|
2064 |
Vertical bedding w/tops known symbol - color black (24K) |
|
2076 |
Generic inclined foliation symbol - color black, open triangle (24K) |
|
2093 |
Inclined eutaxitic foliation symbol - color black (24K) |
|
2096 |
Inclined flow foliation symbol - color black (24K) |
|
2110 |
Inclined close disjunct cleavage symbol - color black (24K) |
|
2111 |
Vertical close disjunct cleavage symbol - color black (24K) |
|
2115 |
Inclined bedding parallel to cleavage symbol - color black (24K) |
|
2128 |
Horizontal joint symbol - color black, open rectangle (24K) |
|
2129 |
Inclined joint symbol - color black, open rectangle (24K) |
|
2143 |
Minor anticline symbol - color red (24K) |
|
2165 |
Fault attitude symbol - color black (24K) |
|
2172 |
Circle with filled central circle (USGS 26.2.5) - color black (24K) |
· CartoObjDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by CartoObjID. Domain: 21 = the DataSetID for the CartographicObject table.
· Label: Character, width 50. This field, when used, contains strings that are equivalent to any labels associated with point features on the default map visualization. In this database, this field contains sample identification numbers or is empty. Domain: Free text.
· Rotation: Integer, width 4. This field contains an integer value that specifies the rotation of the font symbol to correctly represent the azimuth of the of geologic feature displayed on the default map visualization at this point. This value is specific to the graphical environment of ArcView 3.2 using the AZGSgeo.ttf font (/support/fonts directory in the distribution package); the rotation angle is measured anticlockwise, starting from a compass azimuth of 90º, and is also dependent on the orientation of the symbol in its font definition. Domain: 0 to ±360.
· Name: Character, width 255. This field contains strings that identify the default classification of each type of point and is included for simplification purposes. Features not shown on the default map visualization are indicated here as being hidden. Domain: Free text.
GEOLOGIC SHAPEFILES
One ESRI shape file containing geologic lines is included in the geospatial database for DI-19. This shapefile, and the user-defined features included in its feature attribute table, is summarized in Table 8.
Table 8. Summary of geologic shapefiles showing fields, field definitions, and associated database tables. The ObjectID field, along with the DataSetID field, is the compound primary key for each shapefile. If a field joins to a lookup table, the table name is shown adjacent to that field in the last column.
|
Shapefile Name |
Type |
Field Name |
Data Type |
Width |
Lookup Tables |
|
|
Line |
ObjectID DataSetID Accuracy TrackingID TrackingDS ConceptID ConceptDS CConf CartoObjID CartoObjDS Label Name |
Integer Integer Integer Integer Integer Integer Integer Character Integer Integer Character Character |
16 16 8 16 16 16 16 16 16 16 50 255 |
|
Roskruge Other Geologic Lines Shapefile
The RoskGeoLines shapefile is a line shapefile that contains
those geologic lines that do not define polygon topology (concealed faults,
fold hinges, dikes, marker beds...).
Arc Attributes
· ObjectID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies each feature in the RoskGeoLines line shapefile. Each feature has a different value. Domain: >0 and <1016, no duplicates.
· DataSetID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies the RoskGeoLines line shapefile. All features in the dataset have the same value. Domain: 423 = the DataSetID for this table in the DataSetAZ dataset.
· Accuracy: Integer, width 8. This field contains an integer value that represents the spatial uncertainty in the location of a feature, in meters. For example, a value of 10 for a line feature indicates that the geologic entity represented by the line on the default map visualization is within 10 meters of the mapped feature’s actual location on the ground. At present this uncertainty combines the geologic uncertainty in the accuracy of location (e.g. for a gradational or poorly exposed contact), and the numerical uncertainty in the computer representation of the line location resulting from accumulated calculation and digitizing errors. The uncertainty must be greater than the numerical precision of the X,Y coordinates that locate a point (i.e. the accuracy cannot exceed the precision). This value determines the line style that represents the line by using standard solid, dashed and dotted lines. For most existing maps, this length will be based on standard map accuracy, i.e. the geologic entity is located within the width of the line shown on a map for a solid line. A value of 0 indicates that accuracy is not defined, as in the case of cartographic lines or the map neatline. Domain: >numerical precision of data and <108.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each object. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingDS. Domain: 18 = the DataSetID for the TrackingRecord table.
· ConceptID: Integer, width 16. This field contains an integer value that specifies the classification concept used to identify the kind of spatial feature represented by this record. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: See Table 9.
Table 9. Classification concept codes used in the RoskGeoLines table.
|
ConceptID |
Name |
|
58 |
Fault, High-angle, normal separation |
|
530 |
Vein |
|
596 |
Fault, Generic high-angle, separation unknown |
|
612 |
Marker bed |
|
1988 |
Fold hinge surface, upright anticline |
|
1994 |
Fold hinge surface, upright syncline |
|
2379 |
Mafic dike |
|
2380 |
Intermediate dike |
|
2381 |
Felsic dike |
· ConceptDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by ConceptID. Domain: 1 = the DataSetID for the ClassificationConcept table.
· CConf: Character, width 16. This field contains a text string that subjectively describes the confidence for the classification of this object. Domain: ‘low’, ‘standard’, or ‘high’.
· CartoObjID: Integer, width 16. This field contains an integer value that identifies the cartographic symbolization for each spatial object on the default map visualization. It is a foreign key that links to the CartoObjID field of the CartographicObject table in the RoskrugeWaterman database. Domain: See Table 10.
Table 10. Cartographic object codes used in the RoskGeoLines table.
|
CartoObjID |
Name |
|
53 |
Null line symbol |
|
56 |
0.35pt dashed red line (24K) (Approximate fold hinge line) |
|
58 |
0.35pt solid red line (24k) (Accurate fold hinge line) |
|
63 |
1.75pt dotted black line (24K) (Concealed fault) |
|
66 |
0.5pt solid black line with perpendicular hashes (24K) (Dike symbol) |
|
69 |
0.5pt solid black line with spaced X's (24K) (Dike symbol) |
|
70 |
0.5pt solid black line with open circles (24K) (Vein symbol) |
|
72 |
0.5pt black line with dash-dot-dot pattern (24K) (Marker bed) |
|
73 |
0.35pt dotted red line (24K) (Concealed fold hinge line) |
|
74 |
0.5pt solid black line with alternating slashes (24K) (Dike symbol) |
· CartoObjDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by CartoObjID. Domain: 21 = the DataSetID for the CartographicObject table.
· Label: Character, width 50. This field, when used, contains strings that identify line features that have a label associated with them, as in the case of dikes that are associated with a particular geologic map unit. Domain: Free text.
· Name: Character, width 255. This field contains strings that identify the default classification of each type of line and is included for simplification purposes. Features not shown on the default map visualization are indicated here as being hidden. Domain: Free text.
CARTOGRAPHIC SHAPEFILES
The ArcView shapefiles below contain the cartographic elements for the
default map visualization for DI-19. These shapefiles, and the user-defined
features included in their feature attribute tables, are summarized in Table
11.
Because the locations of points and lines in these shapefiles are chosen to
provide cartographic clarity, the Accuracy and CConf fields are
irrelevant and therefore not included.
Table 11. Summary of cartographic shapefiles showing fields, field definitions, and associated database tables. The ObjectID field, along with the DataSetID field, is the compound primary key for each shapefile. If a field joins to a lookup table, the table is shown adjacent to that field in the last column.
|
Shapefile Name |
Type |
Field Name |
Data Type |
Width |
Lookup Tables |
|
||||||
|
|
Line |
ObjectID DataSetID TrackingID TrackingDS ConceptID ConceptDS CartoObjID CartoObjDS Name |
Integer Integer Integer Integer Integer Integer Integer Integer Character |
16 16 16 16 16 16 16 16 255 |
|
||||||
|
|
Point |
ObjectID DataSetID TrackingID TrackingDS ConceptID ConceptDS CartoObjID CartoObjDS Label Rotate Name |
Integer Integer Integer Integer Integer Integer Integer Integer Character Integer Character |
16 16 16 16 16 16 16 16 50 4 255 |
|
||||||
Roskruge Cartographic Lines Shapefile
The RoskCartoLines shapefile contains the cartographic lines
(text lead-in lines...) used in the default map visualization. The location of
these lines has no geologic significance.
Arc Attributes
· ObjectID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies each feature in the RoskCartoLines line shapefile. Each feature has a different value. Domain: >0 and <1016, no duplicates.
· DataSetID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies the RoskCartoLines line shapefile. All features in the dataset have the same value. Domain: 425 = the DataSetID for this table in the DataSetAZ dataset.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each object. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· ConceptID: Integer, width 16. This field contains an integer value that specifies the classification concept used to identify the kind of spatial feature represented by this record. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: 2396 = Text lead-in line; 2419 = Cross Section Surface trace.
· ConceptDS: Integer, width 16. This field contains an integer value that identifies the dataset that contains the data object identified by ConceptID. Domain: 1 = the DataSetID for the ClassificationConcept table.
· CartoObjID: Integer, width 16. This field contains an integer value that identifies the cartographic symbolization for each spatial object on the default map visualization. It is a foreign key that links to the CartoObjID field of the CartographicObject table in the RoskrugeWaterman database. Domain: 53 = Null line symbol; 57 = 0.35pt solid black line (24K).
· CartoObjDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by CartoObjID. Domain: 21 = the DataSetID for the CartographicObject table.
· Label: Character, width 50. This field, when used, contains strings that identify line features that have a label associated with them. Domain: Free text.
· Name: Character, width 255. This field contains strings that identify the default classification of each type of line and is included for simplification purposes. Domain: Free text.
Roskruge Cartographic Points Shapefile
The RoskCartoPnts shapefile contains the cartographic points (text labels, fault symbols, fold geometry symbols...) used in the default map visualization . The locations of these points have no direct geologic significance.
Point Attributes
· ObjectID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies each feature in the RoskCartoPnts point coverage. Each feature has a different value. Domain: >0 and <1016, no duplicates.
· DataSetID: Integer, width 16. Compound primary key. This field contains an integer value that uniquely identifies the RoskCartoPnts point coverage. All features in the dataset have the same value. Domain: 426 = the DataSetID for this table in the DataSetAZ dataset.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each object. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· ConceptID: Integer, width 16. This field contains an integer value that specifies the classification concept used to identify the kind of spatial feature represented by this record. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: See Table 12.
Table 12. Classification concept codes used in the RoskCartoPnts table.
|
ConceptID |
Name |
|
3057 |
Discrete feature point symbols |
|
3317 |
Annotation, unit label |
|
3318 |
Annotation, structural measurement label |
|
3321 |
Annotation, generic text |
· ConceptDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by ConceptID. Domain: 1 = the DataSetID for the ClassificationConcept table.
· CartoObjID: Integer, width 16. This field contains an integer value that identifies the cartographic symbolization for each spatial object on the default map visualization. It is a foreign key that links to the CartoObjID field of the CartographicObject table in the RoskrugeWaterman database. Domain: See Table 13.
Table 13. Cartographic object codes used in the RoskCartoPnts table.
|
CartoObjID |
Name |
|
2134 |
anticline symbol |
|
2137 |
syncline symbol |
|
2169 |
normal fault symbol |
|
2177 |
plunge arrowhead |
|
2270 |
structural measurement label |
|
2270 |
unit label |
|
2271 |
dike label |
|
2271 |
generic text label |
|
2271 |
structural measurement label |
|
2271 |
unit label |
|
2272 |
dike label |
|
2272 |
generic text label |
|
2272 |
unit label |
|
2273 |
generic text label |
|
2275 |
unit label |
|
2276 |
unit label |
|
2277 |
unit label |
|
2279 |
generic text label |
· CartoObjDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by CartoObjID. Domain: 21 = the DataSetID for the CartographicObject table.
· Rotation: Integer, width 4. This field contains an integer value that specifies the rotation of the font symbol to correctly represent the azimuth of the of geologic feature displayed on the default map visualization at this point. This value is specific to the graphical environment of ArcView 3.2 using the AZGSgeo.ttf font (/support/fonts directory in the distribution package); the rotation angle is measured anticlockwise, starting from a compass azimuth of 90º, and is also dependent on the orientation of the symbol in its font definition. Domain: 0 to ±360.
· Label: Character, width 50. This field, when used, contains strings that identify point features that have a label associated with them. For text label points, the field contains strings that are equivalent to the text labels that appear on the default map visualization. Domain: Free text.
· Name: Character, width 255. This field contains a text string that identifies the default classification of each type of point and is included for simplification purposes. Domain: Free text.
ROSKRUGE-SPECIFIC DATABASE TABLES
The two lookup tables defined below contain supporting information
specific to DI-19. These tables, summarized in Table 14, are
included as a Microsoft Access database. By default, each dataset field below
references a table that is included in the Arizona Geological Survey namespace.
Table 14. Summary of project-specific Microsoft Access database tables showing fields, field definitions, and associated database tables. If a field joins to a lookup table, the table name is shown adjacent to that field in the last column.
|
Table Name |
Field Name |
Data Type |
Width |
Lookup Tables |
|
|
MapUnitID DataSetID TrackingID TrackingDS MapLabel Name Description |
Number Number Number Number Text Text Memo |
Long
Integer Long
Integer Long
Integer Long
Integer 50 255 |
|
|
|
StructMeasureID DataSetID SpObjID SpObjDS TrackingID TrackingDS Name StructMeasureTypeID StructMeasureTypeDS ConceptConfidence UTME UTMN LocErr Azimuth AzimuthErr Dip DipErr DipDirection |
Number Number Number Number Number Number Text Number Number Text Number Number Number Number Number Number Number Text |
Long
Integer Long
Integer Long
Integer Long
Integer Long
Integer Long
Integer 255 Long
Integer Long
Integer 16 Single Single Single Single Single Single Single 16 |
|
|
|
ObjectID DataSetID SampleID SampleDS TrackingID TrackingDS Sample AnalyticalResults (13 fields) |
Number Number Number Number Number Number Text Number |
Long
Integer Long
Integer Long
Integer Long
Integer Long
Integer Long
Integer 255 Single |
|
|
|
ObjectID DataSetID ActivityID ActivityDS FieldID DataCollected UTME UTMN UTMzone SpObjID SpObjDS Area Quadrangle RockUnitID RockUnitDS MapUnit Notes TrackingID TrackingDS |
Number Number Number Number Text Date Number Number Number Number Number Text Text Number Number Text Memo Number Number |
Long
Integer Long
Integer Long
Integer Long
Integer 30 dd/mm/yy Single Single Long
Integer Long
Integer Long
Integer 255 255 Long
Integer Long
Integer 50 Long
Integer Long
Integer |
|
|
|
ObjectID DataSetID SampleID SampleDS TrackingID TrackingDS Sample AnalyticalResults (20 fields) |
Number Number Number Number Number Number Text Number |
Long
Integer Long
Integer Long
Integer Long
Integer Long
Integer Long
Integer 255 Single |
|
Map Unit Table
The MapUnits table defines the map units used to classify polygons in the Roskruge Geology coverage.
Database Table Fields
· MapUnitID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each geologic map unit in the MapUnits dataset. Domain: >0 and <1016, no duplicates.
· DataSetID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the MapUnits dataset. Domain: 427 = the DataSetID for this table in the DataSetAZ dataset.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each record. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· OriginDate: Date/Time, short date. This field contains a date value, in the mm/dd/yy format, that records when the record was created. This information provides more detailed information on the time that records were originally entered, supplementing the information in the associated TrackingRecord table. Domain: Valid date.
·
MapLabel: Text, width 25. This field contains
strings used to label polygons on the default geologic map visualization. These
map labels do not necessarily correspond to the map labels in the Label
field of the RoskGeo.pat table for the
polygon that contains the point. This is because some generalization of the
geology has been made for the default visualization, and because labels may be
located outside of the polygon they identify. Map labels with Tertiary,
Pennsylvanian, Precambrian, Cambrian, Paleozoic, or Mesozoic geologic age
prefixes are shown using their corresponding special font symbols included in
the AZGSArial True Type font (/support/fonts/ Azgsa___.ttf). When shown in the
default ArcView font, as in ArcView tables, these prefixes map to the following
characters: _files/image013.jpg){kind=small}
= ² (Alt-0178) ; _files/image014.jpg){kind=small}
= ³ (Alt-0179); _files/image015.jpg){kind=small}
= ¹ (Alt-0185); _files/image016.jpg){kind=small}
= º (Alt-0186); _files/image017.jpg){kind=small}
= ¼ (Alt-0188); and _files/image018.jpg){kind=small}
= ¾ (Alt-0190). Domain: Limited to the map labels on the original
source maps.
· Name: Text, width 255. This field contains a text string that identifies the map unit name or rock type. Domain: Free text.
· Description: Memo. This field contains a full description of the rock unit. Domain: Free text.
Roskruge Structural Measurement Data Table
The StructureDataRoskruge table contains values that define the
orientation of structural features. The inclusion of both the UTM coordinates
for the station location and a link to a spatial object representing the
station location is redundant, but both forms of location are included for
reliability. If the link with the spatial object data set is corrupted, the StructureDataRoskruge
table still contains sufficient information to locate the station. Likewise,
the StructureDataRoskruge table can be exported for data exchange
without including a data set with location spatial objects. A separate
correlation table to link stations with locations is unnecessary because each
station has a unique location.
Database Table Fields
· StructMeasureID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each structural measurement in the StructureDataRoskruge table. Domain: >0 and <1016, no duplicates.
· DataSetID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the StructureDataRoskruge table. Domain: 429 = the DataSetID for this table in the DataSetAZ dataset.
· SpObjID: Number, long integer. This field contains an integer value that uniquely identifies a field station record in an associated point coverage. It is a foreign key that joins with the ObjectID field of the RoskPnt point coverage. Domain: >0 and <1016, but limited to the values in the ObjectID field of the associated point datasets.
· SpObjDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by SpObjID. Domain: 424 = the DataSetID for the RoskPnt point coverage.
· TrackingID: Number, long integer. This field contains an integer value that uniquely identifies the origin tracking for each record. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· Name: Text, width 255. This field contains a text string that provides a descriptive name for each type of structural measurement. Domain: Free text.
· StructMeasureTypeID: Number, long integer. This field contains an integer value that classifies the geologic concept for each structural measurement. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: See Table 15.
Table 15. Structural measurement type codes used in the StructureDataRoskruge table.
|
StructMeasureTypeID |
Name |
|
42 |
Close disjunct cleavage |
|
543 |
Flow foliation |
|
544 |
Eutaxitic foliation |
|
546 |
Foliation, generic |
|
555 |
Joints |
|
559 |
Well developed s-tectonite |
|
563 |
Cleavage parallel to bedding |
|
567 |
Minor fault surface |
|
572 |
Lineation, generic tectonic |
|
581 |
Fold hinge, anticline |
|
588 |
Orientation, fault surface |
|
762 |
Bedding, crude or indistinct |
|
768 |
Bedding, planar parallel |
|
3324 |
Bedding, planar parallel, w/tops |
|
3326 |
Bedding, contorted or variable |
|
3329 |
Fold hinge, syncline |
· StructMeasureTypeDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by StructMeasureTypeID. Domain: 1 = the DataSetID for the ClassificationConcept table.
· ConceptConfidence: Text, width 16. This field contains a text string that subjectively describes the accuracy for the classification of this object. Domain: ‘low’, ‘standard’, or ‘high’.
· UTME: Number, single. This field contains a positive real number that reflects the UTM easting coordinate (X-value), in meters, for the location of the structural measurement. Domain: >0 and <108.
· UTMN: Number, single. This field contains a positive real number that reflects the UTM northing coordinate (Y-value), in meters, for the location of the structural measurement. Domain: >0 and <108.
· LocErr: Number, single. This field contains a real number that records the location error, in meters, for the UTM coordinates. Domain: >0 and <108.
· Azimuth: Number, single. This field contains a positive real number that records the trend or strike of a structural feature in degrees. For planar surfaces, the measurement is recorded using the right-hand rule (i.e. the measurement is made such that the down-dip direction is to the right when facing in the azimuth direction). The magnitude of the angle is measured clockwise starting from a compass azimuth of 0º. Domain: >0 to <360
· AzimuthErr: Number, single. This field contains a real number that records the uncertainty, in degrees, associated with an azimuth measurement. For example, an AzimuthErr of 5 for an Azimuth of 127 would indicate that the azimuth actually falls within the range from 122 to 132 degrees. Domain: >0 and <108.
· Dip: Number, single. This field contains a positive real number that records the angle between a planar or linear feature and horizontal (degrees). The angle is measured in the vertical plane perpendicular to strike for planar features and parallel to trend for linear features. The dip angle here measures total rotation rather than the conventional inclination measurement. For overturned beds this results in dips >90º. This allows conceptually consistent representation of the dip of upright, overturned, or doubly overturned structures. Overturned beds have 90 < dip <=180. Doubly overturned beds have dip >180. Domain: ≥0.
· DipErr: Number, single. This field contains a real number that records the uncertainty, in degrees, associated with a dip measurement. For example, a DipErr of 3 for a Dip of 29 would indicate that the dip actually falls within the range from 26 to 32 degrees. Domain: >0 and <108.
· DipDirection: Text, width 2. This field contains a dip direction modifier, based on compass directions, that may be used as a redundant check for structural measurements recorded using the right-hand rule. Domain: N, NE, E, SE, S, SW, W, NW.
MajorConstituents
The MajorConstituents table contains whole rock chemical analyses for samples listed in the Samples table.
Database Table Fields
· ObjectID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each record in the MajorConstituents table. Domain: >0 and <1016, no duplicates.
· DataSetID: Number, long integer. Compound primary key. This field contains a value of –1 because this dataset is unique to the RoskrugeWaterman database. A system for representing of chemical analyses is still under development at the AZGS.
· SampleID: Number, long integer. Foreign key to the Samples table. This field contains an integer value that identifies the rock sample that was analyzed to produce the data in this record. Domain: >0 and <1016, no duplicates.
· SampleDS: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the Samples table. Domain: 430 = the DataSetID for this table in the DataSetAZ dataset.
· TrackingID: Number, long integer. This field contains an integer value that uniquely identifies the origin tracking for each record. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· Sample: Text, width 30. This field contains a text string that records the sample identifier assigned to the rock collected in the field by the original collector.
· Analytical results: Number, real, single precision. Weight per cent fractions for the following constituents: SiO2, TiO2, Al2O3, Fe2O3 (Total), MnO, MgO, CaO, K2O, Na2O, P2O5, LOI, and Total. Also includes ppm Ba.
Samples
The Samples table contains location and description information for rock samples submitted for chemical analyses reported in the MajorConstituents and TraceElements tables. The inclusion of both the UTM coordinates for the sample location and a link to a spatial object representing the sample location is redundant, but both forms of location are included for reliability. If the link with the spatial object data set is corrupted, the Samples table still contains sufficient information to locate the sample. Likewise, the sample table can be exported for data exchange without including a data set with location spatial objects.
Database Table Fields
· ObjectID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each record in the Samples table. Domain: >0 and <1016, no duplicates.
· DataSetID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the Samples table. Domain: 430 = the DataSetID for this table in the DataSetAZ dataset.
· ActivityID: Number, long integer. Compound primary key. This field contains an integer value that identifies the Activity for collection of the sample. Activities for sample collection should indicate the person who collected the sample. Domain: >0 and <1016, no duplicates.
· ActivityDS: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the Activities dataset. Domain: 2 = the DataSetID for the Activities table.
· FieldID: Text, width 30. This field contains a text string that records the sample identifier assigned to the rock collected in the field by the original collector.
· DateCollected: Date. Date sample was collected.
· UTME: Number, real, single precision. UTM easting coordinate for sample location. Domain: 122000 < UTME < 700000.
· UTMN: Number, real, single precision. UTM northing coordinate for sample location. Domain: 3420000 < UTMN < 4110000.
· UTMzone: Number, long integer. Zone number for UTM coordinates. Domain: 11 or 12 for the State of Arizona.
· SpObjID: Number, long integer. This field contains an integer value that uniquely identifies the field station record in an associated point coverage where the sample was collected. It is a foreign key that joins with the ObjectID field of the RoskPnt point coverage. Domain: >0 and <1016, but limited to the values in the ObjectID field of the associated point datasets.
· SpObjDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by SpObjID. Domain: 424 = the DataSetID for the RoskPnt point coverage.
· Area: Text, width 64. Geographic area name from Arizona Geological Survey Place Names list. Domain: Place names included in Trapp and Reynolds [1998]
· Quadrangle: Text, width 64. Name of USGS 7½ minute quadrangle that contains the sample location. Domain: USGS 7½ Quadrangle names.
· RockUnitID: Number, long integer. This field contains an integer value that uniquely identifies the geologic map unit in the MapUnits dataset from which the sample was collected. Domain: >0 and <1016, no duplicates.
· RockUnitDS: Number, long integer. This field contains an integer value that uniquely identifies the MapUnits dataset. Domain: 427 = the DataSetID for the MapUnits dataset in the DataSetAZ dataset.
·
MapUnit: Text, width 32. Abbreviation for map
unit from which sample was collected that is used on the default map visualization
for the RoskrugeWaterman database. Domain: Map unit labels used in RoskrugeWaterman
database.
·
Notes: Memo. Free text notes on sample.
· TrackingID: Number, long integer. This field contains an integer value that uniquely identifies the origin tracking for each record. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
TraceElements
The TraceElements table contains trace element analyses for samples listed in the Samples table. Twenty trace elements are reported.
Database Table Fields
· ObjectID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each record in the TraceElements table. Domain: >0 and <1016, no duplicates.
· DataSetID: Number, long integer. Compound primary key. This field contains a value of –1 because this dataset is unique to the RoskrugeWaterman database. A system for representing of chemical analyses is still under development at the AZGS.
· SampleID: Number, long integer. Foreign key to the Samples table. This field contains an integer value that identifies the rock sample that was analyzed to produce the data in this record. Domain: >0 and <1016, no duplicates.
· SampleDS: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the Samples table. Domain: 430 = the DataSetID for this table in the DataSetAZ dataset.
· TrackingID: Number, long integer. This field contains an integer value that uniquely identifies the origin tracking for each record. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· Sample: Text, width 30. This field contains a text string that records the sample identifier assigned to the rock collected in the field by the original collector.
· Analytical results: Number, real, single precision. Parts per million (ppm) analyses (except as noted) for the following elements: Sr, Rb, Th, Pb, Ga, Zn, Cu, Ni, Fe203 (wt. %), MnO (wt %), Cr, TiO2 (wt. %), Ba, V, As, U, Y, Zr, Nb, Mo.
ARIZONA GEOLOGIC DATA SYSTEM TABLES
The lookup tables defined below contain the supporting data that
complete the geographic database portion of DI-19. These tables, summarized in Table
16, are
included as a Microsoft Access database. By default, each dataset field below
references a table that is included in the Arizona Geological Survey namespace.
Table 16. Summary of general Microsoft Access database tables showing fields, field definitions, and associated database tables. If a field joins to a lookup table, the table name is shown adjacent to that field in the last column.
|
Table Name |
Field Name |
Data Type |
Field Size |
Lookup Tables |
|
Refnum Cite |
Number Text |
Long Integer 255 |
AzGeoBib [Trapp et al.,
1996] |
|
|
|
ActivityID DataSetID Name PersonOrgID PersonOrgDS ProjectID ProjectDS Comment |
Number Number Text Number Number Number Number Memo |
Long Integer Long Integer 255 Long Integer Long Integer Long Integer Long Integer |
|
|
|
CartoObjID DataSetID Sequence TrackingID TrackingDS Name CartoObjTypeID CartoObjTypeDS GraObjID GraObjDS ColorID ColorDS OriginDate Comment |
Number Number Number Number Number Text Number Number Number Number Number Number Date/Time Memo |
Long Integer Long Integer Integer Long Integer Long Integer 255 Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Short Date |
|
|
|
ConceptID DataSetID TrackingID TrackingDS Name ParentID ParentDS OriginDate Definition |
Number Number Number Number Text Number Number Date/Time Memo |
Long Integer Long Integer Long Integer Long Integer 255 Long Integer Long Integer Short Date |
|
|
|
ColorID DataSetID Name CMYK RGB R G B |
Number Number Text Text Text Number Number Number |
Long Integer Long Integer 255 25 25 Integer Integer Integer |
|
|
|
DataSetID NameSpace NameSpaceID NameSpaceDS DataSetName DataSetTypeID DataSetTypeDS DataSetSubjectID DataSetSubjectDS TrackingID TrackingDS SourceFileTypeID SourceFileTypeDS PhysicalAddressTypeID PhysicalAddressTypeDS PhysicalAddress IdentifierFieldName DataSetFieldName Comment |
Number Text Number Number Text Number Number Number Number Number Number Number Number Number Number Text Text Text Memo |
Long Integer 50 Long Integer Long Integer 255 Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer 255 50 50 |
|
|
|
GraObjID DataSetID Name Width Scale Pattern |
Number Number Text Number Number Text |
Long Integer Long Integer 255 Single Long Integer 50 |
|
|
|
GraObjID DataSetID Name SymbolID SymbolDS Spacing Scale Pattern Offset |
Number Number Text Number Number Number Number Text Number |
Long Integer Long Integer 255 Long Integer Long Integer Single Long Integer 50 Single |
|
|
|
GraObjID DataSetID Name PatternID PatternDS Scale Rotation |
Number Number Text Number Number Number Number |
Long Integer Long Integer 255 Long Integer Long Integer Long Integer Integer |
|
|
|
GraObjID DataSetID FontName Style Spacing Alignment Size Scale ColorID ColorDS |
Number Number Text Text Number Text Number Number Number Number |
Long Integer Long Integer 25 16 Single 25 Single Long Integer Long Integer Long Integer |
|
|
|
RelationshipID DataSetID HierarchyTypeID HierarchyTypeDS ParentID ParentDS ChildID ChildDS TrackingID TrackingDS |
Number Number Number Number Number Number Number Number Number Number |
Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer |
|
|
|
MetadataRelationshipID DataSetID RelTypeID RelTypeDS FirstRoleID FirstRoleDS SecondRoleID SecondRoleDS TrackingID TrackingDS Comment |
Number Number Number Number Number Number Number Number Number Number Memo |
Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer Long Integer |
|
|
(not included in this database) |
|
|
|
|
|
(not included in this database) |
|
|
|
|
|
(not included in this database) |
|
|
|
|
|
|
TrackingID DataSetID TrackingRecordTypeID TrackingRecordTypeDS Name LogDate ActivityID ActivityDS DataProcMethodID DataProcMethodDS Description |
Number Number Number Number Text Date/Time Number Number Number Number Memo |
Long Integer Long Integer Long Integer Long Integer 255 Short Date Long Integer Long Integer Long Integer Long Integer |
|
Bibliographic Citations Table (_AzGeoBibCite)
The _AzGeoBibCite table is derived from the Arizona Geological Survey bibliographic data base (AzGeoBib, Trapp et al. [1996], DataSetID = 4 in the DataSetAZ table), and provides a mechanism for citing published literature. In this database citations are related to tracking records through the MetadataRelationship table. This derivative table is included to replace links to the full AzGeoBib database.
Database Table Fields
· RefNum: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each citation in the _AzGeoBibCite table. Domain: >0 and <1016, no duplicates. The identifiers used here are the same as identifiers for the citation in AzGeoBib.
· Cite: Text, length 255. A text citation in standard bibliographic format (author, date, title, citation).
Activities Table
The Activities table is a link to an activity responsible
for update of, or addition to, the database. An activity is a particular
person, working for a particular organization, under the auspices of a particular
project.
Database Table Fields
· ActivityID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each activity in the Activities table. Domain: >0 and <1016, no duplicates.
· DatasetID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the Activities dataset. Domain: 2 = the DataSetID for the Activities table.
· Name: Text, width 255. This field contains a descriptive string that provides a unique name identifier for each activity. This is the string the is displayed in combo boxes on data entry forms. Domain: Free text.
· PersonOrgID: Number, long integer. This field contains an integer value that uniquely identifies the person and the organization that are associated with each activity. It is a foreign key that links to the PersonOrgID field of the PersonOrg table in the RoskrugeWaterman database (the PersonOrg table is not included with this database, but the PersonOrgID field is included for future compatibility). Domain: See Table 17.
Table 17. PersonOrg codes used in Tracking Records in this database
|
PersonOrgID |
DataSetID |
PersonName |
Organization |
|
1 |
15 |
Dr. Stephen M. Richard |
Arizona Geological Survey |
|
2 |
15 |
Mr. Tim R. Orr |
Arizona Geological Survey |
|
4 |
15 |
Mr. Null N Null |
None |
|
5 |
15 |
Mr. Jason . Brander |
Bureau of Land Management |
|
11 |
15 |
Dr. Philip A. Pearthree |
Arizona Geological Survey |
|
12 |
15 |
Ms. Ann . Youberg |
Arizona Geological Survey |
|
13 |
15 |
Mr. Ray C. Harris |
Arizona Geological Survey |
· PersonOrgDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by PersonOrgID. Domain: 15 = the DataSetID for the PersonOrg link table.
· ProjectID: Number, long integer. This field contains an integer value that identifies the project associated with each activity. It is a foreign key that links to the ProjectID field of the Projects table in the RoskrugeWaterman database (the Projects table is not included with this database, but the ProjectID field is included for future compatibility). Domain: See Table 18.
Table 18. ProjectID codes used in tracking records for this database
|
ProjectID |
ProjectDS |
Project_title |
Prj_comment |
|
1 |
17 |
Arizona NADM implementation development |
Develop NADM 5.2 implementation and use for new geologic map of Arizona database |
|
2 |
17 |
DI-8 Version 3 database development |
Construct NADM-compliant database with geologic data compiled for Map 35. |
|
3 |
17 |
Phoenix N, East Half Database development |
Activities related to development of databases for east half of Phoenix North 30 by 60 minute quadrangle |
|
4 |
17 |
Null |
No project assigned |
|
5 |
17 |
Digitize Geologic Map of Arizona, using MOSS |
get 1:1,000,000 scale geologic map in digital form to assist management decisions |
|
8 |
17 |
Edit Map 26 Data to release as DI8 V.1 |
Get original MOSS version converted to ARC and into a form that could be released |
|
10 |
17 |
Statemap 1999, Waterman Peak 1:24000 quad |
Generate Statemap deliverable, geologic map of Waterman Peak quad |
|
11 |
17 |
TheodoreRoosevelt100KGISV2 |
Generate final, complete 100K geology GIS for Theodore Roosevelt Lake 100K quad. |
|
13 |
17 |
Statemap 1999 Surficial |
Surficial Geologic maps of Avra Valley and Green Valley areas |
|
16 |
17 |
AZ Geologic Map Index database conversion |
conversion of DI-9 (AZ Map Index) to new AZ_NADM datastructure |
|
17 |
17 |
Statemap2000PhxDatabases |
Project to complete 1:24k GIS databases for quads in phoenix area; includes preliminary development work on Waterman-Roskruge database also funded by this project |
|
20 |
17 |
Statemap 1999, Roskruge/Waterman Digital Data |
Digital geologic information for the Roskruge and Waterman Mountains |
· ProjectDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by ProjectID. Domain: 17 = the DataSetID for the Projects table.
· Comment: Memo. This field contains descriptive text about each activity, including the name of the person who conducted the activity, their employing organization, and the project they were working on. Domain: Free text.
Cartographic Object Table
The CartographicObject table is an implementation-independent
representation of symbols used to display points, lines, polygons, and text on
map visualization. This is done by defining links to tables that provide
implementation-dependent descriptions of graphical objects used for
symbolization. Graphical object tables in this database are designed to
describe symbology for ArcView 3.2 running in a Microsoft Windows environment.
Individual cartographic objects may consist of several graphical objects
stacked according to the sequence attribute in the table, with the lowest
sequence symbol overlain by subsequent symbols in the sequence.
Database Table Fields
· CartoObjID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies each cartographic object in the CartographicObject table. Domain: >0 and <1016, no duplicates.
· DatasetID: Number, long integer. Compound primary key. This field contains an integer value that uniquely identifies the CartographicObject dataset. Domain: 21 = the DataSetID for the CartographicObject table.
· Sequence: Number, integer. Compound primary key. This field contains an integer value that corresponds to the layer order in which graphical elements are created. For example, an ornamented line, such as a line with queries, would be created using two layers. The first layer, the line itself, would have a sequence value of 1, while the second layer, the query symbol, would have a sequence value of 2. Domain: >0 and <108.
· TrackingID: Integer, width 16. This field contains an integer value that uniquely identifies the origin tracking for each record. It is a foreign key that links to the TrackingID field of the TrackingRecord table in the RoskrugeWaterman database. Domain: TrackingRecord codeset – RoskrugeWaterman database.
· TrackingDS: Integer, width 16. This field contains an integer value that specifies the dataset that contains the data object identified by TrackingID. Domain: 18 = the DataSetID for the TrackingRecord table.
· Name: Text, width 255. This field contains a text string that uniquely identifies and describes each cartographic object and is included for intelligibility. Domain: Free text.
· CartoObjTypeID: Number, long integer. This field contains an integer value that classifies the graphical element type. It is a foreign key that links to the ConceptID field of the ClassificationConcept table in the RoskrugeWaterman database. Domain: See Table 19.
Table 19. Cartographic object type codes used in the CartographicObject table.
|
CartoObjTypeID |
Name |
|
1957 |
Cartographic Object -- point |
|
1958 |
Cartographic Object -- line |
|
2392 |
Point symbol from font |
|
2393 |
Annotation at point |
|
2408 |
Fill, solid |
|
2409 |
Fill, pattern |
|
3019 |
Line, solid |
|
3020 |
Line symbol, dash-dot pattern |
|
3021 |
Line symbol, ornamented |
· CartoObjTypeDS: Number, long integer. This field contains an integer value that specifies the dataset that contains the data object identified by CartoObjTypeID. Domain: 1 = the DataSetID for the ClassificationConcept table.
· GraObjID: Number, long integer. This field contains an integer value that corresponds to a specific graphical element. It is a foreign key that links to the GraObjID field of either the GraphicLine table, the GraphicLineOrnamented table, the GraphicPattern table, or the GraphicTextFormat table in the RoskrugeWaterman database. Domain: See Table 20.
Table 20. Graphic object codes used in the CartographicObject table.
|
GraObjID |
GraObjDS |
Name |
|
11 |
26 |
thick line (1.5 pt), solid |
|
3 |
26 |
medium thin line (0.35 pt), standard short dash |
|
4 |
26 |
medium thin line (0.35 pt), solid |
|
5 |
26 |
medium line (0.5 pt), standard short dash |
|
6 |
26 |
medium line (0.5 pt), solid |
|
7 |
26 |
medium line (0.5 pt), dash-dot |
|
18 |
26 |
medium thin line (0.35 pt), dotted |
|
14 |
26 |
thick line(1.75 pt), dotted |
|
10 |
26 |
thick line (1.5 pt), standard medium dash |
|
13 |
26 |
very thick line (2.5 pt), solid |
|
19 |
26 |
medium line (0.5 pt), dash-dot-dot |
|
20 |
26 |
medium line (0.75 pt), dotted |
|
14 |
411 |
cross hatch, lines at 30° 90° and 150°, separation = 4 pt. |
|
33 |
411 |
vertical hatch, separation = 1 pt. |
|
13 |
411 |
cross hatch, lines at 0° and 90°, separation = 4 pt. |
|
0 |
411 |
Null Pattern |
|
12 |
411 |
cross hatch, lines at 0° and 90°, separation = 3.25 pt. |