
Security News
Deno 2.2 Improves Dependency Management and Expands Node.js Compatibility
Deno 2.2 enhances Node.js compatibility, improves dependency management, adds OpenTelemetry support, and expands linting and task automation for developers.
Create maps using the Github Gist API as GeoJSON or TopoJSON, directly from PostGIS.
Create maps using the Github Gist API as GeoJSON or TopoJSON, directly from PostGIS.
dev-branch
.. image:: https://travis-ci.org/mattmakesmaps/pgsql2gist.png?branch=development
master
.. image:: https://travis-ci.org/mattmakesmaps/pgsql2gist.png?branch=master
Create a command line utility similar to pgsql2shp, but the output of which should be a link to an anonymous private gist. The gist link should leverage Github’s rendering of GeoJSON/TopoJSON, e.g. render a map.
See issues for additional features to be implemented.
Listed below is the --help usage information.::
POST GeoJSON or TopoJSON features from PostGIS to a Github Gist.
Example usage: pgsql2gist --host localhost --user matt tilestache \
"SELECT name, ST_AsGeoJSON(geom) AS geometry FROM neighborhoods LIMIT 5;"
Current SELECT Statement Requirements:
- Geometry must be in EPSG:4326 WGS84 coordinate system
- Geometry must be wrapped in ST_AsGeoJSON(), ST_AsTopoJSON()
usage: pgsql2gist [-f FILE] [-d DESCRIPTION] [-h HOST] [-p PORT] [-P PASSWORD]
[-u USER] [-g GEOM_COL] [-t TOPOLOGY_LAYER] [-v] [-?]
database SELECT
positional arguments:
database PostGIS database name.
SELECT SELECT Statement. NOTE: Geometry must be WGS84;
wrapped in ST_AsGeoJSON() or AsTopoJSON().
optional arguments:
-f FILE, --file FILE Filename. NOTE: Must end in 'geojson' or 'topojson'
extension. (default: upload.geojson)
-d DESCRIPTION, --description DESCRIPTION
Description of upload (default: File uploaded using
pgsql2gist.)
-h HOST, --host HOST PostGIS database hostname. (default: None)
-p PORT, --port PORT PostGIS database port. (default: 5432)
-P PASSWORD, --password PASSWORD
PostGIS user password. (default: None)
-u USER, --user USER PostGIS database user. (default: postgres)
-g GEOM_COL, --geom-col GEOM_COL
Geometry column name as defined in SELECT statement.
(default: geometry)
-t TOPOLOGY_LAYER, --topology-layer TOPOLOGY_LAYER
For TopoJSON Queries; Name of Topology Layer (default:
None)
-v, --verbose Verbose output. (default: False)
-?, --help
Gist API: (http://developer.github.com/v3/gists/)
The spiffy idea behind a db context manager comes from Migurski's awesome TileStache map server. http://tilestache.org
FAQs
Create maps using the Github Gist API as GeoJSON or TopoJSON, directly from PostGIS.
We found that pgsql2gist demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Deno 2.2 enhances Node.js compatibility, improves dependency management, adds OpenTelemetry support, and expands linting and task automation for developers.
Security News
React's CRA deprecation announcement sparked community criticism over framework recommendations, leading to quick updates acknowledging build tools like Vite as valid alternatives.
Security News
Ransomware payment rates hit an all-time low in 2024 as law enforcement crackdowns, stronger defenses, and shifting policies make attacks riskier and less profitable.