Name: CIPTracker

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 6 0;"><SPAN><SPAN>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>

Copyright Text: City of Arlington staff

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2351299.3102384657
YMin: 6900597.432076067
XMax: 2443438.044595808
YMax: 6990451.702826485
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 85, 0, 255]
Outline:
Style: esriSLSSolid
Color: [255, 85, 0, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 100 )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 50 )
• FromStreet ( type: esriFieldTypeString, alias: From Street, length: 50 )
• ToStreet ( type: esriFieldTypeString, alias: To Street, length: 50 )
• ProjectLocation ( type: esriFieldTypeString, alias: Project Location (eBuilder), length: 1500 )
• ProjectScope ( type: esriFieldTypeString, alias: Project Scope, length: 1500 )
• WaterProject ( type: esriFieldTypeString, alias: Water Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• SewerProject ( type: esriFieldTypeString, alias: Sewer Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• StreetProject ( type: esriFieldTypeString, alias: Street Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• DrainageProject ( type: esriFieldTypeString, alias: Drainage Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• SidewalkProject ( type: esriFieldTypeString, alias: Sidewalk Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• TrafficProject ( type: esriFieldTypeString, alias: Traffic Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• ParksProject ( type: esriFieldTypeString, alias: Parks Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• BuildingProject ( type: esriFieldTypeString, alias: Building Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• MillOverlayProject ( type: esriFieldTypeString, alias: Mill Overlay Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• ReclamationProject ( type: esriFieldTypeString, alias: Reclamation Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• MicrosealProject ( type: esriFieldTypeString, alias: Microseal Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• HeaterRepaverProject ( type: esriFieldTypeString, alias: Heater Repaver Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• PanelReplacementProject ( type: esriFieldTypeString, alias: Panel Replacement Project, length: 1 , Coded Values: [P: Primary Project] , [I: Included Project] )
• ManagingDivision ( type: esriFieldTypeString, alias: Managing Division, length: 4 , Coded Values: [PWDR: Public Works Drainage] , [PWSM: Public Works Street Maintenance] , [PWST: Public Works Engineering (Streets)] , ...8 more... )
• CityDepartment ( type: esriFieldTypeString, alias: City Department, length: 2 , Coded Values: [PW: Public Works] , [WU: Water Utilities] , [CM: Construction Management] , ...1 more... )
• PrimaryProjectNumber ( type: esriFieldTypeString, alias: Primary Project Number, length: 25 )
• SecondaryProjectNumber ( type: esriFieldTypeString, alias: Secondary Project Number, length: 25 )
• PrimaryProjectManager ( type: esriFieldTypeString, alias: PrimaryProjectManager, length: 30 )
• PrimaryPMPhone ( type: esriFieldTypeString, alias: Primary Project Manager's Phone Number, length: 15 )
• PrimaryPMEmail ( type: esriFieldTypeString, alias: Primary Project Manager's E-mail, length: 50 )
• SecondaryProjectManager ( type: esriFieldTypeString, alias: Secondary Project Manager, length: 30 )
• CouncilDistrict ( type: esriFieldTypeString, alias: Council District, length: 15 )
• ProjectStatus ( type: esriFieldTypeString, alias: Project Status, length: 2 , Coded Values: [PR: Proposed] , [AC: Active] , [CP: Complete] , ...3 more... )
• ProjectPhase ( type: esriFieldTypeString, alias: Project Phase, length: 2 , Coded Values: [CP: Complete] , [DG: Design] , [WR: Warranty / Maintenance] , ...9 more... )
• CSTNStartYear ( type: esriFieldTypeSmallInteger, alias: Construction Start Year )
• SubsCompleteMonth ( type: esriFieldTypeString, alias: Substantially Complete Month, length: 3 , Coded Values: [JAN: January] , [FEB: February] , [MAR: March] , ...9 more... )
• SubsCompleteCalendarYear ( type: esriFieldTypeSmallInteger, alias: Substantially Complete Calendar Year )
• SubsCompleteFiscalQuarter ( type: esriFieldTypeSmallInteger, alias: Substantially Complete Fiscal Quarter )
• SubsCompleteFiscalYear ( type: esriFieldTypeSmallInteger, alias: Substantially Complete Fiscal Year )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 30 )
• HikeBikePlan ( type: esriFieldTypeString, alias: Hike/Bike Plan, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• SquareYard ( type: esriFieldTypeDouble, alias: Square Yard )
• LaneMile ( type: esriFieldTypeDouble, alias: Lane Mile )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• CurrentActivity ( type: esriFieldTypeString, alias: Current Activity, length: 1000 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 50 )
• AnticipatedCompletionDate ( type: esriFieldTypeDate, alias: Anticipated Completion Date, length: 8 )
• LastUpdatedDate ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
• LastUpdatedByEBuilder ( type: esriFieldTypeDate, alias: Last Updated by e-Builder, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SubsCompleteQtr ( type: esriFieldTypeString, alias: Substantially Complete Quarter, length: 10 )
• CIP_ID ( type: esriFieldTypeString, alias: CIP ID, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• EditedLastBy ( type: esriFieldTypeString, alias: EditedLastBy, length: 50 )
• LastEditedDate ( type: esriFieldTypeDate, alias: LastEditedDate, length: 8 )
• BondProgramYear ( type: esriFieldTypeSmallInteger, alias: Bond Program Year )
• BondProjectCategory ( type: esriFieldTypeString, alias: Bond Project Category, length: 30 , Coded Values: [Public Safety: Public Safety] , [Parks & Recreation: Parks & Recreation] , [Public Works/Streets: Public Works/Streets] , ...2 more... )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata