Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


dil_bert last won the day on June 12 2019

dil_bert had the most liked content!

Community Reputation

5 Neutral

About dil_bert

  • Rank
    Prolific Member

Profile Information

  • Interests
    used OpenSuse for more than 10 years - now stick to Mx-Linux; Interested in all raspi-things, Python, Perl, PHP and GIS,

Recent Profile Visitors

8,736 profile views
  1. update: i have found a good and solid manual that describes to get started with open-street-map-to-postgis-the-basics https://www.cybertec-postgresql.com/en/open-street-map-to-postgis-the-basics/
  2. hi there good day dear friends, I am trying to maintain a postgresql database using osm2pgsql to maintain my database. idea: I want to track the changes made by the daily replication files. do i need to create triggers that fired after delete, update and insert. should i do a daily update process. the idea: having a OSM dataset on Postgresql via osm2pgsql. Now I am trying to query all public buildings in UK such as - hospitals, - schools, - fire stations and - churches. - gasoline stations and so on and so forth Well in order to do that, I use something like this query: SELECT * FROM planet_osm_point pop WHERE pop.amenity IN ('hospital','fire_station','place_of_worship','school, gasoline stations') well - how do you think about this approach? Is is a good method do do so!? By looking at the results, it just extracts some of the existing hospitals. i am pretty sure that there are much more hospitals. I can see the red plus logo for hospitals that I also know that they exist there. But it does not show them in the query results. Question: How can I include all of these buildings? assumption: i guess that i am missing those hospitals mapped as areas. We have to run the same query on planet_osm_polygon as well, or we could construct a "union" query: This would come with alot of benefits for the request: That gives us the centrepoints of polygons in addition to the points we have above. i guess that we need to use the amenity = 'hospital' from the polygon table and union all with the points. The benefit: it would gives a few more hospitals. The next step needs to be to find out the node, way or relation ID of a hospital that we're missing and query our database for it. btw: can i do this with Python - working on the Overpass API what about the query OSM data with the Overpass API, but how can we use this data now? a idea and a method to download the data is by using the command line tools curl or wget. In order to do this we need to access one of the Overpass API endpoints, where the one we will look go by the format http://overpass-api.de/api/interpreter?data=query. When using curl we can download the OSM XML of our query by running the command curl --globoff -o output.xml http://overpass-api.de/api/interpreter?data=node(1);out; well - the previously crafted query comes after data= and the query needs to be urlencoded. The --globoff is important in order to use square and curly brackets without being interpreted by curl. This query returns the following XML result <?xml version="1.0" encoding="UTF-8"?> <osm version="0.6" generator="Overpass API ff15392f"> <note>The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.</note> <meta osm_base="2018-02-24T21:09:02Z"/> <node id="1" lat="61.4779481" lon="-0.0014863"> <tag k="historic" v="memorial"/> <tag k="memorial" v="stone"/> <tag k="name" v="gasoline-station at the corner"/> </node></osm> regarding the methods to get the data which method is better and more appropiate? regarding the formats: well we have to say: there are various output formats to choose from in the documentation. In order to download the query result as JSON we need to add [out:json]; to the beginning of our query as in the command: curl --globoff - o output.json http://overpass-api.de/api/interpreter?data=[out:json];node(1);out; ...giving us the previous XML result in JSON format. You can test the query also in the browser by accessing http://overpass-api.de/api/interpreter?data=[out:json];node(1);out;. which way would you go? look forward to hear from you
  3. hello and good day, first of all - i hope that this question is placed in the correct forum. Dear admin - if not please set me straight and help me to put the question in the right forum. Many thanks for all you did!! Keep up the great project here at neowin it rocks!!! i am pretty new to openStreetmap and have only some insights into openStreetmap: my wiki-page: https://wiki.openstreetmap.org/wiki/User:Tagtheworld some first steps into the technique of OpenStreetMap i have made: working with the languages like PHP / Perl and of course Python i am working on the API-endpoint with requests ... osmconvert and osmfilter Overpass-API and Overpass-Turbo-API working on the planet file - at the API-Endpoint with PHP, Perl, Python - PostGIS and of course osmosis - the OpenStreetMap - swiss army tool. now i have seen a interesting dataset like healthsites.io_ this is pretty cool: this is just outstanding and great! i work for an organization that contributes to volunteering opportunities especially in the field of education and medicine (hospital, clinic etc. etx). peace and development through volunteerism worldwide. Volunteerism - in general - is a powerful means of engaging people in tackling development challenges, and it can transform the the engagement of a single volunteer. Volunteerism benefits both society at large and - besides that- the individual volunteer by strengthening trust, solidarity and reciprocity among citizens, and by purposefully creating opportunities for participation. At the moment we re thinking about doing some first steps with the great dataset of healthsites. regarding healthsites this is the most important link: https://healthsites.io/api/docs/ Means there is an API to get the data from with a personal API key …: note: with this - i should be able to put the data on a website e.g. to a mapping plugins of wordpress. there some of them working with openStreetmap - see for example: https://de.wordpress.org/plugins/search/map/ they are equipped with a whole lot of top notch and very advanced features so we do not need to manually embedded map. In addition to single or multiple locations, interactive map plugins provide: – were able to add – Custom icons and markers – Animations – Filter and search options – Clusterization – Zooming and panning – pinning the map to a block – using the data that comes shipped with the map. question: can we run and apply the data from the Open data collaboration https://healthsites.io in wordpress :: look forward to hear from you above all: keep up the great project - it rocks. regards
  4. hello dear all, limesurvey - pre installation check stalls permanent - how to go round today i want to share my issues with you - the issues that i have with limesuvey a very very famous open-source-survey.script see https://forums.limesurvey.org/ https://community.limesurvey.org/ Latest Linux Installer Stalls at Pre-Installation Check Have unpacked and run installation script, but find it stalls continuously at the Pre-Installation check. The two warning which are apparently really errors (since installation is not allowed to proceed) are: Session Writeable > session.save_path: /temp PHP LDAP Library > Warning Icon Could find no online docs to provide any insight into further troubleshooting. well dear commuity i want you to confirm that the directory permissions are set per installation docs. Any suggestions welcome. by the way: can i go round the annoying step of the Pre-Installation check? This is pretty annoying...: https://forums.limesurvey.org/forum/installation-a-update-issues/121835-sessions-not-writable-permanent-complaint-in-installer-script#203280 We save a session variable : https://github.com/LimeSurvey/LimeSurvey/blob/14b5f4b26ac79ec244117c5e599ec6d06c04294e/application/controllers/InstallerController.php#L169 We read a session variable : https://github.com/LimeSurvey/LimeSurvey/blob/14b5f4b26ac79ec244117c5e599ec6d06c04294e/application/controllers/InstallerController.php#L206 If it's not set : it's not writable …
  5. dear Community, MuPDF :: pagination of the output is messed up: no linearity : 1235476 i ve got issues with Mutool and MuP running this on MX-Linux: I'm trying to work with the latest release of MuPDF library. if i a the document into pieces (A 5) then i get fancy results: the number of the pages (the pagination) does fulle get lost.. 1,4,3,2,5, and so forth btw: see the commands i run: mutool poster -x 2 input.pdf output.pdf states that the document should be divided into two parts in the X axis. The cutting axis is accordingly in the middle from top to bottom, so that two equal sides are created on the left and right. You can split a document into individual pages with pdftk pdftk input.pdf burst we can find the output files in the same directory as pg_0001.pdf, pg_0002.pdf etc what goes wrong here!? see the datset - https://www.file-upload.net/download-14207207/__0_100__20200413204027.pdf.html what is wanted: i want to cut this into A5 :: note: the A5-Formate is 148 mm width and 210 mm height i use the commands from these ressources: https://www.mankier.com/1/mupdf https://mupdf.com/docs/ any ideas? look forward to hear from you
  6. we want to use this cpu for a low-power-consumption server. you think that we should take a cheaper mainboard!?
  7. hello dear experts, cpu Intel Core i7 - 10700T, 8x2.000 GHZ Tray :: recomendations on a good z490 Mainboard cpu Intel Core i7 - 10700T, 8x2.000 GHZ Tray Intel’s 10th Gen consumer desktop processors are here, including the upper-mid-range Core i7-10700K. It comes with a new socket and chipset, the LGA 1200, and the Z490. whoever is on LGA 115X platform, is in luck, as all CPU cooler mounting hardware is already fully compatible. what if i am going to purchase the 10700K : can you suggest some of the best Z490 motherboards which addtitional advice do you have for the 10700K build,
  8. How dificult is .... it to socket a intel core i7 10700 8x2,00 GHz, tray socel 1200 LGA on a mainboard. see also here : https://www.alternate.de/Intel/Core-i7-10700-Prozessor/html/product/1612095
  9. hi there i am currently workin with the https://www.rapidee.com/en/environment-variables to digg all the things
  10. hello - i was able to add the system variable to the win environment. but i stuck with the work on the regedit!? can you advice here!?
  11. hello dear all, good day dear experts - good day dear Freaks first of all: i hope youre fine and all goes well at your site! i am using the wordpress_org page for interaction and idea exchange. so the thread of today is concerned about: XML or RSS-feed for plugin support on wordpress page: is there an API and a endpoint afaik the official Plugin support pages doesn’t provide any links for RSS feed. At least i did not find one link. i there a API or a endpoint that we can use here?! Can we add “feed” to the end of link to get RSS feed like this https://wordpress.org/support/plugin/connections/feed, is this possible!? If so this would be not bad. But wait: This feed displayed only first message for each topic. What is aimed: i wanna I get all messages from support? Because I need posibility to get answers via RSS. Well it would be a good thing to have a API for that, but if not there an access to the XML version of each thread would be interesting too: I guess that we can do it like so: by appending “feed” to the end of the URL. background: I need a fully fledged XML, but for all messages in support forum for one plugin. imagine: adding each thread to RSS feed is not convenient - it is a mess. I need just to see answer for all topic in my RSS feed, but I see only first message in topic. This is awful. If I need to watch answers for something like 50 plugins, then i run into a huge overload with this approach. Imagine this is done for 100 plugins. It certainly would be a whole mess. it would be hard work : ... open each plugin support page and check is there some answer, but this take a lot of time. any idea - how to solve this issue Regards,
  12. ... more insights: very interesting as mentioned above: it seems that the additional css in the customizer does not accept any changes. or - in other words: All i change here .- has absolutly no effect on the behavior of the site. this is very very interesting _ but i keep on working on the issues i will report and let you know all the findings. [media]https://imgur.com/leEDm8k[/media]
  13. first of all i will loook into all that. I will try to digg deeper. afaik -as far as i understand your postings then i should use another way of upload the images -not as a backgroud image. the interseting finding: the addtional css in the theme-customizer is not working - in other words. no change in the comands of the additonal css has any effect - it looks in some way like i have the very same behavior like the other authors ..here: https://stackoverflow.com/questions/14644138/custom-css-in-wordpress-not-working#comment20460334_14644138 Additional CSS not working? https://wordpress.org/support/topic/additional-css-not-working/ well this is my current additional css... .wrap { max-width: 1366px; } .wrap { max-width: 1366px; } @media screen and (min-width: 1168px) { .entry-header, .entry-content { float: left; } .entry-header { margin-right: 5%; width: 35%; } .entry-content { width: 85%; } } .search_keywords { font-size: 16px; font-family: serif; } .search_location { font-size: 16px; font-family: serif; } .search_category { font-size: 16px; font-family: serif; } .navigation-top .wrap { max-width: 96%; text-align: center;} .navigation-top [class*="menu-primary"] { text-align: center; display: inline-block;} /*For Content*/ .has-sidebar:no(.error404) #primary { width: 60% /*For Sidebar*/ .has-sidebar #secondary { width: 30% } /*Responsive*/ @media(max-width:768px) { /*For Content*/ .has-sidebar:(.error404) #primary { width: 100% } /*For Sidebar*/ .has-sidebar #secondary { width: 100% } } /* STRUCTURE */ .wrap { max-width: 80% !important; } .page.page-one-column:not(.twentyseventeen-front-page) #primary { max-width: 100% !important; } @media screen and (min-width: 48em) { .wrap { max-width: 80% !important; } } @media screen and (min-width: 30em) { .page-one-column .panel-content .wrap { max-width: 80% !important; } } @media screen and (max-width: 350px) { .wrap { max-width: 95% !important; } } @media screen and (min-width: 48em) { .background-fixed .panel-image { background-attachment: initial; } } .custom-header-media { height: 6vh; } @media screen and (min-width: 48em) { .panel-image { height: 460px; }} .postid-256 .single-featured-image-header img { /* display: block; */ /* margin: auto; */ height: 45vh; object-fit: cover; } .postid-258 .single-featured-image-header img { } @media screen and (min-width: 48em) { .postid-258 .panel-image-prop { padding: 12px; height:33px; object-fit: cover; }} @media screen and (min-width: 48em){ .background-fixed .panel-image {background-attachment: scroll !important;} .panel-image {height: auto !important; max-height: 800px; background-size: contain !important;} }
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.