Documentation of Data Conversion Errors – Chapple Inlet



Documentation of Data Conversion Errors – Chapple Inlet

BAPID: 4355

Proj_Name: Chapple Inlet

Author: Patty McKenna, Sid Tsang and Neale Quan

Organization: Atticus Spatial Information Management Ltd.

Date: February 17, 2006

Summary:of Data Conversion: Source coverages were checked by GIS using ter_check.aml V1.06, required columns were added and/or updated. Project coverage was created by dissolving all existing terrain polygons within the project study area - Problems with edge ties between adjacent mapsheets were identified and fixed at this time. Coverages and report generated from Ter_check were provided to TP for review along with source plots and databases. TP checked for logic errors in the Ter using Excel’s auto-filter function. Corrections and updates to the current (2006) standard were made where possible. TP also checked the Tea, and Tes for coding errors; corrections were made where possible. No outstanding issues to report.

Summary of Errors/Outstanding Issues: Common errors were missing data in the Ter (Polygon) file. Other errors include missing FCODE for lakes (Tea) and sample sites (Tes).

Other Comments: Unresolved errors listed in the detailed errors report might be resolved by reviewing the original typed air photos or field notes. Terrain polygon boundaries FCODEs (solid, dashed, dotted) in the Ter (Arc) file cannot be checked without the original typed air photos; however, SRC_FCODE was checked. There were no terrain features; therefore, no Tef was checked. No geomorphological processes (GEOP_1,2,3) were used in the terrain mapping.

Detailed Conversion Procedures:

Table 1: Detailed Data Conversion Report

|No. |Input |Output file |Field Name |Ter_Tag |Issue/Error |Correction/ |Comment |

| |file(s) | | | | |Procedure | |

|1 |Tea |T4355A.e00 |TEA_TAG | |Did not exist |Added the TEA_TAG field to the |Resolved |

| | | | | | |PAT and AAT | |

|2 |Tea |T4355A.e00 |n/a |n/a |BAPID |Added the BAPID field and |Resolved |

| | | | | | |populated with 4355 | |

|3 |Tea |T4355A.e00 |n/a |n/a |Annotation subclass |The annotation was dropped |Resolved |

| | | | | |IGDS existed but | | |

| | | | | |with no data | | |

|4 |Tea |T4355A.e00 |n/a |n/a |Projection is UTM9 |Changed projection to ALBERS |Resolved |

|5 |Tea |T4355A.e00 |n/a |n/a |No spatial index or |Indexed the spatial coverage and|Resolved |

| | | | | |indexed FCODE |the FCODE item in the PAT and | |

| | | | | | |AAT | |

|6 |Ter |T4355R.e00 |n/a |n/a |Missing fields |Added the following fields: |Resolved |

| | | | | | |PROJ_TYPE | |

| | | | | | |ECP_TAG | |

| | | | | | |PROJ_ID | |

| | | | | | |MAPSH_NBR | |

| | | | | | |TTEX_1C | |

| | | | | | |TTEX_1B | |

| | | | | | |TTEX_1A | |

| | | | | | |SURF_E1A | |

| | | | | | |SURF_E1B | |

| | | | | | |SURF_E1C | |

| | | | | | |STTEX_1C | |

| | | | | | |STTEX_1B | |

| | | | | | |STTEX_1A | |

| | | | | | |SSURF_E1A | |

| | | | | | |SSURF_E1B | |

| | | | | | |SSURF_E1C | |

| | | | | | |TTTEX_1 | |

| | | | | | |TTTEX_1C | |

| | | | | | |TTTEX_1B | |

| | | | | | |TTTEX_1A | |

| | | | | | |TSURFM_1 | |

| | | | | | |TSURFM_Q1 | |

| | | | | | |TSURFM_ST1 | |

| | | | | | |TSURF_E1 | |

| | | | | | |TSURF_E1A | |

| | | | | | |TSURF_E1B | |

| | | | | | |TSURF_E1C | |

| | | | | | |TTEX_2C | |

| | | | | | |TTEX_2B | |

| | | | | | |SURF_E2A | |

| | | | | | |SURF_E2B | |

| | | | | | |SURF_E2C | |

| | | | | | |STTEX_2C | |

| | | | | | |STTEX_2B | |

| | | | | | |STTEX_2A | |

| | | | | | |SSURF_E2A | |

| | | | | | |SSURF_E2B | |

| | | | | | |SSURF_E2C | |

| | | | | | |TTTEX_2 | |

| | | | | | |TTTEX_2C | |

| | | | | | |TTTEX_2B | |

| | | | | | |TTTEX_2A | |

| | | | | | |TSURFM_2 | |

| | | | | | |TSURFM_Q2 | |

| | | | | | |TSURFM_ST2 | |

| | | | | | |TSURF_E2 | |

| | | | | | |TSURF_E2A | |

| | | | | | |TSURF_E2B | |

| | | | | | |TSURF_E2C | |

| | | | | | |TTEX_3C | |

| | | | | | |TTEX_3B | |

| | | | | | |TTEX_3A | |

| | | | | | |SURF_E3A | |

| | | | | | |SURF_E3B | |

| | | | | | |SURF_E3C | |

| | | | | | |STTEX_3C | |

| | | | | | |STTEX_3B | |

| | | | | | |STTEX_3A | |

| | | | | | |SSURF_E3A | |

| | | | | | |SSURF_E3B | |

| | | | | | |SSURF_E3C | |

| | | | | | |TTTEX_3 | |

| | | | | | |TTTEX_3C | |

| | | | | | |TTTEX_3B | |

| | | | | | |TTTEX_3A | |

| | | | | | |TSURFM_3 | |

| | | | | | |TSURFM_Q3 | |

| | | | | | |TSURFM_ST3 | |

| | | | | | |TSURF_E3 | |

| | | | | | |TSURF_E3A | |

| | | | | | |TSURF_E3B | |

| | | | | | |TSURF_E3C | |

| | | | | | |GEOP_INZ1 | |

| | | | | | |GEOP_INZ1A | |

| | | | | | |GEOP_SCM1A | |

| | | | | | |GEOP_INZ1B | |

| | | | | | |GEOP_SCM1B | |

| | | | | | |GEOP_INZ1C | |

| | | | | | |GEOP_SCM1C | |

| | | | | | |GEOP_INZ2 | |

| | | | | | |GEOP_INZ2A | |

| | | | | | |GEOP_SCM2A | |

| | | | | | |GEOP_INZ2B | |

| | | | | | |GEOP_SCM2B | |

| | | | | | |GEOP_INZ2C | |

| | | | | | |GEOP_SCM2C | |

| | | | | | |GEOP_INZ3 | |

| | | | | | |GEOP_INZ3A | |

| | | | | | |GEOP_SCM3A | |

| | | | | | |GEOP_INZ3B | |

| | | | | | |GEOP_SCM3B | |

| | | | | | |GEOP_INZ3C | |

| | | | | | |GEOP_SCM3C | |

| | | | | | |FLDNUM | |

| | | | | | |DRAIN_1A | |

| | | | | | |DRAIN_SEP1 | |

| | | | | | |DRAIN_1B | |

| | | | | | |DRAIN_2A | |

| | | | | | |DRAIN_SEP2 | |

| | | | | | |DRAIN_2B | |

| | | | | | |DRAIN_3A | |

| | | | | | |DRAIN_SEP3 | |

| | | | | | |DRAIN_3B | |

| | | | | | |SLPSTB_CL1 | |

| | | | | | |SLPSTB_CL2 | |

| | | | | | |SLPSTB_CL3 | |

| | | | | | |SFCERO_PT1 | |

| | | | | | |SFCERO_PT2 | |

| | | | | | |SFCERO_PT3 | |

| | | | | | |TTEX_GEN1 | |

| | | | | | |TTEX_GEN2 | |

| | | | | | |TTEX_GEN3 | |

| | | | | | |THKCLS_1 | |

| | | | | | |THKCLS_2 | |

| | | | | | |THKCLS_3 | |

| | | | | | |LSSED_CLS1 | |

| | | | | | |LSSED_CLS2 | |

| | | | | | |LSSED_CLS3 | |

| | | | | | |SESED_CLS1 | |

| | | | | | |SESED_CLS2 | |

| | | | | | |SESED_CLS3 | |

| | | | | | |SLPLL_1A | |

| | | | | | |SLPUL_1A | |

| | | | | | |SLPLL_1B | |

| | | | | | |SLPUL_1B | |

| | | | | | |SLPLL_2A | |

| | | | | | |SLPUL_2A | |

| | | | | | |SLPLL_2B | |

| | | | | | |SLPUL_2B | |

| | | | | | |SLPLL_3A | |

| | | | | | |SLPUL_3A | |

| | | | | | |SLPLL_3B | |

| | | | | | |SLPUL_3B | |

| | | | | | |BAPID | |

|7 |Ter |T4355R.e00 |SMPL_TYPE | |Field name change |Altered the old field names: |Resolved |

| | | |POLY_COM | | |FLDCHKTP | |

| | | | | | |COMMENTS | |

|8 |Ter |T4355R.e00 |FCODE | |Incorrect FCODE |FCODE value of FF84555000 was |Resolved |

| | | | | |value |changed to FF84555210 | |

|9 |Ter |T4355R.e00 |PROJ_ID | | |Populated this field with the |Resolved |

| | | | | | |valid PROJ_ID code | |

|10 |Ter |T4355R.e00 |TER_TAG | |Unpopulated |Populated the TER_TAG field by |Resolved |

| | | | | | |concatenating PROJ_ID, | |

| | | | | | |MAPSH_NBR, POLY_NBR | |

|11 |Ter |T4355R.e00 |n/a |n/a |BAPID |Added the BAPID field to the PAT|Resolved |

| | | | | | |and AAT and populated with 4355 | |

|12 |Ter |T4355R.e00 |n/a |n/a |Annotation subclass |The annotation was dropped |Resolved |

| | | | | |IGDS existed but | | |

| | | | | |with no data | | |

|13 |Ter |T4355R.e00 |n/a |n/a |Projection is UTM10 |Changed projection to ALBERS |Resolved |

|14 |Ter |T4355R.e00 |n/a |n/a |No spatial index or |Indexed the spatial coverage and|Resolved |

| | | | | |indexed FCODE |the FCODE item in the PAT and | |

| | | | | | |AAT | |

|15 |Ter |T4355R.e00 |n/a |n/a |Edgematching between|MAPJOINed the two mapsheets and |Resolved |

| | | | | |mapsheets 103A096 |cleaned up linework | |

| | | | | |and 103H006 | | |

|16 |Ter |T4355R.e00 |COMREL1_2 |n/a |Invalid code | |COMREL1_2 = ‘-‘ |

|17 |Ter |T4355R.e00 |COMREL2_3 |n/a |Invalid code | |COMREL2_3 = ‘1’ |

|18 |Ter |T4355R.e00 |PROJ_TYPE |n/a | |Populated PROJ_TYPE = TSM |Resolved |

|19 |Ter |T4355R.e00 |PROJ_NAME |n/a | |Populated PROJ_NAME = Chapple |Resolved |

| | | | | | |Inlet | |

|20 |Ter |T4355R.e00 |SLP_UNIT |n/a | |Calculated SLP_UNIT = P |Resolved |

|21 |Ter |T4355R.e00 |LEG_TYPE |n/a | |Calculated LEG_TYPE = C |Resolved |

|22 |Ter |T4355R.e00 |SLP_REL, |n/a |Not needed |Dropped the items |Resolved |

| | | |SEDTSFPOT | | | | |

|23 |Tes |T4355S.e00 |SRC_FCODE |n/a |The SRC_FCODE has a | |117 records with the |

| | | | | |value of “FIELD” | |value “FIELD |

|24 |Tes |T4355S.e00 |TES_TAG | |Did not exist |Added the TEA_TAG field to the |Resolved |

| | | | | | |AAT | |

|25 |Tes |T4355S.e00 |n/a |n/a |BAPID |Added the BAPID field to the PAT|Resolved |

| | | | | | |and AAT and populated with 4363 | |

|26 |Tes |T4355S.e00 |n/a |n/a |Annotation subclass |The annotation was dropped |Resolved |

| | | | | |IGDS existed but | | |

| | | | | |with no data | | |

|27 |Tes |T4355S.e00 |n/a |n/a |Projection is UTM9 |Changed projection to ALBERS |Resolved |

|28 |Tes |T4355S.e00 |n/a |n/a |No spatial index or |Indexed the spatial coverage and|Resolved |

| | | | | |indexed FCODE |the FCODE item in the PAT and | |

| | | | | | |AAT | |

| |Tea |T4355A.e00 |FCODE |All |Missing code for |FCODE = GB15300000. Added |Resolved |

| | | |COMMENT | |definite lake. |COMMENT = Lake | |

| |Ter |T4355R.e00 |Surfm_1 |Chapl103A09523|Missing code for |Populated Surfm_1 = N for all |Resolved |

| |(Polygon) | |POLY_COM |Chapl103A09528|lake polygons. |lakes. Add Lake to POLY_COM. | |

| | | | |Chapl103A09535| | | |

| | | | |Chapl103A09543| | | |

| | | | |Chapl103A09550| | | |

| | | | |Chapl103A09558| | | |

| | | | |Chapl103A09562| | | |

| | | | |Chapl103A09567| | | |

| | | | |Chapl103H0057 | | | |

| | | | |Chapl103H00518| | | |

| |Ter |T4355R.e00 |SMPL_TYPE |Chapl103A09533|Missing code. |Based on Fldnum, Smpl_Type = v |Resolved |

| | | | |Chapl103A09563| | | |

| | | | |Chapl103A09566| | | |

| |Ter |T4355R.e00 |COMREL1_2 |Chapl103A09540|Missing code. Data |COMREL1_2 = // |Resolved |

| | | | | |on map but not | | |

| | | | | |updated in Ter. | | |

| |Ter |T4355R.e00 |DRAIN_1 |Chapl103A09540|Missing code. Data |DRAIN_1 = m |Resolved |

| | | | | |on map but not | | |

| | | | | |updated in Ter. | | |

| |Ter |T4355R.e00 |DRAIN_SEP |Chapl103A09540|Missing code. Data |DRAIN_SEP = “-” |Resolved |

| | | | | |on map but not | | |

| | | | | |updated in Ter. | | |

| |Ter |T4355R.e00 |DRAIN_2 |Chapl103A09540|Missing code. Data |DRAIN_2 = p |Resolved |

| | | | | |on map but not | | |

| | | | | |updated in Ter. | | |

| |Ter |T4355R.e00 |SESED_CLS |Chapl103A09540|Missing code. Data |SESED_CLS = vl |Resolved |

| | | | | |on map but not | | |

| | | | | |updated in Ter. | | |

| |Ter |T4355R.e00 |SLPLL_1 |Chapl103A09540|Missing code. Data |SLPLL_1 = 6 |Resolved |

| | | |SLPUL_1 | |on map but not |SLPUL_1 = 27 | |

| | | | | |updated in Ter. | | |

| |Ter |T4355R.e00 |SLPLL_1 |Chapl103H0053 |SLPLL_1 cannot equal|Delete SLPUL_2. |Resolved |

| | | |SLPUL_2 | |SLPUL_2. | | |

| |Ter |T4355R.e00 |Slpll_1 |Chapl103A09531|Slpll_1 cannot be > |Reversed Slpul_1 with Slpll_1 |Resolved |

| | | |Slpul_1 |Chapl103A09518|Slp_ul1 | | |

| | | | |Chapl103A09512| | | |

| |Ter |T4355R.e00 |Slpll_1 |All |Slopes entered as |Converted all slope classes to |Resolved |

| | | |Slpul_1 | |slope classes. |slope ranges in percent based on| |

| | | |Slpll_2 | | |map legend. | |

| | | |Slpul_2 | | | | |

| |Ter |T4360R.e00 |SLP_REL |All |Column for SLP_REL |Codes no longer required. The |Resolved |

| |(Polygon) | | | |at end of database |SLP_REL column was deleted. | |

| | | | | |is not a standard | | |

| | | | | |field. | | |

| |Ter |T4355R.e00 |SEDTSFPOT |All |Column for SEDTSFPOT|Data moved to SESED_CLS column |Resolved |

| | | | | |at end of database |and converted from numbers 1-5 | |

| | | | | |is not a standard |to vl-vh based on map legend. | |

| | | | | |field. | | |

| |Tes |T4355F.e00 |FCODE |All |Missing code. |Used general sample site FCODE =|Resolved |

| |(Point) | | | |Uncertain which |FE25755000 | |

| | | | | |sites were ground or| | |

| | | | | |air calls. | | |

| |Ter (Arc) |T4355R.e00 |FCODE |Chapl_Ter#72 |Incorrect code. |Used generic polygon boundary |Resolved |

| | | | |Chapl_Ter#86 |FCODE for |FCODE = FF84555000 | |

| | | | |Chapl_Ter#95 |approximate terrain | | |

| | | | |Chapl_Ter#103 |polygon boundary was| | |

| | | | |Chapl_Ter#105 |used instead of the | | |

| | | | |Chapl_Ter#107 |generic project | | |

| | | | |Chapl_Ter#112 |boundary FCODE. | | |

| | | | |Chapl_Ter#118 | | | |

| | | | |Chapl_Ter#120 | | | |

| | | | |Chapl_Ter#122 | | | |

| | | | |Chapl_Ter#123 | | | |

| | | | |Chapl_Ter#124 | | | |

| | | | |Chapl_Ter#128 | | | |

| | | | |Chapl_Ter#132 | | | |

| | | | |Chapl_Ter#136 | | | |

| | | | |Chapl_Ter#140 | | | |

| | | | |Chapl_Ter#143 | | | |

| | | | |Chapl_Ter#177 | | | |

| | | | |Chapl_Ter#182 | | | |

| | | | |Chapl_Ter#183 | | | |

| | | | |Chapl_Ter#209 | | | |

| | | | |Chapl_Ter#211 | | | |

| | | | |Chapl_Ter#212 | | | |

| | | | |Chapl_Ter#226 | | | |

| | | | |Chapl_Ter#231 | | | |

| |Ter (Arc) |T4355R.e00 |COMMENT |Chapl_Ter#7 |Polygon boundary |Add COMMENT = Lake |Resolved |

| | | | |Chapl_Ter#9 |follows existing | | |

| | | | |Chapl_Ter#10 |lake boundary. | | |

| | | | |Chapl_Ter#11 | | | |

| | | | |Chapl_Ter#12 | | | |

| | | | |Chapl_Ter#13 | | | |

| | | | |Chapl_Ter#39 | | | |

| | | | |Chapl_Ter#40 | | | |

| | | | |Chapl_Ter#98 | | | |

| | | | |Chapl_Ter#108 | | | |

| | | | |Chapl_Ter#109 | | | |

| | | | |Chapl_Ter#119 | | | |

| | | | |Chapl_Ter#121 | | | |

| | | | |Chapl_Ter#135 | | | |

| | | | |Chapl_Ter#144 | | | |

| | | | |Chapl_Ter#147 | | | |

| | | | |Chapl_Ter#148 | | | |

| | | | |Chapl_Ter#153 | | | |

| | | | |Chapl_Ter#161 | | | |

| | | | |Chapl_Ter#163 | | | |

| | | | |Chapl_Ter#164 | | | |

| | | | |Chapl_Ter#172 | | | |

| | | | |Chapl_Ter#174 | | | |

| | | | |Chapl_Ter#179 | | | |

| | | | |Chapl_Ter#188 | | | |

| | | | |Chapl_Ter#194 | | | |

| | | | |Chapl_Ter#200 | | | |

| | | | |Chapl_Ter#202 | | | |

| | | | |Chapl_Ter#204 | | | |

| | | | |Chapl_Ter#206 | | | |

| | | | |Chapl_Ter#214 | | | |

| | | | |Chapl_Ter#217 | | | |

| | | | |Chapl_Ter#218 | | | |

| | | | |Chapl_Ter#221 | | | |

| | | | |Chapl_Ter#225 | | | |

| | | | |Chapl_Ter#227 | | | |

| | | | |Chapl_Ter#229 | | | |

| | | | |Chapl_Ter#232 | | | |

| | | | |Chapl_Ter#238 | | | |

| | | | |Chapl_Ter#242 | | | |

| | | | |Chapl_Ter#245 | | | |

| | | | |Chapl_Ter#247 | | | |

| | | | |Chapl_Ter#249 | | | |

| |Ter (Arc) |T4355R.e00 |SRC_FCODE |Chapl_Ter#133 |Incorrect code. |Replaced SRC_FCODE = GE14850000 |Resolved |

| | | |COMMENTS |Chapl_Ter#137 |Coded as island but |with GG05800000. Added to | |

| | | | |Chapl_Ter#138 |coastline would be |COMMENTS “Princess Royal Island | |

| | | | |Chapl_Ter#149 |more appropriate. |Coastline”. | |

| | | | |Chapl_Ter#157 | | | |

| | | | |Chapl_Ter#159 | | | |

| | | | |Chapl_Ter#168 | | | |

| | | | |Chapl_Ter#181 | | | |

| | | | |Chapl_Ter#187 | | | |

| | | | |Chapl_Ter#192 | | | |

| |Prj (Arc) |T4355J.e00 |FCODE |Chapl_Prj#1 |Missing code. |FCODE = FF84555000 |Resolved |

| | | | |Chapl_Prj#2 | | | |

| | | | |Chapl_Prj#3 | | | |

| |Tea (Label|T4355A.e00 |FCODE |Chapl_Tea#6 |Invalid code. Old |Replace FCODE WI84555120 with |Resolved |

| |point) | |COMMENT | |WI84555120 FCODE was|FF84555000. Add COMMENT = “Study| |

| | | | | |used instead of |area bdy crosses lake.” | |

| | | | | |project boundary | | |

| | | | | |which also crosses | | |

| | | | | |lake. | | |

| |Tea (Label|T4355A.e00 |FCODE |Chapl_Tea#4 |Invalid code. Old |Replace FCODE WI84555000 with |Resolved |

| |point) | |COMMENT |Chapl_Tea#5 |WI84555100 FCODE was|GB15300000. Add COMMENT = Lake. | |

| | | | | |used instead of | | |

| | | | | |defined lake | | |

| | | | | |boundary. | | |

| |Tea (Label|T4355A.e00 |FCODE |Chapl_Tea#11 |Missing code for |FCODE = GB15300000. |Resolved |

| |point) | |COMMENT | |lake boundary. |Add COMMENT = Lake. | |

| |Tea (Label|T4355A.e00 |COMMENT |Chapl_Tea#1-5,| |Add COMMENT = Lake. |Resolved |

| |point) | | |7-12 | | | |

Detailed Error Report/Outstanding Issues:

None

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download