Frequently Asked Questions (FAQs)

Home

GIS Research in Longwood Medical Area

GIS at Harvard University

FAQs

Sources of spatial data

Scripts

Spatial Statistics

Links

How do I get started using GIS at Harvard School of Public Health?

Harvard University has a site license for ESRI software. Click on the above link to the site license information and follow the directions for downloading and installing the software and connecting to the license server. Countway Library covers the cost of the site license for the Longwood Medical Area faculties. Harvard faculty, students and staff can run ESRI software on Harvard network computers at no charge. If you have the space on your computer I recommend installing the ArcGIS 8.3 Workstation version (ARC/INFO). Since the interface for the workstation and desktop versions are the same and there is no additional cost under the site license, you might as well get the additional tools available with the workstation version in case you need them later.

Make sure you also download the books and maps, and take a look at some of the books for tips on how to get started. (For example "Getting Started with ArcMap"). The tutorial data you can download during the installation is designed to be used with the books.

Refer to the site license web page link to Tech Support, Training and Hard Copy Documentation for information about free access to the ESRI Virtual Campus for online training. The ArcGIS online help is actually pretty useful and the ESRI web site knowledge base is extremely helpful.

What happens if the Harvard ESRI license server goes down while I am running ArcGIS?
Here's a tip Bonnie Burns from the Harvard Map Library posted to the Harvard GIS Users ABCD Group:
> There is a bug in ArcGIS 8.3 (shocking!). Anyway, this
> particular beastie will keep the desktop administrator
> from opening if the license server it points to is down.
> I got a message that esri-lm was down, tried to change
> to mercator, and my Desktop admin didn't start. And I got
> crabby. Then I got over it. The solution is listed here:
> http://support.esri.com/index.cfm
> Article Number: 24775 (You will need to log on to the ESRI site, but it is free)

Where do I find data?

There are numerous sources of free data available through the internet. It is also possible to purchase data from various vendors. I have found government agencies to be very willing to provide data to academic researchers at no cost, although it sometimes takes some detective work to find the right person with access to the data you want.

In Massachusetts MassGIS is a tremendous resource. ESRI's Geography Network is a good place to start looking for data from around the world. Check out the Harvard Geospatial Library for electronic data available at the university. For additional sources of data refer to Links.

How do I get longitudes and latitudes (or other x and y coordinates) from a spatial dataset?

Frequently researchers want to know the coordinates of geocoded points in order to analyze the data with a statistical model. To get the coordinates in the coordinate system of the dataframe (map) in use:
-Open the attribute table
-Add two new fields for x-coordinate and y-coordinate. I usually use double for the field type
-Go to the Editor toolbar and start editing the point layer. You may need to go to View, Toolbars in order to see the Editor toolbar.
-Right click on the new x-coordinate field and choose Calculate Values
-Load the script xcoord.cal and click on OK
-Repeat for the y-coordinate field, changing the x's to y's in the xcoord.cal script.
-Save your edits and stop editing
-You can export the attribute table, or if you are working with shapefiles, the .dbf file will now contain the coordinates.

How do I find the centroid of a polygon?

The coordinates of the centroid or center of mass of a polygon can be calculated using the following free scripts from ET Spatial Techniques with the field calculator (described above for longitudes and latitudes). polygon_Get_X_Center
polygon_Get_Y_Center

Where can I find code that can be used with the Field Calculator?

ET Spatial Techniques offers many great .cal files that can be used with the ArcGIS field calculator. Go to "Free ArcGIS tools" and download "Easy Calculate".

How do I display my output from a statistical software package (e.g. SAS, S-Plus, R) on a map?

In general, it is relatively easy to export data from GIS software into a format that can be used with other software packages and import results from other software into the GIS. I prefer working with .dbf files, but the ArcGIS software does allow you to import text files as well. If I have exported data from a statistical package to a .dbf file, I will often use Microsoft Excel to format the data the way I want it. Make sure the top row are field names acceptable to .dbf files, and make sure your number fields are numbers and text fields are text. If your data includes x- and y- coordinates you can add it to your dataframe using Tools, Add XY data. You will need to specify the projection the data is in. If you want to do any analyses with the data, it is a good idea to export it as a spatial dataset (e.g. a shapefile)

If your dataset includes an ID field that corresponds to an ID field in an existing spatial dataset, you can simply join the .dbf file to the attribute table of the dataset. For census data I usually use a text field "STFID" that is the concatenation of the state, county, tract, block group and block codes to join attribute data to census polygons.

How do I import a comma delimited textfile into ArcMap?
ArcMap will allow you to import a comma delimited text (.csv) file for joining to a spatial dataset, geocoding, or adding as XY data. Unfortunately it will read any fields with numbers as numbers rather than text. This is a problem if you have fields with leading zeros such as ZIP codes or IDs. The trick is to edit the schema.ini file that resides in the same folder as your csv file as follows:
[Yourfile.csv]
Format=CSVDelimited
Col1=Attribute1 Text Width 10
Col2=Attribute2 Double
Col3= Attribute3 Text Width 32
etc...

Col1 refers to field 1, Attribute1 will display as the name of the field, Text Width 10 will create a string field 10 characters wide.
Thanks to Mark Hoyland for posting this on the ESRI Knowledge Base http://forums.esri.com/Thread.asp?c=93&f=1149&t=64464