more hospital details

[paola....@gmail.com]

Anand , Frances and all
below some hospitals addresses and urls
Angelo and Andy Carvin are getting translated shelters locations and contacts



Dr Sardjito General Hospital
Palliative Care Consultancy in the hospital
Jalan Kesenatan No 5
Yogyakarta 55284, INDONESIA
ph: 62274587333
fax: 62 274 514 495
http://members.bumn-ri.com/rs_sardjito/corporate_profile.html



Bethesda Hospital
http://www.yakkum.or.id/bethesda/
Jl. Jenderal Sudirman 70
Yogyakarta 55224
Phone: +62(0274)586688, +62(0274)562246
Fax : +62(0274)563312
beth...@indosat.net.id


Catholic Nuns Hospital
RUMAH SAKIT PANTI RAPIH
Jalan Cik Ditiro 30,
Yogyakarta 55223
Tel. +62 - 0274 - 514 845 or 563 650 or 563 333.
http://www.pantirapih.or.id/


University Medical Center
http://www.ugm.ac.id/index.php?page=frontpage
Gadjah Mada Medical Center (GMC)
+62(274)551411
+62(274)551412

On 5/29/06, Anand Madhvani <an...@dosima.org> wrote:

Dear Frances,

Welcome back!

I'm setting up the system now, but it will probably be a day or so until
we can start data entry.  I think it would be useful to work out what
the information gaps are at present, and where we should and can best
fit into that.  My feeling is that there is information needed about
refugee camps (shelters) but also hospitals, and maybe other
infrastructure too.

Would be good to scope that out now, and get some sense of where
information may be coming from, and who will need it.  I'm making
changes to the system according to what I anticipate, and what would be
useful for other disasters too.

I've got a fresh wiki running on www.shelterfinder.org - lets use that
for any planning.

best wishes
Anand





Frances wrote:
> Hi, Paolo,
>
> I did a lot of data input for Shelterfinder and Peoplefinder.
>
> If there is a place for me to help, please let me know.
>
> Thanks,
>
> Frances
>
>     ----- Original Message -----
>     *From:* paola....@gmail.com <mailto:paola....@gmail.com>
>     *To:* Anand Madhvani <mailto:an...@dosima.org> ; Angelo
>     Embuldeniya <mailto:angelo.em...@gmail.com> ; Fabio Varesano
>     <mailto:fa...@varesano.net>
>     *Cc:* Kieran Lal <mailto:kie...@civicspacelabs.org> ; Wendy
>     Edwards <mailto:mrs...@gmail.com> ; Frances
>     <mailto:chip...@iname.com>
>     *Sent:* Monday, May 29, 2006 6:56 AM
>     *Subject:* Re: handing over logins and mails
>
>     Brill, thanks a lot
>
>     I think some people are translating shelter data, let us know when
>     we can start loading it
>     And yes, if you make a set of instructions on how to handle
>     development we can keep the thing going in your absence.
>
>     I am cc Angelo who is coordinating with other people in Indonesia,
>     and Fabio, who had done the code for p2paid - please keep them in
>     your  loop.
>
>     I think we'd like to link each shelter to a url page on
>     p2pAid.org,  so that each shelter can load their list of  things
>     they need the most, that can be used by agencies to distribute
>     supplies directly to the shelters as needed
>
>     Let me know if there is anything you need from me
>
>     thanks again
>
>     PDM
>
>     On 5/29/06, *Anand Madhvani* <an...@dosima.org
>     <mailto: an...@dosima.org>> wrote:
>
>         >
>         > Anand, pls let us know how can we create a set of shelter
>         locations
>         > for Indonesia
>         > if possible
>         >
>         I've been working on it since yesterday.
>
>         Will take about a day more, my end, so start gathering
>         data...  I'll
>         have limited time after that, so would like to pass on the
>         code etc.
>
>         I also added the main aid agency maps to Google Earth and
>         alerted the
>         keyhole community, and hope that will bring in some people.
>
>         Anand
>
>
>

[Angelo Embuldeniya]

We now have the GIS data on roads & villages, files are with Wendy who's working on it at the moment, copies of the files have been forwarded on to Kathryn Cramer & P. Anand, do you guys have a wiki link for SF where people can go and dump raw info on locations, coordinates, etc.?

thanks,
angelo.

[Judith Barnett]

http://katrinahelp.info/wiki/index.php/ShelterFinder

[Judith Barnett]

Correction. The current wiki is here:

http://shelterfinder.org/wiki/index.php/Main_Page

On 5/29/06, Angelo Embuldeniya <angelo.em...@gmail.com> wrote:

[Angelo Embuldeniya]

thanks Judith, appreciate that.

[Wendy Edwards]

I've opened the GIS data you sent me - does this look about right?
Streets are green, villages are red. What do you need coordinates for
- the village points (in red)?

[Wendy Edwards]

OK, here's what I've found vis a vis the shapefile to KML conversion - some expensive proprietary software will do it.  Someone's also come up with a beta that's free, and I've asked him for a copy.  There's also a trial version of something that 1) doesn't work because it's missing at least one DLL and 2) wouldn't convert enough features anyhow.  If that falls through, there's also a possibility of converting shapefiles to GML and then seeing if this GML to KML XSLT file I found works.

http://interactiveearth.blogspot.com/ (beta converter)
http://members.home.nl/cybarber/geomatters/GML2KML.xslt (XSLT)

I'll also ask my coworkers about free map servers out there.

On 5/30/06, Anand Madhvani <an...@dosima.org> wrote:

Hi Angelo,

That is the URL of the old KH Wiki - we have moved to one on the same site as SF now:

    http://www.shelterfinder.org/wiki/index.php/Main_Page
        or just plain
    http://www.shelterfinder.org/wiki/

Would be useful to see this GIS data - please zap it across, Angelo or Wendy.  I can also do rough geocoding dynamically for Indonesia dynamically using Geonames, as people add other data.   I'm attaching a dump of their data, although I'm not sure, however, how useful importing large tables of GIS data will be at this stage.  It may swamp the system and user interface for the mapping - probably better to start with key places we have some info for.  I'd started to process local village names to import, and assuming we'll want to link/add any snippets of information we can glean about locations like villages, shelters, hospitals.

It is an opaque clutter of information that I'm seeing at the moment...  I think we can help by mapping some of it, but setting up an obvious place where data can be maintained, status updated.  I'd find it useful to know what others are seeing and thinking, at this stage - lots of activity without clear shared direction will lead to wasted energies.

Below is the field structure I'm now using for ShelterFinder.  This is based on abstracting from the US-based shelter data, to try and accomodate village data from Pakistan last year.  There is useful information about Indonesian regional names/administrative structures at http://en.wikipedia.org/wiki/Subdivisions_of_Indonesia

Will make some changes this morning, to allow direct entry to the site.  I'm then collecting someone from the airport so busy the rest of today.

	locationID	smallint(10)		No		auto_increment	Change	Drop	Primary	Index	Unique	Fulltext
	disaster	smallint(4)		No			Change	Drop	Primary	Index	Unique	Fulltext
	duplicate	smallint(6)		No			Change	Drop	Primary	Index	Unique	Fulltext
	location	varchar(250)		No			Change	Drop	Primary	Index	Unique	Fulltext
	address1	varchar(250)		No	address (street etc)		Change	Drop	Primary	Index	Unique	Fulltext
	address2	varchar(250)		No	village		Change	Drop	Primary	Index	Unique	Fulltext
	address3	varchar(50)		No	sub-district (kecamatan)		Change	Drop	Primary	Index	Unique	Fulltext
	address4	varchar(50)		No	city		Change	Drop	Primary	Index	Unique	Fulltext
	address5	varchar(50)		No	sub-province (kabupaten/kota)		Change	Drop	Primary	Index	Unique	Fulltext
	address6	varchar(50)		No	province		Change	Drop	Primary	Index	Unique	Fulltext
	addressCountry	varchar(50)		No			Change	Drop	Primary	Index	Unique	Fulltext
	addressCode	varchar(50)		No			Change	Drop	Primary	Index	Unique	Fulltext
	addressCategory	smallint(2)		No			Change	Drop	Primary	Index	Unique	Fulltext
	latitude	double		Yes			Change	Drop	Primary	Index	Unique	Fulltext
	longitude	double		Yes			Change	Drop	Primary	Index	Unique	Fulltext
	dataType	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	dataName	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	status	varchar(50)		No			Change	Drop	Primary	Index	Unique	Fulltext
	capacity	varchar(50)		Yes			Change	Drop	Primary	Index	Unique	Fulltext
	people	smallint(6)		Yes			Change	Drop	Primary	Index	Unique	Fulltext
	contactPhone	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	contactEmail	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	contactName	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	contactInfo	text		No			Change	Drop	Primary	Index	Unique	Fulltext
	contactNotes	text		No			Change	Drop	Primary	Index	Unique	Fulltext
	publicNotes	text		No			Change	Drop	Primary	Index	Unique	Fulltext
	extraText1	varchar(255)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	extraText2	varchar(255)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	extraMemo1	text		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	extraMemo2	text		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	extraNumber1	smallint(6)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	extraNumber2	double		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	modifiedSource	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	modifiedNotes	text		No			Change	Drop	Primary	Index	Unique	Fulltext
	modifiedUser	varchar(255)		No			Change	Drop	Primary	Index	Unique	Fulltext
	modifiedUserID	smallint(10)		No	0		Change	Drop	Primary	Index	Unique	Fulltext
	modifiedDate	datetime		No	0000-00-00 00:00:00		Change	Drop	Primary	Index	Unique	Fulltext

Angelo Embuldeniya wrote:

Guys, is this the sf wiki or the sf coordination page for katrina on the kh wiki?

http://katrinahelp.info/wiki/index.php/ShelterFinder

[paola....@gmail.com]

Hi Anand
thanks for the updates and for setting up local wiki
I think you are ablosutely right that we do not need to import large files for which we have not use.
What I would identify/represent  to start with are the essential nodes that can be useful for logistic purposes
I followed you suggestion yesterday by starting with hospitals and I see you've followed up with more generic inftrascturure data

In addition to generic landmarks like hospitals, I think  we should wait from the input from the ground
(: hey give us the coordinates and qualitative information of the  emergency nodes as they are being set up) and we put them on our maps accordingly,
So that the resulting map will be reflecting the emergency network as it is now, rather than what itwas before the quake, and it can be used for resource allocation purposes

For this purpose specifically, I would hope that we can count on the collaboration of the international media currently covering the emergency to make sure that their reports include precise information and useful data about what they find. I was disapointed yesterday to read stories about 'hospitals need supply' and then a BBC report saying 'hospital have supplies' .    Maybe some supplies they have, and some they need,
I read a lot of reports where they say that the situation is desperate, but nobody can make a list of things that are needed and where to send them. if press reports could provide us with an additinal  level detail and relevant contact information when they  find out about a need, it would be very useful.

--
Paola Di Maio
Systems Analyst
www.content-wire.com

[paola....@gmail.com]

Wendy
any idea what kind of data is in those gis files? is it generic geospatial coord about the region, or specific locatoins inputted by emergency
workers?)
I mean,  do we seleect subsets that are relevant to us, or something that we have to import as a whole

also, I am confident that any software firm will grant us a temprorary license free of charge, please let me know
of any software that we need and I ll try to get a copy for us to use

cheers
pdm

[Wendy Edwards]

What we seem to have now are the village and road layers, but no labels (which might be different layers).

On 5/30/06, paola....@gmail.com <paola....@gmail.com> wrote: