Isochrones

[rkamnik]

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?
   
2. What should be inside the id and geom field in the table?
   
3. Can you send me the sample shp data from this video.

A big thanks ...

[Samweli]

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]

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:[email protected]] 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: [email protected]<mailto:[email protected]>, www.fgpa.um.si<http://www.fgpa.um.si/> Od: Samweli Mwakisambwe <[email protected]> Poslano: sreda, 31. julij 2019 22:28 Za: Samweli/isochrones <[email protected]> Kp: Rok Kamnik <[email protected]>; Mention <[email protected]> Zadeva: Re: [Samweli/isochrones] Isochrones (#8) Hi @rkamnik<https://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. 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<url>, 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 GitHub<#8?email_source=notifications&email_token=AMYLCNHPSG6FZHZMPOIFRIDQCHYURA5CNFSM4IIGAIEKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3IOUAI#issuecomment-517007873>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AMYLCNE6PA3WKCDN4YB6MOLQCHYURANCNFSM4IIGAIEA>.

[rkamnik]

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:[email protected]] 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: [email protected]<mailto:[email protected]>, www.fgpa.um.si<http://www.fgpa.um.si/> P Pred tiskanjem pomislite na OKOLJE ! Before printing, think about the ENVIRONMENT ! From: Samweli Mwakisambwe [mailto:[email protected]] Sent: Wednesday, July 31, 2019 10:28 PM To: Samweli/isochrones <[email protected]> Cc: Rok Kamnik <[email protected]>; Mention <[email protected]> Subject: Re: [Samweli/isochrones] Isochrones (#8) Hi @rkamnik<https://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. 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<url>, 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 GitHub<#8?email_source=notifications&email_token=AMYLCNHPSG6FZHZMPOIFRIDQCHYURA5CNFSM4IIGAIEKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3IOUAI#issuecomment-517007873>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AMYLCNE6PA3WKCDN4YB6MOLQCHYURANCNFSM4IIGAIEA>.

[Samweli]

Hi @rkamnik

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

Thanks.

[Samweli]

Just saw it, this one right [email protected] ?