Skip to content

Instantly share code, notes, and snippets.

View talllguy's full-sized avatar
🎯
Focusing

Elliott Plack talllguy

🎯
Focusing
50 followers · 86 following
View GitHub Profile
@talllguy
talllguy / OwnerID_Codes.md
Created June 27, 2014 14:51
Maryland Owner ID Codes for Baltimore County

Baltimore County Codes 01 – Administration (County complex, Multi-purpose Facilities, Parking lots

04 – Drainage and Utility Reservation, Bridge Area, Re-Channelization; Storm Water Management; Flood Control Strips (DPW)

05 – Highway (DPW)

08 – Land Fills (DPW)

@talllguy
talllguy / osm-baco-building-workflow.md
Created June 30, 2014 15:37
Workflow for Baltimore County building import

OSM Buildings import for Baltimore County

Conditions

  • ArcMap 10.2
  • Address data
  • Building data

Workflow

@talllguy
talllguy / baco-osm-import-thoughts-day0.md
Last active August 29, 2015 14:03

OSM Baltimore County Buildings Import

Thoughts:

  • many field calcs to concatenate addresses and streets
  • title case!
  • need to figure out how to expand abbr.
  • three separate imports
  • merged buildings

  • separate buildings
  • separate addresses
@talllguy
talllguy / closures.json
Last active August 29, 2015 14:04
Sample of Baltimore County Road Closure data. Full site at http://egov.baltimorecountymd.gov/roadclosures/
{
"displayFieldName": "FIRST_STLABEL",
"fieldAliases": {
"OBJECTID": "OBJECTID",
"CLOSURE_ID": "CLOSURE_ID",
"FIRST_STLABEL": "STLABEL",
"FIRST_INTERSECTIONLIST": "IntersectionList",
"FIRST_ROAD_CLOSURE_DATE": "ROAD_CLOSURE_DATE",
"FIRST_ROAD_EST_OPEN_DATE": "ROAD_EST_OPEN_DATE",
"FIRST_CLOSURE_TYPE": "CLOSURE_TYPE",
@talllguy
talllguy / create_osm_view_pubsafe.sql
Created August 8, 2014 20:19
parallel of https://github.com/baltimorecounty/openstreetmap/blob/master/create_osm_view_pubsafe.sql
DROP VIEW VW_ADDRESS_OSM;
DROP MATERIALIZED VIEW VW_ADDRESS_OSM;
CREATE MATERIALIZED VIEW VW_ADDRESS_OSM
AS
SELECT
ADP.SHAPE,
AD.OBJECTID,
TRIM(CONCAT(AD.ST_NUMBER || ' ',(TRIM(AD.ST_NUMSUFFIX)))) as ADDR_HOUSENUMBER,
TRIM(
CONCAT(
@talllguy
talllguy / TimelineRawData-20140821T093037.json
Created August 21, 2014 13:39
iD #2151 Bug timeline
This file has been truncated, but you can view the full file.
["5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36",
{"type":"Program","data":{},"startTime":90103731,"children":[],"endTime":90103731},
{"type":"BeginFrame","data":{},"startTime":90104295.559,"thread":"5404"},
{"type":"Program","data":{},"startTime":90103746,"children":[],"endTime":90103746},
{"type":"RequestMainThreadFrame","data":{},"startTime":90104309.07699999,"thread":"5404"},
{"type":"ActivateLayerTree","data":{"id":3374},"startTime":90104311.05499999,"thread":"5404"},
{"type":"Program","data":{},"startTime":90103759,"children":[{"type":"BeginFrame","data":{"id":3374},"startTime":90103759},{"type":"UpdateCounters","data":{"documents":6,"nodes":6663,"jsEventListeners":2636,"jsHeapSizeUsed":50937204},"startTime":90103759},{"type":"ScheduleStyleRecalculation","data":{},"startTime":90103759,"frameId":"3360.1"},{"type":"UpdateCounters","data":{"documents":6,"nodes":6663,"jsEventListeners":2636,"jsHeapSizeUsed":50937204},"startTime":90103759},{"type":"Reca
@talllguy
talllguy / CPU-20140821T092534.cpuprofile
Created August 21, 2014 13:42
CPU Profile iD Bug #2151
This file has been truncated, but you can view the full file.
{"head":{"functionName":"(root)","scriptId":"0","url":"","lineNumber":0,"columnNumber":0,"hitCount":0,"callUID":3554729892,"children":[{"functionName":"(program)","scriptId":"0","url":"","lineNumber":0,"columnNumber":0,"hitCount":3393,"callUID":1298304791,"children":[],"deoptReason":"","id":2},{"functionName":"(idle)","scriptId":"0","url":"","lineNumber":0,"columnNumber":0,"hitCount":25369,"callUID":2132994222,"children":[],"deoptReason":"","id":3},{"functionName":"(anonymous function)","scriptId":"603","url":"http://www.openstreetmap.org/assets/iD-a8ed6f71ddc719370a00c3fb3b18e4b8.js","lineNumber":1,"columnNumber":7420,"hitCount":10,"callUID":3084228093,"children":[{"functionName":"u","scriptId":"603","url":"http://www.openstreetmap.org/assets/iD-a8ed6f71ddc719370a00c3fb3b18e4b8.js","lineNumber":7,"columnNumber":15049,"hitCount":0,"callUID":1216987851,"children":[{"functionName":"o","scriptId":"603","url":"http://www.openstreetmap.org/assets/iD-a8ed6f71ddc719370a00c3fb3b18e4b8.js","lineNumber":7,"columnNumber
@talllguy
talllguy / overpass-baltimore-co
Last active August 29, 2015 14:05
Baltimore County Overpass Query
<osm-script output="json" timeout="900" element-limit="1073741824">
<id-query {{nominatimArea:Baltimore County}} into="area"/>
<!-- gather results -->
<union>
<!-- query part for: “amenity=school” -->
<query type="node">
<has-kv k="amenity" v="school"/>
<area-query from="area"/>
</query>
<query type="way">
@talllguy
talllguy / hess.geojson
Created September 3, 2014 13:14
Chris Whong's Hess Triangle. ref http://chriswhong.com/open-data/in-search-of-hess-triangle-part-1/
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@talllguy
talllguy / baco-hydroLine.py
Last active January 9, 2017 17:45
hydrology line ogr2osm translation
'''
Baltimore County Translate
'''
def filterTags(attrs):
if not attrs:
return
tags = {}
# Changing tag caps