[Imports] United States Poultry Import

Wed Apr 20 13:53:13 UTC 2022

III.

Based on the CSV ( from the original link ) as  I see  -
*-  this is  ~2009 data  ( *CONTDATE column )
- * NAVTEQ 2008Q1 based  ( *ST_VENDOR ST_VERSION columns )

CONTDATE
2009/02/19 00:00:00+00
2009/03/02 00:00:00+00
2009/02/03 00:00:00+00
2009/02/20 00:00:00+00

GEODATE
2009/02/19 00:00:00+00
2009/03/02 00:00:00+00
2009/02/03 00:00:00+00
2009/02/20 00:00:00+00
2009/02/23 00:00:00+00

ST_VENDOR ST_VERSION GEOPREC
NAVTEQ 2008Q1 BLOCKFACE
NAVTEQ 2008Q1 ONENTITY
NAVTEQ 2008Q1 ONENTITY
NAVTEQ 2008Q1 ONENTITY
NAVTEQ 2008Q1 ONENTITY
NAVTEQ 2008Q1 ONENTITY
NAVTEQ 2008Q1 ONENTITY

and some factory has been changed:

1.)     Mar-lees Seafood, Inc.  / New Bedford / MA   --->  now Seatrade
details: https://gist.github.com/ImreSamu/68b8cdaabcd7098a88cfa2ee96c47b12
-  in the import* "Mar-lees Seafood, Inc."*    ( ~ 2009  data )
-  on the news:   2014  *"Seatrade acquires Mar-Lees scallop processing
plant" *

https://www.seafoodsource.com/news/supply-trade/seatrade-acquires-mar-lees-scallop-processing-plant
    "Seatrade International Co. of Topsfield, Mass., USA, will acquire a
66,000-square-foot scallop processing facility currently operated by
Mar-Lees Seafood in New Bedford, Mass."
-  same building in the osm:   *name=Seatrade*
https://www.openstreetmap.org/way/214662555

Imre

Imre Samu <pella.samu at gmail.com> ezt írta (időpont: 2022. ápr. 19., K,
21:07):

> II .
>
> for me, ( living in Europe )   this NY city name is strange
> *addr:city=Astoria*
> (  based on:  https://en.wikipedia.org/wiki/Astoria,_Queens
>    "Astoria is a neighborhood in the western portion of the New York City
> borough of Queens."  )
>
> on the other hand
> -  I have found a lot of other similar POI -s (
> https://overpass-turbo.eu/s/1hNB “'addr:city'=Astoria in "New york"”  )
> -  but I have found  :   addr:city ="Queens" or addr:city ="New York"
> values
>
> Strange :-)
>
> $ osmium getid -f osm
>  Poultry_Slaughtering_and_Processing_Facilities_addrfixed.osm n119407
> <?xml version='1.0' encoding='UTF-8'?>
> <osm version="0.6" upload="false" generator="osmium/1.13.1">
>   <node id="-119407" lat="40.7707906" lon="-73.9217011">
>     <tag k="TEXT35temp" v="PROCESSING"/>
>    * <tag k="addr:city" v="Astoria"/>*
>     <tag k="addr:housenumber" v="25-38"/>
>     <tag k="addr:postcode" v="11102"/>
>     <tag k="addr:state" v="NY"/>
>     <tag k="addr:street" v="-38 Astoria Boulevard"/>
>     <tag k="man_made" v="works"/>
>     <tag k="name" v="Dubonilha Sausage Company"/>
>     <tag k="product" v="meat"/>
>     <tag k="source" v="HIFLD Poultry Slaughtering and Processing
> Facilities"/>
>   </node>
> </osm>
>
> Imre
>
> Imre Samu <pella.samu at gmail.com> ezt írta (időpont: 2022. ápr. 19., K,
> 20:12):
>
>> > All details are at
>> https://wiki.openstreetmap.org/wiki/United_States_Poultry_Import - see
>> also the talk page there.
>>
>> Hi Hiausirg,
>>
>> quick feedback:
>>
>> 1.)
>> in the addr:housenumber=*    there are a lot of strange values ( at least
>> for me )
>> - at least an "AVE" / "AVENUE" is strange ..
>>
>> $ cat Poultry_Slaughtering_and_Processing_Facilities_addrfixed.osm |
>> grep addr:housenumber  | cut -d"'" -f4 | sort -u | tail -n 50
>> ALASKA
>> AS
>> AVE
>> AVENIDA
>> AVENUE
>> BARRIO
>> CALLE
>> CARRETER
>> CHASE
>> CLAFLIN
>> CRAVENS
>> DOTTIE
>> DVORACHE
>> E0320
>> EAST
>> EVANS
>> FARM
>> GRIDER
>> HARMON
>> INDIANA
>> LEONA
>> MAIN
>> MARGINAL
>> MEAT
>> N3620
>> N4993
>> N5765
>> N6927
>> N6977
>> N979
>> NORTH
>> ONE
>> P314
>> PARQUE
>> PLATT
>> PONCE
>> PORTER
>> S-120
>> SOUTH
>> SPEEDWAY
>> SPRINGFI
>> STATE
>> UNITED
>> W11644
>> W1184
>> W2103
>> W4315
>> W8876
>> W8880
>> WEST
>>
>> example for strange value :    addr:housenumber" v="AVENUE"
>>
>> $ osmium getid
>>  Poultry_Slaughtering_and_Processing_Facilities_addrfixed.osm -f osm
>> n118295
>> <?xml version='1.0' encoding='UTF-8'?>
>> <osm version="0.6" upload="false" generator="osmium/1.13.1">
>>   <node id="-118295" lat="18.4201131" lon="-67.1558754">
>>     *<tag k="TEXT35temp" v="PROCESSING"/>*
>>     <tag k="addr:city" v="Aguadilla"/>
>>    * <tag k="addr:housenumber" v="AVENUE"/>*
>>     <tag k="addr:postcode" v="00603"/>
>>     <tag k="addr:state" v="PR"/>
>>     <tag k="addr:street" v="Avenue Yumet 112"/>
>>     <tag k="man_made" v="works"/>
>>     <tag k="name" v="Elaboracion Felo Incorporado"/>
>>     <tag k="product" v="meat"/>
>>     <tag k="source" v="HIFLD Poultry Slaughtering and Processing
>> Facilities"/>
>>   </node>
>> </osm>
>>
>>
>> 3.)
>> I have converted to geojson with this command:
>> osmium export
>>  Poultry_Slaughtering_and_Processing_Facilities_addrfixed.osm -o
>> poultry_import2022apr19.geojson
>>
>> and uploaded to GitHub gist  - for a visual check;  result:
>> https://gist.github.com/ImreSamu/30e816d6dca4f39301c3fa21eb1a20f6
>> the good news:  No NULL Island!
>> probably some US local mappers - have to spot check!
>>
>> 4.)
>> Tags stat
>>
>> $ osmium tags-count
>>  Poultry_Slaughtering_and_Processing_Facilities_addrfixed.osm
>> 4459 "addr:city"
>> 4459 "addr:housenumber"
>> 4459 "addr:postcode"
>> 4459 "addr:state"
>> 4459 "addr:street"
>> 4459 "name"
>> 4459 "product"
>> 4459 "source"
>> 4187 "man_made"
>> *3322 "TEXT35temp"           <---- Strange , please verify ! *
>> 647 "industrial"
>> 277 "building"
>>
>>
>> regards,
>>  Imre
>>
>>
>> Hiausirg <grussausbw at gmx.de> ezt írta (időpont: 2022. ápr. 19., K,
>> 12:14):
>>
>>> I'm planning a relatively small import of chicken slaughterhouses and
>>> processing sites in the US - All details are at
>>> https://wiki.openstreetmap.org/wiki/United_States_Poultry_Import - see
>>> also the talk page there.
>>>
>>> Greetings
>>>
>>> _______________________________________________
>>> Imports mailing list
>>> Imports at openstreetmap.org
>>> https://lists.openstreetmap.org/listinfo/imports
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20220420/64413a7e/attachment.htm>