{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "CIPTracker", "type": "Feature Layer", "description": "

This feature class was created by linking a previously developed feature class with a table that was historically maintained in Access. City staff determined that they would like the spatial and tabular data used for CIP planning to all be stored in one location in our enterprise geodatabase. Public Works is he lead city department on this project. This feature class was created by Danielle Hamilton (Asset System Administrator, Public Works, danielle.hamilton@arlingtontx.gov). Data will be maintained by Public Works (Amy Powell, Engineering Coordinator, amy.powell@arlingtonttx.gov) and Water Utilities (TBD) with support from the Asset System Administrator.<\/SPAN><\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Arlington staff", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 85, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 85, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2351299.3102384657, "ymin": 6900597.432076067, "xmax": 2443438.044595808, "ymax": 6990451.702826485, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ProjectName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "length": 100, "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "FromStreet", "type": "esriFieldTypeString", "alias": "From Street", "length": 50, "domain": null }, { "name": "ToStreet", "type": "esriFieldTypeString", "alias": "To Street", "length": 50, "domain": null }, { "name": "ProjectLocation", "type": "esriFieldTypeString", "alias": "Project Location (eBuilder)", "length": 1500, "domain": null }, { "name": "ProjectScope", "type": "esriFieldTypeString", "alias": "Project Scope", "length": 1500, "domain": null }, { "name": "WaterProject", "type": "esriFieldTypeString", "alias": "Water Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SewerProject", "type": "esriFieldTypeString", "alias": "Sewer Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StreetProject", "type": "esriFieldTypeString", "alias": "Street Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DrainageProject", "type": "esriFieldTypeString", "alias": "Drainage Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SidewalkProject", "type": "esriFieldTypeString", "alias": "Sidewalk Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TrafficProject", "type": "esriFieldTypeString", "alias": "Traffic Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParksProject", "type": "esriFieldTypeString", "alias": "Parks Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BuildingProject", "type": "esriFieldTypeString", "alias": "Building Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MillOverlayProject", "type": "esriFieldTypeString", "alias": "Mill Overlay Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ReclamationProject", "type": "esriFieldTypeString", "alias": "Reclamation Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MicrosealProject", "type": "esriFieldTypeString", "alias": "Microseal Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HeaterRepaverProject", "type": "esriFieldTypeString", "alias": "Heater Repaver Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PanelReplacementProject", "type": "esriFieldTypeString", "alias": "Panel Replacement Project", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Project_Management_Option", "description": "Project Management Option", "codedValues": [ { "name": "Primary Project", "code": "P" }, { "name": "Included Project", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ManagingDivision", "type": "esriFieldTypeString", "alias": "Managing Division", "length": 4, "domain": { "type": "codedValue", "name": "CIP_Managing_Division", "description": "Managing Department and Group", "codedValues": [ { "name": "Public Works Drainage", "code": "PWDR" }, { "name": "Public Works Street Maintenance", "code": "PWSM" }, { "name": "Public Works Engineering (Streets)", "code": "PWST" }, { "name": "Public Works Sidewalk", "code": "PWSW" }, { "name": "Public Works Traffic Engineering", "code": "PWTE" }, { "name": "Water Utilities Operations", "code": "WUOP" }, { "name": "Construction Management Asset Management", "code": "CMAM" }, { "name": "Parks and Recreation Planning", "code": "PKPL" }, { "name": "Water Utilities Water and Sewer Mains", "code": "WUWS" }, { "name": "Water Utilities Water Treatment", "code": "WUTR" }, { "name": "Water Utilities Water Tanks", "code": "WUTK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CityDepartment", "type": "esriFieldTypeString", "alias": "City Department", "length": 2, "domain": { "type": "codedValue", "name": "CIP_City_Department", "description": "City Department", "codedValues": [ { "name": "Public Works", "code": "PW" }, { "name": "Water Utilities", "code": "WU" }, { "name": "Construction Management", "code": "CM" }, { "name": "Parks and Recreation", "code": "PK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PrimaryProjectNumber", "type": "esriFieldTypeString", "alias": "Primary Project Number", "length": 25, "domain": null }, { "name": "SecondaryProjectNumber", "type": "esriFieldTypeString", "alias": "Secondary Project Number", "length": 25, "domain": null }, { "name": "PrimaryProjectManager", "type": "esriFieldTypeString", "alias": "PrimaryProjectManager", "length": 30, "domain": null }, { "name": "PrimaryPMPhone", "type": "esriFieldTypeString", "alias": "Primary Project Manager's Phone Number", "length": 15, "domain": null }, { "name": "PrimaryPMEmail", "type": "esriFieldTypeString", "alias": "Primary Project Manager's E-mail", "length": 50, "domain": null }, { "name": "SecondaryProjectManager", "type": "esriFieldTypeString", "alias": "Secondary Project Manager", "length": 30, "domain": null }, { "name": "CouncilDistrict", "type": "esriFieldTypeString", "alias": "Council District", "length": 15, "domain": null }, { "name": "ProjectStatus", "type": "esriFieldTypeString", "alias": "Project Status", "length": 2, "domain": { "type": "codedValue", "name": "CIP_Project_Status", "description": "Project Status", "codedValues": [ { "name": "Proposed", "code": "PR" }, { "name": "Active", "code": "AC" }, { "name": "Complete", "code": "CP" }, { "name": "Cancelled", "code": "CN" }, { "name": "Inactive", "code": "IN" }, { "name": "Administrative", "code": "AD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProjectPhase", "type": "esriFieldTypeString", "alias": "Project Phase", "length": 2, "domain": { "type": "codedValue", "name": "CIP_Project_Phase", "description": "Project Phase", "codedValues": [ { "name": "Complete", "code": "CP" }, { "name": "Design", "code": "DG" }, { "name": "Warranty / Maintenance", "code": "WR" }, { "name": "Construction", "code": "CN" }, { "name": "Administrative", "code": "AD" }, { "name": "Study / Evaluation", "code": "ST" }, { "name": "Planning", "code": "PL" }, { "name": "Bidding", "code": "BD" }, { "name": "Equipment / Services", "code": "EQ" }, { "name": "Permitting", "code": "PR" }, { "name": "Utilities", "code": "UT" }, { "name": "Acquisition / ROW", "code": "AQ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CSTNStartYear", "type": "esriFieldTypeSmallInteger", "alias": "Construction Start Year", "domain": null }, { "name": "SubsCompleteMonth", "type": "esriFieldTypeString", "alias": "Substantially Complete Month", "length": 3, "domain": { "type": "codedValue", "name": "CIP_Month", "description": "Month", "codedValues": [ { "name": "January", "code": "JAN" }, { "name": "February", "code": "FEB" }, { "name": "March", "code": "MAR" }, { "name": "April", "code": "APR" }, { "name": "May", "code": "MAY" }, { "name": "June", "code": "JUN" }, { "name": "July", "code": "JUL" }, { "name": "August", "code": "AUG" }, { "name": "September", "code": "SEP" }, { "name": "October", "code": "OCT" }, { "name": "November", "code": "NOV" }, { "name": "December", "code": "DEC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SubsCompleteCalendarYear", "type": "esriFieldTypeSmallInteger", "alias": "Substantially Complete Calendar Year", "domain": null }, { "name": "SubsCompleteFiscalQuarter", "type": "esriFieldTypeSmallInteger", "alias": "Substantially Complete Fiscal Quarter", "domain": null }, { "name": "SubsCompleteFiscalYear", "type": "esriFieldTypeSmallInteger", "alias": "Substantially Complete Fiscal Year", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 30, "domain": null }, { "name": "HikeBikePlan", "type": "esriFieldTypeString", "alias": "Hike/Bike Plan", "length": 1, "domain": { "type": "codedValue", "name": "CIP_Yes_No", "description": "Yes / No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SquareYard", "type": "esriFieldTypeDouble", "alias": "Square Yard", "domain": null }, { "name": "LaneMile", "type": "esriFieldTypeDouble", "alias": "Lane Mile", "domain": null }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 255, "domain": null }, { "name": "CurrentActivity", "type": "esriFieldTypeString", "alias": "Current Activity", "length": 1000, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 50, "domain": null }, { "name": "AnticipatedCompletionDate", "type": "esriFieldTypeDate", "alias": "Anticipated Completion Date", "length": 8, "domain": null }, { "name": "LastUpdatedDate", "type": "esriFieldTypeDate", "alias": "Last Updated Date", "length": 8, "domain": null }, { "name": "LastUpdatedByEBuilder", "type": "esriFieldTypeDate", "alias": "Last Updated by e-Builder", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "SubsCompleteQtr", "type": "esriFieldTypeString", "alias": "Substantially Complete Quarter", "length": 10, "domain": null }, { "name": "CIP_ID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "EditedLastBy", "type": "esriFieldTypeString", "alias": "EditedLastBy", "length": 50, "domain": null }, { "name": "LastEditedDate", "type": "esriFieldTypeDate", "alias": "LastEditedDate", "length": 8, "domain": null }, { "name": "BondProgramYear", "type": "esriFieldTypeSmallInteger", "alias": "Bond Program Year", "domain": null }, { "name": "BondProjectCategory", "type": "esriFieldTypeString", "alias": "Bond Project Category", "length": 30, "domain": { "type": "codedValue", "name": "CIP_BondProjectCategory", "description": "Describes what the bond funds were allocated for", "codedValues": [ { "name": "Public Safety", "code": "Public Safety" }, { "name": "Parks & Recreation", "code": "Parks & Recreation" }, { "name": "Public Works/Streets", "code": "Public Works/Streets" }, { "name": "Buildings", "code": "Buildings" }, { "name": "Libraries", "code": "Libraries" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R127_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_127", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_127", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S112_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }