Skip to content

Instantly share code, notes, and snippets.

View lucasnad27's full-sized avatar

Lucas Culbertson lucasnad27

View GitHub Profile
@lucasnad27
lucasnad27 / Inlets.js
Last active December 15, 2015 04:19
Blog post for marionette.js with ESRI mapping API
RPAT.module('Inlets', function(Inlets, App, Backbone, Marionette, $, _) {
// Inlet Model
// -----------
Inlets.Inlet = Backbone.Model.extend({
idAttribute: "OBJECTID",
defaults: {
@lucasnad27
lucasnad27 / generate_lines.py
Created March 15, 2013 13:50
Genealogy Line Work
import urllib2
import urllib
base_url = 'http://lucasnad27.cartodb.com/api/v2/sql'
api_key = 'none of your business'
delete_sql = urllib.quote('delete from CONNECTORS')
insert_sql = urllib.quote('Insert into connectors (the_geom,person_id) select ST_MakeLine(points), c.person_id from (select n.the_geom as points, n.person_id from nodes as n order by start_date) c group by c.person_id')
req = urllib2.Request('%s/?q=%s&api_key=%s' % (base_url, delete_sql, api_key))
response = urllib2.urlopen(req)
@lucasnad27
lucasnad27 / line_generation.py
Last active December 11, 2015 18:39
Create genealogical lines from nodes
import urllib2
import urllib
base_url = 'http://lucasnad27.cartodb.com/api/v2/sql'
api_key = 'none of your business'
delete_sql = urllib.quote('delete from CONNECTORS')
insert_sql = urllib.quote('Insert into connectors (the_geom,person_id) select ST_MakeLine(points), c.person_id from (select n.the_geom as points, n.person_id from nodes as n order by start_date) c group by c.person_id')
req = urllib2.Request('%s/?q=%s&api_key=%s' % (base_url, delete_sql, api_key))
response = urllib2.urlopen(req)
@lucasnad27
lucasnad27 / SDSFIE 3.0 Create Table
Last active December 10, 2015 20:18
SublimeSnippet
<snippet>
<content><![CDATA[
CREATE TABLE GCWGS84_VECTOR.${1:FeatureClassName}
(
${1:FeatureClassName}IDPK NVARCHAR2(20),
SDSID NVARCHAR2(20),
SDSFEATURENAME NVARCHAR2(80),
SDSFEATUREDESCRIPTION NCLOB,
SDSMETADATAID NVARCHAR2(80),
MEDIAIDFK NVARCHAR2(20),