search

Samweli / isochrones

A tool for creating isochrones maps
25 stars 6 forks source link

Isochrones #8

Open rkamnik opened 4 years ago

rkamnik commented 4 years ago

Dear Samweli A warm thanks for the video https://www.youtube.com/watch?v=thBKETlQbqY. I ave some issues regarding isochromes. Please help me out:dfd 1) I'm not sure why I cant import shp to my SQL database - I think that the data are not corectly prepared. Can you help me somehow? fig1 2) What should be inside the id and geom field in the table? fig2 3) Can you send me the sample shp data from this video.

A big thanks ...

Samweli commented 4 years ago

Hi @rkamnik,

Thanks for your feedback!

  1. This can happen if the database doesn't have the postgis extension, so you have to make sure postgis is installed and you create its extension in the database.

    If you want me to help you out on setting up the database and data before you use the plugin, just reach me out through my email.

  2. Inside "id" there should be any type of identifier that will be unique, "geom" is the geometry column for the table, you wont need to edit any data on this field, it is auto generated when importing shapefile to the database.

  3. You can find the sample data I used on the video here https://github.com/Samweli/isochrones/tree/master/iso/test/data, the point layer is inside catchment folder with filename hospitals and network layer inside network folder with filename roads.

Best.

rkamnik commented 4 years ago

Dear Samweli

Thanks for your quick response. I'm working on isochromes for whole week now and no results, so yes please if you could help me out.

1) Please help me setting up my postgis and creating extensions in the database. Online there is a bunch of instructions so I don't know which one to follow. I think that my postgre is installed correctly, then I just unzip postgis folders and files and copy them to the postgre folder – is that OK? If not, what should I do. I'm a windows user.

2) Now, how to create its extension in databse?

Best regards,

Rok KAMNIK

[cid:image001.jpg@01D29732.93F01730]

dr. sc. (Republika Hrvaška) Rok KAMNIK Univerza v Mariboru | University of Maribor Fakulteta za gradbeništvo, prometno inženirstvo in arhitekturo Faculty of Civil Engineering, Transportation Engineering and Architecture Smetanova ulica 17, 2000 Maribor, Slovenija T: +386 2 229 4313, F: +386 2 252 4179 E: rok.kamnik@um.simailto:ime.priimek@um.si, www.fgpa.um.sihttp://www.fgpa.um.si/

Od: Samweli Mwakisambwe notifications@github.com Poslano: sreda, 31. julij 2019 22:28 Za: Samweli/isochrones isochrones@noreply.github.com Kp: Rok Kamnik rok.kamnik@um.si; Mention mention@noreply.github.com Zadeva: Re: [Samweli/isochrones] Isochrones (#8)

Hi @rkamnikhttps://github.com/rkamnik,

Thanks for your feedback!

  1. This can happen if the database doesn't have the postgis extension, so you have to make sure postgis is installed and you create its extension in the database.

If you want me to help you out on setting up the database and data before you use the plugin, just reach me out through my email.

  1. Inside "id" there should be any type of identifier that will be unique, "geom" is the geometry column for the table, you wont need to edit any data on this field, it is auto generated when importing shapefile to the database.

  2. You can find the sample data I used on the video here https://github.com/Samweli/isochrones/tree/master/iso/test/data, the point layer is inside catchment folder with filename hospitals and network layer inside network folder with filename roads.

Best.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Samweli/isochrones/issues/8?email_source=notifications&email_token=AMYLCNHPSG6FZHZMPOIFRIDQCHYURA5CNFSM4IIGAIEKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3IOUAI#issuecomment-517007873, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMYLCNE6PA3WKCDN4YB6MOLQCHYURANCNFSM4IIGAIEA.

rkamnik commented 4 years ago

Dear Samweli

Me again ☺. I have resolved my database problems and add extension. I think the server and the database now works fine. I have also managed to import roads_cut and warehouse file in the database (Figure 3). I think that this is now OK.

1) When I start the Isochrone plugin I get the message in Fig 4. What is the problem now? Maybe because I work in the state CRS MGI 1901 / Slovene National grid 3912??? I'm attaching my dataset…

2) Unfortunatelly I can't test your dataset (obtained from GitHub) – roads, hospitals. Qgis says: Invalid data source: … path … is not a valid or recognised data source. Why so??? (Fig. 5)

Thank you verry much.

Rok KAMNIK

[cid:image001.jpg@01D29732.93F01730]

Docent / Assistant professor PhD dr. sc. (Republika Hrvaška) Rok KAMNIK Univerza v Mariboru | University of Maribor Fakulteta za gradbeništvo, prometno inženirstvo in arhitekturo Faculty of Civil Engineering, Transportation Engineering and Architecture Smetanova ulica 17, 2000 Maribor, Slovenija T: +386 2 229 4313, F: +386 2 252 4179 E: rok.kamnik@um.simailto:ime.priimek@um.si, www.fgpa.um.sihttp://www.fgpa.um.si/

P Pred tiskanjem pomislite na OKOLJE ! Before printing, think about the ENVIRONMENT !

From: Samweli Mwakisambwe [mailto:notifications@github.com] Sent: Wednesday, July 31, 2019 10:28 PM To: Samweli/isochrones isochrones@noreply.github.com Cc: Rok Kamnik rok.kamnik@um.si; Mention mention@noreply.github.com Subject: Re: [Samweli/isochrones] Isochrones (#8)

Hi @rkamnikhttps://github.com/rkamnik,

Thanks for your feedback!

  1. This can happen if the database doesn't have the postgis extension, so you have to make sure postgis is installed and you create its extension in the database.

If you want me to help you out on setting up the database and data before you use the plugin, just reach me out through my email.

  1. Inside "id" there should be any type of identifier that will be unique, "geom" is the geometry column for the table, you wont need to edit any data on this field, it is auto generated when importing shapefile to the database.

  2. You can find the sample data I used on the video here https://github.com/Samweli/isochrones/tree/master/iso/test/data, the point layer is inside catchment folder with filename hospitals and network layer inside network folder with filename roads.

Best.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Samweli/isochrones/issues/8?email_source=notifications&email_token=AMYLCNHPSG6FZHZMPOIFRIDQCHYURA5CNFSM4IIGAIEKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3IOUAI#issuecomment-517007873, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMYLCNE6PA3WKCDN4YB6MOLQCHYURANCNFSM4IIGAIEA.

Samweli commented 4 years ago

Hi @rkamnik

Great that you have made progress! Do you have an email? I could help you more through it.

Thanks.

Samweli commented 4 years ago

Just saw it, this one right rok.kamnik@um.si ?