Image Image Image Image Image
Scroll to Top

To Top

Mapping Solutions



In Mapping Solutions
Tips and Tricks

By Alvin Rentsch

How to add a map service for ArcGIS server

On 20, Jun 2013 | In Mapping Solutions, Tips and Tricks | By Alvin Rentsch

This tutorial does not discuss how to connect to a server. Please see our other content for that. Requirements for this are a ArcServer Connection and if you need to be able to edit your maps , all your data must be sourced in a SDE. Don’t forget to register your data store or you will copy all data to the server and waste space.

Tags | , , ,



In Mapping Solutions

By ColonC20

How to Georeference an Image in ArcMap

On 13, Jun 2013 | In Mapping Solutions | By ColonC20

1.) If you are using a print map, you will need to scan in to your compute and save it as a JPG. If you are using a PDF of a map you will need to save it as a JPG (you can simply screenshot or use the snipping tool and save it as a JPG).

2.) In ArcMap, make sure that the Georeferencing Toolbar is on. Customize>Toolbars> Georeferencing (Make sure that there is a check mark next to it).

3.) The Georeferencing Toolbar looks like this:

4.) Then, in ArcMap add the image that you want to georeference by clicking the Add Data button. After you select your image, click the Add button.

5.) Then, after you add your image, click the drop down arrow next to the Add Data button and click Add Basemap and choose one that will be most helpful to you.

6.) Then in the TOC, right click on the image you want to georeference and click Zoom To Layer.
7.) In the Georeferencing toolbar click the Add Control Points icon

8.) Then, find an intersection of roads on the image and click to place the Control Point there.

9.) Next, right click on the basemap in the TOC and click Zoom To Layer. Zoom to the location on the basemap where your image is actually located on the globe. Find the same intersection of roads that you added a control point on the image and add a control point to that same intersection on the basemap.

10.) The image will move to that location. Find two more intersections to add control points (spread them out across the image). If after having a total of 3 control points you feel your image still needs to be aligned, add more control points as necessary.

Tags | , , , , , , , , , ,



In Mapping Solutions

By Craig Nelson

Granting Dataset Privileges in ArcMap with PostgreSQL

On 05, Jun 2013 | In Mapping Solutions | By Craig Nelson

While deploying and configuring our newest geodatabase, I was tasked with setting up user login information for each employee on the PANGEA team, rather than simply sharing the superuser login. As someone who worked with creating users, setting up user groups, and granting access/edit/deletion privileges for databases in classes previously, I assumed the task would take a matter of minutes. I was wrong.

Initially, the project seemed to be running quite smoothly. By connecting to our database server via remote desktop, then running the PostgreSQL DBMS Admin client (pgAdmin III), I was able to quickly establish 3 separate user groups (User, Publisher, and Admin). From there, I simply created individual user logins, then added them to their respective groups. Through pgAdmin, I tested to make sure that all Admin users could create, edit, and delete new databases, that Publishers could create and edit, and that Users could only view, but not change, the database. So far, everything was working well.

The issues started once I began to work outside the database server. Through ArcMap, we needed to setup our new server with geodatabases, rather than normal, blank databases. To do so, the ArcMap client needed to access the database server, then upload several tables full of geographical referential data. However, each time we tried running the very simple tool within ArcMap, we’d end up with a connectivity error. After a few hours of troubleshooting these issues, including editing config files to enable ip access and tinkering with several server settings, we eventually discovered the problem through simple ping tests via the DOS command prompt. Our database server’s Windows Firewall hadn’t been configured to allow outside access. In just a few mouse clicks, we enabled access and were back on our way.

After successfully allowing access to our new database in ArcMap, we set up a new geodatabase to begin testing user privileges. However, it seemed that no matter how many privileges we granted both our groups and our users via pgAdmin, not a single account other than the original superuser was able to make any changes to the database due to ownership. We attempted to grant privileges on a group basis, a per-user basis, a per-database basis, and even a per-schema basis, and yet nothing seemed to make a difference within ArcMap. It wasn’t until we contacted the experts at ESRI that we found a solution to our issue.

Rather than granting privileges on a database level through the database server itself, we found that the key to setting up user privileges for ArcMap Geodatabases boiled down to two simple ideas: one, that each user needed their own version of the database schema and two, that privileges in ArcMap are granted on a per-dataset, rather than per-database basis. Now that we have this solution, we have been able to successfully build, deploy, and grant user privileges as planned to geodatabases on a new database server.


In short, the steps to granting dataset privileges for ArcMap geodatabases are as follows:

1) Create a new Login Role through your database server’s DBMS client

2) Grant basic database access privileges through DBMS client

3) Within your geodatabase, create a new schema with corresponding access privileges through DBMS client

4) In ArcMap, connect to your geodatabase via the your superuser (owner) account

5) Once connected, right-click on each dataset, navigate to manage, then privileges, where you can grant SELECT, ADD, EDIT, and/or DELETE privileges to each user.

Tags | , , , , , , , , ,



In Mapping Solutions
Tips and Tricks

By Lance Kohls

Tips and Tricks for Mapmaking using Javascript

On 23, May 2013 | In Mapping Solutions, Tips and Tricks | By Lance Kohls

The steps in order to enable only one check-box (out of 2 or more check-boxes) when the application starts:

1) Changed the checkbox checked property -> checked: (id == “25″) ? true : false

2) Added the line map.getLayer(“4″).hide();  in order to hide the layers whose check-boxes are not checked. -The line to be added goes after the “map.addLayers([list of the layers on the map]);”

-The line to be added goes before the “dojo.connect(map,’onLayersAddResult’,function(results){

//re-size the map when the browser re-sizes”


Removing the comma from a Flexviewer Applications:

1) In the popup.xml file edit the line of code that needs the comma removed:

“<field visible=”true” alias=”Zip Code” name=”zipcode”>

<format usethousandsseparator=”false”/>


Another Example:


“<field visible=”true” alias=”Year” name=”Year”>

<format usethousandsseparator=”false”/>


*If there are any extra spaces in the coding it may not work.



In Mapping Solutions
Tips and Tricks

By Lance Kohls

Enable layer toggleing using Javascript

On 09, May 2013 | In Mapping Solutions, Tips and Tricks | By Lance Kohls

Steps to making a layer in a legend turn on and off:

*IMPORTANT: anything that is labeled with an asterisk doesn’t get put into the coding.

1. In the script tag next to the other dojo.require(…)

Make sure to add:




2. In the var template inside the Function InIt(){


var template = new esri.InfoTemplate(“${business}”, “Address: ${address_1} <br/> City: ${city} <br/> State: ${state} <br/> Zip Code: ${zipcode} <br/> Website: <a target=’_blank’ href=${website_1}>${website_1}</a><br/> Type: ${type_1}”);

*IMPORTANT: The code above has to be on one line. It can not be entered in two or more lines because the enter will break the coding. You must use “br/” tags to be able to enter in more fields after the first comma is used. Anything before the first comma above will be the header to the popup and everything after it will be the attributes it brings in.

I also made the websites a hotlink within the popup for people viewing it to have an easy way to bring up the website.

var uniquename = new esri.layers.FeatureLayer(“″,
mode: esri.layers.FeatureLayer.MODE_ONDEMAND,
outFields: ["*"],
infoTemplate: template});


*IMPORTANT: If the uniquename in the case above is not the same in the three locations that are colored red then the layer will not show up on the map.

3. The coding below must be placed after the layers are added into the coding.


//Add the Legend
var legend = new esri.dijit.Legend({

*IMPORTANT: The layers you want entered into the legend will be placed inside the bracket of map.addLayers([]). If there is more than one layer that needs to be displayed then put commas after each uniquename.


//add check boxes
var layerName = layer.title;
var checkBox = new dijit.form.CheckBox({
name: “checkBox” +,
checked: layer.layer.visible,
onChange: function(evt) {
var clayer = map.getLayer(this.value);
this.checked = clayer.visible;

//add the check box and label to the toc,dojo.byId(“toggle”),”after”);
var checkLabel = dojo.create(‘label’,{‘for’, innerHTML:layerName},checkBox.domNode,”after”);“<br />”,checkLabel,”after”);

*IMPORTANT: Anything that follows the //add check box has to be typed exactly like what is being displayed because it is very sensitive coding and one error will cause the entire page to fail.

Enjoy javascripting!

Business Innovation through Mapping

On 25, Apr 2013 | In Business Intelligence, Interactive Mapping, Mapping Solutions | By Erin Olshefski

The Wisconsin Business Incubation Association (WBIA) specializes in supporting the success of small business start-ups in the region by managing and developing entrepreneurial companies and helping them to survive, grow, and become stable companies that create jobs and strengthen local economies.

A screen shot of the editor is seen here

Flex Editor


Tags | , , ,



In Mapping Solutions
Tips and Tricks

By Kyle Freeman

How to use the Rubber Sheeting tool in ArcMap

On 22, Apr 2013 | In Mapping Solutions, Tips and Tricks | By Kyle Freeman

I was in the process of deciding which way would be the best in manipulating several roads files all at once without losing the integrity of my remaining data. I came across the Rubber Sheeting tool within Arcmap’s spatial analysis tool box. It allowed me to move my desired roads into their correct locations while keeping the roads with the correct location in place. I hope these steps are of use to you in your future endeavors.

Easy steps to follow when editing points or lines in Arcmap:

1.) Open ArcMap

2.) Add your basemap and shapefiles that you want to edit

3.) Turn on Spatial analysis under ‘Extensions

4.) Begin an edit session

5.) Add your snapping toolbar and check ‘vertex snapping

6.) Add the Spatial Adjustment tool to the toolbar. Go to the ‘Spatial Adjustment‘ menu and click Set Adjust Data.

7.) Then it’s required to specify if you want to adjust a select set of features or all features. Click ‘All features in these layers‘. Then make sure only your desired layer to edit is checked.

8.) You’ll then need to open up the Spatial Adjustment menu again, navigate to ‘Adjustment Methods‘ and check ‘Rubbersheet

9.) If any additional options need to be set for Rubbersheet, then select ‘Options‘ from the Spatial Adjustment menu, click the general tab then Rubbersheet, this will allow you to see additional options

10.) Then Click options, Natural Neighbor then OK


What the roads look like before editing.


What the roads look like before editing.




This 'anchor tool' allows you to "lock" that point while still moving and manipulating other points and lines


Place the anchor on this intersection, since I want to keep this point constant. This ‘anchor tool’ allows you to “lock” that point while still moving and manipulating other points and lines.




The 'New displacement' tool allows you to shift to the desired location. It works in function with the anchor tool.


Using the Displacement tool, click on the line or intersection you want to move, then drag to the desired location. The ‘New displacement’ tool allows you to shift to the desired location. It works in function with the anchor tool.


After you placed your moves, click the 'Spatial Adjustment' menu then click adjust. This will shift your feature to the designated locations, as displayed in the picture above.



After you placed your moves, click the ‘Spatial Adjustment’ menu then click adjust. This will shift your feature to the designated locations, as displayed in the picture above.



Good Luck and happy mapping

Tags | , ,



In Mapping Solutions
Tips and Tricks

By Nick Lazarides

Adding Alleys to Your Roads File That do not Connect.

On 19, Apr 2013 | In Mapping Solutions, Tips and Tricks | By Nick Lazarides

The following are steps used to connect your existing roads data to collected alleys in order to create a fully route able network data set.

  • Load your road and alleys files into a new geodatabase, and create a new feature data set containing the roads and alleys feature classes.
  • Set up some attributes in both the roads and alleys files that will be useful in the future steps.
  • Create a new field in the attribute table of both of the roads and alleys files to distinguish them from one another. (You can assign a 1 to roads, and a -1 to alleys in that new field, or label one as roads and the other as alleys, etc.)





  • Use the Merge tool (data management tools–> general–> merge) and input the roads and alleys shapefiles as the inputs for the merge. Be sure to give the output a proper name save it to the correct folder you are using.




  • Add the new merged layer to the map document after the process is complete.


  • Use the same process as above to select all of the alleys from the merged dataset.


  • Use the Extend Line tool (Tools–> Editing Tools–> Extend Line) using your merged file with the alleys selected. You may choose to select an extend length that will only extend lines within that distance of another line, or chose not to enter one, in which case it will extend until it reaches another line no matter the distance. (Be sure to uncheck the extend to extensions box.)


Good luck and Happy Mapping

Tags | , ,



In Mapping Solutions
Tips and Tricks

By Lance Kohls

Creating a New Geodatabase on a SDE

On 17, Apr 2013 | In Mapping Solutions, Tips and Tricks | By Lance Kohls

During the process of creating  a new geodatabase on our server, I ran into some problems and had to figure some things out that weren’t stated anywhere on ArcGIS help.

A main Tips and Tricks I learned early in the process was that their website wasn’t 100% step by step, which meant I had to figure out what each step meant. The website below is where to find ESRI’s step by step guide to setting up a geodatabase in PostgreSQL.

Where to find the standard creation instructions:

ESRI SDE database creation

Lance’s Tips and Tricks

  1. When installing the geodatabase on an already created SDE then you have to go under the ArcGIS folder in the ArcSDE folder in the start menu and select ArcSDE for PostgreSQL Post Installation. They don’t tell you this until step 6 when it should be put at the beginning and say something like “If you already have PostgreSQL already installed please skip to step 6.
  2. Write down the step by step instructions you did to create your geodatabase because if you forget the superuser or any password you will lose everything on that geodatabase. Not because you forgot but you won’t be able to access it and edit it.

Okay now that should help, good luck an happy mapping

Tags | , , , ,



In Mapping Solutions
Spatial Analysis

By Erin Olshefski

MDPW: Analyzing Garbage District Routes and Cart Capacities

On 16, Apr 2013 | In Mapping Solutions, Spatial Analysis | By Erin Olshefski

GIS is intended to be utilized to provide solutions to spatial problems. Vehicle routing is a spatial problem, with garbage routing being a classic example. Recently, the studio undertook the project of assisting Milwaukee Department of Public Works in creating a network dataset to efficiently route their garbage trucks that service over 190,000 households. A project like this requires the consideration and coordination of many variables, most importantly the consideration of time, capacity, and efficiency.

My role was to analyze the current garbage pick-up routes by district, day of pick-up, truck capacity, and cart capacity. My initial findings showed that within each district there was not uniformity in routing by day, causing for inefficiencies in routing- creating the need for trucks to travel on the same streets multiple days of the work week.

Using Excel, I was able to break down the attribute data provided to us by MDPW and find trends. I found that the number of carts picked up per day, the pounds picked up per day, and the pounds per truck per day were not consistent despite the use of the same amount of trucks per day. I was then able to provide a recommendation of carts/day, pounds/day, and trucks/day.

We found that when conducting network analysis and creating a network dataset, it is important to analyze the system already in place to discover existing inefficiencies that should be corrected in order to produce an effective routing solution.

Tags | , ,