Name: Service Point

Display Field: lakegis.SDE.UTIL_SANITARY_ACCOUNTS.ACCOUNT_NU

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 7100

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2246252.647451341
YMin: 698505.1401064545
XMax: 2376552.495610714
YMax: 800054.9612846226
Spatial Reference: 102722  (3734)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: lakegis.SDE.UTIL_SANITARY_ACCOUNTS.PermitStatus
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Insp
  Label: Inspected
  Description:
  Symbol:
  
• Value: Sch
  Label: Scheduled
  Description:
  Symbol:
  
• Value: Per
  Label: Permitted
  Description:
  Symbol:
  
• Value: CutC
  Label: Cut and Cap
  Description:
  Symbol:
  
• Value: Con
  Label: Connected
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: [lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Permit] CONCAT NEWLINE CONCAT NEWLINE CONCAT [LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Account_Number]
Use Coded Values: true
Symbol:
Color: [230, 152, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 35
YOffset: 2
Size: 11
Font Family: Times New Roman
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2000.0
Max. Scale: 0.0

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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.mlocStrNo ( type: esriFieldTypeString, alias: mlocStrNo, length: 10 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.mlocStrNam ( type: esriFieldTypeString, alias: mlocStrNam, length: 50 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.mlocStrSuf ( type: esriFieldTypeString, alias: mlocStrSuf, length: 10 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Lat_Long ( type: esriFieldTypeString, alias: Lat Long, length: 50 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.GIS_Juris ( type: esriFieldTypeString, alias: GIS_Juris, length: 2 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.OID_ ( type: esriFieldTypeInteger, alias: OID_ )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.ACCOUNT_NU ( type: esriFieldTypeString, alias: Account No., length: 15 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.NAME ( type: esriFieldTypeString, alias: Name, length: 38 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.SERVICE_AD ( type: esriFieldTypeString, alias: Service Address, length: 31 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.PARCEL_ID ( type: esriFieldTypeString, alias: Parcel, length: 20 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.EXPPERDAT ( type: esriFieldTypeDate, alias: Permit Expiration Date, length: 8 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.PermitStatus ( type: esriFieldTypeString, alias: Permit Status, length: 50 , Coded Values: [Con: Connected] , [Sch: Scheduled] , [Per: Permitted] , ...6 more... )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.InspSchDate ( type: esriFieldTypeDate, alias: Scheduled Date, length: 8 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Permit ( type: esriFieldTypeString, alias: Permit, length: 50 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Link ( type: esriFieldTypeString, alias: Link, length: 150 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Inspection_Type ( type: esriFieldTypeString, alias: Inspection Type, length: 50 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 , Coded Values: [KM: K. McCloskey] , [BC: B. Cook] , [LC: L. Crosby] , ...11 more... )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.INDSCAT ( type: esriFieldTypeString, alias: Industrial Category, length: 50 , Coded Values: [SIU: Significant Industrial User] , [SINND: Significant Industrial User(Non-Discharge)] , [IU: Industrial User] , ...6 more... )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.FACILTYID ( type: esriFieldTypeString, alias: FACILTYID, length: 50 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Contact_No ( type: esriFieldTypeString, alias: Contact Number, length: 15 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Industrial_Zone ( type: esriFieldTypeString, alias: Industrial_Zone, length: 50 , Coded Values: [A1: A1] , [B1: B1] , [C1: C1] , ...52 more... )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Credit ( type: esriFieldTypeDouble, alias: Credit )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Meter_Size ( type: esriFieldTypeString, alias: Meter_Size, length: 50 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Inspection_Deposit ( type: esriFieldTypeDouble, alias: Inspection_Deposit )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.City ( type: esriFieldTypeString, alias: City, length: 150 )
• lakegis.SDE.UTIL_SANITARY_ACCOUNTS.Connection_Type ( type: esriFieldTypeString, alias: Connection Type, length: 50 , Coded Values: [Apartment: Apartment] , [NonResidential: Non-Residential] , [Condo: Condo] , ...2 more... )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Account_Number ( type: esriFieldTypeString, alias: Account Number, length: 30 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Start_Date ( type: esriFieldTypeDate, alias: Start Date, length: 8 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Stop_Date ( type: esriFieldTypeDate, alias: Stop Date, length: 8 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Account_Type ( type: esriFieldTypeString, alias: Account Type, length: 2 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Parcel_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 30 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Read_Location ( type: esriFieldTypeString, alias: Read Location, length: 65 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.District ( type: esriFieldTypeString, alias: District, length: 2 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Service_Unit ( type: esriFieldTypeString, alias: Service Unit, length: 5 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Service_City ( type: esriFieldTypeString, alias: Service City, length: 4 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Service_Lot ( type: esriFieldTypeString, alias: Service Lot, length: 10 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Steet_Number ( type: esriFieldTypeInteger, alias: Steet Number )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Streer_Suffix ( type: esriFieldTypeString, alias: Streer Suffix, length: 5 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Streer_Post_Direction ( type: esriFieldTypeString, alias: Street Post Direction, length: 4 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Streer_Pre_Direction ( type: esriFieldTypeString, alias: Street Pre Direction, length: 4 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Street_Type ( type: esriFieldTypeString, alias: Street Type, length: 10 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Service_Street ( type: esriFieldTypeString, alias: Service Street, length: 25 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Service_Zip_Code ( type: esriFieldTypeString, alias: Service Zip Code, length: 10 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Account_Create_Date ( type: esriFieldTypeDate, alias: Account Create Date, length: 8 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Read_Sequence ( type: esriFieldTypeInteger, alias: Read Sequence )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Route_Book ( type: esriFieldTypeString, alias: Route Book, length: 6 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Backflow_Required ( type: esriFieldTypeString, alias: Backflow Required, length: 1 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Customer_ID ( type: esriFieldTypeInteger, alias: Customer ID )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Addtional_Adress ( type: esriFieldTypeSmallInteger, alias: Addtional Address )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Hold_Bill ( type: esriFieldTypeString, alias: Hold Bill, length: 1 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Phone_Number ( type: esriFieldTypeString, alias: Phone Number, length: 20 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Billable ( type: esriFieldTypeString, alias: Billable, length: 1 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Delivery_Method ( type: esriFieldTypeString, alias: Delivery Method, length: 1 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Billing_Comment ( type: esriFieldTypeString, alias: Billing Comment, length: 30 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Mailing_Name_1 ( type: esriFieldTypeString, alias: Mailing Name 1, length: 64 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Mailing_Name_2 ( type: esriFieldTypeString, alias: Mailing Name 2, length: 64 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Customer_Phone ( type: esriFieldTypeString, alias: Customer Phone, length: 20 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Customer_Email ( type: esriFieldTypeString, alias: Customer Email, length: 254 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Update_Date ( type: esriFieldTypeDate, alias: Update Date, length: 8 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Update_By ( type: esriFieldTypeString, alias: Update By, length: 20 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Account_Key ( type: esriFieldTypeInteger, alias: Account Key )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Meter_Size ( type: esriFieldTypeString, alias: Meter Size, length: 10 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Customer_Start_Date ( type: esriFieldTypeDate, alias: Customer Start Date, length: 8 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Meter_Serial ( type: esriFieldTypeString, alias: Meter Serial, length: 15 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Meter_Install ( type: esriFieldTypeDate, alias: Meter Install, length: 8 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Meter_Remote ( type: esriFieldTypeString, alias: Meter Remote, length: 15 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Service_Status ( type: esriFieldTypeString, alias: Service Status, length: 1 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Type_ ( type: esriFieldTypeString, alias: Type, length: 50 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Acitve ( type: esriFieldTypeString, alias: LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Acitve, length: 1 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Primary_Name ( type: esriFieldTypeString, alias: Primary Name, length: 64 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Secondary_Name ( type: esriFieldTypeString, alias: Secondary Name, length: 64 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Mailing_Name_3 ( type: esriFieldTypeString, alias: Mailing Address 3, length: 64 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Phone_Type ( type: esriFieldTypeString, alias: Phone Type, length: 20 )
• LakeGIS.sde.UTIL_MUNIS_ACCOUNT_RECORDS.Primary_Address ( type: esriFieldTypeString, alias: Primary Address, length: 1 )

Relationships:

• Sanitary Permit Survey (0) -- Related To: Sanitary Permit Survey (26)
• Sanitary_Inspections_Survey (1) -- Related To: Sanitary Inspections (24)
• lakegis.SDE.UTIL_MUNIS_ut_consumption (2) -- Related To: Sanitary - Consumption (28)
• LakeGIS.SDE.UTIL_MUNIS_ut_bill_summary (3) -- Related To: Sanitary - Bill Summary (29)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata