Pirmin Kalberer pka

## point.rs
fn write_file() {
    let mut file = File::create("test_point.fgb").expect("failed to write point");
    let points = [[1.0, 1.0], [2.0, 2.0]];

    const MAGIC_BYTES: [u8; 8] = [b'f', b'g', b'b', 3, b'f', b'g', b'b', 0];
    let _ = file.write(&MAGIC_BYTES);

    let mut fbb = flatbuffers::FlatBufferBuilder::new();
    let column_args = ColumnArgs {
        name: Some(fbb.create_string("STATE_FIPS")),

## decode_flask_cookie.rs
use flate2::read::ZlibDecoder;
use ring::hmac;
use std::convert::TryInto;
use std::io::Read;
use std::time::{Duration, SystemTime};

fn decode_flask_cookie(
    cookie: &str,
    secret: &str,
    salt: &str,

## filter_actors.rs
extern crate actix;
extern crate futures;

use actix::dev::{MessageResponse, ResponseChannel};
use actix::*;
use futures::{future, Future};
use std::env;

// Message and Response data type
#[derive(Debug)]

## gpkg-extensions.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                pka
                / gpkg-extensions.md
            
            
              Last active
              July 8, 2017 20:04
            
              
                Useful Geopackage extensions
              
          
Non-Linear Geometry Types
http://www.geopackage.org/spec/#extension_geometry_types
Aspatial data - Tables/views without a geometry column
http://www.gdal.org/geopackage_aspatial.html
Point cloud data
http://www.slideshare.net/mpgx/geo-package-pointclouds
Feature Tile Link and Geometry Index (NGA)
http://ngageoint.github.io/GeoPackage/docs/extensions/
Tiled Gridded Elevation Data Extension (Draft)
https://github.com/opengeospatial/geopackage-elevation/blob/master/spec/index.adoc


## quickfinder.sql
CREATE MATERIALIZED VIEW av.adressen AS
    SELECT hau.pk, lok.r1_text || COALESCE(' ' || hau.r1_hausnum, '') AS adresse, hau.wkb_geometry
      FROM av.ge_hausnummerpos hau
        JOIN av.ge_lokalisationsnamepos lok ON lok.r1_benannt=hau.r1_gebaeud;

CREATE INDEX adressen_trgm_idx ON av.adressen USING gin (adresse gin_trgm_ops);

SELECT adresse,ST_AsBinary(wkb_geometry)::geometry
  FROM av.adressen
  WHERE similarity(adresse, %(search)s) > 0.2

## index.html
<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <link rel="stylesheet" href="http://dev.openlayers.org/releases/OpenLayers-2.12/theme/default/style.css" type="text/css">
    <link rel="stylesheet" href="http://dev.openlayers.org/releases/OpenLayers-2.12/examples/style.css" type="text/css">
    <script src="http://dev.openlayers.org/releases/OpenLayers-2.12/OpenLayers.light.js"></script>
    <script type="text/javascript">

## x.js
// generated by create search command
CmdUtils.makeSearchCommand({
  name: "rails",
  url: "http://apidock.com/rails/search?query={QUERY}",
  icon: "http://apidock.com/images/favicon.ico",
  parser: {
    container: "#main_body > .result",
    title: ".result_title > h3 > a",
    maxResults: 10,
  },
	fn write_file() {
	let mut file = File::create("test_point.fgb").expect("failed to write point");
	let points = [[1.0, 1.0], [2.0, 2.0]];

	const MAGIC_BYTES: [u8; 8] = [b'f', b'g', b'b', 3, b'f', b'g', b'b', 0];
	let _ = file.write(&MAGIC_BYTES);

	let mut fbb = flatbuffers::FlatBufferBuilder::new();
	let column_args = ColumnArgs {
	name: Some(fbb.create_string("STATE_FIPS")),
	use flate2::read::ZlibDecoder;
	use ring::hmac;
	use std::convert::TryInto;
	use std::io::Read;
	use std::time::{Duration, SystemTime};

	fn decode_flask_cookie(
	cookie: &str,
	secret: &str,
	salt: &str,
	extern crate actix;
	extern crate futures;

	use actix::dev::{MessageResponse, ResponseChannel};
	use actix::*;
	use futures::{future, Future};
	use std::env;

	// Message and Response data type
	#[derive(Debug)]
	CREATE MATERIALIZED VIEW av.adressen AS
	SELECT hau.pk, lok.r1_text \|\| COALESCE(' ' \|\| hau.r1_hausnum, '') AS adresse, hau.wkb_geometry
	FROM av.ge_hausnummerpos hau
	JOIN av.ge_lokalisationsnamepos lok ON lok.r1_benannt=hau.r1_gebaeud;

	CREATE INDEX adressen_trgm_idx ON av.adressen USING gin (adresse gin_trgm_ops);

	SELECT adresse,ST_AsBinary(wkb_geometry)::geometry
	FROM av.adressen
	WHERE similarity(adresse, %(search)s) > 0.2
	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
	<meta name="apple-mobile-web-app-capable" content="yes">
	<link rel="stylesheet" href="http://dev.openlayers.org/releases/OpenLayers-2.12/theme/default/style.css" type="text/css">
	<link rel="stylesheet" href="http://dev.openlayers.org/releases/OpenLayers-2.12/examples/style.css" type="text/css">
	<script src="http://dev.openlayers.org/releases/OpenLayers-2.12/OpenLayers.light.js"></script>
	<script type="text/javascript">
	// generated by create search command
	CmdUtils.makeSearchCommand({
	name: "rails",
	url: "http://apidock.com/rails/search?query={QUERY}",
	icon: "http://apidock.com/images/favicon.ico",
	parser: {
	container: "#main_body > .result",
	title: ".result_title > h3 > a",
	maxResults: 10,
	},