View In:   ArcGIS Online Map Viewer

Name: VOP Excavation Locations - Restoration Complete

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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:

Fields:

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

Templates:

• Name: Excavation Locations - Restoration Complete
  Description: Excavation is fully completed
  Prototype:
  SOURCE: null
  STREETSCONTRACTDATE: null
  STREETSCOMPLETEDDATE: 1546300800000
  WATERSEWERCOMPLETEDDATE: 1546300800000
  PARKWAYCOMPLETEDDATE: 1546300800000
  PRODUCTIONNOTES: null
  DIGNUMBER: null
  DIGDATE: null
  DIGTYPE: null
  SERVICESIZE: null
  SETTLEPERIOD: null
  LANDSCAPECONTRACTDATE: null
  FORESTRYCOMPLETEDDATE: 1546300800000
  ADDRESSNUMBER: null
  STREETNAME_1: null
  STREETNAME_2: null
  LOCATIONDESCRIPTION: null
  SECTION: null
  PARKWAY: null
  PARKWAYWIDTH: null
  PARKWAYLENGTH: null
  PARKWAYDEPTH: null
  PARKWAYAREA: null
  STREETASPHALT: null
  STREETCONCRETE: null
  STREETLENGTH: null
  STREETWIDTH: null
  CURBLENGTH: null
  SIDEWALKSQUARES: null
  COACHWALKLENGTH: null
  STREETFINALPAVEMENTLENGTH: null
  STREETFINALPAVEMENTWIDTH: null
  SQUAREYARDS: null
  WINTERIZEEXCAVATION: null
  DEWINTERIZEDATE: null
  EMPLOYEECOUNT: null
  MANHOURS: null
  LABORCOST: null
  EQUIPMENTCOST: null
  DIGCOST: null
  COMMENTS: null
  DATECREATED: null
  DATEMODIFIED: null
  MODIFIEDBY: null
  CREATEDBY: null
  SOURCETYPE: null
  FEATUREID: null
  REPLICAFILTER: null
  GEODBID: 026
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata