ns-1m

<?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*

ns-1m

<?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

<?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

/* 
 *   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

/* 
 * Portions of this code and logic copied from OpenLayers and
 * redistributed under the original Clear BSD license terms:
 * 
 * http://trac.osgeo.org/openlayers/browser/license.txt
 *
 * Copyright 2005-2010 OpenLayers Contributors, released under 
 * the Clear BSD license. See authors.txt for a list of contributors.
 * All rights reserved.
 *

ns-1m

config.json:

{
  "database": {
    "connection": "pg://postgres:[email protected]:5432/test"
  },
  "web": {
    "port": 8000
  }
}

ns-1m

/*!
 * Convert <select> elements to Dropdown Group
 *
 * Author: John Rocela 2012 <[email protected]>
 * Update: Fixed issue with selected showing value instead of text Colin Faulkingham <[email protected]> 2012
 */
jQuery(function($){
    $('select').each(function(i, e){
        if (!($(e).data('convert') == 'no')) {
            $(e).hide().wrap('<div class="btn-group" id="select-group-' + i + '" />');

ns-1m

class MyGeoResource(Resource):
    def apply_sorting(self, objects, options=None):
        if options and "longitude" in options and "latitude" in options:
            return objects.distance(Point(options['latitude'], options['longitude'])).order_by('distance')

        return super(MyGeoResource, self).apply_sorting(objects, options)

ns-1m

{
     "title":"Food",
     "articles":
     [
        {
            "url":"http://oursocialbloggingsite.com/api/articles/111",
            "title":"Why Food Is Delicious",
            "author":"Abe Adams"
        },
        {

ns-1m

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>DVTConsoleDebuggerInputTextColor</key>
	<string>0 0 0 1</string>
	<key>DVTConsoleDebuggerInputTextFont</key>
	<string>Menlo-Bold - 11.0</string>
	<key>DVTConsoleDebuggerOutputTextColor</key>
	<string>0 0 0 1</string>