Technoleros

Observations from hacking around with all kinds of hardware and software

  • Home
  • Downloads
RSS
Category Archives: Data

Get Quarterly Updates of ZIP Code Data Set Available from SAS Maps Online

Posted on March 25, 2009 by Fred Janssen
No comments

from support.sas.com:

In response to requests from many customers, quarterly updates to the SASHELP.ZIPCODE data set are now available for you to download from the SAS Maps Online Web site.

The zip file provided in the download is a SAS data set in transport format, and you should use this file to replace your existing SASHELP.ZIPCODE data set.

The data set contains the following information:

  • US ZIP codes and centroid xy coordinates for each code
  • The variable, AreaCodes, which returns all area codes within a ZIP code
  • The variable, Alias_City, which returns all cities within a ZIP code

Features of the SASHELP.ZIPCODE Data Set

ZIP Code Centroids

The SASHELP.ZIPCODE data set contains ZIP code centroids, or the geographic centers of the areas, defined by the ZIP codes. You can use centroids and associated data to:

  • Calculate distances between ZIP codes and cities.
  • Find nearest locations to a ZIP code.
  • Perform address matching.
  • Annotate locations on a map.
    When merged with marketing data, the SASHELP.ZIPCODE data set can enhance a company’s marketing strategy to a significant degree.

SAS ZIP Code Functions

ZIPCITY is a SAS written function that utilizes the SASHELP.ZIPCODE file. It takes ZIPCODE as its argument and returns a title case city name and two-character postal code state abbreviation – for example – ZIPCITY(’02138′) returns "Cambridge, MA".

There are some useful functions that are indirectly related to the ZIP code file:

  • ZIPSTATE returns the uppercase two-character postal code for any five-character ZIP code argument.
  • ZIPNAME returns the uppercase name of the state for any five-character ZIP code argument.
  • ZIPNAMEL returns the mixed case name of the state for any five-character ZIP code argument.
  • ZIPFIPS returns the two-digit numeric U.S. Federal Information Processing Standards (FIPS) code for any five-digit ZIP code argument.
Categories: Data, Software, Statistics | Tags: coordinates, postal code, SAS

Trimble Updates TerraSync Software to Version 3.30

Posted on March 11, 2009 by Fred Janssen
No comments

trimble It appears that Trimble Navigation Ltd. refreshed its TerraSync software in December 2008 to version 3.30.  TerraSync is a form-centric data collection and management software designed to run on Trimble’s GeoExplorer, Juno, Ranger, and Nomad series of handheld GPS, as well as notebook or tablets PCs.  TerraSync runs on Microsoft Windows Mobile 2003, Windows Mobile 5.6/6, Windows 2000, Windows XP (Home, Professional, or Tablet PC Edition), and Windows Vista (Home Basic, Home Premium, Business, Ultimate, and Enterprise editions).  TerraSync comes in Standard Edition and Professional Edition flavors.  A table comparing the relative feature sets is at http://www.trimble.com/mgismedia/product_comparison/Field%20Software.xml. 

The new features available in the TerraSync 3.30 upgrade include:

  • Support for Juno SB and SC handhelds
  • Enhanced support for adding image files as attributes to features
  • Integration with CoPilot Live 7 Professional for Trimble TerraSync, and TomTom Navigator 6 turn-by-turn navigation software
  • Ability to change the order of raster images in Background Files form
  • Context menus in Map screen
  • Configurable Data Update screen
  • Updated SatDGPS.ini file for recent OmniSTAR frequency changes
  • Not Connected status for External real-time sources

TerraSync 3.30 fixes the following issues:

  • Incorrect Magnetic declination calculation
  • Inaccurate height displayed in the Skyplot and Navigation screens Trimble Survey receivers not initializing correctly and displaying Linkdown message
  • Not able to output NMEA messages from Trimble Survey receivers
  • OmniSTAR position flags in SSF File were incorrect when using Omnistar XP or HP
  • The Select Server window (NTRIP table) is hard to read on devices with VGA displays
  • Some Shapefiles are not able to display as backgrounds files

Customers whose TerraSync software maintenance expiry date is on or after 2 December 2008 are eligible for a free upgrade to the new version. Use your existing installation code to upgrade to v3.30.  TerraSync v3.30 requires the GPS Pathfinder Office software v4.10

Categories: Data, Downloads, GPS, Maps, Software | Tags: Pathfinder Office, TerraSync, Trimble

OLAP Tips from a SAS e-Learning Class

Posted on February 26, 2009 by Fred Janssen
No comments

saslogo I recently took the opportunity to sit through a SAS e-Learning course titled Creating OLAP Cubes.  It was a pretty detailed walkthrough for individuals creating OLAP cubes using SAS OLAP Cube Studio or Data Integration Studio.  Dimensions, levels, and hierarchies were described thoroughly, but measures were inadequately addressed.  Overall, it was a fine course for staff preparing to develop their first cube, particularly for small course fee.

There were a few takeaway points from the course that were worth sharing, particularly the last one, which I learned the hard way:

  • Every cube must have at least one dimension.
  • You can have only one TIME dimension per cube.
  • In a TIME dimension, you must order levels from the most general time period to the most specific with regard to the drill path.
  • You can specify a maximum of 1,024 measures per cube.
  • If you are creating a cube from a detail table or a star schema and you are including aggregated data from tables other than the input data source, then you must include measures for the stored statistics that are required for each derived statistic that you want to create for the new cube.
  • When you edit the definition of a cube, any existing physical cube is deleted.
  • To perform tasks on a physical cube (such as deleting, rebuilding, and tuning), you must have the appropriate file access permissions at the operating system level. If you do not have access, contact your system administrator for more information.
Categories: Data, Software, Statistics | Tags: BI, cubes, dimensions, hierarchy, measures, OLAP, SAS

Trimble Planning Software v2.8 is Available

Posted on February 25, 2009 by Fred Janssen
No comments

Trimble

Download Trimble Planning 2.8 Here

You already knew this, right?  According to Trimble’s web site, version 2.8 of the Planning Software was posted in July 2008.  I was still running version 2.7.  If you aren’t familiar with Planning Software by Trimble, in a nutshell it is software that helps you identify when you will have the greatest opportunity for a successful GPS data collection mission (read lowest DOPs) based on your study site location and local conditions.  Below is a summary of features:

Trimble’s Planning software is a powerful stand-alone software tool supporting any form of analysis to determine visibility for GPS, GLONASS, IGSO and geostationary satellites.

Some of the features include:

Station location:
Pick your location from a list of cities from all over the world, select your location from the world map or type in your local WGS84 position to do more precise mission planning. Add obstructions to your site to determine the best times for GPS observation.

Multi station planning:
Put in multiple station locations to determine the best time to observe these stations simultaneously.

Sky Plots:
Get detailed sky plots (including obstructions) of your site for any time of the day to aid in determining the best available occupation times.

DOP charts:
Chart out the different DOP values by time.

Visible satellites:
Get a quick overview on the number of satellites available for your site, for any time of the day.

Categories: Data, GPS, Maps, Software, Technology | Tags: DOP, GLONASS, GNSS, planning, satellite, Trimble

20-Foot South Central United States Topographic Data for Garmin GPS

Posted on February 24, 2009 by Fred Janssen
No comments

1233970967 John M. has created maps suitable for Garmin GPS units and posted them at GPSFileDepot.  The extent of the area includes all of New Mexico, Oklahoma, Texas, parts of Arkansas, Louisiana, and Missouri.  Features include:

  • Roads – Interstates, highways, arterial roads, residential roads, limited unpaved roads
  • Railroads
  • High resolution water data – lakes, rivers, streams, and washes
  • Federal Land Usage – Wilderness area, national parks, and military bases/ranges, native American reservations
  • Borders – County and state boundary lines
  • Elevation contours – 20ft intervals
  • GNIS Points of Interest – summits, mines, falls, dams, cemeteries, towers, populated places, etc.

The map collection (616 MB), with installer, can be downloaded at http://www.gpsfiledepot.com/maps/view/102/.

Categories: Data, Downloads, GIS, GPS, Maps, Outdoors, Software | Tags: contours, elevation, Garmin, GNIS, roads, topography

Zapata County Soil Map Update

Posted on February 17, 2009 by Fred Janssen
No comments

I just received an email from the Natural Resources Conservation Service (NRCS) indicating that the soil survey data for Zapata County, Texas has been updated.  We do some environmental work in Zapata County, and the soils data is an important component in some of the GIS analyses there.  Zapata County is unique in that it is one of the few counties in the United States that never had a soil survey book created for it, and because of that, it is one of the last counties to have GIS-based soils data.  The update message I received went like this:

Dear Soil Data Mart subscriber,

Some or all of the data for soil survey area TX505 has been updated.

Survey Area Symbol: TX505
Survey Area Name: Zapata County, Texas
Publication Status: Tabular and Spatial Data Currently Available

Survey Area Version: 10
Survey Area Version Established: 2/12/2009 1:00:26 PM

Tabular Data Version: 10
Tabular Data Version Established: 2/12/2009 1:00:26 PM
Tabular Data Version Updated?: Yes

Spatial Data Version: 4
Spatial Data Version Established: 8/22/2008 7:39:49 AM
Spatial Data Version Updated?: No

FGDC Metadata Updated?: Yes

Looking at the data in ArcMap, about 75% of the county now has data available.  The data is available in Access 2002 format, easily read as a personal geodatabase.  Keep working on it NRCS!


View Larger Map

Categories: Data, GIS, Maps | Tags: NRCS, soils, Zapata

DNRGarmin GPS 5.4.1

Posted on February 1, 2009 by Fred Janssen
No comments
DNRGarmin v5.4.1 - v.5.4.1 - 11.29 MB


From the Minnesota DNR web site:

This extension was built to provide users the ability to directly transfer data between Garmin GPS handheld receivers and various GIS software packages. Using this program a user can use point features (graphics or shapefile) and upload them to the GPS as Waypoints. Line and Polygon Graphics or shapes can be uploaded to the GPS as Track Logs or Routes. Conversely, Waypoints, Track Logs, and Routes collected using the GPS can be transferred directly to ArcView/ArcMap/Google Earth/Landview and saved as Graphics or Shapefiles.

This program has a real-time tracking mode that allows users to follow their progress on the ground within an ArcView View Document, ArcMap Data Frame, or Landview Map. This real-time track log can be saved as either points or lines as a set of graphics or in a shapefile.

Functionality Highlights

At this time DNRGarmin contains (but is not limited to) the following functionality:

Download Waypoints/Tracks/Routes – Download waypoints, tracks, and routes from Garmin GPS and save as ArcView Shapefiles or Graphics

Upload Waypoints/Tracks/Routes – Upload waypoints, tracks, and routes to Garmin GPS

Real-Time Tracking – Collect real-time locational information and store as graphics or shapefile

Waypoint to Point – Converts Waypoints downloaded from the GPS unit into a point shapefile or graphics

Track to Point/Line/Polygon – Converts a Garmin Track log to an ArcView graphic or shapefile

Point to Waypoint – Convert Point shapes or graphics to a GPS Waypoint

Line/Polygon to Track – Converts a line or polygon to a Garmin Track

Point to Line/Polygon – Converts Point themes to Lines or Polygons

Add Documentation to Features – Adds basic documentation to ArcView themes including Name, GPS Model, Date, Agency, etc. – ArcView 3.x only

Calculate Shape Attributes – Calculates Area, Perimeter, Length attributes for features. ArcView 3.x/9.x

Calculate CEP – Determine Circular Error Probability rings for Error estimation. ArcView 3.x/9.x

Image Hotlinking – Create hotlinks between images and GPS data.

USB Connectivity – Speed up your downloads by a factor of about 10 with USB connectivity option!

Projection Engine – Built in Projection Functionality using Proj.4 Cartographic Projections Library http://www.remotesensing.org/proj/ by Gerald Evenden

Click here to go to the DNRGarmin web site

Categories: Data, GIS, GPS, Maps, Software | Tags: ArcGIS, extension, Garmin, real-time, routes, tracks, waypoints

ResMap ECW Plug-in for ArcPad

Posted on January 19, 2009 by Fred Janssen
No comments

Download the ResMap ECW Plug-in Here

From ResMap.com:

This FREE plugin enables ArcPad 6.0 to open ECW and remote ResMap images (ECWP). "ESRI’s ArcPad TM software is a mobile geographic information system (GIS). ArcPad provides database access, mapping, GIS, and global positioning system (GPS) integration to users out in the field via handheld and mobile devices." This release offers:

  • Open ECW images in ArcPad
  • Open remote ECW images (ECWP)
  • Fast display times for ECW (fastest ECW plugin)
  • View ECW imagery on handheld devices
  • Use remote ECW (ECWP) to access terabytes of imagery on handheld devices
  • User Friendly Install performs all steps for ECW in ArcPad
  • Single Install application for both PC and PPC (handheld) devices
  • Example datasets, ECW and ECWP included with install.

Operating system: Windows 9x/NT/2000/XP or Windows CE 2.11, 2.12, and 3.0
Hardware: Any standard pc or Pocket PC with StrongArm

Click here to go to the ResMap web site

Categories: Data, GIS, Maps, Software | Tags: ArcPad, ECW, Imagery, PocketPC

Turning Your Garmin GPSMap 60CSx into a Flash Drive

Posted on January 11, 2009 by Fred Janssen
No comments

If you are like me, you carry your handheld GPS with you wherever you go.  I can never seem to keep up with my USB flash drives though.  They are never with me when I need them.  That doesn’t matter because you can turn your micro-SD card-equipped Garmin handheld into a portable flash drive.  You’ll need your GPS and transfer cable.  Here are the simple steps:

  1. Connect your USB cable to the computer and Garmin and turn the Garmin on.  The computer would need the Garmin USB driver loaded.
  2. Go to the main menu of the Garmin (I typically push the menu button twice no matter what page I am on) and scroll to the setup icon and press the enter key.
    60
  3. Scroll to the interface icon and press the enter key.
    60_2
  4. Scroll down to the USB Mass Storage button and press the enter key.
    60_3
  5. Your Garmin is now in Mass Storage mode (can’t use the GPS capability or get a screen shot).
  6. Open Windows Explorer and browse to your newly-mounted drive.  The drive name will typically be what you named your SD card (or how it came from the manufacturer).  Files can now be copied to and from the GPS.
  7. After files are transferred, use the Windows Eject or Safely Remove Hardware techniques disconnect the GPS from the PC.
  8. Press the Garmin power button to exit Mass Storage mode.
  9. According to Garmin, this technique works similarly on Macintosh computers.

When I want to work with my .gpx files in software such as GPSTrackMaker, I just put my 60CSx into Mass Storage mode and open the files straight off the Garmin – convenient!

Categories: Data, GPS, Software | Tags: Garmin, GPS, Windows

Data Mining Techniques Training

Posted on December 18, 2008 by Fred Janssen
No comments

I recently attended a three-day training course titled “Data Mining Techniques: Theory and Practice” in Boston, Massachusetts.  The training is part of the Business Knowledge Series offered by SAS Institute Inc., which features courses authored by experts and utilizing SAS software to accomplish the objectives of the courses.  I was fortunate to have Gordon Linoff as my instructor for the class.  Gordon is a recognized expert on the subjects of SQL (Structured Query Language) and data mining, and has authored many popular books on the subject.  Unlike many instances of classroom-based training, the Data Mining Techniques class was rich with real-world business examples and discussed the evolution of processes that are now used to increase efficiency of business and solve business problems.

The course includes lectures on the following topics: data mining overview, regression, decision trees, neural networks, memory based reasoning, clustering, survival analysis, association rules, link analysis, and genetic algorithms.  Labs were included with most of the lectures, as students used SAS Enterprise Miner 5.3 to perform the analyses.  Stories and real business scenarios were scattered throughout the training to bring together the theory and the hands-on techniques.

Enterprise Miner is an incredibly powerful tool, utilizing the statistical routines that SAS is renowned for.  SAS created an easy to use interface for Enterprise Miner that shields the data analyst from the many lines of SAS code used to generate the models.  The most amazing feature of Enterprise Miner is the ability to compare the models generated by the different techniques to identify which would work the best to answer a particular question.

The Data Mining Techniques course is scheduled approximately 10 times annually across the United States.  Both Gordon Linoff or Michael Berry teach the course depending on the schedule or location.  I highly recommend the course to data analysts in any field.

Categories: Data, Software, Statistics | Tags: decision trees, Enterprise Miner, mining, neural networks, regression, SAS
Next Entries
  • Categories

    Biking Business Intelligence Data Downloads GIS GPS Hardware Maps Media Outdoors PDA Smartphone Software Statistics Technology Twitter Uncategorized Web

  • Tags

    analysis ArcGIS ArcPad ArcView attributes Austin BaseCamp browser Communicator coordinates elevation Enterprise Guide ESRI extension firmware Garmin geocaching geography geotagging Google GPS health hot fix Junction kml Maps MapSource mobile NOAA OLAP projection registry routes SAS satellite scripts toolbox topography tracks transfer utility waypoints Web Report Studio Webupdater Windows
  • Meta

    • Register
    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org
  • Recommended Links

    • Ed Bott’s Windows Expertise
    • Engadget
    • Free Geography Tools
    • Geocaching
    • Hardware 2.0
    • Lifehacker
    • MapMyRide
    • sasCommunity.org
    • the SAS BI-ogsource
    • Trails.com
  • Recent Tweets...

    • SAS Global Forum registration now OPEN! - http://t.co/6JjZXcth 2011-11-13
    • Flash is dead. Long live HTML5. http://t.co/sgKYHr0Y 2011-11-10
    • How to create multiple LSF users - http://t.co/va4rbPcv #SAS 2011-11-04
    • Adding WRS to Portal in #SAS 9.2 / 9.3 - http://t.co/pYU9gdYv 2011-11-04
    • CSR announces SiRFstarV chipset - http://t.co/D3fAgsPa 2011-11-04
    • Kinect for Windows is Confirmed for 2012- http://t.co/sVGZhexJ 2011-11-04
    • Using Windows PowerShell to report on your #SAS Enterprise Guide project files - http://t.co/kitxR3Ic 2011-11-04
    • New #SAS Job Site - http://t.co/IkcxaTm9 2011-11-04
    • How To Install Windows 8 From A USB Flash Drive - http://t.co/10A8dF4u 2011-11-04
    • GarageBand 1.1 available for iPhone and iPod touch users - http://t.co/7211B6EJ 2011-11-04
    • More updates...

    Posting tweet...

© Technoleros. Proudly Powered by WordPress | Nest Theme by YChong