Name: BusinessDistrictSurvey

Display Field: STARTSURVEY

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b4a950fb4bd547e18ca902cbd4640cf5

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• DISTRICT ( type: esriFieldTypeInteger, alias: District )
• NAME_OF_BUILDING ( type: esriFieldTypeString, alias: Name of Building, length: 99 )
• FULLADDRESS ( type: esriFieldTypeString, alias: Address, length: 255 )
• SERIAL_NO ( type: esriFieldTypeString, alias: Serial Number, length: 25 )
• MTMSIZ ( type: esriFieldTypeString, alias: Meter Size, length: 15 , Coded Values: [A: 250 CFH] , [B: 400 CFH] , [C: 425 CFH] , ...16 more... )
• COMPANY_CD ( type: esriFieldTypeString, alias: Meter Manufacturer, length: 25 , Coded Values: [A: American] , [B: Schlumb] , [C: Roots] , ...2 more... )
• SUBCNTL_CD_SDESC ( type: esriFieldTypeString, alias: Location of Meter Installation, length: 250 )
• DELIVERYPRESSURE ( type: esriFieldTypeString, alias: Delivery Pressure, length: 25 , Coded Values: [DP: Distribution Pressure] , [IP: Intermediate Pressure] , [MP: Medium Pressure] , ...1 more... )
• MATERIALSVCENTRANCE ( type: esriFieldTypeString, alias: Material At Service Entrance, length: 25 , Coded Values: [BR: Brick] , [CI: Cinder] , [CO: Concrete] , ...8 more... )
• GROUNDLEVELINDICATOR ( type: esriFieldTypeString, alias: Service Entrance Indicator, length: 15 , Coded Values: [A: Above Ground] , [B: Below Ground] , [C: No Entry] )
• SVCPIPESIZE ( type: esriFieldTypeString, alias: Service Pipe Size, length: 25 , Coded Values: [1: 1] , [1.25: 1 1/4"] , [1.5: 1 1/2"] , ...11 more... )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Excellent: Excellent] , [Good: Good] , [OK: OK] , ...2 more... )
• lLeak ( type: esriFieldTypeString, alias: Is There A Leak?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter ( type: esriFieldTypeString, alias: Is There A Leak At Meter?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_MS ( type: esriFieldTypeString, alias: Is There A Leak At Meter Seams?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_MSLG ( type: esriFieldTypeString, alias: Meter Seam Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_MSLD ( type: esriFieldTypeString, alias: Meter Seam Leak Determiniation, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lMeter_MGD ( type: esriFieldTypeString, alias: Is There A Leak At Meter Glass or Dials?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_MGDLG ( type: esriFieldTypeString, alias: Meter Glass or Dials Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_MGDLD ( type: esriFieldTypeString, alias: Meter Glass or Dials Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lMeter_IS ( type: esriFieldTypeString, alias: Is There A Leak At Inlet Swivel?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_ISLG ( type: esriFieldTypeString, alias: Inlet Swivel Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_ISLD ( type: esriFieldTypeString, alias: Inlet Swivel Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lMeter_OS ( type: esriFieldTypeString, alias: Is There A Leak At Outlet Swivel?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_OSLG ( type: esriFieldTypeString, alias: Outlet Swivel Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_OSLD ( type: esriFieldTypeString, alias: Outlet Swivel Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lMeter_MGS ( type: esriFieldTypeString, alias: Is There A Leak At Meter Gaskets or Seals?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_MGSLG ( type: esriFieldTypeString, alias: Meter Gaskets or Seal Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_MGSLD ( type: esriFieldTypeString, alias: Meter Gaskets or Seal Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lMeter_MIV ( type: esriFieldTypeString, alias: Is There A Leak At Meter Inlet Swivel?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_MIVLG ( type: esriFieldTypeString, alias: Meter Inlet Valve Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_MIVLD ( type: esriFieldTypeString, alias: Meter Inlet Valve Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lMeter_ONM ( type: esriFieldTypeString, alias: Is There A Leak At Meter - Other?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lMeter_ONMC ( type: esriFieldTypeString, alias: Meter Leak Other Comment, length: 250 )
• lMeter_ONMDLG ( type: esriFieldTypeString, alias: Meter - Other Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lMeter_ONMDLD ( type: esriFieldTypeString, alias: Meter - Other Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lRegulator ( type: esriFieldTypeString, alias: Is There A Leak At The Regulator?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_RD ( type: esriFieldTypeString, alias: Is There A Leak At The Regulator Diaphragm?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_RDLG ( type: esriFieldTypeString, alias: Regulator Diaphragm Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lRegulator_RDLD ( type: esriFieldTypeString, alias: Regulator Diaphragm Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lRegulator_RCP ( type: esriFieldTypeString, alias: Is There A Leak At The Regulator Cleanout Plug?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_RCPLG ( type: esriFieldTypeString, alias: Regulator Cleanout Plug Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lRegulator_RCPLD ( type: esriFieldTypeString, alias: Regulator Cleanout Plug Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lRegulator_RIP ( type: esriFieldTypeString, alias: Is There A Leak At The Regulator Inspection Plug?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_RIPLG ( type: esriFieldTypeString, alias: Regulator Inspection Plug Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lRegulator_RIPLD ( type: esriFieldTypeString, alias: Regulator Inspection Plug Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lRegulator_ROS ( type: esriFieldTypeString, alias: Is There A Leak At Regulator Outlet Side?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_ROSLG ( type: esriFieldTypeString, alias: Regulator Outlet Side Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lRegulator_ROSLD ( type: esriFieldTypeString, alias: Regulator Outlet Side Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lRegulator_RIS ( type: esriFieldTypeString, alias: Is There A Leak At The Regulator Inlet Side?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_RISLG ( type: esriFieldTypeString, alias: Regulator Inlet Side Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lRegulator_RISLD ( type: esriFieldTypeString, alias: Regulator Inlet Side Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lRegulator_ONM ( type: esriFieldTypeString, alias: Is There A Leak At Regulator - Other, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lRegulator_ONMC ( type: esriFieldTypeString, alias: Regulator Other Comment, length: 250 )
• lRegulator_ONMLG ( type: esriFieldTypeString, alias: Regulator Other Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lRegulator_ONMLD ( type: esriFieldTypeString, alias: Regulator Other Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lCurbValve ( type: esriFieldTypeString, alias: Is There A Leak At The Curb Valve?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lCurbValve_LG ( type: esriFieldTypeString, alias: Curb Valve Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lCurbValve_LD ( type: esriFieldTypeString, alias: Curb Valve Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• lServicePiping ( type: esriFieldTypeString, alias: Is There A Leak At Service Piping?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• lServicePiping_LG ( type: esriFieldTypeString, alias: Service Piping Leak Grade, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• lServicePiping_LD ( type: esriFieldTypeString, alias: Service Piping Leak Determination, length: 50 , Coded Values: [CGI: CGI] , [Other: Other] , [Foam: Foam] )
• CURBVALVEOFF ( type: esriFieldTypeString, alias: Is Curb Valve Off?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• METERINLETVALVEOFF ( type: esriFieldTypeString, alias: Is Meter Inlet Valve Off?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• BUILVAC ( type: esriFieldTypeString, alias: Is The Building Vacant?, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• CHECKDATE ( type: esriFieldTypeDate, alias: Checked Date, length: 8 )
• MATSERVPIPE ( type: esriFieldTypeString, alias: Material of Service Pipe, length: 25 , Coded Values: [PL: Plastic] , [ST: Steel] , [UK: Unknown] )
• METERLOC ( type: esriFieldTypeString, alias: Meter Location, length: 25 , Coded Values: [Inside: Inside] , [Outside: Outside] )
• METERLOCCOM ( type: esriFieldTypeString, alias: Meter Location Comment, length: 25 , Coded Values: [A: West Wall] , [B: East Wall] , [C: North Wall] , ...1 more... )
• EMAILSENT ( type: esriFieldTypeSmallInteger, alias: Was Email Sent? )
• STARTSURVEY ( type: esriFieldTypeDate, alias: Survey Start Time, length: 8 )
• ENDSURVEY ( type: esriFieldTypeDate, alias: Survey End Time, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ReportLink ( type: esriFieldTypeString, alias: Report Link, length: 250 )
• METERREMOVED ( type: esriFieldTypeString, alias: Was Meter Removed?, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• SERIALCHANGE ( type: esriFieldTypeString, alias: Has Serial Number Changed?, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• SERIALNEW ( type: esriFieldTypeString, alias: Enter New Serial Number, length: 15 )
• RELATE ( type: esriFieldTypeGUID, alias: RELATE, length: 38 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Year ( type: esriFieldTypeString, alias: Year, length: 4 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• METEROFF ( type: esriFieldTypeString, alias: Is Gas Off at the Meter?, length: 50 , Coded Values: [Y: Yes] , [N: No] )

Relationships:

• BusinessDistrictPoints (2) -- Related To: Business District Points (19)

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

  Iteminfo   Thumbnail   Metadata