Latest Contributions by TonyHowser

Hi Alexandre, Are you simply trying to access the underlying data in the report? In that case, specify the output as Simplified XML ("S.XML" format instead of "PDF") and parse the resulting output from the Simple Rings service. Thanks, Tony ... View more

Greetings Aaron, If you are using ArcGIS for SharePoint v2.1.1 (final), our developers suggest trying the following: (a). In the list edit view, remove �??ArcGIS Location�?? field (b). Remove any geocoding workflow if ran on this list (c). Create a new �??ArcGIS Location�?? column if list has Lat/Lon or run the geocoding workflow if list contains address for with location needs to be determined. (d). After performing step c, click on each list item and view this item to make sure the feature get rendered on the map. (e). If it did not get rendered on the map, try the following: �?� Disable ArcGIS for SharePoint feature from Site collection features list under Site Collection Administration.         �?� Re-enable ArcGIS for SharePoint feature         �?� Clear browser cache         �?� Perform IIS reset         �?� Repeat steps (a) through (d) I hope this solution addresses your issues. Thanks for sharing your question with Esri community.  Tony ... View more

Jeff, you are awesome for sharing his Flex goodness with the wider Esri user community. Here's some more info: http://forums.arcgis.com/threads/61532-BAO-API-for-Flex-and-ArcGIS-API-for-Flex-3.0 Cheers, Tony ... View more

Greetings Jeff, Barring any unforeseen issues, we will have a BAO API for Flex which is compatible with the core ArcGIS API for Flex v3.x libraries. I'm going to try to follow up with some estimates some time next week. Note: The BAO API for Flex is compatible with the Business Analyst Online API and Community Analyst API.  Please see the FAQs below. If you have any specific follow up questions, please feel free to contact me at thowser{at}esri.com. Thanks for your question and for your patience (and for providing the dev community with a temporary workaround!) Tony FAQs 1. What are the differences between the boundary files used in the Esri 2010/2015 and Esri 2011/2016 datasets and how do I access them? Esri 2010/2015 data and projections (including associated reports) are based on Census 2000 administrative boundaries.  Esri 2011/2016 data and projections (including associated reports) are based on Census 2010 administrative boundaries. Business Analyst Online API and Community Analyst API users may access the content based on the Census 2000 administrative boundaries through the default �??USA�?� dataset.  Content based on the Census 2010 administrative boundaries may be accessed through the �??USACensus2010�?� dataset. The ActiveDatasetID parameter can currently be used to toggle between the �??USA�?� (default) and �??USACensus2010�?� datasets.  When you specify this optional parameter in most Web services requests with the Business Analyst Online and Community Analyst APIs, a different list of content (including data and reports) will be accessible.   Study the examples and note the ActiveDatasetID parameter.  This parameter is supported in the REST and SOAP services and, in the Flex and Silverlight SDKs. 2. What is the relationship between the Business Analyst Online and Community Analyst Web applications and the associated APIs? The Business Analyst Online and Community Analyst Web applications are highly-refined Esri-hosted Software as a Service (SaaS) applications which consume the Business Analyst Online and Community Analyst APIs.  Custom client applications and workflows, which integrate and leverage Business Analyst Online and Community Analyst content and capabilities, can be implemented with these public APIs.  A significant amount of research and development has been invested in the usability and design of these Web applications.  They are showcase client applications of the APIs and; because of this, they are one of the best ways to become familiar with the content and capabilities of the APIs.  Free trial subscriptions are available. 3. What are the differences between the Business Analyst Online and Community Analyst APIs? The Business Analyst Online API and Community Analyst API are targeted to different market segments, stakeholders, and decision makers.  Many of differences are associated with the data and other content that can be accessed through them. From a programmer�??s perspective, accessing either dataset is accomplished through the same Web services endpoints and SDKs, including the BAO API for Flex.  The subscription credentials and, by extension, the API token that was generated with them, will automatically enable the developer to access to the content associated with their particular subscription, whether it�??s from the Business Analyst Online API or the Community Analyst API. ... View more

Hi mickogricko, Thank you for your patience. The "S.XML" (simplified XML)/XML-based output "report" formats are excellent options for consuming the data and *calculations* which are displayed/formatted in the PDF versions of the report. This way you can easily consume the information and leverage it in your systems, workflows, and applications. I completely empathize with you regarding your experience with the current "caption" attributes of many of the XML records returned with the S.XML and XML versions of the reports. Ideally, we should be providing "captions" that more closely represent the field descriptions in the PDF versions of the reports. This is a challenge since the fields are often nested in sub-fields and sub-headings, etc. We are assigning resources to address this challenge in our future releases. In the mean time, what you can do is map/associate the XML record (of the S.XML or XML versions of the report output) with a caption that you want to represent in your client application. You can generate both the PDF and S.XML/XML versions of the report simultaneously during application designtime and map the "name" attribute with the data or *calculated* field that interests you or is important to your system and/or stakeholders. We sincerely appreciate your frank feedback. This is extremely valuable for us. If we did not capture this feature request appropriately, please feel free to contact us through the bao_support@esri.com email and reference your Forum discussion with Tony. We are very interested in making sure the API meets your needs (because it will likely help our other customers' needs as well). Thank You! Tony EXAMPLE: (1). REST request to generate Esri Business Analyst Market Profile Report on the 92373 ZIP code in PDF and S.XML versions simultaneously: http://baoapi.esri.com/rest/report/SummaryReports?Boundaries={"StdLayer":{"ID":"US.ZIP5","geographyIDs":["92373"]}}&ReportOptions=[{"TemplateName":"market_profile","ReportFormat":"PDF"},{"TemplateName":"market_profile","ReportFormat":"S.XML"}]&f=json&TaskOutputType=GetReport&Token=iraIdzBCKv1fPYO5EU4oljNg3JvL1bz4d46yNBpBQ2SrHRp7uHA1UHiYuq2sFW9c& (2). View both of the report formats; identify the fields that are important to you in the PDF version of the report; and map this selected item in the PDF version of the report with the corresponding XML ReportItem record's "name" attribute: Market Profile Report (PDF ) ---------snip----------- 2010 Housing Units (14,577) [name="TOTHU_CY" in S.XML below] Housing Units Summary -> 2010 Housing Units -> Owner Occupied Housing Units (49.5%) ] [name="SCRIPT_C_2" in S.XML below] Housing Units Summary -> 2010 Housing Units -> Renter Occupied Housing Units (45.1%) [name="SCRIPT_C_3" in S.XML below] Housing Units Summary -> 2010 Housing Units -> Vacant Housing Units (5.4%) [name="SCRIPT_C_4" in S.XML below] ---------snip----------- Market Profile Report (S.XML ) ---------snip----------- <ReportItem name="TOTHU_CY" caption="2010 Total Housing Units" value="14577.000" /> <ReportItem name="SCRIPT_C_2" caption="SCRIPT_CY_OwnerOcc%" value="49.523" /> <ReportItem name="SCRIPT_C_3" caption="SCRIPT_CY_RenterOcc%" value="45.078" /> <ReportItem name="SCRIPT_C_4" caption="SCRIPT_CY_Vacant%" value="5.399" /> ---------snip----------- ... View more

Hi mickogricko, I am sorry that the caption attribute values in the XML records are not entirely helpful in associating the PDF fields with the XML document.  We are currently having our engineers look into the issue.  I will try to respond by this evening or tomorrow at the latest after I get more information for you.  If you have any further details to provide us, please send it to bao_support@esri.com or feel free to log you issue with SDK Support at 888-377-4575. Thank you very much for your extreme patience and understanding. -Tony ... View more

Thanks for your reply. Again, your feedback has been noted and; yes, you will experience better overall performance by analyzing "chunks" of locations together. Thanks again! Tony ... View more

Hi Sarah, Thank you for your WONDERFUL QUESTION (and your wonderful timing)! As a matter of fact, we will be releasing new REST documentation on the Resource Center for the Online API describing syntax, parameters, and samples for our new "Smart Map Facts" Web service at the beginning of next week for the Users Conference in San Diego.  With it, you can perform complex spatial and attribute-based queries of the Business Analyst Online dataset. For your questions, you will need an Online API subscription to access the 'DOMTAP' ("Dominant Tapestry Segment Number Variable) but I will show you the exact syntax and a sample here as a preview to the forthcoming documentation: 1. Give me the Dominant Tapestry Code (and, just for fun, let's throw in some other stuff in the request: the 2010 estimate for the Median Household Income, the 2010 estimate for the Median Age, and the output polygon geometry so we can map it!) of Census Block Group 060730054002 Here is the associated REST request: baoapi.esri.com/rest/maps/ThematicQuery/execute?geoLevelID=US.BlockGroups&f=pjson&outFields=NAME,ID,DOMTAP,MEDHINC_CY,MEDAGE_CY &ReturnGeometry=true&OutSR=4326&Where=(ID='060730054002')&Token=<YOUR_ONLINE_API_TOKEN> And, after about a second, here are your results: Dominant Tapestry Segment: #8 ("Laptops and Lattes") 2010 Median HH Income: $72,470 2010 Median Age: about 51 The JSON Response: The Rendered Geometry of the Block Group Which Was Queried (location is near the San Diego Cruise Ship Terminal with lots of high rise condos): [2] Give me the locations of all Census block groups in San Diego County which have a Dominant Tapestry Code of 8 or 23 ("Laptops and Lattes" and "Trendsetters", respectively) (this time without any geometry---we just want the FIPS codes of the areas) Here is the associated REST request using the extent of San Diego County: baoapi.esri.com/rest/maps/ThematicQuery/execute?geoLevelID=US.BlockGroups&f=pjson&outFields=NAME,ID,DOMTAP&geometry={"xmin":-117.783716,"ymin":32.482960,"xmax":-116.013673,"ymax":33.488599}&geometryType=esriGeometryEnvelope&InSR=4326&Where=(DOMTAP=8 OR DOMTAP=23)&Token=<YOUR_ONLINE_API_TOKEN> And, after about a second, here are your results: The JSON Response: And the Rendered Response (if I changed to request to include it): I hope this was able to answer your questions and, if you will be around at the Esri Users Conference in San Diego, please stop by the Business Analyst/Community Analyst Commercial Solutions booth and say, "Hi" and also attend our sessions and presentations! Thanks for your wonderful timed questions, Tony ... View more

Hi Kelly.  The new report is actually available in the "USACensus2010" Online API dataset.  It is not available in the default ("USA") dataset.  In order to specify an alternate dataset for any Online API service, you will need to add the "activeDatasetID" parameter and value to your request.  This parameter is documented in each of the services including the REST and SOAP Get Report Templates services For the Get Report Templates REST service, the request will be the following: http://baoapi.esri.com/rest/report/GetReportTemplates?&activeDatasetID=USACensus2010&f=PJSON&Token=YOUR_TOKEN To query the available datasets, please see the Get Datasets service in REST or SOAP. For a summary of the newer features, please see the What's New Page in REST or SOAP. Thank you so much for your question.  I am certain it will help others. -Tony The new Census 2010 Profile report is now available on the Business Analyst Online site.  However it is not a report listed using the BAO API GetReportTemplates Rest request.  When will the Census 2010 Profile be available for the the BAO API? ... View more

Section 1 - PART 5 of 5 (had to split this up) (Step 4). Generate a summary report on the selected areas. This is the final step. Using the information you looked in Steps 1-3, we going to leverage the Summary Reports service (REST: http://help.arcgis.com/en/businessanalyst/online%20apis/services/rest/reference/index.htm?SummaryReports.html SOAP: http://help.arcgis.com/en/businessanalyst/online%20apis/services/soap/reference/index.htm?SummaryReports.html ) to generate reports describing our study areas. Letâ??s go back to our workflow example one last time and summarize what we collected. â??I want to generate a Demographic and Income Report in PDF format of the City of Redlands, CA. To take it one step further, I also want to create the same report describing the Redlands ZIP codes, the county containing Redlandsâ?�. (Step 1). Determine which Online API Dataset you want to access. Result: Online dataset ID: â??USAâ?� (Step 2). Look up the area IDs of the administrative areas you want to query/analyze. Result: Standard Geography Data Layer ID US.Places Area Name Redlands city Area ID 0659962 Standard Geography Data Layer ID US.ZIP5 Area Name Redlands Area ID 92373 Standard Geography Data Layer ID US.ZIP5 Area Name Redlands Area ID 92374 Standard Geography Data Layer ID US.Counties Area Name San Bernardino County Area ID 06071 (Step 3). Look up the IDs of the report you want to generate. Result: Report ID dandi Report Title Demographic and Income Profile (New Style) Now, to generate each of the four Demographic and Income Profile reports described above, we pass those parameters from Step 1-3 to the Summary Report service. TO SEE THE OUTPUT IN REST, YOU CAN IMMEDIATELY SUBMIT THE FOLLOWING REST REQUESTS WITHOUT A SUBSCRIPTION TOKEN AND PRODUCE THE REPORTS THROUGH A REST DEMO VIEWER BY CLICKING ON THESE LINKS (and clicking on the output report link): Working REST Summary Report requests: 1. Demographic and Income Profile Report describing the City of Redlands: report and mapped polygon report only 2. Demographic and Income Profile Report Describing the Redlands ZIP Codes report and mapped polygon report only 3. Demographic and Income Profile Report Describing the county containing Redlands (San Bernardino County) report and mapped polygon report only Next week, for Section 2, I'll add the ASP.NET C# code to do the same in REST and SOAP. Take it easy. ... View more

Section 1 - PART 4 of 5 (had to split this up) (LIST CONTINUED FROM PREVIOUS) Report ID cex_retail Category Consumer Spending Reports Report Title Retail Goods and Services Expenditures Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID site_map Category MAP_Reports Report Title Site Map Available Output Formats [PDF] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID site_details_map Category MAP_Reports Report Title Site Details Map Available Output Formats [PDF] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID icubed04 Category MAP_Reports Report Title Site Map i-cubed 0.4 Miles Wide Available Output Formats [PDF] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID icubed08 Category MAP_Reports Report Title Site Map i-cubed 0.8 Miles Wide Available Output Formats [PDF] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID icubed16 Category MAP_Reports Report Title Site Map i-cubed 1.6 Miles Wide Available Output Formats [PDF] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID acs_housing Category ACS Reports Report Title ACS Housing Summary Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID acs_population Category ACS Reports Report Title ACS Population Summary Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Going back to our workflow example: â??I want to generate a Demographic and Income Report in PDF format of the City of Redlands, CA. To take it one step further, I also want to create the same report describing the Redlands ZIP codes, the county containing Redlandsâ?�. According to the list above, we want to generate the following report for all of those areas: -------------------------------------------------------------------------------- Report ID dandi Category Demographic Reports Report Title Demographic and Income Profile (New Style) Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- ... View more

Section 1 - PART 3 of 5 (had to split this up) (Step 3). Look up the IDs of the report you want to generate. This is a quick and easy step. The Online APIs have a growing number of predefined report â??templatesâ?� which you can generate with the services. In most cases, the reports summarize demographic, business, consumer characteristics, and many other measures which describe the underlying population of your selected study areas. In Step 2, you selected the study area, in this step, you are selecting the reports and you need to look up their associated IDs to tell the Online API which report you are interested in creating. (It should be noted that access and availability of report templates and associated analysis locations are subject to the terms of your subscription.) Leverage the Get Report Templates service (REST: http://help.arcgis.com/en/businessanalyst/online%20apis/services/rest/reference/index.htm?GetReportTemplates.html SOAP: http://help.arcgis.com/en/businessanalyst/online%20apis/services/soap/reference/index.htm?GetReportTemplates.html ) to look up the list of available report templates. As of this writing and with my own â??Basicâ?� subscription, the following reports on the â??USAâ?� dataset are available to me: -------------------------------------------------------------------------------- Report ID market_profile Category Demographic Reports Report Title Market Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID dandi Category Demographic Reports Report Title Demographic and Income Profile (New Style) Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID dandi_fy Category Demographic Reports Report Title Demographic and Income Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID dandicomparison Category Demographic Reports Report Title Demographic and Income Comparison Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID sf3_comparison Category Demographic Reports Report Title 1990-2000 Comparison Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID 55plus Category Demographic Reports Report Title Age 50+ Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID ageinc Category Demographic Reports Report Title Age by Income Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID agesexrace Category Demographic Reports Report Title Age By Sex By Race Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID agesex Category Demographic Reports Report Title Age by Sex Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID pl_summary Category Demographic Reports Report Title Census 2000 Detailed Race Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID sf3_summary Category Demographic Reports Report Title Census 2000 Summary Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID stdb_execsummary Category Demographic Reports Report Title Executive Summary Profile Available Output Formats [PDF, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID housing Category Demographic Reports Report Title Housing Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- Report ID qrtlydemog Category Demographic Reports Report Title Quarterly Demographic Profile Available Output Formats [PDF, Excel, XML, S.XML] Optionally Customizable Header Fields [logo, Report Title, areadescription, address, subReport Title, longitude, locationReport ID, latitude, binarylogo] -------------------------------------------------------------------------------- (LIST CONTINUES) ... View more

Section 1 - PART 2 of 5 (had to split this up) If you recall our workflow example: â??I want to generate a Demographic and Income Report in PDF format of the City of Redlands, CA. To take it one step further, I also want to create the same report describing the Redlands ZIP codes, the county containing Redlandsâ?�---we still need to get the county which contains Redlands. Well, we might already know this but this is not convenient for areas which you are not familiar with. Additionally or alternatively, we can actually do everything we want in this step (Get the area IDs of our study locations) using an *address* (or latitude and longitude coordinates) instead of an area name. What we really want is to obtain the â??completeâ?� spatial context of the location---that is, I want to know every area for every available standard geography data layer that â??touchesâ?� or intersects that address (or those coordinates), I can leverage the Return Standard Geographies service (REST: http://help.arcgis.com/en/businessanalyst/online%20apis/services/rest/reference/index.htm?ReturnStandardGeography.html SOAP: http://help.arcgis.com/en/businessanalyst/online%20apis/services/soap/reference/index.htm?ReturnStdGeography.html ) to do this and obtain the area IDs this way as well. In our example, the Esri Headquarters is located at â??380 New York St. Redlands, CA 92373â?� and I wanted to get every area from every available standard geography data layer that is associated with this location. Well, I would simply pass that address and the IDs of all of the standard geography data layers to the Return Standard Geographies service and get the following: -------------------------------------------------------------------------------- Standard Geography Name Entire Country Standard Geography Data Layer ID US.WholeUSA Area Name Area ID United States Area ID 01 -------------------------------------------------------------------------------- Standard Geography Name States Standard Geography Data Layer ID US.States Area Name California Area ID 06 (State FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) -------------------------------------------------------------------------------- Standard Geography Name Designated Market Areas (DMAs) Standard Geography Data Layer ID US.DMA Area Name Los Angeles, CA Area ID 803 -------------------------------------------------------------------------------- Standard Geography Name Congressional Districts Standard Geography Data Layer ID US.CD Area Name California - District 41 Area ID 0641 -------------------------------------------------------------------------------- Standard Geography Name Metropolitan Areas (CBSAs) Standard Geography Data Layer ID US.CBSA Area Name Riverside-San Bernardino-Ontario, CA Metropolitan Statistical Area Area ID 40140 -------------------------------------------------------------------------------- Standard Geography Name Counties Standard Geography Data Layer ID US.Counties Area Name 06071 (County FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) Area ID San Bernardino County -------------------------------------------------------------------------------- Standard Geography Name Cities and Towns (Places) Standard Geography Data Layer ID US.Places Area Name Redlands city Area ID 0659962 (Census-designated Place FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) -------------------------------------------------------------------------------- Standard Geography Name ZIP Codes Standard Geography Data Layer ID US.ZIP5 Area Name Redlands Area ID 92373 -------------------------------------------------------------------------------- Standard Geography Name County Subdivisions Standard Geography Data Layer ID US.CS Area Name San Bernardino CCD Area ID 0607192770 (County Subdivision FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) -------------------------------------------------------------------------------- Standard Geography Name Census Tracts Standard Geography Data Layer ID US.Tracts Area Name 060710081.00 (Census Tract FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) Area ID 06071008100 -------------------------------------------------------------------------------- Standard Geography Name Census Block Groups Standard Geography Data Layer ID US.BlockGroups Area Name 060710081.002 (Census Block Group FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) Area ID 060710081002 -------------------------------------------------------------------------------- Well, thatâ??s real cool. I actually make reports or query data that can be used to compare summary attributes or facts describing these areas like average/median household income, age, specific consumer expenditures, education level, etc. Going back to our workflow example: â??I want to generate a Demographic and Income Report in PDF format of the City of Redlands, CA. To take it one step further, I also want to create the same report describing the Redlands ZIP codes, the county containing Redlandsâ?�. Well, we were able to leverage utility services to look up all this info: -------------------------------------------------------------------------------- Standard Geography Name Cities and Towns (Places) Standard Geography Data Layer ID US.Places Area Name Redlands city Area ID 0659962 (Census-designated Place FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) State Name California State Abbrev CA -------------------------------------------------------------------------------- Standard Geography Name ZIP Codes Standard Geography Data Layer ID US.ZIP5 Area Name Redlands Area ID 92373 State Name California State Abbrev CA -------------------------------------------------------------------------------- Standard Geography Name ZIP Codes Standard Geography Data Layer ID US.ZIP5 Area Name Redlands Area ID 92374 State Name California State Abbrev CA -------------------------------------------------------------------------------- Standard Geography Name Counties Standard Geography Data Layer ID US.Counties Area Name 06071 (County FIPS Code: http://en.wikipedia.org/wiki/Federal_Information_Processing_Standard) Area ID San Bernardino County -------------------------------------------------------------------------------- ... View more