{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "CIP Projects", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 24000, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "DUBUQUE.CIP_Budget", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJECTNO", "composite": false, "catalogID": "{D47F8273-BF9C-4164-A48D-0DF217F4D829}" }, { "id": 0, "name": "DUBUQUE.CIP_Expenditure", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJECTNO", "composite": false, "catalogID": "{B0A7AFC9-B8DB-4DD4-85E0-2E5CFC59B007}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 5650816.089870423, "ymin": 3617294.660724446, "xmax": 5692136.2998808175, "ymax": 3675722.370353386, "spatialReference": { "wkid": 102675, "latestWkid": 3417, "vcsWkid": 5703, "latestVcsWkid": 5703, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "sourceSpatialReference": { "wkid": 102675, "latestWkid": 3417, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3.742388458866003E7, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 50, 129, 134, 255 ], "outline": null } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJECTNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PROJECTNO", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PROJECTNO" }, { "name": "PROJECTNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROJECTNAME" }, { "name": "TOTALCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "TOTALCOST" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "STATUS" }, { "name": "DEPT", "type": "esriFieldTypeString", "alias": "Department", "domain": { "type": "codedValue", "name": "CIPDepartment", "description": "CIP Department", "codedValues": [ { "name": "Fire", "code": "Fire" }, { "name": "Leisure Services - Parks Division", "code": "Parks" }, { "name": "Leisure Services - Civic Center Division", "code": "CivicCenter" }, { "name": "Leisure Services - Recreation Division", "code": "Recreation" }, { "name": "Leisure Services - Conference Center", "code": "ConferenceCenter" }, { "name": "Library", "code": "Library" }, { "name": "Water Department", "code": "Water" }, { "name": "Water & Resource Recovery Center", "code": "WRRC" }, { "name": "Airport", "code": "Airport" }, { "name": "Public Works", "code": "PublicWorks" }, { "name": "Engineering - Sanitary Sewer", "code": "Sanitary" }, { "name": "Engineering - Street", "code": "Street" }, { "name": "Engineering - Stormwater", "code": "Stormwater" }, { "name": "Engineering - Miscellaneous", "code": "EngMisc" }, { "name": "Engineering - Traffic", "code": "Traffic" }, { "name": "Economic Development", "code": "Economic" }, { "name": "Transportation Services", "code": "Transportation" }, { "name": "Transportation Services - Parking Division", "code": "Parking" }, { "name": "Housing & Community Development", "code": "Housing" }, { "name": "Planning Services", "code": "Planning" }, { "name": "City Manager's Office", "code": "CMO" }, { "name": "Public Information Office", "code": "PIO" }, { "name": "City Clerk", "code": "Clerk" }, { "name": "City Council", "code": "Council" }, { "name": "Finance", "code": "Finance" }, { "name": "Budget", "code": "Budget" }, { "name": "Engineering - Facility Management", "code": "Facility" }, { "name": "Inspection & Construction Services", "code": "Construction" }, { "name": "Information Technology", "code": "I" }, { "name": "Sustainability", "code": "Sustainability" }, { "name": "Office of Shared Prosperity and Neighborhood Support", "code": "OSPNS" }, { "name": "Leisure Services - Ice Arena", "code": "IceArena" }, { "name": "Police", "code": "Police" }, { "name": "Solid Waste", "code": "DMASWA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEPT" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Project Description", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Sources", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "FUNDSOURCE" }, { "name": "FSOURCE1", "type": "esriFieldTypeString", "alias": "Funding Source 1", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE1" }, { "name": "FSOURCE2", "type": "esriFieldTypeString", "alias": "Funding Source 2", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE2" }, { "name": "FSOURCE3", "type": "esriFieldTypeString", "alias": "Funding Source 3", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE3" }, { "name": "FSOURCE4", "type": "esriFieldTypeString", "alias": "Funding Source 4", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE4" }, { "name": "FSOURCE5", "type": "esriFieldTypeString", "alias": "Funding Source 5", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE5" }, { "name": "FIRSTYEAR", "type": "esriFieldTypeString", "alias": "Year Added to CIP", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "FIRSTYEAR" }, { "name": "OLDCIP", "type": "esriFieldTypeString", "alias": "Old CIP Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OLDCIP" }, { "name": "OLDCIP2", "type": "esriFieldTypeString", "alias": "Old CIP Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OLDCIP2" }, { "name": "OLDCIP3", "type": "esriFieldTypeString", "alias": "Old CIP Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OLDCIP3" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R2594_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9738_PROJECT", "fields": "PROJECTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_2594", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_2594", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1766_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Projects", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": null, "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "b27407b448504f9281d0fe619d16a806" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "CIP Projects", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 24000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "DUBUQUE.CIP_Budget", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJECTNO", "composite": false, "catalogID": "{D47F8273-BF9C-4164-A48D-0DF217F4D829}" }, { "id": 2, "name": "DUBUQUE.CIP_Expenditure", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJECTNO", "composite": false, "catalogID": "{B0A7AFC9-B8DB-4DD4-85E0-2E5CFC59B007}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 5650816.089870423, "ymin": 3617294.660724446, "xmax": 5692136.2998808175, "ymax": 3675722.370353386, "spatialReference": { "wkid": 102675, "latestWkid": 3417, "vcsWkid": 5703, "latestVcsWkid": 5703, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "sourceSpatialReference": { "wkid": 102675, "latestWkid": 3417, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3.742388458866003E7, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DEPT", "defaultSymbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 130, 130, 130, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 130, 130, 130, 255 ], "width": 0.7 } }, "defaultLabel": "", "uniqueValueGroups": [ { "heading": "Department", "classes": [ { "label": "Airport", "description": "Airport", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 166, 206, 227, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 206, 227, 255 ], "width": 0.7 } }, "values": [ [ "Airport" ] ] }, { "label": "Budget", "description": "Budget", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 31, 120, 180, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 31, 120, 180, 255 ], "width": 0.7 } }, "values": [ [ "Budget" ] ] }, { "label": "City Manager's Office", "description": "City Manager's Office", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 178, 223, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 223, 138, 255 ], "width": 0.7 } }, "values": [ [ "CMO" ] ] }, { "label": "Leisure Services - Civic Center Division", "description": "Leisure Services - Civic Center Division", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 51, 160, 44, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 160, 44, 255 ], "width": 0.7 } }, "values": [ [ "CivicCenter" ] ] }, { "label": "City Clerk", "description": "City Clerk", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 251, 154, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 251, 154, 153, 255 ], "width": 0.7 } }, "values": [ [ "Clerk" ] ] }, { "label": "Leisure Services - Conference Center", "description": "Leisure Services - Conference Center", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 227, 26, 28, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 227, 26, 28, 255 ], "width": 0.7 } }, "values": [ [ "ConferenceCenter" ] ] }, { "label": "Inspection & Construction Services", "description": "Inspection & Construction Services", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 253, 191, 111, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 253, 191, 111, 255 ], "width": 0.7 } }, "values": [ [ "Construction" ] ] }, { "label": "City Council", "description": "City Council", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 127, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 0, 255 ], "width": 0.7 } }, "values": [ [ "Council" ] ] }, { "label": "Economic Development", "description": "Economic Development", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 202, 178, 214, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 202, 178, 214, 255 ], "width": 0.7 } }, "values": [ [ "Economic" ] ] }, { "label": "Engineering - Miscellaneous", "description": "Engineering - Miscellaneous", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 106, 61, 154, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 106, 61, 154, 255 ], "width": 0.7 } }, "values": [ [ "EngMisc" ] ] }, { "label": "Engineering - Facility Management", "description": "Engineering - Facility Management", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 153, 255 ], "width": 0.7 } }, "values": [ [ "Facility" ] ] }, { "label": "Finance", "description": "Finance", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 177, 89, 40, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 177, 89, 40, 255 ], "width": 0.7 } }, "values": [ [ "Finance" ] ] }, { "label": "Fire", "description": "Fire", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 166, 206, 227, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 206, 227, 255 ], "width": 0.7 } }, "values": [ [ "Fire" ] ] }, { "label": "Housing & Community Development", "description": "Housing & Community Development", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 31, 120, 180, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 31, 120, 180, 255 ], "width": 0.7 } }, "values": [ [ "Housing" ] ] }, { "label": "Information Technology", "description": "Information Technology", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 178, 223, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 223, 138, 255 ], "width": 0.7 } }, "values": [ [ "I" ] ] }, { "label": "Library", "description": "Library", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 51, 160, 44, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 160, 44, 255 ], "width": 0.7 } }, "values": [ [ "Library" ] ] }, { "label": "Office of Shared Prosperity and Neighborhood Support", "description": "Office of Shared Prosperity and Neighborhood Support", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 251, 154, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 251, 154, 153, 255 ], "width": 0.7 } }, "values": [ [ "OSPNS" ] ] }, { "label": "Public Information Office", "description": "Public Information Office", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 227, 26, 28, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 227, 26, 28, 255 ], "width": 0.7 } }, "values": [ [ "PIO" ] ] }, { "label": "Transportation Services - Parking Division", "description": "Transportation Services - Parking Division", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 253, 191, 111, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 253, 191, 111, 255 ], "width": 0.7 } }, "values": [ [ "Parking" ] ] }, { "label": "Leisure Services - Parks Division", "description": "Leisure Services - Parks Division", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 127, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 0, 255 ], "width": 0.7 } }, "values": [ [ "Parks" ] ] }, { "label": "Planning Services", "description": "Planning Services", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 202, 178, 214, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 202, 178, 214, 255 ], "width": 0.7 } }, "values": [ [ "Planning" ] ] }, { "label": "Public Works", "description": "Public Works", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 106, 61, 154, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 106, 61, 154, 255 ], "width": 0.7 } }, "values": [ [ "PublicWorks" ] ] }, { "label": "Leisure Services - Recreation Division", "description": "Leisure Services - Recreation Division", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 153, 255 ], "width": 0.7 } }, "values": [ [ "Recreation" ] ] }, { "label": "Engineering - Sanitary Sewer", "description": "Engineering - Sanitary Sewer", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 177, 89, 40, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 177, 89, 40, 255 ], "width": 0.7 } }, "values": [ [ "Sanitary" ] ] }, { "label": "Engineering - Stormwater", "description": "Engineering - Stormwater", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 166, 206, 227, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 206, 227, 255 ], "width": 0.7 } }, "values": [ [ "Stormwater" ] ] }, { "label": "Engineering - Street", "description": "Engineering - Street", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 31, 120, 180, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 31, 120, 180, 255 ], "width": 0.7 } }, "values": [ [ "Street" ] ] }, { "label": "Sustainability", "description": "Sustainability", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 178, 223, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 223, 138, 255 ], "width": 0.7 } }, "values": [ [ "Sustainability" ] ] }, { "label": "Engineering - Traffic", "description": "Engineering - Traffic", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 51, 160, 44, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 160, 44, 255 ], "width": 0.7 } }, "values": [ [ "Traffic" ] ] }, { "label": "Transportation Services", "description": "Transportation Services", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 251, 154, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 251, 154, 153, 255 ], "width": 0.7 } }, "values": [ [ "Transportation" ] ] }, { "label": "Water & Resource Recovery Center", "description": "Water & Resource Recovery Center", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 227, 26, 28, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 227, 26, 28, 255 ], "width": 0.7 } }, "values": [ [ "WRRC" ] ] }, { "label": "Water Department", "description": "Water Department", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 253, 191, 111, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 253, 191, 111, 255 ], "width": 0.7 } }, "values": [ [ "Water" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 166, 206, 227, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 206, 227, 255 ], "width": 0.7 } }, "value": "Airport", "label": "Airport" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 31, 120, 180, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 31, 120, 180, 255 ], "width": 0.7 } }, "value": "Budget", "label": "Budget" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 178, 223, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 223, 138, 255 ], "width": 0.7 } }, "value": "CMO", "label": "City Manager's Office" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 51, 160, 44, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 160, 44, 255 ], "width": 0.7 } }, "value": "CivicCenter", "label": "Leisure Services - Civic Center Division" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 251, 154, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 251, 154, 153, 255 ], "width": 0.7 } }, "value": "Clerk", "label": "City Clerk" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 227, 26, 28, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 227, 26, 28, 255 ], "width": 0.7 } }, "value": "ConferenceCenter", "label": "Leisure Services - Conference Center" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 253, 191, 111, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 253, 191, 111, 255 ], "width": 0.7 } }, "value": "Construction", "label": "Inspection & Construction Services" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 127, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 0, 255 ], "width": 0.7 } }, "value": "Council", "label": "City Council" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 202, 178, 214, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 202, 178, 214, 255 ], "width": 0.7 } }, "value": "Economic", "label": "Economic Development" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 106, 61, 154, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 106, 61, 154, 255 ], "width": 0.7 } }, "value": "EngMisc", "label": "Engineering - Miscellaneous" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 153, 255 ], "width": 0.7 } }, "value": "Facility", "label": "Engineering - Facility Management" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 177, 89, 40, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 177, 89, 40, 255 ], "width": 0.7 } }, "value": "Finance", "label": "Finance" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 166, 206, 227, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 206, 227, 255 ], "width": 0.7 } }, "value": "Fire", "label": "Fire" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 31, 120, 180, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 31, 120, 180, 255 ], "width": 0.7 } }, "value": "Housing", "label": "Housing & Community Development" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 178, 223, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 223, 138, 255 ], "width": 0.7 } }, "value": "I", "label": "Information Technology" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 51, 160, 44, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 160, 44, 255 ], "width": 0.7 } }, "value": "Library", "label": "Library" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 251, 154, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 251, 154, 153, 255 ], "width": 0.7 } }, "value": "OSPNS", "label": "Office of Shared Prosperity and Neighborhood Support" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 227, 26, 28, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 227, 26, 28, 255 ], "width": 0.7 } }, "value": "PIO", "label": "Public Information Office" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 253, 191, 111, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 253, 191, 111, 255 ], "width": 0.7 } }, "value": "Parking", "label": "Transportation Services - Parking Division" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 127, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 0, 255 ], "width": 0.7 } }, "value": "Parks", "label": "Leisure Services - Parks Division" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 202, 178, 214, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 202, 178, 214, 255 ], "width": 0.7 } }, "value": "Planning", "label": "Planning Services" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 106, 61, 154, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 106, 61, 154, 255 ], "width": 0.7 } }, "value": "PublicWorks", "label": "Public Works" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 153, 255 ], "width": 0.7 } }, "value": "Recreation", "label": "Leisure Services - Recreation Division" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 177, 89, 40, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 177, 89, 40, 255 ], "width": 0.7 } }, "value": "Sanitary", "label": "Engineering - Sanitary Sewer" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 166, 206, 227, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 206, 227, 255 ], "width": 0.7 } }, "value": "Stormwater", "label": "Engineering - Stormwater" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 31, 120, 180, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 31, 120, 180, 255 ], "width": 0.7 } }, "value": "Street", "label": "Engineering - Street" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 178, 223, 138, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 223, 138, 255 ], "width": 0.7 } }, "value": "Sustainability", "label": "Sustainability" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 51, 160, 44, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 51, 160, 44, 255 ], "width": 0.7 } }, "value": "Traffic", "label": "Engineering - Traffic" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 251, 154, 153, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 251, 154, 153, 255 ], "width": 0.7 } }, "value": "Transportation", "label": "Transportation Services" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 227, 26, 28, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 227, 26, 28, 255 ], "width": 0.7 } }, "value": "WRRC", "label": "Water & Resource Recovery Center" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 253, 191, 111, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 253, 191, 111, 255 ], "width": 0.7 } }, "value": "Water", "label": "Water Department" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 166, 206, 227, 255 ], "toColor": [ 166, 206, 227, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 31, 121, 181, 255 ], "toColor": [ 31, 121, 181, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 177, 222, 138, 255 ], "toColor": [ 177, 222, 138, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 51, 161, 43, 255 ], "toColor": [ 51, 161, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 250, 154, 152, 255 ], "toColor": [ 250, 154, 152, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 25, 28, 255 ], "toColor": [ 227, 25, 28, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 191, 111, 255 ], "toColor": [ 252, 191, 111, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 128, 0, 255 ], "toColor": [ 255, 128, 0, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 178, 214, 255 ], "toColor": [ 202, 178, 214, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 106, 61, 153, 255 ], "toColor": [ 106, 61, 153, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 255, 255, 153, 255 ], "toColor": [ 255, 255, 153, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 176, 88, 40, 255 ], "toColor": [ 176, 88, 40, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJECTNAME", "typeIdField": "DEPT", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PROJECTNO", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PROJECTNO" }, { "name": "PROJECTNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROJECTNAME" }, { "name": "TOTALCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "TOTALCOST" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "STATUS" }, { "name": "DEPT", "type": "esriFieldTypeString", "alias": "Department", "domain": { "type": "codedValue", "name": "CIPDepartment", "description": "CIP Department", "codedValues": [ { "name": "Fire", "code": "Fire" }, { "name": "Leisure Services - Parks Division", "code": "Parks" }, { "name": "Leisure Services - Civic Center Division", "code": "CivicCenter" }, { "name": "Leisure Services - Recreation Division", "code": "Recreation" }, { "name": "Leisure Services - Conference Center", "code": "ConferenceCenter" }, { "name": "Library", "code": "Library" }, { "name": "Water Department", "code": "Water" }, { "name": "Water & Resource Recovery Center", "code": "WRRC" }, { "name": "Airport", "code": "Airport" }, { "name": "Public Works", "code": "PublicWorks" }, { "name": "Engineering - Sanitary Sewer", "code": "Sanitary" }, { "name": "Engineering - Street", "code": "Street" }, { "name": "Engineering - Stormwater", "code": "Stormwater" }, { "name": "Engineering - Miscellaneous", "code": "EngMisc" }, { "name": "Engineering - Traffic", "code": "Traffic" }, { "name": "Economic Development", "code": "Economic" }, { "name": "Transportation Services", "code": "Transportation" }, { "name": "Transportation Services - Parking Division", "code": "Parking" }, { "name": "Housing & Community Development", "code": "Housing" }, { "name": "Planning Services", "code": "Planning" }, { "name": "City Manager's Office", "code": "CMO" }, { "name": "Public Information Office", "code": "PIO" }, { "name": "City Clerk", "code": "Clerk" }, { "name": "City Council", "code": "Council" }, { "name": "Finance", "code": "Finance" }, { "name": "Budget", "code": "Budget" }, { "name": "Engineering - Facility Management", "code": "Facility" }, { "name": "Inspection & Construction Services", "code": "Construction" }, { "name": "Information Technology", "code": "I" }, { "name": "Sustainability", "code": "Sustainability" }, { "name": "Office of Shared Prosperity and Neighborhood Support", "code": "OSPNS" }, { "name": "Leisure Services - Ice Arena", "code": "IceArena" }, { "name": "Police", "code": "Police" }, { "name": "Solid Waste", "code": "DMASWA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEPT" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Project Description", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Sources", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "FUNDSOURCE" }, { "name": "FSOURCE1", "type": "esriFieldTypeString", "alias": "Funding Source 1", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE1" }, { "name": "FSOURCE2", "type": "esriFieldTypeString", "alias": "Funding Source 2", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE2" }, { "name": "FSOURCE3", "type": "esriFieldTypeString", "alias": "Funding Source 3", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE3" }, { "name": "FSOURCE4", "type": "esriFieldTypeString", "alias": "Funding Source 4", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE4" }, { "name": "FSOURCE5", "type": "esriFieldTypeString", "alias": "Funding Source 5", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FSOURCE5" }, { "name": "FIRSTYEAR", "type": "esriFieldTypeString", "alias": "Year Added to CIP", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "FIRSTYEAR" }, { "name": "OLDCIP", "type": "esriFieldTypeString", "alias": "Old CIP Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OLDCIP" }, { "name": "OLDCIP2", "type": "esriFieldTypeString", "alias": "Old CIP Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OLDCIP2" }, { "name": "OLDCIP3", "type": "esriFieldTypeString", "alias": "Old CIP Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OLDCIP3" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R2594_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9738_PROJECT", "fields": "PROJECTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_2594", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_2594", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1766_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": "Airport", "name": "Airport", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Airport", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Airport", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Budget", "name": "Budget", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Budget", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Budget", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "CMO", "name": "City Manager's Office", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "CMO", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "CMO", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "CivicCenter", "name": "Leisure Services - Civic Center Division", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "CivicCenter", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "CivicCenter", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Clerk", "name": "City Clerk", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Clerk", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Clerk", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "ConferenceCenter", "name": "Leisure Services - Conference Center", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "ConferenceCenter", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "ConferenceCenter", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Construction", "name": "Inspection & Construction Services", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Construction", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Construction", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Council", "name": "City Council", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Council", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Council", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Economic", "name": "Economic Development", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Economic", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Economic", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "EngMisc", "name": "Engineering - Miscellaneous", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "EngMisc", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "EngMisc", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Facility", "name": "Engineering - Facility Management", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Facility", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Facility", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Finance", "name": "Finance", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Finance", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Finance", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Fire", "name": "Fire", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Fire", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Fire", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Housing", "name": "Housing & Community Development", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Housing", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Housing", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "I", "name": "Information Technology", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "I", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "I", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Library", "name": "Library", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Library", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Library", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "OSPNS", "name": "Office of Shared Prosperity and Neighborhood Support", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "OSPNS", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "OSPNS", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "PIO", "name": "Public Information Office", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "PIO", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "PIO", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Parking", "name": "Transportation Services - Parking Division", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Parking", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Parking", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Parks", "name": "Leisure Services - Parks Division", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Parks", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Parks", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Planning", "name": "Planning Services", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Planning", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Planning", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "PublicWorks", "name": "Public Works", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "PublicWorks", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "PublicWorks", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Recreation", "name": "Leisure Services - Recreation Division", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Recreation", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Recreation", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Sanitary", "name": "Engineering - Sanitary Sewer", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Sanitary", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Sanitary", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Stormwater", "name": "Engineering - Stormwater", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Stormwater", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Stormwater", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Street", "name": "Engineering - Street", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Street", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Street", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Sustainability", "name": "Sustainability", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Sustainability", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Sustainability", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Traffic", "name": "Engineering - Traffic", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Traffic", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Traffic", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Transportation", "name": "Transportation Services", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Transportation", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Transportation", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "WRRC", "name": "Water & Resource Recovery Center", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "WRRC", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "WRRC", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": "Water", "name": "Water Department", "domains": { "DEPT": {"type": "inherited"}, "FSOURCE1": {"type": "inherited"}, "FSOURCE2": {"type": "inherited"}, "FSOURCE3": {"type": "inherited"}, "FSOURCE4": {"type": "inherited"}, "FSOURCE5": {"type": "inherited"} }, "templates": [ { "name": "Water", "description": "", "prototype": { "attributes": { "OLDCIP3": null, "OLDCIP2": null, "PROJECTNO": null, "PROJECTNAME": null, "TOTALCOST": 0, "STATUS": null, "DEPT": "Water", "DESCRIPTION": null, "FUNDSOURCE": null, "FSOURCE1": null, "FSOURCE2": null, "FSOURCE3": null, "FSOURCE4": null, "FSOURCE5": null, "FIRSTYEAR": null, "OLDCIP": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "b27407b448504f9281d0fe619d16a806" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Budget", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "DUBUQUE.CIP_Projects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJECTNO", "composite": false, "catalogID": "{D47F8273-BF9C-4164-A48D-0DF217F4D829}" }, { "id": 3, "name": "DUBUQUE.CIP_Projects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJECTNO", "composite": false, "catalogID": "{D47F8273-BF9C-4164-A48D-0DF217F4D829}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJECTNO", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PROJECTNO", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PROJECTNO" }, { "name": "TOTALCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTALCOST" }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Sales Tax Fund (20%)", "code": "SalesTax20" }, { "name": "DRA Distribution/Gaming", "code": "DRA" }, { "name": "Greater Downtown TIF", "code": "GDTIF" }, { "name": "Golf Fees", "code": "Golf" }, { "name": "Water Construction Fund", "code": "WaterConstruction" }, { "name": "State Revolving Fund (SRF)", "code": "SRF" }, { "name": "Sanitary Sewer Construction Fund", "code": "SanitaryConstruction" }, { "name": "FAA Funding", "code": "FAA" }, { "name": "FAA Entitlement Fund", "code": "FAAEntitlement" }, { "name": "Customer Facility Charges (Rental Cars)", "code": "Customer" }, { "name": "State Commercial Service Vehicle Infrastructure Fund (CSVI)", "code": "CSVI" }, { "name": "Sales Tax Fund (30%)", "code": "SalesTax30" }, { "name": "Road Use Tax Fund", "code": "RoadUse" }, { "name": "General Fund", "code": "General" }, { "name": "Refuse Collection Fund", "code": "Refuse" }, { "name": "Stormwater Construction Fund", "code": "StormwaterConstruction" }, { "name": "HUD NDRC Grant Fund", "code": "HUDNDRC" }, { "name": "Sales Tax Increment Fund", "code": "SalesTaxIncrement" }, { "name": "DICW TIF", "code": "DICWTIF" }, { "name": "Special Assessments Fund", "code": "Special" }, { "name": "Community Development Block Grant (CDBG) Fund", "code": "CDBG" }, { "name": "Housing TIF", "code": "HousingTIF" }, { "name": "DICW Land Sales", "code": "DICWSales" }, { "name": "State &/or Federal Grant Fund", "code": "StateFederal" }, { "name": "Public Transit Infrastructure Grant Program", "code": "PublicTransit" }, { "name": "Private Party Funding", "code": "PrivateParty" }, { "name": "HUD Lead Grant", "code": "HUDLead" }, { "name": "Iowa Finance Authority Trust Fund", "code": "IFA" }, { "name": "G.O. Debt (Sales Tax 20%)", "code": "GOSales" }, { "name": "G. O. Debt (GDTIF)", "code": "GOGDTIF" }, { "name": "Dubuque County", "code": "County" }, { "name": "Sanitary Sewer Revenue Bonds", "code": "SanitaryRevenue" }, { "name": "ARPA (American Rescue Plan Act) Funds", "code": "ARPA" }, { "name": "Garage Service Fund", "code": "GarageService" }, { "name": "G.O. Debt (Refuse)", "code": "GORefuse" }, { "name": "G.O. Debt (DICW)", "code": "GODICW" }, { "name": "Salt Operations Fund", "code": "SaltOperations" }, { "name": "DMASWA Fund", "code": "DMASWAFund" }, { "name": "State Flood Mitigation", "code": "StateFlood" }, { "name": "DMATS SWAP Funding", "code": "DMATSSwap" }, { "name": "State ICAAP Grant", "code": "ICAAP" }, { "name": "State TSIP Grant", "code": "TSIP" }, { "name": "DMATS STBG", "code": "DMATSSTBG" }, { "name": "IDOT Funding", "code": "IDOT" }, { "name": "Insurance Reimbursements", "code": "Insurance" }, { "name": "Transit Fund", "code": "TransitFund" }, { "name": "FTA Grant", "code": "FTAGrant" }, { "name": "Parking Construction Fund", "code": "ParkingConstruction" }, { "name": "Loan Repayments", "code": "LoanRepayments" }, { "name": "Sales Proceeds", "code": "SalesProceeds" }, { "name": "IFA Loan Repayments", "code": "IFALoan" }, { "name": "RRP Repayments", "code": "RRPRepayments" }, { "name": "UDAG Loan Repayments", "code": "UDAGLoan" }, { "name": "Cable TV Fund", "code": "CableTV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FUNDSOURCE" }, { "name": "FY2022", "type": "esriFieldTypeInteger", "alias": "2022 Expense", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2022" }, { "name": "FY2023", "type": "esriFieldTypeInteger", "alias": "2023 Budget", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2023" }, { "name": "FY2024", "type": "esriFieldTypeInteger", "alias": "2024 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2024" }, { "name": "FY2025", "type": "esriFieldTypeInteger", "alias": "2025 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2025" }, { "name": "FY2026", "type": "esriFieldTypeInteger", "alias": "2026 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2026" }, { "name": "FY2027", "type": "esriFieldTypeInteger", "alias": "2027 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2027" }, { "name": "FY2028", "type": "esriFieldTypeInteger", "alias": "2028 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2028" }, { "name": "FY2029", "type": "esriFieldTypeInteger", "alias": "2029 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2029" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FY2030", "type": "esriFieldTypeInteger", "alias": "FY2030", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2030" } ], "indexes": [ { "name": "R2596_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9740_PROJECT", "fields": "PROJECTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_2596", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_2596", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Budget", "description": "", "prototype": { "attributes": { "FY2030": 0, "FY2029": 0, "PROJECTNO": null, "TOTALCOST": null, "FUNDSOURCE": null, "FY2022": 0, "FY2023": 0, "FY2024": 0, "FY2025": 0, "FY2026": 0, "FY2027": 0, "FY2028": 0 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "b27407b448504f9281d0fe619d16a806" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Expenditures", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "DUBUQUE.CIP_Projects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJECTNO", "composite": false, "catalogID": "{B0A7AFC9-B8DB-4DD4-85E0-2E5CFC59B007}" }, { "id": 2, "name": "DUBUQUE.CIP_Projects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJECTNO", "composite": false, "catalogID": "{B0A7AFC9-B8DB-4DD4-85E0-2E5CFC59B007}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJECTNO", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PROJECTNO", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PROJECTNO" }, { "name": "TOTALCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTALCOST" }, { "name": "ITEM", "type": "esriFieldTypeString", "alias": "Expenditure Item", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ITEM" }, { "name": "FY2022", "type": "esriFieldTypeInteger", "alias": "2022 Expense", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2022" }, { "name": "FY2023", "type": "esriFieldTypeInteger", "alias": "2023 Budget", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2023" }, { "name": "FY2024", "type": "esriFieldTypeInteger", "alias": "2024 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2024" }, { "name": "FY2025", "type": "esriFieldTypeInteger", "alias": "2025 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2025" }, { "name": "FY2026", "type": "esriFieldTypeInteger", "alias": "2026 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2026" }, { "name": "FY2027", "type": "esriFieldTypeInteger", "alias": "2027 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2027" }, { "name": "FY2028", "type": "esriFieldTypeInteger", "alias": "2028 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2028" }, { "name": "FY2029", "type": "esriFieldTypeInteger", "alias": "2029 Projected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2029" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FY2030", "type": "esriFieldTypeInteger", "alias": "FY2030", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "FY2030" } ], "indexes": [ { "name": "R2595_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9739_PROJECT", "fields": "PROJECTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_2595", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_2595", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Expenditures", "description": "", "prototype": { "attributes": { "FY2030": 0, "FY2029": 0, "PROJECTNO": null, "TOTALCOST": null, "ITEM": null, "FY2022": 0, "FY2023": 0, "FY2024": 0, "FY2025": 0, "FY2026": 0, "FY2027": 0, "FY2028": 0 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "b27407b448504f9281d0fe619d16a806" } ] }