Map of SPCC 2.0 Revised

Smoothed Segments Future

Field Value Checks - Confirming Vacant Commerical Resolved

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] "detailed_analytic_lu_existing"      "refined_analytic_lu_existing"      
## [7] "detailed_analytic_lu_future"        "refined_analytic_lu_future"

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: detailed_analytic_lu_existing

Data Frame Summary

data

Dimensions: 12160 x 5
Duplicates: 83

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1619.9 (1194.4)
min < med < max:
1 < 1272 < 4503
IQR (CV) : 1920 (0.7)		 4472 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 418.3 (248.7)
min < med < max:
1 < 330 < 902
IQR (CV) : 393 (0.6)		 14 distinct values 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 9167.9 (76126.5)
min < med < max:
289.6 < 2000 < 3480973
IQR (CV) : 3000 (8.3)		 885 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 13213338 (382509394)
min < med < max:
1252.2 < 250000 < 26973025788
IQR (CV) : 750000 (28.9)		 1429 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		 9 ( 0.1%)
1726 (14.2%)
2479 (20.4%)
3023 (24.9%)
3351 (27.6%)
55 ( 0.5%)
15 ( 0.1%)
8 ( 0.1%)
23 ( 0.2%)
667 ( 5.5%)
804 ( 6.6%)		 0
(0.0%)

GDB layer name: refined_analytic_lu_existing

Data Frame Summary

data

Dimensions: 10574 x 5
Duplicates: 627

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1282.2 (1063.6)
min < med < max:
1 < 977.5 < 4000
IQR (CV) : 1637.5 (0.8)		 3850 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 312.7 (202.7)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.6)		 1 : 674 ( 6.4%)
2 : 1480 (14.0%)
307 : 3023 (28.6%)
330 : 1869 (17.7%)
400 : 2623 (24.8%)
500 : 55 ( 0.5%)
600 : 15 ( 0.1%)
801 : 804 ( 7.6%)
900 : 31 ( 0.3%)		 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 10049.5 (83087.1)
min < med < max:
289.6 < 2000 < 3480973
IQR (CV) : 3000 (8.3)		 871 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 15195214 (413054950)
min < med < max:
1252.2 < 250000 < 27311995856
IQR (CV) : 750000 (27.2)		 1387 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		 674 ( 6.4%)
1480 (14.0%)
2673 (25.3%)
3023 (28.6%)
2623 (24.8%)
55 ( 0.5%)
15 ( 0.1%)
31 ( 0.3%)		 0
(0.0%)

GDB layer name: detailed_analytic_lu_future

Data Frame Summary

data

Dimensions: 12211 x 5
Duplicates: 62

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1632 (1206.5)
min < med < max:
1 < 1279 < 4555
IQR (CV) : 1936.5 (0.7)		 4524 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 417 (248.9)
min < med < max:
1 < 330 < 902
IQR (CV) : 393 (0.6)		 14 distinct values 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 9187.1 (76823.8)
min < med < max:
289.6 < 2479 < 3603973
IQR (CV) : 3000 (8.4)		 899 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 13158152 (380157043)
min < med < max:
1252.2 < 250000 < 26770775788
IQR (CV) : 750000 (28.9)		 1436 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		 9 ( 0.1%)
1751 (14.3%)
2495 (20.4%)
3041 (24.9%)
3340 (27.4%)
64 ( 0.5%)
21 ( 0.2%)
8 ( 0.1%)
24 ( 0.2%)
669 ( 5.5%)
789 ( 6.5%)		 0
(0.0%)

GDB layer name: refined_analytic_lu_future

Data Frame Summary

data

Dimensions: 10624 x 5
Duplicates: 607

No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 Id
[integer]		 Mean (sd) : 1295.9 (1074.6)
min < med < max:
1 < 985 < 4047
IQR (CV) : 1649 (0.8)		 3888 distinct values 0
(0.0%)
2 gridcode
[integer]		 Mean (sd) : 311.2 (202.4)
min < med < max:
1 < 330 < 900
IQR (CV) : 93 (0.7)		 1 : 676 ( 6.4%)
2 : 1510 (14.2%)
307 : 3041 (28.6%)
330 : 1892 (17.8%)
400 : 2599 (24.5%)
500 : 64 ( 0.6%)
600 : 21 ( 0.2%)
801 : 789 ( 7.4%)
900 : 32 ( 0.3%)		 0
(0.0%)
3 Shape_Length
[numeric]		 Mean (sd) : 10073.1 (83737.7)
min < med < max:
289.6 < 2000 < 3603973
IQR (CV) : 3000 (8.3)		 888 distinct values 0
(0.0%)
4 Shape_Area
[numeric]		 Mean (sd) : 15123700 (410311870)
min < med < max:
1252.2 < 250000 < 27108745856
IQR (CV) : 750000 (27.1)		 1395 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		 676 ( 6.4%)
1510 (14.2%)
2681 (25.2%)
3041 (28.6%)
2599 (24.5%)
64 ( 0.6%)
21 ( 0.2%)
32 ( 0.3%)		 0
(0.0%)