Skip to content

Instantly share code, notes, and snippets.

View kbatuigas's full-sized avatar

Kat Batuigas kbatuigas

View GitHub Profile
@kbatuigas
kbatuigas / dd_database.sql
Created October 5, 2020 20:36
DB schema SQL script exported from pgModeler
-- Database generated with pgModeler (PostgreSQL Database Modeler).
-- pgModeler version: 0.9.2
-- PostgreSQL version: 11.0
-- Project Site: pgmodeler.io
-- Model Author: ---
-- object: devuser | type: ROLE --
-- DROP ROLE IF EXISTS devuser;
CREATE ROLE devuser WITH
INHERIT
@kbatuigas
kbatuigas / ol-pdx-example.html
Created February 13, 2020 20:31
Example of Portland area web map displaying neighborhood boundaries and transit stops - OpenLayers, pg_tileserv, pg_featureserv
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Portland</title>
<!-- CSS for OpenLayers map -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/openlayers/openlayers.github.io@master/en/v6.2.0/css/ol.css" type="text/css">
<style>