Name: project_info

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 642db0cc9a984bcd8df1a5db8455930c

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, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• 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_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Number, 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_add ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Do you need to add a new general contractor?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• gc_info_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Based on the company info above, make the appropriate selection., type: esriFieldTypeString )
• gc_mod_fields ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select which fields you need to edit, type: esriFieldTypeString )
• gc_address_1_mod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Address, type: esriFieldTypeString )
• gc_city_mod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor City, type: esriFieldTypeString )
• gc_state_mod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor State, type: esriFieldTypeString )
• gc_zip_mod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Zip Code, type: esriFieldTypeString )
• gc_phone_mod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Phone, type: esriFieldTypeString )
• gc_web_mod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor Website, 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_company_name_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Company Name Final, type: esriFieldTypeString )
• gc_address_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Address Final, type: esriFieldTypeString )
• gc_city_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC City Final, type: esriFieldTypeString )
• gc_state_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC State Final, type: esriFieldTypeString )
• gc_zip_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Zip Final, type: esriFieldTypeString )
• gc_phone_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Phone Final, type: esriFieldTypeString )
• gc_web_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Website Final, type: esriFieldTypeString )
• gc_info_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Final Geocode Address, type: esriFieldTypeString )
• gc_geocode_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Geocode Address, type: esriFieldTypeString )
• gc_x_geocode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Address X, type: esriFieldTypeString )
• gc_y_geocode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Address Y, type: esriFieldTypeString )
• gc_service_lines ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Select the Service Lines of this General Contractor 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 Aptitude, type: esriFieldTypeString )
• 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, alias: Calculated weighted points, type: esriFieldTypeInteger )
• eval_score ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Evaluation Score, type: esriFieldTypeString )
• low_eval_comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Evaluation scores below 70% require commentary! 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_consultant ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did GHA use Consultants on this project?, type: esriFieldTypeString )
• subconsult_count ( nullable: true, editable: true, defaultValue: null, length: 255, alias: How many GHA Consultants would you like to add?, type: esriFieldTypeString )
• 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: [Drainage Grading: Drainage Grading] , [Native Restoration: Native Restoration] , [Parking Lot Recon: Parking Lot Reconstruction] , ...9 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 )
• gc_known_id ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor ID known, type: esriFieldTypeString )
• gc_id ( nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor ID, type: esriFieldTypeString )
• gc_id_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Company ID Final, type: esriFieldTypeString )
• gc_service_line_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Enter the "other" service lines, type: esriFieldTypeString )
• gc_known_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC known address, type: esriFieldTypeString )
• gc_known_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC known city, type: esriFieldTypeString )
• gc_known_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC known state, type: esriFieldTypeString )
• gc_known_zip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC known zip, type: esriFieldTypeString )
• gc_known_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC known phone, type: esriFieldTypeString )
• gc_known_web ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC known email, type: esriFieldTypeString )
• gc_known_info ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Verify General Contractor Contact Information, type: esriFieldTypeString )
• gc_service_lines_final ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GC Service Lines Final, type: esriFieldTypeString )

Relationships:

• Draft_Evaluation_project_info (0) -- Related To: Draft_Evaluation (0)
• project_info_sigsub_info (1) -- Related To: sigsub_info (2)
• project_info_subconsult_info (2) -- Related To: subconsult_info (3)
• project_info_qty_repeat (3) -- Related To: qty_repeat (4)

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