Recently, I saw a question come across one of the many GIS email lists I am on asking about whether or not the spelling sensitivity setting in an Address Locator also worked with addresses located using names and a Place Name Alias table in ArcGIS. This question intrigued me because though I have done my share of geocoding over the years, I have not used place name aliases much. I was unsure how this would work so I decided to do some testing. Click here to find out more
Tripp Corbin, CFM, MCP, GISP CEO eGIS Associates, Inc.Archive for the ‘Tips and Tricks’ Category
Geocoding – Place Name Alias Tables and Spelling Sensitivity
Posted by trippcor on May 31, 2012
Posted in Tips and Tricks | Leave a Comment »
Excel Spreadsheets and ArcGIS
Posted by trippcor on May 18, 2012
Microsoft Excel is an amazing tool that allows users to store information, perform calculations, link data, and a more. This tool is used by multiple professions and practices in support of day to day tasks to store critical and useful information. As a result GIS users often need to make use of data stored in Excel Spreadsheets to perform their daily duties.
While an Excel spreadsheet can act similar to a traditional database, it is not. A spreadsheet allows users to perform functions within, such as assign equations to individual cells or records, which are not allowed in a database. This additional functionality often causes problems when a GIS User tries to integrate spreadsheets into their workflows and analysis within Esri’s ArcGIS platform. To be successful, they must be aware of the limitations.
Posted in Tips and Tricks | Leave a Comment »
Service Pack 4 for ArcGIS 10 to be released in March
Posted by trippcor on February 8, 2012
Esri is planning another service pack for ArcGIS 10. This will be the 4th service pack for 10. It will address several issues. Here are a few that might be of some interest:
- Changes to layer names inside a group layer file are not saved/persisted when ArcCatalog is closed.
- ArcMap crashes intermittently when editing while GPS connection is open
- GPS Toolbar does not recognize COM ports over 9.
- Projecting annotation from a file geodatabase feature dataset causes the text to draw a huge distance away from the proper location in the output. This is also reproducible in a personal geodatabase and data in SDE.
- ArcMap crashes with runtime error when reconciling certain child versions with default
- Layer with marker fill symbol loses its background color when adding to basemap layer with symbol level turned on.
- ArcPy local function tools do not accept a Mosaic dataset layer in the TOC as input
- When composite locator is created in the ArcSDE database, long property names cause it to fail
- Synchronizing a one-way replica is crashing ArcCatalog and ArcMap
- Synchronization fails while checking in the edits from a file geodatabase
- When running the Spatial Analyst > Hydrology > Fill tool and specifying a Z limit, ArcGIS Version 10 SP2 fills less sinks than ArcGIS Version 9.3.1 SP2.
- Applying a Military Grid Reference System (MGRS) grid 1:500,000 reference system to a data frame with non-WGS84 datum crashes the software
- When reconciling certain versions that are involved in a Parcel Fabric, the error returned is, “Version could not be reconciled,” with no extended description.
- Export metadata to FGDC CSDGM format: when an item’s spatial reference uses parameter names that are all lower case, the projection parameters are not exported
- Reconciling a version with its parent version corrupts the geometric network connectivity
- When map tips are enabled, the Hyperlink tool’s cursor no longer turns black when hovering over a hyperlinked feature
Those are just a few issues the service pack will address that I found interesting. There are 7 pages of issues addressed with SP 4. For a complete list of the issues SP 4 is to address go to: http://downloads2.esri.com/support/downloads/other_/183410.0_SP4_Announcement.pdf
Tripp Corbin, MCP, CFM, GISP | Chief Executive OfficereGIS Associates, Inc. tcorbin@egisassociates.com | www.egisassociates.com 678-710-9710 ext 21 | 866-304-3864 Fax Esri Certified Trainer | Esri Certified Desktop Associate
Posted in Announcements, News, Tips and Tricks | Leave a Comment »
Esri Technical Certifications – Questions Answered
Posted by trippcor on May 6, 2011
This week I attended Esri’s SERUG conference in Jacksonville Florida. I think SERUG went really well this year. Attendance was up from last year I believe. Presentations were great. It is always amazing to see what folks are doing with GIS and Esri Technology.
One of the hot button topics at this year’s SERUG conference was Esri’s new technical certifications. Renee Schreibman, Esri’s Southeast Training Consultant, had the job of trying to explain the new certifications and what it takes to earn one of the certifications. Renee did a great job explaining the program and answering questions. Here are a couple of highlights:
- If I earn a certification will I have to recertify with each new release of Esri? Looks like Esri is following the Microsoft model here. According to Renee, once you are certified you will not need to recertify with each new release. Only with major releases will you possibly need to recertify. In this case there will most likely be an abbreviated “Update your certification” type exam that would focus on the changes found in the new major release. Also you would still be certified on the past versions. This keeps with IT industry standard practices such as the Microsoft and Cisco certification Models.
- Do I have to take the associate exam before I take the professional exam? If you are looking to get certified on ArcGIS Desktop, you can skip straight to the professional exam if you feel you are at that level. Other exams currently under development for Developer and Enterprise may have a requirement for you to get associate first and then professional later.
- How many times can I take the exam and do I have to pay the $255 each time? The last part is easy to answer. Yes you have to pay each time you take the exam. I should point out Esri does not make any money from those taking the exams. Most if not all of that fee goes to the Pearson testing folks. So now to the first part of the question, how many times can I take an exam. Basically you can take the exam 3 times. After the third time you have to talk with Esri and get permission to take it a fourth time.
- How hard are the exams? Based on my experience and what Renee said, these exams are not easy. They are designed to make sure you have a thorough knowledge of ArcGIS at the level you are being tested for. Esri wants these exams and certifications to mean something. When you earn one you have accomplished something to be proud of.
- What is the pass rate on the exams? Still too early to tell. These exams have only been out for a few months and Esri is still gathering data, however see question 4. I have heard some number passed around on the beta exams but nothing concrete enough to say for certain. I will say it was not a super high pass rate on the beta exams if the numbers I have heard via the rumor mill are even close to correct. As stated with question 4, Esri wants these certifications to have meaning so they are not giving them away. You do have to earn them.
- Do I get told which questions I got wrong? No you only get told if you passed or failed
- Where can I take an exam? At pretty much any Pearson Vue authorized testing center. These are located all over the place. Go to http://www.pearsonvue.com/esri/ to locate a testing center near you and to register to take an exam
- Do I have to complete all the recommended training classes before I take a Certification Exam? No, you don’t. The list of recommended classes contain topics which might be included on the exams.
- If I have not upgraded to ArcGIS 10 yet can I still take the exams? Yes you can but you will have a hard time passing. The exams are all built around ArcGIS 10. If you are not familiar with the new functionality such as Feature Templates, Dynamic Test and Data Driven Pages you will be at a severe disadvantage taking the exam.
- Does this compete with the GISP especially since they are considering an exam? No, the two are complementary. The Esri Technical Certifications only test on knowledge about using Esri products. A GISP exam, if implemented, would test on a more rounded and theoretical knowledge most likely based on the Dept. of Labor Geospatial Core Competency Model (GTCM).
So there you go, my brief summary of Renee’s presentation and some of the questions that were asked/answered during the presentation. Renee’s presentation will be posted to the SERUG website at some point soon. In the meantime you might want to go to http://training.esri.com/certification/ if you have any questions or are looking for more information. Of course I am always happy to answer questions or help to find answers.
Tripp Corbin, CFM, GISP Vice President, GIS Keck & Wood, Inc. Esri Certified Trainer | Esri Certified ArcGIS Desktop AssociatePosted in Announcements, Tips and Tricks, Training | Leave a Comment »
Extract day of the week from a date field in ArcGIS
Posted by trippcor on December 15, 2010
So your are ArcGIS 10 (ArcView licence only) and have a large dataset with a Date field. You want to select all those dates that fall on a specific day or days of the week. How would use do this only using the tools in ArcGIS? Try this:
1. Add an integer field to the table
2. Use the field calculator and vbscript syntax YourDOWField = DatePart (“w”, [YourDateField]).
3. The field will then contain values 1-7 which translates to Sunday – Saturday. You can then select on this.
Tripp Corbin, CFM, GISP Vice President, GIS/IT Esri Authorized Instructor Esri Certified ArcGIS Desktop 10 Associate Keck & Wood, Inc. www.keckwood.comPosted in Announcements, Tips and Tricks | Leave a Comment »