Monthly Archives: August 2009
Earlier this year we released ESRI StreetMap Premium for North America and Europe using NAVTEQ data, and until this week it has been the only version available from ESRI. Well, as of this week, ESRI StreetMap Premium for North America … Continue reading
8/28/09–Today, we updated the ArcGIS Online Sharing application. We’ve fixed some bugs, sped up performance, and improved the editing experience for groups you own.
Look for our next update in about two weeks.
Have suggestions for improving the application? Let us know through the ArcGIS Online forums.
Whether you’re learning the basics of the latest release or looking to create your own add-in using the SDK, the ArcGIS Explorer Community offers a wide variety of useful information. These include this blog, the Explorer Gallery, a Media Gallery, peer-to-peer discussion and help forums, and the Knowledge Base.
Just go to the ArcGIS Explorer Resource Center and click Community.
by Kyle Watson
Let’s have a quick chat about the geocoding in ESRI Business Analyst – and how to increase the accuracy. Business Analyst, as you may know, bundles street data and locators that allow you to “put dots on the map”. Those dots are usually your stores, customers, competitors etc. – any file with address information.
Here’s how the standard composite locators try to find addresses:
(1) Address Point …highest level of accuracy, but not available in all areas so then it finds…
(2) Street Address …if it can’t find the address then…
(3) ZIP Code …maybe the address is misspelled, or if no ZIP is found then it drops to…
(4) City/State …you may want to revisit these original records and re-geocode…
But there’s one more option, have you ever used the Business Analyst ZIP+4 locator and data? It adds an extra level of thoroughness while finding street addresses. Here’s an example of why you would want to use it.
The image below shows a customer file geocoded in the 07410 ZIP Code (Fair Lawn, NJ). I tried geocoding the 11 addresses and for whatever reason the street addresses weren’t found so the default locator at least assigned them to their ZIP Code, (represented by the red triangle in the middle). The triangle location is just the ZIP Code center, not their real postal address. So the problem here is I now have 11 records in one location and you miss out on your customer distribution patterns.
I then used the ZIP+4 locator to geocode the same file. The results (black dots) give a much better representation of the customer locations. Their ZIP+4 extensions (ex: 07410-1590) add another level of geographic granularity within the overall boundary.
So how do I use it? Easy, just modify your install options to include it. Pop in your install DVD, go to your Add/Remove Programs and find Business Analyst. Hit the Change or Add/Remove buttons. Select the ZIP+4 Geocoding Data. The data (2.5GB) and locator are added.
Then you just need to activate the locator in Business Analyst. Go to your Business Analyst Preferences > Dataset tab and select the new ZIP+4 locator. If your data has ZIP+4 records, you’ll see a new entry for ZIP+4 entry in the Store and Customer Setup dialogs.
Hope you found this helpful. (many thanks to Dennis Kaplan for this blog idea…)
by Catherine Spisszak
Esri Data is showcased in a recent edition of Crain’s New York City Facts.
This online article provides very interesting facts about New York City, including which neighborhoods are expected to grow the fastest over the next five years due to good schools, rehabbed housing and new shopping.
Click here to check out the entire article: crainsnewyork.com
Question: I have a raster elevation file and a polygon SHP file, and I would like to know the mean elevation according to each spatial unit in my SHP file. I see that this can be done through zonal statistics, but I don’t have zones in my raster file, but rather only a SHP file. Later I will repeat the same process for aspect, and slope.
Thank you for your help.
Answer: You should be able to use the Polygon to Raster tool (ArcInfo License) to convert your shapefile to a raster. One of the tool parameters is the value field from your polygons that will contain the zone ID. The one thing to watch out for are multipart polygons which will not work, so you may need to use the Multipart to Singlepart tool first.
Though it may be more useful to use the Raster to Point tool. This will take longer, but then you can use the Identity tool to assign the polygon IDs to these points. That will allow you to do a more meaningful presentation of what average elevation means by including a standard deviation, and a cell count. To do that use the Summary Statistics tool. You could get the same information with rasters, though you’d have to produce three raster datasets, and optionally use the Combine tool to have a similar attribute table for a single raster dataset.
Formerly a Mapping Center Ask a Cartographer Q & A.
8/25/09–All items published to ArcGIS Online contain information on when they were published. You can use this information in your searches to find items published during a given time frame.
The date and time an item is published is not stored in a form that is easily read by people. Instead, ArcGIS Online uses UNIX time (also UNIX epoch and POSIX time) as its reference system. UNIX time is defined as the number of seconds that have elapsed since midnight January 1, 1970. So in order to create a search expression that incorporates time, you need to convert time as we typically refer to it (e.g., August 6, 2009 08:40 AM) into UNIX time. Here’s a useful web site that does just that: http://www.epochconverter.com/.
Suppose you want to find all public items published between August 1, 2009, 12:00AM to today (August 6, 2009 08:40AM). First you’d need to convert both of these dates into UNIX time.
August 1, 2009 12:00AM converts to: 1249084800
August 6, 2009 08:40AM converts to: 1249548000
ArcGIS Online actually stores time in milliseconds, so you need to add three zeros to the end of the numbers above. Additionally, you need to pad six zeros on the front of the number. This is because the number is stored as a string in the database.
To form the search expression that you can enter into the search box of ArcGIS Online, you specify you want to search the uploaded field. This is the field that stores the date and time an item is uploaded. Thus, the expression would look like this:
uploaded: [0000001249084800000 TO 0000001249548000000]
Note that the operator TO needs to be in uppercase.
In my case, ArcGIS Online returned a few items dated July 31, 2009. Initially, I was a bit confused by this, but then I realized that time zone differences come in to play. August 1, 2009 12:00AM (UTC – Coordinated Universal Time) is actually July 31, 2009 04:00PM (UTC-8 – Pacific Time).
You can combine the uploaded field with other search parameters. For example:
- earthquakes uploaded: [0000001249084800000 TO 0000001249548000000] – would find items that contain the word earthquakes published in the time frame.
- owner:esri uploaded: [0000001249084800000 TO 0000001249548000000] – would find items owned by ESRI published in the time frame. (NOTE: There are no published items during this time frame from ESRI.)
For additional information on other searchable fields, see http://www.arcgisonline.com/help/content/search/advanced_search.htm
Contributed by Mike Minami of the ArcGIS Online development team
Summer is winding down, so we thought we’d take this opportunity to report on a few things we spent our summer working on and some things you’ll see in the fall.
First, you can now follow us on Twitter at ESRITeamWater – we’ll be providing updates via twitter about our activities, information for our water, wastewater and stormwater customers and also when we’ve posted updates to the resource center.
And we have quite a few updates on the way….
Those of you who were lucky enough to attend the UC in July, you saw us present our “costing tools” for ArcGIS Desktop. We are now doing some final code revisions and documentation and will be posting this new template to the resource center in the next few weeks.
For those that haven’t seen the costing tools yet, they are a set of desktop tools designed to help you cost out capital improvement projects or really cost out any type of project with GIS. The concept is that you can either choose assets that are in your GIS and select them for replacement and the tools will look up against a cost table to determine the replacement costs. The cost table is fully customizable and you can do some things like have default replacement types for materials – for example if you always replace transite pipes with ductile iron, than that will be pipe type used for your replacement project and that will drive your replacement costs. Also you can choose to add or extend mains or pipes to get costs for water main extension or sewer expansion projects.
We’ll also be providing some geoprocessing models to help you make system rehab and expansion decisions. We’ve had a lot of discussions with water and wastewater utilities about how to make some generic models to assist in condition assessment and decided that it would be more impactful if we created some models that showed you how you can use GIS and geoprocessing to make rehab decisions. Than you can customize the models for your utility’s information, workflows & asset rehab priorities.
To be fair, the costing tools are more of generic toolset and you’ll also see the costing tools as a template for pavement management on the soon to be launched ESRI Public Works Resource Center. So if you are looking for an end-to-end solution for condition & risk assessment that leverages your investment in GIS data, we suggest you check out some ESRI business partner solutions such as CapPlan from MWH Soft or MRP from Advantica.
Editing Template Update
As you may have heard, we are also working on an update to the editing template that will expand the editing toolbar for both water and wastewater.
Over the next few months you’ll see us begin to add more wastewater information and templates to the Water Resource Center. So, while decided to start with water (hey, you have to start somewhere) we are going to add more content for wastewater and stormwater.
Water & Wastewater Utility Training Plan
We are wrapping up a GIS training plan specifically for our water and wastewater customers. The intent of the training plan is to give water utilities a tool to help them make training decisions by recommending GIS training courses by both typical staff roles within a utility (mapping technician, engineer, DBA, etc) as well as buy department (IT, planning, operatins) . So for example, we can help recommend training course for engineers that want to use GIS for lightweight analysis and ad hoc mapping or for folks in the IT department who need a better understanding of how GIS fits into their enterprise.
The training plan is designed to be customized for specific utilities. So you can work with an ESRI training consultant to identify what your organizational and GIS goals are and then based on the size of your utility we can recommend training options. And the training plan will be free of charge!
Public Works Resource Center
We’ll be launching a Public Works resource center soon that will compliment the Water Resource Center. So you can go to the public works resource center for information about managing pavement, street furniture, signs, facilities, snow plow routing, solid waste pickup, etc and use the Water Resource Center for information about GIS for water, wastewater and stormwater.
As always, your feedback guides much of our future plans. So if you’d like to make suggestion please email us at ArcGISTeamWater@esri.com, post a comment to this blog or use the water/wastewater discussion forums.
Because content is such a crucial component of your GIS projects, and because ESRI is working to make more content available to you, we decided it’s about time we launch a blog about all things ArcGIS Data.
The ArcGIS Content team builds the data components you find in the box with ArcGIS products, such as ESRI Data & Maps, and also the street data you find in ArcLogistics and the Business Analyst suite, all the maps and tasks in ArcGIS Online, the maps for MapIt, and basically any other GIS data in ESRI products.
Since we complete or release a new data product almost every week, we thought it would be a good idea to open up this direct line of communication with you. We will keep you posted on the latest and greatest data news and give you a heads-up on what we have in the works.
So stay tuned…
On behalf of the ArcGIS Content Team, welcome to the new ArcGIS Data Blog.
The 9.3.1 ArcGIS Server Web ADF for .NET introduces an extensibility point to the Print Task that allows you to customize the look of your printouts using template files on the Web server.
A new property called LayoutTemplateFile is introduced to define the template file. This property can point to any file on disk but must be accessible via a web URL. The file may be part of the same application or can reside in a separate application (for example, the aspnet_client folder).
In Visual Studio, select the PrintTask control and you’ll see the new property. Clicking the Browse button allows you to browse to the custom template file.
How do you create a simple custom template?
An easy way to create a template is to modify the ADF’s default template.
- Within Visual Studio, right-click your project and choose “Add New Item…” from the menu. When the dialog appears, choose “HTML Page” and give it a suitable name. This will create an HTML document which you can use as the template.
- Open the default template file which is typically installed in the ADF runtime folder (Example: C:Inetpubwwwrootaspnet_clientESRIWebADFPrintTaskLayoutTemplatesdefault.htm). This file defines the default appearance and layout of the Print Task output window.
- Overwrite the markup of the new page with the contents from default.htm.
- Modify the markup and CSS to obtain the output you desire.
What can you do with these custom templates?
Using custom templates, you can:
Control the layout of elements and their styles
In the template file, you can define the position and dimensions of the different elements on the page such as the map title, map image, and legend information. You can style the template page using inline CSS or an externally linked style sheet.
Inject dynamic content
The template file is not restricted to static HTML files but can reference resources which generate dynamic content (such as .aspx files or .ashx files). For example, the current time stamp could be included in the print output using a dynamic page.
Control the display of results
You can control the styling of task results through CSS and you may also choose to render the result entirely, forgoing the default generated table view. If you want to get more advanced, you might add an image generated using the Google Chart API or a report section rendered using a browser plugin like Silverlight.
The SDK sample Common Print Task demonstrates the above capabilities where a chart is drawn dynamically using the Google Chart API
Contributed by Nikhil Shampur of the ArcGIS Server .NET software development team.