Name: VOP All Excavation Locations

Display Field: STREETNAME_1

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: OBJECTID: System-generated unique identifier for each record within the feature classGEODBID: Three-digit code that assigns editing responsibility to a community in the GIS ConsortiumFEATUREID: GIS-Consortium-generated unique identifier for each record within the feature class. All FEATUREIDs start with the GEODBID of the community that owns the recordDATECREATED: Date/time stamp from the moment the GIS record was createdDATEMODIFIED: Date/time stamp from the last moment the GIS record was changedSOURCE: Organization that provided the data. The GIS Consortium standard is to preface the source with the three-letter municipal code of the community providing the data, followed by a dash. Example: VGV-Public WorksSOURCETYPE: Accuracy context for the recordPRODUCTIONNOTES: Technical notes from GIS personnelREPLICAFILTER: Code used to filter data for the creation of custom geodatabasesCREATEDBY:Records who created the GIS feature or tableMODIFIEDBY:Records who modified the GIS feature or tableDIGNUMBER: Unique identifier assigned at excavation entryDIGDATE: Date of excavationDIGTYPE: Type of/reason for excavationLANDSCAPECONTRACTDATE: Date information was given to the landscape contractorSETTLEPERIOD: Boolean field indicating if the excavation requires a 60 day settle periodSTREETSCONTRACTDATE: Date information was given to the streets contractorSTREETSCOMPLETEDDATE: Date Streets Division completed workPARKWAYCOMPLETEDDATE: Date parkway work was completedADDRESSNUMBER: House number for locationSTREETNAME_1: Street name of the locationSTREETNAME_2: Secondary street name of the locationSECTION: Refers to Oak Park's grid systemPARKWAY: Boolean field indicating if the excavation includes parkway workPARKWAYWIDTH: Measurement of the width of the parkwayPARKWAYLENGTH: Measurement of the length of the parkwayPARKWAYDEPTH: Measurement of the depth of the parkwayPARKWAYAREA: Measurement of the area of the parkwayASPHALT: Boolean field indicating if asphalt was usedCONCRETE: Boolean field indicating if concrete was usedSTREETLENGTH: Measurement of the length of the streetSTREETWIDTH: Measurement of the width of the streetCURBLENGTH: Measurement of the length of the curbSIDEWALKSQUARES: Number of sidewalk squaresCOACHWALKLENGTH: Measurement of the length of the coach walkSTREETFINALPAVEMENTLENGTH: Final measurement of the length of the pavement replacedSQUAREYARDS: Final measurement of the area of the pavement replacedEMPLOYEECOUNT: Number of employees on teh projectMANHOURS: Total number of man hoursLABORCOST: Cost of the laborEQUIPMENTCOST: Cost of the equipmentDIGCOST: Cost of digWATERSEWERCOMPLETEDDATE: Date Water/Sewer Division completed workFORESTRYCOMPLETEDDATE: Date Forestry Division completed workLOCATIONDESCRIPTION: Statement illustrating the whereabouts of a featureWINTERIZEEXCAVATION: Boolean field indicating if the excavation was winterizedSHAPE: System generated geometry type of the featureDeWinterize Date: Date indicating when the winterized excavation was fully restoredFinal Pavement Restoration Width: Final measurement of the width of the pavement replacedComments: Additional comments during the excavation process

Copyright Text: Created by the Oak Park GIS Consortium Site Analyst with input for Oak Park Public works staff in 11/2017 with ongoing updates.

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 32000

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: 1128337.774311494
YMin: 1894558.912681654
XMax: 1136554.2486921623
YMax: 1910109.950477153
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DIGNUMBER ( type: esriFieldTypeInteger, alias: Dig Number )
• DIGDATE ( type: esriFieldTypeDate, alias: Dig Date, length: 8 )
• DIGTYPE ( type: esriFieldTypeString, alias: DIGTYPE, length: 255 , Coded Values: [1 1/2 water service upgrade: 1 1/2 water service upgrade] , [1" water service upgrade: 1" water service upgrade] , [b-box repair: b-box repair] , ...57 more... )
• SERVICESIZE ( type: esriFieldTypeDouble, alias: LANDSCAPECONTRACTDATE )
• SETTLEPERIOD ( type: esriFieldTypeString, alias: STREETSCONTRACTDATE, length: 255 )
• LANDSCAPECONTRACTDATE ( type: esriFieldTypeDate, alias: SETTLEPERIOD, length: 8 )
• STREETSCONTRACTDATE ( type: esriFieldTypeDate, alias: STREETSCONTRACTDATE, length: 8 )
• WATERSEWERCOMPLETEDDATE ( type: esriFieldTypeDate, alias: WATERSEWERCOMPLETEDDATE, length: 8 )
• STREETSCOMPLETEDDATE ( type: esriFieldTypeDate, alias: STREETSCOMPLETEDDATE, length: 8 )
• PARKWAYCOMPLETEDDATE ( type: esriFieldTypeDate, alias: PARKWAYCOMPLETEDDATE, length: 8 )
• FORESTRYCOMPLETEDDATE ( type: esriFieldTypeDate, alias: FORESTRYCOMPLETEDDATE, length: 8 )
• ADDRESSNUMBER ( type: esriFieldTypeInteger, alias: ADDRESSNUMBER )
• STREETNAME_1 ( type: esriFieldTypeString, alias: STREETNAME_1, length: 50 , Coded Values: [ADAMS ST: ADAMS ST] , [AUGUSTA ST: AUGUSTA ST] , [BELLEFORTE AVE: BELLEFORTE AVE] , ...90 more... )
• STREETNAME_2 ( type: esriFieldTypeString, alias: STREETNAME_2, length: 50 , Coded Values: [ADAMS ST: ADAMS ST] , [AUGUSTA ST: AUGUSTA ST] , [BELLEFORTE AVE: BELLEFORTE AVE] , ...90 more... )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, length: 255 )
• SECTION ( type: esriFieldTypeInteger, alias: SECTION )
• PARKWAY ( type: esriFieldTypeSmallInteger, alias: PARKWAY , Coded Values: [0: No] , [1: Yes] )
• PARKWAYWIDTH ( type: esriFieldTypeDouble, alias: PARKWAYWIDTH )
• PARKWAYLENGTH ( type: esriFieldTypeDouble, alias: PARKWAYLENGTH )
• PARKWAYDEPTH ( type: esriFieldTypeDouble, alias: PARKWAYDEPTH )
• PARKWAYAREA ( type: esriFieldTypeDouble, alias: PARKWAYAREA )
• STREETASPHALT ( type: esriFieldTypeSmallInteger, alias: ASPHALT , Coded Values: [0: No] , [1: Yes] )
• STREETCONCRETE ( type: esriFieldTypeSmallInteger, alias: CONCRETE , Coded Values: [0: No] , [1: Yes] )
• STREETLENGTH ( type: esriFieldTypeDouble, alias: STREETLENGTH )
• STREETWIDTH ( type: esriFieldTypeDouble, alias: STREETWIDTH )
• CURBLENGTH ( type: esriFieldTypeDouble, alias: CURBLENGTH )
• SIDEWALKSQUARES ( type: esriFieldTypeDouble, alias: SIDEWALKSQUARES )
• COACHWALKLENGTH ( type: esriFieldTypeDouble, alias: COACHWALKLENGTH )
• STREETFINALPAVEMENTLENGTH ( type: esriFieldTypeDouble, alias: STREETFINALPAVEMENTLENGTH )
• STREETFINALPAVEMENTWIDTH ( type: esriFieldTypeDouble, alias: Final Pavement Restoration Width )
• SQUAREYARDS ( type: esriFieldTypeDouble, alias: SQUAREYARDS )
• WINTERIZEEXCAVATION ( type: esriFieldTypeSmallInteger, alias: WINTERIZEEXCAVATION , Coded Values: [0: No] , [1: Yes] )
• DEWINTERIZEDATE ( type: esriFieldTypeDate, alias: DeWinterize Date, length: 8 )
• EMPLOYEECOUNT ( type: esriFieldTypeInteger, alias: EMPLOYEECOUNT )
• MANHOURS ( type: esriFieldTypeDouble, alias: MANHOURS )
• LABORCOST ( type: esriFieldTypeDouble, alias: LABORCOST )
• EQUIPMENTCOST ( type: esriFieldTypeDouble, alias: EQUIPMENTCOST )
• DIGCOST ( type: esriFieldTypeDouble, alias: DIGCOST )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 255 )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 255 )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, length: 20 )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, length: 15 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 20 )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• 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 )

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

  Iteminfo   Thumbnail   Metadata