Home

ARGISS - ENBOSSSupport.com

1. OMAHA LINCOLN NE Total rows in query 20 Print Orientation Launch Excel Close 11 47 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Save the Results of the Query 1 Click Save to save the results of the query The following Save Query and Data dialog appears A Save Query and Data E4 e Save Query Information Query Hame STATE_FACILITIES Description HE FACILITIES USING COMPLEX TABLE Access Level Read Only other users can only read Private other users cannot read or modify Read Only other users can only read Public other users can read or modify ODBC Profile fps reports Existing Queries Creator Access Table Hame NECOMPLX Database lenbossiargiss fpsidata Database Type FoxPro Save Cancel Check the Save Query Information check box Enter a query name and description in the Name text box and Description text box respectively In the Access Level text box choose an access level from the drop down box Select fps reports as the ODBC Profile Enter NECOMPLX as the table name in the Table Name text box Click Save Click OK on the save confirmation message dialogs Click Close on the View Edit Untitled Result Data dialog Notice the title bar of the Query dialog It has changed from untitled to the query name you have specified 9 Click the Close button or Query gt Close eal a E ITE 48
2. To search by contents click on a topic 4 To search on a keyword click the Search tab and in the keyword that you would like to search on 99 Exiting the Facility Planning System To exit FPS l Click File gt Exit MapInfo from the menu bar ze Click OK to exit 11 22 EVER VIGILANT ARGISS ENBOSS Training Manual FPS Data Management 11 23 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Objectives The objectives of the FPS Data Management section is to educate the user on how to maintain and update the data files that FPS needs in order to run the Create Application Data process ARGISS does not create any of its own data However the geographical data and the process of refreshing new tables from other directorates are necessary to ensure the data that is read into FPS during the Create Application Data process 1s current and accurate This section will cover the following Updating Facility Ids and the Georeference Table Refreshing the Force Program File Refreshing the SIDPERS Table Updating the FPS Table Running the Create Application Data Process for FPS a We present the following information so the student understands the process to create the databases that are used by FPS Updating Facility Ids and the Georeference Table The EMAAR and RISER systems are updated at the RRC RSC When Facility Ids are added or deleted in EMAAR those Facility Ids are not automaticall
3. aval Hx for all asr fy A eS bitmap cue total ceiling tot corrut casel x when a ther oblig_ arnt char crtena sel crit El a cost x x ba 3 Select the column to filter from the Columns list box 4 Specify a function from the Functions list box select an operator button or type an operator 5 Enter a value to search for The example in the window above will filter the ASR Report for all pri_ams Z In other words the totals for all environmental work orders will be retrieved Remember character fields must have double quotes around the value 6 Click Verify A message box displays to indicate if the filter function is valid a Click OK if the filter expression is valid 8 Click the Retrieve button on the FPS Reports window to refresh the report The report will be displayed with only the data that met the filter that you specified To exit Canned Reports I Close the open report by selecting File gt Close Ze Click the Exit button from the Painter Bar I 15 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Mapping Canned Reports To map an existing Canned Report l Specify a search criteria to create the Canned Report Remember to re specify a search criteria click Info from the FPS MapInfo dialog and then select Change Info 2 Search All Facilities by state and click Canned Reports from the Search By Information dialog Search By Information X State Abbreviation Map
4. z 6 ARGISS Training Manual Expression Columns Operators Funchons Type an expression Lancel Verity Help Click Verify then OK when expression 1s complete To sort the results by a specific column select the column to sort by in the Sort by Column drop down box Click OK The expression will query the selected table extract the records that meet the expression and display the results in a Browser window To save the results of the query to a permanent file select File gt Save Copy As and give the Selection a permanent file name Selecting Using SQL Select While MapInfo s Select command lets you formulate sophisticated queries SOL Select goes even further The records in the query table generated by the Select command do not have any information in them that 1s not contained in the records of the base table They are in fact the same records They have been arranged so they can be viewed together With SOL Select you can create query tables containing information that was only implicit in the base table To do an SOL Query do the following l Select SOL Query from the Query menu option In the from Tables box choose a table s from the Tables drop down box You can query multiple tables using SQL Select You must fill in the from Tables box before you fill in the Select Columns box MapInfo uses the tables in the from Tables to generate the list of columns used
5. ARGISS Training Manual CACI EVER VIGILANT ARGISS Training Manual Terms and Abbreviations ARGISS Terms ACSIM Assistant Chief of Staff for Installation Management ASR Account Summary Report ECS Equipment Concentration Site Ad hoc reporting tool developed by PowerSoft LSR Lease Report MACOM Major Army Command Maint Maintenance Site MapInfo Mapping software developed by MapInfo Corporation Maintenance Backlog By Tier Report PlanView ARGISS Sites and Floor Plan system tructured Query Language myrna Regional Office of CACI Smyrna GA torage Facility TNG Training site UAT UIC Unit Identification Code CACI EVER VIGILANT ARGISS Training Manual B 4 USAR United States Army Reserve USARC United States Army Reserve Command USARC DCSENG United States Army Reserve Command Deputy Chief of Staff Engineer CACI EVER VIGILANT ARGISS Training Manual Microsoft Windows Terms Active Window The window you are currently working with or just selected The active window is the topmost window Application A computer program that performs a specific task such as word processing Application The primary window for an application This window can contain Window multiple windows within it Check Box A square box that appears within a dialog box which contains an X when selected and is empty when deselected Command Menu The large square button with a horizontal
6. ARGISS pulls data from existing databases maintained by the United States Army Reserve These databases include Engineer Base Operating Support System ENBOSS Individual Training and Readiness System ITRS Force Program File DCSFOR I 3 CACI EVER VIGILANT ARGISS ENBOSS Training Manual O Relational Database Management System RDBMS Overview ARGISS 7 0 completed the migration from the FoxPro DBMS to Sybase SQL Anywhere a RDBMS A RDBMS is a software application that organizes data in relationships Relationships are created by including common columns in the tables that will be related For example ARGISS entity table and bridge table both have a database ID column DB_ID to create a relationship between the two tables A RDBMS stores data in tables The tables are stored in a database The database is seen as a single file in a directory but the tables cannot be seen or accessed without special software called a database engine A valid user name and password are also required to access the tables in the database These security measures make it difficult for someone to edit data or delete a table DBMS tables on the other hand are less secure than RDBMS tables In contrast each table in a DBMS such as FoxPro can be seen as an individual file in a directory This means the tables DBMS can be moved renamed or deleted intentionally or by mistake using the Windows Explorer Data in the tables DBMS
7. Obligation Summary Report Stationing Report Current Stationing Report Projected The report formats look something like the one below Report account_summary_report oix Page 1 of 36 UNITED STATES ARMY RESERVE ENGINEER ACCOUNT SUMMARY REPORT For Official Use Only SELECTION CRITERIA Regional Support Command 88TH FAC ID TITLE LOCATION FY WORK CLASS ESTIMATED COMMITTED IL001 PARKHURST USARC OM5 D5 DARIEN IL 19397 K 5 000 00 0 00 1995 J 94 209 00 91 771 39 1995 K 75 450 00 40 221 74 1995 993 67 1 104 74 1993 J 0 00 30 007 96 1999 K 19 254 00 112 551 00 1999 P 0 00 429 20 TOTALS FOR FACILITY 215 506 67 335 266 11 IL002 COL P SCHULSTAD USARC ARLINGTON HEIGHTS IL 1995 F 0 00 19 152 26 1995 J 160 061 45 315 556 11 1995 K 455 000 00 155 964 69 23 April 1999 08 19 51 OBLIGATED 0 00 40 634 25 96 221 74 0 00 30 007 96 17 524 00 0 00 157 267 93 0 00 136 760 47 156 964 69 4 1995 412 591 55 311 305 ii 4 11 14 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Filtering Canned Reports Filtering a report allows the user to extract specific data from the reports by specifying filter criteria To filter the report data l Click Rows from the menu bar 2 Choose Filter The Specify Filter dialog will appear Specify Filter DE Caneel Ney Verity pr ame Z Cancel Functions Columns abs asc fac state pr ams
8. Styles Position Anchor Point J Label Lines m EA C Simple X 7 Rotate Label with Line E Arrow Label Offset 2 Points Cancel Help 5 Check the Allow Overlapping Text check box 6 Click the Style button under the Styles options Text Style Font Arial fis i l The quick brow iia n fox jumps ove Background Effects C None Halo C Box W Bold Underline Shadow Color Italic PO AllCaps Expanded Cancel Help 7 Change the font size to 78 and the Text Color to red 8 Check the Bold and Underline check boxes under the Effects section 9 Click OK C 49 CACI EVER VIGILANT ARGISS Training Manual 10 Click OK on the Stateshr Label Options window 11 Click OK on the Layer Control window Turn the AutoLabel Off l Open the Layer Control window 2 Uncheck the AutoLabel check box for the Stateshr layer 3 Click OK Open a DBF File You will now open NECOMPLX This is a dbf file that was saved as a result of the STATE FACILITIES query that was developed in the Data Bridge practical exercises NECOMPLX contains facility information from EMAAR for the state of Nebraska 1 Select File from the menu bar 2 Select Open Table from the menu items Open Table Look ir 3 Data 2 Ga_close dbf 2 ne_riser dbf 2 Pbeatmt dbf E ga_facil dbf E ne_wkord dbf Pbcattbl dbf Ga_facs dbf e mecompls dbf Pbcatwld dbf largefac dbf E oblamr
9. V 22 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Conclusion PlanView is a very powerful automation tool that allows the user to quickly view and register site and floor plans The system also provides for full MapInfo functionality The system can be used by novice as well as experienced Map nfo users To summarize you created the following map and workspace NE003 layout window of NE003 site plan and a thematic map of the main USAR center Ist floor plan labeled by room name The saved workspace will be used in the Conclusions and Overview Section IV 23 CACI EVER VIGILANT ARGISS ENBOS Training Manual This page intentionally left blank IV 24 CAC ARGISS ENBOSS Training Manual Appendix A Geographic Data Sources A 1 CACI EVER VIGILANT A 2 ARGISS ENBOSS Training Manual This page intentionally left blank CACI EVER VIGILANT ARGISS ENBOSS Training Manual Geographic Data Sources There are many resources available that provide geographical data that can be either opened directly in MapInfo Professional or translated into MapInfo Professional The following is a list of available resources in this Appendix Internet MapInfo Professional Federal Government Agencies State and Local Governments and Universities Military Agencies Private Resellers This is not a complete list of available geographical data Most of the data will also need to be
10. Laver gt i s Cosmetic Layer E lA E Y OK Georef A TO fe ie oth ASC eT ie fe Cancel renew Label Thematic At Layers Add Bercy Help PLLC eh f 7 l Select the Text Style button from the Drawing toolbar and choose a font size and color Click OK Ze Click the Text button from the Drawing toolbar Position the pointer where you want to place the title and click the left mouse button 4 Type a title 99 C 85 CACI EVER VIGILANT ARGISS aa Training Manual Print your MCAR map k Select File gt Print 2 Select your print options and then click OK Save the Windows as a Workspace l Select File from the menu bar 2 Select Save Workspace 3 Give the workspace a name 4 Click OK Conclusion The Advanced MapInfo practical exercise gave you an advanced understanding of MapInfo functionality Desktop GIS can be a valuable tool to engineers planners real estate specialists and facility managers You are encouraged to practice using Maplnfo after the conclusion of this class The strip map with directions from the Omaha airport to NE003 and map of all the MCAR projects with only the states in the 89th RSC displaying will be used for the Congressman s presentation CACI EVER VIGILANT ARGISS 2 Training Manual This page intentionally left blank
11. MapInfo Corporation the makers of MapInfo Professional has a substantial amount of data for sell in their Geographic Information Systems catalog Maps retail from 300 10 000 MapInfo has a web site that has additional information and available data at http www mapinfo com A 4 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Federal Agencies National Wetlands Inventory NWI URL http nw1 fws gov The National Wetlands Inventory NWI develops and disseminates biologically sound scientific information on the characteristics and extent of the Nation s wetland resources This data is available at no cost and can be downloaded from the NWI website United States Geological Survey USGS URL http www usgs gov USGSHome html The USGS website contains topics in geology mapping remote sensing and water resources Multiple data types and formats can be accessed from this site However much of the data is not free and a processing charge is likely to be applied for the USGS data The most important and useful data available include the following formats DLG digital line graphs DEM digital elevation models DTM digital terrain models USGS Quad Sheets 1 12 000 1 24 000 1 100 000 and 1 250 000 scale maps DOQ digital orthoquads Satellite Imagery multiple satellite imagery including SPOT and LandSat imagery Federal Emergency Management Agency FEMA URL http www fema gov This site contai
12. Open the States Table 1 Select File from the menu bar 2 Select Open Table Open Table Look ir J Basemaps 2 EJ Usrppa tab lan Cities tab a Usrppp tab a Counties tab lan Usrppt tab E Mcarl tab E a Usrrdl tab a Miltbase tab a Uscongrs tab a Zipl tab a cean tab Ush tab File name Sratesh tab O0 Files of type Mapinfo tta H Cancel Help Preferred View Automatic 3 Select T ENBOSS ARGISS BASEMAPS STATESHR TAB 4 Click OK A map of the United States will appear in a Map window Zoom In Zoom Out and Grab Use the Zoom In EU Zoom Out and the Grabber tools to navigate around the map and change views Practice using these tools for a couple of minutes CACI EVER VIGILANT ARGISS Training Manual Change the Map Options To change the map options l Select Map from the menu bar 2 Select Options Hap Options Map Units Distance Area uzing Coordinate Units Spherical Distance Units miles a Area Units square miles Apply Clip Region Using O artesian Display in Status Bar f Zoom Window Width C Map Scale Cursor Location Windows Device Clipping all objects C Windows Device Clipping no points text Erase Outside no points text When Resizing Window f Fit Map to New Window I Scroll Bars O Preserve Current Scale M Autoscroll Projection M Show DMS Cance
13. Select Complex from the Table drop down box 6 Highlight ALL of the fields from the Field Names drop down box hold the shift button down and select the first and last field or drag the cursor down 7 Click Insert to insert the selected fields into the Data Bridge Table Click OK in the confirmation message box 9 Click Close to get back to the Local Table Maintenance window and Close again to return to the main Data Bridge dialog GN Ss 11 45 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Query the Complex Table for Facility Data Once the Data Bridge table is populated with data you can perform queries on the data through the Data Bridge Query menu The following steps will query the COMPLEX Table from EMAAR for all the facilities in the state of Nebraska l To create the new query click on the New icon from the main Data Bridge dialog or select Query gt New 2 From the Key Field drop down box choose FAC _ID from complex as the key field This should be the only key field available at this point Select Key Field EE ls Suppress duplicate rows Field Descriptions Selected Field Descriptions Add All gt gt mdd z lt lt Remove All B no_ex_bld ofc_in_chg Remove on_active 3 Double click the following fields from the Field Description list box coe_dist fac_city fac_state fac_street fac_title fac_zip ifs_sf_ total Do not remove FAC ID from the Selected Fie
14. 10 Select the Autolabel layer that you are labeling Group Autolabels Autolabel layer SGMA Cancel 11 Click OK The labels are now spread out and easier to read I 20 EVER VIGILANT ARGISS ENBOSS Training Manual Viewing Site and Floor Plans in ARGISS PlanView is a separate ARGISS module that displays the site and floor plans of those facilities for which digital plans are registered PlanView can be conveniently launched from within the FPS module to view site and floor plans for each facility To launch PlanView select Lammie from the ARGISS Application Group View Help e mi Type Site Plan Floor Plan Facility ID TH Display Building Ready PlanView will be discussed in detail in Section V I 21 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Accessing FPS Help To access FPS help l From the Help menu select MapInfo Help Topics or select the Help option from the ARGISS program group 2 The following FPS Help dialog will appear This dialog allows the user to view the contents of the on line help or search by a keyword Help Topics Mapinfo Help Contents Ei Ei Contents Index Find Click a book and then click Open Or click another tab such as Index Using Maplnta Ce Reference Information e Microsoft Office 97 Compatible qe Technical Support gb Maplnto Map Overview Ca Maplnto Map Reference Information Open Print Lancel
15. 2004705714 LAH 2004705714 Local 2004705714 W Back Up Current Data Copy Cancel 3 In the Directory Information window click Continue 4 Select the All Facilities check box from the Select Options group gt Highlight City from the Search By box I 28 CACI EVER VIGILANT ARGISS ENBOSS Training Manual City State ip Code Congressional District Unit Identification Code Regional Support Command mo m El E llas Click Continue The Search By Information dialog will appear Enter Omaha in the City text box Enter NE in the State text box Enter 50 in the Radius text box ade AN 10 Click Map A map of Omaha Nebraska will appear with all facilities that are located within a 50 mile buffer 11 29 el EVER VIGILANT CACI ARGISS ENBOSS Training Manual Label the Map with Fac_id You will now utilize some of the skills learned in the previous MapInfo section to customize your map Label the facilities with Fac_id l Make the Map window active by clicking on it 2 Select the Layer Control button from the main toolbar 3 Check the AutoLabel check box for the List layer Cosmetic Layer Ind Value with Comp 4 Calif even il Wie caman il gt Label with the Fac id I 30 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 6 Check the Allow Overlapping Text check box and uncheck the Allow Duplicate Text check box I Click the Label Styles
16. 825 Rzcbndry Ocean Stateshr Map CACI EVER VIGILANT ARGISS Training Manual To access the Layer Control dialog box click the Layer Control button Ed from the Main Toolbar or select Map gt Layer Control You can also access Layer Control by placing the cursor inside the Map window and right click on the mouse then select Layer Control The Layer Control dialog box will display Layer Control Laver i T E Cosmetic Layer EOD E M E M O wp Mw f Cancel M E MO Display Label Thematic Hotlink Layers Reorder Add Remove Up Down Help FELER ieh f CACI EVER VIGILANT ARGISS Training Manual Layer Visibility The visible attribute in Layer Control controls whether a layer is visible on the map For example to make a layer invisible uncheck the layer s visible check box The layer will no longer display in the map window however the file is still open Reordering Layers In our map you see the Ocean and the RSC boundaries Because the Ocean layer is positioned on top of the States layer the land is blue We need to reorder the layers in order to see the State and RSC boundaries correctly l Select the Ocean layer d Click the Down button from the Reorder group and move it to the bottom gt Clicking and dragging down on the text Ocean will accomplish the same task 4 Click OK The Map window automatically redraws itself The State and RSC boundaries are now v
17. Basic Spatial Analysis Tools Creating Queries Understanding Graph Windows Understanding Layout Windows Printing Maps Graphs and Charts Saving Tables Saving Workspaces 9 0 10 9 99 9 29 9 9 29 SM Again the following section 1s to give the user a basic understanding of MapInfo Professional It 1s recommended that the user experiment with the additional functionality not covered in this section MapInfo Terminology Table HI 1 MapInfo Terminolog Definition Automatically labels objects Browser window A window that displays data in tabular form The topmost layer of a map which contains temporary graphic objects Geocode The process of assigning latitude and longitude coordinates N to records in a table so they can be displayed as objects on a map A window that displays numeric data as a graph A window that displays a table as a map A process to generate new information with a table or map A type of map that uses colors and fills patterns to graphically display information A saved configuration of MapInfo windows The tabular representation of data similar to a spreadsheet C 3 CACI EVER VIGILANT ARGISS Training Manual Toolbars There are three toolbars most often used in MapInfo Standard Main and Drawing Each of these are dockable toolbars that can be placed anywhere by clicking on the title bar and dragging to the desired location Once you have placed the toolbars in the desired location this can be s
18. Click OK The objects are now displayed on the map and need to be labeled CACI EVER VIGILANT ARGISS Training Manual Labeling Your map To label your map The autolabel check box in the Layer Control is by default not activated To activate auto labels simply check the box for the layer you want to label The Label tool from the Main tool bar can be used to interactively label objects on the map To change the default auto label options for the map l From the Layer Control window select the Label button Nebraska Label Options M Allow Duplicate Text Dizpl thin A i Display within Range T Allow Overlapping Text taline Zoom 0 000 iit T Label Partial Segments Glen aman i 00 000 mii Maximum Labels Hm Position f 3 al Tar Label Lines RE W Rotate Label with Line Label Offset 2 Points i None C Arow Cancel Help 2 Select a field to label the layer with from the Label With drop down box You can label the layer with any fields within its database 3 Check the Allow Overlapping Text or Allow Duplicate Text if desired Aa 4 Under Styles click the button El to change the appearance of the label CACI EVER VIGILANT ARGISS Training Manual Text Style Fort 2 gt The quick brown fox jumps over the Text Color o lazy dog Effects Sample Background f None f Halo Box T Bold PO Underline Shadow T Italic TP AllCaps T Expanded Col
19. GIF Graphics Interchange Format JPG JPG PCX ZSoft Paintbrush CACI EVER VIGILANT ARGISS Training Manual e TGA Targa TIF Tagged Image File Format External Graphic Data MapInfo can import the following formats MIF MapInfo Interchange Format DXF AutoCad MBI MapInfo Boundary Interchange MMI MapInfo Mapfile Interchange IMG MapInfo DOS Image If you need to import a MicroStation file convert the DGN file to a DXF file which can be imported into MapInfo Remember when importing files into MapInfo the images will need to be cleaned up after the import and some information will be lost during the translation To display a raster image 5 Select the File menu and then Open Table 6 Select Raster Image from the List Files of Type drop down box is Select the raster image you want to display and click OK Open Table EES Look in E Usa Maps 1 EX File name Open Files of type ESCANEAR a AUR T Cancel di Help Preferred View Automatic 8 When asked if you want to simply display the image or register 1t so it will have geographic coordinates click Display CACI EVER VIGILANT ARGISS Training Manual Haplnto gt Do you want to simply display the image or a register it 0 that it will have geographic coordinates Register NEW_HQ Map E ae tn pl C 71 EVER VIGILANT ARGISS Training Manual Advanced MapInfo Features Prac
20. Mapinto Professional ME File Edt Tools Objects Query Table Options Map Window Help isle Sl a gt aaa alla fajofojo aJa l e 4 A aaa 1149 2 6 2 EE Ela amp AROOICIF Map Legend of AROO1 B Ea AR00161F by RoomMame Admin 5 Arms Room 11 Assembly Hall 011 Classroom 11 Corridor 11 Equipment Room Janitors Closet Kitchen Latrine Rifle Range Scullery storage Vestibule Classroom Latrine Assembly Hall Equipment Room E El O o O El E 0 E c E Scale 1 in 19 43 tt a Editing None a Selecting None Opening PlanView s On Line Help The Help menu provides access to the on line help for PlanView On line Help offers the complete ARGISS User Manual Exiting PlanView To exit PlanView l Select the View menu option from the Plan View menu bar and select Exit Ze Or press the Exit button T IV 12 EVER VIGILANT ARGISS ENBOSS Training Manual PlanView Practical Exercise IV 13 CACI EVER VIGILANT ARGISS ENBOS Training Manual Scenario Using the PlanView module create a site plan floor plan and a thematic map for NE003 Label the floor plan s rooms and add a title to the site plan Add the site plan floor plan and thematic map to a layout window and print the layout Also register your assigned site plan and a floor plan into the PlanView system Only one person at a time can register a site or floor plan therefore you m
21. Operators Functions Lancel Verity Help Type an expression proj title chr 13 Fac_cit Type in the following expression Proj_title chr 13 Fac_city Click Verify If the expression is valid click OK If not re enter the expression Check the Allow Overlapping Text check box Change the font and any other options O Click OK from the Label Options window 1 Click OK from the Layer Control window ZORTAM The map is now labeled with Proj_ title and the city that the facility is located in Move the labels around so they are visible Your map should look similar to the example below CACI EVER VIGILANT ARGISS Training Manual 15 15 118 N 6 S 00 0 PE ll A MS AN EXPAND MEP CONS ACCESS ROAD Expand AMSALOMAS SAC CITY E SIOUX CITY Wdd Alt USARCIOMSIMEP GARNER pe Addfalt USARC Twa CITY CONSTRUCT USAR f NORTH PLATTE EXPAND POYV MEP erations of USARC HASTINGS Build to Suit Leased Facility HAYS AddfAlt USARCIOMS HAYS USARCIOMSIAMSA TOPEKA SONST USARCIOMS ADDIALT USARTCIOMS PEKA WICHT A CONSTRUCT OMS amp ME WICHITA Add Alt USARCIOMS 4 WICHITA Add Alt USARCIOMSIAMSA CONSTRUCT USARCIOMS addikt USARCIOMS WICHITA ARKANSAS CITY INDEPENDENCE ROS y Add a Title to your MCAR map l Click the Layer Control button Ze Make the Cosmetic Layer editable by checking the Editable check box 3 Click OK Layer Control
22. Pl l Click the Save toolbar button The Save Query As dialog displays 2 Enter a Query Name and Description and choose an Access Level da Save Query As Existing Queries 7 Save Query Information Query Hame Creator Access Description Access Level Private other users cannot read or modify cancel Saving a Query with an ODBC Profile To save the result data with an ODBC profile l Click the Save button in the View Edit Result Data dialog l Check the Save Data Information checkbox 3 Select an ODBC profile from the drop down list To report on the data in InfoMaker use the fps reports profile 4 Enter a Table Name The name can be no longer than eight characters and must not contain any spaces 1 20 CACI EVER VIGILANT ARGISS ENBOSS Training Manual A Save Query and Data Save Query Information Existing Queries Query Hame ARGISS TRAINING Description 30 June 03 Access Level Creator Access Private other users cannot read or modify Save Data Information ODEC Profile fps reports Table Name TRAINING Database Eienboss argiss psidata Database Type FoxPro cancer 5 Click the Save button Click OK on the confirmation message boxes When saving the data without an ODBC profile the data can be saved to a DBF file a text file a Microsoft Excel file or
23. There is now a wizard that guides the user through the creation of queries Although the user will still have all of the old functionality available to them the wizard will make things easier to the novice user The wizard will also build ODBC relationships automatically Additional options added to EPS and FPS include the ability to map facilities with a functional code of Other ARGISS 6 0 was released in April 1999 This release is a 32 bit version that runs in Windows 95 Windows NT Workstation and on an NT server The software is fully Y2K compliant The Data Bridge also provides a database backup utility In the event of a server crash the back up database can be recovered so that the information that was stored in the system tables is preserved ARGISS 7 0 was released in June 2000 This release incorporates a re engineering of the EMAAR system and a transitioning into an integrated client server environment with a stable relational database management system RDBMS This has resulted in the Engineering and Base Operations Support System ENBOSS a system that converts the EMAAR database from Microsoft FoxPro to Sybase Adaptive Server Anywhere ASA e ARGISS remains extremely Windows intensive software so users must understand Windows graphical user interface when taking this course ARGISS 8 0 was released in June 2001 as part of the ENBOSS 2 suite of software This release enabled ARGISS to function more easily in a stand alone e
24. Training Manual Geocode Mode f Automatic C Interactive Geocode Table 8 using Column State h Boundary Column none Search Table Georef Symbal a for Objects im Column Fac_id Optional Retine Search with Table none using Boundary Mame Column none Lancel Options Help 3 Select your MCAR Project table as the table to geocode from the Geocode Table drop down box Select Fac_id as the column to use under the using Columns drop down box Select the GEOREF table as the table to search in the Search Table drop down box Select Fac_id as column to geocode with in the for Objects in Columns drop down box To change the symbol color and size click the Symbol button Click OK Click OK on the MapInfo window displaying how many records were geocoded A A NA Add the Database to the Map Window Click the Layer Control button A Under Layers click the Add button Select your MCAR Project table from the list of tables Click OK Click OK from the Layer Control window The MCAR Project data will now display on the map A CACI EVER VIGILANT ARGISS Training Manual if Georef _89t h_R5C Map Label the MCAR Projects with Proj Title and Proj City l Click the Layer Control button Za Highlight your MCAR project table 3 Click the Label button 4 In the Label With box select Expression The following window will appear Expression Columnz
25. csccccssccccsccccecccsscccescccuseccescccsececuscseueceuuscecescceueseuseceesnceeuneses Il 6 SEARCH BY FACILITY IDENTIFICATION CODE ceccsecceccscccccscccccscauccucccsccasccusccsscesccuscesscasceusceeees 111 7 FPS MAIN WINDOW tata econ E 7 PP TT 8 CHANGO E a E E ateos race II 8 A IN E E E E AE E EE E N JII 9 SEAR ADI E a E E EE E E AE T A E JI 9 SEAR ADB PE DE i cs nce ais E EE A E EE A A TM 10 SEARCH BY CONGRESSIONAL DISTRICT cccsccescscccoccccesesseanctevccsecssasscosceccsecsocsvsusderscsvessnceetoeeestanetvocss I 10 SEARCH BY UNIT IDENTIFICATION CODE ccccccseccsscccsccessccesccescccscccusccesccuscceesseesccecceusseesccusseesesens 11 11 SEARCH BY RSC THE RRSC CONFIGURATION IS NOT SUPPORTED IN ARGISS AT THIS TIME oouo o I 11 EUA A A II A inne E AA I 12 CANNED POR TS nl EEEE A I 13 IU NG NINE DR OR BS eros E E a a ad I 15 MAPPING CANNED REPORTS ccccseccscccssccescccscccsccusccusccesseusceescceusseusccuseceusseusceesceeusceusecucceeeceusceuees I 16 POTD OS TRS PO DSZ I 18 CREATING AD HOC REPORTS isos deeicniese gags deveuskedeouses densuewetiogaceundevexebesoeaseustens I 18 MAPPING AD HOC REPORTS cccc scsccosccoucsccssesesescerecoversccctescconctenseascevecsbesbessetseccscssssvensecesesseesctvecceascess I 18 GROUP AUTOLABELING ccscccsscccscccsscccssccsscesccesccessceusscesccessceesseesccesseesseesscesseusscesccesseeesseusscesesens I 19 VIEWING SITE AND FLOOR PLANS IN ARGISS wooo cece cecccse
26. then OK in the confirmation message box T Click Close to return to the Table Maintenance dialog Data Bridge Table oe Registering fields from different tables under the same key field e g Fac_1d creates a link between the tables using the key field The descriptions are editable but must remain unique Inserting a New Field into the Data Bridge Table To insert and register a new field into the Data Bridge Table l Select Data Bridge Table from the Reference Table list box Note that it is already populated 2 Click the New button to insert a field The Insert New Field dialog appears 3 Choose a Key Field ODBC Profile and Table to choose your fields from II 9 CACI EVER VIGILANT ARGISS ENBOSS Training Manual A Insert New Field Rey Field Tete ELH eles ODEC Profile oa_emaar Database Unknown Database Type Oracle T Table TEXAS Field Names Close 4 While holding the lt CTRL gt key select all of the fields you wish to query from or hold the lt SHIFT gt key select the first record and last record you wish to query from A Insert New Field Key Field EI A La ODBC Profile oa emaar Database Unknown Database Type Oracle Table complex Field Hames afrc_ host service deleted_in_ifs exces disp fac_street_ fac title 5 Click Insert then Close Click Close to return to the Table Maintenance dialog All of the selected fields should appear i
27. ARGISS ENBOSS Training Manual l Select Info gt Change Info from the menu bar 2 Click the All Facilities check box and highlight Congressional District from the Select Search Criteria window lx Congressional District Unit Identification Code Regional Support Command a 1 41 1 2 lt d 4 2 Click Continue 4 Enter NE 01 in the Congressional District text box gt Click Map 6 Click Info gt Data Summary to obtain summary statistics of the search Notice that the space utilization for these facilities is over 150 M 34 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Label the Facilities with Fac_id and Space Utilization l Click the Layer Control button from the main toolbar 2 Highlight the List layer and click the Autolabel check box Cosmetic Layer Ind Value with Comp UY Click the Label button 4 In the Label with text box select Expression from the drop down box An Expression window will appear Expression Fac id chr 13 Space Utilization is Columns 5pc_utlztn tower E 11 35 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Se Enter the following expression Fac_id chr 13 Space Utilization is Spc_utlztn Click Verify Click OK if expression is valid and OK in the List Label Options window Click OK again from the Layer Control window Make the Map window active and select File gt Print Select File gt Save Wor
28. ASSIGN Program State in Which Facility is Located FAC STREET Street Address of the Facility FAC TITLE Full Title of the Facility FAC ZIP Pci SN Zip Code of the Facility FACIL MGR MGR Character 15 Name of the Name of the Facility Manager Manager hes of A ae per week the facility is scheduled for full time personnel GR_SHOP SF Numeric Sum of all user entered gross square feet at the functional activity level for Shops AMSA G OMS amp Joint OMS AMSA attached to facility B 7 CACI EVER VIGILANT ARGISS Training Manual GR TNG SF Numeric Sum of all user entered gross square feet at the functional activity level for all Training Buildings attached to the facility Installation NO EX BLD Number of existing buildings at the facility OFC IN CHG Character The Name of the Officer in aes of the facility ieee eerie facility RQ TNG SF Numeric Gross Sq Ft Authorized for facility Calculated only for Units Attached to the facility The Utilization Report populates this field Number of nights per week the facility will be used by Reservists ar aee 20 Regional Support Center FYPDT Future Year Plan FYP Information for both Field and Headquarters Length ARCOM PRI Numeric 3 0 Project Priority Assigned by the Regional Support Command Army Reserve Command RSC ARCOM MACOM PRI Project Priority Assigned by the Major Army Command MACOM MDEP 1 e ae Management Dec
29. Arable land country land cover major grainage basin pasture land population density wetlands major city and major watershed boundary maps http www grida no baltic htmls maps htm e National Geospactial Data Clearinghouse Wide rang of public domain maps everything from coal investigation to thematic maps http nsdi usgs gov nsdi pages maps html e One World Guide Local World Maps City Net Virtual Tourist II and world country maps http www denver rti net guide local world maps e On line Map Creation Maps are created from north south east and west boundaries map projections plot locations plate boundaries and other options http www aquarius geomar de omc amke map html e US Geodata Various public domain maps http edcwww cr usgs gov doc edchrome ndcdb ndcdb html e Interactive Marine Observations Maps of marine weather and wave condition http polar wwb noaa gov regional e FGDC Manual Federal Geographic Data Products http info er usgs gov fgdc catalog title html e United States Geological Survey USGS environmental data and quadsheets http www usgs gov The list of available GIS data web sites is enormous You can search using an internet browser and search on GIS data Thousands of possible sites will emerge However most of the larger sites such as USGS and EPA have pointers to the most popular sites The larger federal GIS sites will be discussed later in further detail MapInfo Professional
30. Character Set Windows US Ww Europe SNS OK Cancel Help 6 A Browser window containing the selected database 1s now open You can use the scroll bars to maneuver in the table To view more of the table resize the borders of the Browser window To view both the map window and the Browser window click and drag both windows to new positions Moving and Resizing Columns To move columns in the table position the cursor on the column name to move Notice the Grabber tool becomes active Click and drag the column to a new position To resize the column width place the cursor on the line dividing the column names until a cross with two arrows 1s visible Click the mouse and drag the length of the column to a new size These changes are only temporary and cannot be saved The grid lines in the Browser window can be displayed or hidden To show grid lines Click on the Browser window to make 1t active Click on the Browse menu from the menu bar Choose Options Click on the Show Grid Lines check box to display grid lines Uncheck 1t to hide the grid lines OR SS CACI EVER VIGILANT ARGISS Training Manual 5 Click OK Querying Objects MapInfo allows you to select objects in multiple ways You can use the selection tools on the Main tool bar to interactively select objects Select multiple objects by holding the SHIFT key down while selecting the objects You can also select objects by querying the tables
31. Info Help iaa aaa a Hes aaa z ael SUS NS SF NSA w Map Legend Ea Fac ID GA077 l Radius 50mi de ASF 1 COLSND 6 CIMANT 7 A OTHER 1 lt gt TNG 1 amp USARC 13 Facility Info FPS EE Facilities List Facto tyne cry state Title CARROLLTON CARROLLTO CARROLLTON CARROLLTO CARROLLTON CARROLLTO COBAINS AFB COBAINS US COBAINS AFB COBAINS e d Mo record Info Menu The nfo menu contains the following information Change Info Allows the user to re specify or change the search criteria Data Summary Displays additional information based on the selection criteria Canned Reports Launches InfoMaker with the ability to view and manipulate the canned reports Ad Hoc Reports Launches nfoMaker with the ability to create new reports and change existing reports Change Info To re specify or change the search criteria l Click Info from the menu bar 2 Select Change Info from the menu items 3 The Select Search Criteria dialog will appear Re specify your search criteria II 8 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 4 Click Continue 5 Enter the search criteria and click Map to map the results Search By City Enter a city to search by in the City box Enter the state the city is located in the State box Enter a radius to search by in the Radius box Specify the radius distance units in the drop down box Click Map to map the search cr
32. Information Unit Identification Code Map Report Map Radius 4d Hoc Reports miles v Canned Reports Lancel Help Search By RSC The RRSC configuration is not supported in ARGISS at this time l Enter a RSC ARCOM in the Regional Support Command drop down box 2 Click Map Search By Information Regional Support Command Map Report Fin Map Ad Hoc Reports Canned Reports Lancel Help M 11 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Data Summary The Data Summary window displays the following statistical information about the selected search criteria Total Number of Facilities Total Gross Training Sq Ft Total Number of Soldiers Average Space Utilization Usage Weekends Month Facilities with Leases RED Status Average Cost Sq Ft 9 0 19 19 9 OH 9 9 To access the Data Summary window l Click Info from the menu bar 2 Select Data Summary from the menu items Data Summary Total Number of Facilities 189 Total Gross Training Sq Ft 4950276 Total Number of Soldiers 33626 Average Space Utilization 133 1 Usage Ww eekends Month 1 5 Leased Facilities T RED Status Ja Average Cost Square Foot 3 07 OK 3 The Data Summary dailog will appear with the statistical information about your search criteria 4 Click OK to return to FPS I 12 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Ca
33. LTA NCOA MB NCOA AB OMS MB OMS AB OMS AMSA MB OMS AMSA AB OMS DS GS MB OMS DS GS AB RTS I RTS MT RTS MED RTS AB Storage USARC MB USARC AB OTHER UNH STORAGE BPC Annual Lease Cost Used for LEASE Real Estate Type Only Construction Fiscal Year Used for Fee Real Estate Type Only Date that Disposal Environmental Baseline Survey EBS was completed Used for all Activities Effective Date of Permit Lease or Easement For LEASE EASEMENT or PERMIT Real Estate Type First Date of Environmental Document for the following Record of Environmental Consideration REC Environmental Assessment EA Environmental Impact Statement EIS or None Finding of No Significant Impact FNSI completion First Date of Environmental Document for the following Record of Environmental Consideration REC Environmental Assessment EA Environmental Impact Statement EIS or None Finding of No Significant Impact FNSI completion First Date of Environmental Document for the following Record of Environmental Consideration REC Environmental Assessment EA Environmental Impact Statement EIS or None Finding of No Significant Impact FNSI completion B 9 CACI EVER VIGILANT ARGISS Training Manual M m First Type of Environmental Document Record of Environmental Consideration REC Environmental Assessment EA or Environmental Impact Statement EIS or Finding o
34. Report E Map Ad Hoc Reports Canned Reports Lancel Help 3 The FPS Reports dialog will display Select the report button that you want to map 4 Filter the report 1f desired 5 Select the Save Rows As option from the File menu The Save As dialog will appear Save As Save ini E Data Iz ES Ga close dbf ne_ eer dbf a Pocattrnit c E criteria DBF E ga facil dbf E ne wkord dbl E Pbcattbl dl E car DEF E Ga_facs dbt necomple dbf Pbcatvld c E ecs_se dbf E largetac dbf oblsmrp dbf rp LIEF E fer DBF Ip DEF E Pbcatcol dbt fup DEF mbr DEF E Pbcatedt dbf File name Ga_FSR Save Save as type Dbase 3 Cancel 6 Locate the H ENBOSS ARGISS FPS DATA directory le From the Save File as Type drop down box select Dbase 3 so that the table can be mapped by FPS 8 Give the file a name and Click Save 9 Exit FPS Reports 14 16 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 10 In FPS return to the Select Search Criteria dialog Choose selection criteria that will allow you to map all of the records in your saved dbf file 11 Inthe Search By Information dialog check the Map Report checkbox and click the Map button 12 Inthe Select Report to Map dialog choose the Ad Hoc radio button Select Report to Map C Stationing Map C Facility Summary Pe Lancel C Future Year Plan C Cost Summary Account Summary Maintenance Backlog by Tier f A
35. Selected objects are placed into temporary tables When you make a selection MapInfo creates this temporary table to store the records you have selected This table is temporarily named Selection or QueryX where X is a number beginning with one and increasing with each successive query You can perform many of the tasks with a selection table that you can perform with permanent tables To convert selections into permanent tables use File gt Save Copy As A list of available tables to save will appear click on Selection and name the table Once you have saved the temporary selection table as a permanent table you can treat it like any other table In order to select objects from a map layer using the tools described below the layer must be selectable in the Layer Control window Once the selection has been saved as a permanent table you must open that table by clicking File gt Open Table and selecting the permanent table you just saved To select objects interactively on the map window use the following tools r Select objects by clicking the cursor on them To select multiple objects hold the lt SHIFT gt key down while selecting the objects Select objects by drawing a rectangle around them Select objects by drawing a circle around them iKi Select objects that are contained within a closed region To clear selected objects click Query from the menu bar and then Unselect All or click the Unselect All butt
36. a single application to access a variety of data sources for which ODBC compliant drivers exist Radio Button A circle generally grouped within a box with other radio buttons which can be toggled on or off Only one radio button within a dialog can be activated at a time Restore Button A small button in the upper right corner containing both an upward and downward arrow which will return a maximized window to its previous size Scroll Bar A horizontal or vertical bar in a window list box or matrix which provides the capability to view information not currently in view Single Line Edit See Text Box B 5 CACI EVER VIGILANT ARGISS Training Manual Status Bar A bar at the bottom of the application window which provides information about the active application window or field A dialog box which provides the capability to enter text Title Bar A horizontal bar at the top of the application or window which contains the name of the application or window Windows fonts that print exactly as they appear on the screen Window A rectangular area of the screen in which you can open an application or a part of an application FPS Map Legend Objects Hf Abbreviation Description Map Icon Armed Forces Reserve Center Red US Army Reserve Center Blue Aviation Support Facility Equipment Concentration Site Maintenance Site Training Site STORAGE Storage Facility B 6 CACI EVER VIG
37. all Currently Open Windows to add all of the currently open windows to the Layout window 6 Click OK wW Layout CACI EVER VIGILANT ARGISS Training Manual To customize the Layout window l Maximize the Layout window and select View Entire Layout from the Layout menu option 2 Move and resize the frames in the Layout window as needed Add a title using the Text tool from the Drawing tool bar 4 Double click on the title itself or select the Text Style tool from the Drawing tool bar to change the font size spacing etc 5 Change the margins by selecting Options from the Layout window and clicking the Margins button 6 Click the Legend button Ti To add a new window to the Layout window click the Frame button from the Main tool bar to add a legend to the Layout window A finished layout should look something like the one below CACI EVER VIGILANT ARGISS E Training Manual Workspaces Any combination of open windows in a MapInfo workspace can be saved for later use A workspace 1s a saved configuration of open Maplnfo tables and windows Saving a Workspace To save a project to a workspace l Click File from the menu bar Select Save Workspace A workspace will always contain the WOR extension Remember to always save workspaces to your C drive never to the LAN 3 Within the Save Workspace window specify a name and a directory to store the workspace and click Save Opening Wor
38. bar that appears in the upper left hand corner of all windows This menu allows you to Restore Resize Minimize Maximize Close Window and switch to another application print option is selected Desktop The entire work environment where Windows displays all windows icons and additional dialog boxes Dialog Box A box in which Windows prompts the user for a response Drop Down List A single line list box that when clicked shows a list of defined Box choices Hot Key A sequence of keys which select or execute menu options Icon A graphical element representing a program or window Icon Ribbon A horizontal bar containing icons which allows the user to select options in the current menu The ribbon can be relocated or closed entirely LAN Local Area Network List Box An information box that contains a list of choices A list box can either be single select or multi select Maximize Button A small button in the upper right corner of a window containing an upward pointing arrow which will resize the window to fill the entire application window or the entire desktop Menu A group of available commands in an application or specific window Menu Bar A horizontal bar at the top of the application window which contains the menu options just beneath the main menu option MS DOS Microsoft Disk Operating System ODBC Open Database Connectivity is a standard application programming interface developed by Microsoft It allows
39. button 8 Change the font size to 12 pt Times New Roman make the Effects bold and add a white box behind the text 9 Click OK from the Text Style dialog and click OK in the List Label Options dialog 10 Click OK from the Layer Control dialog The map will label all of the facilities by fac id 11 Click and drag on the labels to spread them out if necessary Create a Layout for the Map You will now create a layout window for your map and print it l From the File menu choose Page Setup and change the Orientation to Landscape Za Select Window gt New Layout window oy Select the One Frame for Window radio button Hew Layout Window Create a new Layout window containing f One Frame for Window Facilities Map CO Frames for All Currently Open Windows C No Frames OK Lancel Help Click OK A new layout window will appear with the facilities map and the legend Maximize the Layout window then choose Layout gt View Entire Layout Rearrange the windows and add a title to the map using the Text tool Print the map from the Layout window by selecting File gt Print AA I 31 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Facilities within 50 mi of Omaha h Lath IH 8 Select File gt Save Workspace In your H ENBOSS ARGISS FPS DATA directory save the workspace as OMAHAS50 WOR 11 32 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Generate and Print a Facilit
40. can be edited using Microsoft Excel or other easily accessible applications that can read DBF file types Therefore Data Bridge Terms The following is a list of common terms the Data Bridge uses and may be discussed during this course Join Allows the user to combine two or more tables in one query by utilizing the WHERE clause Key Field A field that is registered in the Data Bridge Table Primary Key The field or group of fields that uniquely defines a record in a table 1 e Fac_id Profiles Profiles must be set up to tell the Data Bridge information how to connect to the tables you want to query A profile tells the Data Bridge the directory where the table is located and the database type Query A method used to retrieve or select data from a profile Relationship A method of relating or joining fields in different databases to one another 1 e Fac_1d from EMAAR and Fac_id from the FORC FIL e Structured Query Language SQL A nonprocedural programming language used to develop queries and manage databases Launching the Data Bridge To launch ARGISS Data Bridge module from the ENBOSS Navigator Select ARGISS 1 4 CACI EVER VIGILANT ARGISS ENBOSS Training Manual E ENBOSS Navigator al ES File Options Connected as TTH ARCOM ENEOSS We Force Propo AF M Web EMBOSS Rep Help Desk Auiding Pride Then choose the DataBridge icon E1 ARGISS Applic M
41. cursor becomes a magnifying glass with a plus sign in the middle 2 Click on any area of the map The area where you click will become the center point and the map will be magnified around that point 3 Click and drag the mouse over the area you want to magnify A marquee box will appear 4 Release the mouse button after selecting an area within the marquee box The area within the marquee will be magnified to fill the Map Window i otateshr Map Fla The Zoom Out Button Ej 1 Click the Zoom Out E button on the Main Toolbar The cursor becomes a magnifying glass with a minus sign in the middle Ze Click on any area of the map The area where you click will become the center point and the map will zoom out around that point 3 Click and drag the mouse over the area you want to see A marquee box will appear CACI EVER VIGILANT ARGISS Training Manual 4 Release the mouse button after selecting an area within the marquee box The area within the marquee will zoom out to show more of the map The Grabber Button Y By using the grabber button the user can reposition the map to view the particular area of interest without changing the zoom level l Click the Grabber ey button on the Main Toolbar The cursor becomes a hand as it is moved within the Map window yr Click and hold anywhere on the map then drag the cursor to view the area of interest 3 Release the mouse button The map is redrawn in its new position Wh
42. have the applications installed conca 8 Continue to select databases and tables until all of the desired tables are chosen I 38 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Data Bridge Wizard Select Tables Please select tables from the database to be included in your join Ensure that all of the data fields you need are in the tablefs you select Database RISER ACTIVE racetadt racctrt ramprf rapwcdrf I rasgrt rbsbrt rbudgetxf rcagedunstA rcommt rotidhxtf rotretdt retretst rdeisxt rdoanelt El Cancel 9 Click the Next button The Select Fields dialog appears 10 Hold down the Control button on the keyboard and select all of the fields that you wish to query from in each table Be sure that there is at least one field selected that contains the same information in each table e g fac_1d Data Bridge Wizard Select Fields Please select fields from the tables to be included in your join Your queries can only display fram these fields complex rpintodt acres rq afrc host servi coe dist deleted in_ifs arcom pri asg ocd bldg num bsb cd comp dt cwe total Cancel 1 39 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 11 Click the Next button The Select Key Fields dialog displays showing all of the fields available for query Select a key field that contains the same information in each table Data Bridge Wizard Selec
43. menu option and then Close Table 8 Open the new base map that contains the states in the 89th RSC The state or states you selected display a _89th_RSC Map Ela CACI EVER VIGILANT ARGISS Training Manual Geocode the MCAR Project Table In order to geocode a table you must use another table that contains X and Y coordinates The master georeference table is an easy table to use because it contains Fac_id The geocoding process will put the MCAR data on a map for visual and spatial analysis To open the MCAR Project table you saved in the Data Bridge Select the File menu option and then Open Table You should have saved the table to C ENBOSS ARGISS DATA Click OK on the Open Table window Click OK at the Dbase DBF Information window e To open the georeference table l Select the File menu option then Open Table E Select C ENBOSS ARGISS DATASET GEOREF TAB 3 Select No View from the Preferred View drop down box since this table has already been geocoded and we do not want to add it to the map window 4 Click OK on the Open Table window ESaldier TAB SidPers TAB aj Forc_til TAB sa Soldier TAB a Georef TAB sa itrrunit TAB File name Georef TAB Files of type Mapinfo tab Cancel Help Preferred View You are now ready to geocode the MCAR Project table 1 Select Table from the menu bar 2 Select Geocode from the menu items CACI EVER VIGILANT ARGISS
44. more complex filters can be applied A WHERE clause limits the query results to data that matches the criteria For example State VA Fiscal Year gt 1999 Start date gt 1999 10 01 There are two special operators within the Where Criteria window called IS NULL and IS NOT NULL By default Data Bridge will ignore values that are blank i e the fields don t have data in them This can produce erroneous results by not reporting all rows that match a query For example if a query s where clause is fac_state lt gt AL and there are records without state information then those records will not show up in the results The Data Bridge corrects this by automatically adding the IS NULL clause to the criteria and avoids missing the correct data This correction is added only when the operator is lt gt however it can be added manually at any time by the user to find records with blanks in a specific field The filter in the query below will produce the following results All of the Army Reserve units in Kansas or Missouri that are not closing have an assigned strength greater than 10 and have no assigned officers To filter a query l Click the Where Clause button from the Query dialog Ze The Where Criteria dialog displays This dialog 1s used to develop the filter criteria da where Criteria Connector Wartable Field Operator Value fann lfac_state E View Window complex fac state ME 3 With
45. or selectable l Click the Layer Control Ed button 2 Check the Editable g check box 3 Click OK The Cosmetic Layer is now editable as shown in the status box at the bottom of the screen Labeling A Map Labels in MapInfo are obtained from the data associated with the map objects By default the data pulled is from the first column in the table The auto label check box in the Layer Control is by default not activated To activate auto labels simply check the box for the layer you want to label Layer Control Layer p 57 A Cosmetic Layer EF Tn 0 KEKE vIe Cancel KEKE MEME Display Label Thematic HatLink ELEF kh f Layers Reorder Add Remove Up Down Help CACI EVER VIGILANT ARGISS Training Manual The Label tool Ea from the Main Toolbar can be used to interactively label objects on the map When the Label Button is used hover over a map object with your cursor a tool tip corresponding to that object will display on the map window To change the default auto label options for the map l Click the Layer Control F button or right click your mouse 2 Highlight the layer you want to label click Label The STATESHR Label Option dialog displays Stateshr Label Options Label with State a State NAME Expressiori wt W Allow Duplicate Text Display within Range Visibility f On Allow Overlapping Text fin Zoom o 000 i T Label Partial
46. rows in query 20 Print Orientation Launch Excel Close Viewing a Query s SQL Syntax Notice in the example below that the query begins SELECT DISTINCT This means that the user had checked to Suppress duplicate rows box in the query s main dialog To view an active query s SQL syntax l Select the View SQL option from the Execute menu The View SQL dialog displays Il 16 CACI EVER VIGILANT ARGISS ENBOSS Training Manual A View SOL SELECT DISTINCT complex fac id comples coe dist cormplex fac_title complex fac street complex fac city complex tac state complex fac zip complex ifs sh total FROM comples WHERE complesx fac state NE AND comples fac_id lt gt If you are querying an Excel Spreadsheet the Choose an Excel 5 Workbook as Database window appears Select the XLS file you are querying and click OK The View Edit Untitled Result Data window appears with the results of the query Printing a Query To print query results 1 Click the Orientation button on the View Edit Result Data window The Print Orientation dialog displays 2 Print Orientation Please choose a print orientation for your query results Landscape C Portrait Ze Select one of the radio buttons Landscape or Portrait The Landscape radio button is selected by default 3 Click the OK button 4 Click the Print button on the View Edit Result Data window The Print Warning message dia
47. tables are open select Table from the menu bar 4 From the Table menu items select Geocode CACI EVER VIGILANT ARGISS Training Manual Geocode Mode f Automatic C Interactive Geocode Table Himi using Column Fac_id bal Boundary Colum none a Search Table Stateshr Symbol Pz for Objects in Colurnri State Optional Refine Search with T able none a using Boundary Mame Column none Cancel Uptions Help Select the table to geocode from the Geocode Table drop down box Select the column to geocode with e g Fac_id from the Using Column drop down box Select a search table from the Search Table drop down box e g georef Select the column from the for Objects in Column to use as the field to search and assign records to the geocode table e g Fac_1d 9 Click OK MapInfo will geocode as many records as it can and return a message window displaying the results Haplnfo Ea Geocoding of table Ga faces completed 11 geocoded not geocoded O previously geocoded e O a ox Some of the records may not have been matched due to multiple possibilities such as proposed facilities that are not yet built facilities that are closed etc The ungeocoded records will have to be examined to determine why they were not geocoded To find ungeocoded records l Select Query gt SQL Select In the from Tables box enter the table you just geocoded 3 In the
48. that have already been registered in PlanView display Click New 4 A new row 1s inserted and highlighted in the File Maintenance dialog d File Maintenance El Plan Type UI FAC ID Buildings Description Floors File Hame a a ZA 195 _ mi m am l ae aml T RE fF 2 409501F USARC 2 Aga ZF CADIS CA095 Us ARE 20 AROOG1F CA095 AA USAR J CAOSS CSF CAOSS CAF New Delete Close Exploring GSup 80 Snaglt Capture Pre M Document Micro E ARGISS_Sectiori Mapinto 5 Enter the values for the FAC ID Building Description Floor and File Name The file naming convention for floor plans is Fac_id one character abbreviation for building type floor number F Example AR002 C 1 F ARO02CIF IV 7 CACI EVER VIGILANT ARGISS ENBOS Training Manual Building abbreviations are C Main USARC Center A AMSA O OMS S Storage M Mixed 6 Once all of the information has been entered into File Maintenance the floor plan can be displayed Deleting a Floor Plan To delete a floor plan Select the facility floor plan to be deleted from PlanView Click the Delete button The Delete Alert window appears Click Yes to delete the floor plan or click No to cancel ue ds Viewing a Site Plan To view a site plan l Select the Site Plan radio button under Type on the Plan View dialog 2i Select the Facility ID 3 Click Disp
49. the Browser window are linked By clicking on the boxes to the left of the record in the Browser window the graphic record or object is highlighted on the map If a record is selected on the map it is also selected in the Browser window Creating a Graph MapInfo can create multiple types of graphs based on map or tabular data When you create a graph MapInfo places the graph into a Graph window A Graph window is used to visualize statistical information in a graphical format MapInfo allows you to create the following graph types Area Area graphs represent quantities as the size of an area on the graph Bar Bar graphs are used to compare a relatively small number of discrete items Line Line graphs plot data points at equal intervals along the label axis connecting the points with the line Pie Pie graphs also referred to as pie charts show the relative proportions of items with quantities represented by the area of the pie wedge X Y X Y graphs plot points according to their X and Y coordinates without any connecting line CACI EVER VIGILANT ARGISS Training Manual To graph data l Click Window from the menu bar Ze Select New Graph Window New Graph Window Graph Table Ga taes using Columns Gnas H Label with Column Fac_id a OF Cancel Help Click on the down arrow next to the Graph Table drop down box Select a table to graph 5 Under the using Columns drop down boxes sele
50. the georeference table T ENBOSS ARGISS DATASET GEOREF TAB in Maplnfo if it is not already open Select Table gt Update Column Select table as the Table to Update field Select latitude for the Column to Update field Select table as the Get Value From Table field Click the Assist button and select the CentroidY function as the Expression Update Column E Table to Update Georef Column to Update Latitude iad ove Value W Browse Results OF Cancel Help 7 Click OK 11 25 CACI EVER VIGILANT ARGISS ENBOSS Training Manual The latitude field 1s now populated with the centroid center of the map object of the Y coordinate for the new Facility Id Do not forget to save the table table before exiting MapInfo To populate the longitude field Select Table gt Update Column Select table as the Table to Update field Select longitude for the Column to Update field Select table as the Get Value From Table field Click the Assist button and select the CentroidX function as the Expression A a as ee Update Column Ea Table to Update Georef iei Column to Update Latitude h M Browse Results OF Cancel Help 6 Click OK The longitude field is now populated with the centroid center of the map object of the X coordinate for the new Facility Id Do not forget to save the table table before exiting MapInfo If you make any changes in address for a FACID t
51. to build a query on Nebraska work orders Data Bridge Wizard Select Number of Databases Welcome to the Data Bridge Wizard Comples Interest Units Enforce ene EMAAR During this process will assist you In joining tables from similar or different databases so that you can query information from various sources Just tell me how many databases you want to join their location which tables and flelds you want from each database and the flelds you will use to join the tables together You will be able to relate fields from various a lp types of databases including Ms Excel spreadsheets MS FoxPro RPINFODT database files Mo Access tables and sybase Adaptive Server Anywhere RACCTGDT Tables t RFNDGDOT A database is a set of tables For example the illustration to the left RISER depicts part of the EMAAR and RISER databases The Complex Interest Units and Enforce tables exist within the EMAAR database Similarly e RPINFODT RACETGOT and RENDGODT are tables within the RISER database How many databases do you want to join a cana 3 Click Next TE 58 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Data Bridge Wizard Select System Database What database contains the first set of tables that you will be joining Select database 1 of 1 Select Database O RESER Archive C Force Program File C Sidpers Extract C Other RISER Archive
52. 99 M 2h FORT GILLSUUSO 5124 FOREST PARK 116164018 0 GA 4790 N STECS 43 30050 516 FOREST PARK 54019 0 GA 1407 Hood SEARISC 30297 317 FOREST PARK GAO 0 GA HANGAR FORT BERS1905 S00IFORT BENNING GAZ 0 GA PROPOSE31905 Columbus GATS 20106 GA BLOG 134 RTS5 MED 30905 505 FORT GORDON GAUZE 47367 GA BLOG 14 FT GORDCS0905 505 FORT GORDON GAZ 0 GA BLOG 971 FORT S7E31314 570 FORT STEWART 123 GA028 0 GA PROPOSE31314 5001F ORT STEWART 124 164029 0 GA PROPOSE31314 5001 FORT STEWART E 44 H UNTITLED sd FI Ready D ee A ee Note Query results over 65 536 rows long will be truncated a Use Excel s functionality to manipulate format preview save and or print the query data The Save Data Information option allows users to save data as a Sybase SQL Anywhere table a Microsoft Access table a FoxPro table or a Microsoft Excel workbook by using one of the existing ODBC profiles Saving a Query Users may save a query definition the results of the query or both The Save Query Information option allows users to save a query with a name description and access level A description of the different query access levels is shown below Access Level Who Can See the Query Who Can Edit and Delete the Query Private Query Creator and System Query Creator and System Users Users Read only All Users Query Creator and System Users All Users All Users 1 19 CACI EVER VIGILANT ARGISS ENBOSS Training Manual To save a query
53. Army Reserve Geographic Information Support System ARGISS TRAINING MANUAL June 2006 CACI ne EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank Table of Contents ARGISS ENBOSS Training Manual AAA nO E O EEE I 1 COURSE INTRODUCTION AND OUTLINE 1 ccccsssccssccccscsccccccccsccccscccccccccsccccscccesscscssccssecccess I 1 ARGISS BACKGROUND oido 1 3 COURSE LAYOUT AND OBJECTIVES iio cds 1 5 SUENAN Loan icoaidia 1 5 SOENARIO lonas cool craceidu 1 5 SECTION Marre ssc E a II 1 DATA MANAGEMENT IN THE DATA BRIDGE ccccccssccccsssccscccccscccsscscccscccscccccscscscsscsecccess II 1 OBJECTIWES arise erste mae ect escent sce pecs scan ts sea Recio Il 3 DATA BRIDGE OVERVIEW vascas dd II 3 RELATIONAL DATABASE MANAGEMENT SYSTEM RDBMS OVERVIEW cccccesssccceeessseeeeeeessseeees II 4 DATA BRIDGE TERMS nta iris I1 4 THE RELATIONSHIP TABLE ooccccnncccnnncnncccnnncnnoccnnnnnnconnnonnnrcnnnonnnrrnnnonnrrnnnonnnrrnnnonnrrnnnnnnarennnonnrcnncnnnircns 11 23 DATA BRIDGE WIZARD sido rt todito cias 11 36 DATA BRIDGE EXPRCISE Sun aies 11 43 SECTION TT od III 1 FACILITY PLANNING SYSTEM FPS naaa II 1 BT Ee ae PA JI 3 A IN An a IlI 3 DIRECTORY INFORMATION DIALOG rata eos Il 3 UPDATING PPS DATA ricotta MI 4 SELECT SEARCH CRITERIA WINDOW csccccscccsscccscccscccssccesccesccccceusccusccesceusseusccecseusceusccueseusceusceuees II 5 SEARCH BY INFORMATION WINDOW
54. CACI EVER VIGILANT ARGISS ENBOSS Training Manual Setting up Relationships You will now set up a relationship between the COMPLEX table from oa_emaar and the FORCE FIL table from oa _emaar This will relate or join these tables so that you can query both tables as if they were one Once these tables are related you will query them to obtain the unit information requested by Congressman Snort First you must insert primary keys for all of the tables you would like to include in your query l From the Administration menu select Table Maintenance The Primary Key Table is active Click New to add new primary keys A Insert Key Field ODBC Profile oa _emaar o id Database Unknown Database Type Jorate o Table torce fle Field Desc facia Field Hames Select oa_emaar for the ODBC profile will be the default setting 3 Select the force file table in the Table drop down box 4 Select facid as the primary key from the Field Names box 5 Click Insert 6 Click OK on the confirmation message dialog 7 Click Close Facid from the FORC FIL is now entered into the Primary Key table Any source data that has the column Fac_id or Facid in it can now be inserted into the Data Bridge table In this case the RPINFODT table has the column Fac id The following sections will illustrate how to enter fields from all three tables 11 49 CACI SR VIGILANT ARGISS ENBOSS Training Manual Insert fields f
55. E HELP 0 00 a e a ae aa a O eiai Iv 12 E EAR VIEW soil lalola Iv 12 PRACTICA EXPRESE E aleta Iv 13 ALLENDE Weep ae ioe mee E io A 1 GEOGRAPHIC DA TA SOURCES cosilla dais A 1 GEOGRAPHIC DATA UREA A 3 INTERNA aa A 4 IVEAPINEO PROEESSIONA E EE E OET E PETE TE A AEE EE T A 4 FEDERATA CENCIE Sa A 5 STATE AND LOCAL GOVERNMENTS AND UNIVERSITIES ccccseccsscccscccssccescccscceesceesccescceusseusccuseceusseusces A 6 IAN a a a EAA A 6 PRIVATE RE N E e e A A E E E AE EE e e DS EAE A A 7 EEE OE EEEN E ETA ANE AT E A E EE AE E AAE E A E A 7 APPENDIX Danni dai E O B 1 IPRM ANDA BBRE VIA TIONS daa as B 3 EXTERNAL YSTEMS USED BY ARGIS utili il B 7 APPENDIX ES A dos C 1 BASIC MAPINFO FEATURES a esses E E EE NE R E C 1 OBIECIT a Ree ene C 3 MAPINFO TERMINOLOGY ormona e e e iO De C 3 A ee Rent ne ee Cee eR er Te TCR RCD ey eer TTR OE Rt oe mee eee eee ae eee Ree ene C 4 TOLAUNCO MARINO e O C 7 TOPE gd 02 8 Me Sher en ee ee No re ete eee C 7 UNDERSTANDING TABLE a e e e de e do C 10 VIEWING TABULAR DATA ie de eee de O o C 11 NAVIGATING THE MAP WINDOW ch sais sd a a eee sees c 12 USING THE MAIN TOOLBAR TO CHANGE A VIEW ccscccsscccscccssccescccsscesccesccesscesseesccesscesseesccesccesesees c 14 CHANGING MAP WINDOW OPTIONS Nai c 15 MAREA YER CONTROL io C 16 LEAVE VID ir o GT ITE PRO TOE EE C 18 REORDERING AYERS nasal ai C 18 ADDING AND REMOVING LAYERS 0 iia C 18 DISPLA INGEA TER sie C 19 EDITING AND OEE CU IN Cia C 21 COSMETIC
56. EAVER aa C 21 EABELING AMA ias C 21 Table of Contents ARGISS ENBOSS Training Manual IV TING ltda C 23 REMOVING LADEE S sii C 24 SE SS O A A RO C 24 CREATING TITLES FOR THE WORKSPACE cissccsncveccececcsderscevecencudeovacdesvousneescadeceeevansuedwaseesevocnneucvedeccwatesans C 24 DAVING THE COSMETICA YE sis C 25 BROWSER WINDOWS dorado lec s C 26 MOVING AND RESIZING COLUMN Sada C 26 QUERYING OBIE CTS odds C 27 SELEC PING USING OUPRIES iia A A a id C 28 ITOOUER DATA USING O LECI astro nateaneacee aaeteansste C 28 SELECTING USING SOLE SELECTA A A E N E C 29 TOSAVE THE QUERY AS A PERMANENT PILE si scteotesceshacsdevehweboddudaerdsalensyacedhaesdctdpesbontabeded eabedevadeosacsaebavante C 31 CREATE G NENA PS gn eer a se bno E ito ea eee C 32 TOGEOCODEA DATABASE DIE artrosis eacussts C 32 TOFIND UNGEOCODED RECORDS castillos C 33 TO ADD THE NEWLY CREATED MAP YOUR MAP WINDOW2 csccssccssccsccesccccenccesscuscesccusseuscenccusceaseescenss C 34 CREATING AGRA PH A EA C 35 TOGRAPHDA TAE A A A iaa C 36 CREATING A LAYOUT WINDOW A A A A iio C 38 TO CREATEATAYOUE a A A iia C 38 TOCUSTOMIZE THE LAYOUT WINDOW ii A A C 39 WORKS ACES ii aa C 40 SAVINGA WORKSPACE normia otras esate needs ita C 40 TOSAVEAPROJECT TOA WORK SPA CB Soc C 40 OPENING WORKSPACES oora A ii C 40 TO OPENASSAVED WORK SPACE A oa C 40 PRINTING AND PLOTTING MAPS i n C 40 PAGESE TP e do C 40 TO SPECIFY THE PAGE SETUP FOR A MAP GRAPH BROWSER OR LAYOUT occocccnocc
57. EBAR program by selecting the Tools menu option then ScaleBar and then Draw ScaleBar 24 Change the options you want to and click OK 25 Print your Layout window for review Y our strip map should look something like the example on the next page C 75 CACI EVER VIGILANT ARGISS Training Manual Save your strip map as a workspace to your C ENBOSS ARGISS DATA directory l Select the File menu option then Save Workspace Ze Give the workspace a name and save it to C ENBOSS ARGISS DATA Save Workspace ki Save in Y Data ce a8 Mehra wor File name Save Save as type Workspace wor a Cancel Help dis Write down the name of your workspace in the space provided below CACI EVER VIGILANT ARGISS Training Manual Populate Your Local Data Bridge Table with MCAR Projects from EMAAR l Double click on the Data Bridge icon in the ARGISS program group Point to your Local System Tables by selecting the Administration menu option then Change Data Source gt Local 3 Select Data Bridge Table from the Reference Table list box if it is not already selected and click New 4 Select Fac_id from the Key Field drop down box Select the sa_emaar profile from the ODBC Profile drop down box Notice the Data Bridge automatically populates the Database and Database Type fields Select HO PROJ from the Table drop down box Select all of the fields from the list of Column Names Click Insert C
58. ER VIGILANT ARGISS ENBOSS Training Manual Select Key Field Suppress duplicate rows v Field Descriptions Field Descriptions Order 2 Select a key field from the Select Key Field drop down list box If the key fields are in a relationship a Relationship Found message will appear Choosing Yes will make all of the fields in a relationship with the selected key field available for query Choosing No will make only the fields entered under the selected key field available for query 3 Select the fields from the Field Descriptions list box that you want to include in your query and click Add To choose all of the fields click Add AIL Select Key Field Fac_id complex Suppress duplicate rows W Field Descriptions acres rq afrc_host_ service coe cist deleted in_ifs exces disp Order A y Ye ci Where Clause 4 To reorder the field highlight the field in the Selected Field Descriptions list box and click IM or Ml to move the highlighted field 1 13 CACI EVER VIGILANT ARGISS ENBOSS Training Manual on To remove fields highlight the fields to remove and click the Remove button To remove all of the selected fields from the query click the Remove All button Running a Query To run a query l To run the query with the filter select Execute from the menu bar and click Run or click x Fun on the toolbar button The Data Bridge begins to process the query and the us
59. ILANT ARGISS Training Manual External Systems Used by ARGISS This document provides a list of tables and columns from other systems that are read by programs within ARGISS The EMAAR table names and column names data types lengths and descriptions have been copied from the EMAAR data dictionary EMAAR Columns Used by ARGISS This section lists the EMAAR tables and columns used by ARGISS These columns are used in the Create Application Data processes to generate the Reports for FPS Any structure changes to them will also cause structure changes in the reports the MapBasic code and the PowerBuilder code COMPLEX Facility Information Coum Length Description i O eee _ ACT Numeric 8 2 Sum of existing E of acres for all Land Functional Activities attached to the facility CONG DIST Numeric The facility s Congressional District Number Validate against the key code in the CONG table Senator s names are pulled from the CONG table which is maintained by CEHNC EXIST SHOP Numeric Sum of existing square feet for Maintenance Shops Area Maintenance Support Activity AMSA ground Organization Maintenance Shop OMS and Joint OMS AMSA at the facility EXIST TNG Numeric Sum of all Training Building Areas Admin Assem Kit Weap Educ Stor Spe Trg Supp Area at facility Is this an existing Facility T F contained in the USAR Real Property Inventory Name of the City where Facility is Located CEHNC
60. Print Orientation Launch Excel Close ARGISS ENBOSS Training Manual 11 63 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 10 Save the query and its results using the information shown on the next page Save Query and Data E4 W Save Query Information Query Hame Existing Queries Query Creator ACCESS LARGE_FACILITIES STUDENTS read only HE_WORK_ORDERS ME_RISER_ENVIRONMENT STUDENTS private TATE FACILITIES STUDENTS read only Description HEBRASKA WORK ORDER DATA Access Level Public other users can read or modify b W Save Data Information ODBC Profile fps reports Table Hame HE WKORD Database fsiargiss psidata Database Type FoxPro ITE 64 CACI R VIGILANT ARGISS ENBOSS Training Manual Conclusion The Data Bridge practical exercise demonstrated the powerful data management database integration and query tool available to the Engineer The queries that were created in this practical exercise will be used in later practical exercises to demonstrate the flexibility and integration of the ARGISS modules To summarize the list below explains the queries created STATE FACILITIES Facility information for the state of Nebraska from EMAAR LARGE FACILITIES Unit information for facilities in Nebraska over 50 000 gross training square feet from the FORCE FIL and EMAAR databases NE WORK ORDE
61. RGISS ENBOS Training Manual 3 Click the Individual button and select Region IndValue Default 4 Click Next 5 Select the table that contains the floor plan and a field to create a thematic map with Create Thematic Map Step 2 of 3 Select a Table and a Field Table met Field IC T Ignore Zeroes or Blanks lt Back Cancel Help 6 Change the legend and styles options as desired and click OK Modify Thematic Map Preview AROOTCTF by RoomMame Admin 5 Arms Room 1 Assembly Hall 17 Classroom 1 Corridor 1 Equipment Room 17 Janitors Closet 11 Kitchen 1 Latrine 2 Rifle Range 1 CUllerry 1 Legend Label Order f Ascending Descending DF Lancel Help Customize SERE Styles Legend The different rooms are displayed thematically using different colors IV 10 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Labeling Room Names l Click on the Layer Control button in the main toolbar 2 Check the AutoLabel check box for the floor plan layer and click the Label button RoomName F Hite eal miniy 7 CT tt Foor e 3 Label the plan with the RoomName and add a box around the name through the Styles button 4 Click OK and OK again in the Layer Control window MapInfo automatically redraws all of the room names for the floor plan displayed IV 11 CACI EVER VIGILANT ARGISS ENBOS Training Manual
62. RISER Information Include the following fields in the report fac id wo_id wo_desc sdn commit dt commit_amt acctg desc cmtl cmt2 cmt3 est_desc apc_cd eor_cd 1 67 CACI R VIGILANT ARGISS ENBOSS Training Manual Create a report containing 2002 ARR H account RISER information l Create a query in the Data Bridge containing 2002 ARR H account RISER Information 2 Include the following fields in the report fac id wo_id wo_desc cwe total commit est desc tdac_cd ITE 68 CACI R VIGILANT ARGISS ENBOSS Training Manual Conclusion You have now created three additional reports The Data Bridge allows you to query multiple databases simultaneously and save those queries as DBF files You can then bring those queries into Excel to create reports for presentation To summarize you have created the following reports for your CG using the Data Bridge and Excel e FACLIST contains facility information e ARRJACCT contains 2002 ARR J account RISER information e ARRJEST contains 2002 ARR H account estimate RISER information Please contact the Engineer Automation Support Desk at 1 800 557 4737 for any technical support or training questions 11 69 EVER VIGILANT ARGISS ENBOSS Training Manual Section IV Plan View CACI EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank CACI EVER VIGILANT ARGISS ENBOSS Training M
63. RS Data concerning the description and status of work orders for Nebraska These queries may now be used in Excel to produce reports for Congressman Snort 1 65 CACI R VIGILANT ARGISS ENBOSS Training Manual Scenario Practical Exercise In the following practical exercise you will develop three additional reports The practical exercise will demonstrate how the Data Bridge and Excel complement each other for query and report generation The following reports will be created e FACLIST contains facility information e ARRJACCT contains 2002 ARR J account RISER information e ARRJEST contains 2002 ARR H EST account estimate RISER information Create a Facility List Report Create the Facility List Query in the Data Bridge 1 Select the Query menu option from the menu bar and select New or press New on the toolbar button After selecting the New query option the Untitled dialog displays 2 Select fac id as the key field from the Key Field drop down box 3 The Relationship Found window appears if there is an entry in the relationship table 4 Click No to select fields only from the tables entered using fac_id as the Key Column 5 The columns from the databases entered using fac_id as the Key Field are displayed in the Field Descriptions list box and the field selected defaults to the Selected Columns list box 6 Select the following fields Field Name Table Name fac_title fac_id complex fa
64. S data then the Local drive needs to be updated To update FPS data l Click the Update button from the Directory Information window The Update dialog will appear Location Last Update Source Data 2002712731 LAH 2003701 708 Local 2003 01 f15 Status ee K MI 4 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 2 Check the Back Up Current Data check box if you wish to back up your current data to the your individual MetaFrame path H ENBOSS ARGISS FPS DATA directory 3 Click the Copy button The system will copy the most recent geocoded data from the LAN to the user s local drive As files are copied a status bar displays the percentage complete After the local drive has been updated the Local date field will reflect the new current date The LAN date field changes when the System Administrator runs the Create Application Data Process to update the LAN data After the data has been updated from the LAN and the file locations are correct click Continue from the Directory Information window Select Search Criteria Window The Select Search Criteria window allows the user to select different types of functional activities and various geographical areas The Select Search Criteria window allows the user to select the following functional activities All Facilities Army Reserve Centers Armed Forces Reserve Centers Aviation Support Centers Equipment Concentration Sites Maintenance Sites Train
65. SER Archive C Force Program File C Sidpers Extract C Other RISER Archive System databases that are grayed out cannot be located Please contact the System Administrator to have the applications installed conca 4 Click one of the radio buttons on the list of system databases known to ARGISS or select the Other radio button If the Other system database 1s selected the user will be prompted to select a database type and location of the table gt Click the Next button The Select Tables dialog appears 11 37 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 6 Select table s from that data source you wish to include in the join The total number of tables selected for all of the databases cannot exceed 6 Data Bridge Wizard Select Tables Please select tables from the database to be included in your jain Ensure that all of the data fields you need are in the table sj you select Database EMAAR Are Cancel h Click the Next button If there are more databases to be included in the join the Select System Database dialog reappears Data Bridge Wizard Select System Database What database contains the next set of tables that you will be joining Select database 2 of 2 Select Database W REER Archive C Force Program File C Sidpers Extract C Other RISER Archive system databases that are grayed out cannot be located Please contact the System Administrator to
66. SS ENBOSS Training Manual 7 Select the map window making it your active window and select the Symbol tool from the Drawing tool palette 8 Use the Symbol tool to tell MapInfo where the new Facility Id is located Click the mouse once TRL want to locate the facility 9 Select the Select tool as soon as you are done locating the facility so you do not accidentally start adding more objects than you want to add 10 Notice the symbol is highlighted MapInfo added a gray star to indicate the new facility location The other facilities in the GEOREF table are blue facilities To change the symbol select Options gt Symbol Style while the facility is still highlighted 11 Select the facility symbol and the color blue 12 The GEOREF table needs to be saved To save the GEOREF table select File gt Save Table Select the GEOREF table and click Save In order for the new Facility Id to display in FPS the Create Application Data process needs to be run The Engineer Automation Help Desk does this twice a month The latitude and longitude fields in the GEORFF table are not automatically populated with the X and Y coordinates MapInfo stores the X and Y coordinates for each record internally in something called an object While in MapInfo you can use the object field obj to run queries etc The following instructions walk you through populating the latitude and longitude fields in the any table To populate the latitude field l Open
67. SS This section lists the RISER tables and columns used by ARGISS These columns are used in the Create Application Data processes to generate the Reports for EPS and FPS Any structure changes to them will also cause structure changes in the reports the MapBasic code and the PowerBuilder code RACCTGDT Accounting Transaction Data Column Type Length Description fy mee 40 Fa Year OBLIG AMT Amount Obligated OBLIG DT Date 8 Obligation Date WO ID Work Order Identifier RFNDGDDT Funding Guidance Information Army Management Structure Code AMSCO RPINFODT Work Order Information AE Pr ota 15 A106 Environmental Projet Number Ei _CD dl a RSC ARCOM or other site which created the record CWE TOTAL Numeric Estimated Cost Total Facility Identifier FNDS CD Character A Status Code prec cl Renee pos Package cme Code eae aoe e a e g J K L PRJ_ CD Character 2 Project Status Code WO_DESC Character 30 Short Description WOID Character 10 Work Order Identifier B 11 CACI EVER VIGILANT ARGISS Training Manual ITRR GIS Columns Used by ARGISS This section lists the ITRR GIS tables and columns used by ARGISS These columns are used in the Create Application Data processes to generate the Reports for FPS Any structure changes to them will also cause structure changes in the reports the MapBasic code and the PowerBuilder code SIDPERS Unit Information Column ADDRESS U
68. Segments Glee man 100 000 mii Maximum Labels HE aa Label Lines Position ls Tar lO If Rotate Label with Line Label Offset 2 Points None Arrow Lancel Help Note The Label with dropdown box allows the user to select a field to label with 3 Check the Allow Overlapping Text or Allow Duplicate Text 1f desired AA 4 Under Styles click to change the appearance of the text style Click OK CACI EVER VIGILANT ARGISS Training Manual Text Style Font i e The quick brown fox jumps over the Text Color o lazy dog Effects Sample Background f None Co Halo C Box Color T Bold Underline Shadow T Italic P AllCaps Expanded To change the position or the anchor point of the label click the desired anchor point from the Position options 5 To change the position or the anchor point of the label click the desired anchor point from the Positions option 6 Click OK Moving a label l Choose the Select k button from the Main Toolbar Ze Click and drag a label to the desired location To edit an existing label 3 Double click on a label The Label Style dialog will display CACI EVER VIGILANT ARGISS Training Manual Label Style Label Line Ol ia Style C Simple X Croma Rotation Angle joo deg Offset 2 Points Text El card to Removing Labels l Choose the Select k button fro
69. T ENBOSS ARGISS DATASET GEOREF TAB Zoom in to the region that contains the facility you wish to move and autolabel the streets layer through layer control tk R OE 18 x _ Hartford_CT County Map 22 a as i Ye au 1148 Sc el el aa USA El AS ela Morton St Si Haran ll i E Editing None Selecting None Zoom 2 002 mi NDL Make the GEOREF layer editable in Layer Control Use the Select tool and click and drag the facility into the correct location Save the table Contact the ARGISS HelpDesk at 1 800 557 4737 to send us a copy of your updated georeference table The Create Application Data CADP process for FPS will have to be run in order for the change you just made to be reflected in the data The Smyrna Regional Office will need a copy of your georeference table for the following reasons So your changes will not get overwritten when we refresh your tables So OCAR s and HQ USARC s master georeference tables also get updated Another useful application of StreetWorks is creating strip maps for directions to your facility CACI EVER VIGILANT ARGISS Training Manual Creating a Strip Map To create a strip map l Open the Streets layer for a county 2 Open the georeference table 3 Zoom in on two facilities in that county 4 Using the Label tool label the streets that yo
70. a Lotus 123 file Saving a Query without an ODBC Profile To save the data without using an ODBC profile l Click the Save button in the View Edit Result Data dialog 2 Check the Save Data Information checkbox 3 Select none from the ODBC Profile drop down list 4 Enter a Table Name The name can be no longer than eight characters and must not contain any spaces 5 Click Save 6 In the Save Data Without Using An ODBC Profile dialog open to the folder you wish to save the data in and select a file type from the Save as Type drop down list 1 21 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Save Data Without Using n ODBC Profile Save ini 3 DataBridge Y c a El File name 30june03 Save as type TAB LE DEF CBF Cancel Ta Click the Save button and click OK in the save confirmation message dialog 8 Click the Close button in the View Edit Data Results dialog 9 Select the Close option from the Query menu or click on the toolbar button Query Hem pen Delete Data Bridge Wizard Save Sawe As Exit yl Open Notice you now have an Open toolbar button 11 22 CACI EVER VIGILANT ARGISS ENBOSS Training Manual The Relationship Table The Relationship Table is used to link tables using key fields that contain the same type of data e g facility IDs but have different names e g Fac_id and Facid A relationship can only be est
71. able Relationship Table Key Field Name Table Hame force_file 11 24 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 2 Select Relationship Table from the Reference Table list box in the Table Maintenance dialog The Relationship Table will appear 3 Click New Relationship to create a new relationship 4 The Choose Key Field Name dialog appears Within this dialog highlight a key column and click Add Key Field Name Table Hame Database Profile complex sa_emaar force file sa_emaar 5 Select a second key by highlighting the key and clicking the Add button This will create a relationship between the two keys 6 Click Close to return to the Relationship Table The two primary keys should be in relationship 1 Reference Table Primary Key Table Data Bridge Table Relationship Table Relationship Key Field Hame Table Hame Database Profile 1 fac_id complex sa_emaar 1 facid force_file sa_emaar nakenin powte ore To add a new primary key to an existing relationship l Select a relationship in the Relationship Table 2 Click Add Key Field The Choose Key Field Name dialog will appear 3 Click Add Click Close to return to the Relationship Table The Relationship Table appears displaying the modified relationship 11 25 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Creating a Relationship Before creating a relationship be sure that there are at least tw
72. ablished if the key fields are registered in the Primary Key Table and the fields relating to the key field are registered in the Data Bridge Table The Data Bridge provides the option of using a relationship from the Relationship Table when creating a new query if a relationship exists for the selected key field If the relationship is selected then all the fields registered in the Data Bridge Table relating to the key fields in the relationship are used for the query Implicit v Explicit Relationships Before querying from two or more tables there must first be a relationship between those tables If the primary keys that you are joining the tables on have identical names then the relationship will be implicit and a join in the relationship table is not necessary In this case the Data Bridge realizes that the primary keys contain the same data and creates the relationship for you The relationship will not be visible in the relationship table but you will be able to use columns from any table that contains a field name that is already in the Primary Key table If the primary keys on the tables you are joining have different names then the relationship will be explicit and you must create it through the Relationship Tables This allows the Data Bridge to realize that the tables although the primary keys from each have different names they contain the same data Inserting New Fields through an Implicit Relationship Once a primary key has bee
73. adsheet form use a Browser Window l Choose Window gt New Browser Window or click on the New Browser E button or by pressing F2 The tabular data associated with the STATESHR table displays Note that BROWSE replaced MAP as an option on the Menu bar This is a window specific option that is available only when a Browser window is active OJK aLaska H Dllal ALABAMA Dllar SRKANSAS llas AMERICAN SAMOA Qlaz ARIZONA Llica CALIFORNIA Llica coLorRaDO jet CONNECTICUT oc DISTRICT OF COLUMBIA _ DE DELAWARE LJ FL FLORIDA Llica GEORGIA GE GERMANY LJjcu Guam LHI HAWAII gt al The user can view both the Map window and the Browser window at the same time by selecting Windows gt Tile Windows or press lt SHIFT gt and F4 These windows are interactive CACI SS EVER VIGILANT MapInfo Professional File Edit Tools Objects Query Table Options Map Window Help oela el eee ol alalclaa aaa ap AR ea darla aaa 111 48 3 elz ee als Stateshr Browser Efel x amp Stateshr Map State o o o o o o o o 7 Ofo Jocaware o o o o o o Ole fmo z Op ona o o o 7 o Ono marao O me mame o Cima MICHIGAN Sa a e Navigating the Map Window ARGISS Training Manual ME ES The benefit of viewing maps on computers is that the user can manipulate the map for easy of viewing The user will often need to change a view of a m
74. al oa_emaar a oa enboss common Oa riser odbc file den rmilocaldatabase 3 Select an ODBC profile from the ODBC Profile drop down box If a new ODBC profile needs to be created for the table you want to insert follow the Windows XP process for creating ODBC Profiles or call the Engineer Automation Help Desk at 1 800 447 5737 4 Select a table from the Table drop down list or type the name of the table in the Table field The Field Names list box is populated with the table s fields If any fields from the selected table have already been registered in the Primary Key table they do not appear in the list A Insert Key Field x ODBC Profile oa_emaar Database Database Type Table Field Desc Field Hames Unknown Oracle bt complex acres Tg afrc_host_service coe dist deleted in_ifs S Insert exces disp fac_id ee fac_state Il 8 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 5 Select a field from the Field Names list box Be sure the field s values are common i e not necessarily the same field name to those in any other tables that you wish to link together E Insert Key Field ODBC Profile oa_emaar bl Database Unknown Database Type oracte Table complex Field Desc fac_id acres rg afrc host service coe dist deleted in_ifs exces disp Field Hames 6 Click Insert in the Insert New Filed dialog
75. alog select oa_emaar from the ODBC Profile drop down box This is the profile that the COMPLEX table comes from U BB Insert Key Field ODBC Profile oa_emaar bul Database Unknown Database Type Oracle Table complex Field Desc fac_id acres rg afrc host service coe dist deleted in_ifs exces disp Field Hames 5 Select the COMPLEX table from the Table drop down box From the Field Names list box select Fac_id as the key column to insert 6 Click Insert to insert Fac_id into the Primary Key Table and click OK in the confirmation message ITE 44 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 7 Click Close Note you now have a key field name Fac_1d for table name COMPLEX in the Primary Key table Insert Fields into the Local Data Bridge Table l Highlight the Data Bridge Table from the Reference Table list box within the Local Table Maintenance dialog Notice only the Fac id field is populated within the Data Bridge table 2 Click New 3 Select Fac_id as the key field from the Key Field drop down box This is the primary key that was just inserted into the Primary Key table A Insert New Field Key Field EA ODEC Profile oa emaar Database Unknown Database Type Oracle Table complex afrce host service Field Hames deleted in_ifs exces disp fac street fac title 4 Select oa_emaar from the ODBC Profile drop down box
76. and save it to the C ENBOSS ARGISS FPS DATA directory 5 Click OK Zoom In to Omaha Using the Zoom In button zoom into the Omaha area The facilities within Omaha should be highlighted on the map Open the OMAHA Table You will now open the query you just saved as a permanent table OMAHA l Select File gt Open Table 2 Select the OMAHA TAB table from the C ENBOSS ARGISS FPS DATA directory 3 Click OK Create a Graph for the Omaha Facilities 1 Select Window from the menu bar 2 Select New Graph Window from the menu items Hew Graph Window Graph Table omaha using Columns Gring sl Label with Colum Fac_id a caca to 3 Select the Omaha table as the Graph Table 4 In the using Columns drop down boxes select Rq tng sf and Gr_tng sf 5 Click OK To add a legend to the graph C 57 CACI EVER VIGILANT ARGISS Training Manual Click the Show Hide Legend button from the Main toolbar Double click on the legend to change the options Add a title and a subtitle Click OK oe Create a Layout Window You will now create a Layout window to place all of the open screens into one page l Close all windows that you do not wish to appear in the layout leave only the map window the OMAHA browser window the graph window and the legend open Ze Arrange the map window to display what you want 3 Click Window from the menu bar 4 Select New Layout Window from the menu items Hew Layo
77. anual Objectives PlanView displays the site and floor plans of facilities in FPS For PlanView to display a specific site or floor plan PlanView must know the directory location of the plans In addition the site and floor plans must be registered within PlanView PlanView can be activated from within the FPS module Users activate PlanView by using a menu option or by pressing F6 Plan View opens and displays the site or floor plan for the selected facility Plan View can also be activated standalone from the ARGISS 8 1 program group The following objectives will be discussed in the PlanView section Accessing Plan View Displaying the MapInfo Window Displaying the Plan View Window Registering Site and Floor Plans Viewing Site and Floor Plans 9 ete oo o o Creating a Thematic Map Accessing PlanView Flanwiew To open PlanView select from the ARGISS Application Group The program launches MapInfo and the PlanView dialog displays View Help e mi Type Site Plan Floor Plan Facility ID Display Building Ready A IV 3 CACI EVER VIGILANT ARGISS ENBOS Training Manual Viewing Directory Information The Directory Information window informs the user where the site and floor plans are stored To view directory information l Select View gt Directory Information The Directory Information dialog displays containing the Location of Floor Plans directory path of the flo
78. ap l 2 C 12 Select File gt Close All oe Select File gt Open or click the Open Table la button Highlight STATESHR and choose Open The United States map opens into a Map window Sl ES CACI EVER VIGILANT ARGISS Training Manual i Stateshr Map Aa E There are multiple ways to change a map s zoom level The Change View command allows the user to enter an exact zoom level This also allows the user to set a specific map scale or to set the center point of the window l Select Map gt Change View or right click anywhere in the map window click Change View The Change View dialog displays Change View Zoom window width Map Scale 1 in l mi Center of Window 2 93 6 deq Y 38 5 deg Cancel Help py Type 4130 in the Zoom Window Width box 3 Select OK The map will redraw with a zoom level of 4 130 miles The status bar at the bottom left of your screen reflects the new specification The center point of the map does not change unless new coordinates are entered CACI EVER VIGILANT ARGISS Training Manual Using the Main Toolbar to Change a View In addition to using the menu structure to access the Change View dialog the user can click the Change View Q button or right click anywhere in the Map window and select Change View from the menu Zoom In Q Zoom Out E and Grabber SI tons The Zoom In Button RQ l Click the Zoom In Ql button on the Main Toolbar The
79. apping functionality enhancements ARGISS 3 0 incorporated two new applications into its toolset Plan View is an application to view site and floor plans and the Environmental Planning System EPS an application that helped users report on environmental related data The Data Bridge enhancements resulted in more querying flexibility and consolidating environmental specific data from different sources In addition the ARGISS 3 0 version of FPS featured mapping enhancements ARGISS 3 1 was designed to work with MapInfo Professional version 4 0 2 ARGISS 3 1 was released in October 1996 ARGISS 5 0 was released 1 October 1997 ARGISS 5 0 required three phases of development The first phase required converting the existing PowerBuilder code from PowerBuilder version 4 to version 5 The second phase consisted of converting the existing ARGISS Database Management System DBMS FoxPro to the Engineering Management Automation Army Reserve EMAAR Relational Database Management System RDBMS and Sybase SQL Anywhere The third phase included incorporating new functional elements into the ARGISS CACI EVER VIGILANT ARGISS ENBOSS Training Manual system including the ability to access multiple data formats new EPS reports Create Application Data process enhancements and the ability to run Data Bridge queries created by other users ARGISS 5 1 was released on 12 December 1998 This release featured significant revision to the Data Bridge
80. as a permanent file l Click File gt Save Copy As Stateshr Complex Interest Quer pA Save Copy of Table As EJ My Query Results Ga FACS TAB Mapinfo tab hd GEC 3 Give the table a name and Save it in a folder that you will remember CACI EVER VIGILANT ARGISS E Training Manual Creating New Maps MapInfo allows users to create maps from existing database files To display your data on a map you must first assign X and Y coordinates to each record MapInfo assigns these coordinates by means of geographic information contained in your database table This data 1s then related to another table referred to as the search table that already has X and Y coordinates associated with 1t For this example we will use the georeference table GEOREF TAB as the search table It 1s recommended to never geocode large databases directly from the LAN For example you may want to assign X and Y coordinates to a Data Bridge query that has a Fac id field in the database MapInfo would read the Fac_id and look for matching Fac_id s in the search table e g georef tab This search table already has X and Y coordinates associated with each record When MapInfo matches the Fac_id s in your Data Bridge query to the Fac_id s in the search table georef tab 1t assigns the corresponding X and Y coordinates to your record The geocoded point becomes part of your database You can view these points by displaying your ta
81. at cover a giver area e g country state zip code boundary Text Refers to text that describes any of the previous objects e g labels titles north arrows It is recommended that each type be a separate layer on the map When opening a file in MapInfo two tables are being created For example when opening a dbase or FoxPro table MapInfo automatically splits 1t into two files The two types of files are Myfile tab describes the structure of the table This is Map nfo s primary file type Myfile dat contains the actual data saved in MapInfo s file format the table is considered mappable if it can be graphically displayed on a map within MapInfo In order for the table to be mappable the records must be assigned latitude and longitudes through the process of geocoding The two additional files necessary for graphic objects are Myfile map describes the graphical objects Myfile id cross reference file that links the data with the objects The table may also contain an indexed field Indexes allow searches to be performed on the table For example in order to search on an address the address field must be indexed in the table in MapInfo The additional file necessary for an index is Myfile ind indicates a reference point or index to perform a search on a field CACI EVER VIGILANT ARGISS Training Manual Viewing Tabular Data To display the data in the STATESHR file as text in a database spre
82. at drill there Scenario Il Congressman Snort went back to Washington D C with his colleagues very pleased with your presentation However within a few weeks he started receiving complaints from the soldiers training in NE003 explaining that they do not have enough space to train To correct the problem ACSIM is considering an MCAR project to expand the existing space in NE003 The MCAR process is being expedited due to the fact that NE003 is at 250 utilization and reported as a RED facility in the Installation Status Report ISR This morning you found out that Congressman Snort and his colleagues want to visit NEOO3 and a strip map with directions for Congressman Snort needs to be created so he can find NE003 without getting lost You also must start the MCAR process You as the Master Planner Facility Manager Environmental Engineer Budget Analyst the 89th is a little understaffed at this time for the 89th RRC it is your responsibility to develop another briefing for the Congressman and his colleagues You will include the following in the final presentation e Street Information and Directions CACI EVER VIGILANT ARGISS ENBOSS Training Manual e Facility Information e Unit Information e Financial Cost Information The Master Planner SGT Bilko has been asked to prepare a second briefing for Congressman Snort The briefing should include a master report and a Microsoft PowerPoint presentation with appropriate maps and g
83. aved as a default by choosing Options gt Toolbars the Toolbar Options dialog displays click the box next to Save as Default as shown below Toolbar Options Toolbar Show Floating CE Drawing Wo p Main MT Cancel Standard jw p DBMS O o Lep I Color Buttons Large Buttons I Show ToolTips The Standard toolbar contains the screen elements most often used as shown in Table III 2 All of these functions can also accessed through the menu options The following tables define the buttons on the Main Drawing and ODBC Toolbars Table II 2 Standard Toolbar C Creates a new table New Table Allows the user to open a MapInfo table dBase DBF file delimited Open Table ASCII file Lotus 1 2 3 spreadsheet Microsoft Excel spreadsheet or raster image Save Table Prints the contents of a Browser Redistrict Map Graph or Layout Print window u Copy the clipboard Paste edited you cannot paste text into a query table Ba O Undo k Allows the user to view and work with text data in table form New Browser PA Displays a table as a map New Map C 4 CACI EVER VIGILANT ARGISS Training Manual Window o S O Displays a table as a graph New Graph New Layout windows for printing Baa iio ae New Redistricter h2 To get help on a topic click the Help button on the Standard Toolbar Help Click on an area and information on the area clicked will come up in a standard Help Window Tabl
84. aw and Main toolbars are dockable toolbars which can by placed anywhere by clicking on their title bar and dragging to the desired location Once you have placed the toolbars in the desired location it can be saved as a default by choosing Options gt Toolbars the Toolbar Options window displays check the check box next to Save as Default C 9 CACI EVER VIGILANT ARGISS E Training Manual Understanding Tables MapInfo allows users to view and manipulate database information in many different ways Spatial data can be mapped to view and analyze spatial relationships such as roads lakes and distances between USAR centers Textual data 1s displayed in a spreadsheet format within a Browser window or as individual records shown in an Info Tool window Numeric data can be graphed within MapInfo quickly to show mathematical relationships between data A Layout window allows the user to combine all these types of data in one window for plotting or printing MapInfo organizes spatial data in four different types Any of the four types will be referred to as objects when discussing MapInfo functionality These four types are Point Refers to a single location of a data element e g building location fire hydrants or wells Line Refers to straight or polyline objects that cover a given distance and have no area associated with them e g road centerline fence line property line Region Refers to closed objects or polygons th
85. ay receive a message stating someone else is maintaining the PlanView table Wait a few minutes and try again View a Site Map Launch the PlanView module by selecting 3 from the ARGISS Application Group Click the Site Plan radio button Select NE003 as the facility id E View Help e mi Type f Site Plan Floor Plan Facility ID Display Building Ready Z 5 Click Display The site plan of NE003 is displayed Add a Title to the Site Plan Using the skills you have learned earlier add a title to the site map l Click the Layer Control button 2 Highlight the Cosmetic Layer 3 Check the Editable check box for the Cosmetic Layer IV 14 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Layer Control x Layer Die 2 Cosmetic Layer E A E Y OK MO mM oO Cancel Disma Label Thematic Layers Reorder Add Benmore Up Eire Help 4 Click OK 5 Select the Text tool from the Drawing toolbar 6 Position the cursor on the map click the left mouse button and type a title ELL EE View a Floor Plan Press F6 or select Options gt Plan View Window from the MapInfo menu bar Select the Floor Plan radio button under Type on the PlanView window Select NE003 as the Facility ID under the Facility ID drop down box Click on the Building drop down box and select NE003 Main USARC as the building to be displayed E a View Help e mi Type C Site Plan Fl
86. ble in a Mapper window There are multiple methods of geocoding data These are Geocoding by Address When you geocode your table with street addresses MapInfo matches the addresses in your table to the addresses in a search table that contains street level data and assigns X and Y coordinates to the record s address Geocoding by Boundary When you geocode your table with boundaries MapInfo matches the boundary name in your table with the boundary name in the search table MapInfo assigns the boundary centroid X and Y coordinates to your data records The centroid of a boundary 1s the approximate midpoint Zip code boundaries can be used to geocode records that contain zip code fields MapInfo also allows the user to geocode data in two modes 9 Automatically Geocodes exact matches only and ignores all other records in the table 9 Interactively Pauses when it cannot match a record and lets the user select from a list of close matches Always geocode automatically first then go back and geocode interactively to match the records MapInfo could not complete This will speed up the process by not requiring user interaction for every record To geocode a database file l Open the table you wish to geocode by selecting File gt Open Table Open the table that will be used as the search table If geocoding queries from the Data Bridge the search table to use is the T ARGISS DATASET GEOREF TAB gt Once the geocode and search
87. c_street fac_id complex fac_city fac_id complex complex complex Ifs sf total fac 1d complex 7 Click the Where Clause button from the Query dialog 8 The Where Criteria dialog displays This dialog is used to develop the filter criteria ITE 66 CACI R VIGILANT ARGISS ENBOSS Training Manual 9 Within the Where Criteria dialog select fac_state from the Variable Field drop down box 10 Select the equal sign from the Operator drop down box 11 Enter any 2 character state abbreviation in the Value box 12 Click the Add button and then click OK 32 Press the Run button from the toolbar 33 The View Edit Untitled Result Data dialog appears with the results of the query 34 Launch Excel to obtain a copy of the report in a standard format 35 Click Save The Save Query and Data dialog will appear 36 Check the Save Query Information check box and name the query 37 Select an access level from the drop down box 38 Select FPS Reports from the ODBC Profile drop down box 39 Enter FAC LIST in the Table Name box 40 Click Save Using the Data Bridge Wizard to Build Queries The following exercises should be completed using the Data Bridge Wizard Now that you are familiar with the background operation of the Data Bridge use those skills to manipulate the Wizard Create a report containing 2002 ARR J account RISER information l Ze Create a query in the Data Bridge containing 2002 ARR J account
88. ccsscccssccusccescccsccusscusceecceusseusccuseceusceuscenecs 111 21 PNG TES SG PS HELP orador tance heteaassuacions 111 22 EXITING THE FACILITY PLANNING SYSTEM csccsecceccceccescccccscccsccusccsccacccsccesccesccsscesceascesscenceuseaeees 111 22 FPS DATA MANAGEMENT vasisscccccnne ncssnnsucnscoweecohowasonssanwadoaawnsedodanpbanctennboanasapendneosadadadoabaesbawenwcteacweadbass 111 23 BIC TV A oa TI acne E EEE asweapoaanaencee cmeaabtanasesseuceeeanacs M 24 UPDATING FACILITY IDS AND THE GEOREFERENCE TABLE cccccsecceccccccecccscccccscccsccesecsccescesscesceaes 111 24 EXITING THE FACILITY PLANNING SYSTEM csccsecceccceccceccucccsccesccsccuccesccscceuceusccsscasccuseceseaecenseeeeees 111 26 PRACTICAL AE E O ee ne eee eee ee 111 27 Table of Contents ARGISS ENBOSS Training Manual SECTION D sao shece ices sew need dace scen cece cece A ia IV 1 PEANY TE Wi is IV 1 OBJECTIVE S 12 atacada Iv 3 PRC CES SING PLAN VIEW a dt Iv 3 VIEWING DIRECTORY INFORMATION xi a a a Sta Iv 4 DISPLAYING THE MAPINFO WINDOW iaa a adi Iv 5 DISPLAYING THE PEAN VIEW WINDO Wes iii Iv 5 REGISTERING A er AS cl ANC e reer ene ee di IV 5 DELE TNG OIE RLANS tr lan toldo tato todo sd IV 7 REGISTERINGA FLOOR PLAN ada tadas IV 7 DELETNGAFLCOOR PEAN cta do lit Sonentatacoaanes IV 8 VIEWNGA SIE FLAN eae del o a a A IV 8 VIEWINGA LOOP LAN its Iv 8 CREATING A THEMATIC MAP 0 a it tidad Iv 9 LABELING ROOM INA S dust da ida ata rv 11 OPENING PLANVIEW S ON LIN
89. centroid X and Y coordinates to your data records The centroid of a boundary is the approximate midpoint Zip code boundaries can be used to geocode records that contain zip code fields MapInfo also allows the user to geocode data in two modes CACI EVER VIGILANT ARGISS Training Manual Automatically Geocodes exact matches only and ignores all other records in the table Interactively Pauses when it cannot match a record and lets the user select from a list of close matches Always geocode automatically first and then go back and geocode interactively to match the records MapInfo could not find a match for To geocode a database file l Open the table you wish to geocode by selecting File gt Open Table Open the table that will be used as the search table If geocoding queries from the Data Bridge the search table to use is the T ENBOSS ARGISS DATASET GEOREF TAB 3 Once the geocode and search table are open select Table from the menu bar 4 From the Table menu items select Geocode 5 Select the table to geocode from the Geocode Table drop down box 6 Select the column to use to geocode with e g Fac_id from the Using Column drop down box 7s Select a search table from the Search Table drop down box e g georef 8 Select the column from the for Objects in Column to use as the field to search and assign records to the geocode table 9 Click OK MapInfo will geocode as many records as it can and return a mes
90. ck the New button from the main Data Bridge window 2 Select a key field from the Key Field drop down box There should be only two key fields available Choose either one 3 The following message will appear Click Yes Relationship Found 2 There i a relationship in the Relationship table for key field Tac_ id Do you want to set the relationship between the tables Choosing No will display all fields registered for the selected key field Yez Ho 4 Select a relationship from the Choose a Relationship dialog There is currently only one relationship Click on either Key Field Name to select a relationship By choosing the relationship you will join the tables together and query them as if they were one Choose a Relationship Database Profile oa_emaar forc_fil force file force program file oa_emaar Relationship Key Field Hame Table Hame 5 Click OK I 53 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Create Facility and FORC FIL Query 1 Highlight the following fields from the Field Description list box These are the fields from COMPLEX and the FORCE FIL tables Field Name Table Name auenl forcefile fac state complex fac street complex fac_title fac_zip Ifs_sf total re Select Key Field facia complex Suppress duplicate rows vw Field Descriptions Selected Field Descriptions acres rq afrc_ host_service coe dist deleted in_ifs Add All
91. ct the fields you would like to graph These fields must be numeric fields a i 6 Click on the down arrow next to the Label with Column and select a column to label with For example if you graphing the gross training square foot you would want to label with Fac id T Click OK The graph of the query is displayed Resize the graph if necessary to make it more legible Graph of Ga _ facs 64014 2 GADE co GA002 64034 i Gao d 64077 0 20 000 40 000 60 000 50 000 10 000 30 000 50 000 70 000 Gr tng_st You may want to change the type of graph to display your data To change the graph type l Make the Graph window active 2 Click Graph from the menu bar CACI EVER VIGILANT ARGISS Training Manual 3 Select Graph Type 4 The Graph Type window allows the user to change the graph title font color and the graph type Select the Bar radio button under Graph Type and change the title Graph Type Graph Title Georgia Training Facility Sizes A Graph Type rea f Bar C Line C Pie D Options M Stecked M Gvedeooed Drop Lines Rotated M Show 3 D OF Cancel Help Overlap 30 Bar Gutter fi O Start Pie Angle o gt Select any options under the Options box 6 In the Graph Title entry field T in a name for the graph T Click on the Style Button and color of the text 8 In the Options check box uncheck the Rotated option as 10 Click OK Chang
92. dHoc 13 Click Map 14 Inthe H ENBOSS ARGISS FPS DATA directory choose the dbf file that you saved earlier 15 Click Open 11 17 CACI EVER VIGILANT ARGISS ENBOSS Training Manual FPS 12 x File Edit Tools Objects Quer Table Options Browse Window Info Help NIM QQ DIS ea Biz Biel Bis osas ofojpolaAJa gt 2 ar Ay Facility Info FPS EF Ad Hoc Report O x Facid Factitte _Fac_street_ ATHENS USART 2190 WINTER ILLE ROAD AUGUSTA USARCIAMSA 3911 WIRIGHATSDORO ROAD CARROLLTON USART 1202 BANKHEAD HIGH rl Mo record COLUMBUS USARC 1 3001 MACON ROAD DOBBINS USARCIASF BLOG 1012 1612 HULL Pus od records 1 5 of 268 A map with magenta circles will appear This Ad Hoc map represents the data that you saved from the Canned Reports Use your Info button and click on a magenta dot The Facility Info window will populate with all of the data from the canned report Ad Hoc Reports Ad hoc reports allow users to create reports from scratch or modify copies of Canned Reports formats For instance the user can create a new report that combines information from several EMAAR tables or that shows data from a Data Bridge query Creating Ad Hoc Reports To create an Ad Hoc Report l Select the Ad Hoc Reports option under the Info menu You can also access 4d Hoc Reports from the Search By Information dialog 2 An InfoMaker session will be launched Create and modify the report in InfoMake
93. dard symbology databases and analysis tools The Corp of Engineer district supporting your region may also have GIS data available as well as that for active Army installations Contact the appropriate personnel to determine the amount and range available if any A 6 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Private Resellers There are multiple private resellers in the GIS market that have data available We have mentioned some of the government agencies that offer free or very cheap GIS data over the internet This data may be in raw format and considerable GIS knowledge or file translation packages may be needed to utilize the data Private resellers offer turnkey products and data for a fee The MapInfo website has a list of the larger private resellers of GIS data To access the MapInfo website go to http www mapinfo com Conclusion GIS data is available in a wide range of formats and types A large amount of data is available at little or no cost However the data may need to be translated or processed to a format that MapInfo can use Private resellers will package the data in the format requested by the purchaser Please contact the ARGISS Help Desk for further information and guidance if purchasing GIS data contained within ARGISS A 7 EVER VIGILANT ARGISS Training Manual Appendix B ARGISS General Information B 1 CACI EVER VIGILANT B 2 This page intentionally left blank
94. data for example they all have the five digit facility identification codes This wary will be able to join all the tables racctgdt restdt rpintodt commit arnt cammit at f wo id lt Back ma 11 For all three tables select Wo_id as the key field 12 Click Finish 13 The Data Bridge Wizard informs you that there are duplicate field descriptions in the Data Bridge table AS Duplicate Field Description Inserting the field fac_id from table rpintodt with the field description fac_id would produce a duplicate field description in the Data Bridge table Therefore the field description has automatically been changed to fac_1d1 You can either accept the automatic description by pressing Insert change the description by pressing Change Description or skip the insertion of the field by pressing Skip Field Change Description Skip Field 14 Click Insert to insert the suggested field name or Change Description to give the field your own description Continue this step until all of the duplicate descriptions are renamed 1 61 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 15 The New Query dialog appears with a message that the Wizard has updated all reference tables for you A New Query Congratulations The Data Bridge Vizard has Updated the Reterence Tables for you Do you want to start a new query with the information vou ente
95. e Layer Control window The NECOMPLX data will now display on the map AutoLabel NECOMPLX l Click the Layer Control button 2 Highlight the NECOMPLX layer and click the AutoLabel check box CACI EVER VIGILANT CWNIAAKRY ARGISS Training Manual Layer O Tre Cosmetic Layer RR np OK MTM iY Veen Cancel M TO Mw MEMC Display MEKE Label Thematic Layers Reorder Add seno Up Down Help i ELEF EE Click the Label button to change the label options In the Label With box select Fac_id Check the Allow Overlapping Text check box Click the Aa button under the Styles options Change the color of the text by selecting a different color in the Text Color box Change the text size to 8 in the font size drop down box Click OK 0 Click OK on the Layer Control window The map window should now contain all of the facilities in Nebraska labeled by Fac_id Zoom in to Nebraska to view the facilities Label the Facilities with Fac_id Fac title and Fac_city les Click the Layer Control button 2 Highlight NECOMPLX 3 Click the Label button 4 In the Label With box scroll to the bottom and select Expression The following window will appear CACI EVER VIGILANT ARGISS Training Manual Expression Columns Type an expression Fac_id chr 13 Fac_title chr 13 Fac city Type in the following expression Fac_id chr 13 Fac_title ch
96. e MI 3 Main Toolbar Function RL Select Button Selects one or more objects The select button is the default pointer or cursor tool Marquee Select Selects map objects that fall within the borders of a rectangular drawn region K Radius Select Selects map objects that fall within a circular drawn region Selects map objects that fall within the borders of a selected polygon region El Zoomin Zooms in to obtain a closer view of a map or layout a Zoom Oui Zooms out to obtain a wider view of a map or layout el Change View Changes settings for map window length map scale map size and map centering Repositions a map by clicking the left mouse button and dragging the map to the desired location or view Displays the associated database information of an object by clicking on the object Labels objects on the map with information from a related database Sal Drag and Drop Places Mapinfo Professional Map into an OLE container application to paste into a Microsoft Word or PowerPoint document Specifies how the various tables layers in a map are displayed labeled and ordered Determines the distance between two points or the length of a path Displays or hides the map or graph legend A TER Displays or hides the statistics window containing sum and figure averages for all selected numeric fields K Polygon Select C 5 CACI EVER VIGILANT ARGISS Training Manual Table III 4 Drawing Toolbar F
97. e number of databases to join A maximum of six databases can be included in the join 1 36 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Data Bridge Wizard Select Number of Databases Welcome to the Data Bridge Wizard Complex Interest During this process will assist you in joining tables fram similar or Units different databases so that you can query information from various sources ll Enforce Just tell me how many databases you want to join their location which FMAAR tables and fields you want from each database and the fields you will use to join the tables together You will be able to relate fields from various types of databases including MS Excel spreadsheets MS FoxPro database files MS Access tables and Sybase Adaptive Server Anywhere Tables RPINFODT RACCTGD RENDGDDT A database is a set of tables For example the illustration to the lett RISER depicts part of the EMAAR and RISER databases The Complex Interest Units and Enforce tables exist within the EMAAR database Similarly as RPINFODT RACCTGOT and RFMOGODT are tables within the RISER database How many databases do you want to join p m caca 3 Click the Next button The Select System Database dialog appears Data Bridge Wizard Select System Database What database contains the first set of tables that you will be joining Select database 1 of 2 Select Database RISER Active O RI
98. e the Axis settings under the Graph menu options Now the graph has an appropriate title fonts and has been rotated Ee Ga_facs Graph e ra Georgia Training Facility sizes a0 000 60 000 40 000 20 000 o 4014 GADE GADO GAD34 G4011 GAO GANS GAOT GAOSO 64001 640 6 Fac id You may need to further customize your graph to the right of the Graph Title to change the font size CACI EVER VIGILANT ARGISS Training Manual Creating a Layout Window MapInfo s Layout window is a page layout feature that allows you to combine your different windows on a page and arrange them for output For example you may have a Browser window and Graph window open simultaneously and want to print both of the windows together on one page or plot and add text such as titles and labels to pull the entire presentation together A Layout window allows you to do this as well as preview the page before printing To create a layout l Close the windows that you do not wish to appear in your layout Select the desired printer paper size and page orientation from the File gt Page Setup window See the Page Setup section for more detail 3 Click Window from the menu bar 4 Select New Layout Window Hew Layout Window E4 Create a new Layout window containing C One Frame for window ia_facs Stateshr Map Frames for All Currently Open Windows C No Frames UE Lancel Help gt Choose Frames for
99. ect the Ocean layer and use the Down button under Reorder to push the Ocean layer down to the bottom 3 Click OK Use the Label Tool The next few steps will show you how to label objects interactively Later we will learn how to label objects automatically 1 Select the Label button from the Main toolbar Ze Position the cursor over a state and click the left mouse button Delete the Labels CACI EVER VIGILANT ARGISS Training Manual l Use the Select button a to select the label you want to delete 2 Press the delete key 3 To delete all of the labels select Map gt Clear Custom Labels AutoLabel The next steps will change the default font of the labels and label all of the states in the Stateshr layer l Select Map gt Layer Control or click the Layer Control button Shortcut Place the cursor inside the map window and right click on your mouse then select Layer Control Layer Control a a i Layer OK Cosmetic Layer Cancel JAAA JAAA SOO ELEF EE RII y Display Label Thematic Layers Reorder Add Seno Up Down Help Ze Select the Stateshr layer 3 Select the AutoLabel check box 4 Select the Label button CACI EVER VIGILANT ARGISS Training Manual Stateshr Label Options Label with State m Visibility f On c Off IM Allow Duplicate Text C Displ thin A il i Allow Overlapping Text Label Partial Segments io Maximun Labels
100. ed PNE DAE Dae fe DueAssewed INSPECT m Information amen e po REG oee 6 B 15 CACI EVER VIGILANT ARGISS Training Manual PERMIT Permit Information Column Type Length Description EXP DAE Date e Poono ooo o FACID Character 5 FFID Number INIT_DATE be s ebe O PERM FEE Float 13 0 Permit Fee PERM_NUM Record Number Other Columns Used by ARGISS This section lists the tables and columns used by ARGISS that come from systems not listed above These columns are used in the Create Application Data processes to generate the Reports for FPS Any structure changes to them will also cause structure changes in the reports the MapBasic code and the PowerBuilder code FORC FIL Column Description ACTCO l Action Code AUAGR Numeric Authorized Aggregate sum of authorized strength for officers warrant officers and enlisted EDATE Effective Date FACID 5 Facility ID ORD DATE Date 8 Date Orders were Cut ORDER NO Character 9 Order Number STAGR Required Aggregate sum of required strength for officers warrant officers and enlisted UIC Character 6 Unit Identification Code UNMBR UNTDS Character 21 Unit Description FPS Created by the Engineering Automation Help Desk ACT AT EXP Action at Expiration what will happen when a lease expires Not Used COST PR SF Numeric 7 Cost per Square Foot calculated at year end using RISER data 7 CST PR SOL Cost per Soldier FAC COND Cha
101. egistered in the Primary Key table are used to join or combine tables in queries Do not register all the fields in a particular table in the Primary Key table Select one field to represent the entire table The field registered in the Primary Key table does not have to be the table s actual primary key but can be any field in the table A particular field e g Fac_id can only be registered once in the Primary Key table 1 6 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Inserting a New Primary Key To insert a new Primary key key field 1 Highlight Primary Key Table from the Table Maintenance dialog and then click New a Local Table Maintenance Reference Table Primary Key Table Data Bridge Table Relationship Table Key Field Hame Table Hame Note This window provides the capability to insert delete and edit primary keys Primary keys are used to combine data in multiple tables so that the user can use this data in creating queries 2 The nsert Key Field dialog displays as shown below The Insert Key Field dialog provides the capability to select key fields from tables in various Open Database Connectivity ODBC profiles The ODBC Profile drop down list box is automatically populated with registered profiles 11 77 CACI EVER VIGILANT A Insert Key Field ODBC Profile Database Database Type Table Field Desc Field Hames ARGISS ENBOSS Training Manu
102. en any of these tools are chosen they remain active after the user is finished using them To turn off any of these buttons the user must click the Select h button from the Main Toolbar When the Select button is active InfoTips will display when the cursor hovers over an object Changing Map Window Options The default Map window options can be changed The map units map projection scale location and type map size and scroll bar options can be changed through Map gt Options To change the Map window options l Click Map from the menu bar then select Options The Map Options dialog displays Hap Options Map Unit da E Coordinate Units Distance Units miles Area Unita square miles When Resizing Window Fit Map to New Window Preserve Curent Scale Display in Status Bar f Zoom Window width C Map Scale Cursor Location F Scroll Bars M Autoscroll The window on the previous page illustrates the many ways to change the default settings for the Map window For example it may be necessary to change the default distance and area units of miles and square miles to feet and square feet if working with a site or floor plan This makes the CACI EVER VIGILANT ARGISS Training Manual area and distance data more intuitive to most users If using FPS it is not necessary or recommended to change the map projections As with other Windows products there are additional opt
103. ent will have a thorough knowledge of the ARGISS mapping capability as well as the query building process in the Data Bridge by using Table Maintenance and through the Data Bridge Wizard At the end of each section you will find practical exercises The practical exercises build upon themselves and it s very important for the student to follow these exercises The exercises are based on a hypothetical problem that illustrates how Data Bridge can be used to assist the Army Reserve Engineer with his or her daily job functions The following paragraphs explain the scenario of the practical exercises Scenario Congressman Snort is visiting the 89 RRC with some colleagues from Washington D C He is coming to your RRC to better understand the Army Reserve needs for his state and more importantly his hometown of Omaha Nebraska As the Facility Manager Environmental Engineer Budget Analyst for the 89 RRC it is your responsibility to develop a briefing for the Congressman and his colleagues You will include the following in the final presentation Facility Information Unit Information Y Financial Cost Information Work Orders The Master Planner SGT Bilko has been asked to prepare a briefing for Congressman Snort The briefing should include reports derived using Data Bridge The reports include A facility report for the state of Nebraska A report including only the facilities over 50 000 square feet and the units th
104. er can view the data as it is being pulled from the source tables When the query finishes processing the View Edit Result Data dialog appears This dialog as displayed on the next page provides the capability to view edit save and print the queried data A View Edit Untitled Result Data FAC ID COE DIST FAC TITLE 2 A 0 ALASKA FORT RICHARDSON AKOZ ALASKA FORT WAINWRIGHT USAAC ALOU MOBILE BILL NICHOLS USARC ECS 158 ALOU MOBILE GREEN SPRINGS USSAC AMS4 141 ALOOS MOBILE BIRMINGHAM AFRE ALODE MOBILE HORACE E HANSON USAR ALOIO MOBILE BELTLIME AFAC ALOT MOBILE WILLIAM Ww EVANS USAAC ALOT4 MOBILE HARRY L GARY JA USARC ALOTS MOBILE FT AUCKER USAAC ALOZ MOBILE GORDO USARC ALOZ5 MOBILE HUNTSVILLE USARC AMSA 1456 AL0 23 MOBILE JASPER USARE ALOS2 MOBILE ANDREW LESLIE JACKSON USARC ALOS4 MOBILE WRIGHT USARC SMSA 151 G ALOIS MOBILE SGT WILLIAM W SEAY USAAC PROS FANS 973 ALOG MOBILE DAVID MONIAC USARC AMSA 1526 4 Total rows in query 1512 Print Orientation Launch Excel Close Ze If you are querying an Excel Spreadsheet the Choose an Excel 5 Workbook as Database dialog appears Select the XLS file you are querying and click OK The View Edit Untitled Result Data dialog appears with the results of the query 1 14 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Filtering Queries Building a WHERE Clause In order to see more specific results from a query with multiple data sources
105. f 3 Select a Table and a Field Table jii Field JIC T Ignore Zeres or Blanks lt Back Cancel Help J Click Next 8 Change the legend and styles options if desired 9 Click OK The different rooms are displayed thematically using different colors amp NEOOSCIF Map Label the Room Names l Click on the Layer Control button from the Main toolbar 2 Check the AutoLabel check box for the NE003C1 F IV 17 CACI EVER VIGILANT ARGISS ENBOS Training Manual ets 3 Click the Label button RoomName F 4 Select RoomName as the field to label with de Check the Allow Overlapping Text check box CACI EVER VIGILANT ARGISS ENBOSS Training Manual AA 6 Click the Styles button El to change the font size of the text Text Style Font Arial 5 Text Colo ME Teseterenerccereetmes Sample Background Effects C None Hao Box T Bold Underline P Shadow Color T Italic D AllCaps Expanded Change the font size to 5 point Click the Box radio button under Background Click OK 0 Click OK from the Layer Control window a ee ees MapInfo automatically draws all of the room names for the floor plan displayed Add Site Floor and Thematic Maps to a Layout l Select Window gt New Layout Window 2 Select the Frames for All Currently Open Windows radio button Hew Layout Window Create a new Layout window containing C One Frame for Wind
106. f No Significant Impact None Populated by popup menu ENVDOCTYP2 Character First Type of Environmental Document Record of Environmental Consideration REC Environmental Assessment EA or Environmental Impact Statement EIS or Finding of No Significant Impact None Populated by popup menu ENVDOCTYP3 Character First Type of Environmental Document Record of Environmental Consideration REC Environmental Assessment EA or Environmental Impact Statement EIS or Finding of No Significant Impact None Populated by popup menu EXPIR DATE Date Expiration Date of Permit Lease or Easement a IO IO Por LEASE PERMIT or EASEMENT Real Estate Type n FEE LEASE PERMIT EASEMENT FAC IDSTR Character Facility Identification Number Automatically populated when an Add is performed USACE Lease Number Used for LEASE Real Estate Type Only MOU CAT Numeric 2 0 Memorandum of Understanding MOU Lease Category Number Used for LEASE Real Estate Type Only Is this Functional Activity Used for Planning Y N UNITS Unit Information Column Type Length Description A A ere remem item DD Forms il hel ene Officers plus Enlisted plus Warrant Officer Name of Direct Reporting Command DRC DRILL WEND Weekend of the Month which Unit Drills FAC ID Facility Identification Number where the Unit is located UNIT NAME Name of Unit CACI EVER VIGILANT ARGISS Training Manual RISER Columns Used by ARGI
107. file Select the File menu then Open from the menu bar Select C ENBOSS ARGISS DATASET GEOREF TAB O Click Open Your map should look like the map below ae oS ee A CACI EVER VIGILANT ARGISS Training Manual IT i Georef Ushwy Miltbase Nebraska Map Label NE003 some of the highways to orient yourself i Georef Ushwy Miltbase Nebraska Map la WUS 30 1761S 6 Tas Ea ee A 12 Make the Cosmetic Layer Editable in Layer Control and add a symbol to show where the airport 1s located 13 Use the Symbol tool to add a symbol indicating the location of NE003 To change the _ default symbol use the Symbol Style toolbar button CACI EVER VIGILANT ARGISS Training Manual i Georef Ushwy Miltbase Nebraska Map yl aEOO 14 Select the Window menu option then New Layout Window 15 Select the One Frame for Window radio button if it is not already selected and click OK 16 Once your Layout window displays change the orientation to Landscape 17 Using the Text tool type in a title to your window You will need to increase the font SIZE 18 Select the map on the Layout window and select the Layout menu option then Create Drop Shadows 19 Click OK on the Create Drop Shadows window 20 Adda Scalebar to your map Remember you have to have the map window active 21 Select the File menu then Run MapBasic Program 22 Select SCALEBAR MBX and click OK 23 Run the SCAL
108. gt Ada lt lt Remove All Remove Md 2 Click the Where Clause button to filter the data The Where Criteria dialog will appear ITE 54 CACI EVER VIGILANT ARGISS ENBOSS Training Manual a Where Criteria Connector Wartable Field Operator Value View Window Select fac_state from the Variable Field drop down box Select from the Operator drop down box Enter NE in the Value text box Click Add to add the filter to the View Window Nn BW Add Another Criteria to the View Window Select AND from the Connector drop down box 2 Select ifs_sf_total from the Variable Field drop down box 3 Select gt from the Operator drop down box 4 Enter 50000 into the Value box 5 Click Add The filter as shown below will retrieve all of the Nebraska facilities larger than 50 000 square feet dB Where Criteria Connector Wartable Field Operator Value g z View Window complex tac_state NE AND complex f _ f total 50000 00 6 Click OK I 55 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 7 Click the Run button to run the query and process the filter da View Edit Untitled Result Data 0 1 0 0 0 0 0 4 0 4 0 1 0 3 0 E 0 1 0 15 1 0 139 11 0 135 11 0 BF 11 0 Ef 11 0 164 102 0 164 102 0 z a Total rows in query 66 Print Orientation Launch Excel Close Save the Query and Data Click Save from the View Edit Untitled Re
109. haracter 30 Installation Name Renamed as Inst name in ARGISS SQL Anywhere table since Name is a reserved word in SQL Anywhere Local Information B 13 EVER VIGILANT ARGISS Training Manual 3 2 2 4 3 3 NPLA Obligated year ex OBL 96 OP UNIT Character 3 Operable Unit OTH PROJID Other Project ID OTHTYPE Other Project ID Type 10 0 l 50 OBL fy where fy Float is 2 digit fiscal P2CAT P2CAT PRG fy where fy Float Program Budget is 2 digit fiscal year ex PRG 96 PROG CODE Character 1 Program Code PROGRAM Character Program Area PROJNAME Character 50 Project Name PROPNUM Character 5 Property Number REG Character 4 Law Reg REQ 97 Float 10 0 Required REO REQ fy where fy Float 10 0 Required is 2 digit fiscal year ex REQ 96 REVISED Character 8 Date Revised STREET Character Street Address 30 WORKSTART Character 6 ConsiucionWork San CACI EVER VIGILANT ARGISS Training Manual ENFORCE Enforcement Information Column Description PY Character 2 Fiscal Yer Dare FAGOR ooo ISSUE DATE Date 8 Date of Action NOTICE NUM Action Number RECORD ID Record Number RES DATE Date f 8 Date Resolved ENF FIND Enforcement Find Information FINDING Character 0 Deseripfon OOOO FINE Fine Information Column Description DATE PAID Date s DwePaid FACID Character 5 Facility Identification Facil Taeniao o AINE AMT Poe TI Amoun KS Assess
110. hese should be added to the georeference table please contact the Engineer Automation Help Desk This is to make sure we have your changes so they do not get overwritten the next time we run the Create Application Data Process Exiting the Facility Planning System To exit FPS 3 Click File gt Exit MapInfo from the menu bar 4 Click OK to exit 14 26 EVER VIGILANT ARGISS ENBOSS Training Manual Facility Planning System FPS Practical Exercise 11 27 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Exercise Scenario The Congressman needs specific reports and maps of the area in Nebraska he and his colleagues are interested in The Facility Planning System automates the process of map creation and report generating Utilize FPS to obtain the maps and reports that the Congressman has requested You will utilize FPS to Conduct multiple searches by different geographic areas Produce the necessary facility and accounting reports requested for the Congressman s presentation Produce the necessary maps requested for the Congressman s presentation Produce graphs and other information for the Congressman s presentation Create a Map of Facilities within a 50 Mile buffer of Omaha NE 1 Launch FPS Ze Click the Update button and make sure the Local date is more recent than the LAN date If it is click Cancel and if not click Copy Update Location Last Update Source Data
111. hip button The New Relationship Warning message dialog appears New Relationship Warning X AN Relationships must include at least two key fields that contain the same information DF Lancel 3 Click OK Il 51 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 4 Inthe Choose Key Field Name dialog highlight one of the Key Field Names and click Add Choose Key Field Name Key Field Hame Table Hame Database Profile forc_fil force_file force program file oa_emaar 5 Click OK on the confirmation dialog and click Add to add the second field to the relationship 6 Click OK again and click Close 7 The Relationship Table should appear displaying the two fields in the relationship as below CB Local Table Maintenance xl Reference Table Primary Key Table Data Bridge Table Relationship Table Relationship Key FieldName Table Name Database Profile 1 acit complex forc_fil force_file force program file oa_emaar Add Key Field 8 Click Close to exit Table Maintenance ITE 52 CACI EVER VIGILANT ARGISS ENBOSS Training Manual EVER VIGILANT Create and Save a Query You are now ready to create a query from the data you have just inserted into the Data Bridge table You will pull out the relevant information that you need to create for your presentation The query will include facility and unit information that will be used later for creating maps and reports 1 Cli
112. ie Es Planwiew Populating the Data Bridge System Tables The Data Bridge system tables consist of the Primary Key Data Bridge Relationship and Security tables if you are pointing to the LAN system tables If the user has changed the data source to Local the Security Table will not be in the list of Reference Tables if needed Performing Table Maintenance ENSURE YOU ARE ON THE LOCAL DATA SOURCE BEFORE ADDING OR DELETING KEYS FIELDS AND TABLES To perform table maintenance IES CACI EVER VIGILANT ARGISS ENBOSS Training Manual Select the Table Maintenance option from the Administration menu Administration pranie Maintenance hange Data Source Create Application Data 7 Or click on the Tables button on the toolbar The Table Maintenance dialog displays B Local Table Maintenance Reference Table Primary Key Table Data Bridge Table Relationship Table Key Field Hame Table Hame The Table Maintenance window provides the capability to maintain the system tables The system tables include the Primary Key Data Bridge Relationship and Security Reference tables The Security Reference table is only available to users with System level access when the LAN data source is selected Primary Key Table The Primary Key table Data Bridge table and the Relationship table are used to register data source fields used for creating and running queries within Data Bridge The fields r
113. in the Where Criteria dialog select the column from the Variable Field drop down box that you would like to include in the filter 4 Select the operator from the Operator drop down box An operator is a mathematical function that returns a value from an expression gt Enter a value in the Value box The Value box is case sensitive 6 Once your filter is defined click Add to enter the filter into the View Window 1 15 CACI EVER VIGILANT ARGISS ENBOSS Training Manual EA To add the additional where clauses to the current filter select a connector from the Connector box and repeat Steps 1 6 The AND connector finds the mathematical intersection between the two criteria and the OR connector creates a union 8 Click OK once the filter is defined ES Fun 9 Select Execute gt Run or select the Run toolbar button A View Edit Untitled Result Data FACID COE DIST FAC TITLE MEOD OMAHA COLUMBUS USARC MEQUS OMAHA FREMONT USARC MEQUS OMAHA HASTINGS USARE NEQUE OMAHA KEARNEY USARC MEO OMAHA LINCOLN USARC MEQUS OMAHA MECOOR USARC MEMO OMAHA MEADE WET SITE MEOT OMAHA NORFOLK USARC MEDI 2 OMAHA NORTH PLATTE USARC MEOIS OMAHA NM PLATTE AMSA MEOT4 OMAHA ADOLFO RATA OMAHA USARC MES OMAHA BOOKER OMAHA USARC MEQIS OMAHA WYMORE USARC MEQ25 OMAHA Lincoln USAARCOMS MEQ24 OMAHA Omaha USARC OMS AMSA MEQ25 OMAHA LINCOLN OMS amp MEP MEQ26 BASOPS AISER OVERHEAD MEQ OMAHA PROPOSED MCCOOK LTA P Total
114. ing Sites Land Storage Facilities Other Facilities 9 0 1 19 9 29 OH FH 2 DO You can also specify the geographic area to search The available search by criteria 1s Facility Identification Code City State Zip Code Congressional District Unit Identification Code Regional Support Command 9 6 1 a ooo o 1 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Select Search Critena Select Options Search By Facility Identification Code City State Army Reserve Centers Zip Code Congressional District Unit Identification Code Regional Support Command l Armed Forces Reserve Centers Aviation Support Facilities Equipment Concentration Sites E mit Maintenance Facilities Training Sites dl Help T Land Storage Facilities T Other Facilities For the facility identification code city zip code and unit identification code criteria a buffer can be specified To search functional activities by a geographic area l Select one of the Options check boxes All Facilities will search for all of the functional activities in the list below it 2 Select a Search By criteria 3 Click Continue Search By Information Window The Search By Information window will appear This window allows you to specify the search criteria and select the next step to process the search criteria The Search By Information window allows you choose the following outputs Map maps the resu
115. ions available to the user by using the right mouse button while using MapInfo Some of these options directly relate to a map window such as changing the view returning to a previous view or viewing an entire specified layer Map Layer Control Each table that contains graphic objects can be displayed as a layer in a Map window Think of these layers as transparencies where each layer contains a different part of the map The layers are stacked on top of the other and allow you to see all aspects of the map at the same time For example one layer may contain country boundaries a second layer may have symbols that represent facilities and a third layer might consist of text labels Laying these transparencies one on top of the other builds a complete map Layer Control is the most important function within a GIS It is here where you control what layers to view which ones can be edited or selected label characteristics and display options 1 Select File gt Close All Select File gt Open Table or click the Open Table i button on the Standard Toolbar Navigate to T ENBOSS ARGISS BASEMAPS Press and hold lt CTRL gt and click on OCEAN RSCBNDRY and STATESHR a If the lt SHIFT gt key is held instead of the lt CTRL gt key all files between the first and last files will be selected Using the lt CTRL gt key allows the user to select files one by one 5 Select Open or double click on the last table chosen The map displays
116. isible Adding and Removing Layers To add or remove a layer click the Add or Remove button from the Layers group at the bottom left of the window A list of available layers to add or remove will appear Simply click the layer to add or remove If no other files are open select File gt Open Table or click on the Open Table button Chose Miltbase by double clicking on the file name or highlight and click Open The map automatically redraws showing the new layer added 5 Recbndry Miltbase Ocean Map CACI EVER VIGILANT ARGISS Training Manual Displaying Layers When you first open a Map Window boundaries lines points and text are all displayed using defaults in the map file You can change how objects display by using the Display button in the Layer Control window To change display options of a window l Highlight the layer you wish to change the display from the Layer Control window 2 Click the Display button Layer Control Layer i s Cosmetic Layer ra ie ln r T Mee O v a y C Cancel ww MEME Display Label Thematic Hotlink FELER EE f Layers Reorder Add Remove Up Down Help 3 Check the Style Override check box then click the Style Override i button directly below The Region Style dialog displays CACI EVER VIGILANT ARGISS Training Manual Stateshr Display Options Display Mode e Stile Override O oom Layering F Display within Zoo
117. ision Management Decision Package EI PRI Numeric Project Priority Assigned by the Office of the Chief Army Reserve OCAR PROJ FY Numeric 4 0 Project Fiscal Year 0 Project Fiscal Year Fiscal Year PROJ NO NO Character es Project Number ESPN CAT Character Readiness Category Used to identify the status of a project relative to 1ts impact on readiness Valid values are IA IB HA IIB MA HIB HO PROJ Actual Level Project Files Column Description FAC ID Facility Identification Number PROJ COST Numeric 80 Total Cost of Project In Thousands PROJ NO Character 5 Project Number PROJ TITLE TITLE Character a Title of Project TYPE ES Character Type of Construction Valid values are N for NEW E for EXISTING R for REPLACEMENT M for MODERNIZATION B 8 CACI EVER VIGILANT ARGISS Training Manual INTEREST Functional Activities for Facilities in the Real Estate Module Coum 7 l a COST aasa DISP EBS C EFECT DATE ENVDOCCOM1 ENVDOCCOM2 ENVDOCCOM3 Numeric mes Date Date Date Date Date Description Abbreviation of available Functional Activities Automatically populated from the FUN ACTV database when an add is performed in Real Estate Valid values are AFRC MB AFRC AB AMSA G AMSA M AMSA S S AMSA AB USARC Marine Facility USARC ASF MB USARC ASF AB Hanger Hanger AB DS GS MB DS GS AB ECS Land
118. iteria ee a Search By Information City Map Report Map state 4d Hoc Reports Canned Reports Radius Carci miles Help Search By State l Enter a state abbreviation in the State Abbreviation box Ze Click the Map button State Abbreviation Map Report z Ad Hoc Reports Canned Reports HA Cancel e Help II 9 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Search By Zip Code Enter a zip code to search by in the Zip Code box Enter a radius to search with in the Radius box Specify the radius distance units in the drop down box Click the Map button NS Search By Information Zip Code Map Report re Map Radius 4d Hoc Reports miles a Canned Reports Lancel EAS Help Search By Congressional District l Enter a congressional district in the Congressional District box 2 Click the Map button Search By Information Congressional District Map Report Map Ad Hoc Reports Canned Reports Cancel ce Me Help I 10 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Search By Unit Identification Code l Enter a unit identification code in the Unit Identification Code box A Enter a radius to search with in the Radius box 3 Specify the radius distance units in the drop down box 4 Click the Map button Search By
119. kspace Save as NE01 WOR to the H ENBOSS ARGISS FPS DATA directory Group AutoLabel NE003 by UIC 9 11 36 Select one of the NE003 records from the Browser window NE003 is now highlighted on the Map window Use the Zoom In tool to zoom in to NE003 NE003 should be the only facility visible in the map window Select the Layer Control button from the Main toolbar Uncheck the Autolabel check box for the List layer highlight the SIDPERS layer check the AutoLabel check box Click the Label button check the Allow Overlapping Text check box and click OK Click OK on the Layer Control window Notice how the labels are stacked upon each other Select Map gt Group Autolabels from the menu bar Select sidpers as the Autolabel layer Group Autolabels Autolabel layer zidperg a OK Cancel Click OK The UIC labels are now stacked neatly in a vertical format CACI EVER VIGILANT ARGISS ENBOSS Training Manual Facilites Map Ox 10 Print the map and exit FPS Conclusion FPS is a powerful automation tool that allows the user to quickly and easily produce maps and reports The system also provides full MapInfo functionality The system can be used by novice users as well as experienced Maplnfo users To summarize you created and printed the following maps and workspaces OMAHASO Map of all facilities within a 50 mile radius of Omaha NEO01 Map of all facilities within the Congressman
120. kspaces To open a saved workspace l Click File from the menu bar 2 Select Open Workspace 3 Select the workspace to open and click Open or double click on the file name Printing and Plotting Maps Map Graph Browser or Layout windows can be printed at any time When printing or plotting Maplnfo will print the active window The Map Graph and Layout windows are WYSIWYG what you see is what you get If printing a Browser window Map nfo will print everything contained in the Browser To print multiple windows together use a Layout window Page Setup To specify the page setup for a map graph browser or layout l Set the print options by selecting File from the menu bar and then Page Setup CACI EVER VIGILANT ARGISS Training Manual ANSI D 22 834 in SUT Select the correct printer under Printer Select the orientation under Orientation Select the size under Paper Click OK ae a Printing a Window To print a Map Graph Browser or Layout window l Select File from the menu bar then Print from the menu options 2 From the Print window you can change the Print range and Copies if desired CACI EVER VIGILANT ARGISS Training Manual ADCSENGIADOSENG_HPESOC_1_PO gt Click OK Plotting a Map A map can be sent to a plotter to be printed in color for large scale map production To plot a map you must set the print options within Page Setup Redirect the output source to
121. l Help 3 Add scroll bars to the map window by checking the Scroll Bars check box 4 Change the Distance Units to kilometers 5 Click OK Open the RSC Boundary Table 1 Select the File menu from the menu bar 2 Select Open Table 3 Select T ENBOSS ARGISS BASEMAPS RSCBNDRY TAB 4 Click OK Open the Ocean Table l Select the File menu from the menu bar 2 Select Open Table 3 Select T ENBOSS ARGISS BASEMAPS OCEAN TAB 4 Click OK CACI EVER VIGILANT ARGISS Training Manual Open the Population Table 1 Select the File menu from the menu bar 2 Select Open Table 3 Select T ENBOSS ARGISS BASEMAPS USRPPA TAB 4 Click OK Shortcut Press and Hold Ctrl to select and open multiple records Press and Hold Shift click on first and last files to select a range of files You have opened four tables However notice how the ocean table covers the states table To correct this you must go to your layer control Access the Layer Control To access the Layer Control window l Click the Layer Control El button or select Map gt Layer Control Notice that the Ocean table is above the States table in your layer control Shortcut Place the cursor inside the map window and right click on your mouse then select Layer Control Layer Control Laver 2E E s Cosmetic Layer rr np KEKE wee a Cancel KEME MEME Display Label Layers Reorder ea Add Seno Up Down Help Ze Sel
122. lay The site plan for the facility chosen displays Viewing a Floor Plan To view a floor plan Select the Floor Plan radio button under Type on the Plan View dialog Select the Facility ID that the floor belongs to Click on the Building drop down box and select the building to be displayed Click the Select button The Floor Files dialog displays A a IV 8 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Floor Files Building sarc File Hame CA095SC1F CADSSCoF CADIS SF 5 Select the layer s to be displayed on the floor plan and click Display 6 The floor plan for the selected facility and building will be displayed Creating a Thematic Map To create a thematic map l Select the Map menu from the MapInfo menu bar 2 Select Create Thematic Map Create Thematic Map Step 1 of 3 Type Template C Sotby Name Sorby Time Previews TemplateName 0000 l Title Region Indv alue Black and White Subtile PY Line IndValue Black and White Category 1 PY Point Indvalue Black and White Category 2 Bar Charte i ge PY Region Indvalue Default Category 3 Ag Point Indyalue Default nici i egor Pie Charte Line Indy alue Default ee HF Category 7 r Category 5 Graduated Category 9 Category 10 Category 11 Category 12 Category 13 Category 14 Category 15 Category 16 Ey 4 0 0 Ls E See Eustomized legend tert caca s IV 9 CACI EVER VIGILANT A
123. ld Descriptions list box 4 Click the Where Clause button to add a filter for the state of Nebraska to the query The Where Criteria window appears Select fac_state from the Variable Field drop down box Select or type the sign in the Operator box Enter NE for the state of Nebraska in the Value box Click Add to add the where criteria to the View Window A ITE 46 CACI EVER VIGILANT ARGISS ENBOSS Training Manual A Where Criteria E Connector Variable Field Operator Value View Window ox cancer 9 Click OK to go back to the Query dialog 10 Torun the query click the Run icon or select the Execute menu and select Run This will process the query for all the selected columns from COMPLEX for the state of Nebraska View Edit Window Once the query is through processing a View Edit dialog will appear These are the results of your query We are going to save these query results for later use in your report and presentation to the Congressman Notice that the total number of rows for the query is displayed at the bottom of the dialog A View Edit Untitled Result Data FAC CITY NORTH PLATTE COE DIST OMAHA OMAHA COLUMBUS NE OMAHA FREMONT NE OMAHA HASTINGS NE OMAHA KEARNEY NE OMAHA LINCOLN NE OMAHA MCCOOK NE OMAHA MEAD NE OMAHA NORFOLK NE OMAHA NORTH PLATTE NE OMAHA NORTH PLATTE NE OMAHA OMAHA NE OMAHA OMAHA NE OMAHA why MORE NE OMAHA LINCOLN NE OMAHA OMAHA NE
124. le lists the file naming conventions that MapInfo uses in StreetWorks using King County Washington as an example Table Ill 4 StreetInfo Table Naming Conventions SS CCCC D SS CCCC H SS CCCC CB SS CCCC MC SS CCCC LM SS CCCC WB SS CCCC WR SS CCCC PC SS CCCC PN One of the more common uses of StreetWorks at the RSCs 1s to better locate facilities The georeference table is the master table by which all ARGISS records are geocoded This file was originally created by placing facilities in the centroid of the zip code boundary in which they reside Although this provides a relatively accurate location of the facilities they can be several hundred meters off If an exact location is known for a facility opening the StreetWorks street files on top of the georeference table allows the user to pinpoint the location of that faclility To update the locations of the georefernce table facilities Ly Insert the StreetWorks CD with the appropriate state on it CACI EVER VIGILANT e MapInfo Professional Hartford_CT EII Top ES File Edit Tools Objects Query Table Options Map Window Help ES Open the Streets Table SS ARGISS Training Manual CCCC D for the county in which the facilities reside If the county is not known a county map can be opened from the T ENBOSS ARGISS BASEMAPS directory Open the master georeference table
125. lete _ Close IV 5 CACI EVER VIGILANT ARGISS ENBOS Training Manual J Click New on the File Maintenance dialog 4 The Site Files dialog displays Select the facility that has a site plan to be registered in PlanView dl Site Files Facilities Al 014 hd Add Cancel 5 Click Add The added facility will now display in the File Maintenance window 6 Type in the correct File Name for the digitized site plan The standard site plan file names are 6 characters in length Example Fac_1d S ARO10S I Once all the site plans have been entered into File Maintenance click Close and save the changes IV 6 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Deleting Site Plans To delete a site plan l Select the facility site plan from the File Maintenance window to be deleted from Plan View 2 Click the Delete button 3 The Delete Alert window will display Click Yes to delete the site plan Registering a Floor Plan Once a floor plan is in Map nfo format it needs to be registered in the Plan View system before it can be viewed A floor plan cannot be registered in Plan View unless its corresponding site plan has already been registered To register a floor plan l Select View gt File Maintenance from the Plan View menu bar or press the File Maintenance button en The File Maintenance dialog displays 2 Select the Floor radio button under Plan Type A list of all the floor plans
126. lick Close GN O A Insert New Field Key Field EA A B ODBC Profile sa_emaar Database cienbossuatasetienboss 96 db Database Type Adaptive Server Anywhere Table Field Names Close the Table Maintenance window Create the MCAR Query Select the Query menu and then New or press the New toolbar button Select Fac_id as the Key Field Click Yes when asked if you want to set up the relationship between the tables Select the relationship and click OK Select the following columns from the Columns list box entgn_cost fac_city fac state fac_street fac title fac zip proj_no proj title proj fy proj cost proj type proj loc Click Add to add all of the selected columns to the Selected Columns window Ta Using the order up and down buttons position the fields in the order you want them ao SS C 77 CACI EVER VIGILANT ARGISS Training Manual Filter the MCAR Query for Iowa Nebraska Missouri and Kansas l Select the Where Clause button to filter only Iowa Nebraska Missouri and Kansas MCAR projects 2 Select fac_state from the Variable Field drop down box 3 Select or type the sign in the Operator box Notice the other types of operators in the drop down box 4 Enter NE for the state of Nebraska in the Value box Remember the Value box is case sensitive 5 Click Add to add the where clause to the View Window Where Criteria Connector Wartable Field O
127. log displays 1 17 CACI EVER VIGILANT Print Warning ARGISS ENBOSS Training Manual The query results may be too wide to fit on one page Before printing please review the width of the results Launching Excel will allow you to format the data for printing Cancel l Don t show this message again To prevent the Print Warning message box from displaying the next time a query 1s printed check the Don t show this message again checkbox Click the Print button A data dump of the query results in the View Edit Result Data dialog is produced Loading a Copy of the Data into Microsoft Excel To load a copy of query results into MS Excel l Il 18 Click the Launch Excel button located on the View Edit Result Data dialog A View Edit Untitled Result Data FAC ID MEOO NEOUS NEOUS NEQUE MEOO NEOUS NEOTO MEO11 MEO MEO HEO14 MEOTS MEO13 NEO2S MEO24 MEO25 HEOZb MEO2 COE DIST OMAHS OMAHA OMAHS OMAHA OMAHA OMAHS OMAHS OMAHS OMAHS OMAHA OMAHA OMAHS OMAHA OMAHS OMAHS OMAHA OMAHA FAC TITLE COLUMBUS USARC FREMONT USAAC HASTINGS US4SAC KEARNEY US4RE LINCOLN USARC MCCOOK USARE MEADE WET SITE NORFOLK USARC NORTH PLATTE US4RE H PLATTE AMSA 21w O0LWORTH OMAHA USAR BOORER OMAHA USARC WITMORE USARC Lincoln USARC OMS Omaha USARC OMS AMSA LINCOLN OMS amp MEP BASOPS RISER OVERHEAD PROPOSED MCCOOK LTA Total rows in query 20 Print Orien
128. lts of the search criteria in MapInfo Ad Hoc Reports develops or generates customized reports in InfoMaker based on the criteria selected Canned Reports generates pre existing reports in InfoMaker based on the criteria selected Cancel returns to the Select Search Criteria screen rn4 6 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Search By Facility Identification Code Enter a Facility Identification Code in the Facility Identification Code box Enter a buffer radius in the Radius box Select Miles or Kilometers from the drop down box to select the search radius units Click Map to create a map A map of the search criteria will be automatically created eo ie Search By Information Facility Identification Code TT Map Report Map Radius 4d Hoc Reports miles Canned Reports Cancel Help FPS Main Window The FPS MapInfo Professional window provides the user all of MapInfo s functionality as well as additional FPS specific features used in mapping the search criteria The FPS Main window contains four windows Facilities Map A map of the search criteria Facilities List A Browser window containing the results of the search criteria Facility Info An info tool display window Map Legend A FPS map legend gt MI 7 CACI EVER VIGILANT ARGISS ENBOSS Training Manual FPS File Edit Tools Objects Query Table Options Browse Window
129. m Range lA mi Mar mman mii F Show Line Direction T Show Nodes T Show Centroids Cancel Help 4 Using the Fill and Border drop down lists change the color fill pattern border color border style and border width Ifa layer contains points lines or text the appropriate button will appear in the display options dialog and functions the same way as the region style dialog Region Style Ed Fill Foregrounc a Beehkoround Style Color Width Pixels C Ponts po Sample Cancel Help 5 Click OK CACI EVER VIGILANT ARGISS Training Manual Editing and Selecting To make changes to the graphic objects in a layer you must make the layer editable You can draw objects on that layer add text combine layers or delete objects Only one layer per Map window can be editable at one time To edit a layer check the Editable E check box next to la the layer you wish to edit To make a layer selectable check the Selectable check box next to the layer you wish to make selectable A layer is automatically selectable when the Editable check box is checked Cosmetic Layer Every map window in MapInfo has a Cosmetic Layer Think of the Cosmetic Layer as the blank transparency that lies on top of all of the other layers It stores map titles and other graphic objects you create during a work session The Cosmetic Layer cannot be removed or reordered and it can only be editable
130. m the Main Toolbar Ze Press the Del key on the keyboard or select Edit gt Clear Saving Labels Labels can be saved as a workspace The workspace saves the desktop configuration map graph and browse window layout and labels l Select File gt Save Workspace 2 Type a file name 3 Click Save Creating titles for the workspace Before text can be added to a map window the layer must be editable The editable layer accepts new map objects when drawn on the map You can also modify delete reshape or change the style of objects on a map The Cosmetic Layer is placed in every map window It also cannot be removed or reordered from the top layer You can use this layer as a transparency to create objects or place text you cannot create through labeling such as titles l Click the Layer Control F button Ze Highlight the Cosmetic Layer 3 Check the box underneath the pencil CACI EVER VIGILANT ARGISS Training Manual Layer Control Laver 2E i Cosmetic Layer Erer MEME Meee Cancel KEME M BM O relay Label Thematic Hat FLLEL eh f Layers Reorder Add Hemose Up Pawn Help 4 Press OK You can now add delete and modify the contents of the cosmetic layer The status bar at the bottom of the screen indicates which layer is editable Zoom 4 000 imi z Editing Cosmetic Layer Select the Text Al button on the Drawing Toolbar then click in the map where you wish to enter text P
131. n entered into the Primary Key table fields from any other table that have a primary key with the same name can be entered into the Data Bridge table This is known as an implicit relationship l Click New Relationship The Insert New Field dialog will appear Ze Select a Key Field from the Key Field drop down box 11 23 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Insert New Field ODBC Profile sa_emaar e Database Unknown Database Type Adaptive Server Anywhere y Table complex e acres act acres auth Field Hames acres au acres rg Insert atre host service au amsa au_avinhgr Close l Select an ODBC profile from the ODBC Profile drop down box Select a table that contains the chosen primary key from the Table drop down box The Field Names list box will populate with fields from the selected table Select the fields to insert into the Data Bridge table Click on Insert The selected columns will populate in the Data Bridge table NAAA Creating an Explicit Relationship When joining two tables on fields that contain the same data but have different names an explicit relationship must be created This is done through the relationship table To add a new relationship to the Relationship Table l Be sure that the primary keys that you want to create the relationship between are in the Primary Key table 2 Local Table Maintenance ES Reference Table Data Bridge T
132. n the Data Bridge Table I 10 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Deleting a Field from the Data Bridge Table ENSURE YOU ARE ON THE LOCAL DATA SOURCE BEFORE ADDING OR DELETING KEYS FIELDS TABLES To delete a field from the Data Bridge Table l Highlight the record to delete and click the Delete button The Delete Confirmation message dialog displays as shown on the next page Delete Confirmation 2 Are you sure you want to delete the highlighted record 2 Click Yes to delete the record or No to return to the Table Maintenance dialog Editing a Field Description To edit a field description l Click on the desired Field Description field in the Data Bridge Table 2 Type in a new unique description 2 Local Table Maintenance Reference Table Primary Key Table Data Bridge Table Relationship Table Field Hame Field Description J Database Profile fac id ic 7 sa_emaar y afrc_host service afrc_host service fac_id comple gt complex sa_emaar coe_dist coe_dist fac_id comple complex sa_emaar deleted in_its deleted in_its fac_id comple complex Sa emaar exces disp fac_id comple gt complex sa_emaar fac_city fac_id comple gt complex sa_emaar fac_id fac_id comple gt complex sa_emaar 3 To save changes click the Close button The Save Confirmation message dialog displays 1 11 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Save Confirmation 7 Do pou want t
133. ndary Mame Column none Cancel Options Help Select NECOMPLX as the table to geocode from the Geocode Table drop box Select Fac id as the column to use under the using Columns drop down box Select the Georef table as the table to search in the Search Table drop down box Select Fac_id as column to geocode with in the for Objects in Columns drop down box To change the symbol color and size click the Symbol button Click OK Click OK on the MapInfo window displaying how many records were geocoded A AI Mapinto Geocoding of table necomplex completed 13 geocoded B not geocoded O previously geocoded CACI EVER VIGILANT ARGISS Training Manual 10 From the Query menu perform and SOL Select to examine the records that are not objects since they were not geocoded SQL Select Select Columns Tables Columns Operators from Tables necompl P where Condition fnot obi Aggregates Funchons Group by Columns Order by Columns Save Template Into Table Named Selection Load Template M Browse Results Cancel Llear Verity Help 11 Browse the results and see if any of the facilities are proposed or were closed Add the Database to the Map Window Click on the map window to make it active and click the Layer Control button l ze Under Layers click the Add button 3 Select NECOMPLX from the list of tables Click OK 4 Click OK from th
134. nit Address ASGN Numeric 6 0 Number of soldier assigned to the unit AUTH Numeric 60 Number of soldiers authorized for the unit CLOSE Character Indicates if unit is closing Y or N DUTYQUAL Numeric 60 Number of qualified soldiers in the unit EFF DATE GAINS FAC ID Character Facility Identification Code affiliated with unit LOSSES MUSARC NAME PHONE 0 Number of soldiers gained in the last year Numeric 60 Number of soldiers lost in the last year Character MUSARC Code 12 STATE Numeric 60 Number of required soldiers for the unit Standard Requirements Code VACS Numeric EX Number of vacancies in the unit CACI EVER VIGILANT ARGISS Training Manual EMM ECATS Columns Used by ARGISS these files are not been maintained by This section lists the EMM ECATS tables and columns used by ARGISS These columns are used in the Create Application Data processes to generate the Reports for FPS Any structure changes to them will also cause structure changes in the reports the MapBasic code and the PowerBuilder code A106 A106 Information Column Type Length Description ASSESS Character l Project Assessment BCODE fy where Character 10 Agency Budget Code fy is 2 digit fiscal year ex BCODE 96 i CONTACT Character 3 DPCMPLT Character 6 Pan Compleed ooo ENTERED Character 8 DateEnteed ooo FINAL Character 6 Final Compliance Regard Er NAME C
135. nnccnnoccnoccnnncnnncnnnccnnacnnos C 40 PRINTING A WIND dd tater ah epi Di a DO o local bio C 41 TO PRINT A MAP GRAPH BROWSER OR LAYOUT WINDOW occcnncccnnoccnnnccnnnccnnnoccnnnccnnnccnnnrcnonoccnnarcnanicnns C 41 AECA E tet ett eat Ma Seed pecan A EE TA Mak acd tacts ashes tant hs tah ard tascam lashed C 42 REDIRECT THE OUTPUT SOURCE TO THE PLOTTER BY A it C 42 MAPINFO ON LNE HELP r oa C 43 SA O A O A C 43 PRACTICALEXERCESE cutter C 44 ADVANCED MAPINFO FEATURES siicecesicscescesedsonssinsdevseseedeusessevancesecnncebascassesaterveseasevadsedcsesebuvaesee gt C 61 CREATING NEW BASE MAP S au ida C 65 GrROCODING DATA os o code abs io end ds o ode o e de e E C 65 PRACTICAR EXERCISES ra tada ey id a aran dde aho da ets OE ca o Ud a EEA AT c 72 CACI ne EVER VIGILANT ARGISS ENBOSS Training Manual Section I Course Introduction and Outline CACI ne EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank CACI EVER VIGILANT ARGISS ENBOSS Training Manual ARGISS Background The Army Reserve Geographic Information Support System ARGISS is a very important component under the Engineer Base Operating Support System ENBOSS umbrella ARGISS originated out of the Army Reserve need to consolidate facility related data from various sources The Army Reserve wanted to spatially display the data and report on the data ARGISS in a geographic information system GIS that provides authorized users wi
136. nned Reports Canned reports are pre formatted reports that contain specific facility related information for selected search criteria To open the FPS Reports window l Click Info from the menu bar Select Canned Reports or press F9 3 The FPS Reports dialog within InfoMaker is displayed with the FPS Reports shown as buttons along the toolbar FPS Reports MEE File Objects Window Help 8 888888268 828 Reports ATRA CER FER FP LER MER OZRA R E R F Exit The Canned Reports can be opened by Using the File menu Using the Objects menu Clicking the individual Canned Report icon Clicking on the Reports icon gt To view a Canned Report through the File menu l Click File from the menu bar Ze Select Open Report 2 Select the report you want to view from the Select Report dialog 4 Click OK To view a Canned Report through the Objects menu l Click on the Objects menu from the menu bar Ze Click on the report you want to view To view a Canned Report through the Report Icon E l Click the Reports button P from the Painter Bar Ze Select the report you want to view from the Select Report dialog 3 Click OK or double click on the report title 11 13 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Report Icon Report Name Account Summary Report Cost Summary Report Facility Summary Report Future Year Plan Lease Report Maintenance Backlog by Tier Report
137. ns a wide range of flood plain and floodway maps and data The data is extremely useful in determining if facilities or construction projects are located in a flood plain or flood way Environmental Protection Agency EPA URL http www epa gov The EPA site contains multiple layers of GIS data ranging from air quality to endangered species However the data is sporadic on a state by state basis United States Census Bureau URL http www census gov This site contains invaluable demographic data derived from the latest census Detailed demographic data such as age income and race can be accessed by an area as small as the block level The data is very useful for master planning 1 e trend analysis traffic impacts etc and recruiting analysis United States Fish and Wildlife Services FWS A 5 CACI EVER VIGILANT ARGISS ENBOSS Training Manual URL http www fws gov The FWS site contains natural resource data related to the biological and forestry professions The Soil Conservation Series soils maps can also be located at this site The above list of agencies is a small number of the major available federal agencies that offer GIS data and products These sites usually have pointers to other more detailed GIS sites 1 e USGS Earthquake GIS data web site State and Local Governments and Universities Many local and state agencies and universities offer GIS data related to the functional area that the agenc
138. nt and print the map Save the Windows as a Workspace l Select File from the menu bar Select Save Workspace 3 Save the workspace as NEFACS WOR to the C Program Files ENBOSS ARGISS FPS DATA directory 4 Click OK Query NECOMPLX Using SQL Select Y ou will now use the SOL Select function to query the NECOMPLX table for all facilities located in the city of Omaha l Select Query from the menu bar Ze Select SOL Select from the menu items SQL Select Select Columns Tables Columns from Tables necomple Uperators Fac city OMAHA T Aggregates Funchons where Conditions Group by Columns Order by Columns Save Template Into Table Named Selection Load Template M Browse Results Cancel Llear Verity Help 3 In the from Tables text box enter NECOMPLX or select 1t from the Tables drop down box 4 In the where Condition field enter Fac_city OMAHA 5 Click Verify 6 If expression is valid click OK If not re enter the expression All of the facilities located in the city of Omaha will appear in a Browser window and will be selected on the map CACI EVER VIGILANT ARGISS Training Manual Save the Query as a Permanent Table To save the query as a permanent table l Select File from the menu bar 2 Select Save Copy As from the menu items 3 Highlight the correct query number and click Save As 4 Save the query as OMAHA TAB
139. nvironment ARGISS 8 1 was released in April 2002 and provided users with immediate verification of LAN versus Local data sources when using Data Bridge The data source 1s indicated in the bottom right corner of most Data Bridge screens ARGISS 8 1 also modified the ARGISS FYP Report Cost Summary Report and Stationing Reports Current and Projected ARGISS for MetaFrame was released in conjunction with ENBOSS 4 0 Suite of Applications in March 2004 It is all web based and available on any computer running Windows with the properly configured Citrix Client and DoD Certificates ARGISS for MetaFrame has retained its functionality while allowing the applications to be updated on the MetaFrame Servers rather than on each user s desktop computer e There are many references to the T drive in this manual This refers to the Remote MetaFrame servers used for ACSIM AR IMA AR and all RRC headquarters This T drive is the location where the ARGISS basemaps and datasets are stored The Remote MetaFrame T drive is not to be confused with your local T drive on your LAN The Remote T drive is only available when you are signed into ENBOSS 4 0 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Course Layout and Objectives The major objectives of this course and guide are to give the student a basic understanding of the ARGISS Facility Planning System FPS and Data Bridge modules At the completion of the course the stud
140. o primary keys in the Primary Key Table that contain the same data but have different names e g Fac_id and Facid Local Table Maintenance Reference Table Data Bridge Table Relationship Table Key Field Hame Table Hame fac_id Complex facid force_Tile a O LAN Table Maintenance Reference Table Primary Key Table Data Bridge Table Relationship Table security Reference Table Field Hame Field Description Table Name Database Profile o ld racctgdiracctgat wo ld racctycracctyct sa_riser wo_id racctacracctyct sa_riser commit_armt wo id racctyct racctyct Sa riser commit _cit wo_id Cracctacracctyct sa_rliser commit_ctr wo id racctyctracctyct Sa riser ctret_num wo ld racctycracctyct sa_riser To add a new relationship to the Relationship Table l Select Relationship Table from the Reference Table list box 1 26 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Ze Click the New Relationship button The New Relationship Warning message appears as displayed below New Relationship Warning AN Relationships must include at least two key fields that contain the same information Cancel 3 Click the OK The Choose Key Field Name dialog appears This dialog contains the key fields registered in the Primary Key table A Choose Key Field Name Key Field Hame Table Hame Database Profile sa_emaar force_file sa_emaar 4 Highlight a key field and click the 4dd b
141. o save changes to the Data Bridge Table Ho Cancel 4 Click the Yes button to save the changes No to discard the changes or Cancel to return to the Table Maintenance dialog Working with Queries There are many options for working with queries Queries can be created opened edited closed deleted saved saved with a different name designated as Public Private or Read only and run to retrieve the results from the database s The SQL generated by the query can also be viewed When building a query a primary key must be chosen All of the fields in the Data Bridge table that were entered under that primary key will be available to query If that primary key is in a relationship all of the fields in the Data Bridge table that are related to that primary key will also be available to query Creating a New Query To create a new query l Select the New option from the Query menu as displayed below or click on the pul Pew toolbar button per Else Pelete Data Bridge Wizard The Untitled query dialog as displayed below allows the user to create a new query On this dialog the user can select a key field and data fields to create the new query An additional checkbox is available on this dialog that will toggle suppressing duplicate information When checked this option will only show one unique value if multiple records are returned that match the query being built 1 12 CACI EV
142. olbars can be found by clicking on the toolbar button or by choosing MapInfo Help Topics from the Help menu option To Launch Maplnfo l Select MapInfo Professional 5 5 from the MapInfo program group a Maplnto Maplnfo Professional 5 5 To open a table l Choose Open a Table in the Quick Start dialog Q uick Start pA Click Open The Open Table dialog displays C 7 CACI EVER VIGILANT ARGISS Training Manual Open Table 7 Look ir 3 Basemaps l cd U6 tab T Dcean tab T Aecbhridry tab T Usrppp tat a Cities TAB Fi Region NE TAB F Stateshr tab E Usrppt tab TA Miltbase tab Fi Region Nw TAB F Us tab E Usrrdl tab FE NE Region TAB Region SE TAB F Uscongetab P zip TAB FE NE Region TAB F RegionSw TAB 2 Ushwy tab EE HE Region TAB EE Rsc tab EE Usrppa tab Files of type Mapinfo tab Cancel Help Preferred View Automatic 3 Navigate to T ENBOSS ARGISS BASEMAPS 4 Highlight STATESHR and click Open or double click on the file name You will see a window display with a map of the United States This is a Map Window where the user can manipulate maps and their associated graphics C 8 CACI EVER VIGILANT MapInfo Professional File Edt Tools Objects Query Table Options Map Window Help oem el Hal ol aaam E4 amp Stateshr Map ARGISS Training Manual A Es gt O D C E aloje Y B 2 KAR The Dr
143. omplex sa _emaar atrc_host_service afrc_host_ service fac_id comple complex sa_emaar coe_dist coe_dist fac_id comple complex sa_emaar deleted_im_if deleted in_its fac_id comple complex sa_emaar exces_ disp exces disp fac_id comple complex sa_emaar fac_city fac_city fac_id Ccomple gt complex sa_emaar fac_id fac_id fac_id comple complex sa_emaar To build a new relationship l Select Relationship Table from the Reference Table list box At this point you can add fields from different tables to the existing relationship or create a new one 2 Click the New Relationship button and click OK on the warning message dialog a Highlight the first key field that you wish to relate and click Add Choose Key Field Name Key Field Hame Table Hame Database Profile arc_cd rengrt a rhudgetxt Sa riser complex sa_emaar im_t1 sa_emaar in_t1Da sa_emaar in_t12a sa_emaar complex sa_emaar in_t10a sa_emaar 4 Add any other keys you wish to be in the relationship and close the Choose Key Field Name dialog There should now be two relationships in the Relationship Table as shown below Il 31 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 5 Select Close in the LAN Table Maintenance dialog Primary Key Table Data Bridge Table Relationship Table Local Table Maintenance Ooo 1 taoid comple semper O o pt faid fore fle A paid comple A Oo 23 force tle A 3 facidstr interest semper Oo 3 O A A O 6 B
144. on on the Main toolbar CACI EVER VIGILANT ARGISS Training Manual Selecting Using Queries A query is another word for a question MapInfo allows you to query databases using Select or SOL Select from the Query menu option Select allows you to select records and objects from a table according to specific attributes You can use it to highlight objects in a map or Browser window that meet certain criteria For example you can ask MapInfo to Show all TDA units Show only facilities greater than 25000 square feet Show only facilities located in a particular state Show counties ideal for recruiting gt gt To perform a Select query you must create an expression An expression is a logical statement that is used to ask your question For example the expression GR TNG SF gt 25000 would produce a selection table with facilities greater than 25000 square feet To query data using Select l Choose Select from the Query menu Select Select Records from Table ea that Satishy Sa Assist Store Results in Table Selection Sort Results by Colum none M Browse Results Lancel Save Template Load Template Help 2 Select the table to query from the Select Records from Table drop down box 3 Type the expression in the that Satisfy box or click the Assist button for help creating the expression The drop down boxes on the right will assist you in creating a query CACI EVER VIGILANT
145. oor Plan Facility ID Select Building ManUSARC Ready Z 5 Click the Select button The Floor Files window displays IV 15 CACI EVER VIGILANT ARGISS ENBOS Training Manual Floor Files Building sarc File Hame C4095C01F CA0SSCoF CAOQISC SF 6 Highlight the floor to be displayed k Click Display The floor plan for the NE003 main USAR Center will be displayed You should now have the site and floor plan as map windows Create a Thematic Map l Select the Map menu from the MapInfo menu bar Ze Select Create Thematic Map Create Thematic Map Step 1 of 3 Type Template Sotby Name Sorby Time Previews Template Mame Z lt o PY Region Ind alue Black and white PY Line IndValue Black and White A Point Indalue Black and White Pg Region Indwalue Default Pg Paint Ind alue Default Title Subtitle Category 1 Category 2 Category 3 Category 4 Category 5 Category 6 Category 7 Category 5 Category 9 Category 10 Category 11 Category 12 Category 13 Category 14 Category 15 Category 16 ARE MM MIO WILE Ee ee M Wee Eustomized Legend Test caca Hee 3 Click the Individual button and select Region IndValue Default 4 Click Next IV 16 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 5 Select NEOO3CIF as the table 6 Select RoomName as the field to create a thematic map with Create Thematic Map Step 2 o
146. or caca up J To change the position or the anchor point of the label click the desired anchor point from the Position options 6 Click OK Adding and Creating Custom Symbols You can use your own custom bitmaps as symbols in MapInfo Once they are saved to the correct location they will populate in the Font list as Custom Symbols In order for your symbols to appear in the Font list you have to save them as bitmap files to the T MAPINFO CUSTSYMB directory The next time you launch Map nfo your symbols will appear in the Font list for Custom Symbols Keep in mind the following limitations when creating your own bitmap file e Bitmap should be under 64K if using 16 bit version of MapInfo e Bitmap should be under 128K if using 32 bit version of MapInfo e 256 colors are supported The smaller bitmaps will look better at smaller font sizes because they do not need to be compressed The larger bitmaps will look better at larger font sizes because they have more pixels and more detail Displaying Raster Images A raster image is a computerized picture that contains rows and rows of tiny dots or pixels A raster image cannot have any data attached it On the other hand a vector image contains X and Y coordinates The maps that display in FPS are all vector images and have data attached directly to the image The following is a list of raster images that MapInfo will open directly BIL SPOT satellite images BMP Windows Bitmap
147. or plans to be displayed in Plan View Location of Site Plans directory path of the site plans to be displayed in Plan View Directory Information Location of Floor Plans T ENBOSS ARGISS PLANVIEWSPLANS 4FLOORS Location of Site Plans T ENBOSS ARGISS4PLANVIEWSPLANSASITES The location of these fields can be changed by clicking in the field you want to change and entering a new path IV 4 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Displaying the MapInfo Window If the MapInfo window minimizes or disappears while PlanView is running l Select the View menu option from the Plan View menu bar and select Map Window or press F6 This will display the MapInfo window Displaying the PlanView Window If the Plan View window minimizes or disappears while Plan View is running l Select the Options menu option from the MapInfo menu bar 2 Select Plan View Window 3 Or press the F6 key This will display the Plan View window Registering a Site Plan Once a site plan is in Map nfo format it needs to be registered in the Plan View system before it can be displayed To register a site plan 1 Select View gt File Maintenance from the Plan View menu bar or click the File Maintenance button en 2 The File Maintenance dialog displays with a list of all the site plans that have already been registered File Maintenance Plan Type i Site Floor FAC ID File Name Hew _ De
148. ow ueoozc F Map Frames for All Currently Open Windows C No Frames OK Lancel Help 3 Click OK A layout window is displayed 4 Arrange and resize the windows in the layout 5 Select File gt Print to print the layout IV 19 CACI EVER VIGILANT ARGISS ENBOS Training Manual NEOO3 SITE PLAN AND CENTER FLOOR PLAN 1822752 Tau 113 ji EEEE EEEEE TEE EEEE 6 Save the windows to a workspace by selecting File gt Save Workspace Save the workspace as NE003 WOR to the C Program Files ENBOSS ARGISS FPS DATA directory A Select File gt Close All Register a Site Plan You will now register a site and floor plan into Plan View Use the table below to determine the site and floor plan assigned to you Student FAC ID Site Plan Name Floor Plan Name NE001S NE005S NE0068 NE007S NE008S NE009S NE010S NE011S IV 20 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Register the site and floor plan that is assigned to you l Select Options gt Plan View Window from the menu bar Ze Select View gt File Maintenance from the menu bar or select the File Maintenance button en 3 The File Maintenance window displays with a list of all the site plans that have already been registered File Maintenance Plan Type i Site Floor FAC ID File Name 4 Click the New button on the File Maintenance window 5 The Site Files window displays Highlight the facilit
149. p dialog appears Highlight one of the fields in the relationship you wish to set and click OK Choose a Relationship E4 Relationship Key Field Hame Table Hame Database Profile fac_id complex sa_emaar force file sa_emaar 2 fac_id complex za_emaar force_ file sa_emaar 5 All of the fields from the tables that are in the relationship that you chose are now available to query Select those that you wish to query and order them so that the columns in the result will be displayed logically 1 28 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Untitled acres rq afrc_ host service 6 Build a Where Clause Where Criteria E E Aa as Run the query and save the results 11 29 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 2 Save Query and Data Iv Query Creator Access ARGISS TRAINING SROAMS private NEBRASKA FACIDs Private other users cannot read or modify M fps reports 11 30 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Creating Multiple Relationships It is possible to have a key field in more than one relationship Before building such a relationship make sure all of the necessary fields are registered in the Primary Key and Data Bridge tables 2 Local Table Maintenance E Reference Table Primary Key Table Data Bridge Table Relationship Table Field Hame Field Description Table Hame Database Profile acres rq acid complesc
150. perator Value View Window Select OR for the Connector drop down box Select fac_state from the Variable Field drop down box Select the sign from the Operator drop down box Type in JA in the Value box Click the Add button to add the filter to the View Window Click OK AA CACI EVER VIGILANT ARGISS Training Manual A Where Criteria Connector Wartable Field Operator Value View Window 12 Repeat the steps above to add Missouri and Kansas to the filter 13 Click OK on the Where Criteria window Run the MCAR Query l Click the Run toolbar button or select the Execute menu then Run Save the Results of the MCAR Query as a DBF Table Click Save to save the results of the query Check the Save Query Information check box Enter a query name in the Name text box Enter a description in the Description text box Select Read Only as the Access Level Check the Save Data Information check box Since we are going to save the results of your query as a DBF table to C ENBOSS ARGISS DATA you do not need to use a profile Select none as the ODBC Profile 8 Click Save ie oe oe a CACI EVER VIGILANT ARGISS Training Manual amp Save Query and Data F Save Query Information Query Hame WORK ORDER Description WO Existing Queries Creator Access 5YEAR PLAN HARDYD public SETHOG HARD YD private EMARGEN HA4RDYD read only OGRANT HA4RDYD private QUTGRANT HA24RDYD pri
151. r Mapping Ad Hoc Reports To map an ad hoc report I 18 CACI EVER VIGILANT ARGISS ENBOSS Training Manual l Create and save an Ad Hoc Report as described above 2 Follow the same instructions for mapping Canned Reports but use the dbf file that was saved from the Ad Hoc report to create your map Group AutoLabeling The Group Autolabel function realigns multiple labels that exist at a single point on the map For example there are usually multiple units assigned to a facility To use the Group Autolabel function In FPS search by Fac_id For this example we will map GA009 When the map of GA009 opens maximize it so it fills the screen and close the legend l 2 3 Click the Layer Control button in the toolbar 4 Highlight the Sidpers layer and check the AutoLabel check box This will produce multiple unit labels for one facility Layer Control Ea Label Layer ae fa TS g VOM Oo OK M O MO Modo Lancel DEDO MEME Display M BOO O MM O M E O C El hematite Help FLEA EE Layers Reorder Add Remove U Down oF Click the Label button 6 Label the layer with Uic check the Allow Overlapping Text check box make the Text Style Effects bold and click OK 7 Click OK again to display the map with overlapping Uic labels i I 19 CACI EVER VIGILANT ARGISS ENBOSS Training Manual 8 Click on the Map menu from the menu bar 9 Select Group Autolabels
152. r 13 Fac_city Click Verify If the expression is valid click OK If not re enter the expression Click OK from the Label Options window Click OK from the Layer Control window The map is now labeled with Fac id facility title and the city that the facility is located in 10 Maximize the map window zoom out and click and drag on the labels to spread them out oe ee Mapinto Professional necomplx Rscbndry Usrppa Ocean Map Fe File Edt Tools Objects Query Table Options Map Window Help x Ojea el A EA wlollolelololajo 2 gt A a aaa 1149 vic el 28 ale Zoom 1 110 mi Editing Mone Selecting Nome Add a Title to NECOMPLX C 54 CACI EVER VIGILANT ARGISS Training Manual l Click the Layer Control button 2 Make the Cosmetic Layer editable by checking the Editable check box 3 Click OK Layer Control El Laver 2E i s Cosmetic Layer E lA E P OK KEME wpe Cancel KEME MaM Diepe KEME ME Reorder Up Dian 7 4 Select the Text Style button from the Drawing toolbar and choose a font size and color Click OK Click the Text button from the Drawing toolbar Position the pointer where you want to place the title and click the left mouse button E Type a title Dn Print NECOMPLX l Select File gt Page Setup and change the Orientation to Landscape CACI EVER VIGILANT ARGISS Training Manual 2 Select File gt Pri
153. racter 5 Facility Condition This Red Amber and Green Status comes from ISR ISR tracks everything by 5 Building Number FAC ID Character 5 Facility Identification CACI EVER VIGILANT ARGISS Training Manual Column Type Length Description PERM SOL Character 20 Permanent Solution for a lease a new facility will be built by Army Reserve noting it is only needed temporarily etc Not Used B 17 CACI EVER VIGILANT This page intentionally left blank ARGISS Training Manual EVER VIGILANT ARGISS Training Manual Appendix C Basic Mapinfo Features C 1 CACI EVER VIGILANT C 2 This page intentionally left blank ARGISS Training Manual CACI EVER VIGILANT ARGISS Training Manual Objective MapInfo Professional is a commercial desktop geographic information system GIS package The following section will familiarize the student with basic MapInfo Professional capabilities and functions Please refer to the MapInfo Users Manual for more detailed and sophisticated functions The tools and skills learned here will be used later in the Facility Planning System section The following is a list of skills and functions the student will gain through this section MapInfo Terminology Opening and Closing tables Understanding Map nfo Tool Palettes Understanding Map Windows and Layer Control Map Labeling and Auto Labeling Understanding Browser Windows Geocoding Data
154. raphics with the 89th RRC Engineer symbol The following items at a minimum will be produced e Strip map containing directions on how to get to NE003 e Map of the 89th RRC without any other states with all the MCAR projects labeled with Name and City e Report with all of the facilities in Nebraska and the ARNG units that train in those facilities You already maintain this Excel spreadsheet with all of the ARNG units and their strengths Report application containing the above report can be run by anyone in the RRC EVER VIGILANT ARGISS ENBOSS Training Manual Section IT Data Management in the Data Bridge CACI EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank CACI EVER VIGILANT ARGISS ENBOSS Training Manual Objectives This section provides a detailed description of Data Bridge functionality The Data Bridge allows the user to consolidate database information from Sybase SQL Anywhere FoxPro MS Excel and MS Access databases create queries on that data and retrieve the data from the specified database or databases In addition Data Bridge creates and geocodes data for the planning system FPS that utilize ARGISS Data Bridge contains three functional areas Working with Queries Performing Administrative Functions Accessing Help and Other Windows Functionality Data Bridge Overview The Data Bridge s three main functional areas include working with que
155. red Starting a New Query 1 Click the Yes button to begin constructing the new query The Untitled query window appears Select Key Field RUE A A Suppress duplicate rows M Field Descriptions Selected Field Descriptions Order Al y Where Clause 2 Select WO_ID from the Select Key Field drop down list 3 The proper fields will show up in the Field Descriptions list box Click the Add All button to move them into the Selected Field Descriptions list box 4 Click the Where Clause button ITE 62 CACI EVER VIGILANT id Where Criteria Connector Variable Field Operator Value fann fac_ia1 E View Window roinfodt req cd ARF AND rpintodt fac_id NE AND rpintodt ftac_id MF 0 me Select fac idI in the Variable Field dropdown menu lt gt from the Operator dropdown menu and NE in the Value box then Add Select fac idl in the Variable Field dropdown menu lt from the Operator dropdown menu and NF in the Value box then Add When done press OK Now run the query by pressing the Run icon The View Edit dialog appears with the results of your query View Edit Untitled Result Data RACCTGDT RACCTGDT RACCTGDT RESTDT pla wO ID COMMIT AMT COMMIT DT CWE FA MAGODS227J 96837 00 RNE M46005227J 96837 00 ON NEI AO ONES NEI Nooo NE NEI NEI NO NE NEI NEI NEI Noroez PN NEI NEI NEI MOTODOT27J So BNE En Total rows in query 802
156. ress the Select k button to exit the text mode Saving the Cosmetic Layer Objects from a cosmetic layer can be saved into a new permanent layer to be used with different maps or by saving a workspace To save the cosmetic layer as a new table l Open Map gt Save Cosmetic Objects Ze Type in a file name in the Save Objects Table dialog 3 Click Save The Save Cosmetic Objects dialog displays CACI EVER VIGILANT ARGISS E Training Manual Browser Windows Use Browser windows to view and manipulate your data records in a traditional row and column form typically used in spreadsheets and databases For example Data Bridge queries can be opened manipulated geocoded and printed within MapInfo Each column contains information about that particular field Each row contains information relating to a single record Y ou can edit records in your table copy records add new ones or delete existing records To open a Browser for an active Map window choose Window gt New Browser Window To open a database that was created in the Data Bridge or another software package Click File from the menu bar and select Open Table Navigate to the drive and the directory where the database is stored Under the List Files of Type select dBASE DBF to view all DBF files Click the database you want to open and click OK or double click on the database The following window will appear Click OK do lat ie E dBASE DBF Information File
157. ries performing administrative functions and accessing help and other Windows functionality Queries defined within the Data Bridge can be customized Data can be retrieved by a query from four database formats including Sybase SQL Anywhere FoxPro MS Excel and MS Access While defining a query the user can select columns from tables set primary key columns join columns from different table formats and modify the SQL statements When a query that references multiple or different database formats is run the Data Bridge pulls all the designated information from the source tables into the Sybase SQL Anywhere database and runs the query The query definition can be saved and the resulting data can be saved into any of the four database formats Queries have access levels associated with them Administrative functions include maintenance functions such as changing passwords and performing table maintenance as well as the Create Application Data process The Create Application Data process compiles application data for FPS from source tables and geocodes the data Geocoding assigns geographic coordinates to the data The System Administrator is responsible for running the Create Application Data Process on a regular basis usually twice a month FPS users are responsible for copying the updated application data to their local drive 1 e the Metaframe local H drive This is done this way to protect the integrity of the ENBOSS database
158. rom the FORC_FIL table l Highlight the Data Bridge Table from the Reference Table list box The Data Bridge Table will become active Click New to insert new fields from the FORC_ FIL table Select facid from the Key Field drop down list and force program file from the ODBC Profile drop down list 4 Select forc_fil from the Table drop down box Highlight the fields you wish to insert into the Data Bridge Table Be sure to hold down ie 6 Choose all of the fields that begin with au all of the fields that begin with st and uic and unmbr Field Name Table Name ITE 50 CACI EVER VIGILANT ARGISS ENBOSS Training Manual A Insert New Field ODBC Profile force program file Database tienboss argiss dataset Database Type FoxPro o Table forea Field Hames insert a y 7 Click Insert then OK in the confirmation dialog 8 Clock Close Set a relationship between Fac_id and Facid Before you query the data you must set up a relationship Since Fac_id and Facid are spelled differently you must set an explicit relationship in the Relationship Table so that the Data Bridge knows that the fields contain the same data This will allow you to query all of the fields that you have just entered The relationship will join the data into a large single database l Click on Relationship Table from the Reference Table list box An empty Relationship Table will appear 2 Click the New Relations
159. s district labeled by Fac_id and space utilization The following reports were generated for the Congressman FACILITY SUMMARY REPORT for the facilities within a 50 mile radius of Omaha ACCOUNT SUMMARY REPORT for the current fiscal year for the facilities within a 50 mile radius of Omaha 11 37 CACI EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank I 38 EVER VIGILANT ARGISS ENBOSS Training Manual Data Bridge Exercises 11 43 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Scenario In order to create some of the reports you must create queries in the Data Bridge and save them as DBF files These files will be used later to create your reports Therefore it is very important to save these query results to the fps reports profile The list below 1s the type of data that you will retrieve using the Data Bridge Gross and required facility square footage Unit information This information comes from a variety of different sources The following practical exercise will retrieve the necessary information using the Data Bridge to assist you in preparing for this briefing But Insert Primary Key from the Complex Table 1 Before inserting new Primary Keys be sure the Primary Key Table is completely empty Click on the Tables icon 2 Highlight the Primary Key Table from the Reference Table selection box Click New 4 Within the Insert Key Field di
160. sage window displaying the results Geocode Mode f Automatic C Interactive Geocode Table MATENE using Colum State h Boundary Columr none Search Table Symbol a for Objects in Column none Optional Refine Search with T able none using Boundary Name Column none iy Cancel Uptions Help Some of the records may not have been matched due to multiple possibilities The ungeocoded records will have to be examined to determine why they were not geocoded Repeat the geocoding steps but select the Interactive radio button from the Mode options in the Geocode window CACI EVER VIGILANT ARGISS Training Manual To find ungeocoded records l Select Query gt SQL Select Ze In the from Tables box enter the table you just geocoded 3 In the where Condition enter not obj SQL Select Select Columns A T ables Columns from Tables PO Operators where Condition Aggregates Functions Group by Columns Order by Columns Save Template into Table Named Selection Load Template e Browse Results Cancel Clear Verity Help The table you geocoded does not automatically display in the map window You need to add the layer using Layer Control Click the Layer Control button El from the Main tool bar l 2 Click the Add button under Layers 3 Select the layer that was just geocoded 4 Click Add 5
161. se files To display your data on a map you must first assign X and Y coordinates to each record Map nfo assigns these coordinates by geographic information in your database table to geographic information in another table referred to as the search table that already has X and Y coordinates associated with it we will use the georeference table This process is called geocoding For example you may want to assign X and Y coordinates to a Data Bridge query that has a Fac id field in the database MapInfo would read the Fac_id and look for matching Fac_id s in the search table e g georef tab This search table already has X and Y coordinates associated with each record When MapInfo matches the Fac_id s in your Data Bridge query to the Fac_id s in the search table GEOREF TAB it assigns the corresponding X and Y coordinates to your record The geocoded point becomes part of your database You can view these points by displaying your table in a Map window There are multiple methods of geocoding data These are Geocoding by Address When you geocode your table with street addresses MapInfo matches the addresses in your table to the addresses in a StreetInfo or other street data file and assigns X and Y coordinates to your record s address Geocoding by Boundary When you geocode your table with boundaries MapInfo matches the boundary name in your table with the boundary name in the search table MapInfo assigns the boundary
162. ship Table is active Za Click the Delete button A confirmation message dialog appears as shown below Delete Confirmation ll 7 Are you sure you want to delete the highlighted record 3 Click the Yes button to delete the relationship record or No to cancel the deletion DELETE PRIMARY KEYS BEFORE MOVING ON TO THE DATA BRIDGE SECTION 11 35 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Data Bridge Wizard The purpose of the Data Bridge Wizard is to lead the user through the creation of a query while keeping this process as non technical as possible The Data Bridge Wizard is used in place of the Table Maintenance window for setting up queries The user first specifies how many databases are to be joined Then for each database the user selects which system database to include If the selected database is not of a system known to ARGISS the database type and location must be specified Tables are then selected from the database and fields selected from each table Finally key fields to join the tables are selected Upon completing the Wizard the appropriate Data Bridge Reference Tables are populated A new query can be automatically populated using the information entered in the Wizard To start the Data Bridge Wizard E l Select the Data Bridge Wizard option from the Query menu or click on the 73 toolbar button Query Hem Oper ise Delete Data Bridge Wizard 2 Select th
163. sult Data dialog The Save Query and Data dialog will appear A Save Query and Data xl e Save Query Information Query Hame STATE_FACILITIES Description HEBRASKA FACILITIES gt 50000 MD Existing Queries Query Creator Access UMTR IN JGREEN read only Access Level Private other users cannot read or modify e Save Data Information ODBC Profile lips reports Table Hame LARGEFAC Database frienbosstargiss tpsidata Database Type FoxPro ITE 56 CACI R VIGILANT ARGISS ENBOSS Training Manual 3 Check the Save Query Information check box Enter a name and description for the query in the Query Name and Description boxes Choose an access level from the Access Level drop down box Select fps reports for the ODBC Profile Enter LARGEFAC as the table name in the Table Name text box Click Save Click OK on the confirmation message dialogs and click Close in the View Edit Untitled Result Data dialog to get back to main Query dialog 10 Click the Close button on the toolbar to close the query which is now named STATE_FACILITES 11 To save changes click Yes 09D 11 57 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Query with the Data Bridge Wizard 1 Start the Data Bridge Wizard using either the menu or the icon 2 Enter the number of databases for this query In this example we will be using only one table
164. system databases that are grayed out cannot be located Please contact the System Administrator to have the applications installed conca 4 Select the RISER Active radio button from the Select System Database dialog 5 Click Next Please select tables fram the database to be included in your join Ensure that all of the data fields you need are in the table s you select Database RISER ACTIVE rarrli x Cancel 6 When the Select Tables dialog appears choose the FOLLOWING TABLES racctgdt Back Scroll down the list as necessary and hold the lt CTRE gt button to select the multiple tables I 59 CACI EVER VIGILANT ARGISS ENBOSS Training Manual I Click Next Data Bridge Wizard Select Fields Please select fields from the tables to be included in your join Your queries can only display from these fields racctgdt restdt rpinfodt i Cancel 8 The Select Fields dialog appears Use this dialog to select the fields from each table that need to be included in the query The chart below will help in the selection Field Name Table Name racctgdi S S rpinfodt rpinfodt 9 After the fields have been entered correctly click the Next button 10 The Select Key Fields dialog appears ITE 60 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Data Bridge Wizard Select Key Fields Please select one field in each table that contains the same
165. t Key Fields Please select one field in each table that contains the same data for example they all have the five digit facility identification code This way will be able to join all the tables rpinfodt complex seu ee ee a REEF 12 Click the Finish button When the Data Bridge has finished automatically updating the Reference Tables the New Query dialog displays b New Query Tr Congratulations The Data Bridge Wizard has Updated the Reference Tables for you Do you want to start a new query with the information you entered 13 Click Yes to build a new query or No to close the dialog 11 40 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Exiting Data Bridge f To exit Data Bridge select the Exit option from the Query menu or click on the toolbar button New Hiper Wose Delete Data Bridge Wizard Save Jare Ae Exit 11 41 CACI EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank 11 42 EVER VIGILANT ARGISS ENBOSS Training Manual Section IIT Facility Planning System FPS CACI EVER VIGILANT ARGISS ENBOSS Training Manual This page intentionally left blank CACI EVER VIGILANT ARGISS ENBOSS Training Manual Objective The major objective of this section is to familiarize the student with the Facility Planning System It is expected that every student will be able to utilize the f
166. tation Launch Excel Close e If MS Excel has been properly installed it will launch and will load an unformatted copy of the query data into a new spreadsheet The name of the new spreadsheet will default to the first eight characters of the query s name It will be saved in the C ARGISS DBRIDGE DATA directory if ARGISS was installed on the C drive CACI EVER VIGILANT ARGISS ENBOSS Training Manual w Microsoft Excel Untitled xls 87 File Edit View Insert Format Tools Data Window Help a x JOSE SGA BBS o OS zz bl 3 i 94 100 gt Aral 0 gt B7U5 H 9 8 Et oO DA ee FAC ID AAC AS SA ES AAN ee ee ee NA FAC ID EXIST TN FAC STATFAC STREFAC TITLEFAC ZIP FAC CITY 54001 30499 GA 2190 WINTASTHENS S0605 213 ATHENS 3 64002 15626 GA 39311 YYRIC AUGUSTA 30909 259 AUGUSTA 54004 0 GA 1202 BANICARROLL 30117 050 CARROLLTON 15 GADS 0 GA PROPOSEOOOOO 0001 CARROLLTON 16 GADO 0575 GA 3001 MAC COLUMB 31906 228 COLUMBUS BADDE 0 GA 1856 MIDT COLUMBL 31906 230 COLUMBUS E 64009 0 GA BLOG 101 DOBBINS 30069 510 DOBBINS AFB 19 64010 0 GA 1002 MAR DUBLIN U 31021 506 DUBLIN 564011 44467 GA 2323 DAULEAST POl 30344 250 EAST POINT DADIS 17957 GA 43904 JONEFOREST F30297 359 FOREST PARK 54014 0 GA 1302 M T FT GILLE 30050 5234 FOREST PARK 113164015 0 GA BLOG 701 FORT GILIL30297 511 FOREST PARK 54016 0 GA BLOG 214 FORT GIL 30050 500 FOREST PARK GAOT 0 GA 45
167. th tools that are utilized in engineering applications ARGISS manages and allows querying mapping and reporting on selected data ARGISS is comprised of the following modules E ARGISS Applic Mal ES 9 Facility Planning System FPS is an engineering application that utilizes ARGISS components Data Bridge provides data management tools PlanView provides site and floor plan management Data Bridge MapInfo Professional provides desktop GIS functionality x Plane ARGISS 1 0 was released in June of 1995 ARGISS 1 0 provided a toolset consisting of the Data Bridge MapInfo and a subset of InfoMaker The Data Bridge consolidated Army Reserve facility related data originating from various sources and allowed ARGISS users to perform simple queries on that data MapInfo provided a platform to make the data mappable InfoMaker provided a number of predetermined tabular report formats for the consolidated Army Reserve data The Facility Planning System FPS was also fielded with ARGISS 1 0 As the first application to use the ARGISS toolset FPS provided a user friendly way to report on facility related data both in spatial and tabular form ARGISS 2 0 was released in September of 1995 ARGISS 2 0 used the full InfoMaker product providing the ability to create and execute tabular report formats for Data Bridge data The Data Bridge featured enhancements that added to its querying flexibility The ARGISS 2 0 version of FPS featured m
168. the plotter by Select File from the menu bar Choose Page Setup Select the Specific Printer radio button and then select the HP DESIGNJET 650C Under Paper change the size of the paper Click OK Ce ee Once the page setup options have been selected plot the map by selecting File from the menu bar and then Print CACI EVER VIGILANT ARGISS Training Manual MapInfo On Line Help MapInfo has extensive on line help To access MapInfo on line help l Select Help gt MapInfo Help Topics from the menu bar The following window will appear 2 Mapinfo Help Contents _ a x File Edit Bookmark Options Help 0 Contents Index de Search Instructions For Using Mapinfo Help El Using Mapinfa al a Reference Information Mapinfo s Help allows you to quickly reference menu commands and options VVhat is E Menu Commands the purpose of this command How do make this command active etc and provides 8 Dialog Box Descriptions step by step instructions for the related tasks E Listing of Buttons E Listing amp Description of Tools Ltiit To find a topic in Help oe E Glossary of Terms a El Intro to Maplnto Help Click the Contents tab to browse through topics by category ct MapInfo Graphing Click the Index tab to see a list of index entries either type the word youre H 4 8 Microsoft Office 97 Compatible looking for or scroll through the list H Technical Support l l l H Mapinto Map O
169. tical Exercises CACI EVER VIGILANT ARGISS Training Manual Scenario The Congressman and his colleagues have not been to NE003 They have requested a strip map complete with instructions from the airport in Omaha to NE003 The strip map will be created in Maplnfo using pre saved StreetWorks data You also need to create a map of the the MCAR projects with only the states in the 89th RSC You will have to run a query in the Data Bridge first and then create the map in MapInfo Finally you will print the maps in a Layout window These maps will be used in your final presentation to Congressman Snort and his colleagues The following practical exercise will walk you through creating a strip map quering MCAR project information from EMAAR in the Data Bridge creating a map of the 89th RSC MCAR projects Create a Strip Map from the Omaha Airport to NE003 Since the Omaha airport is so close to the Iowa border the strip will include Nebraska as well as Iowa streets l Double click on the MapInfo icon in the MapInfo program group 2 Select the File menu then Open Workspace from the menu bar 3 Select T ENBOSS ARGISS DATA NEHWY WOR 4 Click Open or double click on the file Open Workspace P Look in E Data El ce File name New won Files of type Workspace For Cancel Help Select the File menu then Open from the menu bar Select T ENBOSS ARGISS BASEMAPS MILTBASE TAB Click Open or double click on the
170. to fill in the Select Columns box In the Select Columns box choose the columns you would like to extract from the table Use the Columns drop down box to pick the columns If you want all of the columns leave the in the Select Columns box CACI EVER VIGILANT ARGISS Training Manual SOL Select Select Columns Tables Columns from Tables PO Operators e where Condition Aggregates Functions Group by Columns Order by Columns Save Template into Table Named Selection Load Template M Browse Results Cancel Llear ETT Help Enter an expression in the where condition Use the Columns Operators Aggregates and Functions drop down boxes to create the expression If desired select a column to group or order by in the Group By and Order By drop down boxes Click Verify to verify the syntax of the expression If there are any errors in your statement MapInfo gives you an error message telling you what the error is and which box contains the error If the expression is correct click OK The results will be displayed in a temporary Selection table EE Query Browser JO x Cong_dist Fac_eity Fac id Grtng_sf Factitle J Abbtype Fac idstr ES FOREST PARK GAD14 26 235 FT GILLEM USARC BLOG USARC MB GA014 C 30 Ma rorestrar eama 27438 Forest Pank usare usarc ame oania F CACI EVER VIGILANT ARGISS Training Manual To save the query
171. training square feet to required training square feet Both of these maps should have been printed and saved as a workspace We will open these workspaces again in the Conclusion and Overview section CACI EVER VIGILANT This page intentionally left blank ARGISS Training Manual EVER VIGILANT ARGISS Training Manual Advanced Maplinfo Features CACI EVER VIGILANT ARGISS Training Manual Objectives The following is a list of skills and functions the student will gain through this section Using StreetWorks Updating the Georeference Table Creating New Base Maps Geocoding Data Adding and Creating Custom Symbols Displaying Raster Images Again the following section is to give the user an advanced understanding of MapInfo Professional It is recommended that the user experiment with the additional functionality not covered in this section Using StreetWorks StreetWorks made by MapInfo Professional contains extensive county level street maps StreetWorks contains highways city boundaries townships landmarks waterways hospitals airports cemeteries libraries parks schools and other major points of interest Each RSC has a copy of StreetWorks for the states in their region The HQ USARC has a copy for the entire United States and Puerto Rico StreetWorks county street maps contain many separate layers or tables that can be turned on and off depending on what you want to display The following tab
172. translated into a file format that MapInfo Professional can read The following is a list of the formats MapInfo will open directly DBF dBASE WK1 Lotus 1 2 3 XLS Microsoft Excel TXT Delimited ASCII Raster Images e BIL SPOT satellite images BMP Windows Bitmap GIF Graphics Interchange Format JPG JPG PCX ZSoft Paintbrush TGA Targa TIF Tagged Image File Format MapInfo can import the following formats MIF MapInfo Interchange Format DXF AutoCad MBI MapInfo Boundary Interchange MMI MapInfo Mapfile Interchange IMG MapInfo DOS Image If you need to import a MicroStation file convert the DGN file to a DXF file which can be imported into MapInfo Remember when importing files into MapInfo the images will need to be cleaned up after the import and some information will be lost during the translation A 3 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Internet The Internet is an excellent way to research what types of geographical data is available what format it comes in what the cost is etc The following is a list of some web sites that will get you started e CIA World FactBook 1995 High and low resolution maps on countries from A Z http www odci gov cia publications 95 fact index html r1 e Census Data Detailed maps can be created for places in the US after entering a name state or zip code http tiger census gov cgi bin gazetteer e GIS Baltic Sea Drainage Basin Database
173. u will include in the directions between the two facilities 5 Add any additional symbols to the map using the Symbol tool Remember you have to have a layer editable in order to add a symbol 6 Open your map in a Layout window by selecting the Window menu option then Layout Window T Using the Text button type in the directions Your Layout window should look similar to the following example llo joa aja a el 1 ele alel xojosiaje mje A 0 A 21 el IO AE Ss pal peyso gt ae i So o C 64 CACI EVER VIGILANT ARGISS a Training Manual Creating New Base Maps Often times when creating maps of particular RSCs or states only selected states are necessary to display A new base map containing only target states can be created from the existing basemaps in the ARGISS dataset To create a new base maps from an existing base map l In MapInfo open the T ENBOSS ARGISS BASEMAPS STATESHR TAB base map 2 Using the Select tool select a state or hold the lt SHIFT gt key down to select multiple states Select File from the menu bar and then Save Copy As Select Selection from the Save Table drop down box and click Save As Give the new base map a name and click OK Close the STATESHR table by selecting the File menu option and then Close Table Open the new base map that contains the states you selected Lea tl Geocoding Data MapInfo allows users to create maps from existing databa
174. uild a new query with the tables in the second relationship and add a Where Clause Untitled OO ete 11 32 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Where Criteria x milf af af interest efect_date gt Date 2003 07411 OR interest efect_date 5 NULL 7 Run the query i View Edit Untitled Result Data FACIDSTR_ACQ COST __ AUAGR AUCW AUENL NY024 127256 00 EN A tS A O O oo A O M A A O M Nyoz4 25000000 O O o o Nyoz4 O O Nooo OO BO NDO O O 0o Noom OOOO BO E O O oo Nooo 3800000 O o o NDOO 6665 00 BO DOOR Bt NDO 6200 00 1502 0 o o Pago 263600 00 69 2 O Z ooo 8 Save the results 11 33 CACI EVER VIGILANT Save Query As Query Creator Access ARGISS TRAINIMG SROAMS private 11 34 ARGISS ENBOSS Training Manual M FAC_IDSTR TRAINING Private other users cannot read or modify CACI EVER VIGILANT ARGISS ENBOSS Training Manual Deleting a Primary Key To delete a key field from the Primary Key table l Highlight the key field in the Primary Key table and click the Delete button A confirmation dialog displays Delete Confirmation AA 7 Are you sure you want to delete the highlighted record 2 Click Yes to delete the record or No to return to the Table Maintenance dialog Deleting a Relationship To delete a record from the Relationship table l Highlight a record in the desired relationship while the Relation
175. ull functionality of FPS The student is also expected to be able to utilize other sections to enhance the functionality of FPS Some of the major objectives include the following Accessing FPS Updating FPS Selecting a Search Criteria Mapping a Facility Viewing Canned Reports Mapping Canned Reports Creating Ad Hoc Reports Mapping Ad Hoc Reports Accessing PlanView 9 A 1 A A a a a a Accessing FPS From the ENBOSS Navigator select then select FPS Planwiew Directory Information Dialog The directory information dialog contains the following Location of Data directory path of the Facility Planning System data used for facility mapping and reporting Location of Basemaps directory path of ARGISS basemap tables used to create maps Location of Map nfo directory path of MapInfo II 3 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Directory Information Location of Data JH ENBOSS ARGISS FPS DATA Location of Base Maps TAENBOSSAARGISSA BASE MAPS Location of Mapinfo T AMAPINFO Update Location H1YENBOSS5S1AARGISSAFPSADATA Continue Exit The location of these files can be changed by clicking in the field you want to change and entering a new path Updating FPS Data The Update window displays the last date the FPS application data was updated on the LAN and on the user s hard drive Local If the LAN FPS data has been updated more recently than the Local FP
176. unction Svmbol Places point symbols on a map n Draws single straight lines on a map Polyline Draws polylines on a map Arc Draws an arc the size and shape of one quarter of an ellipse Draws filled polygons a z J Ellipse Draws filled elliptical and circular objects O Rectangle Draws filled rectangles and squares C Rounded Rectangle Draws filled rounded rectangles and squares Text Adds titles labels and annotation to maps and layouts Pence Creates frames in the Layout window to display maps graphs Browsers legends info windows statistics windows message windows and empty frames Reshape Edits regions polylines lines and arcs by moving adding and deleting nodes that define them Add Node Adds additional nodes to an object for more precise editing Symbol Style Changes the style color and size of a symbol object icine le Changes the style color and size of a map object E Region Style Text Style Changes the font typeface size style color and background of text objects Changes the fill pattern and border of region objects By using the Main and Drawing toolbars users can perform a majority of basic mapping and GIS functions within MapInfo To display or hide these toolbars chose Options gt Toolbars the Toolbar Options window displays as shown below CACI EVER VIGILANT ARGISS Training Manual Toolbar Options Tools Further explanations of each of these to
177. ut Window Create a new Layout window containing One Frame for window Jomaha necomplx Ascbndi Ice C No Frames Cancel Help 5 Select the Frames for All Currently Open Windows radio button automatically insert all open windows into the layout 6 Click OK Te A Layout window with all of the currently opened windows will appear Rearrange and resize the windows as necessary 8 Click the Text tool from the Main toolbar and add a title to the layout by clicking on the Layout where you want to place the title CACI EVER VIGILANT ARGISS Training Manual Omaha Facilites Lian abe E kr Fr m pa FP al 9 Select File gt Save Workspace 10 Save your work as OMAHA WOR to the C Program Files ENBOSS ARGISS FPS DATA directory 11 Select File gt Print to print the Layout window Conclusion The MapInfo practical exercise gave you a basic understanding of Maplnfo functionality Desktop GIS can be a valuable tool to engineers planners real estate specialists and facility managers You are encouraged to practice using MapInfo after the conclusion of this class The following sections will build upon what you have learned in this section To summarize you created the following maps and workspaces for the Congressman s presentation NEFACS Map of Nebraska facilities labeled by Fac_id Fac title and Fac city OMAHA Layout window of Omaha facilities with a corresponding graph comparing gross
178. utton or double click on a key field Add as many key fields to the relationship as desired 5 Click the Close button to return to the Table Maintenance window The Table Maintenance dialog appears displaying the new relationship BLAN Table Maintenance Reference Table Data Bridge Table Relationship Table security Reference Table Relationship Key Field Hame Table Hame Database Profile fac_id complex za_emaar fac_idstr interest sa_emaar fa_id inztiDa za_emaar fa_id in_t1 sa_emaar fa_id in_ti2a za_emaar fac_id complex sa_emaar fac_id complex sa_emaar fac_id units sa_emaar Add Key Field 6 Click Close on the Table Maintenance dialog 1 27 CACI EVER VIGILANT ARGISS ENBOSS Training Manual Creating a Query from Tables in a Relationship O To build a query from tables in a relationship l Select the New option from the Query menu or click on the Ea toolbar button Z From the Untitled query window select a key field from the drop down box that is in a relationship The Relationship Found message dialog appears Relationship Found 2 There iz a relationship in the Relationship table for key feld Facid Do you want to set the relationship between the tables Choosing No will display all fields registered for the selected key field 3 To query from all of the fields in each table in the relationship the relationship must be set Click Yes 4 The Choose a Relationshi
179. vate UTILITY OTL 2 YT private WORE ORDER RAINFORC public Access Level Private other users cannot read or modify 7 Y Save Data Information ODBC Profile none E Table Hame WORK ORD Database peoo Database Type F cancel 9 In the File Name text box enter in a name 10 Select C ENBOSS ARGISS DATA as the directory 11 Click OK on the Save Data Without Using An ODBC Profile window 12 Click OK on the Save Confirmation window 13 Click Close on the View Edit Result Data window 14 Click the Close toolbar button or select the Query menu then Close 15 Exit the Data Bridge CACI EVER VIGILANT ARGISS Training Manual Create a New Base Map Containing Only the States in the 89th RSC l Double click on the MapInfo icon in the MapInfo program group Open the T ENBOSS ARGISS BASEMAPS STATESHR TAB base map 3 Using the Select tool select Nebraska and press the lt SHIFT gt key down Select lowa Missouri and Kansas 4 Select File from the menu bar and then Save Copy As 5 Select Selection from the Save Table drop down box and click Save As 6 Give the new base map a name select C ENBOSS ARGISS DATA as the directory and click OK Save Copy of Table As ki ES Save in Sy Data ex a 89th ASC TAB sa Nebraska TAB File name A TAB Save as type Mapinfo tab Cancel Help Save Projection id T Close the STATESHR table by selecting the File
180. verview Click the Search tab to search for words or phrases that may be contained in a e Mapinto Map Reference Information Help topic Note For complete instructions on how to use Windows Help press the F1 key while a Help window is active 2 The MapInfo help utility follows the windows standards Exiting MapInfo To exit MapInfo click File from the menu bar then Exit C 43 EVER VIGILANT ARGISS Training Manual Basic MapInfo Practical Exercise CACI EVER VIGILANT ARGISS Training Manual Scenario The Congressman and his colleagues have requested graphic representation of the data and reports that are required for your presentation The following section and practical exercise will guide you through the process of creating maps graphs and charts and perform spatial analysis The maps and graphics created will be inserted into the PowerPoint presentation for the Congressman and his colleagues The following practical exercise will demonstrate some of MapInfo s basic functions MapInfo is extremely powerful and therefore sometimes complicated The basic map making functions will be demonstrated You will learn how to open existing maps and create new ones The queries that were created in the Data Bridge practical exercise will be used to demonstrate how tabular data can be displayed on a map for visual and spatial analysis To start the practical exercise click on the MapInfo icon from the MapInfo program group
181. where Condition enter not obj This will return all of the records in the table that are not map objects i e they have no X and Y coordinates CACI EVER VIGILANT ARGISS Training Manual SQL Select Select Columns Tables Columns from Tables PO Operators e where Condition Aggregates Functions Group by Columns Order by Columns Save Template into Table Named Selection Load Template M Browse Results Cancel Llear ETT Help Once you have geocoded the data you can now add that data as a layer to your map To add the newly created map your map window l Click on a map window to make it active Ze Click the Layer Control button El from the Main tool bar 3 Add and Remove layers you wish to display Layer Control Layer zE E he e E CO E OK w E O Mm m Tr Lancel Display Label Thematic HotLink Reorder Ee E Heb PELE EE f CACI EVER VIGILANT ARGISS Training Manual 4 Check the Auto label checkbox and auto label the records if desired 5 Click OK then zoom in to the map area where your records are displayed MapInfo Professional Ga_Facs Stateshr Map MI ES File Edit Tools Objects Query Table Options Map Window Help e x ale E S cele Leken FSSC CELS F E z SAE ae HARRY MILTON KANDEL USARC e 644 4 mi 5 Editing Mone Selecting Mone The data displayed on the map window and
182. y dbf sip DBF ES ip DBF ES Pbcatcal dbf mbr DEF Pbcatedt dbf AAA File name necompl der Files of type dBASE DBF fdh e Cancel Help Preferred View Automatic 3 Under List Files of Type select dbase DBF All the available DBF files will populate in the File box 4 Select the NECOMPLX DBF table from the C Program Files ENBOSS ARGISS FPS DATA directory 5 Click OK on the Open Table window 6 Click OK in the dBASE DBF Information window Geocode the DBF File You will now geocode or assign latitude and longitude coordinates to the NECOMPLX table The geocoding process will put the data on a map for visual and spatial analysis However before CACI EVER VIGILANT ARGISS Training Manual you can geocode NECOMPLX you must open a table to geocode it against the GEOREFERENCE table l Select File gt Open Table Select the georef tab from T ENBOSS ARGISS DATASET 3 Select No View from the Preferred View drop down box since this table has already been geocoded and we do not want to add it to the map window 4 Click OK Now you are ready to geocode the NECOMPLX table l Select Table from the menu bar Za Select Geocode from the menu items Geocode Geocode T able necompl a Mode using Colum Fac id la Automatic Interactive Boundary Colum none a Search Table eoret Symbol tr for Objects in Column Fac_id a Optional Refine Search with Table none using Bou
183. y Summary Report The next step is to produce the two reports requested by the Congressman for the facilities within the 50 mile buffer l Select Info from the menu bar Select Canned Reports from the menu items This will launch FPS Reports E Click the FSR button F 1 to preview the Facility Summary Report Select File gt Print to print the report 5 Close the Facility Summary Report EA Generate an Account Summary Report for Current Fiscal Year e L Click the ASR button L _ to preview the Account Summary Report 2 Select Rows gt Filter to extract data for any fiscal year The Specify Filter dialog will appear Specify Filter aer fy 1999 OK x DEN cs vai Verity Cancel Functions Columns abzl asci e avg Hx for all Pos ES bitmap fac state cellinal x pri arn casel x when a thei asr fy char cwe total 1 cosl y tot comit hd Select or type the following expression in the expression window asr_fy 1999 Click Verify If the expression is valid click OK Only the records for 1999 will appear Click the Retrieve button to recalculate the report with your filter Select File gt Print to print the report Click the Close then the Exit button A Se Create Map of Congressional District NE 01 The Congressman has also requested a map of all facilities in his district labeled with fac_id and space utilization 11 33 CACI EVER VIGILANT
184. y added to ARGISS Since ARGISS is a Geographic Information System GIS the Facility Ids need to have X and Y latitude and longitude coordinates associated with them so the GIS engine will know where they are located in the map The X and Y coordinates are stored in a master table called the georeference table GEOREF TAB The Engineer Automation Help Desk maintains the master georeference table and copies it to local folder of each FPS user The old GEOREF table needs to be overwritten with the new GEOREFF tables in the T ENBOSS ARGISS DATASET directory The Create Application Data process needs to be run for the Facility Planning System in the Data Bridge for this information to be reflected in the system To add a new Facility Id to FPS the Engineer Automation Help Desk performs these tasks l Open the georef table T ENBOSS ARGISS DATASET GEOREF TAB in Maplnfo The STATESHR TAB USHWY TAB etc located at T ENBOSS ARGISS BASEMAPS are useful for identifying location in the Earth s surface Make the GEORFF table editable in Layer Control Open the GEOREF table in a Browser window Select Edit gt New Row to add a new row to the GEORFF table Type in the needed information Fac_id Fac title Fac street Fac city Fac state Fac zip etc Sale cal ae 6 Use the Select tool to select the empty box to the far left of the new row you just added The box will fill in when the row is selected 11 24 CACI EVER VIGILANT ARGI
185. y deals with For example your state department of transportation may have detailed GIS information on traffic or air quality Local government agencies such as the local city planning department may have detailed land use and zoning information Many academic institutions also maintain GIS clearinghouses For example the Georgia Institute of Technology maintains a GIS data clearinghouse for the state of Georgia This is the best site to obtain free GIS data for the state of Georgia Academic institutions usually have web sites and the data can be accessed via the internet Local and state agencies may or may not have a web site and you may have to order the data by phone or mail Military Agencies GIS data can be obtained from military agencies such as the Corp of Engineers National Imagery and Mapping Agency NIMA the Tri Service Spatial Data Clearinghouse and many active Army installations that operate a geographic information system e National Imagery and Mapping Agency DOD agency involved in mapping and remote sensing activities Develops and maintains the Digital Chart of the World data Also serves as a repository of military installation CAD and GIS data e Tri Service CADD GIS Technology Center This center is a multi service vehicle to set standards and coordinate facilities CADD and GIS within the Department of Defense It also promotes system integration and standards including naming conventions common GIS layers stan
186. y that has been assigned to you Gi Site Files Facilities 6 Click Add The added facility will now display in the File Maintenance window 7 Type in the correct File Name for the digitized site plan The standard site plan file names are 6 characters in length 8 Example Fac id S NEOOI1S 9 Once the site plan has been entered into File Maintenance click Close and save the changes IV 21 CACI EVER VIGILANT ARGISS ENBOS Training Manual Register a Floor Plan l Select View gt File Maintenance from the Plan View menu bar or press the File Maintenance button en The File Maintenance window displays 2 Select the Floor radio button under Plan Type A list of all the floor plans that have already been registered in Plan View display 3 Click New 4 A new row 1s inserted and highlighted in the File Maintenance window i File Maintenance Plan Type C Site amp Floor Description Floor File Hame FAC ID Building Aron UA US ARO 1 2 AROM CAF ARDD TCE USARC 2 AROM CIF ARDOZ 400 OMS Shop 1 TS F 100 Mn US ARE 1 ARODSCI F Enter your assigned Fac id in the Fac_id drop down box Enter 100 in the Building box Enter a description in the Description box Enter 1 in the Floor box Enter the file name in the File Name box A 0 Once all of the information has been entered into File Maintenance click Close The floor plan can be now be displayed using Plan View

ARGISS - ENBOSSSupport.com

Contents

Download Pdf Manuals

Related Search

Related Contents