Home

Urban Info guidelines - UN

1. Fig A 7 Map Define the first and the last color and click on Smooth button to graduate the color shades for the middle two colors Sound The Sound tab lets you choose the default sound file that plays when the Urbanlnfo 2 0 is active Fig A 8 User Preferences General Language Indicator Data Map Sound Sound Default av v mm C ok cance Cay Fig A 8 Sound Click on the Sound box and choose the desired music files from the drop down list Click to browse for music files from other locations Click e to enable or disable the background music Exit Click on the exit button to exit UrbanInfo 2 0 You can also use the keyboard shortcut mentioned to the right of the exit button Help Menu The help menu has four elements Content Tour Support and About Support Click Support to forward any queries to the online technical support of Urbaninfo The default e mail program gets activated and a new e mail message window appears The default e mail id of the UrbanInfo technical support team appears in the To bar 118 119 About Gives you information such as Product Name Version Name Logo Copyright notice and disclaimer information Fig A 9 A bout Devinfo 5 0 Devinfo Version 5 0 5 0 0 6 D evlnfa 03232006 2042 This product is provided with no representations about the software or cantent and ite suitability for any purpose tis prov
2. Fig 8 20 Indicator To select double click the Indicator in the Available pane The Indicator appears in the Selected pane Click Next to proceed to step 2 96 Step 2 Levels In Step 2 you can specify the level for which you want to generate the subtotal figures Fig 8 21 Calculate Subtotal Wizard Step 2 of 4 Levels Joey Subtotal Level Level Name v 1 Continent 2 v Nea Fig 8 21 Level Notice that the level above the current level of data is available in the window Click Next to proceed to Step 3 977 Step 3 Preview Calculations otep 3 provides a preview Fig 8 22 of the calculated values Calculate Subtotal Wizard Step 3 of 4 Preview Calculations Subtotal amp File Edit view Insert Format Tools Data Window Help A 1 Subtotal 2 _3 Module Subtotal 4 Date anc 2008 Apr 14 23 42 08 5 Log File Log Subtotal 2006 Apr 14 23 42 08 xIs 6 7 Eo Internet users 10 ArealD Area Name Total 11 12 OCN Oceania 21803600 13 EUR Europe 42000 14 ASI Asia 2148003 15 AFR Africa 63000 Northern America 15200000 19 l M 4 gt Summary Database Log la Ready NUM e3 v Fig 8 22 Preview Calculations Click Next to proceed to Step 4 98 Step 4 Preview Data Entry Spreadsheet In Step 4 you can preview the UrbanInfo data entry spreadsheet with the calculated values Fig 8 23 Calculate Subtotal Wizard Step 4 of 4
3. Graph Helps you prepare and save a Graph presentation in four steps Map Helps you prepare and save a Map presentation in five steps Creating Tables Mrip Use the filter option to further refine your data view before creating the table Before creating a table make sure the data view contains the data that you want to present as a table Click on the Table button in the Data Page Option bar to activate the Table wizard The Table wizard involves seven steps Steps 1 through Step 5 allow you to modify the row and column settings and table formatting Step 6 gives you a preview of the table Step 7 lets you specify the table name and save it in the gallery When you open the Table wizard it automatically applies a default setting for the rows columns and other table formatting elements It straightaway takes you to Step 6 of the Table wizard Fig 5 1 Wf Table Wizard Step 6 of 7 ole E File Edit View Insert Format Tools Data Window Help v TR X A B C D E F G Fl 1 Net enrolment ratio in primary education 2 Percent 8 Anauilla 9 Argentina 990 10 Aruba 001 11 Bahamas 990 12 Bahamas 2001 13 Barbados 990 14 Barbados 001 15 Belize 990 16 Bolivia 990 17 Bolivia 2001 18 Brazil 990 19 Brazil 2001 20 British Virgin Islands 001 LA e re Table Data Source iie fal 2m Ready NUM Bak stes v Fig 5 1 Table Click Next to proceed to Step 7 and sa
4. Searching Data explains the steps in querying data using key parameters Indicator Time and Area Chapter 4 Viewing Data introduces options to customize the Data view You can learn to use statistical options and get more information from the Data view Chapter 5 Presenting Data explains the steps in creating professional output using wizards Table Graph and Map Here you can learn to use advanced wizard options Chapter 6 Gallery takes you through the steps in viewing tables graphs and maps in the gallery Learn to create a PowerPoint presentation in the Gallery wizard Chapter 7 Reports outlines the steps in applying report templates to different databases Chapter 8 Calculate takes you through the steps in using the utilities in the Calculate wizard Appendix 1 explains the menu bar options in the home page of URBANINFO 2 0 Introduction UrbanInfo Urbaninfo 2 0 is an advanced database management system to keep track of the commitments towards human development It is endorsed by the UN to report on the progress towards the Millennium Goals With Urbanlnfo you are literally a few mouse clicks away from facts that help you to e Analyze data for evidence based decision making e Undertake results based monitoring and evaluation e Link different levels national sub national and regional of planning e Reach out to a large and diverse audience through thematic advocacy This Introd
5. The Item pane lists the elements of the map for which you can modify the style format Highlight an element to modify the default style settings for the element To modify the font choose the desired font from the drop down list below Font Name To modify the font style choose the desired font style from the drop down list below Font Style To modify the font size click on the text box below Font Size and enter the desired font size Check the box to the left of Footnotes to display footnotes linked to data values along with the map Check the box to the left of to display the scale for the map Click Next to proceed to Step 3 60 Mrip Click i to maximize the map window 61 Step 3 In Step 3 you can preview the map The preview reflects the changes made in Steps 1 and 2 Notice that Step 3 window contains a vertical panel to the left and a horizontal tool bar on the top Fig 5 22 rap Wizard Step 3 of 5 Jog koe WuWwOmwmNSX RI d4 imk CON SE m Theme A Wd NER MALE 5865185 32 30742 9424 Km Stp3 v Fig 5 22 Step 3 The left pane contains four panels Theme Layer Features and Inset Click on the panel heading or on to expand and reveal panel options Theme Panel The Theme panel displays the legend for all the themes that you created in Step 1 You can apply a theme from the theme panel Check the box to the left of the theme name The window displays the eff
6. Click to go to the first page of the data view Click to display the previous data page Click 2 to display the next data page Click to go to the last page of data view To move to a specific page click and select the desired page from the drop down list Data Grouping Bar The data 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 the desired order Drag the grouping element back to the data window to revert to the default data view Mrip Use 4 to change the order in which the sort function will be applied Data Sort Click to open the Sort window and organize the Data view Fig 4 2 The sort option allows you to specify the sort criterion and arrange the elements of the various columns in the data view as per the sort criterion If you have a data view of several pages the sort function is applied to the current page view Sort Available 8 D D Selected 1 qoe uw EA Time Period Time Period fii Area ID i Area Name lii Indicator E Data Value fiif Unit i Subgroup i Source Fig 4 2 Page Option Sort You can specify multiple criteria for sorting To specify criteria for sorting double click on the element in the Available pane The element appea
7. 1 00 km Reference Customize Point Layer a m Fig 5 28 Buffer settings Click on the text box below Name to specify the buffer name Click and enter the area for buffer coverage in the text box under Radius Click on the radio button next to Layer to choose the layer to which you want to apply the buffering Click on radio button next to Customize to create your own buffering You can choose a point layer or line layer from the drop down list Click on the text bar under Target to choose any particular layer from the drop down list where you want to apply the buffer M Create Inset of specific sections of the map The inset images 68 Mrip Insets are useful to bring specific areas into focus You can also use insets to visualize time series data Note No map actions can be performed on the Inset Note Raster image is useful to describe continuously varying features such as soil type elevation or temperature 69 are placed along with the main map file You can view them in Step 4 The Inset panel Fig 5 29 lists the insets that you have created V Cambbean Islands V Panama Canal Fig 5 29 Inset label Check the box to the left of the inset name to make the inset visible Overlay the thematic map on a raster image The image is super imposed in NASA s WorldWind application amp Create Time Series maps for all time periods available in the data view A Time s
8. 100 x numerator denominator Let us suppose we have a data view for the following Fig 8 2 Net ODA Official Development Assistance disbursed by European Countries Net ODA to LDCs Least Developed Countries by the European countries UB Urmaninte MDG Info 2005 mdb wees File Ect Hep Urba ninfo Pd indicator ts Time Period I e Aren Ej on e sem bir Reports iH 8 View Source Unt Subgroup Statistics Cacusle Tobe Gah hen Be ee saya UNSD CECD UNSD_CECD J ECE UNSD OECD Cue UNSOED inso cec USO OECD vou UNSD OECD UNSO_CECD xs em s USO cECE cs ISS aior Tol 5D OECD 6282 14 LESS itor ds UNSD_CECD Page of 10 Fig 8 2 Data view of source indicators We want to find out Net ODA to LDCs as a percentage of the total ODA by the European countries We can use the Percent option to generate the percentage figure based on the available data Click on Calculate in the Data page option bar and double click on the Percent option There are five steps in Percent option Step 1 Numerator In Step 1 specify the numerator to calculate the percentage The numerator should be Net ODA to LDCs Calculate Percent Wizard Step 1 of 5 Numerator Joey 100 Numerator Denominator Available 2 D D Selected 1 10 Indicator Subgroup Indicator Subgroup CF Net ODA Total CF Net ODA to LDCs Total CF Net ODA to LDCs Total Sto v Fig 8 3 Numerator
9. Area Name Indicator Data Value Unit Subgroup and Source Fig 4 1 UN Urbaninia MOG Info 2005 mdb i mA Data page options EX 5 n 4 3 Indicator X Time Period e Aren Urbaninfo UNSO UNSO LNICE eetimetas ctal 01 Tod UeDuMKERRddn 00 Eon click to view categories record POT TAA TS UNSD UhIcEF estimates UNSO UNICEF eclimitas AT MN TUDIN ous a ae ney y am tay in Data page navigation bar Fig 4 1 Data view You can use the right click menu option to expand the subgroup column and view the subgroup categories Subgroups are classified under four categories Age Sex Location and Others selected 2207 displays the total number of records checked Notice that the data records have a checkbox to the left of each record Uncheck the checkbox to remove the record from the data view The data records that you have removed will not be considered while generating a table graph or map To make the deleted record available click and select Reset in the filter window 26 Mrip To prevent pagination uncheck the Paging Lines per Page check box in the general tab of user preferences window ZI Data Page Navigation Bar When you have a data view with too many records the data view gets paginated The data view navigation bar helps in managing the data view Page 2 0f 5 displays the current page location
10. Fig 5 6 Grable Wizard Step 5 of 7 Jat3 Format None vi New Delete Item Title Settings Font Name Subtitle Settings Arial v Column Settings Row Settings Font Style Content Settings Bold v Sub Aggregate Settings Group Aggregate Settings Lebel Group Header Settings m6 Legend Footnotes Font Color Background Color lt gt IV Show Border Lines Fig 5 6 Formatting the Table To apply a style theme click on the text bar below Format and choose a style theme from the drop down list You can further modify the theme settings by highlighting the formatting elements in the Item pane and modifying 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 will appear in the Format text bar Select the custom theme from the format bar to modify the formatting Click on the text bar below Font Name to select the desired font from the drop down list Click on the text bar below Font Style to choose from the styles available in the drop down list Enter the size in the text box below Font Size You can also use the arrow buttons to scroll to the desired font size Click on the color tabs below Font Color to modify the font color Click on the color tabs below Background Color to modify the table background color Check the box to the left of Show Border line to make the grid outline visible for the table Uncheck it to hide gr
11. MD amp G Info 2005 mdb Fig 2 2 Open Database The Offline tab window lists databases available in the default location on your local hard disk To select highlight the desired database from the list and click OK Click L to browse and select a database from a desired location To select an Online database e Click on the Online tab to view the Online window Fig 2 3 e Click on the down arrow and select any online connections available from the drop down list The list of databases available on the specified server is displayed in the window e Highlight the desired database and click OK 16 Note The next time the application is opened the database last used gets automatically selected Open Offline Online vne Fig 2 3 Select Online Database Click 55 to connect to a server that is not listed Provide the details in the New Connection window Fig 2 4 Click on the Connection Details box to select type of database from the drop down list Enter the Connection Name to assign a name to the connection Enter the Internet Protocol IP address in the Server Name Enter the Database name of the UrbanInfo database located on the server Enter the User Name and Password to access the database Click Test to authenticate the user name and password on the specified server The program returns a connection successful message after authentication Click Save to sa
12. To select the numerator double click on the indicator in the Available pane The indicator will appear in the Selected pane Fig 8 3 Click Next to proceed to Step 2 80 Step 2 Denominator In Step 2 select the Denominator to calculate the percentage The denominator should be Net ODA Calculate Percent Wizard Step 2 of 5 Denominator Joke 100 Numerator Z Denominator Available 2 D D Selected 1 18 Indicator Subgroup Indicator Subgroup Co Net ODA Total Cr Net ODA Total CF Net ODA to LDCs Total 2 v Cra Fig 8 4 Denominator To select the denominator double click on the indicator in the Available pane The indicator will appear in the Selected pane Fig 8 4 Click Next to proceed to Step 3 81 Step 3 Save As In Step 3 you can specify the save options for the new indicator Fig 8 5 ret Calculate Percent Wizard Step 3 of 5 Save As Joe 100 Numerator Denominator Indicator Classification Sector Sector 3 Economy Debt Development Assistance Employment Income Education v Indicator Percentage of Net ODA to LDCs vi Unit Percent Subgroup Total v Decimals 0 ES 3 v Ne Fig 8 5 Save As Select the desired sector or sub sector from the sector window to classify the Indicator Click on the text box below Indicator to enter indicator name You can also choose a name from the drop down list Enter the new unit in the
13. name and location of the current database Here you can make further changes to the table before saving it in the Gallery Click Save Report to save the I U S combinations and table format options as a template You can apply these settings on a Urbanlnfo database to quickly generate a table Click Next to proceed to Step 7 Step 7 In Step 7 you can save the table in the Gallery Fig 5 8 fy E Grable Wizard Step 7 of 7 Gallery Location C Devinfo Devinfo 5 0 Gallety Presentations Presentation Name Net enrolment ratio in primary education Default gallery location T Fig 5 8 Step 7 opecify a name for the table By default the table is saved in the presentation folder Click L to browse and save the table at a different location Click Finish to save the table and exit the table wizard 46 Creating Graphs The graph wizard lets you create graphs based on the data view Click on the Graph option to activate the graph wizard Creating a graph involves four steps otep 1 In Step 1 you can select the elements for the X and Y Axis Mrip Fig 5 9 Click tit i to prioritize the X Axis and Y Axis elements Gicraph Wizard Step 1 of 4 mex Available Y Axis Q lt 4 l Indicator Time Period Unit Subgroup Age Group Location Sex Others Source Area ID X Axis i d s Area Name Step v Fig 5 9 Step 1 Drag and drop elements from the Available box to
14. 86 EP M aro 672 Lo pane een ea en sam RE t en nee ne ee eee re 87 wii puel PNE RHENO 88 Step 3 Preview Calculations 00 0 0 ceccceesscccccccesssceececccesssseeeeccccessseeeeecesessscseseececesessseeeceeeessseeeceeseeeesneeeees 88 Step 4 Preview Data Entry Spreadsheet esses eene enne ener eene ennt n sienne 89 89710 Wc B 2 P 90 iz em Fal 0 eio PNE meteor ae en E en ene ene nme wane EE Rn 9 Sep 2 Weigh C MMIe 92 SS 5 OO eye 1 a 8 E E EE ee A EE ESEA OAOE ANTT 93 Step 4 Preview Calculations 00 0 0 cece ceccccessccccccccessssseeeccceesssseeececcesesseeececsessseeeececeessseeesecesessseseeeeeeesenaeeeess 94 Step 5 Preview Data Entry Spreadsheet sese eene enne nennen enne enne esent 95 NUI P c 96 SE SMALE EE 10 peter ane eer leu c M MEM DIM I E LII ELA EA 97 vga E c m 98 wieder i i 2 610 zi od meee mr mm 99 Step 4 Preview Data Entry Spreadsheet sss eene eene enenatis 100 APR ce RN MH 101 SIED T MAC 11 eee me nee el vee oe Oe euadere bacc E Ce MEE 102 Sep 2 Unit Conversion FICO ane ne N 103 EPS VO AS a E E ee eee eee eee eer are 104 DiC 4 Freeview C AIC UAT 9 T Em 105 Step 5 Preview Data Entry Spreadsh
15. As In Step 2 you can specify the Indicator Classification Select the sector and sub sector for the Indicator Fig 8 10 Calculate 100 Minus Wizard Step 2 of 4 Save As 100 Indicator Indicator Classification Sector i2 Sector amp Economy f Education Gender Equity Literacy Primary Education amp Environment Indicator Ste2 Finish Fig 8 10 Save As Step 3 Preview Calculations In Step 3 you can preview the calculations in excel Fig 8 11 Calculate 100 Minus Wizard Step 3 of 4 Preview Calculations 100 Indicator G File Edit View Insert Format Tools Data Window Al v f 100 Minus ia B 1 inus 2 3 Module 100 Minus 5 Log File NLog_100 Minus 2006 Apr 14 23 31 27 xls 6 7 Decimals 0 Area Name Literacy rate of 15 24 year olds 100 Minus Subgroup Time Unit Source 914 8 Total 15 24 yr 2004 Percent UNSD UNESCO 847 15 Total 15 24 yr 1990 Percent UNSD UNESCO 838 18 Total 15 24 yr 1989 Percent UNSD UNESCO 8628 17 Total 15 24 yr 1988 Percent UNSD UNESCO 81 8 18 Total 15 24 yr 1987 Percent UNSD_UNESCO 80 7 19 Total 15 24 yr 1986 Percent UNSD_UNESCO 797 20 Total 15 24 yr 1985 Percent UNSD_UNESCO 787 21 Total 15 24 yr 1984 Percent UNSD_UNESCO 778 22 Total 15 24 yr 1983 Percent UNSD UNESCO v jal i nat iin Ready NUM Cinca tek s03 w Cce ten Fig 8 11 Preview Calculations Click Next to proceed to Step 4 otep 4 Preview Data En
16. Ect Hep Urbaninfos 45 mane Sp Toe Pesos e Ekoa E caiey E reme View Source Unt Subgroup Statistics Cacuste Table anh We Ph Y Brac col hear wet hat catum eto grol thie Tina Fetiod ArasD Ares Nema 7004 ASISR a UNSO_UINESCO UNSD_LINESCO UNSD_UNESOO UNSO_UNESCO UNSD_UINESCO iio Unesco UND LNEScO PEE UNSD UNESCO UNSD_LNESCO mede ma UNSO UNESCO v 200 AS F urkmerister beracy oki cog Percent old 15 24 y ISO LINESCC iv 2004 AS Saucl Arabia arasy o3 2 Perce ctal 18 24 yr UNSD_UNESCO vl Selected 476 paio BO MOA Fig 8 8 Data view of source indicators The Data View Fig 8 8 contains Literacy rate of 15 24 year olds for some Asian countries EJ Note We can use the 100 Minus option to generate the Adult Illiteracy cc tais opion tor rate for 15 24 year olds using the formula indicators having percentage as unit X 100 Literacy rate of 15 24 year olds 100 Minus involves four steps 85 Step 1 Indicator In Step 1 specify the indicator Double click on the indicator in the Available pane The indicator will appear in the Selected pane Fig 8 9 Calculate 100 Minus Wizard Step 1 of 4 Indicator 100 Indicator Available 1 5 D D Selected 1 1 8 Indicator Indicator CF Literacy rate of 15 24 year olds CF Literacy rate of 15 24 year olds Fig 8 9 Select Indicator Click Next to proceed to Step 2 86 otep 2 Save
17. I U S view Click D in the Goal pane to Auto Select all indicators in the Goal pane for which data is available Click P in the Available pane to Auto Select all indicators in the Available pane for which data is available To remove indicators from the Selected pane highlight the indicator s and click Xl or use other methods explained on page 11 Indicator Classifications Indicators are classified under seven types In Sector indicators are classified on the basis of their functionality Common sectors are Health Education Demography etc In Goal indicators are organized on the basis of an agreed purpose or objective Common Goals are the Millennium Development Goals the National planning goals etc In Framework indicators are organized on the basis of a systematic format or logical structure Common frameworks are DFID s sustainable livelihoods framework and IFAD s food security framework In Theme indicators are grouped on the basis of a broad perspective Common themes are Poverty Gender etc In Source indicators are linked to the agency producing data for the particular indicator Common sources are Government Non government agencies etc In Institution indicators are linked to Organization Common Institutions are UN International NGOs Government etc In Convention indicators are classified on the basis of formal UN multilateral treaties negotiated with a large number of states Common Conventions are Chil
18. Ld Ld Ld Ld r r r Fr r 40 an M 4 gt n Data Ready mmm mm IE NS Fig 8 29 Preview Data Entry Spreadsheet Click Finish to save the calculated data in a new database User Defined Formula The User Defined Formula option provides a method to perform a calculation on the data based on a custom formula M Urhaninfe Devinfo MDG HDR SOWC SOWP WDR 2004 05 31 12h01 mdb File Edt Hep Urbaninfoa 4 vamo E time Pec Ares Eionn E ces S nes View Source Unt Subgroup Statistics Cacuste Ts bbe Gant Map See pea he PA irsicetor w Mon ms B 2S S 1 Lite exec brih Lite expectancy ot arth 3SBRE Life or yer Lite expectancy at with E Lite expectancy at brih Life expectancy at brih TH Life axpectanc y st brih 3 Lite ex xpectonr en SEBRBB Life expectancy at brih T Life ex ren cy birth 8 TEE Lite expectant yan Life e sxpectanc m l iv iv iv iv ivi vl E vi ui Le v A vj E ira ical vi iv tv Lvl T ea fy fv w SB tory Occu mM a enh EE Life ex SPON Lite ex sean e srh Sue UNICEF sowc 2004 UNCEF_SOWT 2004 UNCEF some 2004 UNICEF SOwC 2c04 UN CEF SC 2004 UNCEF SONE 2004 UNCER SQWC 2004 UNICEF SOME 2004 UNCEF SOC 2004 UNCEF_SOMC 2004 UNCEF_ _ SOE 2004 UNICEF SOWC 2004 UNCEF SOWC 2004 Pegetotd Of Fig 8 30 Data view of source indicat
19. Lists all Units in the database Identifies Units that are global Subgroup Lists all subgroups Identifies subgroups that are global U S Lists all I U S Time Period Lists all Time Periods Area Lists all Area Names Area IDs shapefile Area level and level name Identifies Areas that are global Provides the Start Date and End Date for each shapefile Sector Lists Sectors and associated sub sectors and linked I U S combinations Goal Lists the Goal tree and I U S combinations associated to the lowest level of each node Framework List of the levels in the Framework and I U S combinations associated at each level 112 frip To prevent pagination uncheck the Paging Lines per Page check box in the general tab of user preferences window 113 Institution Lists Institutions in the Framework and l U S combinations associated at each level Theme Lists Themes in the Framework and l U S combinations associated to each level Convention Lists levels in the Convention and l U S combinations associated to each level Source Lists Source tree and l U S combinations associated to the source Template Log Log of action taken on the template with Date and Time stamp Identifies the user Database Log Log of actions taken on the database with Date and Time stamp Identifies the user User Preferences You can modify the display of UrbanInfo 2 0 User Preferences window Note that there are six tabs
20. P tile you 2o cm it fy asta R 4 a ub P n b E owe n ne lec I amp Ecusdor Falcon stance Area Mame frea D Level Guede Cragenns on A Grena CF Brari L k uat CH Bolivia LACBOL Feen Guryan Hondur Hali Jamon Sart kK arti weco ortsa verti ous here e v 4 gt Fig 3 4 Map option In the Map view the Available pane shows the map for the node selected in the area tree The map tool bar in the Available pane helps you to achieve following tasks X Change mouse to pointer mode Point and click on Area to select area The selected area is highlighted and appears in the selected pane View full extent of the map file amp Magnify the selected area to the pane extent s Zoom in by a fixed magnitude Zoom out by a fixed magnitude i Pan to a particular location on the map file Display Label Area Name on the map 24 CHAPTER Viewing Data 22 The Data page lets you view the data records of the selected database You can view all the records in the database or view limited records from the database by specifying the data parameters Indicator Time and Area The steps involved in selecting data parameters are discussed in Chapter 3 page 19 24 The Data page contains nine page options Fig 4 1 View Displays data records It includes following data elements Time Period Area ID Area Name Indicator Data Value Unit Subgroup and Source Source View the sources available a
21. Preview Data Entry Spreadsheet Subtotal amp File Edit view Insert Format Tools Data Window Help Al X amp Devinfo Data Entry Spreadsheet vA B C D E F Devinfo Data Entry Spreadsheet 3 Sector Information and Communication 4 Internet 5 Indicator Internet users 7 Unit Number Decimals 0 8 9 Time Area ID Area Name Data Value Subgroup Source Footnotes Denomin 10 OCN Oceania EUR Europe 21803800 Total UNSO_ITU estimates 42000 Total UNSD ITU estimates ASI Asia 2148003 Total UNSD_ITU estimates AFR Africa 63000 Total UNSD_ITU estimates NAM Northern America 15200000 Total UNSD_ITU estimates d Fr y r r M 4 X Data jal Ready Back Stoo Fig 8 23 Preview Data Entry Spreadsheet Click Finish to save the calculated data in a new database Transform Unit The Transform Unit option allows transforming a Unit by a multiplier For example this option can be used to change thousand to million or number to thousand QP Urbanitas MDG Info 2005 mdb Jog File Edt Hep Urbariinfows C esas C tom tone es spon Tay Gen Gy ree BA M S In aeuo Seine cii TM Ore Dn Tima Period AreslD Ares Nome Delta Ysha Lini DE rre aE a T E A ER 77707070707 GA reco aar aN 2000020002200 sn es ws s aitare Alera tamna ers 0000 Mur 009 Musee cla JNSO ITU i 1110207 Mumbar cto UNSO_JTU estimass 13000 urbe ote UNSD_JTU estimates BO Mumba Teta UN TU T 10500000 S
22. Total 90 Total 36 Total Area ID Area Name Unit Data Value Conversion Factor Thousand Subgroup Time 2002 2003 2003 2003 Ready NUM Source UNSD_ITU UNSD_ITU UNSD_ITU UNSD_ITU UNSD ITU e UNSD ITU UNSD ITU UNSD ITU UNSD ITU e Back Step4 v Fig 8 28 Preview Calculations Click Next to proceed to Step 5 104 105 Step 5 Preview Data Entry Spreadsheet In Step 5 you can preview the UrbanInfo data entry spreadsheet with the calculated values Fig 8 29 Calculate Transform Unit Wizard Step 5 of 5 Preview Data Entry Spreadsheet Transform Unit amp File Edit View Insert Format Tools Data Window Help Al X f Devinfo Data Entry Spreadsheet A B C E F D 1 Devinfo Data Entry Spreadsheet 2 3 Sector Information and Communication 4 Internet 5 Indicator Internet users 7 Unit Thousand Decimals 0 8 9 Time Area ID Area Name Data Value Subgroup Source Footnotes Denor 10 AFRAGO Angola AFRBOI Burund AFRBDI Burund ASIAFG Afghanistan ASIAFG Afghanistan ASIARE United Arab Emirates ASIARE United Arab Emirates EURALB Albania 123 Total UNSD ITU estimates 42 Total UNSD TU estimates 24 Total UNSD TU estimates 60 Total UNSD ITU estimates 3 Total UNSD_ITU estimates 3331 Total UNSD ITU estimates 3050 Total UNSD ITU estimates 90 Total UNSD_ITU estimates CiilD4LO fleo 28 Toe vert ITI 8 n nA mr
23. Vincent and the Grenadind Netherlands Antilles Gregada T ain rinidad and Tobago 61 18897 19 92236 1434 Km 3 v Cie Fig 5 25 Label Nudge WY Edit Label to modify the label settings at three levels Apply To C Active Theme W Label On Area ID M Area Name Data Value Unit Subgroup Time Period Multi row Indented C Active Laver Active Selection Font Name Font Style Font Size 8 EX Color Leader Line ll Fig 5 26 Label setting e Active Theme level Label settings are applied to the active color theme All base layers are affected e Active Layer level Label settings are applied to the active layer 66 ip Replacing the base layer helps when the map file associated with the area is outdated due to changes in administrative boundaries If the updated map file is available it can be substituted in place of the old file residing in database 67 To select the layer highlight the layer in the layer panel e Active Selection Label settings are applied to areas selected using X Insert North pointer into the map Hide left panel and provide more viewing space Click on it again to make the left panel visible Add layers such as roads rivers health centers and villages The Add Layer window Fig 5 27 displays the shapefiles available in the database itself It lists the map files for each available level Here the
24. boxes to the left of each classification help you control the visibility of the classifying criterion in the table For example to organize the indicators by the MDGs highlight Goal from the IC pane and check the box to the left of Millennium Development Goals in the Classification select window The indicators will be grouped as per the MDGs To group the indicators by MDGs and the respective targets enter 3 in the text bar above the Classification select window Check the box to the left of Column Arrangement to change the order in which the columns appear in the table Click Next to proceed to Step 4 Step 4 In Step 4 you can specify the sort order for the elements in the table Notice that the Sort window has two panes Available pane and Selected pane Fig 5 5 Bi Table Wizard Step 4 of 7 m ole Sort By Available D Selected IJ g Mis Indicator Area Name ligi Area Name Data Value ji Data Value Indicator Cancel Back Step 4 v Next Fig 5 5 Step 4 42 43 Along with Data Value the Available column lists the elements selected in the rows box in Step 1 To select an element for sorting drag and drop the element from the Available pane to the Selected pane The arrow pointer before the element gives you the sort order Click on the arrow to reverse the sort order Click Next to proceed to Step 5 Step 5 In Step 5 you can specify the formatting style for the table elements
25. ent be ts 23 IBhoug Tdsde 7 Diag and LOB escort ede crceGeacenccccseersateteesncentCerseruneedaeeantet 7 E Enter Table options sees 40 Me A OUI s otros E eed be ni i dua 40 a E 4c ue enn Ee enn een ene tote divisae 40 cis MT P 7 Export report format ssssssssseeeeeeeeneennn 76 F MPS UG panel ociera E culo opea Manes ADU 62 FIC THOTWE terse ar sia R E E AEE E E TE EET 112 Spl NERO NT 7 Bo oll 6 Ee 40 Format options in Table 44 Formatting options in Map seseessses 60 Fr Wel W OMI uv TT TN 21 G cj E 73 General User Preferences eeeeeeeeeeseseeee 114 CoL M ee 2 GVA qiie eile a NR 49 CADEI ZA uie a ede eti a et Eo de ned 48 H PIOTD HIE TIE scoaciec ee otpet e pap O dte c eicere ics 114 High is good option reniir a 40 Itiport repor Torma t 4 noo ee bee addi 76 Indicator classification in Table 42 Indicator Classifications esssssssse 21 Indicator viewing options eeeeeesseeeeeererre 114 NTR IMAI ON terc 7 WANING d ODIO IB c out ON eere aseo e eas 40 Inset DWTOD iiie teint teer ei beer tees 62 Tastallmg UtrbanlInfo u oe t ter des 14 MSU Mea e ea ED 21 L Language and style settings eeeeeeessssss 114 Layer pane ep eee eaten e
26. files for the area 23 generating the data view If you have made a selection for Indicator Time the data records for the chosen areas for the selected Indicator s and Time period s is displayed in the data view Notice that the Area page has two page options Name and Map Fig 3 3 You can select areas either by their name or on a map Selecting Area by Name The name page is divided into three panes Area tree Available pane and Selected pane IB Urbaninia MDG Info 2005 mdb mo File Edt Hep Urbantinfo 4 Y Indicator o Time Period e Aren Gur Data ica Galery ia Reparts amp Name Mao wee 151 4rea vi gt D valasole 45 DD dD Selected qd amp c Lean Amence Anne aren D I Aron Name Aren ID Level Sheer CPArnbs LACAEVe ang CY gulis LACAIA NECETE AaS C Natherlanes Anties LACANT E CT Argna LACARG Sheep in Cran wo ond Berbers LACAT Criss nr z Beliz Cr sheanss LACO kh CF Deire LACELZ razil CF Bolivia LACBOL Aahodes CT Brazi LACSRA Chile CP Broncos LACERB DO CITIO Fit Crcnte LACH Coste Rica CF Colombia LA L Cubs CP Costa Ric LACCRI ayman sl CF Cuba LACIE ONCA Cy Cayman lends LACCYM Dorhnican Cr Dominica LACOMA Ecusedor CY Dominican apik LACOCM Fabien id CP Ecuador LAGE Maas CP Paktand nerds LACFLK voa CPGusdelou LACGLP unte am Feenrh Cy Grenada LACGED Guvan CT Gustema LACTA Honig Crrrerch ca LACGUF Haili CY Guyana LACGUY jemsx CP Honera LACH Sart Cr Hati LACHT a
27. fr Fig 5 14 Step 1 By default mapping module generates a color theme based on a unique I U S combination Click on the text box below Theme to select a theme from the drop down list To modify the selected theme click Edit To add a new theme click New You can create a new theme or edit the existing one in the theme dialogue box Fig 5 15 52 53 Theme Theme Theme Type F a i n Net enrolment ratio in primary education tw Indicator Unit Percent wv Subgroup Female v Fig 5 15 Theme dialogue box Enter the theme name in the text box below Theme Choose the U S combination for the theme by clicking on the drop down lists below Indicator Unit and Subgroup Next choose from the four available theme symbols Color to represent data ranges with different colors or color gradients Use the color theme to present interval data such as Infant mortality rate etc N Hatch to represent data ranges with different patterns Use Hatch Patterns to present nominal data such as subgroups male and female E Dot Density to represent data by a number of dots corresponding to the data values Use dot density theme to represent absolute numbers It is not effective to use this theme for presenting percentages t Chart to represent data with a column chart over the map It is an effective method to compare different values Create a color theme To create a c
28. in User Preference Fig A 3 User Preferences General Language Indicator Data Map Sound Product Path C Devinfo Devinfo 5 0 Product Name Devinfo 5 0 Auto Select Filter Options Area Tree Sorted by Area ID Global Color L Paging Lines per Page 50000 Show Classic Home Page Fig A 3 User Preferences General Product Path Displays the path of application root folder It cannot be modified Note The interface strings in DI 2 0 can be viewed in all the six official languages of UN Arabic Chinese English French Russian and Spanish Note The interface strings can be in a language different from the source language Product Name Displays product name as it appears in the icon label As with the product path you can only view it without modifying Auto Select Filter Option Check the box to automatically select the Filter option If the box is unchecked the program will prompt you to manually specify the filter options every time you use the Auto Select utility Area Tree Sorted by Area ID Check the box to set Area ID as default sort option for the area tree Global Color Check the box to assign a different color to the global items Click on the color tab to open the color palette and assign a different color Click OK to apply the changes and exit the properties window Click Apply to save the changes and continue with the properties window Clic
29. in the development of the Global Urban Indicators Database III was collected from different sources national censuses Demographic and Health Surveys DHS Multiple Indicators Cluster Surveys MICS various national household surveys and other statistical sources Since 2006 the Global Urban Indicators Database has been updated annually In response to demands from data users The Global Urban Observatory GUO of UN HABITAT initiated the UrbanInfo software in 2004 a user friendly tool prepared on the Windows platform UrbanInfo helps to store present and analyze urban indicators through a variety of presentation tools such as tables graphs and maps The first version of UrbanInfo published in 2006 contains information on several topics such as housing demography communication energy economy education health nutrition and gender The second version of UrbanInfo provides updated information on these topics and also covers new topics such as disaster crime migration income inequalities and transport The second version of UrbanInfo is designed by UN HABITAT in collaboration with the United Nations Children s Fund UNICEF and the United Nations Development Group UNDG with financial support from the World Bank and other partners The UrbanInfo technical team acknowledges invaluable technical assistance and cooperation from the DevInfo group The team greatly appreciates encouragement and support from the Director of the Monitori
30. is the last step of the Percent option Here you can view the data entry spreadsheet for the new indicator Fig 8 7 Calculate Percent Wizard Step 5 of 5 Preview Data Entry Spreadsheet 100 Numerator Denominator a File Edit View Insert Format Tools Data Window Help B5 f amp Percentage of Net ODA to LDCs Devinfo Data Entry Spreadsheet 2 3 Sector Economy 4 Development Assistance 5 Indicator Percentage of Net ODA to LDCs l 6 7 Unit Percent Decimals 0 8 9 Time Area ID Areas Name _ Data Value Subgroup Source Footnotes Denominator 10 EURAUT Austria r 33 Total UNSD OECD EURBEL Belgium r 59 Total UNSD OECD EURCHE Switzerland r 31 Total UNSD_OECD EURDELU Germany i 37 Total UNSD_OECD EURDNK Denmark r 38 Total UNSD OECD EURESP Spain r 17 Total UNSD OECD EURFIN Finland d 33 Total UNSD OECD EURFRA 41 Total UNSD_OECD M Ae LL Lin ico Ta 9s v Fig 8 7 Preview Data Entry Spreadsheet Click Finish to save the calculated data to a new database The database is stored in the following location C UrbanInfo UrbanInfo 2 0 Data folder 84 100 Minus The 100 Minus option lets you calculate the complement of available indicators For instance if you have data for the literacy rate you can use this option to find out the Illiteracy rate The indicator is calculated based on the following formula X 7 100 data value of indicator M Urbanino MOG Info 2005 mdb i Welk File
31. size of the bar By default a bar is created for each subgroup associated with the selected indicator Check the box to the left of Subgroup to display the subgroup on the map Uncheck the box to suppress the subgroup Click on the color tab next to each subgroup to change the color for each subgroup bar After deciding on the themes click Next to proceed to Step 2 Step 2 In Step 2 you can add a title subtitle and disclaimer You can also modify the font style for various map elements E Map Wizard Step 2 of 5 Title Net enrolment ratio in primary education Sie x Subtitle Percent Disclaimer Note The boundaries and the names shown and the designations used on these maps do not imply official endorsement or acceptance by the United Nations Template Item Map Title Map Subtitle Disclaimer Legend Title Legend Body Theme Label Font Name Microsoft Sans Serif Font Style Regular Font Size 14 Color _ Footnotes O v l nee Fig 5 21 Step 2 Enter the map title in the text bar below Title Enter the map subtitle in the text bar below Subtitle Enter the disclaimer in the text bar below Disclaimer To choose from available style themes click on the text bar below Template and select a theme from the drop down list To add your custom style theme click New Enter a name for the new style theme and make the desired changes to the map elements listed in the Item pane
32. text box below Unit Click the text box below Subgroup to specify the subgroup You can also choose a subgroup from the drop down list Specify the decimal places that you want to present your data value in the text box below Decimal Click Next to proceed to Step 4 82 83 Step 4 Preview Calculations In Step 4 you can preview the calculations in a excel sheet Fig 8 6 Calculate Percent Wizard Step 4 of 5 Preview Calculations 100 Numerator Denominator amp File Edit view Insert Format Tools Data Window Help Al X f Percent A B 1 Perc nt Module Percent Date and 2005 Apr 14 23 27 14 Log File N Loa Percent 2006 Apr 14 23 27 14 xis 2 3 4 5 5 7 8 Decimals 0 Numerator Denominator Target 9 410 Net ODA to LDCs Net ODA Percentage of Net ODA to LDCs 11 ArealD Area Name Total Total Total Total Percent 12 13 EURAUT Austria 169 169 04 78 50478 14 EURBEL Belgium 1088 1088 1853 4 18534 15 EURCHE Switzerland 405 405 1299 49 1299 49 16 EURDEU Germany 2508 2508 6784 18 6784 18 17 EURDNK Denmark 673 673 1748 16 1748 16 18 EURESP Spain 342 342 1961 26 196126 19 EURFIN Finland 183 183 55849 558649 aoa NSummary Database Log 7 Da eat E lt Ready Sep4 vw New Fig 8 6 Preview Calculations The sheet displays the calculated indicator for all the areas in the data view Click Next to proceed to Step 5 otep 5 Preview Data Entry Spreadsheet Step 5
33. 16 Save As opecify the Indicator name Unit and Subgroup in the respective text bars Specify the scale for the index under the Scale Min and Scale Max text boxes For instance you can prepare a composite index on a scale of 0 to 1 or O to 100 Click Next to proceed to Step 4 92 Step 4 Preview Calculations In Step 4 you can preview the calculations performed to generate the composite index Fig 8 17 Calculate Composite Index Wizard Step 4 of 5 Preview Calculations Composite Index G Fie Edit View Insert Format Tools Data Window Help 1 Composite Index 2 EN Module Composte Index 4 Date and Time 2006 Apr 14 23 34 36 5 Log File Name Log Composite Index 2006 Apr 14 23 34 36 xls 6 7 Scale Min B Scale Max 100 9 10 96 weight 33 11 Highis Good TRUE 12 43 14 Area Name Literacy rate of 15 24 year olds Female 15 24 yr index Proportion of 1 year old childre 45 15 Afghanistan 0 845757932 17 United Arab Emirates 95 0 916655567 18 Armenia 99 9 1 19 Azerbaijan 39 9 1 M 4 Summary Database Log Jae a f NUM mm fer m ETIN n m CN Fig 8 17 Preview Calculations Click Next to proceed to Step 5 Step 5 Preview Data Entry Spreadsheet In Step 5 you can preview the data entry spreadsheet with the calculated values Fig 8 18 Calculate Composite Index Wizard Step 5 of 5 Preview Data Entry Spreadsheet Composite Index G Fie Edit View Insert Format Tools Dat
34. 2003 rr M AF Saher ITAA ANAS bd 25052 X f Features Y F E 74 re Inset Y x 22 16882 28 7062 10105 Km Step3 m C New Fig 5 24 Information window Select to Highlight areas on the map Remove highlighting of a highlighted area Zoom to highlight areas The map extent covers the highlighted areas Labels to switch between displaying and hiding map labels 4 Label Nudge to view uncluttered labels Drag the label that you want to displace A leader line automatically connects the label with the area Fig 5 25 Note The default location of label is the centroid of the area At times this may be problematic for areas where the centroid position falls outside the boundary of the area Nudge option helps you to rectify the problem V rip Modifying label settings for the Active Selection helps to focus on areas using distinct label settings W Map Wizard Step 3 of 5 k Wouuwwmy Theme Percent 81 6 879 E 880 947 Bl 948 991 B 992 1000 BD Missing Value wI we x Net enrolment rat e Layer 2 7 LAC LATIN AMERICA LAC MR L02 2003 LAC NGB 102 2003 FM A 6 smi cs anna Mj Aruba 2090352 X B 9 Features x re Inset x x X 4 44 iux ZOrFf c ik United States Virgin Islands British Virgin Islands _ i oon Antigua and Barbuda Saint Kitts and Nevis Montserrat Guadgibupe Dorica Marfifigue Seint ucia Barbados St
35. EKEMERDRDR DER RERUATRU RUNDE ad edenecseencion incteeds 2 Ree EM Mae ek Ot RE o memet 21 vee ee ROM Time PEro tte cern see ce eaten eee acest eee 23 citi t Ere 23 L9 218 a E Od icc 26 i i gis Mere UI ez PENNE 32 DA demE cor 33 Viewing SUBOrOUPS eterna TIR 34 Viewing iri rz 1c 05 RI ERROR RR ae er ten Oe E te 35 COB ACP VEER c ih 36 ERR Yoyo caeosacacacebnaiaieussanacesces sv AEA EE EOE AAE 73 VIEW OBJECTS IN GALLERY secoscccsncstacvtundsaceehossucsdne vede sbs es pesvee psa steszboesi veis Peu es bbess me Sv PE s VE Tas re esdesssezbpesvee wsaFtnesks 74 CREATE POWERPOINT PRESENTATION cccsscceccecceccecceccecceeccecceccescesceeceecteccescscuscescusssesceseuscascescesceeseesceseascuecs 75 NE NE MON ERR 76 79 a EG NV Yn 79 PEP ER I 80 ACT 01 0 riis Mmm 81 ez eR DENOMINA ON ereen m 82 ele oME ucl MN m 83 iier uii EE ilz et RE 84 Step 5 Preview Data Entry Spreadsheet sse ene ernnr nennen nnne nns 85 UOI 9 E
36. NE 21 CODY TO SIS OW ase need qe nti Pru tub Un bee deE 75 Circate Chart De HO oen Senden chee e 53 Create Colof TOI eiua EAE 53 Create Dot Density theme eesseeeeeeeeeeeee 53 Credle OPIBDS eee ee ee ee eee te ne ee 48 Create Hate h DEM source p tabat IH poet nih EE 53 Create PowerPoint presentation T3 Creating a map 52 Creating area series maps sssssseee 62 Creating standard reports ssssusss 76 Creare TADIC C 37 Creating time series maps ssssseseer 62 D BUB mE UU TU 30 Data Grouping Baf uueedeecieoeie ree irri erento 27 Data Page Navigation Bar sse P Data Pase OpLHOfs u i iet Eoi iiri ERE EHRES RS 26 Data Parano el cette crete ase tee ee 20 B Ele Neo eo Sanne nee ee een pee pera KM DU LE 28 BLUR m E 27 Database Elements netten 13 Database Summary Report 112 Decimalni ee eee ene ee eee eee nee ae 40 Default gallery location 74 Default map color options sse 114 Default report location ierit rer tt ensui e tesa eden 76 Delete gallery presentation ccccccccccceeeeeeeeeeeeeeees 74 IJeletmp a selee HOM usi e eaa siae ise tet d itae iu SeiaSs 7 UrbanInfo Home pape etie eerte o Fere 15 Disc CELINE 60 Discontinuous 14e eor RIETI oo Fr HIDE IU ERE RES EESR 40 Display label button oe ete trt e
37. Save As In Step 3 provide the Indicator Classification details Fig 8 27 Calculate Transform Unit Wizard Step 3 of 5 Save As Joey Transform Uni Indicator Classification Sector Y z Environment amp Health Information and Communication Computer Intemet Telephor E Nutrition is Indicator Internet users v Unit Subgroup Decimals 0 sp3 e Fig 8 27 Save As Enter the Sector Classification details in the Sector window Highlight the Sector or sub sector for classifying the Indicators Notice that the Unit reflects the new unit mentioned in Step 2 Click Next to proceed to Step 4 103 otep 4 Preview Calculation In Step 4 you can preview the calculated values Fig 8 28 Transform Unit S File Edit View Insert Format Tools Data Window f Transform Unit Transform Unt Date and Tir 2006 Apr 14 23 43 51 __ Log File NamLog Transform Unt 2006 Apr 14 23 43 51 xls Decimals 0 Internet users 10 11 AFRAGO Angola Number 41000 0 003 1 12 AFRBDI Burundi Number 14000 0 003 13 AFRBD Burundi Number 8000 0 003 14 ASIAFG Afghanistan Number 20000 0 003 Afghanistan Number 1000 0 003 18 EURALB Albania Number 30000 0 003 19 EURALB Albani Number 12000 0 003 ia n 4 gt Summary Database Log Ls la 23 Total 42 Total 24 Total 60 Total 3 Total 1B ASIARE United Arab Emirates Number 1110207 0 003 3331 Total 17 ASIARE United Arab Emirates Number 1018796 0 003 3050
38. UrbanInfo User s Guide United Nations Human Settlements Programme Acknowledgements The United Nations Human Settlements Programme UN HABITAT is the pioneer organization in the collection of urban indicators In 1991 the organization initiated the Housing Indicators Programme focusing on monitoring the performance of cities and countries in the delivery of shelter In order to address urban issues on a greater scale the Housing Indicators Programme evolved into the Urban Indicators Programme UIP in 1993 Since then UIP has produced two main databases Global Urban Indicators Databases I and IL in 1996 and 2001 respectively These were presented at the Habitat II and Istanbul 5 conferences Since 2002 UN HABITAT s monitoring and reporting function has undergone a transformation process in an effort to fulfill the requirements of new international mandates primarily the Millennium Development Goals MDGs As part of this transformation UN HABITAT s Monitoring Systems Branch revisited its existing Urban Indicators Programme and designed a new approach the Monitoring Urban Inequities Programme MUIP to better meet the monitoring and reporting needs of the organization In 2005 MUIP produced the Global Urban Indicators Database III In addition to addressing the Habitat Agenda this database provides information on the Millennium Development Goals particularly target 11 improvement in the lives of slum dwellers The data used
39. a Window Help Al NR amp Devinfo Data Entry Spreadsheet A B C D E F 1 Devinfo Data Entry Spreadsheet 2 3 Sector Education 4 Literacy 5 Indicator Impact of female literacy of health and poverty Index B vc 7 Unit Value Decimals 8 9 Time Area ID Area Name Data Value Subgroup Source Footnotes ASIAFG Afghanistan ASIARE United Arab Emirates ASIARM Armenia ASIAZE Azerbaijan 15 2004 ASIBGD Bangladesh 16 5004 ASIBHR Bahrain 47 5004 ASIBRN Brunei 91 Total UNSD UNESCO 18 2003 ASIBTN Bhutan 77 Total UNSD UNICEF estimates amp CIALL Chinn ZO Tea LION ICCOoho E rere Data 7 IERI Ready 50 Total UNSD_UNICEF estimates 84 Total UNSD UNESCO 88 Total UNSD UNESCO 97 Total UNSD UNESCO 0 Total UNSD UNESCO 90 Total UNSD UNESCO WW Ww Nw Ww WWW 9s v Fig 8 18 Preview Data Entry Spreadsheet Click Finish to save the Index in a new database Note Subtotal should be used only after verifying that the unit of measurement for the indicator selected can be subtotaled Also you need to account for the survey methodology before applying the subtotal utility 95 Subtotal The Subtotal option lets you to create subtotal data values from a lower to a higher level of geographic areas For example this option can be used to generate subtotals at the national level based on subtotals for the sub national level This option may be used to subtotal census data in some ca
40. al sub national and regional of planning e Reach out to a large and diverse audience through thematic advocacy This Introduction gives a preview of New features of URBANINFO 2 0 Content Overview User Interface uli cium 1 New features of URBANINFO 2 0 The new features of URBANINFO 2 0 give you more options in querying for data and help to undertake results based monitoring and effective advocacy The new features include e User friendly interface for hassle free navigation e Online data access and query e Grouping bar in data view to better organize and analyze data o Enhanced Table wizard features Aggregate function more options for cross tabulation e Enhanced Map Wizard features Options for Dot density and chart theme label nudging inset and exporting to raster image e Reports feature to store report templates and apply ready to use report formats across databases 2 Content Overview This guide contains eight chapters an appendix and an index It provides a step by step explanation for querying data and generating reports Key steps have been graphically illustrated to help you better understand URBANINFO 2 0 and effectively 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 tells you about different ways of accessing data Chapter 3
41. d Rights Convention Convention on Bio Diversity and Vienna Convention on Law of Treaties Selecting Time Period Click on the Time Period tab in the navigation bar to access the Time Period page Here you can select the time period s for generating a data view Notice that the time period page has two panes Selected and Available Fig 3 2 Uraninta MG Info 2005 mdb JJ Fie Edt Hep IET Urbanlnfo n Y Incicntor d Time Period e Aren E Data E Gallery ie Reparts iki vM ge E X Avale CNN bb Selected S d Tre z 2003 2002 S SS2SSERRQGRSSSISRLAZ Fig 3 2 Time Period page To select one or several time periods drag the highlighted time period s from the Available pane to the Selected pane or use other methods of selection as explained on page 11 To remove a time period from the Selected pane highlight the time period and click lt or use other methods of deleting a selection as explained on page 11 Click on the column header of available or selected panes to sort the time periods oelecting Areas Click on the Area tab in the navigation bar to access the Area page and select areas Here you can select the geographical areas for 22 fip Click on to select the level of area from the drop down list The Select highlighted button will now select areas for the specified level Note Each area has a unique Area ID The Area ID is used to link the area name with the map
42. data values for the indicator poverty head count ratio into four quarters to find out which countries fall in the fourth quarter Mrip Choose continuous when you want to find out which sub national regions are close to the national average for the given indicator You can manually change the To value to decide on the appropriate class limits Iri When you want to group the data for the maternal mortality ratio across developed countries and developing countries use the discontinuous method to accommodate the wide range of values for the indicator across the regions in the text box below Breaks You can set a maximum of ten and a minimum of two breaks Click on the text box next to breaks to select the method of break You can choose from the following types of breaks Equal count Data values are distributed across the specified breaks so that each class interval has approximately same number of areas You can not change the From and To Columns Choose the equal count method if you want to divide the areas based on a quantile classification Equal size Data values are distributed across the specified breaks so that difference between the From value lower class limit and the To value upper class limit is the same for all the class intervals You can not change the From and To Columns Choose equal size as the method of break to retain the inherent variation in the data values Cont
43. depicting regions and landscape Making a map in the Map wizard involves five steps Click on the map button in the data view to activate the Map wizard When you open the Map wizard it automatically applies a default color scheme to the data values of the selected indicators and generates a map preview Fig 5 13 W Map Wizard Step 3 of 5 cog L HAAOMINEKRASCVARBEFORX GSE m Theme A e E Net enrolment ratio ir dii e Percent 81 9 88 4 885 342 Bl 343 330 Bl 991 1000 Ed Missing Value ise 1 00 35 S rune Inset 51 44945 32 30742 9424 Km Back Fig 5 13 Map wizard Note You can choose from a maximum of ten breaks and a minimum of two breaks Note Uniqueness of a theme is defined by a combination of Indicator Unit Subgroup and Theme Type Multiple themes can be created for the same l U S but different theme type Click Next to accept the system suggested map and proceed to Step 4 to preview the map in Excel To modify the map click on the GO TO box and select Step 1 from the drop down list otep 1 In Step 1 you can modify the theme specify the legend title and decide on the statistical classification method and number of breaks You can also change the legend text and border color GB Map Wizard Step 1 of 5 Theme K Net enrolment ratio in primary education Percent Female Legend Title Percent Breaks E z Continuous Border fw
44. e indicators to select the Indicators Click Next to proceed to Step 2 90 9 otep 2 Weights In Step 2 you can assign weights for each indicator Notice that by default equal weight is applied to all the indicators Fig 8 15 Literacy rate of 15 24 year olds Female 15 24 yr Propottion of 1 year old children immunised against measles Total 1 yr Proportion of population below 1 PPP per day Total S o2 v Fig 8 15 Weights You can modify the weight to suit the requirements in your context Note that the sum of the weights should equal 100 Check the cell in the column High is Good for indicators where a higher value is better than a lower value Uncheck the cell for indicators for which reverse is true In the above example uncheck the box for the indicator Proportion of population below 1 PPP per day Click Next to proceed to Step 3 Step 3 Save As In Step 3 you can specify the Indicator Classification Select the Sector and sub sector for classifying the Indicator Fig 8 16 Calculate Composite Index Wizard Step 3 of 5 Save As Jay E3 Composite Index Indicator Classification Sector Sector a Economy Education Gender Equity Literacy Primary Education Environment Indicator Impact of female literacy of health and poverty Index v Unit Value Subgroup Total v Decimals 0 E Scale Min Scale Max 5 3 LE 3 v ne Fig 8
45. e source appears in the Selected pane Click on the View tab to view the data for the specified sources Viewing Units Click on the Unit tab to specify the Units to be included in the Data V rio view Click F to toggle between eua JU Notice that the Unit tab has two panes the Available and the ewing the indicator and unit or only unit Selected pane Fig 4 6 Ui Urbariinta MOG Info 2005 mdb we File Edt Help Urbanlnfo ii indicate C Time Period e Aren LI Data ica Galery ge Reports i e wee amp Y 5 Available 2 wb D Selected 2 eq receto Unt helexior hi CF niort mortally rete Deslhis per 1000 live births CP infant morsky rete Deaths per 1000 hve births Cy visceral mortelly ratio Desire per 100 090 Eve kits CP Hslecrssd motaity ratio Deaths per 100 000 live births Fig 4 6 Page option Source To select double click a unit in the Available pane The unit appears in the Selected pane Click on the View tab to view the data for the specified unit 32 ip Click T to toggle between viewing the indicator and subgroup or only subgroups Note Subgroups refer to the subpopulations grouped into four categories Sex Location Age and Others 33 Viewing Subgroups Click on the Subgroup tab to specify the subgroups for the indicators to be included in the Data view Notice that the subgroup window has two panes Available and Selected pane Fig 4 7 Ui Urar
46. eate a weighted composite index M Urbanite MOG Info 2005 mab ak Fie Edt Hep Urba ninfo 77 indicate Gg Time Pesicd e Aren E Dua 57 ey bir Reports Subgroup Slelisice Cacusle Tobe Graph gt ES es a E Tine Period Ares v 2004 SSKA 200 v 2004 iv zen v 2004 fz at v 2004 v 200 v 200 9 2004 v 2004 Pagetors 9 ivi 00 Fig 8 13 Data view of source indicators The Data View Fig 8 13 shows data available on following indicators e Literacy rate of 15 24 year olds Percent Female 15 24 yr e Proportion of 1 year old children immunized against measles Percent Total 1 yr e Proportion of Population below 1 PPP per day Percent Total You can use Composite Index option to combine these indicators and generate one value to reflect all these different elements Step 1 Indicator In Step 1 you can select the indicators that you want to combine to generate the composite index Fig 8 14 Calculate Composite Index Wizard Step 1 of 5 Indicator Composite Index Available 3 Subgroup D D Selected 3 Indicator Subgroup Indicator Subgroup CP Literacy rate of 15 24 year olds Female 15 24 yr CF Proportion of 1 year old childr Total 1 yr CF Proportion of 1 year old childr Total yr C3 Proportion of population belo Total CF Proportion of population belo Total Se v Fig 8 14 Indicator Double click on th
47. ect of the theme For the Chart theme and Color themes you can change the color option for the theme elements To change the color for a theme range or a chart bar click on the color tab to the left of the range or subgroup respectively Note Base Layers are the Polygon or Point layers that define the administrative boundaries location of an area Base layers are rendered based on theme settings while feature and custom layers are rendered based on user defined color and patterns For the Hatch theme you can change the hatch pattern for each range Click on the hatch pattern tab to change the pattern The Counter on the bottom left of the screen gives you the latitude and longitude position of the mouse pointer It also gives you an approximate reading of the extent of the thematic map that you are viewing Layer Panel The layer panel displays the shapefile name of the base layer and the custom layer Base layers are represented by plain icons in layer legend where as Feature layer and Custom Layers are represented by colored icons represents Polygon shapefiles Common examples of polygons are administrative boundaries lakes and national parks represents Point shapefiles Common examples of points are villages hospitals and service centers represents Line shapefiles Common examples of lines are rivers rail networks and roads Click on the button to the left of the feature or custo
48. eet ccc cccssccccessssecccesssceeceesseececessaeecceesseeceessseeeeeessseeecesssseeeessaes 106 USER DEFINED FORMULA T 107 ESD Mise eio OESTE 108 wie Eu PISANI T e m 109 Step 3 Preview Calculations 0 0 0 cece cccccsssscccccccesssssceccccsessseescccceessseescecceceseeeeeeeceeesseeeeceseeeseeeeeeeeesssaeeeees 110 Step 4 Preview Data Entry Spreadsheet nennen enne eene enne entren nnns 111 APFPFENDIN der 112 MENU BAR OPTIONSG ssssseccccecceesseecccecesauseeeccceeesusseeccceeesaaseeeeeceeessaaseeecceeeesauasseeceeeessaaeeseecceessaaaeseeeeeeeeeaas 112 air er E E 112 107 MET EN 112 Database Summary nico e E 112 Jeer Pre eae aan aa T 114 zd m 119 ELE ea E a eet P 119 PO e E E MEE 119 KADE S a E E E A 121 Introduction UrbanInfo Urbaninfo 2 0 is an advanced database management system to keep track of the commitments towards human development It is endorsed by the UN to report on the progress towards the Millennium Goals With Urbanlnfo you are literally a few mouse clicks away from facts that help you to e Analyze data for evidence based decision making e Undertake results based monitoring and evaluation e Link different levels nation
49. ehensive summary of the database It is a one step process and provides you with useful summary documentation of the database that can be filed for future reference The report is generated as MS Excel workbook with worksheets for various database elements Fig A 2 fie Ect view inset Format fods Osta Window Help _ xX DAHA ERY ite I zii ib dedans win Bi m 5 A 7 Al amp Summery Repon NEN B ee E F 6 H T ES 22 Se Sass F Summar Report 2 3 4 Database Name Davinfo DG HOR SOWC SOAP VOR 2094 0531 1203 5 Created n 5 Templat 7 Count 43 8 3 L Indicator 303 ii Unt 32 12 Subgroup 3a 13 1 u s 374 14 15 Mea 237 Level 1 16 17 13 Time Per rim 195 19 4 2050 20 21 Sou 8 22 23 Languag nt Fnglish en 24 amp robic or 25 4 french tr 26 EI Chris zh 27 El Sosrish Jes 2d Ir ian t 3 31 Sector 32 Goal 33 Framewor k 0 J4 Institut 0 al a gt WA Summary Incater Unt brou 7 14 5 ZTime aea f Sector f God Framework 31 Draw Aynoshepes A 5 RBE Ready NL I Fig A 2 Database summary report summary Provides the following database information Name Date of creation and template name It gives a total count for data records Indicator Unit Subgroup I U S Area Time period Source Language Sector Goal Theme Framework Institution and Convention Indicator Lists all Indicators in the database Identifies indicators that are global and have metadata Unit
50. er helps you to change the order of the elements Note The drop down list for selecting the grouping criteria contains elements selected for table rows e Source Column Pane Displays the elements selected for the column s of the table Row Pane Displays the elements selected for the rows of the table To specify the elements for the row or column drag and drop the elements from the Available pane to the respective panes Aggregates Function Pane Provides options for grouping the data records and generating summary statistics such as sum count and mean Check the box to the left of Aggregate Function to activate the aggregate menu You can select from three available aggregate functions Sum Count and Mean Click on the radio button to the left of these options to choose the desired aggregate function You can specify the criterion for grouping the data records and applying the aggregate function Click on the text bar below Groups and select the criterion for grouping from the drop down list Check the box to the left of Suppress Duplicate Headings to hide any table headings that have been repeated This option applies only for the column headings For example if the table contains two indicators with same units then the units get combined and are displayed in one cell Click Next to apply the changes and proceed to Step 2 38 Step 2 In Step 2 you can specify the table title footnotes and choose to colo
51. eries bar Fig 5 30 appears at the bottom of the map preview Most Recent Auto Cycle 1960 1870 1880 1992 2001 2002 Fig 5 30 Time Series bar Most recent tab displays the latest data Auto Cycle tab lets you view animated map for all time periods in sequence A tab is created for every time period for which data are displayed in the data view Create Area series maps for all available levels of area in the data view An Area series tab Fig 5 31 gets appended to the map preview All Auto Cycle Africa Tanzania Mainland Zanzibar Region District Ward Fig 5 31 Area Series bar All tab lets you view all the levels in one map Auto Cycle tab lets you view animated map for each Area level in sequence A tab is created for each level of area Click Next to proceed to Step 4 Step 4 In Step 4 you can preview the map in MS Excel format J Map Wizard Stop 4 of 5 XU zie Edt Wew Inset Format fools paa indov Help T 85x Al 5 EUM GS b E F G H J K L M N 0 E Net enrolment ratio in primary education Te Percent The Excel workbook Fig 5 32 includes spreadsheets of the data view and sources Click Next to proceed to Step 5 70 71 Step 5 In Step 5 you can provide a name for the map presentation that you created By default the map is saved in the Gallery Click L I to save the map at a desired location Click Finish to save the presentation and
52. exit the map wizard CHAPTER Gallery UrbanInfo 2 0 uses the Gallery to manage the Table Graph and Map presentations created in Urbanlnfo You can organize the objects in different folders under the Gallery and transfer the objects directly into MS PowerPoint To activate the Gallery do one of the following In the Home page place your mouse pointer over and click on Presentations in the Gallery menu Fig 6 1 Click on the gallery page tab in the navigation bar B Uraninfa MDG Info 2005 mdb wee Fie Edt Hep GALLERY felons A 5 4 VW uM Urbaninfo AANS United Nations Human Settlements Programme E D p 9 Fig 6 1 Home page gallery menu 12 View objects in Gallery Notice that the Gallery window is divided into two panes Fig 6 2 wo de EP Be EB Net enrolment ratio in primary educ EB Net enrolment ratio in primary educ Bolivia Mrip Click e to locate presentation objects Anguilla gt Ready Tammie un M gt gt Graph Table Data Sour Gallery C Devinfo Devinfo 5 0 Gallery Presentations pD pDe E Presentations ia Net enrolment ratio in primary education Graph xls CS Net enrolment ratio in primary educ File Edit View Insert Format Tools Chart Window Help f Het Enrolment in primary education p X Fig 6 2 Gallery window The pane on the left lists items available in the pre
53. fied value e Equal to specified value Click OK to apply the specified filters Click Cancel to reject the filters and exit the filter window Click Reset to revert to the default data view 30 Mrip You can select different Sources for different Subgroups or Units of the same Indicator Mrip Highlighted sources are classified as recommended sources 31 Viewing Sources Click on the Source tab in the page option bar to manage the data sources appearing in the Data view Notice that the source page is divided into two panes Fig 4 5 UP Urbaninta MDG Info 2005 mdb JJ File Edt Hep gt A p Urba n nfo i amp J Indicator t Time Period Aren Go Data E Galery ii Reports amp E View Sources uat Subgroup Staliziice Ca cusie Table oat kap 1 A amp f we E B 6 Y UN Ayake 2 cw 56 D Selected 2 l g recato ure Subgroup Saroz hokmor n Subgroup Source CF niort mortally rate Deaths per Total UNSD_UMCEF estimat CP infant martsity rete Deaths per Tota UMSD WKE estima CF sates mortelity ratio Deste per Total UNSD_YHO UNKEF CO ister motaty ratio Dess ger Toss UNSD_VVHO UNICEF Fig 4 5 Page option Source The Available pane lists the I U S combinations and their data source The Selected pane shows the data sources for the I U S appearing in the data view To include a source in the data view double click on the source in the Available pane Th
54. ft Windows XP Microsoft Office XP Microsoft Internet Explorer 6 0 12 Installing UrbanInfo v2 0 Note Computers with Windows 98 Operating System need to be restarted after installing DI 2 0 To install this software application on your computer follow the steps given below E Insert Urbaninfo v2 0 User Interface CD into the CD ROM drive E Wait for auto run to open the setup screen E Follow the instructions on screen to complete the setup E Double click Bl on the desktop to start the application If the set up program does not load automatically Choose Start Run E Type d setup where d is the letter of your CD ROM drive and press Enter key E Follow the instructions on screen to complete setup E Double click Bl on the desktop to start the application CHAPTER JE The Homepage This is the home page of Urbanlnfo 2 0 Notice that the home page has a column of buttons next to the animation Fig 2 1 Place the mouse pointer on any button to reveal menu options IB Urbar nfa Devino MDG HDR SOWC SOWP WDR 2004 05 31 12h08 mdb Fie Edk Help Urbaninfo a Fig 2 1 The Home Page 14 1 Information menu has two options Product and Organization Product Opens the default internet browser and displays information about UrbanInfo 2 0 Organization Opens the default internet browser and displays information about the UN c Data menu has four options Indicator Time Area a
55. heme Pig LLL LLL LI 17 BENE SSS Fig 5 17 Hatch theme The only difference is that in the Hatch theme you can change both the color and the hatch pattern To change the polygon pattern click on any cell in the polygon column to choose the desired pattern from the drop down list You can also change the color for the desired pattern by clicking on the color tab 56 ip Dot Density themes are suited for representing discrete numeric values like population size If one dot represents a population of 1000 and there are 50 dots in a district then the population of the district approximates 50000 Data value defines the count of dots and has no bearing on the dot size Size may be scaled by the user to make the map clearer 57 Create a Dot Density theme To create a dot density theme click i Gi Map Wizard Step 1 of 5 Oleg Theme SX AIDS Deaths vi Legend Title Style Custom Font Custom Character Value 200 Cancel Step 1 v Next Fig 5 18 Dot Density theme Click on the text bar under Legend Title to specify a name for the dot legend Fig 5 18 Click on the color tab under Style to open the color pop up window and choose the desired color Click 3 to enter the desired font size for the marker Click to choose a different marker style from the drop down list If you want to use a custom marker click on the drop down arrow below Style and select the last item fr
56. id lines Click Delete to delete an existing format theme Click Save to save the formatting changes to the selected format theme Click Next to proceed to Step 6 44 45 Step 6 In Step 6 you can preview the effect of the changes made in Steps 1 through Step 5 The output is presented as a Microsoft Excel workbook Notice that there are three worksheets in the workbook Fig 5 7 S Lou Table Wizard Step 6 of 7 Joe S File Edit View Insert Format Tools Data Window Help Al X fe Net enrolment ratio in primary education A B Net enrolment ratio in primary education Percent Area Name Millennium Development Goals Net enrolment ratio Anguilla Net enrolment ratio Argentina 9 Net enroknent ratio Aruba 10 Net enrolment ratio Bahamas 11 Net enrolment ratio Barbados 12 Net enrolment ratio Belize 13 Net enrolment ratio Bolivia 14 Netenrolment ratio Brazil 15 Net enrolment ratio British Virgin Islands 15 Net enrolment ratio Chile 17 Net enrolment ratio Colombia 18 Net enrotnent ratio Costa Rica 19 Net enrolment ratio Cuba 20 Net enrolment ratio Dominican Republic 21 Net enrolment ratio Ecua M 4 gt gt I Table Data vv Ready Gai sp6 1 2 3 4 5 6 7 8 Fig 5 7 Step 6 Table sheet displays the table created using the Table wizard Data sheet displays the Data View used to create the table Source sheet displays the list of data sources It also gives you the
57. ided as is without 1 express or implied warranty This product is provided with na responsibility For impacts resulting fram the use of the software the This database software has been developed with the cooperation of the UN system The product has been m Fig A 9 About Urbanlnfo 2 0 Click System Info to generate a detailed report of the hardware and software setting of the computer INDEX A Ac yate gallery coquina de ast entos den iesostim eomm 73 nli EK PIT 62 Add raster Jt 3B6 ieiietete eet b eter EL Ee es obe cose ebd Ee eeeeal 62 Aggregate Functions available 38 Aggregates Function pane eeeeeeeeeesseseeeeeeel 38 Apply color in table eessesssseesees 40 B Buffer DUON seereis iner AREER ET 62 C Calculate TOO MITIS eoe ocotir beoe ite Eois 86 Calculate Composite Index sssssss 90 Calculate Peteetilou uoi o Eoo REDEEM 80 Calculate Subtotal sssseseeeeeeeeee 96 Calculate Transform Unit esssssssss 101 Calculate User defined Formula 107 Calculate Wizard a eiie die ardt etaed pete PU PR Ph R2 desee Utd Needs 79 Close slide SOW iii tiir t t EUER HE EIE EHE HEEESEIE DAL 75 E ohm Dalle ues pene tatu steep ter LL eI 38 Content overview esses 7 COn RR T T 3 CO TNO eienenn eee Eee EERE EEEE 40 Miel SINFO
58. in the Available pane header or o Choose the Select Highlighted option from the right click menu e To select all items listed in the Available pane o Click in the Available pane header or o Choose the Select All option from the right click menu Deleting a Selection Deleting refers to removing the item from the Selected pane To delete do one of the following e Double click on the item in the Selected pane e To remove item s highlighted in the Selected pane o Click in the Selected pane header or o Choose the Remove Highlighted option from the right click menu or o Press Delete key e To remove all items listed in the Selected pane o Click Jin the Selected pane header or o Choose the Remove All option from the right click menu CHAPTER E Getting Started The Urbanlnfo 2 0 database system consists of the following elements Indicator Time Period Geographic Area Subgroup classified into four categories Sex Location Age Group and Others e Unit e Source e Data value The system provides access to indicators organized by sectors goals themes and other data management schemes Urbaninfo 2 0 is integrated with Microsoft Office for easy presentation of data in tables graphs and maps oystem Requirements The recommended hardware requirements to install this software application are Pentium IV 512 MB of RAM 1 GB of free hard disk space Display resolution 1024 x 768 Microso
59. infe MOG Info 2005 mdb aA Fie Ect Mep UrbanIinfow 4 7 indicate tS Time Period Aren LI Datn ical Galery un Reports a i y o View Source Uni Subgroup Sletisiics Cacusle Table ant Wap E 1 vb ga E Bp a V CN Araki 2 mb D Selected 2 4 redcetoc Suberoun bdicarar Suber cur CT niort mortally rete Tota CPh f ai motat e Total fer mortality ral CF visent mortelty ratio Tots CP Malernal norlaly rio Toss Fig 4 7 Page option Source To select double click a subgroup in the Available pane The subgroup appears in the Selected pane Click on the View tab to view data for the specified subgroups Mrip Use the data grouping bar to group the columns of the statistics page Mrip This statistical overview is useful to create meaningful range breaks in maps Note Standard Deviation measures the variation from an average of a group of measurements For example if the standard deviation for the sex ratio is very high across the sub national areas for a country it means that there is high variability in the sex ratio across the regions For a normal distribution 68 of all measurements fall within one standard deviation of the average and 95 of all measurements fall within two standard deviations of the average Viewing Statistics Click on the Statistics tab to find out basic statistical values for the I U S combinations included in the Data view The Statistics tab window dis
60. inuous You can change the value of To column On changing the To column in one class interval the From and To columns for all the intervals are automatically recalculated to ensure continuity The continuous method is useful when you want to manually set the class limit while retaining the continuity across the class intervals Discontinuous You can change both the To and From values On changing either of the values the interval limits do not get recalculated The discontinuous method is very useful to group data values that are widely dispersed The default values are displayed in the text boxes below Minimum and Maximum You can set the Minimum and Maximum range value for the data set The values specified here influence the method of break opecify the decimal precision in the text box below Decimal The upper and lower limits of the breaks are sensitive to the decimal range the data values can fall in one break or the other depending on the decimal places The High is good option lets you apply the reverse color scheme 40 Mrip Specify the level of classification arrangement in the text box above the classification select pane Mrip Use L to modify the order of both the classification and column arrangement 4 for indicators that measure the level of the negative factor For instance the indicator Illiteracy rate has an inverse relationship with literacy When you are deciding
61. k Cancel to discard changes and exit properties window Language In the language tab you can change the language and style settings of the interface strings Fig A 4 User Preferences General Language ndicator Data Map Sound Interface String Name DI English en mim Font Arial v Style Regular v Size 8 EX Source Language DI Enalish en v 114 Note You can choose only one of the Indicator Classifications as default view setting 115 Fig A 4 Language Click on the Name box to change the language setting for the interface string To select a language choose the language from the drop down list Click on the Font box to choose the desired font from the drop down list Click on Style box to choose the desired style from the drop down list Click on Size box to scroll through and apply from available font sizes Click on the Source language box to choose the database language strings Choose a desired language from the drop down list Indicator The Indicator tab lets you select the viewing options for Indicator Classifications There are seven types in which indicators are classified User Preferences General Language Indicator Data Map Sound Select Indicators By F7 6 G Goal O Framework O Theme O Source O Institution Convention Show Unit and Subgroups Fig A 5 Indicator Notice that there are two sets of ico
62. lick to close the slide show window pane 74 Reports Creating Reports The Reports wizard simplifies the process of creating a table presentation in Urbanlnfo It helps you apply the table formatting options and the I U S combinations to create a report in table format You can thus generate standard reports by applying the saved formatting options to other databases Click on Reports tab in the Navigation bar to open the Reports window The report window lists all formats that you have already created Fig 7 1 W Reports Joey Mirip Use Report to store format for tables generated on a regular basis Fig 7 1 Reports window By default the report formats are saved under the following location C UrbanInfo UrbanInfo 2 0 Reports Click 3 to import report formats from a desired location 75 Note If the Data checkbox is left unchecked the table will be generated for all data values in the database Click E to export reports to a desired location The report files are stored in xml format Click to delete the saved reports Highlight a report from the window and click 4 to match the I U S combinations in the report with those of the database that you have selected The result of the matching process is displayed in a MS Excel Worksheet Fig 7 2 Microsoft Excel Book1 File Edit View Insert Format Tools Data Window Help D cS Gar ee e AT fe A Indicator Net enrolmen
63. m layer to modify the layer settings For a Polygon layer you can set fill color transparency and fill style You can also change the border color border style and border width For a Line layer you can change the border color border style and border width For a Point layer you can change the marker color marker style and marker size Ordering of the layers affects the map display as the layers are rendered in a bottom to top sequence Highlight a layer and use the layer toolbar or right click menu options to modify the layer order 62 Mrip Click zr to zoom to the highlighted layer The layer is displayed in the preview window 63 Fig 5 23 Layer h LAC LATIN AMERICA Move Move to Top i LAC_MR_LO _ 2003 Edit Label Move Up Move Down h C LAC VOB L02 2003 zoom In Laver Settings Move to Bottom E Delete Fig 5 23 Layer tool bar To move the highlighted layer up by one step do one of the following Click in the layer tool bar Choose Move Move Up from the right click menu option To move the highlighted layer down by one step do one of the following Click 7 in the layer tool bar Choose Move Move Down from the right click menu option To move the highlighted layer to the top of all layers do one of the following Click in the layer tool bar Choose Move Move To Top from the right click menu option To move the highlighted layer to the bottom of all layers do o
64. map files are available under two levels Continent and Country Add Layer Continent Country Available 6 D Map Name Start Date End Date AFR AFRICA 2003 1800 01 01 2200 12 31 ASI ASIA 2003 1800 01 01 2200 12 31 gt EUR EUROPE 2003 1800 01 01 2200 12 31 LAC LATIN AMERICAN 1800 01 01 2200 12 31 NAM NORTHERN AM 1800 01 01 2200 12 31 s NCM OCEANIA nn 1O0nn nd nm 7 5nn 12 4 M Selected 1 I J Map Name Start Date End Date LAC LATIN AMERICAN 1800 01 01 2200 12 31 Fig 5 27 Add layer To select a shapefile double click on the desired shapefile from the Available pane Click OK to add the layer and exit the window Click Apply to add the layer and select more layers from the window Click Cancel to exit the add layer window without selecting any Note Buffers are concentric polygons drawn around point or lines Map buffer is a very effective tool for impact analysis under an influence zone ip Click on buffer layer after selecting T from the toolbar The Information dialog window will display the count of target features lying inside the buffer If the target layer is a base layer then sum and mean are also displayed shapefile Click to access and use external shapefiles Replace Base Layer with an external layer Create Buffer zones around the line or point layer The buffer window lets you modify the buffer settings B uffer Mame Radius
65. nd Data Indicator Opens the Indicator page and lets you view and choose indicators 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 V ri choose to view all the data records in the database or generate a data view based on Indicator Time and Area selections To view all the data records click on the Data option in the Data menu c Gallery menu has two options Presentations and Images Presentations Opens the presentation folder in gallery and lets you view UrbanInfo 2 0 presentations Table Graph and Map Images Opens the Images folder and lets you view the images appearing in the flash animation Help menu has three options Content Tour and Support Content Link for the pdf file of the User s manual Tour Run the Urbanlnfo tour Support Opens the default mail client with the UrbanInfo support address in the To text bar Others Displays any additional link 15 Note If you click on any sub menu under Data without selecting a database you will get the message Select Database To open a database select File Open The Open Database window appears Notice that there are two tabs Online and Offline Fig 2 2 Open Offline Online C Devinfo Devinfo 5 0 Data localhost Devinfo MDG HDR SOWC SOWP WDA 2004 05 31 12h08 mdb localhost
66. nd those selected for the data view Here you can remove or add new data sources Unit View the Units available and those selected for the data view Here you can remove or add new units Subgroup View the subgroups available and those selected for the data view Here you can remove or add new subgroups otatistics View basic statistics for the data records Count Range Mean and Standard Deviation Calculate Perform calculations on the records in the data view Percent 100 Minus Composite Index Subtotal Transform Unit and User defined formula The Calculate options are discussed in detail in Chapter 8 page 78 110 Table Open the Table wizard and create a table presentation Graph Open the Graph wizard and create a graph presentation Map Open the Map wizard and create a map presentation Mrip On the home page select the Data option in the Data menu to view all the data records for the selected database Mrip Click on any data column header to quickly sort the data in ascending or descending order ip EX The export button lets you export the data from the data view into the following file formats XLS CSV PDF HTML XML Database and Urbanlnfo Data Entry Spreadsheet format Data View To generate a data view click on the Data tab in the navigation bar after selecting the data parameters Indicator Time and Area Notice that there are eight columns in the data window Time Period Area ID
67. ne of the following Click amp in the layer tool bar Choose Move Move To Bottom from the right click menu option Mrip After using any tool click to prevent applying the tool effect to any further areas ip When you use the information button the area remains highlighted Click to remove the highlighting Feature Panel The feature panel displays the default features associated with areas in the database The features could be a polygon line or point map file The Tool bar buttons help you achieve the following tasks Change mouse to pointer mode View full extent of map file amp Zoom in frame to zoom selected area to the pane extent Zoom in by a fixed magnitude Zoom out by a fixed magnitude i Pan to a particular location on the map file 4 nformation on the highlighted area The information window Fig 5 24 gives you details such as Area Id Area name Data value Indicator name Unit Subgroup and Time period 64 65 heRZAAMHIX KAS EVA DIF PORK S44 Theme A Al NER MALE a T Percent v 81 5 87 9 88 0 947 Bl 948 991 Information Bi 99 2 100 0 LAC_MEX_L02_2003 Bl Missing Value Item Value B 1 00 v Area ID LACMEX Area Name Mexico Indicator Net enrolment ratio in primary edu 3 Layer 2 Unit Percent Subgroup Male LAC LATIN AMERICA A Time Penod 2001 7 LAC MR 02 2003 Data 98 8 V LAC_VGB_LO2
68. ng and Research Division Oyebanji Oyeyinka the former Head of the Monitoring Systems Branch Nefise Bazoglu and the Head of the City Monitoring Branch Eduardo L pez Moreno UrbanInfo technical team Coordinator Gora Mboup Chief of GUO Database Administrator Philip Mukungu GIS coordinator Maharufa Hossain Data Processing Assistants Julius Majale George Madara Raymond Otieno Database Assistants Steller M Kavuwa Lucy P M Wachira Interns Tonny O Kinyangi Peninah N Kimani Anne Kibet Send your comments and suggestions to UrbanInfo Database Administrator Global Urban Observatory Monitoring and Research Division P O Box 30030 00100 Nairobi Kenya Phone 254 20 7623057 Fax 254 20 7623080 Email guo unhabitat org Website http www unhabitat org Contents ACKNOWLEEDGEMENT rit nni PEE EE EO RU RIPAPAI N RERNUPN EVER IUAR URGE ARER 2 CONTENTS n 3 INTRODUCTION oodd ipo Eten edet ien ROM NI tudid e uit eH ENS 7 CHAPTER rt 13 GETERG TARTE D MR ERN OO OM 13 System Requirements E ET DET ISDN 13 Insralind Urbanino NE E sicura divis ddk d rm nat te mare anne RET Pu PE OR a Dv Qa A EA al M CUR 14 S S a LU DE sae Baw bee ere Sa cca A 15 AT PAD DS ec P 20 SELECTING DATA PARAMETER GS esanian 70908987 R027AERFAOIDA TRRERRIRTRLRENDA YR ROR
69. nit Value Subgroup Total Decimals 3j 52 v Cree Fig 8 32 Save As Highlight the Sector or sub Sector to classify the new Indicator Specify the Indicator name Unit Subgroup and the decimal places for the data value Click Next to proceed to Step 3 108 Step 3 Preview Calculations In Step 3 you can see a preview of the calculated values Fig 8 33 User Defined Formula G Fie Edit View Insert Format Tools Data Window Help Al v f User Defined Formula MES B a hi 1 User Defined Formula 2 User Defined Formula 4 Date and T 2006 Apr 14 23 54 33 i Log File Ns Log User Defined Formula 2006 Apr 14 23 54 33 xls B 7 Decimals 2 os Life expectancy at birth 10 ArealD Area Name Total Lite expectancy at birth Total 25 85 25 11 12 AFRAGO Angola 40 1471 13 AFRBOI Burund 41 1571 14 AFRBEN Benin 51 25 71 15 AFRBFA Burkina Faso 46 2071 16 AFREVVA Botswana 4i 1571 17 AFRCAF Central African Republic 40 1471 18 AFRCIV C te divoire 41 1571 19 AFRCMR Cameroon 47 21 74 n 4 gt 1 Summary Database Log I Ready Se3 v mex Fig 8 33 Preview Calculations Click Next to proceed to Step 4 109 Step 4 Preview Data Entry Spreadsheet Step 4 provides a preview of Urbanlnfo data entry spreadsheet with the calculated values Fig 8 44 Calculate User Defined Formula Wizard Step 4 of 4 Preview Data Entry Spreadsheet User Defined F
70. nrolment ratio Armenia 13 Net enrolment ratio Austrata 14 Net enrolment ratio Austria 15 Net enrolment ratio Azerbaijan Uic MN Co 4 0 96 47 Net enrolment ratio Bahrain 18 Net enrolment ratio Bangladesh 19 Net enrolment ratio Barbados 78 20 Net enrolment ratio Belarus 21 Net enrolment ratio Belaiu A M 4 MTable Data CUTE Jal Ready Fig 7 3 Preview Table in Reports wizard Click Next to proceed to Step 7 In Step 7 enter the desired name and click Finish to save the table in the Gallery CHAPTER Calculate The Calculate wizard provides you with utilities to perform calculations on the data queried from the database Sometimes the available data are not present in an appropriate format There are six options available in Calculate Fig 8 1 I Urhaninfa MDG Info 2005 mdb File Edit Help Urbaninfow View Source Unit Subgroup Statistics Calculate Table Grap i ie gt que E User Defined Formula Fig 8 1 Calculate options Percent Convert absolute numbers into percentages 100 Minus Calculate inverse indicator values Composite Index Create composite index Subtotal Create national totals from sub national data Transform Unit Convert measuring unit for the Indicator User Defined Formula Apply your own formula on the data records 78 79 Percent The percent option lets you convert absolute numbers into percentages It is based on the formula
71. ns radio buttons to the extreme left and check boxes to the left of the items Fig A 5 Click the radio button to the left of the ICs to set it as the default view Check boxes to the left of the ICs to display each item Uncheck to hide The classification by Sector is the default set by the program and can not be unchecked Check the box to the left of the Show Unit and Subgroups item to show the Indicator Unit Subgroup grouping Uncheck it to view only the Indicator Data The Data tab lets you select the elements and view order in the data page of UrbanInfo User Module Fig A 6 User Preferences General Language Indicator Data Map Sound Column Arrangement Available 5D Selected 9 1 0 Time Period Area ID Area Name Indicator Data value Unit Subgroup Source Data View Alternate Row Color Fig A 6 Data To select drag and drop elements from the Available pane to the Selected pane Click to change the order in which you want the elements to appear in the data entry module Check the Data View Alternate Row Color box to view the 116 117 alternate rows in a different color Click on the color tab to change the default color scheme Map The Map tab lets you change the default map colors for the four default breaks of map wizard Fig A 7 User Preferences General Language Indicator Data Map Sound Default Map Colors L EJ E IN
72. oci Min uc ET 62 Replace base aye det i at ERO RSS ERE needles 62 Reports Wizard cru tec taber a tos tci ee s 76 Row Dalle cuaciectiesiteecesntc iacit eus 38 S SETS NYAS cor E 12 Saye REPOT ub ara rre E TER 46 Save MAG ipaesi R 47 SAVING Orap Pe ren S 51 Sirio ME EN ee E aE E T SEON aie HP 2 Selecting Area cus s estes eret n e ode weed s 23 Selecting area by map sssssee 23 Selecttmg Arca Dy DAME sco Geddes 23 Selecting graph X and Y axis uessssse 48 Selecting rows and columns e 38 Selecting Time Periods eeeeesssse 23 Setting sound options Quse ite I bet tesis 114 SOIL uU M i PER DS 7 Sort options in Table 43 SOUL COs idet ea sled Ei E 2 Statisties COUDL 1e Mere o teer cire igs 35 Statistics s IMAXTDUET 355 cii ouo EHE a RN 35 Statistics VIO e eco reist pete e e ie Led 35 SEaliStes MIDIBTUTHO eee ee e es 35 Statistics Standard Deviation ssssssss 35 Status Bab coude uie e deb tune utut hides T Suppress Duplicate Headings sssssss 38 System Redquit emellts ooa re E ORT ReGA MEER 13 T Table DHLUOT oco oue ener ce eM ee 37 Table elements in available pane Time series baf osi eese be ed vedete ee tie toss iuvdd User Preferences View full extent button View objects in Gallery esesssssss 74 Viewing data elemen
73. ointer on and select Indicator from the data menu Notice that the Indicator page is divided into three panes Fig 3 1 MB Urbarinta MOG Info 2005 mdb Fie Ect Mp UrbanInfo w AS indem i Time Period Sector Gas retrework Thame Source retiudior Convention wee rf eX Gow cya D D amp Gael Fig 3 1 Indicator Page The left pane displays the tree view of the Indicator Classification IC method The IC type is displayed in the pane header The default IC type is Goal Click on a Goal or on to the left of the Goal to display targets defined under the Goal Highlight a target to display all Indicators linked with the target in the Available pane Select one or several indicators to generate a data view To select drag the highlighted indicator from the Available pane and drop it in the Selected pane or use other methods explained on pages 11 The indicator appears in the Selected pane By default the Available pane displays the Indicator Unit Subgroup 20 Note The Auto Select Option builds on the choices made for any other parameter For example if you have already selected time then auto select selects indicators for the chosen time period Mrip Click on the column header s in the Selected and Available pane to quickly sort the indicators in ascending or descending order 21 I U S combinations Click 778 to view only indicators Click on the button to revert to the
74. olor theme click FC Click OK to apply the color theme and close the theme window Click the text box below Legend Title to enter a title for the legend Enter the number of breaks that you want to use to represent the data values in the text box below Breaks opecify the method of break Click on the drop down list next to the break text box and select from the four types of break options Equal count Equal size Continuous and Discontinuous The breaks are discussed in detail on page 40 The Minimum Maximum and Decimal values are generated from the selected data You can edit these values to set custom ranges and decimal 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 Click on the default name to customize it From column displays the minimum value included in the range To column displays the maximum value included in the range Count column displays the number of areas included in each range Color column shows the default color scheme applied for each range To modify the color click on the color tab and choose the desired color from the color palette window The row of Missing Data lists the count of areas that were selected in the Area page but do not have a data value available You can choose the color for the missing data areas by clicking on the color tab Click Smooth to create a color gradient fr
75. om the drop down menu Fig 5 19 You can modify the font and character by clicking and choosing from the drop down lists below Custom font and Custom Character respectively ip You can use the chart theme to present data on subgroups Proportional bars are suitable for representing and comparing numeric values Style B aj Custom Font Custom Character Value 200 Fig 5 19 Custom Marker options To modify the default data value that a dot represents click on the text bar below Value and enter the desired value Create a Chart theme To create a chart theme click j The chart theme window lets you modify chart display options Fig 5 20 Gap Wizard Step 1 of 5 MAX Theme ii NER CHART oie egend Ti v View Data Value Chart Size 1 Subgroup Color Female Male Sw v Fig 5 20 Chart theme Click on the text bar under Legend Title to specify a name for the bar legend Check on the box to the left of View Data Value to display the value for each bar Uncheck to suppress the data value 58 Mrip In the title and subtitle you can include information such as indicator unit and subgroup and time for the data represented in the map Note The disclaimer is important information for avoiding confusion on the use of the map You can also add name organization location and date of production of the map 59 Click and drag the slider below Chart size to modify the
76. om the first to last color of the range Choose the color of the first and last range to apply a color gradient for the in between ranges 54 You can also change the Border style for the geographical areas Border m 3 Click on the color tab below Border to change the default color for the boundaries Click on the Border outline box to choose the desired border style from the drop down list To change the border thickness click 1 00 The arrow buttons let you specify the thickness You can save the changes made to the number of breaks break legend and the legend color Click to save the changes EJ Note Click to open the legend window Fig 5 16 and choose b aa uA from the available options Check the boxes to the left of Labels for the color theme ney Color and Legend to apply all or any of these options Note Literacy rate breaks plf It is recommended to have the same number of breaks in Step 1 as the number of the breaks that are stored in the legend file to be loaded C Labels C Color Legend Fig 5 16 Legend window Click to ignore any changes made to the default settings 55 Create a Hatch theme To create a hatch theme click Al Notice that the Hatch theme has the same options in Step 1 as the color theme Fig 5 17 Baap Wizard Step 1 of 5 Theme Mors MX NER Female Legend Title In the map preview the pm hatch pattern will be overlaid on the color t
77. ormula amp File Edit view Insert Format Tools Data Window Help Al f Devinfo Data Entry Spreadsheet B C D E E ee 1 Devinfo Data Entry Spreadsheet 2 3 Sector Demography EM Life Expectancy 5 Indicator Life expectancy at birth Index Decimals 9 Time Area ID Area Name Data Value Subgroup Source Footnotes AFRAGO Angola AFRBO Burund AFRBEN Benin AFRBFA Burkina Faso AFREVWVWA Botswana AFRCAF Central African Republic AFRCIV C te d ivoire AFRCMR Cameroon Coman Dom Rem 14 71 Total UNICEF SOWC 2004 15 71 Total UNICEF SOWC 2004 25 71 Total UNICEF_SOWEC 2004 20 71 Total UNICEF SOWC 2004 15 71 Total UNICEF SOWC 2004 14 71 Total UNICEF SOWC 2004 15 71 Total UNICEF SOWC 2004 21 71 Total UNICEF SOWC 2004 4c 74 Total Phecce CMAs nnha4 Is verry yt seoa v Fig 8 34 Preview Data Entry Spreadsheet Click Finish to save the calculated data in a new database 110 Menu Bar Options 111 File Menu The File menu is available on all the pages It has the following sub menu options Fig A 1 File Edit Help Open Chrl 0 Database Summary Report User Preferences Ctrl U Exit Ctrl g Fig A 1 File menu Open You can use this option to open a database You can open an offline database available on the local computer or an online database available on the web These options are discussed on page 16 Database Summary Report You can use this option to generate a compr
78. ors P The Data View Fig 8 30 contains Life expectancy at birth in years of some countries in Africa for the year 2000 2005 We can use the User defined formula option to calculate Life Expectancy Index using the formula Life Expectancy Index Life expectancy at birth 25 85 25 The User defined formula option involves four steps 106 Step 1 Indicator In Step 1 enter the custom formula in the formula bar Fig 8 31 Calculate User Defined Formula Wizard Step 1 of 4 Indicator Jal X User Defined Formula Available 1 Indicator Subgroup Label CF Life expectancy at birth Total A User Defined Formula X ce Lite expectancy at birth Total 25 85 25 amp 25 85 25 Sw v Fig 8 31 Indicator Use the operators available below the Formula Text bar to form your argument Notice that you can use labels for the long indicator names in the text bar For example you can use A instead of the long Indicator name The window below the operators displays the long indicator name Click Next to proceed to Step 2 107 Step 2 Save As In Step 2 you can provide the Indicator classification option Fig 8 32 Calculate User Defined Formula Wizard Step 2 of 4 Save As User Defined Formula Indicator Classification Sector Sector Demography Life Expectancy Population Population Growth x Economy i Education Indicator Life expectancy at birth Index U
79. plays several useful statistical values Fig 4 8 Ui Urhaniinga MOG Info 2005 mdb JJ Fie Eck Hep Urban Info ki Indicator C Time Period Aren LJ Data ica Galery ge Reports 8 View Source uat Suogrouwp Slelisiice Cacusle Table ant Mi we A amp oe A indicestor Unt Subgroup Count Miriam Miscomam eon Standard Daviscon Intent mortally rata Ceaths per 1000 live Tota 222 6 163 45 211 T1171177117 34 3411646354278 Mataral mortality relio Dexns per 100000 Tow 8 A 110 18309483372003 187 821031630491 Fig 4 8 Statistics Count Displays the number of unique I U S combination records Minimum Displays the minimum data value for a given I U S combination Maximum Displays the maximum data value for a given I U S combination Mean Displays the simple arithmetic mean for the range of data values for a given I U S combination Standard Deviation Displays the standard deviation for a given Il U S combination 34 CHAPTER JE Presentation Wizards 35 Urbanlnfo 2 0 has inbuilt presentation wizards to help you prepare professional presentations and reports The wizards guide you through a series of steps to help you decide the content and style of the output The output is saved along with the data sheet and data sources You can use the wizards to produce outputs in three formats Table Graph and Map Table Helps you prepare and save a Table presentation in seven steps
80. r code the data Fig 5 3 Table Wizard Step 2 of 7 Joe Title Net enrolment ratio in primary education Subtitle Percent Footnotes Inline V Apply Color N Indicator ote Net enrolment ratio in primary education vV Decimals Breaks Minimum Maximum The Table wizard allows you to ma T Sn L1 2 specify the color for a maximum High is Good of 10 breaks Legend Label Label2 Label 3 Label 4 From To Count Color 21 6 86 9 43 87 0 91 3 45 91 4 957 43 z 35 8 100 0 40 mE Click to select method of break mes stp v Fig 5 3 Step2 Click on the text bar below Title to enter the table title Click on the text bar below Subtitle to enter table subtitle Check the box to the left of Footnote to display footnotes The footnotes will appear at the bottom of the table Check the box to the left of Inline to make the footnotes appear in the cell along with the data value Mrip A data value with an inline Check the box to the left of Apply Color to arrange the data into footnote will have ared square breaks and assign a color for each break You can group the data on the top right comer s and apply color for each indicator in the data view Click on the text box below Indicator to view and select the indicator for applying breaks and color scheme To select the number of breaks enter the desired number of breaks 39 Mrip Choose equal count to distribute the
81. rie etos ener ees eerie none 62 Legend labels siae Ai Par cos eres he ee 40 Tra M 53 Ene dd Ci ses space sees e E A ULLA E E E 62 M Making a Selection o Aw See eee 7 Mappoimte r DOUNON matonen cadebat 62 Map theme options eeeee 53 Map tool bar b ltobs riui tonio cec eo die oo totae neos 62 hoo ori FTT ntact aca cannibal Mesut eamacaetites 7 Methods 0f Break o E tide ise 40 Minimum and Maximum range ccccceeeeeeseeeeeeens 40 IVHSSIHT E T0 d osos eene e eaae te eerta ii 53 Modify b ffer Sets uic eret ist Db ee po Eoo Ue SLE npa 62 Most Recent filter optioner aE 30 N iNavieadtion Bat assesses te teet iesu sciens ii New features of Urbanlnfo 2 0 ssussse ji New online connection essssssseses 16 OHH Database soie oo ED Een speso 16 Onlme Database a pact pt eet pes eiu dp 16 Online technical support uii ena 114 121 Open in file menu eee nis 112 P Pace ODDO Bar aceite RE EO ota EO SERIEN Noten gi Pan DUO eoe eee a eet oaa eee re Miles Cete 23 Pane Header oues t oe DE RURSUS SERAIS Ee seed J Port LAY CF dde pdt o sedi eria e tete voe e dede 62 Pob von lave ottenere estis aute 62 Presentation wizards sesssssssseess 36 Preview Graphi necesi eee 50 Preview Map cn creto eo exe val Loci eO Eco 62 71 Preview Table oo Ep et btt o et E erat 46 Product Information seen 114 R l
82. rs in the Selected pane Click OK to apply the sorting criteria and view the sorted records in the data view 28 29 Data Filter Click to open the Apply Filters window and screen the records appearing in the Data view Fig 4 3 As with the sort option in case of a data view of multiple pages the filter option is applied to data records in the current page Apply Filters Apply Filters Most Recent HU S Data Value Cry d Indicator Infant mortality rate Fig 4 3 Page Option Apply Filter Check the box to the left of Most Recent to filter and view the data for the most recent time period for an I U S and a given area The filter tool has two tabs I U S and Data Value Click on the I U S tab to set the minimum and maximum range for each I U S combination The records are filtered based on the specified range The default view displays only indicators Click CP 4 to view the I U S combination The Data Value tab lets you filter records based on the data value Fig 4 4 ip If you have specified any filter criteria under both l U S and Data Value tabs only the l U S tab filter criteria are applied Apply Filters Apply Filters Most Recent Uo0 l LJ S Data Value Between Fig 4 4 Data Value tab Click on the text box to choose from the following options in the drop down list e Between two values e Greater than specified value e Less than speci
83. rt Li CH tensive LACJAM taco CT Saint tle and h LACKMA Yorks CP Sant Lucia LACLCA Merling Cries LACMEX Mode NI w ajy Er x 4 gt Fig 3 3 Area page The left pane displays the Area tree Click on the area name or on to the left of the area to reveal the sub levels of a given area For example you can expand the Africa node to reveal the countries in Africa The areas under the highlighted node are displayed in the available pane The available pane lists the Area name Area ID and the level at which the area exists Select areas to generate the data view based on the selected areas To select drag an area from the Available pane and drop it in the Mrip In Map view click A to horizontally dock the available and selected panes This lets you view the map better Selected pane or use other methods of making a selection as explained on page 11 The area appears in the Selected pane Selecting Area by Map Click on the Map tab in the page option bar to view the map window Fig 3 4 Urmaninte MDG Info 2005 mdb we File Edt Help gt lt E o Urbanlinfo 3 Indicator 22 Time Period e Area EF Data m Gallery ie Reports bey A Mame Mag vb qe E h EN Area v gt gt vala 46 gt gt i bn Amenc P m dE X o wA A m 7 Arepuin keh hir eri AN y Ts Argert er Sir rlig JB 7 a n A Bsa 3 oss K AX C Belize yi ire bime X Aa d 3 Fami Vd c F ota f ren
84. sentation folder Highlight a presentation object to display in the right pane By default they are stored at the following location C UrbanInfo UrbanInfo 2 0 Gallery Presentations Click to open presentation objects from a different location Click 5 to delete a presentation from the folder 73 Create PowerPoint Presentation You can copy the presentation objects directly onto MS PowerPoint in the gallery folder Click to copy the selected presentation object to a slideshow The Copy to slideshow window appears Click New in the window to copy the presentation into a new file Click Open to copy into an existing presentation On choosing New Open the presentation window is split into three panes Fig 6 3 5 0MGaltor v Gallery DevintoWevinfo FD recontations oW Dow I YQ Presentations ig Nel ereciment ratio ir pricery educetion MAE NER ppt 55 E Net eramen se npe E pe Edk Wew sert Format SAR De Edt Yer Insert Format Tock SideShow Window Heb Artiste AdobePDF X Cir Net enrolment Mon pee Tons fists WW Help ax gt EL Not erecimenn ratio in pet 4 Picture 2 he 1 c M POL FR GOS RD RY O E b BL Hs Kiet enrolment ree in pr mzry ezuz3606 Pero v Click lo add notes amp nMap Msp l 4f MM ee Ast Side Loft Fig 6 3 Presentation window The extreme right pane displays the presentation object in MS PowerPoint C
85. ses Urbarinfe MDG Info 2005 mdb Fie Edt Hep Urbaninfow Pd indicate X3 Time Period f e Ares ome Fe Gale T Reports View Source Unt Sudgroup Statistics Cacusle Tobe awh Bee rw ey X Osta Ysha Uni 480000 Sumber ARNAS E000 ubere ATEO 6971520 Musi 145000 Mumbar 8661020 Murther 8160000C Mumbar M7020 ickbes 27000 Lanes ER EJ bari BOD Mumber 28200 latere 750000 liber 76000 Suche 30000 Shave DODO Suche 78000 Mucber 0000 re UNSO ITU UNSD ITU estimates i UNSD ITU eshmyes UNS TU e UNSO_JTU estimates ITIL r DIT UNSD_ITU estimates UNSD ITU i TV UNSO ITU estimates d TUe UNSOJTU estimates UNSD_ITU estimates UNSD ITU estimates NS t SD ITUe UNSD TU eslimatss UNSO IT K UNSD_ITU estimates UNSD ITI UNSO ITU estimates J D TU 1 UNSD TU estimas IED ITU z Selected 2172 UNSD JITU estimates Page of4q ie Fig 8 19 Data view for subtotal The Data View Fig 8 19 contains the Internet Users in numbers We can use the Subtotal option to generate data for Internet Users in numbers for each continent The Subtotal option involves four steps Step 1 Indicator In Step 1 Select the Indicator for which you want to calculate the subtotal Fig 8 20 n Calculate Subtotal Wizard Step 1 of 4 Indicator BAX Subtotal Available 1 D D Selected 1 I q Indicator Indicator CF Intemet users CF Internet users Sep v
86. t options esse 114 Viewing SOUIGOS d uso n tuis erm m Uh vgs ait M Ee 32 Viewing Statistics essssssseeeee 35 Viewing Subgroups eeeeeem 34 VIGWIDG UNIS societas iae rS SOR a Eden Es 33 W Word Win seek ssa n M d NIE 62 Z Zoom in button ids det umet 23 oO M OU DUO c sete es zee ioc ecce coh conan suc etc ae a 23 Zoom to selection button sse 23 122
87. t ratio in primary education Indicator Unit Subgroup Net enrolment ratio in primary education Percent Male 2 Met enrolment ratio in primary education Percent Total 3 Net enrolment ratio in primary education Percent Female 2 3 4 5 G i m g Fig 7 2 Matching results The first section of the report shows the list of Indicators present in the report as well as in the current database The second section shows the I U S combinations present in the report as well as the current database Only the matched I U S combinations will be considered to create the table You can choose the level of Area for generating the table Click on the text bar next to Area Level and select the desired area level from the drop down list Check the box to the left of Data to generate the table based on the 76 data view that you have generated Click OK in the report window to generate the table The table is displayed in Step 6 of the Table wizard Fig 7 3 W Tabie Wizard Step 6 of 7 File Edit View Insert Format Tools Data Window Help Al v f Net enrolment ratio in primary education A B C D E ment ratio in primary education Percent Indicator Area Name 1990 1991 1991 1392 1992 1993 1997 2000 1998 1998 139 X Millennium Development Goals poem rem pum Net enrolment ratio Afghanistan 42 Net enrolment ratio Albania Net enrolment ratio Algeria 33 10 Net enrolment ratio Angola 11 Net enrolment ratio Argentina 12 Net e
88. t to proceed to Step 4 Step 4 otep 4 is the final step in the graph wizard Here you can save the graph in the gallery Fig 5 12 Graph Wizard Step 4 of 4 ga V p Gallery Location j C Devinfo Devinfo 5 0NG allerNPresentationsN Click Lex to browse and Presentation Name save the graph at any other mann suis location Net enrolment ratio in primary education T able Back Step4 v Finish Fig 5 12 Step 4 opecify a name for the graph to save it in the gallery The graph can be viewed in the Gallery This graph can be copied into other MS Office application with the help of the tools available in the Gallery 50 Creating Maps Note UrbanInfo projects the thematic maps onto the raster images from NASA s WorldWind application 5 The map wizard lets you link data to geographical units to create a thematic map The 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 performing geo statistical analysis You can create a wide range of thematic maps using gradients colors patterns and charts and use these themes alone or in combination You can associate feature layers such as roads and rivers onto the thematic map to improve its visual impact You can also overlay the thematic map on a three dimensional globe a raster image
89. the X Axis and Y Axis boxes 47 otep 2 In Step 2 you can specify the title and subtitle for the base table used to create the graph Fig 5 10 Graph Wizard Step 2 of 4 Joe Title Net enrolment ratio in primary education Subtitle 2001 lv Sort by Data Value Back Step 2 v Next Fig 5 10 Step2 Check the box to the left of Sort by Data Value to sort the table on the data values of the first data column You can change the order of sorting by clicking on the arrow button next to the checkbox Click Next to start the process of specifying the graph type Here the graph wizard of MS Excel takes over and lets you choose from the different types of graphs and other settings 48 49 Step 3 In Step 3 the Excel chart wizard prepares a graph based on your inputs You can now preview the graph as a MS Excel workbook Fig 5 11 GB Graph Wizard Step 3 of 4 G File Edit View Insert Format Tools Chart Window Help Het Enrolment in primary education Netherlands Antilles Bolivia M 4 gt nNGraph Table Data Source 93 v Fig 5 11 Step 3 The preview window contains four spreadsheets Graph sheet displays the chart Table sheet displays the table used to generate the graph Data sheet displays the data view on which the graph is based Source sheet displays the data sources and the current database Here you can make further changes to the graph Click Nex
90. the breaks for such indicators you can set the high is good option to No to apply the color scheme in reverse order Click Apply to apply the number and method of break specified above The bottom portion of the window gives a preview of the break ranges count and color applied to each range You can edit the Legend labels by clicking on the text boxes in the legend column You can change the color for any data range Click on the Color tab for a range to choose the desired color from the color palette window Click Next to proceed to Step 3 Step 3 In Step 3 you can specify the grouping criteria for the data rows and the sequence of the column arrangement Fig 5 4 B Table Wizard Step 3 of 7 ole 9 9 v Classification Arrangements Indicator Classification Classification Select Sector v Millennium Development Goals Goal Framework Theme Source Institution Convention V Column Arrangement Time Period 1890 Specify classification level 2001 Cancel Back Step 3 v Fig 5 4 Step 3 V rio Use 4 to prioritize the sort elements Check the box to the left of Classification Arrangement to group the data rows by Indicator Classification IC categories You can choose from the seven ICs Sector Goal Framework Theme Source Institution and Convention Highlight the IC type in the left pane to view the available categories in the Classification select pane The check
91. the data view you can also export to a Database mdb or to a UrbanInfo data entry spreadsheet format Open the Information window and display metadata for the highlighted element la Toggle Pane View between horizontal and vertical view A Search for the keyword mentioned in the text bar The elements matching the search criteria are displayed in the available pane 2 Open the Sort window to choose the sort elements and sort order for sorting records in the data view It is explained on page 28 7 Apply Filter criteria to screen records in the data view It is explained on page 29 The table below presents a checklist of the tools available for each page Tas Pane Header The Pane header identifies the pane contents and displays the count of items in the pane Note Status Bar Displays progress of the action being processed It also ane chunical teimere displays system time and date displayed only for the em and Selected W Shows the status of the speakers Displays Offline when a local database is accessed Displays Online when a database is accessed from a remote server 10 Making a Selection Selection refers to making the item appear in the Selected pane To select do one of the following Double click on the item in the Available pane Click and drag the item from the Available pane and Drop it in the Selected pane e Toselect items highlighted in the Available pane o Click D
92. try Spreadsheet In Step 4 you can preview the new indicator in the data entry spreadsheet view Fig 8 12 Calculate 100 Minus Wizard Step 4 of 4 Preview Data Entry Spreadsheet 100 Indicator amp Fie Edit View Insert Format Tools Data Window Help B5 X f Illiteracy rate of 15 24 year olds B cC D Se 1 Devinfo Data Entry Spreadsheet 2 3 Sector Education 6 7 Unit Percent Decimals 9 Time Area ID Area Name Data Value Subgroup Source Footnotes 10 11 500 ASIARE United Arab Emirates 12 7 990 ASIARE United Arab Emirates 13 1989 ASIARE Uned Arab Emirates 14 988 ASIARE United Arab Emirates 15 i987 ASIARE United Arab Emirates 16 986 ASIARE United Arab Emirates 47 i985 ASIARE United Arab Emirates 20 Total 15 24 yr UNSD UNESCO 18 i984 ASIARE United Arab Emirates 21 Total 15 24 yr UNSD_UNESCO 40 ac eC Lintad vols Emieoteo Sh fh O o P ID PII di M Data Ready 9 Total 15 24 yr UNSD UNESCO 15 Total 15 24 yr UNSD UNESCO 16 Total 15 24 yr UNSD UNESCO 17 Total 15 24 yr UNSD UNESCO 18 Total 15 24 yr UNSD UNESCO 19 Total 15 24 yr LINSD UNESCO www S 6 ELE Sw v Fig 8 12 Preview Data Entry Spreadsheet Click Finish to save the calculated data in a new database 88 89 Composite Index A composite index is constructed by combining the values of several indicators into one value on a defined scale You can assign weights to the indicators and cr
93. uction gives a preview of New features of URBANINFO 2 0 Content Overview User Interface uli cium 1 New features of URBANINFO 2 0 The new features of URBANINFO 2 0 give you more options in querying for data and help to undertake results based monitoring and effective advocacy The new features include e User friendly interface for hassle free navigation e Online data access and query e Grouping bar in data view to better organize and analyze data o Enhanced Table wizard features Aggregate function more options for cross tabulation e Enhanced Map Wizard features Options for Dot density and chart theme label nudging inset and exporting to raster image e Reports feature to store report templates and apply ready to use report formats across databases In figure 1 page options for the Indicator page sector goal framework theme source institution and convention are displayed in the 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 inactive buttons appear in grayscale E gt Open the window to select a different database Print the contents of the selected pane to a PDF file Export the contents of the selected pane into the following file formats MS Excel Spreadsheet xls Comma Separated Value csv Portable Digital File pdf Hyper Text Markup Language html and eXtensible Markup Language xml In
94. urber c UND ITU estimates 152000 ate cad UNSOJTU e 12000 urbe cts UNSD ITU estimates 06796 Munker Total UNSD TU estime 4000 hebes ctel UMSD ITU eshmetes DO hrbe Teta F JTI 31000 Mumber c UNSO ITU estimates Fig 8 24 Data view of source indicators The Data View Fig 8 24 contains the Internet Users in numbers for select countries Let s use the Transform Unit option to generate data for Internet Users in thousand The Transform Unit option involves five steps 100 Step 1 Indicator In Step 1 specify the Indicator for which you want to transform the unit Fig 8 25 Calculate Transform Unit Wizard Step 1 of 5 Indicator Joey Transform Unit Available 1 D D Selected 1 18 Indicator Indicator CF Intemet users CF Internet users Canoe Sw v Fig 8 25 Indicator To select double click on the Indicator in the Available pane The Indicator appears in the Selected pane Click Next to proceed to Step 2 101 otep 2 Unit Conversion Factors In Step 2 specify the conversion factor and the target unit Fig 8 26 Transform Unit Target Unit Thousand istep2_ y Fig 8 26 Unit Conversion Factors Enter the target Unit in the text box below Target Unit Enter the factor of conversion in the Conversion Factor column The source unit will be converted into the target unit based on the conversion factor Click Next to proceed to Step 2 102 Step 3
95. ve the connection for future use Hew Connection Connection D etak Type Microsoft SQL Server Connection Mame Server Mame Database Mame User Mame Password Fig 2 4 New Connection Click amp to delete any server connection available in the drop down list 18 CHAPTER J Data Parameters There are three data parameters that define the data value Note l T Indicator Time and Area ata parameter defines a particular characteristic of the data value These parameters help you to query the database and generate a Data view You can then prepare a Table Graph or a Map You can select the parameters in any sequence You can choose to modify the parameters at any time The process of making and deleting a selection is similar for all the parameters 19 Selecting Data Parameters Note An Indicator is a pointer or yardstick to access the progress of the intended goal or objective In DI Indicators are linked with Units and Subgroups to form I U S combinations ip Select File User Preferences Indicator to select the default Indicator Classification view for the Indicator page Note If you highlight a node with multiple sub nodes then the Available pane displays indicators linked to the highlighted sub node Viri Use ex to search and locate indicators Selecting Indicators You can select indicators from the indicator page In the home page place the mouse p
96. ve the table in the Gallery with the default formatting and presentation If you are not happy with the applied table format you can go back to Steps 1 through 5 and make the necessary changes Click Back to go to the previous step You can also click on the combo box and select the desired step from the drop down list Let s start with Step 1 36 Mrip You can either use the subgroup or the elements of the subgroups such as age Sex location etc This gives you more options for cross tabulation 37 Step 1 In Step 1 you can specify the row and column elements that you want to include in the table You can also choose to insert aggregates sum count and mean and categorize the data records Notice that the Step 1 window is divided into four panes Fig 5 2 re e Ves lea B Table Wizard Step 1 of 7 Jag Available Columns Q g I9 9 Indicator Time Period nit Age Group Dthers Source Area ID Subgroup Location Sex Rows g amp Q D Aggregate Functions Area Name V Aggregate Functions Sum Count Mean Group By None vi Suppress Duplicate Headings mes Sel v Fig 5 2 Step 1 Available Pane Contains the list of elements that you can select for the rows and columns You can choose from the following elements Indicator Time Period Unit Subgroup Area ID Area Name Age Group Sex Location Others Mrip it The Move up and down buttons on the row and column head

Urban Info guidelines - UN

Contents

Download Pdf Manuals

Related Search

Related Contents