YouTube

MySQL Lecture Video

Web-GIS Stack

 

Django Installation/Intro

Comments

Post a Comment

Feel free to ask, suggest and comment regarding this post/blog. You can also contact me through e-mail, just always use the contact page. Thank you for visiting this blog.

Popular posts from this blog

Publish PostGIS Layers in GeoServer Automatically using cURL and REST

Disclaimer: The idea came from this blog . So, what's the difference? I'm using Windows.  cURL should be installed already. If you have lots of tables in your database that you wanted to publish in GeoServer, you can use this method. Just prepare a list of tables (separated by new line) you want to publish in a text file format. Before proceeding in publishing layers, you need to setup a workspace and store in your GeoServer first. Although this can be done using cURL and REST API, but it is more convenient in that way. After a minute.... :D :D Create ".bat" file Use the code below but (of course) change the necessary inputs for /f %%a in ( <list of tables you want to publish> .txt) do  curl -v -u <username> : <password>   -XPOST -H "Content-type: text/xml" -d "<featureType><name>%%a</name></featureType>" http://localhost:8080/geoserver/rest/workspaces/ <name of workspace> /datastores/...
Read more

How to download all images from a link?

Image
So, you want to download an image or photo from a certain link or website. That will be easy, a simple right click then save as image will do. But how about if there are lot of images that you want to save? It will be give you more time to do it and for a lazy person like me I want to share this simple software that will help and save your time instead. *drum roll please* You need to download this "2.5 MB" software, NeoDownloader Lite. I'm sure you'll be able to download it in just a few seconds. Install it after. . . . . After installing..you'll be able to see its GUI. Of course, without those scratches.hehe
Read more

Export Data from QuerySet as Excel File in Django

Post a Comment
Let's say you have this function in your views.py: def funtion_name(request): if request.method == "GET": get_id = request.user.id ... ... ... args = [] kwargs = { 'landproperty__sownerid__id': get_id, 'geom__distance_lte': (pnt, D(km=kmdistance)), 'narea__lte': getarea } mm = YourModelHere.objects.filter(*args, **kwargs).values_list('fielname1', 'fielname2', 'fielname3','fielname4') request.session[0] = mm return HttpResponse(json.dumps(list(m)), content_type='application/json') In order to get or pass the QuerySet from this function, you need to store it in a session as shown above. Here's how to create an excel file: def create_excel(request): book = xlwt.Workbook(encoding='utf8') sheet = book.add_sheet('untitled') default_style = xlwt.Style.defa...
Read more