View In:   ArcGIS Online Map Viewer

Name: Surplus

Display Field: Survey_Company_Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 6e65fa981a0c481eb01ed866f9fb45d5

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 415702.83220000006
YMin: 4483311.644300001
XMax: 424988.70999999996
YMax: 4500272.486500001
Spatial Reference: 26912  (26912)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SURPLUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Y
  Label: Y
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [230, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 0
Transparency: 50
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SURPLUS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Parcel_Number ( type: esriFieldTypeString, alias: Parcel Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Parcel_Number )
• Land_Owner ( type: esriFieldTypeString, alias: Land Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Land_Owner )
• Company_Contact ( type: esriFieldTypeString, alias: Company Contact, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Company_Contact )
• Affected ( type: esriFieldTypeString, alias: Affected, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Affected )
• Document_Type ( type: esriFieldTypeString, alias: Document Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Document_Type )
• Current_Submittal ( type: esriFieldTypeString, alias: Current Submittal, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Current_Submittal )
• First_Submittal ( type: esriFieldTypeString, alias: 1st Submittal, editable: true, nullable: true, length: 10, defaultValue: null, modelName: First_Submittal )
• Second_Submittal ( type: esriFieldTypeString, alias: 2nd Submittal, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Second_Submittal )
• Third_Submittal ( type: esriFieldTypeString, alias: 3rd Submittal, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Third_Submittal )
• Property_Address ( type: esriFieldTypeString, alias: Property Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Property_Address )
• Owner_Address ( type: esriFieldTypeString, alias: Owner Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Owner_Address )
• Owner_City ( type: esriFieldTypeString, alias: Owner City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner_City )
• Owner_State ( type: esriFieldTypeString, alias: Owner State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Owner_State )
• Owner_Zip ( type: esriFieldTypeDouble, alias: Owner Zip, editable: true, nullable: true, defaultValue: null, modelName: Owner_Zip )
• Ownership_Percent ( type: esriFieldTypeDouble, alias: Ownership Percent, editable: true, nullable: true, defaultValue: null, modelName: Ownership_Percent )
• Parcel_Tax_ID ( type: esriFieldTypeDouble, alias: Parcel Tax ID, editable: true, nullable: true, defaultValue: null, modelName: Parcel_Tax_ID )
• Phone_Number ( type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Phone_Number )
• Vesting_Instrument ( type: esriFieldTypeString, alias: Vesting Instrument, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Vesting_Instrument )
• Vesting_Entry_Number ( type: esriFieldTypeString, alias: Vesting Entry Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Vesting_Entry_Number )
• Vesting_Book_Number ( type: esriFieldTypeDouble, alias: Vesting Book Number, editable: true, nullable: true, defaultValue: null, modelName: Vesting_Book_Number )
• Vesting_Page_Number ( type: esriFieldTypeDouble, alias: Vesting Page Number, editable: true, nullable: true, defaultValue: null, modelName: Vesting_Page_Number )
• Site_Section ( type: esriFieldTypeSmallInteger, alias: Site Section, editable: true, nullable: true, defaultValue: null, modelName: Site_Section )
• Site_Township ( type: esriFieldTypeString, alias: Site Township, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Site_Township )
• Site_Range ( type: esriFieldTypeString, alias: Site Range, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Site_Range )
• Site_Latitude ( type: esriFieldTypeDouble, alias: Site Latitude, editable: true, nullable: true, defaultValue: null, modelName: Site_Latitude )
• Site_Longitude ( type: esriFieldTypeDouble, alias: Site Longitude, editable: true, nullable: true, defaultValue: null, modelName: Site_Longitude )
• Zoning ( type: esriFieldTypeString, alias: Property Type for E-Summ, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Zoning )
• Total_Property_Size_Sq_Ft ( type: esriFieldTypeDouble, alias: Total Property Size Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: Total_Property_Size_Sq_Ft )
• Parcel_ROW_Take_Sq_Ft ( type: esriFieldTypeDouble, alias: Parcel ROW Take Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: Parcel_ROW_Take_Sq_Ft )
• Parcel_Perpetual_Easement_Sq_Ft ( type: esriFieldTypeDouble, alias: Parcel Perpetual Easement Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: Parcel_Perpetual_Easement_Sq_Ft )
• Parcel_Temporary_Construction_E ( type: esriFieldTypeDouble, alias: Parcel Temporary Construction Easement Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: Parcel_Temporary_Construction_Easement_Sq_Ft )
• Existing_ROW_in_Deed_Sq_Ft ( type: esriFieldTypeDouble, alias: Existing ROW in Deed Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: Existing_ROW_in_Deed_Sq_Ft )
• Remaining_Sq_Ft_on_Left ( type: esriFieldTypeString, alias: Remaining Sq Ft on Left, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Remaining_Sq_Ft_on_Left )
• Remaining_Sq_Ft_on_Right ( type: esriFieldTypeString, alias: Remaining Sq Ft on Right, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Remaining_Sq_Ft_on_Right )
• Relocation ( type: esriFieldTypeString, alias: Relocation, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Relocation )
• Submitted_to_ROW_Design ( type: esriFieldTypeDate, alias: Submitted to ROW Design, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Submitted_to_ROW_Design )
• Submitted_for_Region ( type: esriFieldTypeDate, alias: Submitted for Region, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Submitted_for_Region )
• Region_QAQC ( type: esriFieldTypeDate, alias: Region QAQC, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Region_QAQC )
• Approved_by_Region ( type: esriFieldTypeDate, alias: Approved by Region, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Approved_by_Region )
• Final_Upload_to_EPM___PW ( type: esriFieldTypeDate, alias: Final Upload to EPM & PW, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Final_Upload_to_EPM___PW )
• Submitted_to_Complex ( type: esriFieldTypeDate, alias: Submitted to Complex, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Submitted_to_Complex )
• Approved_by_Complex ( type: esriFieldTypeDate, alias: Approved by Complex, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Approved_by_Complex )
• Appraisal_Ordered ( type: esriFieldTypeDate, alias: Appraisal_Ordered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Appraisal_Ordered )
• Appraisal_Complete ( type: esriFieldTypeDate, alias: Appraisal_Complete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Appraisal_Complete )
• Appraisal_Review ( type: esriFieldTypeDate, alias: Appraisal Review, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Appraisal_Review )
• Appraised_Value ( type: esriFieldTypeDouble, alias: Appraised Value, editable: true, nullable: true, defaultValue: null, modelName: Appraised_Value )
• Just_Compensation_Approval ( type: esriFieldTypeDate, alias: Just Compensation Approval, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Just_Compensation_Approval )
• Relocation_Study ( type: esriFieldTypeDate, alias: Relocation Study, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Relocation_Study )
• Offer_Made ( type: esriFieldTypeDate, alias: Offer Made, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Offer_Made )
• Option_4_Letter ( type: esriFieldTypeDate, alias: Option 4 Letter, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Option_4_Letter )
• Condemnation ( type: esriFieldTypeString, alias: Condemnation, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Condemnation )
• Occupancy ( type: esriFieldTypeDate, alias: Occupancy, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Occupancy )
• Target_Occupancy ( type: esriFieldTypeDate, alias: Target Occupancy, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Target_Occupancy )
• Price_per_Sq_Ft ( type: esriFieldTypeDouble, alias: Price per Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: Price_per_Sq_Ft )
• Easement_Value ( type: esriFieldTypeDouble, alias: Easement Value, editable: true, nullable: true, defaultValue: null, modelName: Easement_Value )
• Perpetual_Easement_65_percent_V ( type: esriFieldTypeDouble, alias: Perpetual Easement 65 percent Value Estimate, editable: true, nullable: true, defaultValue: null, modelName: Perpetual_Easement_65_percent_Value_Estimate )
• Cost_of_Land_Easement_Estimate_ ( type: esriFieldTypeDouble, alias: Cost of Land Easement Estimate Total, editable: true, nullable: true, defaultValue: null, modelName: Cost_of_Land_Easement_Estimate_Total )
• Estimated_Improvements_Acquired ( type: esriFieldTypeDouble, alias: Estimated Improvements Acquired, editable: true, nullable: true, defaultValue: null, modelName: Estimated_Improvements_Acquired )
• Estimated_Cost_to_Cure ( type: esriFieldTypeDouble, alias: Estimated Cost to Cure, editable: true, nullable: true, defaultValue: null, modelName: Estimated_Cost_to_Cure )
• Damages_and_Proximity ( type: esriFieldTypeDouble, alias: Damages and Proximity, editable: true, nullable: true, defaultValue: null, modelName: Damages_and_Proximity )
• Incentives ( type: esriFieldTypeDouble, alias: Incentives, editable: true, nullable: true, defaultValue: null, modelName: Incentives )
• Total_Estimated_Cost_for_Parcel ( type: esriFieldTypeDouble, alias: Total Estimated Cost for Parcel Acquisition or Relocation, editable: true, nullable: true, defaultValue: null, modelName: Total_Estimated_Cost_for_Parcel_Acquisition_or_Relocation )
• Items_in_Impacted_Area ( type: esriFieldTypeString, alias: Items in Impacted Area, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Items_in_Impacted_Area )
• Actual_Administrative_Settlemen ( type: esriFieldTypeDouble, alias: Actual Administrative Settlement Amount, editable: true, nullable: true, defaultValue: null, modelName: Actual_Administrative_Settlement_Amount )
• Actual_Contract_Condemnation_To ( type: esriFieldTypeDouble, alias: Actual Contract Condemnation Total Amount, editable: true, nullable: true, defaultValue: null, modelName: Actual_Contract_Condemnation_Total_Amount )
• Total_Money_of_Relocation_Claim ( type: esriFieldTypeDouble, alias: Total Money of Relocation Claims, editable: true, nullable: true, defaultValue: null, modelName: Total_Money_of_Relocation_Claims )
• Final_Total_Cost_of_the_Parcel ( type: esriFieldTypeDouble, alias: Final Total Cost of the Parcel, editable: true, nullable: true, defaultValue: null, modelName: Final_Total_Cost_of_the_Parcel )
• Difference_Estimate_and_Actual_ ( type: esriFieldTypeDouble, alias: Difference Estimate and Actual Final Cost, editable: true, nullable: true, defaultValue: null, modelName: Difference_Estimate_and_Actual_Final_Cost )
• Closing ( type: esriFieldTypeDate, alias: Closing, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Closing )
• Recording ( type: esriFieldTypeDate, alias: Recording, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Recording )
• UDOT_Site_Region ( type: esriFieldTypeSmallInteger, alias: UDOT Site Region, editable: true, nullable: true, defaultValue: null, modelName: UDOT_Site_Region )
• Void___Retain ( type: esriFieldTypeString, alias: Void & Retain, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Void___Retain )
• Void___Replace ( type: esriFieldTypeString, alias: Void & Replace, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Void___Replace )
• Void ( type: esriFieldTypeString, alias: Void, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Void )
• Survey_Company_Name ( type: esriFieldTypeString, alias: Survey Company Name, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Survey_Company_Name )
• Survey_Company_Phone_Number ( type: esriFieldTypeString, alias: Survey Company Phone Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Survey_Company_Phone_Number )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 3000, defaultValue: null, modelName: Notes )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectID )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Engineering Design: engineering design] , [ROW Design: row design] , [In Appraisal: in appraisal] , ...7 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Priority )
• test ( type: esriFieldTypeString, alias: test, editable: true, nullable: true, length: 50, defaultValue: null, modelName: test )
• OwnerContactName ( type: esriFieldTypeString, alias: OwnerContactName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerContactName )
• ProposedSubmittalNo ( type: esriFieldTypeString, alias: ProposedSubmittalNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProposedSubmittalNo )
• ProposedSubmittalDate ( type: esriFieldTypeDate, alias: Proposed SubmittalDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ProposedSubmittalDate )
• PropertyTypeForESumm ( type: esriFieldTypeString, alias: PropertyTypeForESumm, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PropertyTypeForESumm )
• SURPLUS ( type: esriFieldTypeString, alias: SURPLUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURPLUS , Coded Values: [Y: Y] , [N: N] )

Types:

ID: Y
Name: Y
Domains:
• Status:
  Inherited
• SURPLUS:
  Inherited
Templates:
• Name: Y
  Description:
  Prototype:
  PropertyTypeForESumm: null
  ProposedSubmittalDate: null
  Parcel_Number: null
  Land_Owner: null
  Company_Contact: null
  Affected: null
  Document_Type: null
  Current_Submittal: null
  First_Submittal: null
  Second_Submittal: null
  Third_Submittal: null
  Property_Address: null
  Owner_Address: null
  Owner_City: null
  Owner_State: null
  Owner_Zip: null
  Ownership_Percent: null
  Parcel_Tax_ID: null
  Phone_Number: null
  Vesting_Instrument: null
  Vesting_Entry_Number: null
  Vesting_Book_Number: null
  Vesting_Page_Number: null
  Site_Section: null
  Site_Township: null
  Site_Range: null
  Site_Latitude: null
  Site_Longitude: null
  Zoning: null
  Total_Property_Size_Sq_Ft: null
  Parcel_ROW_Take_Sq_Ft: null
  Parcel_Perpetual_Easement_Sq_Ft: null
  Parcel_Temporary_Construction_E: null
  Existing_ROW_in_Deed_Sq_Ft: null
  Remaining_Sq_Ft_on_Left: null
  Remaining_Sq_Ft_on_Right: null
  Relocation: null
  Submitted_to_ROW_Design: null
  Submitted_for_Region: null
  Region_QAQC: null
  Approved_by_Region: null
  Final_Upload_to_EPM___PW: null
  Submitted_to_Complex: null
  Approved_by_Complex: null
  Appraisal_Ordered: null
  Appraisal_Complete: null
  Appraisal_Review: null
  Appraised_Value: null
  Just_Compensation_Approval: null
  Relocation_Study: null
  Offer_Made: null
  Option_4_Letter: null
  Condemnation: null
  Occupancy: null
  Target_Occupancy: null
  Price_per_Sq_Ft: null
  Easement_Value: null
  Perpetual_Easement_65_percent_V: null
  Cost_of_Land_Easement_Estimate_: null
  Estimated_Improvements_Acquired: null
  Estimated_Cost_to_Cure: null
  Damages_and_Proximity: null
  Incentives: null
  Total_Estimated_Cost_for_Parcel: null
  Items_in_Impacted_Area: null
  Actual_Administrative_Settlemen: null
  Actual_Contract_Condemnation_To: null
  Total_Money_of_Relocation_Claim: null
  Final_Total_Cost_of_the_Parcel: null
  Difference_Estimate_and_Actual_: null
  Closing: null
  Recording: null
  UDOT_Site_Region: null
  Void___Retain: null
  Void___Replace: null
  Void: null
  Survey_Company_Name: null
  Survey_Company_Phone_Number: null
  Notes: null
  ProjectID: null
  Status: null
  SURPLUS: Y
  ProposedSubmittalNo: null
  OwnerContactName: null
  test: null
  Priority: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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