Skip to content

Instantly share code, notes, and snippets.

View gadomski's full-sized avatar

Pete Gadomski gadomski

206 followers · 182 following
View GitHub Profile
@gadomski
gadomski / window_detail.js
Created October 28, 2011 15:16
mapfish javascript
var map;
var drawLayer;
function doGeomGet() {
var in_options = {
"internalProjection": new OpenLayers.Projection("EPSG:4326"),
"externalProjection": new OpenLayers.Projection("EPSG:900913")
}
@gadomski
gadomski / nowhere.sql
Created November 6, 2011 21:52
strange sdo_anyinteract behavior
SELECT sdo_anyinteract(l.blk_extent, w.clip_geometry) lfirst, sdo_anyinteract(w.clip_geometry, l.blk_extent) wfirst
FROM lidar_block l, export_window w
--WHERE sdo_anyinteract(l.blk_extent, w.clip_geometry) = 'TRUE'
ORDER BY obj_id;
-- RESULTS: TRUE TRUE
@gadomski
gadomski / export.xml
Created November 9, 2011 18:04
an export pcpipeline
<?xml version="1.0"?>
<Pipeline version="1.0">
<Writer type="drivers.las.writer">
<Option name="compression">false</Option>
<Option name="filename">/tmp/gadomski.las</Option>
<Filter type="filters.inplacereprojection">
<Option name="scale_x">0.01</Option>
<Option name="offset_x">0.0</Option>
<Option name="offset_y">0.0</Option>
<Option name="offset_z">0.0</Option>
@gadomski
gadomski / backtrace
Created November 18, 2011 17:41
XML, backtrace, and option dump from a qfit load error
#0 0x0000003a11a30265 in raise () from /lib64/libc.so.6
#1 0x0000003a11a31d10 in abort () from /lib64/libc.so.6
#2 0x0000003a240bed14 in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib64/libstdc++.so.6
#3 0x0000003a240bce16 in ?? () from /usr/lib64/libstdc++.so.6
#4 0x0000003a240bce43 in std::terminate() () from /usr/lib64/libstdc++.so.6
#5 0x0000003a240bcf2a in __cxa_throw () from /usr/lib64/libstdc++.so.6
#6 0x00007ffff7d2f3e7 in pdal::Utils::check_stream_state<char, std::char_traits<char> > (
srtm=<value optimized out>) at /opt/pdal/src/../include/pdal/Utils.hpp:186
#7 0x00007ffff7d66c62 in pdal::drivers::qfit::Reader::Reader (this=0x641ac0,
options=<value optimized out>) at /opt/pdal/src/../include/pdal/Utils.hpp:117
@gadomski
gadomski / models.py
Created November 18, 2011 19:31
Custom SpatialRefSys
from django.db import models
from django.contrib.gis.models import SpatialRefSys as CsSrs
class Unit(models.Model):
"""An unmanaged model that tracks the oracle units table"""
sdo_unit = models.CharField(max_length=80, primary_key=True)
unit_name = models.CharField(max_length=2083)
conversion_factor = models.FloatField(blank=True, null=True)
@gadomski
gadomski / gist:1384089
Created November 21, 2011 21:59
django config
#
# EXAMPLE DJANGO CONFIGURATION
# ============================
#
# # Where the Django project is.
# CELERYD_CHDIR="/opt/Project/"
#
# # Name of the projects settings module.
# export DJANGO_SETTINGS_MODULE="settings"
#
@gadomski
gadomski / gist:1443910
Created December 7, 2011 18:12
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 7 10:12:35 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
@gadomski
gadomski / managers.py
Created December 8, 2011 18:03
SRS models for an oracle db
class UnitManager(models.Manager):
"""Model manager for units that removes any items with a null pk"""
def get_query_set(self):
return super(UnitManager, self).get_query_set().filter(pk__isnull=False)
@gadomski
gadomski / gist:1450266
Created December 9, 2011 05:06
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 8 21:06:37 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
@gadomski
gadomski / gist:1452494
Created December 9, 2011 17:29
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 9 09:29:18 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options