Home

Maintenance Manual (1.0MB PDF)

Contents

1. Disply Source 0124 a Drawno k O A 12 Times New Roman TS BZ U Av Av br 4 1 91 11 45 Inches 31 10 4 Look Up Tables The CCIAM references 63 look up tables Each look up table conforms to the naming convention outlined in Section 7 The CCIAM is designed so that each coefficient or look up value can be easily updated with more current data Therefore no thresholds are hard coded into the model but are located in tables that are referenced by the VBA code Table 10 3 briefly describes the location and purpose of each look up table in the CCIAM Geodatabase Description scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu scenario_lu SIF SIF SIF SIF SIF SIF SIF Land Use PC code cross reference for pre processing the parcel data Table 10 3 Look up Table Z LuPC LUT Z Zones LUT Z HabitatOSR LUT RZ Pugeo LUT RZ Result LUT R Feature Class List LUT R HabitatList LUT R KeySegment LUT R LYRLIST LUT R PlanUnitList LUT Z Ave EDU LUT Z PrimeVeg LUT Z RE2 DuplicatesOnly LUT F Existing Expenditures CC LUT F Capital Annualized LUT F Gov Expenditures LUT F School Cost LUT H TounstDU LUT I Length of US1 LUT I LOS LUT Zoning PC code cross reference for pre processing the parcel data Habitat development ratio for
2. The carrying capacity analysis shall be designed to determine the ability of the Florida Keys ecosystem and the various segments thereof to withstand all impacts of additional land development activities The Carrying Capacity Impact Assessment Model CCIAM and Routine Planning Tool RPT were created as part of the FKCCS This manual documents the technical details of these two applications Overview of the Carrying Capacity Impact Assessment Model CCIAM The CCIAM is a spatial model built using ArcGIS 8 1 and automated with VBA which evaluates the end state effects of land use scenarios on the natural and social systems of the Florida Keys The CCIAM analysis is triggered by changes in the land use GIS layer The user defines these changes as alternative land use scenarios through the Graphical User Interface GUI to modify land use patterns and specify stormwater and wastewater treatment types Users of this model include planners from Monroe County the South Florida Regional Planning Council the Florida Department of Community Affairs as well as other stakeholders involved with the county s comprehensive planning process The CCIAM is expected to be run during reviews of the Monroe County comprehensive plan which may occur annually or less frequently Outputs from the CCIAM include geodatabase feature classes and tables Arc Info coverages and Arc Info grids These outputs are summarized into two HTML reports
3. WATERFRONT Identify waterfront parcels inspect parcels to find waterfront properties Manual activity Visually ADJ US1 Identify parcels adjacent to US 1 A se eters which ones are adjacent to US1 VACANT_CONS Identify parcels within 300 feet of at least 10 acres of contiguous undisturbed habitat or of a publicly owned conservation area see calculation guidelines SUB_ID2 Identify parcels in subdivisions GIS process Overlay with subdivisions layer from MCPA NOTE must be done prior to manually shifting parcels SUBDIV_PERC Identify subdivision percentage developed Manual activity Summarize tthe number of developed parcels and divide by the total number of parcels in the subdivision to get the ratio FAR Calculate floor area ratios Manual activity Divide the GFA column by the SQFOOTAGE column 46 Table 12 1 Items in the CCIAM Parcel Attribute Table Continued Item in Method to Attribute Table Description of Item Calculate the Value Manual activity Add an item called GFA and calc GFA GFA Calculate gross floor area o PLA Thb way cone simply to make the item more intuitive and still retain the original data field EDU Assign EDUs to each parcel See Delivery Order 8 Report Assign wastewater treatment to MA each parcel See Delivery Order 8 Report Table 12 2 Land Use Categories Corresponding PC Values m 20
4. N 300 foot buffer of polys 10 acres or more Developed area not part of the dissolved habitat layer TE LN Florida Keys Carrying Capacity Study 59 Carrying Capacity Impact Assessment Model Maintenance Model Section 12 Select By Location g 2 x Lets you select features from one or more layers based on where they are located in relation to the features in another layer want to select from the currently selected features in al the following layers cards A Buffer natural W parcelclp polygon k that intersect v the features in this layer Buffer natural I Use selected features 0 features selected T Apply a buffer to the features in Buffer natural of 300 000000 fret y m Preview The red features represent the features in Buffer_natural The highlighted cyan features are selected because they intersect the red features 7 Add an item VACANT CONS and calculate VACANT CONS 1 for those records 8 Do another select by location in ArcMap with the CARL coverage layer and use the buffer on the fly option Figure 12 4 Florida Keys Carrying Capacity Study Carrying Capacity Impact Assessment Model Maintenance Model 60 Figure 12 4 Select By Location A x Lets pou select features from one or more layers based on where they are located in relation to the features in another layer want to
5. select from the currently selected features in the following layers Ocal OBuffer_natural W parcelclp polygon that are within a distance of jd cal JT Use selected features 0 features selected IV Apply a buffer to the features in carl98 of 300 000000 Feet y m Preview The red features represent the features in carl98 The highlighted cyan features are selected because they are within a distance of the red features Points Lines Polygons 9 Calculate VACANT CONS 1 for those records 12 5 Dwelling Unit Calibration Guidelines The CENSUS 2000 provided additional information regarding the number of dwelling units in the Florida Keys The contractor used this opportunity to calibrate the dwelling units in the parcel GIS layer with the dwelling units being reported in the CENSUS See the Delivery Order 11 report for a discussion on the methods and rationale that guided this effort The DU_AVE attribute should not be updated unless the Monroe County Property Appraiser s office provides a more accurate or reliable count of dwelling units from their CAMA tax roll database 12 6 Input Layer Updates There are sixteen ArcInfo coverages and 22 grids reguired by the CCIAM Table 12 6 itemizes each coverage and describes the reguired pre processing activity for the layer 61 Table 12 6 Input Layers and Reguired Pre Processing Layer Name Descriptio
6. 43560 Add an item DEV POLY and calculate DEV POLY egual to POLY ACRE DEV RATIO For each RE2 summarize DEV POLY in Arc Workstation this is a FREQUENCY in ArcMap it is a SUMMARIZE to produce a new summarized table In the summarized table change the DEV POLY name to PARC TOTDEV Do this to avoid confusion when joining these data back to the coverage Add an item LESS 01 to the summarized table Select for PARC TOTDEV greater than or egual to 0 1 Calculate LESS 01 equal to N 54 12 13 14 15 16 Select for PARC TOTDEV less than 0 1 Calculate LESS 01 equal to Y Join the summarized table to VACPARCELS using RE2 as the join item Select from VACPARCELS all polygons that have a LESS_01 value of N to create VACRESDEV These are the developable vacant residential parcels The remaining tasks calculate the suitability ranking of these developable parcels Add four items to the VACRESDEV attribute table POT H20 HABITAT FEMA SUBDIV Select for parcels that have access to potable water Do this by finding all roads that have an FKAA customer location within 100 feet of the road Then select all parcels that are within 50 feet of the selected roads The assumption being that if a road has a FKAA customer on it then the vacant parcels would be able to get a potable water hook up The 50 foot buffer is used try to minimize the effect of the spatial error in both the
7. See the suitability guidelines to calculate NONRES_SUIT Add an item REDEV VALUE and calculate REDEV VALUE PBLDG1 PLANDI Add an item WATERFRONT and visually inspect parcels to find those that are adjacent to the shoreline or are on a canal Calculate WATERFRONT 1 for those that meet the criteria Add an item ADJ UST and visually inspect parcels to determine which ones are adjacent to US1 Calculate ADJ US1 I for those parcels that meet the criteria See the vacant conservation guidelines for the VACANT_CONS item Add an item called GFA and calc GFA equal to FLA Add an item called FAR and divide the GFA column by the SOFOOTAGE column to obtain the FAR values 50 29 For both the EDU and WWT items refer to the Delivery Order 8 report These items should only be updated if a systematic effort to account for eguivalent dwelling units and wastewater treatment methods is undertaken to enhance the CCIAM Table 12 3 Zoning Classifications and Land Development Standards ZONE MAX RES DEN MAX HOTEL MAX FAR ZONE OSR ACCC 0 00 0 00 0 00 1 00 UC 12 00 10 00 0 45 0 20 BU 2 12 00 10 00 0 45 0 20 BU 2F 12 00 10 00 0 45 0 20 BU 3 12 00 10 00 0 45 0 20 UR 12 00 0 00 0 30 0 20 RU 3 12 00 0 00 0 30 0 20 RU 5 12 00 0 00 0 30 0 20 RU 5P 12 00 0 00 0 30 0 20 URM 7 00 7 00 0 00 0 20 RU 1M 7 00 7 00 0 00 0 20 SC 6 00
8. then open one of the ten canal xls files enable the macros and go to the Results worksheet to view results For a more detailed discussion of the canal results please refer to the canal report Florida Keys Carrying Capacity Study 11 Carrying Capacity Impact Assessment Model Maintenance Model The web report directory contains the HTML XML XSL and images reguired for the two result reports At the conclusion of the analysis VBA code the first action of the result reporting code is to copy this entire directory to with a new name of the scenario number The mol layer files and report layer files directories contain the ArcInfo layer files that reference feature classes and grids in the FKCCS results geodatabases and grid workspaces These layer files are referenced by the result reporting VBA code to produce maps Layer files contain the symbology for a dataset The layer files in the FKCCS Results mol layer _fileslwater_loads directory are created through VBA code whereas all the other layer files have been created as static files that do not change with each scenario The water loads layer files are dynamically created with VBA code on the fly because they require a table join to a feature class before conversion to a layer file Therefore a simple change of data source will not work with these layer files to accommodate different scenarios The terrestrial GRIDS directory is an ArcInfo workspace that contains the ArcInfo gri
9. 10 00 0 40 0 00 se 6 00 10 00 0 40 0 00 BU 1 6 00 10 00 0 40 0 00 BUIL 6 00 10 00 0 40 0 00 C 1 6 00 10 00 0 40 0 00 SR 10 00 5 00 0 50 0 50 SRL 3 00 0 00 0 00 0 00 SS 6 00 5 00 0 20 0 80 SS ACCC 6 00 5 00 0 20 0 80 OS 2 00 2 00 0 00 0 95 NA 999 00 0 00 0 20 999 00 IS 1 00 0 00 0 25 0 00 IS D 1 00 0 00 0 25 0 00 IS M 1 00 0 00 0 25 0 00 Isve9 1 00 0 00 0 25 0 00 RU 1 00 0 00 0 25 0 00 RUI 1 00 0 00 0 25 0 00 RU 1 1 00 0 00 0 25 0 00 RU 2 1 00 0 00 0 25 0 00 R 1 1 00 0 00 0 25 0 00 R 1A 1 00 0 00 0 25 0 00 51 Table 12 3 Zoning Classifications and Land Development Standards Continued ZONE MAX RES DEN MAX HOTEL MAX FAR ZONE OSR R 2 1 00 0 00 0 25 0 00 IC ACCC 1 00 0 00 0 25 0 00 IS ACCC 1 00 0 00 0 25 0 00 DR 18 00 10 00 0 30 0 20 RV 0 00 15 00 0 00 0 00 CFA 12 00 0 00 0 40 0 20 CFV 12 00 0 00 0 40 0 20 CFSD 12 00 0 00 0 40 0 20 MU 12 00 10 00 0 40 0 20 I 12 00 0 00 0 40 0 00 MI 12 00 10 00 0 60 0 00 MF 12 00 0 00 0 50 0 20 M 12 00 0 00 0 50 0 20 AD 0 00 0 00 0 10 0 00 PR 5 00 5 00 0 20 0 90 LDR C 1 00 0 00 0 00 0 50 MDR C 8 00 0 00 0 00 0 50 SF 1 1 00 0 00 0 00 0 50 SF 2 1 00 0 00 0 00 0 50 SF 1 00 0 00 0 00 0 50 MDR 16 00 0 00 0 00 0 50 HDR 22 00 0 00 0 00 0 60 LC 16 00 0 00 0 80 0 60 GC 16 00 0 00 0 80 0 60 CT 16 00 0 00 0 80 0 60 RO 16 00 0 00 0 80 0 60 PRD 8 0
10. 71 72 73 74 75 76 77 78 79 Institutional 90 Open Space and Recreation 80 82 86 87 88 89 92 99 Mig OA Military E Submerged Lands 47 Updating the parcels can take three forms First the spatial accuracy of the parcel geometry is improved either manually or through a systematic process As long as the real estate RE2 attribute does not change a simple join of the attribute table to the new GIS layer can be performed to update the table of the new layer Second the tax roll data are updated by the MCPA and therefore the attribute data in the CCIAM parcels need to reflect these updates The steward would have to perform the attribute updating actions identified in Table 10 1 and the steps noted below Once completed this new table has to be linked to the parcel GIS layer Third both the spatial and attribute data have been updated The steward would have to obtain the new GIS layer and update the attributes accordingly It is highly recommended that the steward closely coordinate with the MCPA prior to any modifications to these data and to ensure that the steward is aware of future updates or enhancements to this information Assuming that an entirely new parcel GIS layer and tax roll needs to be integrated into the CCIAM the following steps must be performed items in bold are the attributes being calculated 1 Ze Import the parcel GIS layer from the MCPA Link the tax roll to t
11. FKAA point data and the parcel data After both selections have been made calculate POT_H20 equal to 1 Select By Location 2 x Lets you select features from one or more layers based on where they are located in relation to the features in another layer want to select features from ha the following layers LIFKAA a Roads vacresdew y that are within a distance of the features in this layer y IF Use selected feature 0 features selected V Apply a buffer to the features in FKAA ie 000000 F Select roads first Preview The red features represent the features in FKAA The highlighted cyan features are selected because they are within a distance of the red fe oe 55 Section 12 17 Select By Location 21xi Lets you select features from one or more layers based on where they are located in relation to the features in another layer want to select features from the following layers FKAA E Roads Vivacresdev y that ae within a distance of v the features in this layer Roads y JP Use selected features 0 features selected JV Apply a buffer to the features in Roads of 50 000000 Feet Preview The red features represent the features in Roads The highlighted cyan features are selected because they are within a distance of the red features S SNA Select for parcels with no
12. First the Scenario Report is a compilation of carrying capacity indicators and other information that can be interpreted to derive an assessment of the user defined scenario The Scenario Report is the primary reporting mechanism for the CCIAM It is intended to be a stand alone document that can provide the planner with the information he or she needs to evaluate their scenario Explanatory text is included in the Scenario Report to assist the planner in interpreting the results produced by the CCIAM Second the Model Output Listing is a report that compiles all of the outputs generated by the CCIAM The Model Output Listing accompanies the Scenario Report to provide supporting information resulting from the CCIAM It is organized by CCIAM modules and has limited explanatory text Overview of the Routine Planning Tool RPT The Routine Planning Tool RPT is an ArcIMS application that is intended for more freguent use by planners and the public It provides wide access to the pertinent information compiled during the FKCCS and the various scenarios run through the CCIAM The RPT functions with ArcIMS a Java servlet connector Servlet Exec Microsoft s web server MS IIS and serves an HTML viewer using an image map service It is a light weight application served over the Internet and is not intended to serve as the model itself However data resulting from the CCIAM can be provided to the planners and the public through this applicatio
13. Library msador15 dll C WINNT system32 Microsoft Scripting Runtime serrun dll 3 Copy the contents of the DVD to the server ensure that the directory structure remains intact See Section 6 for details regarding the directory structure 4 Once the contents of the DVD have been placed on the data server check to ensure that the FKCCS mxd map document file is located at the top of the FKCCS directory 5 Check to ensure that there are five subdirectories within the FKCCS directory a Canal_ Model b data c Hurricane Model d Results e Scenario Covs 6 To ensure that the CCIAM is operational double click on the FKCCS mxd ArcMap will open and load the FKCCS mxd into the application 7 Refer to the CCIAM User s Manual for instructions on the operation of the CCIAM 17 Section 9 Microsoft Excel Option Settings The CCIAM uses Microsoft Excel files for both the Hurricane Evacuation and the Canal models In order for the VBA code to run correctly the Excel option settings must be set Open Microsoft Excel select Tools Options and the Options window will be displayed Two settings have to be checked First go to the Edit tab and make sure the settings are the same as those displayed below Note The Ask to update automatic links check box should NOT be checked Figure 9 1 Florida Keys Carrying Capacity Study 18 Carrying Capacity Impact Assess
14. Section 6 Geodatabases e Scenario_lu mdb Scenarios mdb SIF mdb Terrestrial mdb Water mdb In the example below the c Web Report and the sgl Web Report are the scenario directories These two directories contain all of the report results HTML reports jpg maps etc for the scenarios Figure 6 3 EX 2 05166_USACE_FKCCS D012_finalmodel FKCCS Results Ol x File Edit Yiew Favorites Tools Help Back gt Search QFolders History GS B gt Address G 2 405166_USACE_FKCCS D012_finalmodel FKCCS Results y Go Folders x C FKCCS a Canal_Model c Web Report Canal Results mol layer files 4 0 data Hurricane Model Ci report layer files a ts Report Template El Scenario Cows sal Web Report 2 FKCC5 51to55 Terrestrial GRIDS A FROCS_s3 2 Scenario_lu mdb From P il 21 Scenarios mdb Graphic 2 SIF mdb Manual_Revisions E Terrestrial mdb 03 smms_metadata Water mdb 9 03 do4 pubworkshop FI info ES M 12 object s Disk free space 12 0 GB 2 70 GB Internet The Canal Model directory contains the ten Excel spreadsheet canal results and the associated Loading xls spreadsheet Each canal spreadsheet 1s linked to the Loading xls spreadsheet To view the canal results first open the Loading xls file
15. XML FILES Upon completion of the analysis portion of the CCIAM a blank HTML directory template is copied to the FKCCS results directory and renamed to the scenario identification number Figure 10 5 29 Figure 10 5 PX 2 05166_USACE_FKCCS D012_finalmodel FKCCS Results c_Web_Report Web_Files Images Maps E ol xj File Edit View Favorites Tools Help Ea back gt E Asearch 2 Folders History G GE X wy Fel Address m 2 05166_USACE_FKCCS D012_Finalmodel FKCCS Results c_Web_Report Web_Files Images Maps gt Go Links gt Folders x a Fkccs pe HY cL_STN ipg H O data Ac L_STP jpg 61 03 Hurricane_Model BY c_L_WTN jpg EHO Results 2Y c_L_WTP jpg c Web Report This folder is Online 8 c_M_STN jpg E Web Files f c M STP jpg H _vti_enf Select an tem to view its description EG M_WTN jpg i gt ell See also A c M WTP jpo T E Charts My Documents 8 c_P01_BWV jpg 3 My Network Places Bf c_P01_DiH jpg L HY c_PO1_DIU jpa 1 0 Tables My Computer Bf c_PO1_HAA jpg HY c_PO1_HAC jpg 8 c_PO1_HBP jpg F mol layer files F report layer files FJ Report Template H E sg Web Report Ac Po HEIS jpa H Ga Terrestrial GRIDS c POL HGL jpo E a Scenario Covs hd 4 1 034 object s Disk free space 15 0 GB 740 MB Internet The layer files in the FKCCS Resultsimol layer filesiwater loads directory are created through VBA code whereas all the other layer
16. current structure Florida Keys Carrying Capacity Study 8 Carrying Capacity Impact Assessment Model Maintenance Model Table 6 1 Dataset Name File Name in YFKCCS data Advanced Identification of Wetlands Overlay of Advanced Identification of Wetlands and basins Wasteshed Basins Overlay of planning units and basins Benthic communities of the Florida Keys Overlay of Advanced Identification of Wetlands and basins for the canal module Wasteshed Basins for the canal module Conservation and Recreational Lands Grid to re class unnecessary richness values in the water Topography Florida Keys Agueduct Authority Customer Locations Key deer habitat Mile Markers on U S 1 Lower Keys marsh rabbit habitat Municipalities of the Florida Keys Monroe County Property Appraiser s Parcels Grid of planning units Planning units Historical vegetation Propeller scars in seagrass Silver Rice Rat habitat Species richness grid Grid of a Euclidean distance from roads Grid of roads Roadway line work South Florida mainland Official shoreline of the FKCCS FKCCS study area Monroe county subdivisions Line work for US1 White crowned pigeon habitat Potential habitat grids adid adid basins basins basins units benthics canal adidbas canal basin carl clipwater fema fkaa pts keydeer milemarkers mrabbit municipality parcels planunitland planunits primitiveveg propscars ricerat rich roadd
17. determine the primitive vegetation type AGGCODE for each unique RE2 number in the parcels coverage see Figure 11 2 Figure 11 2 Contents Preview Metadata OBECN CODE DD DES 191 fu Freskiale Wetlands E 3 i 20 sw Saltwater Wetlands R 13 21 bb Beach Berm E 20 22 ha Hammocks A 21 23 pi Pinelands i 22 24 wa Water L Record 14 1 gt af Show All Selected Reco Preview Table ha Entire table contains 69 745 records The Z PrimVeg LUT table was created manually using the following steps 1 Identity of parcels with primitiveveg to create parc_prim at Arc Info prompt 2 Summarize parc_prim on RE2 Max Area First AGGCODE to create PrimVeg dbf using ArcMap 3 Summarize parc_prim on RE2 Sum Area to create PrimVeg2 dbf using ArcMap 4 Table join of PrimVeg dbf and PrimVeg2 dbf using RE2 as common field add a new field named perc calc perc Max Area Sum Area if perc lt 0 5 then calc AGGCODE wa else calc AGGCODE First AGGCODE using ArcView 5 Import the table created in step 4 into the Scenario_lu mdb geodatabase using ArcCatalog To summarize the primitive vegetation type will be changed to water wa for the entire parcel if the largest polygon is less than half the area of the parcel or else the primitive vegetation type will be changed to whatever the largest polygon
18. habitat constraints by selecting for parcels that intersect the ADID description of developed or description of exotics Calculate HABITAT 1 Select By Attributes ax Query Wizard Layer ADID Fields Unique sample values Ter O Soe ee ES DESCRIPTION lx Eal KEY_SEGMENT N 78 SOL Info Complete List SELECT FROM adid polygon WHERE CODE NS 80R CODE NS 4 Clear Verify Help Load Save oee Select parcels within 50 feet of the selected roads Florida Keys Carrying Capacity Study Carrying Capacity Impact Assessment Model Maintenance Model 56 2 Select By Location 21xj Lets you select features from one or more layers based on where they are located in relation to the features in another layer want to select features from y the following layers JFK A A Roads v vacresdev y that the features in this layer ADID ps V Use selected features 998 features selected T Apply a buffer to the features in ADID of 50350 000000 Fe y m Preview The red features represent the features in ADID The highlighted cyan features are selected because they intersect the red features oO Points 18 Visually inspect the VACRESDEV with the FEMA coverage Very few intersect the X zone Most intersect the AE zone Manually calculate the FEMA item according to the flood zon
19. http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName BaseMap var imsURL http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName BaseMap var imsOVURL var imsOVURL http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName BaseMap 6 Edit the aimsPrint js file to change the name of the server Figure 13 3 66 Figure 13 3 Winl document writeln lt IMG SRC http ursims Website rpt images FKCCSsmall gif width 75 HSPACE 10 VSPACE 0 BORDER 0 BORDERCOLOR white ALT ALIGN middle gt lt TD gt Table 13 2 Map Service Name AXL File Service Type Basemap C ArcIMS AXL rpt axl Image currentconditions C ArcIMS AXL currentconditions axl Image smartgrowth C ArcIME AXL smartgrowth axl Image scenario5 C ArcIMS A XL scenario5 axl Image 7 Start ArcIMS Administrator 8 Add four new map services 9 Save the website configuration and close ArcIMS Administrator 10 Type the URL of the server into the address line of a web browser to view the application 13 3 RPT Updates The RPT can be updated with new data or functionality It can also be updated with the latest version of ArcIMS If new data become available the steward can either edit the map configuration files with ArcIMS Author or build entirely new map configuration files and associated map services If new data from the CCIAM a
20. number prefix Changes the land use coverage attribute values accordingly Populates the scenario geodatabase with the user s selections collected from the forms 20 Figure 10 2 A COPY COVERAGE gt CHECKLAND CHANGE AND RE NAME WITH AVAILABILITY ATTRIBUTE SCNEARIO ID TABLE POPULATE REPEAT TASKS EE SCENARIO FOR EACH ANALYSIS DATABASE LOCATION RESULT REPORTING These five tasks may be repeated depending upon how many locations the user selects to change in their scenario At the CHANGE ATTRIBUTE TABLE step all items in the land use coverage attribute table with an NS extension have their values changed according to the user s input The letters NS refer to new scenario The items that get changed from GUI selections are noted in Table 10 1 Table 10 1 Attribute in Coverage Description LU_NS Land Use DU_NS Residential Dwelling Units DENSITY_NS Residential Density GFA_NS Non residential Gross Floor Area FAR_NS Non residential Floor Area Ratio WWT_NS Wastewater Treatment Type EDU_NS Equivalent Dwelling Unit HOTELROOM_NS Hotel Rooms 10 2 Analysis The analysis VBA code executes all of the spatial and mathematical operations of the CCIAM While the CCIAM is comprised of analysis modules terrestrial water socio economic fiscal infrastructure and canals the VBA code is also organized into modules Further discussions will refer to the CCIAM analysis modules as an
21. pre processing the parcel data Planning unit key segment cross reference Planning unit key segment used for cross tab queries List of feature classes to load for median calculation Lost of habitat categories List of key segments List of layer files to process List of Planning Units List of average dwelling units for non residential parcels List of primitive vegetation types by RE2 69 745 unique RE2 numbers List of duplicate RE2 numbers RE2 numbers with a count greater than 1 Current conditions expenditures millions of dollars Annual debt payment millions of dollars Gov expenditures by jurisdiction millions of dollars Constants used in school costs Percent tourist dwelling units by evacuation zone Length of US1 by planning unit miles LOS thresholds for US 1 miles per hour 32 Table 10 3 Continued Geodatabase Look up Table Description SIF I Regression Coef LUT Regression coefficients for traffic equation SIF SE ConstCosts LUT Socioeconomic cost coefficients SIF SE_DemoCoef LUT Socioeconomic demographic coefficients SIF SE Employment Coef LUT Socioeconomic population employment coefficients SIF SE FloorArea LUT Socioeconomic gross floor area coefficient SIF SE_MCPD_LUT Socioeconomic Monroe County census statistics SIF SE PropertyValues LUT Taxable value coefficients SIF SE PU LUT List of planning units SIF SE WageRates LUT Annual wage rates SIF SE Construction Cos
22. the municipality layer to determine which jurisdiction the parcel belongs to Calculate the attribute accordingly EVAC Assign parcels to hurricane evacuation zones Manual activity Assign parcels to hurricane evacuation zones according to 44 Table 12 1 Items in the CCIAM Parcel Attribute Table Continued Item in Attribute Table Description of Item Method to Calculate the Value the Miller Consulting Hurricane Evacuation Report ZONE Assign zoning to each parcel GIS process Link the zoning field obtained from the MCPA to the parcels using RE2 as the unique identifier ACRES Calculate acreage for each parcel GIS process Run a frequency on RE2 and area Add an item IACRES to the frequency table and calculate ACRES AREA 43560 Do a JOINITEM back to the parcel attribute table using RE2 as the unique identifier SQFOOTAGE Calculate the square footage for each parcel GIS process Run a frequency ion RE2 and area Add an item SQFOOTAGE to the frequency table and calculate SQFOOTAGE AREA Do a JOINITEM back to the parcel attribute table using RE2 as the unigue identifier LU Calculate land use categories Manual activity See the land use categories Table 10 2 Select the PC codes and calculate the LU accordingly HOTEL ROOMS Assign hotel rooms to parcels Manual activity Calculate dwelling units per DU_AV
23. the Stormwater to Surface Loads operations to calculate the stormwater surface loads and places the statistics table in FKCCS results water mdb Note that various look up tables are used in these SQL statements These look up tables are itemized in Section 10 4 of this manual 25 Wastewater to Groundwater Loads A UNION operation is performed with the scenario land use coverage located in FKCCS scenario_covs and the BASINS coverage located in FKCCS data to produce a feature class located in FKCCS results water mdb SQL statements are executed using this feature class to calculate the wastewater to groundwater loads and place the statistics table in FKCCS results water mdb Note that various look up tables are used in these SQL statements These look up tables are itemized in Section 10 4 of this manual If the wastewater master plan is selected by the user then the wastewater treatment types are changed accordingly during the land use change phase of the GUI operation Potable Water Demand SQL statements are executed using various look up tables and dwelling unit data from the WW_ Ground Table located in FKCCS results water mdb Statistics tables are placed in FKCCS results water mdb The look up tables are itemized in Section 10 4 of this manual Potable Water Costs SQL statements are executed using various look up tables that are itemized in Section 10 4 of this manual Statistics tables are placed in FKCCS results water md
24. 0 Memory RAM 1 512 MB DRAM Hard Drive Space 80 GB Networking Fiber optic networking capabilities Other Tape back up system or an equivalent back up plan Note Microsoft Access and Excel 2000 are required Microsoft Office 2000 in order for the CCIAM to run Access is required for the geodatabases and Excel is required for the Hurricane Evacuation and Canal modules 5 2 RPT The RPT is a lightweight ArcIMS application that serves interactive maps using an HTML viewer and an image map service The RPT was developed using the following computing infrastructure Web Server Microsoft IIS Java Servlet Servlet Exec Mapping Software ArcIMS 3 1 OS Windows NT Server 4 0 Hard Drive Space 20 GB Networking Internet Service Provider or access to a T1 connection Directory Structure The CCIAM all of the input data and all of the results are contained within the FKCCS directory This directory contains five subdirectories Canal Model e Data e Hurricane Model e Results Scenario Covs The map document file FKCCS mxd contains the VBA code to run the GUI analysis and reporting of results The FKCCS mxd is the model and it refers to all of the directories within the FKCCS directory It must be located in FKCCS in order for the CCIAM to execute correctly Additional information regarding the contents of the FKCCS mxd is in Section 9 5 6 1 Canal_Model Directory The FKCCS Canal_ Model dire
25. 0 0 00 0 80 0 60 HMDR 16 00 0 00 1 00 0 60 HHDR 22 00 0 00 1 00 0 60 HRCC 1 22 00 0 00 1 00 0 70 HRCC 2 8 00 0 00 1 00 0 60 HRCC 3 22 00 0 00 1 00 0 60 HNC 1 16 00 0 00 1 00 0 60 HNC 2 16 00 0 00 1 00 0 60 HNC 3 16 00 0 00 1 00 0 60 HCT 22 00 0 00 1 00 0 70 HRO 16 00 0 00 1 00 0 60 HPS 0 00 0 00 1 00 0 50 52 Table 12 3 Zoning Classifications and Land Development Standards Continued ZONE MAX RES DEN MAX HOTEL MAX FAR ZONE OSR HPRD 22 00 0 00 1 00 0 50 PS 0 00 0 00 0 80 0 50 A 0 00 0 00 0 80 0 00 C OW 0 10 0 00 0 01 0 95 C TW 0 10 0 00 0 01 0 95 C UH 0 10 0 00 0 01 0 95 C FW 0 10 0 00 0 01 0 95 CM 0 10 0 00 0 01 0 95 12 2 Residential Developability Suitability Guidelines Each developable vacant residential parcel has been assigned a value of one through four with one representing parcels that are most suitable for development and four representing parcels least suitable for development Details regarding the rationale and methods of this developability suitability analysis can be found in the Delivery Order 11 report There are four instances where this analysis may have to be performed to update the developability suitability information The spatial accuracy of the parcels is greatly improved and therefore enhances the habitat constraints portion of the analysis Note that the contractor has already manually moved the parcels GIS data See Se
26. 00 meters of developed areas The RISK attribute for those records is updated with a value of 1 The resultant feature class is located in FKCCS results terrestrial mdb SQL statements summarize the data and place two statistics tables in FKCCS results terrestrial mdb Water Stormwater to Surface Loads A UNION operation is performed with the scenario land use coverage located in FKCCS scenarios and the ADID BASINS coverages located in FKCCS data that produces a new feature class named ADBas located in FKCCS results water mdb SQL statements are executed using this feature class to calculate the stormwater surface loads and place the statistics table in FKCCS results water mdb Note that various look up tables are used in these SQL statements These look up tables are itemized in Section 9 4 of this manual If BMPs are selected by the user then the loads are reduced according to those selections using the W SWBMP LUT look up table The BMP reductions are applied on a per planning unit basis If the stormwater master plan is selected by the user then the loads are reduced according to the Retention BMP in the W SWBMP LUT look up table and is applied to all planning units Note BMP reductions are ONLY applied to records which show a land use change and are uplands these records make up a small subset of the total stormwater records Stormwater to Groundwater Loads SQL statements are executed using the feature class created in
27. CCS mxd The FKCCS mxd contains 32 forms These forms make up the Graphical User Interface also referred to by the acronym GUI The forms provide a front end to allow the user to build a custom land use scenario which can then be analyzed by the CCIAM The forms gather the users selections which are then saved to the Scenarios mdb database located in the FKCCS Results directory To actually see images of all the forms please refer to the User s Manual under CCIAM Step by Step Guidelines The 32 VBA forms are shown in Figure 10 8 below Figure 10 8 Ex Project project E a FrmBuildScenario frmChangeFrom Cat frmChangeTo Cat frmCreateMaps frmCreateScenario frmDataPrep frmEnvInterventions frmFinished frmFromCom frmFromind frmFromInst frmFromRes frmFromWvYac frmHurricane FrmHurricaneLanes frmLoop frmMasterPlans frmQueryMessage frmQueryMessage_RUNCCIAM frmQueryMessageN5 frmRestoration frmRunCCIAM_NOGUI frmScenarios FrmScenSelections frmScenType frmStatsError frmToCom frmTolnd frmTolnst frmToRecOS frmToRes frmUsedPrefixes v Florida Keys Carrying Capacity Study Carrying Capacity Impact Assessment Model Maintenance Model 38 Restoration Scenarios The restoration scenario reguires its own section because it is a special case Different procedures are called in the Analysis modules if the scenario is a restoration scenario The GUI will change all selected parcels to open spa
28. E See dwelling unit guidelines parcel A Manual activity Divide the DENSITY Calculate residential density du ave by ACRES Calculate residential suitability RES_SUIT for development on vacant See suitability guidelines parcels NONRES_SUIT Calculate non residential suitability for development on vacant parcels See suitability guidelines MAX ALLOW DU Calculate maximum allowable dwelling units for vacant residential parcels Manual activity Select vacant residential parcels and multiply ACRES by the allotted dwelling units according to the ZONE value 45 Table 12 1 Items in the CCIAM Parcel Attribute Table Continued Item in Attribute Table Description of Item Method to Calculate the Value See the zoning allotted density table MAX FLOORAREA Calculate maximum allowable gross floor area for vacant non residential parcels Manual activity Select vacant non residential parcels and multiply SOFOOTAGE by the allotted floor area according to the parcel s ZONE value MAX_HOTEL Calculate maximum allowable hotel units for vacant commercial parcels Manual activity Select vacant commercial parcels and multiply the ACRES by the allotted hotel units according to the ZONE value REDEV_VALUE Calculate the ratio of the building taxable value to the land taxable value Manual activity Divide PBLDG1 by PLAND1 Manual activity visually
29. FLORIDA KEYS CARRYING CAPACITY STUDY Carrying Capacity Impact Assessment Model and Routine Planning Tool Maintenance Manual March 2003 This report was prepared by URS Corporation formerly Dames amp Moore Inc for the U S Army Corps of Engineers and the Florida Department of Community Affairs Funds for this study were provided under U S Army Corps of Engineers Contract No DACW17 99 D 0058 Delivery Order 12 Test CCAM 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 13 0 14 0 PURPOSE AND ORGANIZATION OF THIS MANUAL o 1 INTRODUCTION TO THE FLORIDA KEYS CARRYING CAPACITY STUDY AA O zalo ld ath cu doo os drsn vosy 2 OVERVIEW OF THE CARRYING CAPACITY IMPACT ASSESSMENT MODEL GC ao E e o NS P o 3 OVERVIEW OF THE ROUTINE PLANNING TOOL RPT 4 COMPUTING SPECIFICATIONS ninia 5 51 CCUM A O O O Pe e PoP ent 5 5S2 AB Iz a do P ka k k A o ooo Pot o de pok ooo aan 6 DIRECTORY STRUCT URE ui as 7 6 1 Canal Model Directory sas aii 7 6 2 Data DI dl ob 8 6 3 Hurricane Mod ol 10 64 Res lts Directory dod ea a E a 9 n 10 6 5 Scenario COVE a das aale E dd A st ak 13 NAMING CONVENTION Ss e ie 14 CCIAM INSTALLATION PROCEDURES stessiianiai ia 16 MICROSOFT EXCEL OPTION SETTINGS eee 18 CCIAM MODELING SEQUENCE AND STRUCTURE o 20 10 1 Graphical User ia dl a e lo o 20 K2 A STS ooo oo ano o A ROB acs o A nd E 21 10 5 RESUIERE POMO 3 3 s2zsacotsk as na dyazkue ak a dat bann NR odk REAT ESEN 29 104 Loo
30. If the application stops in the middle of code execution the FKCCS mxd project should not be saved when closed The code creates objects and adds these objects to the layout view Ifthe FKCCS mxd project is saved then these objects will get saved which means the FKCCS mxd project will not be in its pre run set up state If the code runs through without stoppage then it is OK to save the FKCCS mxd 36 Section 10 The VBA modules are shown in Figure 10 7 below Figure 10 7 Eele Modules a a Analysis Module 2 a Canal Mod Rest 2 a Canal Run Excel 2 a ChangeTo_Method2 a a Create Water Layer Files ee a Fiscal Stats 2 a Hurricane Evac GA a Level of Service 2 a Main Module g a_modFromQuery 2 a_modFunctions j v a_modParamCode 2 a modPublicSettings a a Save Scenario to Access 2 a Soc Economic Mod i a_Socio_Economic_Stats i 4 a_Terrestrial_Impacts_Rest 2 a Terrestrial Mod Rest A A a_Terrestrial_Species_Rest iG a Terrestrial Stats Mod Rest la Water Module Rest v a Water Stats Rest 2 Result Create JPG Files Median 22 Result Gen Folders og Result Infra SOL At Result LU SOL 2 Result Run Map Creation 2 Result Scenarios SOL iG Result Terr SOL ow Result Water SOL it Result XMLOueries La Florida Keys Carrying Capacity Study Carrying Capacity Impact Assessment Model Maintenance Model Section 10 10 6 Description of VBA Forms in the FK
31. alysis modules and references to the VBA code will be VBA modules 21 Section 10 The order of analysis module execution is terrestrial water canals socio economic fiscal infrastructure and hurricane Figure 10 3 Each module is further broken down into components The components specific to a module are itemized in the order they are executed with the module box Figure 10 3 RESULT REPORTING Note that the arrows in Figure 10 3 do not represent dependencies or data transfers between analysis modules Information regarding the placement and structure of the data resulting from the analysis modules is provided in Section 6 The following analysis module descriptions briefly outline the process and data used for each computation in the CCIAM Terrestrial Module Species richness Developed parcels from the scenario land use coverage in FKCCS scenarios are selected converted to a temporary grid as a recordset reclassified to zero and multiplied with the ROADGRID grid This temporary grid is added to the CLIPWATER grid and then multiplied with the species rich grid located in FKCCSWata The resulting grid is placed in FKCCS results species_grids Zonal statistics are created using the Florida Keys Carrying Capacity Study 22 Carrying Capacity Impact Assessment Model Maintenance Model PLANUNITLAND grid and the resultant richness grid This statistics table is placed in the terrestrial geodatabase locat
32. arameters for the RPT are itemized in Table 13 1 Table 13 1 Map Configuration File C ArcIMS AXL rpt axl C ArcIMS AXL currentconditions axl C ArcIMS AXL smartgrowth axl C ArcIMS AXL scenario5 axl Map Services Note Image map services only basemap uses rpt axl Current conditions uses current conditions axl smartgrowth uses smart growth axl scenarioS uses scenario5 axl ArcIMS website C ArcIMS website rpt Shapefiles E rpt basedata E rpt currcondition E rpt smartgrowth E rpt scenario5 Homepage and associated HTML files C Inetpub wwwroot fkccs 13 2 Installation Procedures 1 Install ArcIMS 3 1 according to the software documentation This installation assumes that the steward is using a Java Servlet connector and Microsoft IIS webserver 2 Copy the contents of the RPT DVD to the appropriate locations on the server a Copy the AXL files to C ArcIMS AXL b Copy the rpt directory to C ArcIMS website c Copy the shapefile directories rpt basedata rpt currcondition rpt smartgrowth rpt scenarioS5 to a local drive on the server Note that you will have to re path the AXL files if the data are not placed on the EX drive 3 Copy the contents of the fkccs directory to C Inetpub wwwroot 4 Re path the AXL files within the lt WORKSPACE gt tags Figure 13 1 Figure 13 1 lt WORKS PACES gt lt SHAPEWORKSPACE
33. b Potable Water Aquaduct Adequacy SQL statements are executed using various look up tables that are itemized in Section 10 4 of this manual Statistics tables are placed in FKCCS results water mdb Stormwater and Wastewater Costs SQL statements are executed using various look up tables that are itemized in Section 10 4 of this manual Statistics tables are placed in FKCCS results water mdb Stormwater Wastewater and Groundwater Flows SQL statements are executed for each of the flow calculations using the feature classes noted in the analysis to calculate each load Statistics tables are placed in FKCCS results water mdb Socio economic The scenario land use coverage located in FKCCS scenario_covs is converted to a feature class and placed in FKCCS results scenario_lu mdb All of the socio economic SQL statements are performed on this feature class The resulting statistics tables are placed in the SIF mdb geodatabase Note that various look up tables are used in these SQL statements These look up tables are itemized in Section 10 4 of this manual 26 Fiscal SOL statements are executed using data from the water cost analysis and the socioeconomic module to produce government costs tables in the SIF mdb geodatabase Note that various look up tables are used in these SOL statements These look up tables are itemized in Section 10 4 of this manual Infrastructure Level of Service on U S 1 SQL stateme
34. ce restored and all other NS fields to zero except WWT NS wastewater treatment type which will remain as is The land use open space restored was added to the W_LU_LUT lookup table in the Water mdb geodatabase All feature classes created had to have the CODE_NS from Adid coverage and DESCRIPTION fields changed to the primitive vegetation type which comes from the Z PrimVeg LUT lookup table in the Scenario_lu mdb geodatabase for restored parcels The problem occurred because not all feature classes had the CODE_NS field 1t was not needed in some feature classes for non restoration scenarios Therefore some additional unions had to be performed for restoration only As well all the SQL statements run on the CODE_NS field had to be modified to pick up the new primitive vegetation types The T Adid LUT lookup table in the Terrestrial mdb had to be updated to reflect the six primitive vegetation types as shown below Figure 11 1 Contents Preview Metadata OBJECTID __RE2_ AGGCODE E 14 150 sw E 15 160 ha E 16 170 sw E 17 180 ha C 18 200 0001 ha C 19 200 000101 ha i 20 200 000102 ha E 21 200 000104 ha E 22 200 000106 ha E 23 200 000111 sw E 24 200 000112 sw Rather than perform a union with the primitiveveg coverage a new lookup table was created named Z PrimVeg LUT located in the Scenario lu mdb geodatabase This lookup table is used to
35. ction 10 1 for more information The land cover attribute data ADID are updated to include descriptor information regarding the guality of the vegetation Monroe County includes habitat guality in their assessment of development suitability This was not performed in the CCIAM due to the lack of available data The land cover data are delineated with an emphasis on determining the true extent of developed areas Currently areas of vegetation that may lie throughout the developed ADID polygons are simply coded as developed in the ADID attribute table See Delivery Order 10 for more details 53 GIS data regarding potable water and electricity hook ups becomes available and is appropriate to use in that portion of the suitability analysis which determines vacant parcels access to infrastructure The following list itemizes the steps taken to determine the residential suitability rankings for vacant residential parcels 1 10 11 Select vacant parcels from the data parcels coverage to create VACPARCELS Perform an IDENTITY operation on VACPARCELS and ADID to produce VACADID Join the Z ZONE LUT to VACADID using the ZONE item Join Z_HabitatOSR_LUT to VACADID using the CODE_NS item Add an item DEV RATIO Compare the open space values from the zoning and the habitat Calculate DEV_RATIO equal to the most stringent of the two open space ratios Add an item POLY ACRE and calc POLY ACRE equal to AREA
36. ctory contains the canal model Microsoft Excel spreadsheets developed by URS Corporation The canal model consists of ten canal spreadsheets one loading spreadsheet and one tide stations spreadsheets The application will copy these files replace the inputs run the Excel macros and place the results in the FKCCS Results Canal_ Results directory For a detailed discussion of the Canal model refer to the Canal Report Section 6 Figure 6 1 2 105166 USACE RA Model File Edit View Favorites Tools Help x 117 Plantation Model xls Canal_Model 3 152 Lower Matecumbe Model xls H E data 24204 Marathon Model xls Hurricane Model 4208 Marathon Model xls H Results 34246 Marathon Model xls BMY Scenario_Covs 41268 Big Pine Model xls O FKCCS_sitoss 26339 Little Torch Model xls B PKCCS 53 150 Key Largo Model xls From Phil 26 69 Rock Harbor Model xls Graphic m 4170 Rock Harbor Model xls 1 03 Manual_Revisions Loading xls 1 03 smms metadata E 20 do4_pubworkshop 4 Loading_Copy xls a info Tide Stations xls HC Oct 15 E 13 object s Disk free space 11 9 GB E 3 45 MB Internet 6 2 Data Directory All of the input GIS data required for the CCIAM to operate are located in the FKCCS data directory Table 6 1 These data include both vector and raster datasets When these data get updated the dataset name item definitions in the attribute tables and location must conform to the
37. d an item ACRES to the frequency table and calculate ACRES AREA 43560 Do a JOINITEM back to the parcel attribute table using RE2 as the unique identifier Run a frequency on RE2 and area Add an item SQFOOTAGE to the frequency table and calculate SQFOOTAGE AREA Do a JOINITEM back to the parcel attribute table using RE2 as the unique identifier Select the vacant residential parcels PC 00 and calculate MAX ALLOW DU ACRES DENSITY for each zoning value See Table 12 3 for zoning allocation Select the vacant non residential parcels PC 10 40 70 and calculate MAX FLOORAREA SOFOOTAGE 49 18 19 20 21 22 23 24 25 26 27 28 GFA for each zoning value See Table 12 3 for zoning allocation Select the vacant commercial parcels PC 10 and calculate MAX HOTEL ACRES HOTEL DENSITY for each zoning value See Table 12 3 for zoning allocation For the DU_AVE item do not update unless there are new CENSUS data or the MCPA refines its method of accounting for dwelling units in the tax roll The steward should maintain close coordination with the MCPA and Monroe County planners See the dwelling unit guidelines for information regarding this procedure Divide the DU AVE by ACRES to obtain DENSITY This should only be performed if there has been a change to the number of dwelling units or the size of the parcels See the suitability guidelines to calculate RES_SUIT
38. description of the action 34 Table 10 4 Number of Procedures CCIAM Step Module Name Description Functions GUI a Save Scenario to Access Save GUI selections to the 14 scenarios mdb GUI a modFromOuery Get the land use From 6 selection set GUI a modParamCode Form opening and closing 4 seguence GUI a ChangeTo Method2 Change the NS fields in the 32 xx lu parcels coverage Analysis amp GUI a_modPublicSettings Listing of public functions and 19 procedures used throughout the CCIAM Analysis a Create Water Layer Files Creates layer files for SW and 9 WW loads Analysis a Analysis Module Contains the union procedure 1 Analysis a Fiscal Stats Calculates all the fiscal statistics 11 Analysis a Hurricane Evac Runs the Hurricane Excel 4 spreadsheet Analysis a Level of Service Calculates the level of service 5 statistics Analysis a_Main Module Used to call the main procedures 1 Analysis a_modFunctions Contains 3 functions e g get 8 developed parcels Analysis a Soc Economic Mod Import the land use coverage into 1 scenario_lu Call main Socio procedures Analysis a Socio Economic Stats Calculates all the socio economic 27 statistics Analysis a Terrestrial Impacts Rest Create indirect impact rasters 11 Analysis a Terrestrial Mod Rest Call terrestrial union and statistic 2 procedures Analysis a Terrestrial Species Rest Create habitat species feature 8 classes for LKMR Rice Rat WCP Analysis a Terrestr
39. ds that result from the terrestrial analysis It contains seventeen potential habitat grids and one species richness grid for each scenario run The Scenario_lu mdb geodatabase contains the feature classes of each scenario s land use layer and summary table These feature classes are identical to the land use coverages for each scenario in the FKCCS scenario_covs directory The socio economic module uses an ADO connection to the Scenario_lu mdb to execute the SQL queries on the feature class Therefore each scenario land use coverage is imported into this geodatabase This geodatabase also contains the US1 feature class used in the GUI spatial queries The Scenarios mdb geodatabase houses all of the user s selections from the GUI and contains no spatial data Prior to executing the analysis VBA code all of the user s GUI selections are written to this database All of the socio economic fiscal and infrastructure results are located in the SIF mdb geodatabase There are no spatial data in this database The terrestrial feature classes and statistic tables are housed in the terrestrial mdb geodatabase This geodatabase and the terrestrial GRIDS workspace comprise all of the terrestrial results 12 The Water mdb geodatabase contains all of the wastewater stormwater potable water and canal feature classes and tables including cost tables It also contains twenty lookup tables ending in LUT 6 5 Scenario Covs The Scena
40. e for the parcel 19 Select for parcels in VACRESDEV that have a SUB ID2 value greater than zero Calc SUBDIV equal to 1 20 Addan item called RES SUIT Calculate RES SUIT with a 1 2 3 or 4 based on Table 12 4 Table 12 4 SUBDIV POT H20 HABITAT FEMA Ranking 1 0 1 0 1 0 X AE V 1 X X X X 1 X X X X 2 X X X X 2 X X X X 2 X X X X 2 X X X X 2 X X X X 3 X X X X 57 12 3 Non Residential Suitability Guidelines Each developable vacant non residential parcel has been assigned a value of one though four with one representing parcels that are most suitable for development and four representing parcels least suitable for development Details regarding the rationale and methods of this developability suitability analysis can be found in the Delivery Order 11 report The steps to calculate the non residential suitability for vacant non residential parcels is identical to the residential suitability methods with the exception of three items 1 Location within a subdivision is not a criterion for non residential development Do not make these selections and calculations 2 Access to potable water and electrical infrastructure is not a criterion for non residential development Do not make these selections and calculations 3 Adjacency to US 1 is a criterion for non residential development Add an item UST and visual
41. ed in FKCCS results terrestrial mdb Potential Habitat 17 species Developed parcels from the scenario land use coverage in FKCCS scenarios are selected converted to a temporary grid as a recordset reclassified to zero multiplied with the ROADGRID grid This temporary grid is added to the CLIPWATER grid and then multiplied with each species potential habitat grid located in FKCCSWatalspecies_grids The resultant grid is placed in FKCCS results species_ grids Direct Impacts to Habitat Developed parcels from the scenario land use coverage in FKCCS scenarios are selected to create a recordset A UNION operation is performed with this selected record set and the ADID coverage located in FKCCS data The CODE NS field for those areas that became developed is updated with a value of 8 The resultant feature class is located in FKCCS results terrestrial mdb SQL statements summarize the data and place a statistics table in FKCCS results terrestrial mdb Indirect Impacts to Habitat Developed parcels from the scenario land use coverage in FKCCS scenarios are selected converted to a temporary grid as a recordset and a EUCLIDEAN DISTANCE operation is performed The recordset is multiplied with the ROADDIST grid and then reclassified to one A UNION operation is performed with the recordset and the ADID coverage located in FKCCS data The CODE_NS field for those areas that became developed is updated with a value of 8 The resulting fea
42. elected record set and the LKMR coverage located in FKCCS data The HABITAT attribute for those areas that became developed is updated with a value of 0 A spatial query is performed to select additional habitat patches that are within 500 meters of developed areas The RISK attribute for those records is updated with a value of 1 The resultant feature class is located in FKCCS results terrestrial mdb SQL statements summarize the data and place two statistics tables in FKCCS results terrestrial mdb 24 White Crowned Pigeon Developed parcels from the scenario land use coverage in FKCCS scenarios are selected to create a recordset A UNION operation is performed with this selected record set and the WCP coverage located in FKCCS data The ADULT and JUV attributes for those areas that became developed is updated with a value of 0 The resultant feature class is located in FKCCS results terrestrial mdb SQL statements summarize the data and place juvenile and adult statistics tables in FKCCS results terrestrial mdb Silver Rice Rat Developed parcels from the scenario land use coverage in FKCCS scenarios are selected to create a recordset A UNION operation is performed with this selected record set and the RICERAT coverage located in FKCCS data The HABITAT attribute for those areas that became developed is updated with a value of 0 A spatial query is performed to select additional habitat patches that are within 5
43. esents the unique scenario ID or prefix The data in these two tables serve as the inputs into the canal Loading xls spreadsheet The feature classes and tables for the canal model are located in the Water mdb geodatabase The second part to the canal model involves copying the results from the WW and SW final tables into the Loading xls file load and flow data per watershed ID then doing a save as saving the file as xx_Loading xls Next each individual canal Excel file is opened the macros enabled the link established with xx_Loading xls and the Model Reset and 27 Flush Model Excel macros are run The file is then saved using the new scenario prefix example sgl 208 Marathon Model xls where sgl represents the scenario prefix This is repeated ten times once for each canal Excel spreadsheet For a more detailed discussion of the canal model please refer to the canal report Additional information regarding each analysis module can be found in the delivery order report pertaining to that part of the FKCCS and the FKCCS Final Report However module information specific to the operation and management of the CCIAM is noted in Table 10 2 Table 10 2 Analysis Module Operation Maintenance Comment Terrestrial e Most computationally intensive e Overlay analyses result in feature classes e Raster analyses result in ArcInfo grids Water e Two spatial overlay processes occur that result in feature classes The remaini
44. files have been created as static files that do not change with each scenario The water loads layer files are created with VBA code dynamically because they reguire a table join to a feature class before conversion to a layer file Therefore a simple change of data source will not work with these layer files to accommodate different scenarios A predetermined map layout and design is populated with the symbolized data Map titles and legends are changed using VBA and ArcObjects The layout is then exported as a JPG to the webreport web_fields images maps directory When the FKCCS mxd is opened it will have zero layers in the Data View In the Layout View the project will have a data frame neat line and FKCCS logo These three objects should never get deleted from the Layout View When the user runs the GUL three base layer files Planning Units lyr usl lyr and Roads lyr and the xx lu coverage will be automatically added to the table of contents A series of SOL statements are executed to generate statistics tables that are formatted for the Scenario Report and Model Output Listing These tables are not physical tables in the geodatabases Once the SOL guery is executed the recordset is immediately converted to XML and placed in the XML directory The data to produce the tables for the two reports are 30 generated as part of analyzing the scenario Therefore it is unnecessary to create another large set of formatted tables for t
45. g the CCIAM Table 12 1 itemizes each field where it originated and if it was derived for the CCIAM how it was calculated in the table Table 12 1 Items in the CCIAM Parcel Attribute Table Item in Method to Attribute Table Description of Item Calculate the Value RE2 Beal E atare iden heanon Obtained directly from tax roll Number NAME Name of property owner Obtained directly from tax roll PC Property Code Obtained directly from tax roll FLA Floor Living Area Obtained directly from tax roll SALE1 Last sale Obtained directly from tax roll YRBLT Year the structure was built Obtained directly from tax roll PBLDG1 Taxable value of the structure Obtained directly from tax roll PLANDI Taxable value of the land Obtained directly from tax roll PTAX1 Total taxable value Obtained directly from tax roll PLAN_UNIT Assign parcels to planning units SIS proces OST parcels and plan units KEY SEGMENT Assign parcels to key segment Manual activity Visually inspect parcels to determine if they are located in the upper middle or lower keys Calculate attribute accordingly WW_HOTSPOT Assign parcels to wastewater hotspots Manual Activity Visually inspect parcels using the maps from the CH2MHill Sanitary Wastewater Master Plan to assign parcels to hotspots Calculate attribute accordingly MUNICIPALITY Assign parcels to municipality Manual activity visually inspect the parcels with
46. grid to produce a new grid with the planning unit numbers only on land RICH species richness grid See section 6 3 ROADDIST euclidean distance grid from Perform a Euclidean distance to 500 feet roads using the ROADGRID as the source ROADGRID roads as a grid Convert the roads to a grid 62 12 7 Potential habitat richness models Potential habitat for seventeen terrestrial species were modeled and then aggregated into a species richness grid All seventeen models as ArcInfo grids and the resulting species richness grid were created based on the Florida Fish and Wildlife Conservation Commission s Habitat Needs of Rare and Imperiled Species study The steward should read the metadata associated with each model the Florida Keys Carrying Capacity Final Report and the Habitat Needs of Rare and Imperiled Species documentation prior to updating these models If the potential habitat models are updated then they are simply summed to produce the overall species richness grid 63 Routine Planning Tool RPT 13 1 RPT Architecture The steward should be familiar with the installation and operation of ArcIMS 3 1 The RPT was designed using ArcIMS manager and all of the subdirectories for this application were created in accordance with the standards outlined in the ArcIMS 3 1 documentation The RPT is a light weight application that serves shapefiles using an image map service through a HTML viewer Specific configuration p
47. he HTML reports The two HTML documents Scenario Report and Model Output Listing are located in webreport They have been built using HTML JavaScript and XML Stylesheets that point to the JPGs and XML files located in the appropriate sub directories These two HTML documents and their supporting sub directories of data constitute the reports generated for each scenario Each report can be printed It is suggested that the Scenario Report be provided to the planners in both hardcopy and digital format The Model Output Listing can be printed however it is envisioned that this report and all of its components be written to CD ROM and simply accompany the Scenario Report After the FKCCS CCIAM code is run either with or without the GUT the last step is to run the map creation code Note As mentioned in the User s Manual the creation of Jpeg maps had to be separated from the CCIAM due to limitations with the ESRI JpegExporter object When the Jpeg map generating code is run using the Maps button the code will delete all previous layers in the table of contents and add the three base layers as shown in Figure 10 6 Figure 10 6 amp FKCCS mxd ArcMap ArcInfo n xj Ele Edt view Insert Selection Tools Window Help DSHS Bx a g 10673 y x amp R B FKCCS GUL FKCCS No GUI amp Maps QQ USED Sh KHZ spatistanayst 7 v Eee
48. he imported GIS layer using RE2 as the unique identifier Drop the un necessary items from the attribute table Perform an overlay operation with the subdivision layer to get the SUB_ID2 item into the parcel attribute table Summarize the number of developed parcels and divide by the total number of parcels in the subdivisions to get the ratio for SUBDIV_PERC If necessary correct the spatial shift either manually or through a systematic process 48 10 11 12 13 14 15 16 17 Overlay with the planning units layer to get the PLAN_UNIT item into the parcel attribute table Add an item KEY_SEGMENT and manually assign parcels to key segment upper middle lower Add an item WW_HOTSPOT and manually assign parcels to wastewater hotspots using the hardcopy maps produced by CH2MHill in the Sanitary Wastewater Master Plan Load the parcels and the municipality layer into ArcInfo for viewing Add an item MUNICIPALITY and manually assign parcels to their appropriate municipality by visual inspection Add and item EVAC and assign parcels to hurricane evacuation zones using the descriptions found in the Miller Consulting Inc Hurricane Evacuation Plan for Monroe County Select PC codes and calculate LU according to Table 12 2 Link the zoning table to the parcels using RE2 as the unique identifier to get the ZONE field into the parcel attribute table Run a frequency on RE2 and AREA Ad
49. he steward should have an understanding of how these data are maintained by the MCPA The tax roll data are maintained in a Computer Assisted Mass Appraisal CAMA database The parcel GIS layer is maintained in an ArcInfo 7 x Librarian system Therefore the MCPA must extract both the tax roll as a DBF file and the parcel geometry as an ArcInfo export file for use in the CCIAM These files are large The tax roll DBF is approximately 80mb and the exported parcel geometry is approximately 450 mb Since these files have been extracted from two computing systems they must be joined using the real estate identification number RE2 Note that there can be multiple polygons for one RE2 creating a one to many relationship between the tax roll record and the parcel GIS layer Figure 12 1 Therefore it is vital that a frequency be run on RE2 to obtain the correct acreage floor area etc for each parcel A simple summary on the attribute table will result in double counting of parcels with more than one polygon 42 Section 12 Figure 12 1 Example of multiple polygons for one RE2 Noa eee b 4 tok este Nou Fenne Be got Yow sert selector Jocs ndo tep RO HOYT JOSEPH TRUSTEE 1380 HOYT JOSEPH TRUSTEE 1380 HOYT JOSEPH TRUSTEE Dasly Soace 3004 mer ROOT AY Se fo Bu A gt amp Zr se Ot the selected cementis 70 3 3710 14 Feet Both the spatial component and attribute data have been enhanced to suppor
50. ial Stats Mod Rest Run SQL s to create terrestrial 15 statistic tables Analysis a Water Module Rest Perform 2 water unions Call 1 main water procedure Analysis a Water Stats Rest Calculates all the water loads 42 flows potable water and costs Analysis a Canal Mod Rest Calculate the canal wastewater 23 and stormwater loads and flows by watershed ID 35 Table 10 4 Continued Number of Procedures CCIAM Step Module Name Description Functions Analysis a Canal Run Excel Run the 10 Excel canal models 3 and create new Excel results Result Reporting Result Create JPG Files Create jpg maps median and 40 Median values Result Reporting Result Gen Folders Create reporting directory 2 structure for new scenario copy template HTML files to web report directory Result Reporting Result Infra SOL Create XML tables for SIF 16 Result Reporting Result LU SOL Create XML table for 5 Scenario_lu Result Reporting Result_Scenarios SQL Create XML tables for Scenarios 2 Result Reporting Result Terr SOL Create XML tables for 12 Terrestrial Result Reporting Result Water SOL Create XML tables for Water 8 Result Reporting Result XMLOueries Call all XML table generating 4 modules Result Reporting Result Run Map Creation Calls jpg creation procedures 2 Note The Rest at the end of some of the names means the VBA module was modified to accommodate restoration scenarios Additional notes concerning the execution of the CCIAM
51. is Note Since the application does not actually perform a union with the primitive vegetation coverage the entire parcel will be changed to the primitive vegetation type listed in the Z PrimVeg LUT lookup table at least 50 of the parcel will consist of this primitive vegetation type 41 CCIAM Data Updates The following section describes the procedures for updating information housed in the CCIAM s personal geodatabases coverage workspaces and grid workspaces There is a clear distinction between updating the data as they are organized and structured in the current model versus adding data or changing look up table values to reflect a more current scientific understanding or user preference For example if a new land cover layer becomes available there are procedures outlined in this document to assist the steward in pre processing those data for use in the CCIAM However if new scientific understanding allows for a more refined analysis of the indirect effects of development on habitat and additional look up tables or data are required for this analysis then that is a model enhancement The steward should work closely with the Florida Department of Community Affairs South Florida Regional Planning Council and Monroe County to reach consensus on data updates versus model enhancements 12 1 Parcel Updates The Monroe County Property Appraiser s MCPA Office parcel GIS layer is the land use dataset used in the CCIAM and t
52. ist roadgrid roads sf mainland shoreline studyarea subdivisions usl wep Species GRIDS subdirectory with 18 ArcInfo grids one for each of the 17 species and one for the species richness grid 63 Hurricane Model The FKCCS Hurricane Model directory contains the Miller Consulting Inc Microsoft Excel spreadsheet model and a blank Microsoft Excel spreadsheet Figure 6 1 Figure 6 2 Folders 34 FKCCS a E DECLININGBACKTRAFF XLS Canal Model 36 HurricaneResults xls data 3 MODEL_V1 xL5 Hurricane_Model Results Scenario_Covs laa 50 7 MB 3 object s Disk free space 12 0 GB Internet The hurricane model is comprised of two related spreadsheets MODEL V1 xls and DECLININGBACKTRAFF xls Miller Consulting Inc has locked both of these spreadsheets so that their macros cannot be accessed by the user The HurricaneResults xls is a template spreadsheet where the scenario run s hurricane results are temporarily placed until they are loaded into the FKCCS results SIF mdb geodatabase 6 4 The FKCCS Results directory is comprised of five sub directories plus one directory for each scenario e g c sgl etc and five geodatabases Results Directory Directories Canal Results mol layer files report layer files Report Template Terrestrial GRIDS 10 1 E V JM m M del Maintenance Model
53. k Up Tables A As 32 10 5 Description of VBA modules in the FKCCS mxd iooocnccnoccncconcconcconacononononos 34 RESTORATION SCENARIOS ab e kosa 38 CCIAM DATA UPDATES ai di del Bado A a AR 42 121 A A Koka Ha hody ae sudo td 42 12 2 Residential Developability amp Suitability Guidelines 53 12 3 Non residential Suitability GuidelinesS ooooonccnnnnnnnccnoncnconnconncconaconnconncoo 58 124 Vacant Conservation Land Guidelines oooooconnconococoncconnnonnnconnaconocancc nnonos 59 12 5 Dwelling Unit Calibration Guide nes ba 61 12 6 PU GA iS 61 12 7 Potential habitat richness models 62514kebxsdekiso5esabbabd nese dla 63 ROUTINE PLANNING TOOL RPT 64 ISL RSE POAT CHC dadas 64 13 2 Tostadas aa 64 153 RPT Upda A a a a a k ta 67 LIST OF SUPPORTING DOCUMENTATION o eee 68 CAMA CCIAM GUI MCPA VBA Computer Assisted Mass A ppraisal Carrying Capacity Impact Assessment Model Graphical User Interface Monroe County Property Appraiser s Routine Planning Tool Visual Basic for Applications 11 Purpose and Organization of this Manual This manual provides the steward of the Carrying Capacity Impact Assessment Model CCIAM and Routine Planning Tool RPT with technical information to maintain and update these two applications Other significant documentation includes the header information within the Visual Basic for Applications VBA code the user s manual and the Florida Keys Carrying Capacity Study Final Repor
54. ly inspect the data to calculate US1 equal to 1 for those parcels adjacent to US1 Once the HABITAT US1 and FEMA items have been calculated add an item NONRES SUIT and calculate it with a 1 2 3 or 4 based on Table 12 5 Table 12 5 US1 HABITAT FEMA Ranking 1 0 1 0 X AE V 1 X X 2 X X X X 2 X X X 2 X X X 3 X X X X 3 X X x 4 X X X X 4 X X X X 58 Section 12 12 4 Vacant Conservation Land Guidelines The GUI has an option in the Change From Vacant form for a user to select vacant parcels that are within 300 feet of 10 acres of contiguous habitat or CARL lands The steps to identify these parcels are noted below 1 Select all ADID vegetation types except for developed and exotic 2 Dissolve the selected polygons Select for polys greater than or equal to 10 acres from the resulting dissolved layer 4 Buffer the selected polys in the dissolved layer by 300 feet Figure 12 2 5 Select for all PC 00 10 40 and 70 from the PARCELS coverage 6 Select by location in ArcMap to get vacant parcels within the 300 foot buffer layer Figure 12 3 Figure 12 2 vecant conservation read ArcMap Arcin o Elo UAE yew cart Selection Jose Window babo xako S hate A a Hol A SS i alla gt DESH oui JA DNS 8X ens Jgn AAnu ea Lr ome Ff 225225
55. ment Model Maintenance Model Section 9 Next go the Calculation tab and make sure the settings are the same as those displayed below Note The option button Automatic should be selected meaning that the calculations in the Hurricane Evacuation model will be made automatically whenever new inputs are entered Figure 9 2 Florida Keys Carrying Capacity Study Carrying Capacity Impact Assessment Model Maintenance Model 19 CCIAM Modeling Seguence and Structure The CCIAM executes in three general steps Graphical User Interface GUD analysis and result reporting Figure 10 1 All of the VBA code and SQL statements reside in the FKCCS mxd located in the FKCCS directory The look up tables that are referenced by the CCIAM are located in the geodatabase pertaining to that particular analysis Additional information regarding the assumptions mathematics and rationale for the CCIAM can be found in the various delivery order reports and final report for the study Figure 10 1 RESULT REPORTING ANALYSIS 10 1 Graphical User Interface The GUI completes five tasks Figure 10 2 Collects information from the user through the controls on the forms Checks the land use coverage to ensure that there is enough land available to accommodate the user s selections Copies the land use coverage to the FKCCS scenario_covs workspace and names the coverage with the scenario identification
56. n If warranted additional data layers can easily be added to this application The RPT is a by product of the overall FKCCS effort and therefore minimal customizations were made to the ArcIMS default application Computing Specifications 5 1 CCIAM The CCIAM functions using a desktop personal computer that is networked to a GIS data server and has access to ArcInfo 8 1 and Spatial Analyst licenses ESRI recommends the following system requirements for a desktop computer using ArcInfo 8 1 http arconline esri com arconline sysreqs cfm R many PID 1 Platform Intel based PC 400MHz minimum 650MHz recommended OS Windows 2000 fully supported SPI and SP 2 optional Memory RAM 128 minimum 256 recommended Hard Drive Space ArcInfo Desktop 8 1 540MB NTFS 754MB FAT ArcInfo Workstation 8 1 695MB NTFS Disk spaces do not include the SOMB of system drive space needed for installation Typically C Winnt System32 Networking Simple TCP IP Network Card or Microsoft Loopback Adapter However the CCIAM was developed using the following computing infrastructure and the contractor recommends at least this level of computing power Desktop Personal Computer Platform HP P4 1 7 GHZ OS Windows 2000 Memory RAM 512 MB RAM BUS Hard Drive Space 20 GB Networking 100BT access to ArcInfo 8 1 and Spatial Analyst licenses GIS Data Server Platform HP LC 2000 Dual P3 866 Mhz RAID 5 OS Windows 200
57. n of Layer Reguired Pre Processing ADID land cover Add an item for planning units overlay of land cover and IDENTITY operation with ADID and ADID RASINS ysins BASINS ADIDFIN DO7 historic vegetation No Action BASINS wastesheds watersheds No Action BASINS UNITS overlay of basins and planning units IDENTITY operation with BASINS and PLANUNITS FEMA FEMA flood zones No Action KEYDEER key deer habitat Add an item HABITAT and calculate all habitat polys to 1 Add an item HABITAT and calculate all lower keys marsh rabbit gt gt MRABBIT habitat a habitat polys to 1 Add item RISK and calculate to 0 PARCELS land use See section 6 1 27 areas throughout the Add an item KEY SEGMENT and PLANUNITS Florida Keys used to calculate each planning unit poly based on summarize results upper middle lower keys f Add an item HABITAT and calculate all RICERAT silver rice rat habitat habitat polys to 1 Add item RISK and calculate to 0 ROADS road line work INo Action official shoreline of the SHORELINE EROS No Action US1 U S 1 line work No Action WCP white crowned pigeon habitat Add an item HABITAT and calculate all habitat polys to 1 Convert planning units to grid Convert M shoreline to grid where the shoreline polys PLANUNITLAND Std of the land within the have a value of 0 and all other values are planning units nodata Add the planning unit grid to the shoreline
58. name shp ws 6 directory E rpt basedata gt lt SHAPEWORKSPACE name shp ws 8 directory E rpt currcondition gt lt WORKSPACES gt 5 Edit the C ArcIMS website rpt ARCIMSparams js file to change the name and IP address of the server Figure 13 2 65 Figure 13 2 J RRR RR k k k k k k k k kk kk k kk k kk kk kk k kk K kk OR K A X k X kA X KX KA X kA X k X k k kk parameters File for HTML Template J RRR RR k kok k k k k k kk kk k kk k kk k kk k kk K kk OR k k K k X k X KX KAZ AX KA X k X k k kk get machine name var hostName document location host make URL for getting mapservice catalog var catURL http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName catalog var serverURL http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName var catURL http hostName servlet com esri esrimap Esrimap ServiceName catalog http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName catalog make prefix for URL var serverURL http hostName servlet com esri esrimap Esrimap ServiceName http 10 101 4 12 servlet com esri esrimap Esrimap ServiceName RRR RR k k k k k k k k kok k k kk k kk k kk k kk k kk k kk OR k k X k X k KAZ AX kA X k X k kk kk LES parameters set by Designer RRR RR k k k k KR KKK KK k kk OR KR KK RK KOR OR KK X k ORK RK KK var imsURL
59. ng analysis is performed using SQL statements e Wastewater requires data from the land use attributes EDU_NS and WWT_NS e Stormwater BMPs requires data from user input from GUI e Master plan implementation requires data from user input from GUI Socio economic Scenario land use coverage converted to feature class prior to executing SQL statements Fiscal e Requires taxable value data from the land use feature class e Requires cost data from water module e Requires population data from socio economic Infrastructure Hurricane Evacuation Model is a MS Excel spreadsheet model that is external to the CCIAM It requires data from user input in the GUI and residential dwelling units Canal Impacts This model consists of 11 Excel spreadsheets 10 Canal spreadsheets and 1 Loading spreadsheet It requires the wastewater and stormwater loads and flows by watershed ID as inputs 28 There is not a one to one relationship between analysis modules and VBA modules A VBA module may be used by more than one analysis module Table 10 4 in Section 9 5 itemizes each VBA module and where it is used in the CCIAM 10 3 Result Reporting CCIAM results include maps tables and charts The result reporting VBA code and SQL queries build these outputs dynamically for each scenario Figure 10 4 Figure 10 4 COPY CHANGE CONVERT TEMPLATE LAYER MAP TO HTML FILE JPG DIRECTORY SOURCE EXECUTE SOL TO GENERATE TABLES AS
60. nts summarize acreages of residential and tourist related land uses from the scenario land use feature class located in FKCCS results scenario_lu_mdb and calculate the level of service along the roadway The resulting statistics table is placed in the SIF mdb geodatabase Hurricane Evacuation Model This is a Microsoft Excel spreadsheet model created by Miller Consulting Inc It has been locked by Miller and can not be modified except for those cells that accept changes from the user SOL statements summarize dwelling unit data and pass these data to the appropriate cells in the spreadsheet The model also reguires input from the user that is obtained through the CCIAM GUI Once this information is passed to the model it runs and SQL queries are executed to summarize the results into a table located in the SIF mdb geodatabase Canal Impacts This model consists of eleven Excel spreadsheets ten canal spreadsheets and one Loading spreadsheet The code used in the canal model is very similar to that used in the wastewater stormwater module The parcels are unioned with the canal_basin and the canal_adidbas coverages rather than the basins and adid_basins coverages as used in the water code The resulting two feature classes named xx_Can_Basins and xx_Can_ADBas are then used to calculate the canal stormwater and wastewater loads and flows per watershed ID The final result tables are named xx_Can_WW_Final and xx_Can_SW_Final where xx repr
61. re to be added to the RPT these data will have to be converted to shapefiles prior to being added to the RPT The steward can add to the functionality of the RPT by either modifying the JavaScript in the HTML viewer or by creating a new website using the ArcIMS Java viewer If the steward chooses to upgrade the RPT to a new version of ArcIMS then it is highly recommended that the steward research all of the implications of a version change to an application built in ArcIMS 3 1 67 List of Supporting Documentation Refer to USACE FKCCS Website FKCCS Final Report CCIAM Users Guide Delivery Order 10 Report Florida Keys Hurricane Evacuation Study Miller Consulting ArcGIS Users Guides including Spatial Analyst Exploring ArcObjects Volumes I amp II ArcObjects Object Model Diagrams Microsoft Access 2000 Developers Guide HTML and Java Script Reference Guides 68
62. rio covs directory is an ArcInfo workspace that contains each scenario s land use ArcInfo coverage Once the user completes the Administrative Information form the parcels coverage in the FKCCS data directory is copied to FKCCS Scenario_covs and given the scenario prefix as its name The coverage attributes are changed after the user clicks the change attributes button on the Scenario Selections form This workspace is referenced by the socio economic analysis VBA code when it imports the scenario s land use coverage into the FKCCS results SIF mdb geodatabase 13 Naming Conventions AI scenario specific coverages feature classes and grids have the scenario number as prefix and an acronym of what the data represent in the model Figure 7 1 Figure 7 1 Scenario numbe Description of feature 699 NADID 4 class indirect impacts to ADID The Terrestrial tabular statistics have the scenario number as a prefix an identifier for the impact being summarized and a suffix stats for each table name Figure 7 2 Figure 7 2 Impact descriptor lower keys marsh rabbit Scenario Number S99 L y m Gtats Statistics suffix For selected results and look up tables an additional identifier is used to denote which module or component the impact descriptor references in the database Figure 7 3 Table 7 1 Figure 7 3 Component descriptor Impact descriptor Socio Socio economic economic Ta
63. s water W Rainfall LUT Rainfall data this table is presently not used in the CCIAM water W SW Public Costs LUT Public stormwater cost values water W SWBMP LUT Stormwater BMP reduction values water W SWDCIA LUT Stormwater reduction values presently not used in the CCIAM water W USI Flows LUT US1 stormwater flows in GPD water W USIPPD LUT US 1 stormwater loads in pounds per day water W Var LUT Water load constants water W WS LUT Reference list of watersheds water W WW Oosts LUT Wastewater cost coefficients by treatment water W WW MFP Oosts LUT Wastewater costs when implementing MP water W PW Existing EDUs CC LUT Sum of EDU s by planning unit for current conditions water RW Pugeo LUT Planning unit key segment cross reference water RW Result LUT Planning unit key segment used for cross tab gueries 10 5 Description of VBA modules in the FKCCS mxd The FKCCS mxd is an ArcGIS 8 1 map document file that houses 31 VBA modules These VBA modules perform all of the functions of the GUT analysis and reporting of results Where possible global variables are declared and repeatedly used throughout the code In addition some VBA modules are called in multiple instances to execute the model Table 10 4 itemizes the VBA modules and provides a brief description of the VBA module s use in the model Note that each VBA module has a header with descriptive information and each procedure within the module is documented with a bulleted
64. t This maintenance manual is organized into twelve sections e Introduction to the Florida Keys Carrying Capacity Study Overview of the Carrying Capacity Impact Assessment Module Overview of the Routine Planning Tool Computing Specifications Directory Structure e Naming Conventions e Installation Procedures CCIAM Architecture CCIAM Updates e RPT Architecture e RPT Updates List of Supporting Documentation Note The FKCCS metadata files are provided under separate cover Introduction to the Florida Keys Carrying Capacity Study In 1986 a new comprehensive plan and corresponding land development regulations were approved for Monroe County They were developed in response to the Area of Critical State Concern designation as well as to comply with State of Florida regulations and to maintain a high guality of life in the region In 1991 the Monroe County Board of Commissioners ratified the Monroe County Year 2010 Comprehensive Plan the Plan The Plan was revised in 1993 following several legal challenges initiated by the DCA and other private organizations Ongoing legal proceedings prompted a 1995 Final Order and Recommendation by the Hearing Officer which resulted in further revisions and final adoption of the Plan in 1996 During final revisions of the Plan a carrying capacity approach to growth management was adopted The goal of the FKCCS excerpted from FAC Rule 28 20 100 reads as follows
65. t CC LUT Current conditions construction costs SIF SE Population CC LUT Current conditions population SIF SE Taxable Value CC LUT Current conditions taxable value SIF RI Pugeo LUT Planning unit key segment cross reference SIF RI Result LUT Planning unit key segment used for cross tab gueries terrestrial T Adid LUT ADID vegetation types terrestrial T Hab Reg LUT Forest interior birds habitat thresholds terrestrial T Indirect ReMap LUT Remap table to reclassify indirect impacts grid terrestrial T Uplands LUT Upland vegetation threshold terrestrial RT Pugeo LUT Planning unit key segment cross reference terrestrial RT Result LUT Planning unit key segment used for cross tab gueries terrestrial RT Rich LUT Planning unit number reference in xx rich stats table water W EDU LUT GPD per EDU by Planning unit water W EMC LUT EMC and RC values by major land use amp load type water W GWRed LUT Groundwater reduction applied to saturated amp unsaturated water W_LU_LUT Major land use category by land use description water W Pollcon LUT Pollution concentration by wastewater treatment type water W PU LUT Reference list of planning units water W PUWS LUT Reference list of planning unit watershed ID combinations 33 Table 10 3 Continued Geodatabase Look up Table Description water W PW Aguaduct LUT Agueduct Adeguacy template in geographic order water W PW Vanables LUT Potable water and cost constant
66. t CCIAM analyses All of these enhancements represent pre processing activities that should be completed if new parcel data become available for use in the CCIAM First the spatial accuracy of the parcel data was manually corrected by moving contiguous polygons into a position that visually lined up with the shoreline on the Digital Orthophoto Quarter Quadrangles The contractor made the decision not to break up contiguous clumps of parcels in order to maintain the integrity of shared boundaries Note that due to the rotation skew and shift in the parcel geometry not all parcels line up correctly with the shoreline However this correction does provide a spatial enhancement to the parcels and increases the accuracy of the CCIAM Since this was a manual visual process it is doubtful that the outcome of future corrections will be identical to the current accuracy of the GIS layer However the goal of this correction was to obtain a best fit until a systematic spatial correction process is undertaken by the county Review the Delivery Order 10 report for further details regarding parcel corrections Florida Keys Carrying Capacity Study 43 Carrying Capacity Impact Assessment Model Maintenance Model Second there are well over 55 attribute fields associated with the Monroe County tax roll Many of these fields are not reguired by the CCIAM In addition the contractor added several fields to the attribute table while developin
67. t analysis Schauss Swallowtail Butterfly SQL statements are executed using the scenario s ADID feature class located in FKCCS results terrestrial mdb to select hammocks within the species range and generate a statistics table This table is located in FKCCS results terrestrial mdb Note that the ADID feature class referred to here has already been created in the Direct Impacts to Habitat analysis Key Largo Woodrat SQL statements are executed using the scenario s ADID feature class located in FKCCS results terrestrial mdb to select hammocks within the species range and generate a statistics table This table is located in FKCCS results terrestrial mdb Note that the ADID feature class referred to here has already been created in the Direct Impacts to Habitat analysis Key Deer Developed parcels from the scenario land use coverage in FKCCS scenarios are selected to create a recordset A UNION operation is performed with this selected record set and the KEYDEER coverage located in FKCCS data The HABITAT attribute for those areas that became developed is updated with a value of 0 The resultant feature class is located in FKCCS results terrestrial mdb SQL statements summarize the data and place a statistics table in FKCCS results terrestrial mdb Lower Keys Marsh Rabbit Developed parcels from the scenario land use coverage in FKCCS scenarios are selected to create a recordset A UNION operation is performed with this s
68. tically be available with all mxd s The remaining references should be made available by turning them on If the library is not available go to FKCCS data Libraries and copy the files into the appropriate directory on the WC drive of the computer being used to run the CCIAM Table 8 1 Location on Local Computer Reference Name File Name NA Visual Basic for Applications NA NA ESRI Object Library NA NA OLE Automation NA NA Normal NA NA ESRI ArcMap Object Library NA Microsoft Visual Basic for NA Applications Extensibility 5 3 NA C WINNT system32 Microsoft Forms 2 0 Object Library FM20 dll C aregis arcexe8 1 Bin ESRI Spatial Analyst Extension EsriSpatialExt Object Library olb Claiegisiarcexe8 Bin ESRI Spatial Analyst Shared Object EsriSpatial Shared Library olb C Program Files Common Microsoft ActiveX Data Objects 2 5 msado15 dll Files System ado Library C Program Files Microsoft Microsoft Excel 9 0 Object Library EXCEL9 OLB Office Office C Program Files Common Microsoft DAO 3 6 Object Library dao360 dll Files Microsoft Shared DAO 16 Table 8 1 Continued Location on Local Computer Reference Name File Name C arcgis arcexe8 1 Bin ESRI Coverage Resource Library CovRes dll C arcgis arcexe8 Bin ESRI UIControls UIControls dll C arcgis arcexe8 1 Bin ESRIutil automation server strings dll C Program Files Common Files System ado Microsoft ActiveX Data Objects Recordset 2 5
69. ture class located in FKCCS results terrestrial mdb SQL statements summarize the data and place a statistics table in FKCCS results terrestrial mdb Forest Interior Birds 5 species SQL statements are executed using the scenario s ADID feature class located in FKCCS results terrestrial mdb and the T HAB REO LUT located in FKCCS results terrestrial mdb to generate individual statistics tables for each species These tables are located in FKCCS results terrestrial mdb Note that the ADID feature class referred to here has already been created in the Direct Impacts to Habitat analysis Direct Impacts to Uplands SQL statements are executed using the scenario s ADID feature class located in FKCCS results terrestrial mdb and the T UPLANDS LUT located in FKCCS results terrestrial mdb to generate the statistics table This table is located in FKCCS results terrestrial mdb Note that the ADID feature class referred to here has already been created in the Direct Impacts to Habitat analysis 23 Indirect Impacts to Uplands SOL statements are executed using the scenario s indirect impacts to ADID feature class located in FKCCS results terrestrial mdb and the T UPLANDS LUT located in FKCCS results terrestrial mdb to generate the statistics table This table is located in FKCCS results terrestrial mdb Note that the in direct impacts to ADID feature class referred to here has already been created in the Indirect Impacts to Habita
70. xable Value result Scenario Number 699 SE 14 Table 7 1 Component Descriptor in Geodatabase Reference SE F 1 SW WW PW Z R T RT W RW GW CAN Socioeconomic module Fiscal Module Infrastructure Module Stormwater Module Wastewater Module Potable water module Miscellaneous land use Miscellaneous results Terrestrial Module Result Terrestrial Module Miscellaneous Water Lookup Tables Result Water Module Groundwater Canal Result Tables Each look up table has a prefix representing the CCIAM module or component and a suffix of LUT Figure 7 4 The module component prefix is identical to those noted in Table 7 1 Figure 7 4 Module Component descriptor Terrestrial escriptor Uplands thresholds ran JME m UT ook up table suffix 15 CCIAM Installation Procedures The CCIAM is designed to be contained entirely within the FKCCS directory Therefore the installation procedures primarily involve copying the contents of the CCIAM DVD to the server and ensuring that the sub directories are correctly located within the project directory 1 Ensure that the hardware and software configuration is compatible with the computing specifications outlined in Section 5 1 2 The FKCCS mxd project must have 17 references available to properly execute the model The first 6 references in Table 8 1 are standard ArcMap references and should automa

Download Pdf Manuals

Related Search

Related Contents

T'nB ADVIHDMI37379 serial switch box  Originae HM100  Hoover 4600 User's Manual    Operators Manual / Opérateur Instructions / Las  日本語  (File size : 763KB)  Aprilaire 8551 Thermostat User Manual  Industrial Secure Router User`s Manual  OpenVox Communication Co.Ltd  

Copyright © All rights reserved. Failed to retrieve file