Understanding trade flow data and other informatio

Comments

16 comments

  • Avatar
    crrochette
    File attached with final data set.
  • Avatar
    crrochette
    File attached with final data set.
  • Avatar
    DougO
    You are looking at a special run. Very few people have seen the trade flow data. As far as the queries go, you will have to ask whoever made them. In the original data: Commodity: the IMPLAN sector number corresponding to the commodity Origin Index: All counties in the US are given an index number - there should be another table linking the county to its index number. Origin couny is the shipping (exporting) county Destination Index: The receiving (importing) county. Value: value of commodity shipped (millions of dollars). Notes: For each line of data, the index will be for a CO county either in the [i]Origination [/i]or the [i]Destination [/i](if not both). Each CO entry will show up twice, once for the counties' shipments to counties and again for the state shipments (which is summation of the couties). These are only domestic imports and exports. You will have to get the foreign exports from the IMPLAN study area for the county. If a locally grown ag commodity undergoes any value added it will be exported by the sector that created the value. For each commodity, the sum of a county's imports will be less than or equal that county's gross commodity demand and the sum of a county's export will less than or equal to that county's net commodity supply. In cases, you will find shipments by a county to itself, this represents local consumption of locally produced goods/services.
  • Avatar
    DougO
    You are looking at a special run. Very few people have seen the trade flow data. As far as the queries go, you will have to ask whoever made them. In the original data: Commodity: the IMPLAN sector number corresponding to the commodity Origin Index: All counties in the US are given an index number - there should be another table linking the county to its index number. Origin couny is the shipping (exporting) county Destination Index: The receiving (importing) county. Value: value of commodity shipped (millions of dollars). Notes: For each line of data, the index will be for a CO county either in the [i]Origination [/i]or the [i]Destination [/i](if not both). Each CO entry will show up twice, once for the counties' shipments to counties and again for the state shipments (which is summation of the couties). These are only domestic imports and exports. You will have to get the foreign exports from the IMPLAN study area for the county. If a locally grown ag commodity undergoes any value added it will be exported by the sector that created the value. For each commodity, the sum of a county's imports will be less than or equal that county's gross commodity demand and the sum of a county's export will less than or equal to that county's net commodity supply. In cases, you will find shipments by a county to itself, this represents local consumption of locally produced goods/services.
  • Avatar
    crrochette
    Summit Economics. Our contact was Greg Alward.
  • Avatar
    crrochette
    Summit Economics. Our contact was Greg Alward.
  • Avatar
    ScottL
    Greg works for us. What year data is it. We have made changes to that data set over the last year.
  • Avatar
    ScottL
    Greg works for us. What year data is it. We have made changes to that data set over the last year.
  • Avatar
    Greg Alward
    Have you looked at the tables in design mode? I'm pretty sure I documented each field in the comments sections. The origin and destination indices are key fields to join with other tables.
  • Avatar
    Greg Alward
    Have you looked at the tables in design mode? I'm pretty sure I documented each field in the comments sections. The origin and destination indices are key fields to join with other tables.
  • Avatar
    crrochette
    Hi Greg, I see where you noted the units for the values now. I've been able to run the queries fine. It's the resulting data that has brought up some questions. The flows for every commodity are very similar when it comes to other states. As in my example listed above, Eastern Colorado should reflect it's production of about 80% of agriculture for the state, but the values yielded for value flows from other states to Eastern CO is $78,981, and to the Front Range it is $79,103. The Front Range shouldn't be getting more money from agriculture than Eastern CO. These out-of-state flows are similar in number for all commodities, however, which is very strange. These numbers are also huge, especially if they represent millions of dollars. This would make our Out-of-State to Front Range number $79 billion. This is why I was wondering if the values represent all economic activity (vs final sales). Thanks, Christina
  • Avatar
    crrochette
    Hi Greg, I see where you noted the units for the values now. I've been able to run the queries fine. It's the resulting data that has brought up some questions. The flows for every commodity are very similar when it comes to other states. As in my example listed above, Eastern Colorado should reflect it's production of about 80% of agriculture for the state, but the values yielded for value flows from other states to Eastern CO is $78,981, and to the Front Range it is $79,103. The Front Range shouldn't be getting more money from agriculture than Eastern CO. These out-of-state flows are similar in number for all commodities, however, which is very strange. These numbers are also huge, especially if they represent millions of dollars. This would make our Out-of-State to Front Range number $79 billion. This is why I was wondering if the values represent all economic activity (vs final sales). Thanks, Christina
  • Avatar
    Greg Alward
    Please look at each table in the database in design mode. For example, the fields for table CO_Shipments_2007 are defined as: Commodity: Commodity Index (see CommodityCodes table) OriginIndex: Shipment origin index (see TradeIndex table) DestinationIndex: Shipment destination index (see TradeIndex table) Value: Value of commodity shipment in 2007 (Millions of $) Fields for other tables are commented similarly.
  • Avatar
    Greg Alward
    Please look at each table in the database in design mode. For example, the fields for table CO_Shipments_2007 are defined as: Commodity: Commodity Index (see CommodityCodes table) OriginIndex: Shipment origin index (see TradeIndex table) DestinationIndex: Shipment destination index (see TradeIndex table) Value: Value of commodity shipment in 2007 (Millions of $) Fields for other tables are commented similarly.
  • Avatar
    DougO
    Please send a copy of the San Luis and the Central CO queries so I can compare (the one that calculates inbound shipments from other states). Thanks - you can e-mail them to info@implan.com or post them.
  • Avatar
    DougO
    Please send a copy of the San Luis and the Central CO queries so I can compare (the one that calculates inbound shipments from other states). Thanks - you can e-mail them to info@implan.com or post them.

Please sign in to leave a comment.