All Layers and Tables (STCH_Service_Line_Inventory

Layers:

Layer: STCH_Service_Line_Inventory (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"authoringInfo":{},"type":"uniqueValue","field1":"PWS_OWNED_SERVICE_LINE_MATERIAL","uniqueValueInfos":[{"value":"Copper","symbol":{"color":[0,112,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Copper"},{"value":"Galvanized","symbol":{"color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Galvanized"},{"value":"Unknown","symbol":{"color":[255,255,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Unknown"},{"value":"Other-Non-Lead","symbol":{"color":[115,178,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[115,178,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Other-Non-Lead"}]},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
WATER_SYSTEM_ID_NUMBER (type: esriFieldTypeString, alias: WATER SYSTEM ID NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
SYSTEM_SPECIFIC_ID (type: esriFieldTypeString, alias: SYSTEM SPECIFIC ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
WATER_SYSTEM_COMMON_NAME (type: esriFieldTypeString, alias: WATER SYSTEM COMMON NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
SERVICE_ADDRESS (type: esriFieldTypeString, alias: SERVICE ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
ZIPCODE (type: esriFieldTypeInteger, alias: ZIPCODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
WATER_MAIN_MATERIAL (type: esriFieldTypeString, alias: WATER MAIN MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
CONNECTOR_OR_GOOSENECK_MATERIAL (type: esriFieldTypeString, alias: CONNECTOR OR GOOSENECK MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
WAS_LEAD_EVER_UPSTREAM_OF_THIS_ (type: esriFieldTypeString, alias: WAS LEAD EVER UPSTREAM OF THIS SERVICE?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
PWS_OWNED_SERVICE_LINE_MATERIAL (type: esriFieldTypeString, alias: PWS-OWNED SERVICE LINE MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
WAS_PWS_OWNED_SERVICE_LINE_EVER (type: esriFieldTypeString, alias: WAS PWS-OWNED SERVICE LINE EVER LEAD?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
PWS_OWNED_SERVICE_LINE_SIZE (type: esriFieldTypeString, alias: PWS-OWNED SERVICE LINE SIZE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
YEAR_PWS_OWNED_SERVICE_LINE_INS (type: esriFieldTypeInteger, alias: YEAR PWS-OWNED SERVICE LINE INSTALLED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
CUSTOMER_OWNED_SERVICE_LINE_MAT (type: esriFieldTypeString, alias: CUSTOMER-OWNED SERVICE LINE MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
CUSTOMER_OWNED_SERVICE_LINE_SIZ (type: esriFieldTypeString, alias: CUSTOMER-OWNED SERVICE LINE SIZE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
YEAR_CUSTOMER_OWNED_SERVICE_LIN (type: esriFieldTypeInteger, alias: YEAR CUSTOMER-OWNED SERVICE LINE INSTALLED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
BUILDING_TYPE (type: esriFieldTypeString, alias: BUILDING TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
POINT_OF_ENTRY_OR_POINT_OF_USE_ (type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATEMENT PRESENT?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
STRUCTURE____PRIMARY_PLUMBING_M (type: esriFieldTypeString, alias: STRUCTURE - PRIMARY PLUMBING MATERIAL 1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
YEAR_STRUCTURE_PLUMBING_INSTALL (type: esriFieldTypeInteger, alias: YEAR STRUCTURE PLUMBING INSTALLED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
YEAR__RANGE__STRUCTURE_PLUMBING (type: esriFieldTypeString, alias: YEAR (RANGE) STRUCTURE PLUMBING MATERIAL INSTALLED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
THIS_LOCATION_WILL_BE_USED_FOR_ (type: esriFieldTypeString, alias: THIS LOCATION WILL BE USED FOR LEAD AND COPPER SAMPLE SITE PLAN?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
SOURCE_1__PWS_OWNED_SERVICE_LIN (type: esriFieldTypeInteger, alias: SOURCE 1: PWS-OWNED SERVICE LINE ID METHOD OR INFO USED (ENTER ONE OR MORE), SQL Type: sqlTypeInteger, nullable: true, editable: true)
SOURCE_2__CUSTOMER_OWNED_SERVIC (type: esriFieldTypeInteger, alias: SOURCE 2: CUSTOMER-OWNED SERVICE LINE ID METHOD OR INFO USED (ENTER ONE OR MORE), SQL Type: sqlTypeInteger, nullable: true, editable: true)
x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeFloat, nullable: true, editable: true)
y (type: esriFieldTypeDouble, alias: y, SQL Type: sqlTypeFloat, nullable: true, editable: true)
ObjectId2 (type: esriFieldTypeOID, alias: ObjectId2, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

PWS_OWNED_SERVICE_LINE_MATERIAL: Copper

PWS_OWNED_SERVICE_LINE_MATERIAL: Galvanized

PWS_OWNED_SERVICE_LINE_MATERIAL: Unknown

PWS_OWNED_SERVICE_LINE_MATERIAL: Other-Non-Lead

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (STCH_Service_Line_Inventory_view)

Layers:

Layer: STCH_Service_Line_Inventory (0)