Save the Excel file to a - Manatee County, Florida
Traffic Count Map book Update Procedures
Semi-Manual Process
Create folder
1. C:\Manatee County\Transportation\Traffic Counts
Copy files
1. GIS_NAS_SHARE on ‘ Raptor’ R:\GIS\mxds\transportation there is a folder ex - Traffic Counts 2008.
2. Copy the Python script and .mxd (TrafficCounts08.mxd) from this folder and put them in the previously created folder and rename.
3. Add Excel file to new .mxd and then export to .dbf and name it ZoneCounts.dbf ex. – ZoneCounts08.dbf
4. Edit Python script to update paths and variables to current year
5. Run script. This prepares data to be used in map.
Create Map book
1. Select the Map Book tab (bottom right in the Table of Contents)
2. Create Map Series:
Choose the index layer = Traffic Count Station Buffer
3. This field specifies the page name = Traffic Count Station
4. Open the layout view
5. Select the Legend – (This legend has probably been converted to graphics.
You will need to adjust accordingly.)
6. Insert Text with empty value
7. Select the Text you added and Right-Click the Map Series
“Tag with Index Layer Field” (This will display the Traffic Counts)
8. Export Map Series
9. Export Map book pages to .pdf format using the same name as the
Previous .pdf map book pages, (Station.pdf), to a New Folder.
Update Transportation Website
The page to reference the updates is –
Departments(Public Works(Traffic Engineering and Operations(Traffic Counts
1. Convert .dbf file to pdf using Acrobat Distiller. Reformatting will be needed to fit all columns on an 11x17 page format before distilling.
2. Make copy of original master pdf with bookmarks located on trenton.. path - /public/gis/arcims/downloads/pdfs/traffic
3. Open TrafficCounts.pdf with Adobe Acrobat
4. Replace pages of copy pdf (TrafficCounts.pdf) with new Converted Spreadsheet, leaving bookmarks intact. On left hand tab, click pages. Select pages and delete all but one page.
[pic]
5. If the new list of pdf's (maps) contains new stations, and therefore, new pdf's GO TO STEP 6
If the new list of pdf's (maps) is identical to the old list of bookmarked pdf's GO TO STEP 7
6. Update bookmarks on TrafficCounts.pdf. Add any new stations that were added. Create bookmarks so that they "link to webfile", using the file path as the URL desination. For Example: bookmark 01-02 links to .
[pic]
7. Replace original TrafficCounts.pdf on trenton with updated pdf.
Replace individual map pdf's, also on trenton, with new updated map pdf's.
8. Go to the County website and check to make sure your changes are working.
Manual Process
Below are steps to create a map book for the Traffic Counts provided by the Department of Transportation.
A Map Book is a multipage document based on a dataset and an index grid representing the pages.
Save the Excel file to a .dbf . If using Windows Vista, import the Excel file into ArcMap and export it as a .dbf (database format file).
ArcCatalog
• Open ArcCatalog
• If one is not available, create a New Personal Geodatabase
➢ Connect to the desired folder( right click( down to “New”( personal geodatabase. You want to store the .dbf file in your new geodatabase.
➢ Name your new GDB then Right-Click on it ( Import Table (single)( Navigate to where the excel or database file is saved, select and import
ArcMap
• Open ArcMap
• Click the add data icon & navigate to the Traffic Count Station layer or open a previous .mxd which contains this layer.
• Create a ¼ -mile buffer around the Traffic Count Station layer, if one is not available.
➢ Open ArcToolbox( Analysis Tools( Proximity(Buffer
[pic]
Input feature: Traffic Count Station layer
Output feature: Traffic Count Station Buffer
Distance: .25 miles
• Add this layer to the map (this is the layer from which the Map Book is created).
• Import the Traffic Count table from the Personal Geodatabase or SDE.
➢ In the ArcCatalog GDB click and drag the Traffic Count table and drop into the Table of Contents, source the data if necessary by double clicking and defining where the table originated. The table will appear under the Source tab in the Table of Contents
• In ArcMap, Right click on for the Traffic Count Station Buffer and Open the Attribute Table( Go to Options(Add Field
• Add a field for the new data. Name the field the same name as it is in the table that you want to join to.
• Right-Click the Traffic Count Station Buffer(Joins and Relates
➢ Join the Traffic Count Table to the Traffic Count Station Buffer based on the field you created
• Open the Attribute Table of the Traffic Count Station Buffer(Right-Click the newly created field and go to “calculate”. This will populate the newly created field with calculations based on the newly joined data.
Map Book creation:
• In Arcmap, Select the Map Book tab at the bottom of the Table of Contents
• Right Click on “Map Book”(click on “Add map Series”(Map Sheet Wizard appears:
[pic]
“Choose the Detail Data Frame”= the data frame where you have placed the layer files associated with the Counts and Buffers
“Choose the index layer” = Traffic Count Station Buffer (only sourced layers will show in this menu)
“This field specifies the page name” = Traffic Count Station
[pic][pic]
• In ArcMap, switch to Layout view
➢ Select/Insert the Legend – (This legend has probably been converted to graphics. Adjust accordingly.)
➢ Insert Text with empty value (no text entered into Text Box)
➢ Select the Text box you added and Right-Click the Map Series
“Tag with Index Layer Field” (This will display the Traffic Counts ID’s)
• Export Map Series
Export the revised mapbook pages to .pdf format using the same name as the
Previous .pdf map book pages, (Station.pdf), to a New Folder.
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- change pdf file to excel format
- convert the following fraction to a decimal
- excel vba import text file to worksheet
- how to insert excel file into word
- powershell excel file to csv
- save excel file as pdf
- print excel file to pdf
- how to convert excel file to pdf
- how to save the environment
- ways to save the earth
- attach excel file to word document
- add excel file to word