Name: join.csv

Display Field: asset_name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OID_ (type: esriFieldTypeInteger, alias: OID_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• asset_clas (type: esriFieldTypeString, alias: asset_clas, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• asset_id (type: esriFieldTypeString, alias: asset_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• system_nam (type: esriFieldTypeString, alias: system_nam, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• asset_grou (type: esriFieldTypeString, alias: asset_grou, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• asset_type (type: esriFieldTypeString, alias: asset_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• material (type: esriFieldTypeString, alias: material, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• size_ (type: esriFieldTypeString, alias: size_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• quantity_l (type: esriFieldTypeDouble, alias: quantity_l, SQL Type: sqlTypeOther, nullable: true, editable: true)
• width (type: esriFieldTypeString, alias: width, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• depth (type: esriFieldTypeString, alias: depth, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• diameter (type: esriFieldTypeInteger, alias: diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• height (type: esriFieldTypeInteger, alias: height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• community (type: esriFieldTypeString, alias: community, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• unit_cost (type: esriFieldTypeString, alias: unit_cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• base_life (type: esriFieldTypeInteger, alias: base_life, SQL Type: sqlTypeOther, nullable: true, editable: true)
• condition (type: esriFieldTypeString, alias: condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• performanc (type: esriFieldTypeString, alias: performanc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accuracy (type: esriFieldTypeString, alias: accuracy, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• criticalit (type: esriFieldTypeString, alias: criticalit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• us_invert (type: esriFieldTypeString, alias: us_invert, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ds_invert (type: esriFieldTypeString, alias: ds_invert, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• us_node (type: esriFieldTypeString, alias: us_node, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ds_node (type: esriFieldTypeString, alias: ds_node, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• purchase_c (type: esriFieldTypeString, alias: purchase_c, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• contract_n (type: esriFieldTypeString, alias: contract_n, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• base_life_ (type: esriFieldTypeString, alias: base_life_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• unit_rate_ (type: esriFieldTypeString, alias: unit_rate_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• unit_rate1 (type: esriFieldTypeString, alias: unit_rate1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• project_id (type: esriFieldTypeString, alias: project_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• asset_owne (type: esriFieldTypeString, alias: asset_owne, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• source (type: esriFieldTypeString, alias: source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• interpolat (type: esriFieldTypeString, alias: interpolat, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• residual_v (type: esriFieldTypeString, alias: residual_v, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• descriptio (type: esriFieldTypeString, alias: descriptio, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• method (type: esriFieldTypeString, alias: method, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• risk (type: esriFieldTypeString, alias: risk, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• dep_asset (type: esriFieldTypeString, alias: dep_asset, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• reason_for (type: esriFieldTypeString, alias: reason_for, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• edited_by (type: esriFieldTypeString, alias: edited_by, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• insurer (type: esriFieldTypeString, alias: insurer, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• fair_value (type: esriFieldTypeString, alias: fair_value, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accumulate (type: esriFieldTypeString, alias: accumulate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• asset_name (type: esriFieldTypeString, alias: asset_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• asbestos (type: esriFieldTypeString, alias: asbestos, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• condition_ (type: esriFieldTypeString, alias: condition_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• full_name (type: esriFieldTypeString, alias: full_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• imp_curve (type: esriFieldTypeString, alias: imp_curve, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_insta (type: esriFieldTypeDate, alias: date_insta, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• date_optio (type: esriFieldTypeString, alias: date_optio, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_renew (type: esriFieldTypeDate, alias: date_renew, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• date_dispo (type: esriFieldTypeString, alias: date_dispo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_found (type: esriFieldTypeString, alias: date_found, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_edite (type: esriFieldTypeDate, alias: date_edite, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• date_fair_ (type: esriFieldTypeString, alias: date_fair_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_accum (type: esriFieldTypeString, alias: date_accum, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_accur (type: esriFieldTypeString, alias: date_accur, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_condi (type: esriFieldTypeString, alias: date_condi, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_criti (type: esriFieldTypeString, alias: date_criti, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_perfo (type: esriFieldTypeString, alias: date_perfo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• globalid (type: esriFieldTypeString, alias: globalid, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SHAPE__Len (type: esriFieldTypeDouble, alias: SHAPE__Len, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asset_ID_1 (type: esriFieldTypeString, alias: Asset_ID_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• US_MH_ID (type: esriFieldTypeString, alias: US_MH_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DS_MH_ID (type: esriFieldTypeString, alias: DS_MH_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• US_ADDRESS (type: esriFieldTypeString, alias: US_ADDRESS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DS_ADDRESS (type: esriFieldTypeString, alias: DS_ADDRESS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MAT (type: esriFieldTypeString, alias: MAT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DIA (type: esriFieldTypeInteger, alias: DIA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOINT_SPACING (type: esriFieldTypeDouble, alias: JOINT_SPACING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VIDEOS (type: esriFieldTypeString, alias: VIDEOS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REPORTS (type: esriFieldTypeString, alias: REPORTS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GRADE (type: esriFieldTypeDouble, alias: GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GIS_MATERIAL (type: esriFieldTypeString, alias: GIS_MATERIAL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GIS_DIAMETER (type: esriFieldTypeInteger, alias: GIS_DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GIS_LENGTH (type: esriFieldTypeDouble, alias: GIS_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAT_NOTE (type: esriFieldTypeString, alias: MAT_NOTE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DIA_NOTE (type: esriFieldTypeString, alias: DIA_NOTE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LENGTH_NOTE (type: esriFieldTypeString, alias: LENGTH_NOTE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ABANDONED (type: esriFieldTypeString, alias: ABANDONED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REVIEW (type: esriFieldTypeString, alias: REVIEW, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REASON__PIM_GRADE (type: esriFieldTypeString, alias: REASON__PIM_GRADE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIM_GRADE (type: esriFieldTypeDouble, alias: PIM_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTES_1 (type: esriFieldTypeString, alias: NOTES_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PEAK_SCORE (type: esriFieldTypeInteger, alias: PEAK_SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOF_GRADE (type: esriFieldTypeInteger, alias: LOF_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FREE_DRAINING (type: esriFieldTypeString, alias: FREE_DRAINING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MINIMUM_WORKS_REQUIRED (type: esriFieldTypeString, alias: MINIMUM_WORKS_REQUIRED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FILE_ (type: esriFieldTypeString, alias: FILE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VIDEO (type: esriFieldTypeInteger, alias: VIDEO, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: join.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/17/2021 9:56:51 PM

Schema Last Edit Date: 5/17/2021 9:56:51 PM

Data Last Edit Date: 5/17/2021 9:56:51 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat