dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Your shapefiles look good. Will have to investigate more closely to
understand why you get those weird coordinates in the database. Which
version and revision of DHIS2 are you using?

Knut

On Wed, Apr 1, 2015 at 9:48 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx> wrote:

>
>
> Dear
>
>
>
> Thanks a lot I already did the projection and this is my shape files
>
>
>
> You can try any one of them
>
>
>
> This is for Syria admin 1 , Admin 2 and Admin 3
>
>
>
> Thanks again
>
>
>
>
>
>
>
> From: Knut Staring [mailto:knutst@xxxxxxxxx]
> Sent: Wednesday, April 1, 2015 10:38 AM
> To: Nami Ghadri
> Cc: Halvdan Grelland; dhis2-users@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-users] GML
>
>
>
> Did you try reprojection? Perhaps you can share your shapefiles?
>
>
>
> Knut
>
>
>
> On Wed, Apr 1, 2015 at 9:36 AM, Nami Ghadri <nami_ghadri@xxxxxxxxxxx>
> wrote:
>
> Hello,
>
> I was able to do everything and import the GML with no errors
>
> But in the database in coordinates filed all values are (-31.4884,3.0E-4)
> for all org levels
>
> Please the attached txt file that contains a copy of one of the
> coordinates fields content
>
> Kindly advice
>
> Thanks in advance
>
>
>
>
>
>
>
> -----Original Message-----
> From: Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri <mailto:
> dhis2-users-bounces%2Bnami_ghadri> =hotmail.com@xxxxxxxxxxxxxxxxxxx] On
> Behalf Of Nami Ghadri
> Sent: Monday, March 30, 2015 3:34 PM
> To: 'Knut Staring'; 'Halvdan Grelland'
> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-users] GML
>
> Thanks a lot
>
>
>
> I will try it and give feed back
>
>
>
> Thanks a lot
>
>
>
>
>
>
>
>
>  <http://www.qrcs.org.qa/> Description: Description:
> cid:image001.jpg@01D02B6E.3FF14DC0
>
> نامي غادري
> مدير قسم تقنية المعلومات و الأنظمة
>
> بعثة تركيا
>
> Nami Ghadri
>
> Head Of Information technology and Systems Dept.
>
> Information Technoclogy & systems
>
> Turkey Mission
>
>
> Mob:+905317978228 <tel:%2B905317978228>              |        Skype:
> nami.ghadri         |           Gaziantep – Turkey
>
>
>
>
>
>
>
> From: Knut Staring [mailto:knutst@xxxxxxxxx]
> Sent: Monday, March 30, 2015 3:31 PM
> To: Halvdan Grelland
> Cc: Nami ghadri; dhis2-users@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-users] GML
>
>
>
>
> If the coordinates are off, you need to reproject the file, as described
> in the link that Halvdan just sent.
>
> For Syria, I'm guessing your shapefiles are in UTM 37N (see
> http://www.dmap.co.uk/utmworld.htm)
>
>
>
> This corresponds to EPSG:32637 (see
> http://spatialreference.org/ref/epsg/wgs-84-utm-zone-37n/ )
>
>
>
> In other words, you should install FWTools, open the FWTools console and
> run the following command:
>
> ogr2ogr -s_srs EPSG:32637 -t_srs EPSG:4326 -f GML filename.gml filename.shp
>
>
>
> On Mon, Mar 30, 2015 at 2:00 PM, Halvdan Grelland <halvdanhg@xxxxxxxxx>
> wrote:
>
> Hi Nami,
>
>
>
> I tried to import the file in question (syr_admin2.gml). Obviously I don't
> have the required DB for it to successfully import so I created a few of
> the orgunits named in the GML file. These import fine: reported as updated
> by the importer as well as their respective DB fields being populated
> correctly. Please make doubly sure you have the correct names set for the
> orgunits in the database.
>
>
>
> What query did you run to validate you DB contents? Please run the
> following after import:
>
>
>
> select name from organisationunit where featuretype is null or coordinates
> is null;
>
>
>
> Do you see the names of the orgunits in the GML file there? If so please
> also check the server logs if possible.
>
>
>
> Also make sure you have read and followed these steps:
>
> https://www.dhis2.org/doc/snapshot/en/user/html/ch18s02.html
>
>
>
> That being said your coordinate data seems to be completely off as the
> districts (at least from the few coordinates I sampled) seem to be located
> in the middle of the South Atlantic Ocean as well as covering incredibly
> small areas (smaller than we support in DHIS2). This would also cause your
> polygons to not render properly in GIS, of course. We do limit the import
> data on import to 4 decimal digits (which should give a maximum accuracy of
> ~10m).
>
>
>
> Regards,
>
> Halvdan
>
>
>
> 2015-03-29 19:42 GMT+02:00 Nami ghadri <nami_ghadri@xxxxxxxxxxx>:
>
> Dears,
>
>
>
> File nami.gml worked with me imported successfully and found it in database
>
>
>
> But file syr_admin2.gml was imported successfully but could not find it in
> database
>
>
>
>
>
> Thanks in advance
>
>
>
>
>
> From: Halvdan Grelland [mailto:halvdanhg@xxxxxxxxx]
> Sent: Sunday, March 29, 2015 8:33 PM
> To: Nayeem Al Mifthah
> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx; Nami ghadri
> Subject: Re: [Dhis2-users] GML
>
>
>
> More precisely: make sure there is a NAME property for each featureMember
> which matches the corresponding orgunit name property (identical match).
> You're welcome to send med a gml sample which you're having trouble with.
>
> On 29 Mar 2015 19:29, "Nayeem Al Mifthah" <n.mifthah@xxxxxxxxx> wrote:
>
> Dear Nami,
>
> Make sure thar Orgunit name is similar to the field name in shape file
> attribute table.
>
>
>
> And the coordinate system of shape file is similar to DHIS2 recommended
> one.
>
>
>
>
> Nayeem Al Mifthah
> HMIS Consultant
> Management Information System
> Directorate General of Health Services (DGHS), Bangladesh Supported by:
> UNICEF-Bangladesh
> Email: n.mifthah@xxxxxxxxx  | nayeem@xxxxxxxxxxxxxxx
>
> Cell:+8801914030574 <tel:%2B8801914030574>  <tel:%2B8801914030574>
>
>
>
>
> On Sun, Mar 29, 2015 at 10:15 PM, Nami ghadri <nami_ghadri@xxxxxxxxxxx>
> wrote:
>
> Hello All,
>
>
>
> I was able to covert shape file to GML file
>
>
>
> And export it to DHIS2
>
>
>
> Result are successful with no error and none is ignored
>
>
>
> But when I check data base on organisationunit table I can’t find the
> coordinates and also featuretype filed is empty ( is should give me Polygon
> )
>
>
>
> Any one faced that problem or any can give a guide line about it
>
>
>
> Thanks in advance
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
>
>
> --
>
> Knut Staring
>
> Dept. of Informatics, University of Oslo
>
> Norway: +4791880522 <tel:%2B4791880522>
>
> Skype: knutstar
>
> http://dhis2.org
>
>
>
>
>
>
>
> --
>
> Knut Staring
>
> Dept. of Informatics, University of Oslo
>
> Norway: +4791880522
>
> Skype: knutstar
>
> http://dhis2.org
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org