Name: Customers

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryMultipoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1028770.01372824
YMin: 1999029.63186548
XMax: 1113937.83501217
YMax: 2103254.88473002
Spatial Reference: PROJCS["NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-88.33333333333333],PARAMETER["Scale_Factor",0.999975],PARAMETER["Latitude_Of_Origin",36.66666666666666],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[155,71,151,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• AcctNum (type: esriFieldTypeString, alias: Account #, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CustNum (type: esriFieldTypeString, alias: CustNum, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• AcctStatus (type: esriFieldTypeString, alias: AcctStatus, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• AddressLine1 (type: esriFieldTypeString, alias: AddressLine1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddressLine2 (type: esriFieldTypeString, alias: AddressLine2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Cycle (type: esriFieldTypeString, alias: Cycle, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Book (type: esriFieldTypeString, alias: Book, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Sewer (type: esriFieldTypeString, alias: Sewer, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Water (type: esriFieldTypeString, alias: Water, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Irrigation (type: esriFieldTypeString, alias: Irrigation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Deduct (type: esriFieldTypeString, alias: Deduct, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• BasicMultiplier (type: esriFieldTypeDouble, alias: Residential Equiv, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FirstName (type: esriFieldTypeString, alias: FirstName, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• StreetAddress (type: esriFieldTypeString, alias: StreetAddress, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• AcctType (type: esriFieldTypeString, alias: Account Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [RE: Residential], [CO: Non-Residential])
• retired (type: esriFieldTypeSmallInteger, alias: Retired Feature, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• sub_accts (type: esriFieldTypeSmallInteger, alias: Sub-Accounts, SQL Type: sqlTypeOther, nullable: true, editable: true)
• watersystem (type: esriFieldTypeString, alias: Water System, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [VERNON HILLS: Vernon Hills], [WILDWOOD: Wildwood], [GRANDWOOD PARK: Grandwood Park], ... 10 more ...)
• sewersystem (type: esriFieldTypeString, alias: Sewer System, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [SC: South Central], [NW: Northwest], [SE: Southeast], ... 3 more ...)
• opsarea (type: esriFieldTypeString, alias: Operational Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• incorporated (type: esriFieldTypeString, alias: Incorporated, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [I: Incorporated], [U: Unincorporated])
• class_desc_pardat (type: esriFieldTypeString, alias: Property Class Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [COM: COM-Commercial], [EX: EX-Exempt], [FA: FA-Farm A], ... 4 more ...)

Templates:

Name: Customers
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/13/2024 1:36:44 PM

Schema Last Edit Date: 9/13/2024 1:36:44 PM

Data Last Edit Date: 9/13/2024 1:36:31 PM

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