Tuning PostgreSQL First off, let's all make sure we are on the same page. I, Joel McCune, am by no stretch of the imagination, a database administrator. Still, I keep an instance of PostgreSQL running on my local work computer for use with ArcGIS, to create SDE databases. Recently discovered
Silently Install ArcGIS for Server In the last couple of days I have been trying to get a few configurations of ArcGIS for Server set up on Virtual Machines (VM's). Along the way I have spectacularly broken quite a few and had to restart the process. After the second time installing I looked
Expand VMWare Windows Virtual Machine Disk Size Recently, when attempting to install software on a VMWare virtual machine (VM), I needed to expand the disk to have enough space. Searching the net yeilded the answer in a VMWare Knowledge Base article [http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_
Change Windows 7 Login Background Many times the motivation for putting up posts on this blog is every bit as much for my own reference as yours. My theory is if I find it useful, you may as well. This post falls into this category. When logging into Windows, the generic background is boring and
ArcGIS Server CentOS Install Script With the release of ArcGIS 10.3, now CentOS [http://www.centos.org/] is officially supported as an operating system for ArcGIS for Server. This week I managed to successfully install and create a script for automating much of the process. Although admittedly a somewhat limited audience, if this sounds
Sort Streets by Name Using Python Update 13Oct2015: Webucator detailed and improved this solution. Take a look! [https://joelmccune.com/sort-streets-by-name-using-python-v2/]. North Davidson Street, Naramore Street and Davidson Street, if sorting street names, these streets should be together. However, if these street names are in a list and sorted alphabetically, North Davidson will be placed in
Get Layer Selected Feature Count Using Python Update 20 minuts after posting: I remembered the GetCount_management tool honors selections. Hence, if you use this tool, it does the same thing. This mostly means this post is an exercise in reinventing the wheel. Recently in a script I needed to get a count of selected features in
Getting Started with the ArcGIS iOS SDK If you want to edit spatial data in the field, one of the best things going is Collector for ArcGIS [http://www.esri.com/software/arcgis/collector-for-arcgis]. If you want to accomodate custom workflows however, right now the only way to facilitate this is to build the application from scratch
generator Web Mapping at the Northwest GIS Conference For many extremely competent GIS professionals, the prospect of creating web mapping applications is extremely intimidating. It really does not have to be. Taking advantage of a number of freely avaiable web development tools can greatly streamline the point of entry for experimenting, learning and building web applications. At 10:
arcpy Testing Regular Expressions Extracting pieces of text out of larger strings based on patterns, this is what regular expression matching facilitates. It really is great stuff...once you wrap your head around it. Most frequently I use regular expression matching in Python, trying to create categorized datasets by extracting values from long strings
ArcGIS for Desktop Recursively List Data Using arcpy.da.walk Although the ArcGIS Python package arcpy does include the capabilty to list a huge variety of data objects, if the data is contained in nested directories or feature datasets within the geodatabase, creating the nested listing loops to find all the resources can be annoying at best and infuriating at
Ghost blogging Don't worry. I am standing by for the flaming for the following statement. PHP needs to die. There are far superior solutions avaialable built on much more modern tehcnologies. One of the more prevelant examples is Node.js. My blog, what you are reading right now, is a
Getting Started with Grunt Gruntfile for Getting Started with Grunt Learning all this Node.js stuff (albeit very,very slowly) means a lot of run, cancel, restart and reload...in addition to all the other things Ishould be doing if learning best practices for web development. As with most things in life and especially development, somebody has already come up
Express 4.0 Express & Express CLI Generator Setup at 4.0 This whole Node.js and Express thing, I am pretty new to it. Once I figure out how to get it working, I am sure it is going to be positively outstanding. This part however, is proving to be somewhat difficult since Express recently updated to version 4.x recently.
Grunt Automatically Restart Node.js During Development Recently I have been attempting to learn at least a little bit about Node.js [http://nodejs.org/] development. It only took about 15 minutes before getting completely sick of hitting Ctrl+C, the arrow up key, and Enter to restart the simple Node.js application I am working on.
Esri Use Symbology from Point Feature Layer in Leaflet For simple web mapping, recently I have been experimenting with Leaflet [http://leafletjs.com/] and Esri-Leaflet [http://esri.github.io/esri-leaflet/] quite a bit. For simple and quick mapping, Leaflet using Esri-Leaflet to support Esri published services is a very viable solution. One difficulty I initially struggled with is getting
Esri Yeoman Generator for Bootstrap-Map-JS Getting started building web mapping applications can be a daunting task at best. In many cases, the recent emergence of generators has greatly lowered the point of entry when getting started with many web frameworks and API's. Unfortunately, when I first started working with the Bootstrap-Map-JS project templates,
Mac Sublime on Mac As I have begun to delve increasingly deeper into development, I am constantly reminded and well aware no matter much I am striving to learn more...I am still in the kiddie pool. Heck, I have not even so much as stumbled into the shallow end and been rescued by
JavaScript Kayaking and Coding, they are similar Yes, I am talking about whitewater kayaking and code slinging. Yes, they are quite similar. What is Joel talking about you say? As both a rookie kayaker and a rookie code slinger, you spend most of your time frustrated, hating life and wondering how the experts make it look so
Esri Esri Southeast User Conference - Python Presentations 07 May 2014 Update: The code created in both presentations has been included in the embedded referenced GISTs. This coming week the annual Esri Southeast User Conference (SEUC) is being held at the Charlotte Convention Center in (no kidding) Charlotte, NC. I will be presenting two presentations on Python. Since
Photography Portfolio Although in the past I have included posts directly in the blog for photo sets, most of my photo work to be highlighted on the web is available on a photo sharing service, 500px. On the main menu of my blog, you should notice a Photography Portfolio button leading to
ArcGIS Cleanse Feature Class Names in Python Today I ran across a problem with what should be a simple solution, but took me the better part of the morning to figure out...primarily because I was not familiar enough with regular expression matching. ArcGIS is pretty picky about feature class names, whether a feature class in a
Leaflet Esri-Leaflet, Lightweight Open Source Esri Web Map Control Recently I stumbled across a blog posting detailing recent open source JavaScript projects Esri has been working on. [http://blogs.esri.com/esri/arcgis/2013/07/31/new-esri-open-source-javascript-projects-leaflet-geoservices-js-terraformer-pushlet/] Although all of the projects are interesting in their own right, the one really catching my attention is the Esri-Leaflet [https://github.
CodeSchool CodeSchool JavaScript Road Trip Ask my mother. She will be the first to tell you. I am stubborn. A few years back she told me, "We raised you to be independent, but you really took the concept and ran with it." My mother has a lot more tact than I do. On
Installing GeoDjango on Ubuntu 12.04 Although not very good at it, I have been toying with what I can do with Django. Right now it admittedly is not much. It is rather pathetic, really. Still, being a GIS guy, when stumbling across GeoDjango [https://docs.djangoproject.com/en/dev/ref/contrib/gis/], I was curious.
