|
Site Analysis API & Address Coding
Site analysis tools are computer-based operations that enable the user to examine demographic, economic and other characteristics of elemental geographies (such as block groups) as a group or composite. Typically, the group of elemental areas is defined by a circle or a radius value in miles from an address or location of interest ... a site with a 1-mile or a 3-mile radius. Site analysis applications are focused on addresses/locations of interest. This section reviews use of the CV XE GIS Site Analysis tools for geocoding addresses and integrating those geocoded address into GIS applications. This is an enabling or first step in many GIS-based site analysis applications. See more about the Site Analysis API that includes features reviewed here. Address Geocoding with Site Analysis API With CV XE GIS (5/18/14 or later version) running and your User Group ID entered in Settings, start the Site Analysis operation from the menu: Analytics>SiteAnalysis. The Site Analysis API (Application Programming Interface) makes use of API technologies to geocode addresses and assign Web-sourced demographic-economic attributes. On the SiteAnalysis form, the address coding operations are located in Tools>Find Address and Tools CodeAddresses. Operations reviewed here may be performed using the no fee CV XE GIS. The map views in the this section show median household income by block group in the Kansas City area. Find Address CodeAddresses Find Address The Find Address operation enables you to enter an address that is then geocoded. The geocoded result is assigned a demographic-economic value selected by the user. In the following example, the user selects the ACS 2012 5 year median household income item. The geocoded result is converted into a shapefile, for optional permanent reuse, and also added to the existing GIS project. 1. Upon clicking the Tools>Find Address button, the address prompt appears. This view shows the default address, but you can use any address. Click OK when ready for next step. 2. The next prompt is for the ACS 2012 5 year subject matter item to assign to this address. This view shows the default "item name", but you can use any ACS 2012 5 year item available at the block group level. The default item is "B19013_001E" (ACS 2012 5 year median household income). See list of available tables. Click OK when ready for next step. 3. The next prompt is for a second address. You can continue adding addresses manually. When done enter a null address as shown here. Click OK when ready for next step. 4. A shapefile is now automatically developed and added to the GIS project. A default file name is used which you can change. You can choose to use the default file name and overwrite/reuse this name. The shapefile marker(s) are displayed in the map window. The identify tool is used to click on the marker (red square marker) and display a mini-profile. In the profile, the Census 2010 census block code is shown as a field in the shapefile dbf. This address is in Census 2010 census block 29-095-006600-2016. The address is located in a block group with ACS 2012 5 year median household income estimate of $44,943 as shown for the field "item1" in the profile. CodeAddresses The CodeAddresses operation is similar to the Find Address operation. Rather than entering addresses manually, addresses are input from a file that you create. As with Find Address, the geocoded results are assigned a demographic-economic value selected by the user. In the following example, the user selects the ACS 2012 5 year median household income item. Like Find Address, the geocoded results are converted into a shapefile, for optional permanent reuse, and also added to the existing GIS project. 1. Upon clicking the Tools>CodeAddresses button, the address input file name appears. See more about the address input file structure. This view shows the existing default input file, but you can develop your own with a text editor. The default addresses input file contains addresses for Starbucks Coffee in the Kansas City area. Click OK when ready for next step. 2. As with Find Address, the next prompt is for the ACS 2012 5 year subject matter item to assign to this address. This view shows the default "item name", but you can use any ACS 2012 5 year item available at the block group level. The default item is "B19013_001E" (ACS 2012 5 year median household income). Click OK when ready for next step. 3. The next prompt enables you to code the first set of addresses in the file (enter the number) or all addresses (All). Processing now proceeds. The record number being processed is shown in the statusbar (lower left corner of window). 4. A shapefile is now automatically developed and added to the GIS project. The shapefile markers are displayed in the map window. Note that the new added address shapefile shows at the top of the legend panel. This is structurally the same shapefile/view as conveyed by the "Locations" layer. Address File Structure The input address file is a comma-delimited/CSV structured file. Include one record per address. Each address record should contain 5 fields: name/ID, address (e.g., 1100 Main St), city, state postal abbreviation, and 5-digit ZIP code. The sample file provided includes the Starbucks Coffee locations in the Kansas City area. These data are shown in the scroll box below. Sample Address File
City Center Square, 1100 Main St, Kansas City, MO, 64105
Crowne Plaza Kansas City, 1301 Wyandotte St, Kansas City, MO, 64105 W. 39th Street, 1701 W. 39th Street, Kansas City, MO, 64111 41st and Main, 4101 Main Street, Kansas City, MO, 64111 Country Club Plaza, 302 Nichols Rd., Kansas City, MO, 64112 Target Mission T-1487, 6100 Broadmoor St, Mission, KS, 66202 Hen House Market-Merriam 31, 5800 Antioch Rd, Merriam, KS, 66202 Hwy 40 and Blue Ridge, 11815 E Highway 40, Independence, MO, 64055 Target Kansas City T-1436, 8509 State Line Rd, Kansas City, MO, 64114 Ward Parkway, 8600 Ward Parkway, Kansas City, MO, 64114 Hy Vee Independence 2, 4545 S. Noland Road, Independence, MO, 64055 23rd and Lee's Summit, 1516 A East 23rd Street, Independence, MO, 64055 Ranch Mart South, 3807 W 95th Street, Overland Park, KS, 66206 89th and Metcalf, 8801 Metcalf, Overland Park, KS, 66212 75th and Quivira, 7411 Quivera Road, Shawnee, KS, 66216 Super Target Shawnee ST-1759, 15700 Shawnee Mission Park, Shawnee Mission, KS, 66217 87th and Pflumm, 13218 West 87th Street, Lenexa, KS, 66215 Independence MO, 19130H East 39th Street, Independence, MO, 64057 Marriott Overland Park, 10800 Metcalf, Overland Park, KS, 66210 Target Overland Park W T-2043, 11501 W 97th St, Overland Park, KS, 66214 Hen House-Lenexa 19, 15000 87th Pkwy, Shawnee Mission, KS, 66215 Hen House-Leawood 24, 11721 Roe Ave, Leawood, KS, 66211 Corporate Woods, 9932 College Blvd., Overland Park, KS, 66210 119th and Glenwood, 6555 W 119th St, Overland Park, KS, 66209 Super Target Overland Park, 12200 Blue Valley Pkwy, Overland Park, KS, 66213 Hen House 34 - Overland Park, 11930 College Blvd, Overland Park, KS, 66210 Super Target Kansas City ST-18, 1201 W 136th St, Kansas City, MO, 64145 119th St. and Hwy 69, 10152 W. 119th Street, Overland Park, KS, 66213 135th and State Line, 13121 State Line Road, Kansas City, MO, 64145 50th and Chipman, 1702 NW Chipman Road, Lees Summit, MO, 64081 127th and Antioch, 12551 Antioch Road, Overland Park, KS, 66213 Super Target Lees Summit ST-13, 1850 NW Chipman Rd, Lees Summit, MO, 64081 135th and Briar, 13480 Briar Street, Leawood, KS, 66209 Macy's - Lee's Summit, 701 NW Blue Pkwy, Lee's Summit, MO, 64086 Shawnee Mission and Monticello, 6620 Monticello Road, Shawnee, KS, 66226 Douglas and Tudor, 1130 NE Douglas Street, Lees Summit, MO, 64086 Hwy 58 and Town Center, 1113 E North Ave, Belton, MO, 64012 151st and Marty St, 7230 W 151st, Overland Park, KS, 66223 Target Overland Park South T-1, 8101 W 151st, Overland Park, KS, 66223 Lee's Summit, 125 SE Hwy 291, Lees Summit, MO, 64063 Hy-Vee Olathe 1, 14955 W. 151st, Olathe, KS, 66062 Price Chopper-Olathe 40, 15970 S Mur Len Rd, Olathe, KS, 66062 151st and Blackbob, 15094 S Blackbob Rd, Olathe, KS, 66062 Blackbob Marketplace, 15225 West 135th Street, Olathe, KS, 66062 Target Olathe South T-1543, 20255 W 154th St, Olathe, KS, 66062 119th and Blackbob, 14605 W 119th Street, Olathe, KS, 66062 Super Target Olathe ST-1756, 15345 W 119th St, Olathe, KS, 66062 119th and I 35, 16521 W. 119th Street, Olathe, KS, 66061 Hwy 7 and I-70, 704 N Highway 7, Blue Springs, MO, 64014 Target Blue Springs T-2525, 1040 NE Coronado, Blue Springs, MO, 64014 This completes the review of using the Site Analyst API for address coding and shapefile development. Review related Site Analyst API section to see how these address coded files can be used for site analysis applications. ProximityOne User Group Join the ProximityOne User Group to keep up-to-date with new developments relating to geographic-demographic-economic decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group. There is no fee. Support Using these Resources Learn more about address coding and use of address coded data. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants. Additional Information ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact us (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest. |
|