Name: project_info

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7ceca6fbe1504e8ab912d2730201035b

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• project_selection ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select a project to enter details on, type: esriFieldTypeString )
• project_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: What is the current status of the project, type: esriFieldTypeString , Coded Values: [In Progress: In Progress] , [Completed: Completed] )
• in_progress ( nullable: true, editable: true, defaultValue: null, length: 255, alias: We will keep this project in our system for future updating. If you have other projects please continue, otherwise submit the form, type: esriFieldTypeString )
• general_contractor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the General Contractor, type: esriFieldTypeString )
• gc_company_info ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Company Contact Info, type: esriFieldTypeString )
• gc_info_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Based on the Company Contact info above, make the appropriate selection., type: esriFieldTypeString , Coded Values: [No Changes: No changes needed] , [Modify: Modifications needed] , [All New: All new information needed] )
• gc_mod_fields ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select which fields you need to edit, type: esriFieldTypeString )
• gc_company_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Company Name, type: esriFieldTypeString )
• gc_address_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Address, type: esriFieldTypeString )
• gc_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor City, type: esriFieldTypeString )
• gc_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor State, type: esriFieldTypeString )
• gc_zip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Zip Code, type: esriFieldTypeString )
• gc_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Phone, type: esriFieldTypeString )
• gc_web ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Website, type: esriFieldTypeString )
• gc_service_lines ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the General Contractors conducted service lines for this project, type: esriFieldTypeString )
• success ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was project completed by the contractor succesfully?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• unsucessful ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Please breifly describe why the project was not completed successfully, type: esriFieldTypeString )
• evaluation_go ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Would you like to perform the contractor evaluation now?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• idot_eval ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was this an IDOT project, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• idot_eval_note ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Use the following link and completed and submit form to IDOT, type: esriFieldTypeString )
• organization_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score for Contractors Organizational apptitude, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• cooperation_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score for Contractors Cooperation during project, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• comm_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score fo Overall Communication during the project, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• quality_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score for workmanship, craftsmanship, etc.., type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• eval_points ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Calculated weighted points, type: esriFieldTypeString )
• eval_score ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Evaluation Score, type: esriFieldTypeString )
• low_eval_score ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Evaluation scores below 70% require commentary!, type: esriFieldTypeString )
• low_eval_comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Provide comments on why the contractor failed to meet minimum evaluation score, type: esriFieldTypeString )
• sig_subs_on ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did the project contain any significant or unique sub-contractors?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• sig_sub_count ( nullable: true, editable: true, defaultValue: null, length: 255, alias: How many significant / unique sub-contractors would you like to add?, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• enter_qtys ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Would you like to enter project quantities now?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• types ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the project type, type: esriFieldTypeString , Coded Values: [Bike Path Improvements: Bike Path Improvements] , [Drainage Grading: Drainage Grading] , [Native Restoration: Native Restoration] , ...5 more... )
• construct_value ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Enter Construction Value, type: esriFieldTypeString )
• fund_source ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the primary funding mechanism, type: esriFieldTypeString , Coded Values: [Federal: Federal] , [Local: Local] , [MFT: MFT] , ...1 more... )
• qty_items ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select each of the major items on the project, type: esriFieldTypeString )
• qty_note_count ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Item Count, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• project_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Number, type: esriFieldTypeString )
• enter_consultant ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did GHA use sub-consultants on this project?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• subconsultant ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the Subconsultant, type: esriFieldTypeString )
• consultant_company_info ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Consultant Contact Info, type: esriFieldTypeString )
• subconsult_info_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Based on the Company Contact info above, make the appropriate selection., type: esriFieldTypeString , Coded Values: [No Changes: No changes needed] , [Modify: Modifications needed] , [All New: All new information needed] )
• subconsult_mod_fields ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select which fields you need to edit, type: esriFieldTypeString )
• subconsult_company_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant Company Name, type: esriFieldTypeString )
• subconsult_address_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant Address, type: esriFieldTypeString )
• subconsult_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant City, type: esriFieldTypeString )
• subconsult_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant State, type: esriFieldTypeString )
• subconsult_zip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant Zip Code, type: esriFieldTypeString )
• subconsult_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant Phone, type: esriFieldTypeString )
• subconsult_web ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subconsultant Website, type: esriFieldTypeString )
• subconsult_service_lines ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the Subconsultants conducted service line for this project, type: esriFieldTypeString , Coded Values: [Geotechnical: Geotechnical] , [Environmental: Environmental] , [Ecological: Ecological] , ...3 more... )
• subconsult_eval_go ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Would you like to perform the subconsultant evaluation now?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• subcons_org_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score for Subconsultants Organizational apptitude, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• subcons_coop_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score for Subconsultants Cooperation during project, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• subcons_comm_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score fo Overall Communication during the project, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• subcons_quality_scr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Score for workmanship, craftsmanship, etc.., type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• subcons_eval_points ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Calculated weighted points, type: esriFieldTypeString )
• subcons_eval_score ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Evaluation Score, type: esriFieldTypeString )
• subcons_low_eval_score ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Evaluation scores below 70% require commentary!, type: esriFieldTypeString )
• subcons_comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Provide comments on why the contractor failed to meet minimum evaluation score, type: esriFieldTypeString )

Relationships:

• Contractor_Updating_project_info (0) -- Related To: Contractor_Updating (0)
• project_info_sigsub_info (1) -- Related To: sigsub_info (2)
• project_info_qty_repeat (2) -- Related To: qty_repeat (3)

Capabilities: Create,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

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

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata