Map of SPCC 2.0 Revised Smoothed Segments Future

Summary Tables of Data Deliverables in GeoDatabase

Data Layers in GDB Deliverable

## [1] "smoothed_segments_future"           "smoothed_segments_existing"        
## [3] "refined_analytic_segments_future"   "refined_analytic_segments_existing"
## [5] "refined_analytic_lu_existing"       "refined_analytic_lu_future"        
## [7] "detailed_analytic_lu_future"        "detailed_analytic_lu_existing"

Summary of Data Layer

GDB layer name: smoothed_segments_future

Data Frame Summary

data

Dimensions: 2781 x 9
Duplicates: 0

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 ROADID
[integer]		 Mean (sd) : 90118764 (3410291)
min < med < max:
86000001 < 89095000 < 94900007
IQR (CV) : 7170000 (0)		 1365 distinct values 0
(0.0%)
2 VALUE
[integer]		 Mean (sd) : 315.3 (150)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.5)		 1 : 52 ( 1.9%)
2 : 351 (12.6%)
307 : 846 (30.4%)
330 : 334 (12.0%)
400 : 1102 (39.6%)
500 : 25 ( 0.9%)
600 : 27 ( 1.0%)
801 : 30 ( 1.1%)
900 : 14 ( 0.5%)		 0
(0.0%)
3 F_MEAS
[numeric]		 Mean (sd) : 18176.2 (34689.7)
min < med < max:
0 < 1270 < 242650
IQR (CV) : 18450 (1.9)		 900 distinct values 0
(0.0%)
4 T_MEAS
[numeric]		 Mean (sd) : 25570.3 (36092.6)
min < med < max:
150 < 10902.3 < 243068.6
IQR (CV) : 23346 (1.4)		 2229 distinct values 0
(0.0%)
5 LENGTH
[integer]		 Mean (sd) : 7393.8 (8602.7)
min < med < max:
102 < 5350 < 125600
IQR (CV) : 5200 (1.2)		 1748 distinct values 0
(0.0%)
6 Shape_Length
[numeric]		 Mean (sd) : 7329.7 (8607.2)
min < med < max:
0.3 < 5308.9 < 125585.1
IQR (CV) : 5245.5 (1.2)		 2781 distinct values 0
(0.0%)
7 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Special District		 52 ( 1.9%)
351 (12.6%)
364 (13.1%)
846 (30.4%)
1102 (39.6%)
25 ( 0.9%)
27 ( 1.0%)
14 ( 0.5%)		 0
(0.0%)
8 FROM_MILES
[numeric]		 Mean (sd) : 3.4 (6.6)
min < med < max:
0 < 0.2 < 46
IQR (CV) : 3.5 (1.9)		 900 distinct values 0
(0.0%)
9 TO_MILES
[numeric]		 Mean (sd) : 4.8 (6.8)
min < med < max:
0 < 2.1 < 46
IQR (CV) : 4.4 (1.4)		 2229 distinct values 0
(0.0%)

GDB layer name: smoothed_segments_existing

Data Frame Summary

data

Dimensions: 2765 x 9
Duplicates: 0

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 ROADID
[integer]		 Mean (sd) : 90104567 (3411297)
min < med < max:
86000001 < 89092000 < 94900007
IQR (CV) : 7170000 (0)		 1365 distinct values 0
(0.0%)
2 VALUE
[integer]		 Mean (sd) : 313 (149.7)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.5)		 1 : 53 ( 1.9%)
2 : 357 (12.9%)
307 : 852 (30.8%)
330 : 334 (12.1%)
400 : 1077 (39.0%)
500 : 27 ( 1.0%)
600 : 23 ( 0.8%)
801 : 31 ( 1.1%)
900 : 11 ( 0.4%)		 0
(0.0%)
3 F_MEAS
[numeric]		 Mean (sd) : 18139 (34615.8)
min < med < max:
0 < 1149 < 242650
IQR (CV) : 18450 (1.9)		 892 distinct values 0
(0.0%)
4 T_MEAS
[numeric]		 Mean (sd) : 25575.9 (36032.9)
min < med < max:
150 < 10941.2 < 243068.6
IQR (CV) : 23406.2 (1.4)		 2220 distinct values 0
(0.0%)
5 LENGTH
[integer]		 Mean (sd) : 7436.6 (8629.3)
min < med < max:
102 < 5387 < 125600
IQR (CV) : 5341 (1.2)		 1750 distinct values 0
(0.0%)
6 Shape_Length
[numeric]		 Mean (sd) : 7372.1 (8634)
min < med < max:
0.3 < 5334.3 < 125585.1
IQR (CV) : 5354.5 (1.2)		 2765 distinct values 0
(0.0%)
7 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Special District		 53 ( 1.9%)
357 (12.9%)
365 (13.2%)
852 (30.8%)
1077 (39.0%)
27 ( 1.0%)
23 ( 0.8%)
11 ( 0.4%)		 0
(0.0%)
8 FROM_MILES
[numeric]		 Mean (sd) : 3.4 (6.6)
min < med < max:
0 < 0.2 < 46
IQR (CV) : 3.5 (1.9)		 892 distinct values 0
(0.0%)
9 TO_MILES
[numeric]		 Mean (sd) : 4.8 (6.8)
min < med < max:
0 < 2.1 < 46
IQR (CV) : 4.4 (1.4)		 2220 distinct values 0
(0.0%)

GDB layer name: refined_analytic_segments_future

Data Frame Summary

data

Dimensions: 8657 x 16
Duplicates: 0

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 ROADID
[integer]		 Mean (sd) : 90089615 (3398162)
min < med < max:
86000001 < 89090000 < 94900007
IQR (CV) : 7140000 (0)		 1365 distinct values 0
(0.0%)
2 ROADWAY
[character]		 1. 93220000
2. 93470000
3. 89030000
4. 89010000
5. 88010000
6. 86470000
7. 86070000
8. 93310000
9. 86080500
10. 86004000
[ 1355 others ]		 128 ( 1.5%)
94 ( 1.1%)
80 ( 0.9%)
76 ( 0.9%)
71 ( 0.8%)
69 ( 0.8%)
64 ( 0.7%)
63 ( 0.7%)
60 ( 0.7%)
57 ( 0.7%)
7895 (91.2%)		 0
(0.0%)
3 RDWYFEAT
[character]		 1. 140 8657 (100.0%) 0
(0.0%)
4 ROAD_STATU
[character]		 1. 02
2. 09
3. 12		 2048 (23.7%)
5408 (62.5%)
1201 (13.9%)		 0
(0.0%)
5 BEGSECPT
[numeric]		 Mean (sd) : 0.7 (3.1)
min < med < max:
0 < 0 < 33.1
IQR (CV) : 0 (4.7)		 193 distinct values 0
(0.0%)
6 ENDSECPT
[numeric]		 Mean (sd) : 8.6 (10.6)
min < med < max:
0 < 3.6 < 46
IQR (CV) : 10 (1.2)		 1234 distinct values 0
(0.0%)
7 ON_SYSTEM
[integer]		 Min : 0
Mean : 0.3
Max : 1		 0 : 6015 (69.5%)
1 : 2642 (30.5%)		 0
(0.0%)
8 GRP_ROADID
[character]		 1. 1-93220000
2. 1-93470000
3. 1-89010000
4. 0-89030000
5. 1-88010000
6. 1-86470000
7. 1-86070000
8. 1-93310000
9. 1-86080500
10. 0-86004000
[ 1386 others ]		 128 ( 1.5%)
94 ( 1.1%)
76 ( 0.9%)
74 ( 0.9%)
71 ( 0.8%)
69 ( 0.8%)
64 ( 0.7%)
63 ( 0.7%)
60 ( 0.7%)
57 ( 0.7%)
7901 (91.3%)		 0
(0.0%)
9 BEGMFT
[integer]		 Mean (sd) : 3472.9 (16211.1)
min < med < max:
0 < 0 < 174784
IQR (CV) : 0 (4.7)		 193 distinct values 0
(0.0%)
10 ENDMFT
[integer]		 Mean (sd) : 45210.8 (55763.9)
min < med < max:
201 < 18823 < 242975
IQR (CV) : 52631 (1.2)		 1234 distinct values 0
(0.0%)
11 Id
[integer]		 Mean (sd) : 1555.5 (1072.5)
min < med < max:
1 < 1359 < 4046
IQR (CV) : 1666 (0.7)		 2713 distinct values 0
(0.0%)
12 gridcode
[integer]		 Mean (sd) : 327 (158.8)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.5)		 1 : 239 ( 2.8%)
2 : 838 ( 9.7%)
307 : 2714 (31.4%)
330 : 1643 (19.0%)
400 : 2712 (31.3%)
500 : 102 ( 1.2%)
600 : 70 ( 0.8%)
801 : 296 ( 3.4%)
900 : 43 ( 0.5%)		 0
(0.0%)
13 Shape_Length
[numeric]		 Mean (sd) : 2355.6 (5642.4)
min < med < max:
0.3 < 982 < 126675
IQR (CV) : 1815.2 (2.4)		 8598 distinct values 0
(0.0%)
14 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Special District		 239 ( 2.8%)
838 ( 9.7%)
1939 (22.4%)
2714 (31.4%)
2712 (31.3%)
102 ( 1.2%)
70 ( 0.8%)
43 ( 0.5%)		 0
(0.0%)
15 FROM_MILES
[numeric]		 Mean (sd) : 0.7 (3.1)
min < med < max:
0 < 0 < 33.1
IQR (CV) : 0 (4.7)		 193 distinct values 0
(0.0%)
16 TO_MILES
[numeric]		 Mean (sd) : 8.6 (10.6)
min < med < max:
0 < 3.6 < 46
IQR (CV) : 10 (1.2)		 1234 distinct values 0
(0.0%)

GDB layer name: refined_analytic_segments_existing

Data Frame Summary

data

Dimensions: 8654 x 16
Duplicates: 0

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1545 (1061.8)
min < med < max:
1 < 1346 < 3999
IQR (CV) : 1668.8 (0.7)		 2704 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 326.9 (159.2)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.5)		 1 : 240 ( 2.8%)
2 : 839 ( 9.7%)
307 : 2713 (31.3%)
330 : 1649 (19.1%)
400 : 2709 (31.3%)
500 : 95 ( 1.1%)
600 : 65 ( 0.8%)
801 : 299 ( 3.5%)
900 : 45 ( 0.5%)		 0
(0.0%)
3 ROADID
[integer]		 Mean (sd) : 90105449 (3396762)
min < med < max:
86000001 < 89092000 < 94900007
IQR (CV) : 7139900 (0)		 1365 distinct values 0
(0.0%)
4 ROADWAY
[character]		 1. 93220000
2. 93470000
3. 89030000
4. 89010000
5. 88010000
6. 86470000
7. 86070000
8. 86080500
9. 93310000
10. 86075000
[ 1355 others ]		 129 ( 1.5%)
91 ( 1.1%)
80 ( 0.9%)
76 ( 0.9%)
71 ( 0.8%)
68 ( 0.8%)
64 ( 0.7%)
63 ( 0.7%)
61 ( 0.7%)
59 ( 0.7%)
7892 (91.2%)		 0
(0.0%)
5 RDWYFEAT
[character]		 1. 140 8654 (100.0%) 0
(0.0%)
6 ROAD_STATU
[character]		 1. 02
2. 09
3. 12		 2041 (23.6%)
5413 (62.5%)
1200 (13.9%)		 0
(0.0%)
7 BEGSECPT
[numeric]		 Mean (sd) : 0.7 (3.1)
min < med < max:
0 < 0 < 33.1
IQR (CV) : 0 (4.7)		 193 distinct values 0
(0.0%)
8 ENDSECPT
[numeric]		 Mean (sd) : 8.6 (10.6)
min < med < max:
0 < 3.6 < 46
IQR (CV) : 9.9 (1.2)		 1234 distinct values 0
(0.0%)
9 ON_SYSTEM
[integer]		 Min : 0
Mean : 0.3
Max : 1		 0 : 6023 (69.6%)
1 : 2631 (30.4%)		 0
(0.0%)
10 GRP_ROADID
[character]		 1. 1-93220000
2. 1-93470000
3. 1-89010000
4. 0-89030000
5. 1-88010000
6. 1-86470000
7. 1-86070000
8. 1-86080500
9. 1-93310000
10. 1-86075000
[ 1386 others ]		 129 ( 1.5%)
91 ( 1.1%)
76 ( 0.9%)
74 ( 0.9%)
71 ( 0.8%)
68 ( 0.8%)
64 ( 0.7%)
63 ( 0.7%)
61 ( 0.7%)
59 ( 0.7%)
7898 (91.3%)		 0
(0.0%)
11 BEGMFT
[integer]		 Mean (sd) : 0.7 (3.1)
min < med < max:
0 < 0 < 33
IQR (CV) : 0 (4.7)		 28 distinct values 0
(0.0%)
12 ENDMFT
[integer]		 Mean (sd) : 45182.8 (55708.1)
min < med < max:
201 < 18924 < 242975
IQR (CV) : 52145 (1.2)		 1234 distinct values 0
(0.0%)
13 Shape_Length
[numeric]		 Mean (sd) : 2356.4 (5635.6)
min < med < max:
0.3 < 1000 < 127624.3
IQR (CV) : 1791.6 (2.4)		 8612 distinct values 0
(0.0%)
14 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Special District		 240 ( 2.8%)
839 ( 9.7%)
1948 (22.5%)
2713 (31.3%)
2709 (31.3%)
95 ( 1.1%)
65 ( 0.8%)
45 ( 0.5%)		 0
(0.0%)
15 FROM_MILES
[numeric]		 Mean (sd) : 0 (0)
min < med < max:
0 < 0 < 0
IQR (CV) : 0 (4.7)		 28 distinct values 0
(0.0%)
16 TO_MILES
[numeric]		 Mean (sd) : 8.6 (10.6)
min < med < max:
0 < 3.6 < 46
IQR (CV) : 9.9 (1.2)		 1234 distinct values 0
(0.0%)

GDB layer name: refined_analytic_lu_existing

Data Frame Summary

data

Dimensions: 10788 x 5
Duplicates: 102

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1402.3 (1056.3)
min < med < max:
1 < 1101.5 < 4000
IQR (CV) : 1660.2 (0.8)		 4000 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 310.2 (205)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.7)		 1 : 743 ( 6.9%)
2 : 1539 (14.3%)
307 : 3033 (28.1%)
330 : 1915 (17.8%)
400 : 2627 (24.4%)
500 : 55 ( 0.5%)
600 : 15 ( 0.1%)
801 : 830 ( 7.7%)
900 : 31 ( 0.3%)		 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 10296.1 (85734.1)
min < med < max:
2000 < 2000 < 3495000
IQR (CV) : 3000 (8.3)		 667 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 17405914 (447121442)
min < med < max:
250000 < 250000 < 27962250000
IQR (CV) : 1000000 (25.7)		 1185 distinct values 0
(0.0%)
5 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Special District		 743 ( 6.9%)
1539 (14.3%)
2745 (25.4%)
3033 (28.1%)
2627 (24.4%)
55 ( 0.5%)
15 ( 0.1%)
31 ( 0.3%)		 0
(0.0%)

GDB layer name: refined_analytic_lu_future

Data Frame Summary

data

Dimensions: 10836 x 5
Duplicates: 72

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1413.6 (1068)
min < med < max:
1 < 1107.5 < 4047
IQR (CV) : 1676 (0.8)		 4047 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 308.9 (204.6)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.7)		 1 : 745 ( 6.9%)
2 : 1568 (14.5%)
307 : 3050 (28.1%)
330 : 1938 (17.9%)
400 : 2603 (24.0%)
500 : 64 ( 0.6%)
600 : 21 ( 0.2%)
801 : 815 ( 7.5%)
900 : 32 ( 0.3%)		 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 9982 (83817.9)
min < med < max:
1874.9 < 2000 < 3618000
IQR (CV) : 3000 (8.4)		 1806 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 17328811 (444568916)
min < med < max:
160095.2 < 250000 < 27759000000
IQR (CV) : 870168.7 (25.7)		 2207 distinct values 0
(0.0%)
5 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Special District		 745 ( 6.9%)
1568 (14.5%)
2753 (25.4%)
3050 (28.1%)
2603 (24.0%)
64 ( 0.6%)
21 ( 0.2%)
32 ( 0.3%)		 0
(0.0%)

GDB layer name: detailed_analytic_lu_future

Data Frame Summary

data

Dimensions: 12450 x 5
Duplicates: 14

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1623.2 (1216.2)
min < med < max:
1 < 1274 < 4555
IQR (CV) : 1942 (0.7)		 4555 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 417.5 (250.5)
min < med < max:
1 < 330 < 902
IQR (CV) : 393 (0.6)		 14 distinct values 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 8355.8 (68867.6)
min < med < max:
1874.9 < 2716.6 < 3109813
IQR (CV) : 2882.4 (8.2)		 4431 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 15082329 (411136442)
min < med < max:
160095.2 < 290544.5 < 27468981705
IQR (CV) : 828832.6 (27.3)		 4438 distinct values 0
(0.0%)
5 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Higher Ed. Campuses
9. Intermodal Hubs
10. Protected/Recreational Ar
11. Vacant Commercial Areas		 17 ( 0.1%)
1817 (14.6%)
2554 (20.5%)
3050 (24.5%)
3344 (26.9%)
64 ( 0.5%)
21 ( 0.2%)
8 ( 0.1%)
24 ( 0.2%)
736 ( 5.9%)
815 ( 6.5%)		 0
(0.0%)

GDB layer name: detailed_analytic_lu_existing

Data Frame Summary

data

Dimensions: 12401 x 5
Duplicates: 13

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1611.2 (1203.9)
min < med < max:
1 < 1268 < 4503
IQR (CV) : 1924 (0.7)		 4503 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 418.7 (250.3)
min < med < max:
1 < 330 < 902
IQR (CV) : 393 (0.6)		 14 distinct values 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 8342.3 (68396.6)
min < med < max:
1874.9 < 2716.6 < 3015076
IQR (CV) : 2882.9 (8.2)		 4395 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 15141924 (413415756)
min < med < max:
160095.2 < 290544.5 < 27667374301
IQR (CV) : 828832.6 (27.3)		 4396 distinct values 0
(0.0%)
5 GCODE_DESC
[character]		 1. C1 - Natural
2. C2 - Rural
3. C3C - Suburban Commercial
4. C3R - Suburban Residentia
5. C4 - Urban General
6. C5 - Urban Center
7. C6 - Urban Core
8. Higher Ed. Campuses
9. Intermodal Hubs
10. Protected/Recreational Ar
11. Vacant Commercial Areas		 17 ( 0.1%)
1793 (14.5%)
2538 (20.5%)
3033 (24.5%)
3355 (27.1%)
55 ( 0.4%)
15 ( 0.1%)
8 ( 0.1%)
23 ( 0.2%)
734 ( 5.9%)
830 ( 6.7%)		 0
(0.0%)