ns-1m’s gists

ns-1m / postgistogeojson.js

Created April 4, 2012 13:44 — forked from samgiles/postgistogeojson.js

A function that converts a PostGIS query into a GeoJSON object.

	/*
	* A function that converts a PostGIS query into a GeoJSON object.
	* Copyright (C) 2012 Samuel Giles <[email protected]>
	*
	* This program is free software: you can redistribute it and/or modify
	* it under the terms of the GNU General Public License as published by
	* the Free Software Foundation, either version 3 of the License, or
	* (at your option) any later version.
	*
	* This program is distributed in the hope that it will be useful,

ns-1m / getfeature.php

Created April 4, 2012 01:06 — forked from pbabik/getfeature.php

PHP PostGIS to GeoJSON - with BBOX query

	<?php
	/**
	* PostGIS to GeoJSON
	* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $bbox Bounding box of request REQUIRED
	* @param string $geotable The PostGIS layer name REQUIRED
	* @param string $geomfield The PostGIS geometry field REQUIRED
	* @param string $srid The SRID of the returned GeoJSON OPTIONAL (If omitted, EPSG: 4326 will be used)
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned) NOTE- Uppercase field names should be wrapped in double quotes

ns-1m / postgis_geojson.php

Created April 3, 2012 22:54 — forked from bmcbride/postgis_geojson.php

PHP PostGIS to GeoJSON

	<?php
	/**
	* PostGIS to GeoJSON
	* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $geotable The PostGIS layer name REQUIRED
	* @param string $geomfield The PostGIS geometry field REQUIRED
	* @param string $srid The SRID of the returned GeoJSON OPTIONAL (If omitted, EPSG: 4326 will be used)
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned) NOTE- Uppercase field names should be wrapped in double quotes
	* @param string $parameters SQL WHERE clause parameters OPTIONAL

ns-1m / sqlite_geojson.php

Created April 3, 2012 02:56 — forked from bmcbride/sqlite_geojson.php

PHP SQLite to GeoJSON

	<?php
	/**
	* SQLite to GeoJSON (Requires https://github.com/phayes/geoPHP)
	* Query a SQLite table or view (with a WKB GEOMETRY field) and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $geotable The SQLite table name REQUIRED
	* @param string $geomfield The WKB GEOMETRY field REQUIRED
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned)
	* @param string $parameters SQL WHERE clause parameters OPTIONAL
	* @param string $orderby SQL ORDER BY constraint OPTIONAL

	<?php
	/**
	* PostGIS to GeoJSON
	* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $bbox Bounding box of request REQUIRED
	* @param string $geotable The PostGIS layer name REQUIRED
	* @param string $geomfield The PostGIS geometry field REQUIRED
	* @param string $srid The SRID of the returned GeoJSON OPTIONAL (If omitted, EPSG: 4326 will be used)
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned) NOTE- Uppercase field names should be wrapped in double quotes

	<?php
	/**
	* PostGIS to GeoJSON
	* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $geotable The PostGIS layer name REQUIRED
	* @param string $geomfield The PostGIS geometry field REQUIRED
	* @param string $srid The SRID of the returned GeoJSON OPTIONAL (If omitted, EPSG: 4326 will be used)
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned) NOTE- Uppercase field names should be wrapped in double quotes
	* @param string $parameters SQL WHERE clause parameters OPTIONAL

	<?php
	/**
	* SQLite to GeoJSON (Requires https://github.com/phayes/geoPHP)
	* Query a SQLite table or view (with a WKB GEOMETRY field) and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $geotable The SQLite table name REQUIRED
	* @param string $geomfield The WKB GEOMETRY field REQUIRED
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned)
	* @param string $parameters SQL WHERE clause parameters OPTIONAL
	* @param string $orderby SQL ORDER BY constraint OPTIONAL

Noli Sicad ns-1m