Paving/mapping.py at master · joshdwall/Paving · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
#inspection data locations based on column number
#############################################################
##########         COLUMNS START AT 0        ################
# subtract 1 from actual excel column number or your data
#############################################################


#Size REQUIRED for accurate PCI#
INSPECTED_SIZE=3

INSPECTED_DATE=41
#Name which will be truncated ex: CS Smith Rd. to CSSSmithRd in scratchXML
INSPECTED_PID1=2
INSPECTED_PID2=0
#comment if any
DCOMMENT=57
#width and length of road
P_LENGTH=3
P_WIDTH=4

#distresscode data locations based on column
#E= exctent, S= severity
#Severity: 1= low, 2=med, 3=high
#Need quantity and other distresses

SAMPLENUMBER=3
SAMPLESIZE=40


SWEATHERING_CODE=4
SWEATHERING_S=5
SWEATHERING_Q=6


ALLIGATOR_CODE=7
ALLIGATOR_S=8
ALLIGATOR_Q=9


BLOCKCRACK_CODE=10
BLOCKCRACK_S=11
BLOCKCRACK_Q=12

TRANSVERSE__CODE=13
TRANSVERSE_S=14
TRANSVERSE_Q=15

DEPRESSION_CODE=16
DEPRESSION_S=17
DEPRESSION_Q=18

POTHOLE_CODE=19
POTHOLE_S=20
POTHOLE_Q=21


EDGECRACKING_CODE=22
EDGECRACKING_S=23
EDGECRACKING_Q=24


JOINTSPALLING_CODE=25
JOINTSPALLING_S=26
JOINTSPALLING_Q=27

DURABILITYCRACKING_CODE=28
DURABILITYCRACKING_S=29
DURABILITYCRACKING_Q=30

FAULTING_CODE=31
FAULTING_S=32
FAULTING_Q=33

PATCHING_CODE=34
PATCHING_S=35
PATCHING_Q=36

BUMPSAG_CODE=37
BUMPSAG_S=38
BUMPSAG_Q=39