Re: [Talk-us] Talk-us Digest, Vol 108, Issue 10

[Georg Verweyen]

Hello,

did you discuss this on on the list impo...@openstreetmap.org 
 ?

I checked the csv data:
there isn’t any geo coordinates
the column "Adress Line 1" has value of addr:housenumber and addr:street
the column „Main Phone“ has the wrong format (xxx) xxx- instead 
+1-xxx-xxx-
the column „Sunday hours“ to „Saturday hours“ has also a wrong format (must be 
changed to 24h format)
the column „Sunday hours“ to „Saturday hours“ must be calculated to one key 
„opening_hours“.
A short search(*) for „lancastergeneralhealth.org 
“ shows only a building with this URL 
(https://www.openstreetmap.org/way/18231 
). This object is part of the list 
(okay: you must change the street name to "West 2nd Avenue“) to find this with 
Nominatim. But see three object with the same address (line 55, 58, 60 with 52 
Peters Road in 175543 Lititz). Can’t find these address in Lititz :( .

Regards

Georg V. (OSM=user_5359)
(*) with over-turbo.eu  : http://overpass-turbo.eu/s/k3e 
 
> Am 14.11.2016 um 17:53 schrieb talk-us-requ...@openstreetmap.org:
> 
> Message: 1
> Date: Mon, 14 Nov 2016 11:50:05 -0500
> From: Justin Mosebach >
> To: impo...@openstreetmap.org , 
> talk-us@openstreetmap.org 
> Subject: [Talk-us] Bulk import for large healthcare system in central
>   PA
> Message-ID:
>    >
> Content-Type: text/plain; charset="utf-8"
> 
> Hello,
> 
> We're working with Lancaster General Health which has 105 physical
> locations (not doctors, etc) in Lancaster and Chester counties in
> Pennsylvania.
> 
> I have updated data for all of the locations directly from them, which I've
> attached to this email as a CSV. This data includes the names, addresses,
> phone numbers, URLs, hours, and even descriptions of each location.
> 
> I've never done a bulk import with OSM before, but am excited to learn.
> 
> Can someone let me know what the next step is?
> 
> Thanks!
> 
> Justin Mosebach, *Director of Local Search*

___
Talk-us mailing list
Talk-us@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-us

Re: [Talk-us] Bulk import for large healthcare system in central PA

[Frederik Ramm]

Hi,

On 11/14/2016 06:40 PM, Justin Mosebach wrote:
> Would lat/long suffice for the location info (in addition to the address)?

It would certainly be enough to point a human to the right spot on the
map where they could then verify whether the object in question is
already on OSM (in which case they might choose to just add some of the
extra data you have), or whether it needs to be newly created.

Note that the "advertising slogan" you have included in your data is not
suitable for OSM and must be omitted.

If you want you can look for ways to boil this down to verifiable facts
(e.g. where it says "Has served families since 1976" you could put
"start_date=1976",or where the text includes information about what the
practice specializes in, this could lead to a "healthcare:speciality"
tag as documented in http://wiki.openstreetmap.org/wiki/Key:healthcare)
but somethink like "fast, friendly, convenient" or "small enough for X
yet large enough for Y" is not something that can be put in OSM.

Best
Frederik

-- 
Frederik Ramm  ##  eMail frede...@remote.org  ##  N49°00'09" E008°23'33"

___
Talk-us mailing list
Talk-us@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-us

Re: [Talk-us] Bulk import for large healthcare system in central PA

[Justin Mosebach]

Thanks for the info! Yes, I did see the import guidelines (which led me to
emailing this group).

Would lat/long suffice for the location info (in addition to the address)?

Thanks,
Justin

On Mon, Nov 14, 2016 at 12:09 PM, Clifford Snow 
wrote:

> Justin,
> I'm guessing you have looked at the import guidelines [1], but if you
> haven't, you can find them on the wiki. The import guidelines talk about
> community involvement, licensing, documentation and the actual import. For
> community involvement, you might want to join us on the US Slack import
> channel [2].
>
> From looking at the data, the one major piece missing is location. While
> the address is there, that means you'll have to rely on a geocoder which
> probably won't provide the accuracy needed to properly locate the building.
> When you document the process, please specify how you plan to determine the
> location. If you do plan on using a geocoder, it's important to use one
> that won't cause a licensing issue.
>
> Best,
> Clifford
>
> [1] https://wiki.openstreetmap.org/wiki/Import/Guidelines
> [2] Sign up at https://osmus-slack.herokuapp.com/
>
> On Mon, Nov 14, 2016 at 8:50 AM, Justin Mosebach  wrote:
>
>> Hello,
>>
>> We're working with Lancaster General Health which has 105 physical
>> locations (not doctors, etc) in Lancaster and Chester counties in
>> Pennsylvania.
>>
>> I have updated data for all of the locations directly from them, which
>> I've attached to this email as a CSV. This data includes the names,
>> addresses, phone numbers, URLs, hours, and even descriptions of each
>> location.
>>
>> I've never done a bulk import with OSM before, but am excited to learn.
>>
>> Can someone let me know what the next step is?
>>
>> Thanks!
>>
>> Justin Mosebach, *Director of Local Search*
>> YDOP
>> http://www.ydop.com
>> 717-397-1212
>>
>>
>>
>> ___
>> Talk-us mailing list
>> Talk-us@openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/talk-us
>>
>>
>
>
> --
> @osm_seattle
> osm_seattle.snowandsnow.us
> OpenStreetMap: Maps with a human touch
>
___
Talk-us mailing list
Talk-us@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-us

Re: [Talk-us] Bulk import for large healthcare system in central PA

[Clifford Snow]

Justin,
I'm guessing you have looked at the import guidelines [1], but if you
haven't, you can find them on the wiki. The import guidelines talk about
community involvement, licensing, documentation and the actual import. For
community involvement, you might want to join us on the US Slack import
channel [2].

>From looking at the data, the one major piece missing is location. While
the address is there, that means you'll have to rely on a geocoder which
probably won't provide the accuracy needed to properly locate the building.
When you document the process, please specify how you plan to determine the
location. If you do plan on using a geocoder, it's important to use one
that won't cause a licensing issue.

Best,
Clifford

[1] https://wiki.openstreetmap.org/wiki/Import/Guidelines
[2] Sign up at https://osmus-slack.herokuapp.com/

On Mon, Nov 14, 2016 at 8:50 AM, Justin Mosebach  wrote:

> Hello,
>
> We're working with Lancaster General Health which has 105 physical
> locations (not doctors, etc) in Lancaster and Chester counties in
> Pennsylvania.
>
> I have updated data for all of the locations directly from them, which
> I've attached to this email as a CSV. This data includes the names,
> addresses, phone numbers, URLs, hours, and even descriptions of each
> location.
>
> I've never done a bulk import with OSM before, but am excited to learn.
>
> Can someone let me know what the next step is?
>
> Thanks!
>
> Justin Mosebach, *Director of Local Search*
> YDOP
> http://www.ydop.com
> 717-397-1212
>
>
>
> ___
> Talk-us mailing list
> Talk-us@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-us
>
>


-- 
@osm_seattle
osm_seattle.snowandsnow.us
OpenStreetMap: Maps with a human touch
___
Talk-us mailing list
Talk-us@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-us

[Talk-us] Bulk import for large healthcare system in central PA

[Justin Mosebach]

Hello,

We're working with Lancaster General Health which has 105 physical
locations (not doctors, etc) in Lancaster and Chester counties in
Pennsylvania.

I have updated data for all of the locations directly from them, which I've
attached to this email as a CSV. This data includes the names, addresses,
phone numbers, URLs, hours, and even descriptions of each location.

I've never done a bulk import with OSM before, but am excited to learn.

Can someone let me know what the next step is?

Thanks!

Justin Mosebach, *Director of Local Search*
YDOP
http://www.ydop.com
717-397-1212
Store Code,Name,Address Line 1,Address Line 2,City,State,Postal Code,Main Phone,Home Page,Hours,Description,Sunday hours,Monday hours,Tuesday hours,Wednesday hours,Thursday hours,Friday hours,Saturday hours
PRIMARY-MountJoyFamily,LG Health Physicians Family Medicine Mount Joy,1001 Cornerstone Drive,Suite B,Mount Joy,PA,17552,(717) 653-2929,http://lancastergeneralhealth.org/LGH/Locations/LG-Health-Physicians/Family-Medicine/Mount-Joy-Family-Medicine.aspx,,"Offering a full spectrum of care, our family doctors offer a small-town, personal practice while bringing the quality of care associated with LGH. After hours, call 717-653-2929.",X,07:30AM-08:00PM,07:30AM-04:30PM,07:30AM-04:30PM,07:30AM-08:00PM,07:30AM-04:30PM,08:00AM-12:00PM
PRIMARY-AbbeyvilleFamily,LG Health Physicians Family Medicine Abbeyville,101 Abbeyville Road, ,Lancaster,PA,17603,(717) 291-5991,http://lancastergeneralhealth.org/LGH/Locations/LG-Health-Physicians/Family-Medicine/Abbeyville-Family-Medicine.aspx,,"LG Health Physicians Family Medicine Abbeyville has served families in the Lancaster community since 1976, growing and expanding to meet your needs. After hours, please call 291-5991.",X,08:00AM-08:00PM,08:00AM-08:00PM,08:00AM-08:00PM,08:00AM-08:00PM,08:00AM-05:00PM,08:00AM-12:00PM
PRIMARY-StrasburgFamily,LG Health Physicians Family Medicine Strasburg,1135 Hampden Drive, ,Strasburg,PA,17579,(717) 687-0313,http://lancastergeneralhealth.org/LGH/Locations/LG-Health-Physicians/Family-Medicine/Strasburg-Family-Medicine.aspx,,"We're a community-based family practice committed to treating our patients as part of our family. We offer our patients a comprehensive approach to their wellness needs. After hours, call 717-687-0313",X,08:00AM-08:00PM,08:00AM-09:00PM,08:00AM-09:00PM,06:30AM-08:00PM,06:30AM-05:00PM,X
PRIMARY-SusquehannaFamily,LG Health Physicians Family Medicine Susquehanna,1159 River Road, ,Marietta,PA,17547,(717) 426-1131,http://www.lancastergeneralhealth.org/LGH/Locations/LG-Health-Physicians/Family-Medicine/Susquehanna-Family-Medicine.aspx,,"We're small enough to offer more personal, patient-centered care, yet large enough to be on the cutting edge of medical advancements. After hours, please call 717-426-1131.",X,08:00AM-08:00PM,08:00AM-08:00PM,08:00AM-08:00PM,08:00AM-08:00PM,08:00AM-05:30PM,08:00AM-01:00PM
OUT-HealthSpecialtyCenterEphrata,Lancaster General Health Specialty Center Ephrata,1261 Division Highway,Suite 2,Ephrata,PA,17522,(888) 884-2377,http://www.lancastergeneralhealth.org/LGH/Locations/Outpatient/LG-Health-Specialty-Center-Ephrata.aspx,,The Lancaster General Health Specialty Center brings quality care and specialists directly to your neighborhood.,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS
SPECIALIST-ArthritisRheumatologyEphrata,LG Health Physicians Arthritis & Rheumatology,1261 Division Highway,Suite 2,Ephrata,PA,17522,(717) 738-0777,http://www.lancastergeneralhealth.org/LGH/Locations/LG-Health-Physicians/Rheumatology/Arthritis-and-Rheumatology-Specialists.aspx,,"We focus on diagnosing and treating arthritis and other disorders of the muscles, joints and bones in order for you to live a healthy and active life. After hours, call 717-738-0777.",DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS,DON'T PUBLISH HOURS
SPECIALIST-HeartGroup-Ephrata,The Heart Group of Lancaster General Health,1261 Division Highway,Suite 2,Ephrata,PA,17522,(888) 884-2377,http://www.lancastergeneralhealth.org/LGH/Our-Services/HeartCenter/The-Heart-Group-of-LGH/About-Us.aspx,,"The Heart Group of Lancaster General Health is a dynamic, growing practice of clinicians committed to providing world-class patient care while contributing to advancing cardiovascular science.",X,X,X,X,08:00AM-04:00PM,08:00AM-04:00PM,X
OUT-RosevillePediatrics-Lanc,Roseville Pediatrics,160 North Pointe Boulevard,Suite 110,Lancaster,PA,17601,(717) 569-6481,http://lancastergeneralhealth.org/LGH/Locations/LG-Health-Physicians/Pediatrics/Roseville-Pediatrics.aspx,,"At LG Health Physicians Roseville Pediatrics in Lancaster, caring for children has been our passion for more than three decades.",X,08:30AM-08:00PM,08:30AM-08:00PM,08:30AM-08:00PM,08:30AM-08:00PM,08:30AM-08:00PM,09:00AM-12:00PM
URGCARE-LancHealthExpress,Lancaster General