Naïve GIS

Such a simple and naive GIS platform.

Fuck those slow, complicated and "user-friendly" GIS software. I just want to show some points on the map.

This program doesn't support WKT/WKB and other formats (now).

Usage

usage: main.py [-h] [-l LISTEN] [-p PORT] [-s SERVER] [-w]
               [-t {sqlite3,pg,mssql,csv}] [-m MAXROW] [-c CONFIG]
               connection [connection ...]

Such a simple and naive GIS platform.

positional arguments:
  connection            database connection parameter(s)

optional arguments:
  -h, --help            show this help message and exit
  -l LISTEN, --listen LISTEN
                        http server listen IP
  -p PORT, --port PORT  http server port
  -s SERVER, --server SERVER
                        bottle http server backend
  -w, --writeable       disable read-only database connection (mssql doesn't
                        support read-only)
  -t {sqlite3,pg,mssql,csv}, --type {sqlite3,pg,mssql,csv}
                        database type
  -m MAXROW, --maxrow MAXROW
                        max row number
  -c CONFIG, --config CONFIG
                        other database parameters, format: 'a=b:c=d'.
                        Integers, 'true', 'false' are recognized.

• sqlite3: connection is the filename. Has options: cache_size, defaults to -100000; spatialite to specify the path of SpatiaLite extension library and load it. Other -c options see here.
• pg: Needs psycopg2 library. connection is the connection string. Other -c options see the docs mentioned before.
• mssql: Needs pymssql library. connection is (server, user, password, database) four arguments. Doesn't support read-only connection. Other -c options see here.
• csv: connection is the file name. The csv file is read into an in-memory SQLite database, where the table name is csv. -w means writeable to this memory database. Has options: header, to specify whether the csv file has a header; spatialite to specify the path of SpatiaLite extension library and load it. If there is no header, the column names will be c1, c2, etc. Other -c options see here.

In the web interface, type in your SQL query. Columns named lat, lon specifies the location. For the EPSG:3857 coordinate system, they should be x and y. Or you can use a PostgreSQL POINT type column coords. An optional z column is used for heatmap. There are other optional columns to change display: color (element color), title (marker title), alt (marker alt), text (marker popup text), weight (polyline/polygon stroke width), opacity (point fill opacity, polyline/polygon stroke opacity), radius (point, heatmap), blur (heatmap), minOpacity (heatmap), maxz (maximum point intensity z in heatmap ).

If using polyline/polygon types, input a "Group by" condition to separate different lines/polygons.

Then, set element color (except for heatmap) and element type. The "Coords" sets which kind of coordinates that the data uses. If "Reset" is checked, the canvas will be reset on next query. Every query results add up until reset.

from https://github.com/gumblex/naivegis