Moore Spatial

GIS and Related Pursuits

By

Shaded Relief and Inset Maps

About: This map was created using a DEM and the Hillshade toolbox in ArcGis 10.1. The inset map reflects the extent of the large map. The roads layer ended up too light, but I like the colors.
Date: April 4, 2013
 
Shaded Relief Map With Inset

Shaded Relief Map With Inset

By

Create a Grid in PostGIS With Just SQL

About: PostGIS is a lot of fun. Here I generate a grid of 1x1km squares with just an SQL query.
Date: March 10, 2013
A generated grid viewed in QGis

A generated grid viewed in QGis

 

The SQL used was:

-- Create a grid with just a query and number the squares
-- The grid squares are in meters, so you'll need a projection that is in meters.
-- The 900913 projection used is fine. 
--
-- This query needs a couple of parameters
-- 
-- Starting point: st_point(0,0)
-- Total width of grid and width of each square: generate_series(0,4000,1000) (xstep)
-- Total height of grid and height of each square: generate_series(0,4000,1000) (ystep)
-- The height per square is used throughout the query (the scattered 1000s)
-- The number of squares is used in generating the numbering (The two 5s)

-- DROP TABLE grid;

CREATE TABLE grid AS

SELECT 
(ystep/1000 + 1) * 5 - 5 + xstep/1000 + 1 as key, -- number grids in order across the top first, then down

st_setsrid( 
    st_makebox2d(
        st_translate(topleft,xstep,ystep*-1), 
        st_translate(topleft,xstep + 1000,ystep*-1 - 1000)
    ), 
    900913
) as way 

FROM 
(
    SELECT 
    xstep,
    ystep,
    st_point(0,0) AS topleft -- Top left starting point
    FROM
    ( SELECT generate_series(0,4000,1000) as xstep) as xstepq,  -- series from 0 to 4000, with 1000 meter steps
    ( SELECT generate_series(0,4000,1000) as ystep) as ystepq
) AS factors ;

CREATE INDEX gridway
ON grid 
USING gist
(way);

ALTER TABLE grid ADD PRIMARY KEY (key);

By

Symbology and Maplex Labeling: Otter Tail County

About: We were given road, lake, river, city, township and other shapefiles and needed to present them all in a coherent manner using the Maplex labeling engine and appropriate symbology. 
Date: March 27, 2013
General Purpose Map of Otter Tail County

General Purpose Map of Otter Tail County

By

Labeling example in ArcMap

About: Map labeling project done in ArcMap 10.1 using the regular (non-Maplex) labeling engine. I also created the terrain shading from multiple layers.
Date: March 12, 2013
Map Labeling with ArcGIS 10.1

Map Labeling with ArcGIS 10.1

By

Simple Chloropleth World Map in ArcGIS

About: Simple chloropleth map of world life expectancy at birth for the year 2000. Made in ArcGIS 10.1
Date: February 19, 2013
Simple Chloropleth

Simple Chloropleth

By

Vector Overlays in ArcMap

About: Use multiple data sources to determine suitability for real estate development
Date: 12/10/2012
Suitability of neighborhoods near central park

Suitability of neighborhoods near central park

Read More

By

Economic Impact of Hurricane Frances

About: Use multiple types of symbology to represent different decision making factors.
Date: 12/10/2012
Hurricane Frances Analysis

Hurricane Frances Analysis

Read More

By

Georeferencing in ArcMap

About: I georeferenced an areal photo of Minneapolis with a vector layer depicting block groups
Date: 12/10/2012
Georeferencing an areal photo in ArcMap

Georeferencing an areal photo in ArcMap

Read More

By

Family Tree Mapper

About: I led a team of 7 students to make a Google Maps mashup of the user’s family tree and genealogical resources.
Date: April, 2008

Family Tree Mapper

Family Tree Mapper

Family History Centers

Family History Centers


Read More

By

Signs Database and ArcGIS Online

About: Myself and two partners collected nearly 300 photos, coordinates and metadata of signs and put them on ArcGIS Online. Date: 12/10/2012 Signs Database in ArcGIS Online
Read More