User`s Guide
Contents
1. Bhp Pen Slang Sep ese ny St 2 Levels Proven reve Ona Spada Step neat Step 2 Unt Conia Faia 77 Guan Sep S Prev D Introduction Urbaninfo database system with the following properties User finaly interface for hassle free navigation Online data access and query Grouping bar in dala view to better organize and analyze data Enhanced Table wizard features Aggregate function more options for cross tabulation Enhanced Map Wizard fealures Options for Dot density and chart theme label nudging inset and exporting to raster mage Reports feature to toro report templates and apply ready to use report formats across databases Content Overview This guide contains eight chapters an appendix and an index I provides a step yop explanation for querying data and generating reports Key stops have been graphically ilustrated to help you better understand Urbaninfo 2 0 and etfecively use It in achieving your work objectives Chapter 1 Getting Started outlines the systems requirements and installation procedure Chapter 2 The Homepage introduces the opening page of Urbaninfo 2 0 and telis you about diferent ways of accessing data Chapter 3 Searching Data explains the steps in querying data using key parameters Indicator Time and Area Chapter 42. Click isto access and uso shape fles Replace Base Layer with an exlernal layer Create Buller zones around the line or point layer The buffer window lls you modiy he buller settings LIE Click on the toxt box below Name to the namo Click and the area lor butler coverage in the text box under radius Click on the radio button next to Layer fo choose the layer lo which you want lo apply the bullering Click on radi bullon next to Customize la create your own bullering You can choose point layer or ine layer Irom the dropdown list Click on the txt bar under Target lo choose any particular layer from the drop down list where you want to apply the buller Create Inset ol specific sections ol the map The inset images placed along with the main map flo You can view them in Step 4 The Insel panel Fig 5229 lists the insets thal you have created Note por perd Check the box lo the of the Inset namo to make the inset visible X Overlay the thematic map on a raster image The image is super imposed in NASA s WorldWind application Create Time Series maps lor all lime periods available in the data A Time series Fig 5 30 appears at the bottom of the map preview FEET juae a ai Most recent tab displays the latest data Auto Cycle tab lets you view animated map for alltime periods in sequence A
3. menu Minimum Navigation Bar emer PowerPoint Presentation xx preseriaon 30 preview a wizard s Search Selection Smooth Sort H Source speakers Standard Deviation 29 sive Subgroup ss n Subtitle Subtotal 2 A Support Suppress Duplicata 33 System Requirements 771 theme E Theme Time n Time Period Time Series Bar 7 Toggle Pane H Tool Bar H Tour Transform Unit Viewing Viewing Sources Viewing Subgroups Viewing Usi
4. and for the base table used to create the raph Fig 540 Check the bax to the left of Sort by Data Value sort the table on the data values ofthe frst column You change the order of soring by clicking on the arrow button nest lo the checkbox Click Next to start the process speclying the graph type Here the graph wizard lakes ver and t you chose the fret pe and ings Step 3 Stop 3 the Excel chart wizard prepares a graph based on your inputs You now preview tho graph as a MS Excel workbook Fig 5 11 Te peer ca eta Graph sheet deplays the chart Table sheet displays the table used to generato graph Data sheet displays data on which he graph ls based Source sheet displays the dala sources and the current database Hera you make luther changes to the graph Click Next to proceed to Step 4 Step 4 the final step in DES M fea veg Creating Maps Note The map wizard lets you link data o geographical units to create thematle map Tho map helps you effectively visualize data and communicate information on development trends within geographical areas countries regions etc or administrative units sub national It includes advanced functions for perlorming geo statistical analysis You can create a wide range of thematic maps using gradients colors
5. menu is available on the pages It has the allowing sub menu options Open Database Summary Report User Preferences You can uso this option o open a database You can open an database available on tho local computor or an online database available an the web Database Summary Report You can uso this option to generate a comprehensive summary of tho database a one step process and provides you with useful summary documentation of he database that can be fled future reference Tho report is gonorated as MS Excel workbook with worksheets for various database elements Fig A2 Summary Provides the following database information Name Date creation and tomplato namo I gives a total count oc data records Indicator Uni Subgroup 145 Area Time period Source Language Sector Goal Thame Framework Institution and Convention Indicator Lists Indicators in the database Indicators that are and have metadata Unit Lists all Unis inthe database Identlles Units that are global Subgroup Lists subgroups identifies subgroups that are global HUS Lists al LU Time Period Lists Time Periods Area ists Area Names Area IDs shape Area level level drills Areas hat aro Provides Dalo End lor eae Sector Liss Sectors
6. Page Option Bar Displays available options forthe elected page In figure 1 page options forte Indicator page sector Institution and convention aro displayed inthe page option bar Tool Bar Displays buttons that help you achieve specific tasks Buttons that are active for the page appear in color while the inactva buttons appear in grayscale Dopen the window to select a diferent database print he contents ol the selecled pane o POF Ef Export the contents ol the selected pane into the folowing flo formats MS Excel Spreadsheet ss Comma Separated Value csv Portable Digital File Hyper Text Markup Language him and eXtensible Markup Language xm In the data view you can also export o a Database mdb or to a data entry spreadsheet format PP Opss the Information window and display metadata lor he highlighted lament i Toggle Pane View between horizontal and vow or he keyword mentioned In the text bar The elements matching the search eta played avalale pane 9 he Sort window to choose tho sot records in the data view screen records inthe data view sents and sort order for soring 5 gl ri Tho table below presents a chockist ol tho tools availabe for ach page Page Teor distr ime Area LJ Y Y Pane Header The Pane header identifies the pane c
7. ther of the values the interval limits do not got recalculated The discontinuous method is very uselu o group data values that are widely dispersed The delaul values are displayed in text boxes below Minimum and Maximum You can set the Minimum and Maximum range value lor tho data set The values pected here inluence the method of break Speclly the decimal precision inthe text box below Decimal The upper and lower of he breaks are sensitive the decimal range the data values can fall in one break the other depending onthe decimal places The High is good option lets you apply the reverse color scheme for indicators thal measure the love of the negalive factor For instance the Indicator literacy ral has an inverse relationship with When you are deciding the breaks lor such indicators you set Ine high is good option o No to apply ho color scheme in reverse order Wire Click Apply to apply the number and method ol break spocified above The bottom portion ofthe window gives a preview ofthe break ranges counl and color applied each range You can adit the Legend labels by clicking on the textboxes inthe legend column You can change the color for any data range Click on the Color tab lor a range lo choose the desired color Irom the color window Click Next to proceed lo Step 3 Stop 3 Stop 3 you can specify the grouping criteria forthe data rows
8. Fig 2 2 The Offline tab window cts databases available in the default location on your hard disk To select highligh the desired database trom tho list and click OK Led o browse and select a database a desired locaton To select an Online database Click on the Online tab o view the Online window Fig 2 3 lt Click on the down arrow and select any online connections available rom the drop down list The ist ol databases available on the speciled server is displayed in the window Highlight he desired database and click OK CHAPTER MH Data Parameters nore There throo data parameters that defino the data value indicator Time and Area Those parameters help you to query the database and generale a Data You then prepare a Table Graph or a Map You can select the parameters any sequence You can choose to modify the parameters al any time Tho process of making and deleting a selecllon is similar for all the parameters Selecting Data Parameters Note fap sheave DO Selecting Indicators You can select Indicators from the Indicator pago In the hame page place the mouse pointer on Eland select Indicator from the data menu Notice that the indicator page is divided into three panes Fig 21 Drip Note E lesen oe peras Ew The let pano displays the tree view ol the Indicator Classifi
9. Step 1 Indicator 1 Stop 1 specty the Indicator for which you want to transform the uni Fg 825 solect double click on the indicator inthe Avaliable pano The Indicator appears in tho Selected pano Click Next to proceed to Stop 2 Step 2 Unit Conversion Factors In Stop 2 specty the conversion factor and the target unit Fig 8 26 Enter the target Unit inthe text box below Target Unit Enter the factor ol conversion in he Conversion Factor column The source unit vill be converted into the target unit based on the conversion factor Click Next to proceed to Step 3 Step 3 Save As In Step 3 provi the Indicator Ciassificaion details Fig 8 27 Enter Sector Classification detalis in the Sector window Highlght tha Sector or sub sector lor classifing the indicators Notice thatthe Uni reflects the now unit mentioned in Step 2 Click Next to proceed to Stap 4 Step 4 Preview Calculation In Stop 4 you can preview the calculated values Fig 8 28 LEGE in 4 eee ny m i fitit Step 5 Preview Data Entry Spreadsheet In Step 5 you can preview the Devinto data envy spreadsheet with he calculaled values Fig 8 29 Click Finish to save the calculated data a now database User Defined Formula The User Detined Formula option provides a method to perform a calculation the data
10. arrow to reverse the sort order Click Next to proceed to Step 5 Steps Stop 5 you can specity the lormating style forthe table laments 9 55 To apply style theme click onthe tex bar below Format and choose a style theme from the drop down You can further the theme settings highlighting the formating elements in the Item pane and modiying the settings To create a custom theme click on New enter a theme name in the pop up window and click OK The theme name wil appear in the Formal bar Select he custom theme from the format bar to madly the formatting Click on the toxt bar below Font Name to select the desired font from the drop down list Click onthe txt bar below Font Style to choose from tho stylos available inthe drop down list Enter the size inthe text box below Font Size You can also use the arrow butions te scrol to the desired font size Click on the color tabs below Font Color to the font color Click on the color tabs below Background Color to madly the table background coor Check the box to the af Show Border line to make the grid outline visible for the lable Uncheck la hide grid nes Click Delete deloto existing format theme Click Save to save the formatting changes to the selected format theme Click Next to proceed to Step Step 6 In Stop 6 you can preview the effect of tho changes made in Stops 1 through Step
11. 5 The output presented as a Excel workbook Notice that there are worksheets in ihe workbook Fig 5 7 ye pm rue Ver sources Table sheet displays tho table created using the Tabla wizard Data sheet displays the Data View used to creato te table Source sheet displays the list of data sources gives you the name and ofthe curent database Here you can further changes to the table before saving itin the Gallery Click Save Report fo save the 1 5 combinations and table format options as template You can apply these settings on another databace to quickly generale a table Click Next to proceed to Stop 7 Step7 n Step 7 you can save the table in the Galery Fig 5 8 Specify name for the table By default he table is saved in the presentation older Click Ea browse and save the table at a diferent location Glick Finish to save the table and oxi the table wizard Creating Graphs Tho graph wizard lets you create graphs based on tho data view Click onthe Graph oplon o graph Wizard Creag a graph volves our Powtrexmr 00 Stepl Stop 1 you can select tho olomonts forthe X and Y Axis Fig 6 8 Drag and drop elements from the Avalable box o the X Axls and boxes Stop 2 In Step 2 you can the
12. based on a custom formula The Data Fig 8 20 contains expectancy at birth years of some in Aria lor tho year 2000 2005 We can use the User defined formula option lo calculate Expectancy Index using the formula Expectancy Index expectancy at birth 25 85 25 The User defined formula option involves tour steps Step 1 Indicator in Stop 1 ho custom formula n tho formula bar Fig 8 81 Uso the operators available below the Formula Text bar lo form your argument Notice that you can use labels for the ong indicator names in the text bar For example you can use instead ol the long Indicator Tho window below he operators displays the lang indicator Click Next to proceed to Step 2 Step 2 Save As In Step 2 you can provide the Indicalor classlication Fig 8 32 Highlight the Sector sub Sector to classify the now Indicator Specily the Indicator name Unit Subgroup and the decimal places for the data value Click Next to proceed to Stop 3 Step 3 Preview Calculations InStep 3 you can seo a preview ofthe calculated values Fig 8 33 Step 4 Preview Data Entry Spreadsheet Stop 4 provides a preview of Devinfo data entry spreadsheet withthe calculated values Fig 844 Ind APPENDIX Menu Bar Options File Menu The
13. pallems and charts and uso these themes alone on combination You can associate feature layers such as roads and rivers onto the thematic improve its visual impact You can overlay the thematic on three dimensional globe a rast image depicting regions and landscape Making map in the Map wizard involves ve stops Click onthe map button in the data view to activate the Map wizard When you open the Map wizard it automatically apples a default color schema fo data values ol the selected indcalors and generates map preview Fig 5 13 LET Click Next to accept the systom suggested map and proceed to Step 410 proviow the map in Excel modify the map click on the GO box and solect Step 1 trom the drop down 3 Note ay Step 1 In Step 1 you can modily the theme specify the legend tile and decide on the statistical classification method and number ol breaks You can also change the legend text and border color ore default mapping module generates a color theme based on a unique I S combination Click on the text box below Theme select theme from the dropdown list the selocted theme click Edit To add a new theme click New You can create a now theme or edil the existing one in the theme dialogue box 3 oe Enter th
14. Available pane shows the map forthe node soloctod inthe area tree The map toolbar inthe Available pane helps you to achieve folowing tasks mouse to pointer mode Point and click on Area to select area The selected area highighted and appears in tho selected pane vien ul extent of he map agni the selected area tothe pane extent Zoom in by a fixed magnitude Zoom oul by lied magnitude Pano on the map Label Area Name on the CHAPTER Viewing Data The Data page lets you view the data records ofthe selected database You can view all the records inthe database or view limited records trom the database by specifying the data parameters Indicator Time and Area The steps Involved in solocing data parameters are discussed in Chapter 3 page 19 24 The Data page contains nine page options Fig 4 1 View Displays data records I Includes following data elements Time Period Area 10 Area Indicator Data Value Unit Subgroup and Source Source View the sources avalable and those selected forthe data view Here you remove add new dala sources Unit View the Units avaliable and those selected forthe data view Here you can remove or add new units Subgroup View the subgroups avaliable and those selected for the data view Here you can remove add new subgroups Sialisics View basic statistics lor ho
15. an approximate reading ofthe ent ol ho thematic map that you are viewing np prre E Layer Panel The layer panel displays the shapefile ol the base layer and tha custom layer Base layers aro represented by plain icons vain layer legend where as Feature layer and Custom Layers are represented by colored icons v Oreprosonts Polygon shapefiles Common examples of polygons are administrative boundaries lakes and national parks Polnt shapefiles Common examples of points are hospital and service centors Line shapefies Common examples ol nos aro rivers networks and roads Click on the button to the leto th feature or custom layer to modify the layer settings For a Polygon layer you can set fil color transparency and fll style You can also change the border color border syle and border width Fora Line lay you can change the border color border style and border width For a Point layer you can change the marker color markar style and marker size Ordering ofthe layers affects Ino map display as the layers are rendered in a bottom fe top sequence Highlight layer and use the layer toolbar right click menu options to ha layer order Fig 5 23 f a e O UC MR un 2003 V von un 0958 To move tha highlighted layer up by one stop dic Label wove Up Move DX Zon In 5 Layer Setti
16. and associated sub sectors and linked 141 combinations Goal Lists tho Goal too and I U S combinations associated to tho lowest level of each node Framowoik List ofthe levels in tho Framework and 40 8 combinations associated at each Institution Lists Institutions in the Framework and I U S combinations associated al each level Theme Lists Themes in the Framework and 0 5 combinations associated to each level Convontion List levels in the Convention and 141 combinations associated each leva Source Lists Source tree and 1415 combinations assacialad lo the source Template Log Log of action taken on the template with Dato and Timo stamp Identities the user Database Log Log of actions taken on the database with Date Time stamp the user User Preferences You can modify the display of DI 50 User Preferences window Nols that here are six tabs in User Preference Fig ti aer Ss E General Product Path Displays the path ol application root folder cannot be Product Name Displays product nama as It appears in the icon label withthe product you can only view without modifying Auto Select Fier Option Check tha box to select the Filter he box is unchecked the program wil prompt you to manually the
17. data records Counl Rango Mean and Standard Deviation Calculate Perform calculations on the records tho data view Percent 100 Minus Composite Index Subtotal Transform Unit and User dalined formula Tho Calculate options are discussed in delall Chapter 8 78 110 Table Open to Table wizard and create a table presentation Graph Open the Graph wizard and create a graph presentation Map Open tho Map wizard and create a map presentation Ar precem I Data View generate data view click on the Data tab in the navigation after solecting the data parameters Indicator Time and Area Notice that there are eight columns in the data window Time Period Area ID Area Indicator Data Value Unit Subgroup and Source Fig 4 1 i i D You can use tho right click menu option to expand the subgroup column and view the subgroup categories Subgroups are classified under four categories Age Sox Location and Others Data records count displays the total number of records checked Natice that the data records have a checkbox othe of each record Uncheck the checkbox to remove the record rom the data view The dala records that you have removed WII not be considered while generating table graph or map To make the doleted record avallable cick and select Reset in the lar window Data Page Navigation Bar When you have a da
18. equal 100 Check tha colin the column High Is Good lor Indicators whare a higher value is better than a lower value Uncheck the lor Indicators for which reverse is ue In the above example uncheck the box for Indicator Proportion of population below 51 PPP per day Click Next to proceed to Step 3 Step 3 Save As In Stop 3 you can specily the Indicator Classification Select the Sector and sub sector lor classilying Indicator Fig 8 18 Speclly the Indicator name Unit and Subgroup in the respective text bars Speclly the scale lor the index under the Scale Min and Scale Max text boxes Far Instance you can prepare a composite index on a scale ol 0 lo 1 or 010 100 Clck Next lo proceed Sup 4 Step 4 Preview Calculations In Step 4 you can preview Ihe calculations performed to generate the composite index Fig 8 47 1 1 iti m x Click Next to proceed to Step 5 Step 5 Preview Data Entry Spreadsheet you can preview tho data entry spreadsheet wih the calculated values Dus Ene rics Click Finish to save the Index in a now database Subtotal The Subtotal option lets you to create subtotal data values from a lower to a higher level ol geographic areas example this can be used lo generale sublolals al the rational level based sublot
19. ho minimum dala value or a given 0 combnaton am Maximum Displays the maximum data value for a given 1415 combination 85 Mean Displays the simple arithmetic mean forthe range data values lor a given US combination Standard Deviation Displays the standard deviation for given US p combination CHAPTER Presentation Wizards Urbaninto 2 0 has presentation wizards to help you prepare professional presentations and reports The wizards guide you through a series steps to help you decide the content and style ofthe output Tho output i saved along with the data sheet and data You can use the wizards to produce outputs in three formals Table Graph and Map Table Helps you prepare and save a Table presentation in seven steps Graph Helps you prepare and save Graph presentation in four Map Helps you prepare and save Map presentation in steps Creating Tables re Before creating a table make sure the data view contains the data that you want lo present as a table Click on the Table button in the Data Page Option bar lo activate the Table wizard Tho Table wizard involves seven stops Steps 1 through Stop 5 allow you to the row and column seltings and able formatting Step 6 gives you a preview of he table Stop 7 lets you the table namo and save iin the gallery When you open tho Table wizard automatically applies a default settin
20. ofa systematic format or structure Common frameworks are DFID s sustainable livelihoods framework and IFAD s food security framework Theme indicators are grouped on the basis of broad perspective Common themes are Poverty Gender In Source indicators are inked agency producing data the particular indicalor Common sources are Government Non goverment agencies etc In Institution indicators ara liked to Organization Common Instiulons are UN International NGOs Government c 1 Convention indicators are classified the basis formal UN multateral negotiated with large number ol states Common Conventions are Child Fights Convention Convention on Blo Diversity and Vienna Convention on Law of Treaties Selecting Time Period Click on the Time Period tab inthe navigation bar to access the Time Period page you can select the time perodis for generating a data view Notice that the ime period page has twa panes Selected and Avaliable Fg 3 2 Er To select one or several ime periods drag highlighted time periods the Avalabie pane lo Selected pane use other methods ol selection as explained on page 11 To remove a lime period the Selected pane highlight ma period and alek or uso other methods ol deleting a selacton as explained on page 11 Click on the column header of available or selected panes to sort the ime
21. periods Selecting Areas Click on the Area tab in ho navigation bar to access the Area page and select areas Here you can select the geographical areas for genarating the data view you have made a selection for Indicator Time Ine data records for the chosen areas for the selectod Indicaloris and Time period s displayed in the data view Arp E Note Notice thatthe Area page has page options Name and Fig 3 3 You select areas either by thelr namo or on a map Selecting Area by Name The namo pago is divided into three panes Area tree Avaliable pane and Selected pane pap Cee aA L p The left pano displays the Area tree Click on the area or on the ol the to reveal Ino sub levels of a given area For example you can expand the nodo lo reveal tho countries in The areas under the highlighted nodo are displayed in the avalable pane The available pane lists the Area namo Area ID and the level at which the area exists Select areas to generale the data based on the selected areas select drag an area from the Available pano and drop itin the Selected pano or use other methods of making a selection as explained on page 11 The area appears in tho Selected pane Selecting Area by Map Click on the Map tab In the page option bar to the map window Fig 3 4 Bw In the Map view the
22. places Click Apply to implement the changes You can view the changes in range values in the columns below Fig 5 14 Legend column displays the legend name Clek an the default name to customize D From column displays the minimum value included in the range To column displays tho maximum value Included in the rango Be Count column displays the number of areas included in ach range Color colum shows the color scheme applied for each range modily he color cick on the color tab and choose the desired color the color window The row of Missing Data sts the count ol areas that were selected in the Area page but do nol have a data value available You can choose the color lor tno missing data areas by clicking on color tab Click Smooth to create color gradient trom the first to last color ol the rango Choose the color of the first and last range to apply color gradient fr he in between ranges You can also change the Border style lor the geographical areas onthe color tab below Border to change the colar for the boundaries Click on the Border outline box to choose the desired border from the drop down ist To change he border thickness cick 19928 mo arrow buttons let you specily the thickness You can save the changes made the number ol breaks break logend and the legend color cies Seres Jio save he changes cl open ag
23. tab is created for every timo period for which data are displayed in the data amp Croate Area serles maps all available levels of area in the data view series lab Fig 531 gets appended to the map preview All tab ets you view the levels one Auto Cycle tb les you view animated map for each Area level in sequence A tab is created for each level of area Click Next to proceed to Stop 4 Stop 4 Stop 4 you can previow the map in MS Excel format E The Excel workbook Fig 5 32 includes spreadsheets of the data view and sources Click Next to proceed to Step 5 Step 5 In Step 5 you can provide name for the map presentation thal you created default the map is saved in the Gallery Clck o save the map at a desired Click Finish to save tha presentation and exit map wizard CHAPTER MH Gallery Urbaninfo 2 0 uses the Gallery to manage the Table Graph and Map presentations created in Urbaninio You organize Ine objects in dillerent folders under the Gallery and iranster the objects dieclly into MS PowerPoint To activate the Gallery de one ol the fllowing Inthe Homo place your mouse pointer over and cick Presentations in the Gallery menu Fig 6 1 Click on the gallery page tab in the navigation bar Sens LOL objects in Gallery Notice thatthe Gallery window is
24. Poe e mouse pron buon ieee er open HEBES 22 31 13 a Information menu has two options Product and Organization Product Opens the datault internet browser and displays information about DI 5 0 Organization Opens the internet browser and displays information about the UN Data monu has four options Indicator Time Area and Data Indicator Opens the Indicator page and lets you view and choose indcalars Time Opens the Time page and lets you view and choose time periods Area Opens the Area page and lets you view and choose areas Data Opens the Data page and lets you view data You can choose view all the data records in the database or generate a data view based on indicator Time and Area selections Gallery has two options Presentations and Images Presentations Opens the presentation folder in gallery and lets you view 0150 presentations Table Graph and Map Images Opens the Images folder and lols you view the images appearing inthe flash animation 21 Help menu has tree options Content Tour and Support Content Link lor he p l fle of he Users Run Urbano our Support Opens ine default mall cont win the Devinfosuppor address in bar 80 others Displays any additional ink To open a database File Open Tho Open Database window appears Notice tat there are tabs Online and
25. UrbanInfo 2 0 UN HABITAT Acknowledgement UN HABITAT has been a pioneer organization in the collection of urban indicators In 1991 the Agency initialed the Housing Indicators Programme focusing on monitoring shelter performances In order 10 address on a larger range of urban issues the Housing Indicators Programme evolved into the Urban Indicators Programme UIP in 1993 Since then UIP has produced two main databases in 1996 and 2001 Global Urban Indicators Databases 1 and Il presented at the Habitat IL and Istanbul 5 conferences which helped establish regional trends in key urban issues In 2005 UN HABITAT produced the Global Urban Indicators Database thal in addition to addressing Habitat Agenda key issues provides information on the Millennium Development Goals particularly Target 11 the improvement ofthe lives of slum dwellers Data for the Global Urban Indicators Database II was collected from different sources ational censuses Demographic and Health Surveys DHS Multiple Indicators Cluster Surveys MICS other national household surveys and other sources Jn response to the demands of data users UN HABITAT initiated Urbunlnfo in 2004 a user friendly software prepared on windows platform Urhanlnfo helps in storing presenting and analysing indicators through a variety of presentation tools such as tables graphs and maps The fist version of Urbanlnfo contains information on Urbanlaf 2006 versio
26. Viewing Data introduces options to customize the Data view You learn io use statistical options and get more information from the Data view Chapter 5 Presenting Data explains the stops in creating professional output using wizards Table Graph and Here you can lo use advanced wizard options Chapter 6 Gallery takes you through the stops in viewing tables graphs and maps inthe gallery Leam lo create a PowerPoint presentation in the Gallary wizard Chapter 7 Reports outlines the steps applying report templates to diferent databases Chapter 8 Calculate Calculate wizard takes you through the steps in using the utilities in the Appendix 1 explains he menu bar options inthe home page of 20 User Interface The Urbanlnfo 2 0 Interface includes diferent loo bars and buttons to help you navigate the application typical interface includes the folowing elements Navigation Bar Displays he page tabz in Urbanlnlo 2 0 There are sb tabs ln tho navigation bar Indicator Time Area Data Gallery and Reports Click on a tab to display the corresponding pago You can to desired page at any point of ime by clicking on the respective tab There are two buttons on the Navigation bar a Opens the User Preference window where you can modify display options It BN Home allows you to access the home page from any page
27. a Chart theme To create chart heme clek The theme window lets you chart display options Fig 520 ick on the text under Legend Till to specily fr the legend Check on the box to th left of View Data Value lo display the value for each bar Uncheck to suppress the data value Click and drag the slider below Chart to modily the size of ho bar default bar is created for each subgroup associated withthe selected 272 Check the box to the left Subgroup lo display the subgroup on the map Uncheck the box suppress the subgroup Click onthe color tab next to each subgroup lo change the color lor each subgroup bar Aer deciding on the themes clck Next to proceed to Step 2 Step 2 Step 2 you can add a tle subtle and disclaimer You also the font ile lor various map elements Enter the inthe text below Enter the map subtitle inthe text bar below Subtitle Enter the disclaimer in the to below Disclaimer choose from avalable style themes click on the text bar bolow Template and select a theme from the drop down list add your custom style theme cick New Entor a name forthe new style theme and make tha desired changes 10 tha map elements listed in tho pane The pane lists the elements of the map for which you modify tho style format Highlight an
28. als lor tne sub national level This option may be used to subtotal census data in soma cases nm gi Tho Data Fig 8 19 contains the Internat Users in numbers We can uso the Subtotal option to generale data for Users in numbers for each continent Tho Subtotal option involves four stops Step 1 Indicator Yn Ste 1 Select he ideato whieh you wart o clita subtotal 69 1 Step 2 Levels In Stop 2 you can speclly the level for which you want to generale the subtotal figures Fig 6 21 Notice thatthe lavo above the current level o data is available in window Click Next to proceed to Step 3 Step 3 Preview Calculations Step 3 provides a preview Fig 8222 ol Ihe calculated values Step 4 Preview Data Entry Spreadsheet 1 Stop 4 you can preview the Dovinfo data entry spreadsheet wilh the calculated values Fig 8223 Transform Unit The Transform Unit option allows transforming a Unit by a multiplier For example his option can be used to change Thousand to millon or number to c oe ERE Fg 24 Dua ve of source dear Tho Data Fig 8 24 contains the Internat Users in numbers for Countries Let s use the Transform Unit option to generate data for Internet Users in housand The Transform Unit option involves ve steps
29. and the sequence tthe column arrangement Fig 5 4 Check the bax othe left Classification Arrangement to group the data rows by Indicator Classification C categories You can choose trom the seven ICs Sector Goal Framework Theme Source Instution and Convention Highlight the IC type in the loft pane to the availabe categories in the Classification select pano The check boxes 1o the of each classification help yeu control the of the classilying crean in ihe table For example to organize the Indicators by the MDGs highlight Goal the IC pano and check the box othe of Milennium Development Goals in select window The Indicators willbe grouped as par the MDGs group the indicators by MOGs and the respective targets enter 2 the text bar above the Classification select window Check tho box to the lelt of Column Arrangement to change the order in which the columns appear inthe table Cick Next lo proceed lo Step 4 Step 4 1 Stop 4 you can the sort order forthe elements in the table Ntice thal the Sort window has panes Avallable pane and Selected pane Fig 5 5 Along with Data Value the Avalablo column lst the elements lected inthe cows box in Stop 1 select an element lor sorting drag and drop the element trom the Available pane tothe Selected pane The arrow pointarbelora the elament gives you the sort order Click on
30. ble click on the Percent There are steps Percent option Step 1 Numerator Stop 1 speclly the numerator to calculate the percentage The numerator should b Nel ODA to LDCs To select the numerator double click on the indicatori tho Avallable pano The Indicator wil appear in Selected pane Fig 8 3 Click Next to proceed to Stop 2 Step 2 Denominator Step 2 select the Denominator to calculate percentage The denominator should be Nel ODA To select the denominator double click on the Indicator in the Available pane The Indicator wil appear in the Selected pane Fig 8 4 Click Next to proceed to Stop 3 Step 3 Save As In Stop 3 you can to save options new indicator Fg 85 Select the desired sector sub sector trom the sector window to classy the indicator Click on the text box below Indicator ta enter indicator namo You can also choase trom the drop down list Emer the now unit inthe text box below Unit Cle text box blow Subgroup o speci he subgroup You can also choose subgroup from the drop down list the decimal places that you want to present your data value ln the text below Decimal Click Next to proceed to Slap 4 Step 4 Preview Calculations In Stop 4 you can preview the calculations in a excel sheet Fig 8 6 Tho sheet displays the calculatod indicator for all the areas
31. cation IC method The IC type is displayed in the pane header The detault IC type is Sector Click on a Sector or onto the leto he sector to display catagories defined under the sector Highlight a category display Indicators inked withthe category in Avalable pane Select or several indicators to generate a data view To select drag the highlighted indicator the Available pane and drop in tho Selected pane or use olher methods explained on pages 11 The indicator appears inthe Selected pano default the Avalable pane displays the Indicator Unit Subgroup 4115 combinations Clck 8 7 8 to view only indicators Click onthe button to revert lo the HU S Click D in tha sector pane to Auto Select indicators in tho sector pane for which data is availabe Click D in the Available pane to Auto Select all indicators in the Available pane for which data is availabe remove indicators from the Selected pane highlight the indicators and click 1 or use other methods explained on pago 11 Indicator Classifications Indicators are classified under o types In Sector indicators are classified on the basis ol heir unctionally Common sectors are Health Education Demography ale In Goal indicators are organized on Ie basis of an agreed purpose or objective Common Goals ae the Milennium Development Goals Tho Habitat Agenda Goals ete In Framework indicators are organized on the basis
32. database system consists ol the following elements Indicator Time Period Geographic Area Subgroup into four categories Sox Location Age Group and Others Unit Source Data valu The systom provides access to Indicators organized by sectors goals themes and other data management schemes Urbaninfo 2 0 is integrated with Microsoft ffe for easy presentation data in tables graphs and maps System Requirements The recommended minimum hardware requirements to install this sotwaro are Pentium IV 512 MB ol RAM 1 GB ol free hard disk space Display resolution 1024 x 768 Windows XP Mierosoll Olice XP Microsol Intemel Explorer 6 0 Installing Urbaninfo 2 0 To install this software application on your computer follow the steps given below Inger Urbaninfo 2 0 CD inte the CD ROM drive Wait for auto run to open the setup screen Follow the instructions on screen to complete the setup Double click on the desktop to start the application set up program does not load automaticaly Choose Start Run where dis the letter ol your CD ROM drive and press Enter key Follow the instructions on screen to completa setup Double click tho desktop o start the application CHAPTER The Home Page Thsis ha home page of Urbano 20 Nace he home page has a column animation Fi 21
33. default set by the program and nol be unchecked Note Chock the bax to the of the Show Unit and Subgroups item ta show the Indicator Unit Subgroup grouping Uncheck it to view only the Indicator Data The Data tab lels you select the elements and view order in the data pago of Devinlo User Module Fig To seloc drag and drop elements from the Avaliable pane tothe Selected pane Click 58 to change the order in which you want the elements to appear in the data entry module Chock the Data View Alternate Row Color box to viow the alternate rows dillerant color Clck an the color lab to change the delaul color scheme The Map tab les you change the detault map colors lor the four default breaks of map wizard Fig A 7 B nel SST FEAT Define the first and last color and click on Smooth button to graduate tho color shades for tha middle wo colors Sound Tho Sound tab ots you choose the dolault sound that plays when the DI 5 0 is active Fig Click on the Sound box and choose the desired music fles rom the drop down list o browse for music Irom other locations Click to enable or disable the background music Exit Click the ext button to DI 5 0 You can also use the keyboard shortcut mentioned tothe right ofthe exit button Help Menu The help men
34. der he fllowing location CADevinfo evita 0 Reports Click 8 to import report formats trom a desired location Click export reports to a desired locaton Tho report are stored in format to delete the saved reports Highlight the window and click to match the I U S combinations in he report with those ofthe database that you have selected The result ofthe matching process is displayed in a MS Excel Worksheet Fig 7 2 Shee Fore Ogee ae eo aaa Mu SERERE tut hts ah Pl ng Pee Sn then Pret rg ae Say Bonn hr uh Proce png Rem RUN um Pct aut dha uh gare nt fuss Prec SF o Bent te e Pow an porto The fist section ol the report shows the list ol Indicators present the report well as in the current database The second section shows the LU S combinations present in tho report as wall as the currant database Only the matched 144 5 combinations will bo considered to create the table You can choose the level of Area for generating the table Click tho tox ext Area Level and select the desired area love rom the drop down lis Check the box to the left of Data to generate the table based on the data view that You have generated Click OK in the report window t
35. divided into two panos Fig 6 2 The pane on the lets tems avallable in the presentation folder Highlight a presentation object to display inthe right pane default they are stored at the following locaton C DevinfolDovinio 5 GaloryProcontations Click to open presentatin objects from a diferent location Click amp to delete a prosontation the folder Create PowerPoint Presentation You can copy the presentation objects directly onto MS PowerPoint in the gallery folder Click lo copy the selectad presentation object to slideshow The Copy to slideshow window appears Click New inthe window to copy the presentation Into new fle Click Open to copy into an existing presentation Hew Open presentation window spit io hee panes Tho extreme right pane displays the presentation abject PowerPoint Click amp to close the side show window pane CHAPTER Creating Reports The Reports wizard simples the process of creating table presentation in Urtaninto It helps you apply the table formatting options and the L S combinations o create report in table format You can thus generate standard by applying the saved formatiig oplions 1o other databases Click on Reports tab in the Navigation bar to open the Reports window The report window lists formats that you have already created Fig 7 1 By default the report formats are saved un
36. e theme name in the text box below Theme Choose the 0 5 combination or the theme by cicking on the drop down lists below Indicator Unit and Subgroup Next choose trom the four available theme symbols color to data ranges wth derent colors or color gradients Use the color heme present larval data such infant marit rate ec to represent data ranges wih derent patterns Use Hatch to present nominal data such as subgroups malo and emale to represent dala by a numberof dots corresponding othe data Values Use dot densi heme 10 represent absolute numbers tis ellectve 1o Use heme for presenting percentages 8 represent wth a column chan over map elche method o compare diferent values Creato a color theme To creata a color theme cick Click OK to apply tha color theme and close the theme window Click he text box below Legend Title o enter a tte or the legend Enter tho number of breaks thal you want lo use to represent the data values in tha box below Breaks Spaclly the method ol break Click on the drop down list next to the break text box and select rom the four types break options Equal count Equal size Continuous and Discontinuous The breaks are discussed in delall on page 40 The Minimum Maximum and Decimal values are generated from the selected data You can odi these values 0 se custom ranges and decimal
37. element to modify the default style setings far the element modily the font choose the desired fon from the drop down list below Font Name modi ihe font style choose the desired font style Irom the drop down list below Font Style To modity the font size click on the text box below Font Size and enter the desired font size Click Next to proceed to Stop 3 Step 3 Stop 3 you can preview tho map The preview reflects the changes mado in Steps 1 and 2 Notice that Step 3 window contains a vertical panel to the and a horizontal tool bar on the top Fig 5 22 Tho loft pane contains four panols Thome Layer Features and Inset Click on he panel heading or on B o expand and reveal panel options Theme Panel The Theme panel displays the legend for the themes that you created in Stop 1 You can apply a theme from the theme panel Check tho box 10 the left of the theme name Tho window displays of tho theme For the Chart theme and Color themes you can change the color for the theme elements To change the color fr there rango or a chart bar click onthe Color lab tothe ot the range or subgroup respectively For the Hatch theme you can change the hatch pattern for each range Click on the hatch tab lo change the patlor The Counter on the bottom left of tho screon gives you the laitudo and longitude positon of tho mouse pointer also gives you
38. en window Fa 5 16 and chaos tom he opns Check ne bores s he eto Label Color Legend to cick eem Jo any changes made othe deat Create Hatch theme To creato a hatch eme cick B Notice tal Hatch theme has the same in 1 asthe color theme Fig 5 17 The only diference is that in the Hatch theme you can change both the color and the hatch patio change the polygon pattern click on any in the polygon column lo choose the desired pattern the drop down list You can also change the color forthe desired by clicking on the color tab 2155 Click on the txt under Legend Title to specify for the dot legend Fg 518 Click on the color tab under Style 1o open the color pop up window and choose the desired colo Click to enter the desired fon size forthe marker Click to choose a different marker syle from tho dropdown list I you want o use a custom marker click on the drop down arrow below Style and select tha last term from the drop down menu Fig 5 18 You ean modily he font and character by clicking and choosing from the drop down isis below Custom ont and Custom Character respeclvaly Custom Fent Custom le iv p Ee To modi the data value that a dot represents click on tho text bar below Value and enter ha desired value Create
39. for each inthe data Click onthe text box below Indicator lo view and select the indicator lor applying breaks and color scheme To select the number of breaks ontor the desired number ol breaks In the text box below Breaks You can sel a maximum of ten and a minimum of breaks Click on the text box next to breaks select the method of break You can choose from the following types of breaks Equal count Data values are distributed across the specified breaks that each lass interval has aporoximalely same number of areas You can nol change the From and Columns Choose the equal count method you want to divide the areas based on a quantle classification Equal size Data values aro distributed across the speclled breaks that differance between the From value lower cass imi and the To value upper lass limi is the same for all he class intervals You can not change the rom and To Columns Choose equal size the method of break to retain the inherent Variation inthe data values Continuous You can change the value of column On changing the column in one class interval he and columns for all he intervals are automatically recalculated o ensure continuly The continuous method is useful when you wan to manually sol the class limit while retaining the continuity across the class intervals Discontinuous You can change bath tha To and From values On changing
40. fter options every timo you use tha Auto Select Arca Treo Sorted by Area ID Check the box to sel Area ID as dolaull sort option or he area ree Global Color Check the box to assign a diferent color to the global tems Click on the color tab lo open the color palette and assign diferent color Click OK to apply the changes and the properties window Click Apply la save the changes and continue wilh the properties window Click Cancel to discard changes and properties window Language In the language tab you can change the style settings ol the interlace strings Fig LUrbaninfo 20 uses English language Therelore the Name and Source language box have only English language choice Click on tho Font box lo choose the desired fant trom the dropdown list Click on Style box choose the desired style Irom the drop down ls Click on Size box to scroll through and apply available font sizes Indicator The indicator tab lets you select he viewing options for Indicator Classifications Thera aro seven types in which indicators are classified Notice that there are two sets ol icons radio buttons la the extreme lett and check boxes tothe letal no tems Fig Click tho radio button to the left of the ICs to set ias the default view Check to tho left ofthe Cs to display cach tom Uncheck to hide Tho classification by Sector s the
41. g for tho rows columns and other table formatting elements It straightaway takos you to Step 8 ofthe Table wizard Fig 5 1 Click Next to proceed to Stop 7 and save the table in the Gallery withthe default and presentan Il you are not happy with the applied format you go back to Steps 1 through 5 and the necessary changes Click Back to go tothe previous stop You can also click onthe combo box and Select the desired step from tho drop down list Lets start with Step 1 Stop 1 Step 1 you can specify the row and column elements that you want to include in the table You can also choose 1o insert aggregates sum count and mean and categorize the data records Notice thatthe Stop 1 window is divided ino four panos Fig 5 2 Avallable Pane Contains the list of elements that you can select for the rows and Columns You choose tram the following elements Indicator Time Period Unt Subgroup Area 0 Name Age Group Sex Location Others 1 Source Column Pane Displays the elements selected for the columnis o the table Pane Displays the elements selected forthe rows ol tho table specify the elements for tha or column drag and drop the elements the Available pane to the respective panos Aggregates Function Pane Provides opllons for grouping the data records and generating summary stalistcs such as sum count and mea
42. in excel Fig 8 11 12 Click Next to proceed to Slap 4 Step 4 Preview Data Entry Spreadsheet In Stop 4 you can preview the new indicator in the data entry spreadsheet view Fig 8 12 LI Click Finish to save the calculated data a now database composito index s constructed by combining the values of several indicators into one value on a defined scale You can assign weights tothe Indicators and create inn tate The Data View Fig 8 13 shows data avallable on following indicators Literacy rate of 15 24 year olds Percent Female 15 24 Proportion ol 1 year children immunized against measles Percent Tolal 1 Propomion Population below 1 PPP day Percont Total You can uso Composite Index option to combine these indicators and generate one value to reflect hese diflarent elements Step 1 Indicator 1 Stop 1 you can select the indicators that you want to combine to generate the composite Index Fig 8 14 Double click onthe indicators select the Indicalors Next to proceed 1o Stop 2 Stop 2 Weights Stop 2 you can assign weights for each indicator Notice that by default equal is applied to all the indicators Fig 8 15 You can modify tho weight 1o suit the requirements your context Noto that the sum of ho weights should
43. in tho data Click Next to proceed to Stop 5 Step 5 Preview Data Entry Spreadsheet Stop 5 is the last stop ofthe Percent option Here you can view the data entry spreadsheet lor ho new indicator Fig 87 1 Click Finish to save tho calculated data to database The database is stored Inthe following location C DovInfoiDovinlo 5 0 Data folder 100 Minus The 100 Minus option lets you calculate the inverse avaiable indicators For instance if you have data fr the rate you can use this option to lind out he literacy rale The indicator is calculated based on the following xX 100 data value o indicator TI I Eee Fg AS Daa vow saree dears The Data View Fig 8 8 contains Literacy rate ol 15 24 year olds We can use the 100 Minus option fo generate the Adult literacy rate for 15 24 year olds using tha formula X 100 Literacy rate of 15 24 year olds 100 Minus involves four stops Step 1 Indicator In Sop 1 spect he indicator Double clck on the indicator in the Avaliable pano Tho indicator wil appear nho Selected pane Fig B9 Click Next to proceed to Step 2 Step 2 Save As In Step 2 you can the Indicalor Classification Select the sector and sub sector lor the Indicar Fig 8 10 Step 3 Preview Calculations Step 3 you can preview the calculations
44. la view with too many records the data view gets paginated The data view navigation bar helps in managing the data view Page 1 of 2 displays the currant page locaton Bek to goto frst page ol the data view cis the previous data page Dates display the data page goto the ast page of data move to a specie page eiek Hl and select the desired page rom the drop down lit Data Grouping Bar The dala grouping bar helps you to organize the data view To group the data view drag and drop the column headings into the grouping bar area You can change the order of grouping by dragging the elements in the grouping bar and arranging them in tho desired order Drag the grouping element back to the data window to revert to the default data view Data Sort Click to open the Sort window and organize the Data view Fig 4 2 The sort option allows you to spacly Ine and arrange the elements ot the Various columns in the data view as per the sort criterion If you have a data of several pages the sort function is applied to the current page view Fig 42 Page Option Sor You can speciy multiple criteria for sorting To specly criteria for sorting double lick on the element in the Avalable pano The element appears in the Selected pano Click OK to apply the sorting and the sorted records in the data view Data Filter Click fi t
45. n Eno Ome Check tho box othe llt of Aggregate Function to activate the aggregate menu You can select three available aggregate functions Sum Count and Mean lick on the radio button tothe lett of hese options to choose the desired aggregate lunclion You specily the criterion for grouping the data records and applying the aggregate function Click onthe text bar below Groups and select the criterion for grouping Irom the drop down lia Check tho box to the lelt of Suppress Duplicate Headings to any table headings thal have been repeated This option applies for the column headings Far example table contains two indicators with same unis then he units get combined and are displayed in one cel Click Next to apply the changes and proceed to Stop 2 Step 2 Stop 2 you can the tabla tle footnotes and choose to color code the data Fig 53 Click onthe text bar below Title to enter the tablet Click on the text bar below Subtitle to enter able subtle Check tho box lo the llt of Footnote display footnotes Tho footnotes wil appear at the bottom of ho table Bre In Check the box lo the let of Inline to make the footnotes appear inthe along with the data value Check the box lo the lett of Apply Color to arrange the data into breaks and assign color foreach break You can group the data and apply color
46. n 1 of the CD ROM released in June 2006 was the fist of the CD released in this series The product contained the basi software and data on several topics such housing demography communication energy economy education health nutrition and gender The Version 2 of he Urbanlnlo being released now has two basic distinctions from the previous version The new version offers geographic buffering which allows a village level focus and layered maps which show schools hospitals and other public institutions the local development and inthe ease of emergencies Urbano technical team Coordinator Gora Mboup Ph D Database Administrar Philip Mukungu Joel Data Analyst Ezekiel Data Processing Assistant Julius Majale Database Assistant Seller Lucy Pauline Muthoni Peninah Kimani Anne Kibet Send your comments and suggestions ta Urbanlnfo Database Administrator Global Urban Observatory Monitoring Systems Branch P O Box 30030 0010 Nairobi Kenya Phone 254 20 7623057 Fax 254 20 623080 Email guo unhahitaLorg Website h p viw unhahitaLorg Contents Content Oven LL Delon 20 joi in Gay 1 Powerit Presi n 1 s H Step 4 Preview Shp Peo Da ry Si E 3 recen Gu ny Sadie iine Sep
47. ngs Move to Detter one ol the felling Click in the layer tool bar Choose Move Move Up the right click menu option To move the highlighted layer down by one stop do one of the folowing Click in the layer toolbar Choose Move Down trom the right click monu option To move the highlighted layer to the top of layers do ane ol the folowing Click B in the layer tool bar Choose Move Move Top the right click menu option To move the highlighted layar tothe bottom of all layers do of Ihe lolowing Glick in the layer tol bar Choose Move Move To Bottom from the right click menu option Feature Panel The feature panel displays the delauil features associated with areas inthe database The features could bo a polygon or point The Tool bar buttons help you achieve the folowing tasks change mouse to pointer mode ull extent of map to Zoom in frame to zoom selected area tothe pane extent Zoom in by oed magnitudo Zoom out by a ied magnitude Pan paricua location on the map te intormation on the highlighted The information window Fig 5 24 gives you detalls such as Area Id Area Data value Indicator name Unit Subgroup and Time parlo Select to Highlight areas on the map Remove highlighting of highlighted area Zoom to highlight areas Tho map exten
48. ns and their data source The Selected pane shows the data sources forthe I U S appearing inthe data view To include a source inthe data view double click on the source the Available pane The source appsars inthe Selected pane Click on the View tab o view the data for the specified sources Viewing Units Clck on the Unit tab the Units 1o be Included in the Data view Note thatthe Unit tab has Wo panes the Avaliable and the Selecied pane Fi 48 double click unit in the Available pano The unit appears in the Solacted pano Click on the tab o the data or tho specified unit Note ston ae one Viewing Subgroups Click on the Subgroup tab specily the subgroups fr the indicators to be included in the Data view Notice thatthe subgroup window has two panes Avallabl and Selected pane Fig To select double click a subgroup in the Available pane Tho subgroup appears in the Solocied pane Click on the View tab o view data forthe speciled subgroups Viewing Statistics Click onthe Statistics tab to find out basic statistical values lor the U S Combinations included in the Data The Sialistcs tab window displays several stalistical values Fig 4 8 nm TIE Count Displays he number ol unique combination records ER Minimum Displays
49. o generate tho table Tho table displayed in Stop Table wizard Fig 7 3 Click Next to proceed to Step 7 In Step 7 enter the desired name and click Finish 1o save the table inthe Gallery CHAPTER Calculate The Calculate wizard provides you with ullos perform calculations on the data Quoriod trom the database Sometimes the available data are not present in an appropriate format There are six options avallablo in Calculate Fig 8 1 Percent Convert absolute numbers into percentages 100 Minus Calculate inverse indicator values Composite Index Create composite index Subtotal Creato national tals rom sub natlonal dala Transform Unit Convert measuring unt foc the Indicator Usor Defined Formula Apply your own formula on the data records Percent The percent option lets you convert absolute numbers Into percentages Its based onthe formula 100 numerator denominator Lotus suppose we have a data for the following Fg 82 Nel ODA Oficial Development Assistance disbursed by European Countries ODA to LDCs Least Developed Countries by the European countries We want lo find out Net ODA to LDCs as a percentage of Ihe total ODA by the European countries We can use the Percent option lo generate the percentage figure based on the availabe data Click on Calculate in the Data page option bar and dou
50. o open the Apply Fillers window and screen the racords appearing inthe Data view Fig 4 3 As withthe sort option in casa ol a data view of multiple pages In iter option is applied Io dala records in Ihe current page Fg Page Ope Ay Check the box to the lett of Most Recent to itor and view the data for tho most recent ime period far an U S and given area The itor tol has tabs LU S and Data Value Click on the HU S tab to set he minimum and maximum range for each 141 combination The records are based on the specified range The detaul view displays only indicators to view the LU S combination The Data Value tab lets you fiterracords based on the data value Fig 4 4 LD GED LED a TT Daa Value iab Click the txt box to choose fram the folowing options in the drop down lst Between values Greater than spectid value Less than specified value Equal to specified value Click OK to apply the speciled Click Cancel to reject th and exit the filer window Click Reset to revert to the dofaul data Viewing Sources ck on the Source tab in the page option bar to manage the data sources appearing inthe Data view Notice thal the source page is divided inl two panes Fig 45 Em pure 45 Page option Source The Available pano lists tha U S combinatio
51. ontents and displays the count of lems in the pane Status Bar Displays progress of tho action boing processed It also displays system time and dato shows the status of the speakers Displays Offline when a local database is accessed PB Displays Online when a database is accessed from a remote server Making a Selection Selection refers to making the item appear in the Selected pane To s ol the flowing Double click the tem inthe Available pane Click and drag tho rom the Avalable pane and Drop i in the Selected pane To select highlighted in the Available pane Click Din the Available pane header 27 Choose the Select Highlighted option rom the right click manu To select listed in he Available pane Pin ihe Available pane header Choose the Select Al option from the right menu et do one Deleting a Selection Deleting reers to removing the item from the Selected pane delete do ono of the folowing Double click on the tem inthe Selected pane Toremove item s highlighted In the Selected pane Click Selected pane header or 5 Choose the Remove Highlighted rom the ight click menu or 2 Press Delete key Toremove items listed in the Selected pane Click in the Selected pane header or Choose tno Remove All option from the right cick menu CHAPTER Getting Started The Urbanlnto 2 0
52. t covers the highlighted areas df Labels fo swich between displaying and hiding map labels f Label Nudge to view uncluttered labels Drag tho label that you want to displaco A leader ino automatically connects the label with he area Fig 5 25 CEon Label to modly the label thee levels m Abe Tene e men 2 3 ee I Fs Activo Thome level Label setings are applied to ho active color All base layers are affected Active Layer level Label setings are applied tothe active layer To select he layer highlght ayer in he layer pane Actio Selection Label stings are appled areas selected using 8 North pointer ito the map Taide left panel and provide more viewing space Click on again to make the pana visio Add layers such as roads rivers health centers and vilages The Add Layer window Fig 5 27 displays the shape flos available in the database ise I ists ho map flos for each available level Here the map fles are avalable under two levels Continent and County To select a shape tile double click on the desired shape the Available pane Click OK to add the layer and exit the window Click Apply add the layer and select more layers from the window Glick Cancel to oxi the add layer window without selecting any shape
53. u has four elements Content Tour Support and About Suppor Support to forward any queries to the Tho default e mail program gots activated and new e mail message window appears About Gives you information such as Product Name Version Name Logo Copyright nalica and disclaimer information Fg A 9 LakeVictoriainfo 1018010 TIER RN FAR 22202 E al 3 Click System Info lo generate detailed report of the hardware and software setting ofthe comput INDEX 1 100 Minus den Age Group n Agoregates Function 32 Apply Color Selec 16 Base Layers E breaks BI ae Chart Gasciicaton Color as por scheme Column Arrangement 36 776 Composite Index Convention Count Crea Creating Maps Creating Repos Ties Spread Das Filer sata greuping Data page sata Data records coun sta owe Data vaio Dat View m Dot Density doldensiy heme feature pana Filter Framework Gallery Geographic Goal Graph raph ward grouping Hateh hate them Help moro home pape 1 Images Layers Legend Line layer Locaton Map view Maximum Mean Menu Bar
Download Pdf Manuals
Related Search