Verified on the v0416 build installed on a 4-node cluster. This problem has been fixed: >>set schema trafodion.g_tpcds1x; --- SQL operation complete. >> >>prepare xx from +> select [first 200] +> i_item_id, +> ca_country, +> ca_state, +> ca_county, +> agg1, +> agg2, +> agg3, +> agg4, +> agg5, +> agg6, +> agg7 +> from +> ( +> select i_item_id, +> ca_country, +> ca_state, +> ca_county, +> avg(cs_quantity) agg1, +> avg(cs_list_price) agg2, +> avg(cs_coupon_amt) agg3, +> avg(cs_sales_price) agg4, +> avg(cs_net_profit) agg5, +> avg(c_birth_year) agg6, +> avg(cd1.cd_dep_count) agg7 +> from catalog_sales, customer_demographics cd1, +> customer_demographics cd2, customer, +> customer_address, date_dim, item +> where cs_sold_date_sk = d_date_sk and +> cs_item_sk = i_item_sk and +> cs_bill_cdemo_sk = cd1.cd_demo_sk and +> cs_bill_customer_sk = c_customer_sk and +> cd1.cd_gender = 'F' and +> cd1.cd_education_status = 'Primary' and +> c_current_cdemo_sk = cd2.cd_demo_sk and +> c_current_addr_sk = ca_address_sk and +> c_birth_month in (9,4,3,11,1,12) and +> d_year = 1999 and +> ca_state in ('VA','NE','MI','WV','WV','CO','IN') +> group by 1,2,3,4 +> union all +> select i_item_id, +> cast(null as char), +> ca_state, +> ca_county, +> avg(cs_quantity) agg1, +> avg(cs_list_price) agg2, +> avg(cs_coupon_amt) agg3, +> avg(cs_sales_price) agg4, +> avg(cs_net_profit) agg5, +> avg(c_birth_year) agg6, +> avg(cd1.cd_dep_count) agg7 +> from catalog_sales, customer_demographics cd1, +> customer_demographics cd2, customer, +> customer_address, date_dim, item +> where cs_sold_date_sk = d_date_sk and +> cs_item_sk = i_item_sk and +> cs_bill_cdemo_sk = cd1.cd_demo_sk and +> cs_bill_customer_sk = c_customer_sk and +> cd1.cd_gender = 'F' and +> cd1.cd_education_status = 'Primary' and +> c_current_cdemo_sk = cd2.cd_demo_sk and +> c_current_addr_sk = ca_address_sk and +> c_birth_month in (9,4,3,11,1,12) and +> d_year = 1999 and +> ca_state in ('VA','NE','MI','WV','WV','CO','IN') +> group by 1,2,3,4 +> union all +> select i_item_id, +> cast(null as char), +> cast(null as char), +> ca_county, +> avg(cs_quantity) agg1, +> avg(cs_list_price) agg2, +> avg(cs_coupon_amt) agg3, +> avg(cs_sales_price) agg4, +> avg(cs_net_profit) agg5, +> avg(c_birth_year) agg6, +> avg(cd1.cd_dep_count) agg7 +> from catalog_sales, customer_demographics cd1, +> customer_demographics cd2, customer, +> customer_address, date_dim, item +> where cs_sold_date_sk = d_date_sk and +> cs_item_sk = i_item_sk and +> cs_bill_cdemo_sk = cd1.cd_demo_sk and +> cs_bill_customer_sk = c_customer_sk and +> cd1.cd_gender = 'F' and +> cd1.cd_education_status = 'Primary' and +> c_current_cdemo_sk = cd2.cd_demo_sk and +> c_current_addr_sk = ca_address_sk and +> c_birth_month in (9,4,3,11,1,12) and +> d_year = 1999 and +> ca_state in ('VA','NE','MI','WV','WV','CO','IN') +> group by 1,2,3,4 +> union all +> select i_item_id, +> cast(null as char), +> cast(null as char), +> cast(null as char), +> avg(cs_quantity) agg1, +> avg(cs_list_price) agg2, +> avg(cs_coupon_amt) agg3, +> avg(cs_sales_price) agg4, +> avg(cs_net_profit) agg5, +> avg(c_birth_year) agg6, +> avg(cd1.cd_dep_count) agg7 +> from catalog_sales, customer_demographics cd1, +> customer_demographics cd2, customer, +> customer_address, date_dim, item +> where cs_sold_date_sk = d_date_sk and +> cs_item_sk = i_item_sk and +> cs_bill_cdemo_sk = cd1.cd_demo_sk and +> cs_bill_customer_sk = c_customer_sk and +> cd1.cd_gender = 'F' and +> cd1.cd_education_status = 'Primary' and +> c_current_cdemo_sk = cd2.cd_demo_sk and +> c_current_addr_sk = ca_address_sk and +> c_birth_month in (9,4,3,11,1,12) and +> d_year = 1999 and +> ca_state in ('VA','NE','MI','WV','WV','CO','IN') +> group by 1,2,3,4 +> union all +> select cast(null as char), +> cast(null as char), +> cast(null as char), +> cast(null as char), +> avg(cs_quantity) agg1, +> avg(cs_list_price) agg2, +> avg(cs_coupon_amt) agg3, +> avg(cs_sales_price) agg4, +> avg(cs_net_profit) agg5, +> avg(c_birth_year) agg6, +> avg(cd1.cd_dep_count) agg7 +> from catalog_sales, customer_demographics cd1, +> customer_demographics cd2, customer, +> customer_address, date_dim, item +> where cs_sold_date_sk = d_date_sk and +> cs_item_sk = i_item_sk and +> cs_bill_cdemo_sk = cd1.cd_demo_sk and +> cs_bill_customer_sk = c_customer_sk and +> cd1.cd_gender = 'F' and +> cd1.cd_education_status = 'Primary' and +> c_current_cdemo_sk = cd2.cd_demo_sk and +> c_current_addr_sk = ca_address_sk and +> c_birth_month in (9,4,3,11,1,12) and +> d_year = 1999 and +> ca_state in ('VA','NE','MI','WV','WV','CO','IN') +> group by 1,2,3,4 +> ) v1 +> order by 2,3,4,1; *** WARNING[6007] Multi-column statistics for columns (CD_GENDER, CD_EDUCATION_STATUS) from table TRAFODION.G_TPCDS1X.CUSTOMER_DEMOGRAPHICS were not available. The columns were being used by Scan operator. As a result, the access path chosen might not be the best possible. *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_COUNTRY) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by Scan operator. As a result, the access path chosen might not be the best possible. *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_STATE, CA_COUNTRY) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible. *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_STATE) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible. --- SQL command prepared. >> >>explain options 'f' xx; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 137 . 138 root 1.23E+005 136 . 137 firstn 1.23E+005 109 135 136 merge_union 1.23E+005 134 . 135 hash_partial_groupby 1.00E+000 133 . 134 esp_exchange 1:13(hash2) 1.00E+000 132 . 133 sort_partial_groupby 1.00E+000 131 111 132 hybrid_hash_join 3.73E+004 130 . 131 esp_exchange 13(hash2):8(hash2) 3.93E+004 127 129 130 nested_join 3.93E+004 128 . 129 probe_cache 1.00E+000 . . 128 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 126 . 127 esp_exchange 8(hash2):13(hash2) 3.93E+004 125 113 126 hybrid_hash_join 3.93E+004 124 115 125 hybrid_hash_join 3.93E+004 123 117 124 hybrid_hash_join 2.17E+005 122 . 123 esp_exchange 13(hash2):13(hash2) 1.00E+004 121 119 122 hybrid_hash_join 1.00E+004 120 . 121 esp_exchange 13(hash2):8(hash2) 7.58E+003 . . 120 trafodion_scan CUSTOMER_ADDRESS 7.58E+003 118 . 119 esp_exchange 13(hash2):8(hash2) 4.65E+004 . . 118 trafodion_scan CUSTOMER 4.65E+004 116 . 117 esp_exchange 13(hash2):8(hash2) 1.43E+006 . . 116 trafodion_scan CATALOG_SALES 1.43E+006 114 . 115 esp_exchange 13(rep-b):8(hash2) 3.34E+002 . . 114 trafodion_scan DATE_DIM 3.34E+002 112 . 113 esp_exchange 13(rep-b):8(hash2) 1.79E+004 . . 112 trafodion_scan ITEM 1.79E+004 110 . 111 esp_exchange 13(hash2):8(hash2) 1.37E+005 . . 110 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.37E+005 108 . 109 esp_exchange 1:13(hash2) (m) 1.23E+005 80 107 108 merge_union 1.23E+005 106 . 107 sort_partial_groupby 8.89E+003 105 . 106 sort 8.89E+003 104 . 105 esp_exchange 13(hash2):13(hash2) 8.89E+003 103 . 104 hash_partial_groupby 8.89E+003 102 82 103 hybrid_hash_join 3.73E+004 101 84 102 hybrid_hash_join 3.73E+004 100 . 101 esp_exchange 13(hash2):13(hash2) 3.93E+004 99 86 100 hybrid_hash_join 3.93E+004 98 88 99 hybrid_hash_join 2.17E+005 97 . 98 esp_exchange 13(hash2):8(hash2) 1.00E+004 94 96 97 nested_join 1.00E+004 95 . 96 probe_cache 1.00E+000 . . 95 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 93 . 94 esp_exchange 8(hash2):13(hash2) 1.00E+004 92 90 93 hybrid_hash_join 1.00E+004 91 . 92 esp_exchange 13(hash2):8(hash2) 7.58E+003 . . 91 trafodion_scan CUSTOMER_ADDRESS 7.58E+003 89 . 90 esp_exchange 13(hash2):8(hash2) 4.65E+004 . . 89 trafodion_scan CUSTOMER 4.65E+004 87 . 88 esp_exchange 13(hash2):8(hash2) 1.43E+006 . . 87 trafodion_scan CATALOG_SALES 1.43E+006 85 . 86 esp_exchange 13(rep-b):8(hash2) 3.34E+002 . . 85 trafodion_scan DATE_DIM 3.34E+002 83 . 84 esp_exchange 13(hash2):8(hash2) 1.37E+005 . . 83 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.37E+005 81 . 82 esp_exchange 13(rep-b):8(hash2) 1.79E+004 . . 81 trafodion_scan ITEM 1.79E+004 53 79 80 merge_union 1.14E+005 78 . 79 sort_groupby 3.73E+004 77 . 78 sort 3.73E+004 76 . 77 esp_exchange 13(hash2):13(hash2) 3.73E+004 75 55 76 hybrid_hash_join 3.73E+004 74 57 75 hybrid_hash_join 3.73E+004 73 . 74 esp_exchange 13(hash2):8(hash2) 3.93E+004 70 72 73 nested_join 3.93E+004 71 . 72 probe_cache 1.00E+000 . . 71 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 69 . 70 esp_exchange 8(hash2):13(hash2) 3.93E+004 68 59 69 hybrid_hash_join 3.93E+004 67 61 68 hybrid_hash_join 2.17E+005 66 . 67 esp_exchange 13(hash2):13(hash2) 1.00E+004 65 63 66 hybrid_hash_join 1.00E+004 64 . 65 esp_exchange 13(hash2):8(hash2) 7.58E+003 . . 64 trafodion_scan CUSTOMER_ADDRESS 7.58E+003 62 . 63 esp_exchange 13(hash2):8(hash2) 4.65E+004 . . 62 trafodion_scan CUSTOMER 4.65E+004 60 . 61 esp_exchange 13(hash2):8(hash2) 1.43E+006 . . 60 trafodion_scan CATALOG_SALES 1.43E+006 58 . 59 esp_exchange 13(rep-b):8(hash2) 3.34E+002 . . 58 trafodion_scan DATE_DIM 3.34E+002 56 . 57 esp_exchange 13(hash2):8(hash2) 1.37E+005 . . 56 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.37E+005 54 . 55 esp_exchange 13(rep-b):8(hash2) 1.79E+004 . . 54 trafodion_scan ITEM 1.79E+004 26 52 53 merge_union 7.70E+004 51 . 52 sort_groupby 3.73E+004 50 . 51 sort 3.73E+004 49 . 50 esp_exchange 13(hash2):13(hash2) 3.73E+004 48 28 49 hybrid_hash_join 3.73E+004 47 30 48 hybrid_hash_join 3.73E+004 46 . 47 esp_exchange 13(hash2):13(hash2) 3.93E+004 45 32 46 hybrid_hash_join 3.93E+004 44 34 45 hybrid_hash_join 2.17E+005 43 . 44 esp_exchange 13(hash2):8(hash2) 1.00E+004 40 42 43 nested_join 1.00E+004 41 . 42 probe_cache 1.00E+000 . . 41 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 39 . 40 esp_exchange 8(hash2):13(hash2) 1.00E+004 38 36 39 hybrid_hash_join 1.00E+004 37 . 38 esp_exchange 13(hash2):8(hash2) 7.58E+003 . . 37 trafodion_scan CUSTOMER_ADDRESS 7.58E+003 35 . 36 esp_exchange 13(hash2):8(hash2) 4.65E+004 . . 35 trafodion_scan CUSTOMER 4.65E+004 33 . 34 esp_exchange 13(hash2):8(hash2) 1.43E+006 . . 33 trafodion_scan CATALOG_SALES 1.43E+006 31 . 32 esp_exchange 13(rep-b):8(hash2) 3.34E+002 . . 31 trafodion_scan DATE_DIM 3.34E+002 29 . 30 esp_exchange 13(hash2):8(hash2) 1.37E+005 . . 29 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.37E+005 27 . 28 esp_exchange 13(rep-b):8(hash2) 1.79E+004 . . 27 trafodion_scan ITEM 1.79E+004 25 . 26 sort_groupby 3.97E+004 24 . 25 sort 3.97E+004 23 . 24 esp_exchange 13(hash2):13(hash2) 3.97E+004 22 2 23 hybrid_hash_join 3.97E+004 21 4 22 hybrid_hash_join 3.97E+004 20 . 21 esp_exchange 13(hash2):13(hash2) 4.18E+004 19 6 20 hybrid_hash_join 4.18E+004 18 8 19 hybrid_hash_join 2.31E+005 17 . 18 esp_exchange 13(hash2):8(hash2) 1.07E+004 14 16 17 nested_join 1.07E+004 15 . 16 probe_cache 1.00E+000 . . 15 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 13 . 14 esp_exchange 8(hash2):13(hash2) 1.07E+004 12 10 13 hybrid_hash_join 1.07E+004 11 . 12 esp_exchange 13(hash2):8(hash2) 7.71E+003 . . 11 trafodion_scan CUSTOMER_ADDRESS 7.71E+003 9 . 10 esp_exchange 13(hash2):8(hash2) 4.86E+004 . . 9 trafodion_scan CUSTOMER 4.86E+004 7 . 8 esp_exchange 13(hash2):8(hash2) 1.43E+006 . . 7 trafodion_scan CATALOG_SALES 1.43E+006 5 . 6 esp_exchange 13(rep-b):8(hash2) 3.34E+002 . . 5 trafodion_scan DATE_DIM 3.34E+002 3 . 4 esp_exchange 13(hash2):8(hash2) 1.37E+005 . . 3 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.37E+005 1 . 2 esp_exchange 13(rep-b):8(hash2) 1.79E+004 . . 1 trafodion_scan ITEM 1.79E+004 --- SQL operation complete. >> >>execute xx; I_ITEM_ID CA_COUNTRY CA_STATE CA_COUNTY AGG1 AGG2 AGG3 AGG4 AGG5 AGG6 AGG7 ---------------- -------------------- -------- ------------------------------ -------------------- --------------------- --------------------- --------------------- --------------------- -------------------- -------------------- AAAAAAAAACJCAAAA United States CO Baca County 52 34.58 33.09 1.72 -1158.89 1957 0 AAAAAAAADDKAAAAA United States CO Baca County 43 11.80 .00 4.48 -10.32 1957 0 AAAAAAAAECHDAAAA United States CO Baca County 63 56.96 .00 22.21 -1591.38 1957 0 AAAAAAAAHMPDAAAA United States CO Baca County 43 49.46 .00 11.37 -692.73 1957 0 AAAAAAAAAOCBAAAA United States CO Clear Creek County 97 141.95 .00 117.81 6402.00 1978 0 AAAAAAAACDODAAAA United States CO Clear Creek County 69 94.13 5676.38 89.42 -3643.64 1978 0 AAAAAAAADJNDAAAA United States CO Clear Creek County 99 107.39 .00 46.17 -1504.80 1978 0 AAAAAAAAEGKDAAAA United States CO Clear Creek County 15 94.76 .00 50.22 110.10 1978 0 AAAAAAAAFDIAAAAA United States CO Clear Creek County 91 140.72 3725.87 42.21 -7079.22 1978 0 AAAAAAAAFEEDAAAA United States CO Clear Creek County 99 33.35 .00 26.34 569.25 1978 0 AAAAAAAAIAKCAAAA United States CO Clear Creek County 54 117.89 .00 7.07 -4631.04 1978 0 AAAAAAAAIKKDAAAA United States CO Clear Creek County 54 19.83 .00 17.64 451.98 1978 0 AAAAAAAALGACAAAA United States CO Clear Creek County 17 10.41 .00 1.45 -34.34 1978 0 AAAAAAAALKDEAAAA United States CO Clear Creek County 55 198.37 .00 45.62 -2361.70 1978 0 AAAAAAAAOJAAAAAA United States CO Clear Creek County 43 84.61 63.99 13.53 -1231.44 1978 0 AAAAAAAAOLBDAAAA United States CO Clear Creek County 41 44.41 .00 19.98 -882.73 1978 0 AAAAAAAAOLKCAAAA United States CO Clear Creek County 50 97.20 .00 74.84 1481.50 1978 0 AAAAAAAAAMLAAAAA United States CO Denver County 69 40.22 .00 18.50 -908.73 1958 1 AAAAAAAABCBDAAAA United States CO Denver County 38 65.32 .00 18.28 -654.36 1958 1 AAAAAAAACFPAAAAA United States CO Denver County 38 76.09 .00 6.08 -742.52 1958 1 AAAAAAAAEOKAAAAA United States CO Denver County 84 129.07 .00 52.91 -2688.84 1958 1 AAAAAAAAGFODAAAA United States CO Denver County 98 10.48 .00 1.25 -576.24 1958 1 AAAAAAAAGNDAAAAA United States CO Denver County 87 53.79 .00 19.36 -728.19 1958 1 AAAAAAAAIJBBAAAA United States CO Denver County 60 145.95 .00 94.86 -265.80 1958 1 AAAAAAAAKIIAAAAA United States CO Denver County 1 52.95 .00 2.11 -20.33 1958 1 AAAAAAAAKMECAAAA United States CO Denver County 72 99.98 .00 72.98 2627.28 1958 1 AAAAAAAALDIAAAAA United States CO Denver County 19 102.24 .00 56.23 396.15 1958 1 AAAAAAAALMEEAAAA United States CO Denver County 67 3.91 .00 .35 -129.98 1958 1 AAAAAAAANLEDAAAA United States CO Denver County 90 22.35 .00 4.02 -1467.00 1958 1 AAAAAAAAAGODAAAA United States CO Douglas County 50 218.95 .00 172.97 4987.00 1947 1 AAAAAAAADPICAAAA United States CO Douglas County 9 37.22 112.48 27.17 -114.28 1947 1 AAAAAAAAELEAAAAA United States CO Douglas County 37 148.13 .00 5.92 -1982.09 1947 1 AAAAAAAAFLCEAAAA United States CO Douglas County 70 88.98 .00 51.60 868.00 1947 1 AAAAAAAAGNDDAAAA United States CO Douglas County 41 34.05 .00 2.38 -465.35 1947 1 AAAAAAAAGOIDAAAA United States CO Douglas County 82 104.28 .00 90.72 4406.68 1947 1 AAAAAAAAIGCEAAAA United States CO Douglas County 20 131.96 926.28 102.92 -40.88 1947 1 AAAAAAAAJMFCAAAA United States CO Douglas County 2 233.52 .00 70.05 -35.48 1947 1 AAAAAAAAMDICAAAA United States CO Douglas County 30 72.12 .00 59.85 912.30 1947 1 AAAAAAAAMGDCAAAA United States CO Douglas County 7 50.02 .00 44.51 -38.57 1947 1 AAAAAAAAOAJDAAAA United States CO Douglas County 70 60.34 2022.13 38.01 -1363.43 1947 1 AAAAAAAAONNAAAAA United States CO Douglas County 4 55.50 .00 27.75 -80.40 1947 1 AAAAAAAAPBJAAAAA United States CO Douglas County 6 193.01 .00 71.41 -156.42 1947 1 AAAAAAAAPGNDAAAA United States CO Douglas County 90 173.83 .00 34.76 -3390.30 1947 1 AAAAAAAACEEBAAAA United States CO Eagle County 83 23.80 .00 2.61 -1194.37 1956 2 AAAAAAAADMKDAAAA United States CO Eagle County 17 223.82 .00 214.86 2322.20 1956 2 AAAAAAAAEPHDAAAA United States CO Eagle County 97 44.40 .00 33.30 153.26 1956 2 AAAAAAAAFPEEAAAA United States CO Eagle County 16 107.53 .00 81.72 703.84 1956 2 AAAAAAAAGMODAAAA United States CO Eagle County 64 169.41 .00 3.38 -4245.76 1956 2 AAAAAAAAIFKCAAAA United States CO Eagle County 62 230.14 .00 46.02 -1967.26 1956 2 AAAAAAAAILADAAAA United States CO Eagle County 61 38.14 .00 16.40 10.37 1956 2 AAAAAAAAMDBEAAAA United States CO Eagle County 53 143.86 .00 5.75 -2498.42 1956 2 AAAAAAAAMJDBAAAA United States CO Eagle County 100 65.60 2124.62 51.82 -272.62 1956 2 AAAAAAAAOHOCAAAA United States CO Eagle County 40 164.24 492.72 41.06 -1553.92 1956 2 AAAAAAAAPDEAAAAA United States CO Eagle County 48 36.25 .00 6.16 -1300.80 1956 2 AAAAAAAAPHNCAAAA United States CO Eagle County 76 151.32 .00 21.18 -3919.32 1956 2 AAAAAAAAPLLDAAAA United States CO Eagle County 74 31.40 .00 12.24 -555.74 1956 2 AAAAAAAAACMDAAAA United States CO Elbert County 5 5.16 .00 3.45 4.65 1927 1 AAAAAAAAADLAAAAA United States CO Elbert County 99 22.84 .00 21.69 1109.79 1927 1 AAAAAAAAAKFEAAAA United States CO Elbert County 40 139.99 206.06 128.79 1612.34 1924 3 AAAAAAAABCDBAAAA United States CO Elbert County 72 50.15 .00 46.63 884.16 1927 1 AAAAAAAABGJAAAAA United States CO Elbert County 33 118.09 .00 89.74 380.49 1924 3 AAAAAAAADGNDAAAA United States CO Elbert County 59 93.20 .00 71.76 2331.09 1927 1 AAAAAAAAEGOBAAAA United States CO Elbert County 22 144.11 .00 28.82 -833.80 1927 1 AAAAAAAAEMCBAAAA United States CO Elbert County 43 8.02 .00 4.09 -119.11 1927 1 AAAAAAAAGOGAAAAA United States CO Elbert County 58 18.70 .00 8.78 -114.26 1927 1 AAAAAAAAHAIBAAAA United States CO Elbert County 76 7.61 .00 4.26 99.56 1927 1 AAAAAAAAHJECAAAA United States CO Elbert County 80 61.68 .00 28.98 -1793.60 1927 1 AAAAAAAAIPIAAAAA United States CO Elbert County 96 31.62 .00 12.01 -1182.72 1924 3 AAAAAAAAKECAAAAA United States CO Elbert County 29 26.75 .00 5.88 -343.36 1924 3 AAAAAAAAKKLDAAAA United States CO Elbert County 20 65.42 .00 58.22 496.80 1927 1 AAAAAAAALBEAAAAA United States CO Elbert County 20 9.98 122.04 6.78 -157.04 1924 3 AAAAAAAAMLFDAAAA United States CO Elbert County 42 132.79 .00 111.54 2656.50 1927 1 AAAAAAAAOBGEAAAA United States CO Elbert County 89 284.28 .00 102.34 323.07 1927 1 AAAAAAAAOMFBAAAA United States CO Elbert County 79 124.53 363.99 92.15 3351.38 1924 3 AAAAAAAAOPCDAAAA United States CO Elbert County 99 32.56 .00 4.55 -2619.54 1924 3 AAAAAAAAALKCAAAA United States CO Huerfano County 18 93.27 736.79 53.16 -494.33 1984 5 AAAAAAAACCDBAAAA United States CO Huerfano County 76 153.44 .00 116.61 3585.68 1984 5 AAAAAAAACHGBAAAA United States CO Huerfano County 66 97.59 1468.52 92.71 -120.80 1984 5 AAAAAAAACOEAAAAA United States CO Huerfano County 8 68.60 .00 66.54 33.36 1984 5 AAAAAAAADOFAAAAA United States CO Huerfano County 45 99.53 762.23 22.89 -1281.98 1984 5 AAAAAAAAHCJBAAAA United States CO Huerfano County 92 110.37 2662.37 50.77 -5626.61 1984 5 AAAAAAAAIABCAAAA United States CO Huerfano County 21 97.55 .00 94.62 656.67 1984 5 AAAAAAAAANPDAAAA United States CO Jefferson County 81 10.20 112.10 3.46 -132.35 1939 6 AAAAAAAACCLBAAAA United States CO Jefferson County 44 150.24 .00 18.02 -1440.56 1939 6 AAAAAAAADGHDAAAA United States CO Jefferson County 68 159.16 1916.37 36.60 -4324.93 1939 6 AAAAAAAAKFGBAAAA United States CO Jefferson County 26 97.84 .00 39.13 -867.10 1939 6 AAAAAAAAKGGAAAAA United States CO Jefferson County 54 114.36 .00 48.03 -1881.36 1939 6 AAAAAAAAMLIBAAAA United States CO Jefferson County 95 99.02 .00 5.94 -2856.65 1939 6 AAAAAAAANFOCAAAA United States CO Jefferson County 94 40.46 1373.47 33.98 -17.05 1939 6 AAAAAAAANLKAAAAA United States CO Jefferson County 45 96.34 .00 79.96 2033.10 1939 6 AAAAAAAACEBAAAAA United States CO Kit Carson County 69 12.85 .00 11.82 287.73 1972 2 AAAAAAAADFLAAAAA United States CO Kit Carson County 58 184.27 .00 162.15 5601.06 1972 2 AAAAAAAADNJDAAAA United States CO Kit Carson County 86 238.08 .00 30.95 -5006.92 1972 2 AAAAAAAAGDLDAAAA United States CO Kit Carson County 6 161.87 .00 147.30 434.16 1972 2 AAAAAAAAICMBAAAA United States CO Kit Carson County 78 49.89 .00 47.89 2425.02 1972 2 AAAAAAAAJJEDAAAA United States CO Kit Carson County 12 269.21 .00 43.07 -624.72 1972 2 AAAAAAAAKIJBAAAA United States CO Kit Carson County 23 247.03 .00 242.08 3574.20 1972 2 AAAAAAAAKOFDAAAA United States CO Kit Carson County 1 197.42 .00 96.73 14.47 1972 2 AAAAAAAAMANBAAAA United States CO Kit Carson County 37 55.87 .00 12.29 -1135.53 1972 2 AAAAAAAANIEDAAAA United States CO Kit Carson County 37 48.79 .00 16.58 -336.70 1972 2 AAAAAAAAPIJCAAAA United States CO Kit Carson County 98 95.75 .00 46.91 902.58 1972 2 AAAAAAAAPNHCAAAA United States CO Kit Carson County 47 9.95 .00 2.68 -170.14 1972 2 AAAAAAAABKFDAAAA United States CO La Plata County 90 36.61 .00 33.31 899.10 1954 5 AAAAAAAAGHLCAAAA United States CO La Plata County 18 42.41 .00 35.20 -60.48 1954 5 AAAAAAAAKBOBAAAA United States CO La Plata County 21 123.99 431.17 85.55 390.14 1954 5 AAAAAAAALFLBAAAA United States CO La Plata County 72 178.62 4853.27 91.09 -2988.47 1954 5 AAAAAAAAMDKDAAAA United States CO La Plata County 37 69.28 .00 24.24 -1371.59 1954 5 AAAAAAAANHACAAAA United States CO La Plata County 92 180.96 .00 85.05 -179.40 1954 5 AAAAAAAAEFLCAAAA United States CO Las Animas County 90 103.96 .00 49.90 -594.00 1927 4 AAAAAAAAEHADAAAA United States CO Las Animas County 70 80.21 .00 57.75 1731.80 1927 4 AAAAAAAAKKBBAAAA United States CO Las Animas County 37 108.40 .00 4.33 -1671.29 1927 4 AAAAAAAAMCACAAAA United States CO Las Animas County 80 91.09 6233.13 85.62 -5949.13 1927 4 AAAAAAAAOFOCAAAA United States CO Las Animas County 57 64.00 .00 3.84 -1009.47 1927 4 AAAAAAAAAAODAAAA United States CO Rio Blanco County 25 248.64 .00 146.69 1190.75 1948 4 AAAAAAAAABAAAAAA United States CO Rio Blanco County 24 27.75 .00 9.71 -317.52 1948 4 AAAAAAAAAEIBAAAA United States CO Rio Blanco County 76 9.73 .00 3.50 -31.16 1948 4 AAAAAAAAANCCAAAA United States CO Rio Blanco County 84 49.99 .00 22.49 -82.32 1925 2 AAAAAAAAAOJCAAAA United States CO Rio Blanco County 35 5.22 .00 1.09 -104.65 1948 4 AAAAAAAACFBDAAAA United States CO Rio Blanco County 18 247.17 .00 54.37 -539.82 1948 4 AAAAAAAAFABEAAAA United States CO Rio Blanco County 67 133.05 .00 38.58 -2480.34 1948 4 AAAAAAAAFBNAAAAA United States CO Rio Blanco County 68 195.99 .00 156.79 5918.72 1948 4 AAAAAAAAGBLCAAAA United States CO Rio Blanco County 62 1.21 .00 .22 -52.08 1948 4 AAAAAAAAGHIBAAAA United States CO Rio Blanco County 68 41.11 .00 29.18 799.68 1948 4 AAAAAAAAGICAAAAA United States CO Rio Blanco County 41 21.35 .00 10.46 -101.68 1925 2 AAAAAAAAHJGAAAAA United States CO Rio Blanco County 46 70.05 .00 28.72 118.68 1925 2 AAAAAAAAHLNAAAAA United States CO Rio Blanco County 68 133.59 .00 44.08 -1434.12 1925 2 AAAAAAAAIEODAAAA United States CO Rio Blanco County 65 82.15 .00 2.46 -2999.75 1925 2 AAAAAAAAILLBAAAA United States CO Rio Blanco County 60 33.52 .00 19.10 -151.80 1925 2 AAAAAAAAJEECAAAA United States CO Rio Blanco County 10 155.36 .00 10.87 -779.10 1948 4 AAAAAAAALHJBAAAA United States CO Rio Blanco County 95 239.78 .00 220.59 12519.10 1948 4 AAAAAAAAMEEDAAAA United States CO Rio Blanco County 19 68.85 .00 44.75 -317.87 1925 2 AAAAAAAAMEHDAAAA United States CO Rio Blanco County 93 268.25 .00 112.66 1535.43 1948 4 AAAAAAAAMLDAAAAA United States CO Rio Blanco County 98 75.38 .00 74.62 3253.60 1925 2 AAAAAAAANKJCAAAA United States CO Rio Blanco County 16 98.09 .00 89.26 -141.28 1948 4 AAAAAAAAAGFCAAAA United States CO Routt County 70 187.00 .00 16.83 -5366.90 1951 2 AAAAAAAADABDAAAA United States CO Routt County 54 108.39 .00 50.94 -2168.10 1951 2 AAAAAAAAFCIBAAAA United States CO Routt County 44 184.34 .00 62.67 -980.32 1951 2 AAAAAAAAFMEEAAAA United States CO Routt County 23 187.92 .00 62.01 -14.49 1951 2 AAAAAAAAGOFDAAAA United States CO Routt County 52 109.18 126.96 4.36 -3539.72 1951 2 AAAAAAAAHFICAAAA United States CO Routt County 98 122.14 6010.68 65.95 -4279.02 1951 2 AAAAAAAAHLMBAAAA United States CO Routt County 92 32.35 .00 21.99 -357.88 1951 2 AAAAAAAAKEBEAAAA United States CO Routt County 18 147.36 .00 48.62 -230.04 1951 2 AAAAAAAAOLPAAAAA United States CO Routt County 19 98.19 .00 42.22 -848.92 1951 2 AAAAAAAAPMDBAAAA United States CO Routt County 64 121.41 3566.24 109.26 -1554.72 1951 2 AAAAAAAACIAEAAAA United States IN Bartholomew County 29 65.53 .00 39.97 7.25 1926 1 AAAAAAAAGCLAAAAA United States IN Bartholomew County 95 40.01 .00 28.00 56.05 1926 1 AAAAAAAAHBBEAAAA United States IN Bartholomew County 2 115.44 .00 61.18 -76.68 1926 1 AAAAAAAAJPNAAAAA United States IN Bartholomew County 19 61.22 .00 27.54 90.82 1926 1 AAAAAAAAKEJDAAAA United States IN Bartholomew County 29 76.77 .00 75.23 1009.78 1926 1 AAAAAAAAMJEDAAAA United States IN Bartholomew County 90 96.65 .00 14.49 -6005.70 1926 1 AAAAAAAAMJEEAAAA United States IN Bartholomew County 74 254.71 .00 99.33 16.28 1926 1 AAAAAAAAPAEAAAAA United States IN Bartholomew County 59 150.06 .00 127.55 3501.06 1926 1 AAAAAAAAAHKCAAAA United States IN Blackford County 50 133.58 .00 13.35 -3064.00 1932 2 AAAAAAAACKNDAAAA United States IN Blackford County 86 7.73 .00 2.39 -98.04 1932 2 AAAAAAAAEMABAAAA United States IN Blackford County 74 255.05 .00 252.49 12130.82 1932 2 AAAAAAAAFOIBAAAA United States IN Blackford County 48 232.32 .00 85.95 -282.24 1932 2 AAAAAAAAGCBCAAAA United States IN Blackford County 49 125.56 .00 111.74 1427.37 1932 2 AAAAAAAAGLJDAAAA United States IN Blackford County 19 109.56 49.94 32.86 -199.47 1932 2 AAAAAAAAMACDAAAA United States IN Blackford County 5 27.17 .00 26.62 52.70 1932 2 AAAAAAAANFNDAAAA United States IN Blackford County 57 99.53 .00 .99 -2037.18 1932 2 AAAAAAAAADFCAAAA United States IN Clinton County 5 97.97 19.59 19.59 -383.79 1947 0 AAAAAAAABOPBAAAA United States IN Clinton County 13 97.92 .00 77.35 405.08 1947 0 AAAAAAAAEKDCAAAA United States IN Clinton County 89 71.55 3048.71 40.78 -3581.82 1947 0 AAAAAAAAEMMAAAAA United States IN Clinton County 15 147.64 1.77 2.95 -1117.02 1947 0 AAAAAAAAEPDAAAAA United States IN Clinton County 92 100.42 1075.34 12.05 -3185.82 1947 0 AAAAAAAAFIOBAAAA United States IN Clinton County 85 29.57 .00 7.39 -1616.70 1947 0 AAAAAAAALDODAAAA United States IN Clinton County 64 80.08 .00 55.25 -1254.40 1947 0 AAAAAAAAMEICAAAA United States IN Clinton County 6 49.80 .00 14.94 -46.20 1947 0 AAAAAAAAMIPDAAAA United States IN Clinton County 54 89.07 .00 12.46 -1744.20 1947 0 AAAAAAAAMMAEAAAA United States IN Clinton County 38 58.45 .00 23.96 114.38 1947 0 AAAAAAAANFHDAAAA United States IN Clinton County 53 239.50 1726.31 38.32 -4485.49 1947 0 AAAAAAAANNIAAAAA United States IN Clinton County 62 7.46 .00 1.64 -159.96 1947 0 AAAAAAAAOAMDAAAA United States IN Clinton County 48 51.10 .00 19.92 -847.68 1947 0 AAAAAAAABLBAAAAA United States IN Daviess County 66 207.37 .00 194.92 7232.28 1948 3 AAAAAAAAGCDCAAAA United States IN Daviess County 29 201.75 .00 133.15 1891.38 1948 3 AAAAAAAAKJBDAAAA United States IN Daviess County 28 219.28 .00 17.54 -1843.52 1948 3 AAAAAAAALBCCAAAA United States IN Daviess County 45 47.55 .00 35.18 573.75 1948 3 AAAAAAAAFHGBAAAA United States IN Franklin County 38 48.28 .00 9.17 -699.96 1943 1 AAAAAAAAGALAAAAA United States IN Franklin County 70 48.12 1919.98 48.12 50.52 1943 1 AAAAAAAAKGPBAAAA United States IN Franklin County 57 73.37 .00 38.88 625.86 1943 1 AAAAAAAANBGCAAAA United States IN Franklin County 29 45.82 .00 30.69 117.45 1943 1 AAAAAAAAPJGBAAAA United States IN Franklin County 82 20.62 .00 6.80 -431.32 1943 1 AAAAAAAABGIBAAAA United States IN Hamilton County 60 209.08 .00 188.17 5400.60 1931 6 AAAAAAAAEIEDAAAA United States IN Hamilton County 73 90.54 .00 77.86 3244.85 1931 6 AAAAAAAAFLPDAAAA United States IN Hamilton County 94 63.02 .00 16.38 -3749.66 1931 6 AAAAAAAAGOBBAAAA United States IN Hamilton County 10 149.29 .00 52.25 -126.60 1931 6 AAAAAAAAIKCCAAAA United States IN Hamilton County 84 86.11 .00 76.63 3484.32 1931 6 AAAAAAAAKDCBAAAA United States IN Hamilton County 77 265.18 .00 238.66 10978.66 1931 6 AAAAAAAANCHAAAAA United States IN Hamilton County 52 82.81 1822.22 76.18 -790.54 1931 6 AAAAAAAANGCBAAAA United States IN Hamilton County 62 148.12 .00 60.72 -1365.86 1931 6 AAAAAAAAOKPCAAAA United States IN Hamilton County 45 151.67 .00 63.70 -479.25 1931 6 AAAAAAAAOOHCAAAA United States IN Hamilton County 53 42.68 .00 34.14 971.49 1931 6 AAAAAAAAAJIDAAAA United States IN Hancock County 80 198.99 .00 119.39 2890.40 1985 5 AAAAAAAAAKKCAAAA United States IN Hancock County 11 38.97 289.76 26.88 -309.34 1956 3 AAAAAAAACHNAAAAA United States IN Hancock County 26 44.43 .00 35.54 438.62 1985 5 AAAAAAAACLFEAAAA United States IN Hancock County 71 156.63 .00 23.49 -3044.48 1985 5 AAAAAAAACODAAAAA United States IN Hancock County 13 23.87 .00 10.98 -23.27 1956 3 AAAAAAAAEIIAAAAA United States IN Hancock County 88 48.77 970.78 38.04 313.14 1956 3 AAAAAAAAEMFCAAAA United States IN Hancock County 68 292.00 .00 277.40 12086.32 1985 5 AAAAAAAAEMLCAAAA United States IN Hancock County 11 79.75 .00 78.95 85.14 1985 5 --- 200 row(s) selected.