Name: Sump Pump Inspections

Display Field: Resident_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b95f356ba6f04ad29c48b876f305630f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 125000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 796331.1486187875
YMin: 1147114.4318526313
XMax: 826772.9932551384
YMax: 1166332.6341745332
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Inspection_complete
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: yes
  Label: Inspection Complete
  Description: N/A
  Symbol:
  
• Value: no
  Label: Inspection Not Started
  Description: N/A
  Symbol:
  
• Value: other
  Label: More Investigation Needed
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• Inspection_num ( type: esriFieldTypeSmallInteger, alias: Inspection Number )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 , Coded Values: [mh: Matt Hight] , [jl: John Latshaw] , [bb: Brandon Bardfield] , ...7 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• Inspection_time ( type: esriFieldTypeString, alias: Time of Inspection, length: 50 )
• Resident_Name ( type: esriFieldTypeString, alias: Name of Resident, length: 50 )
• Resident_cont ( type: esriFieldTypeString, alias: Resident Contact Number, length: 50 )
• Prop_type ( type: esriFieldTypeString, alias: Property Type, length: 50 , Coded Values: [rent: Rental Property] , [real: Realtor Owned] , [res: Resident Owned] )
• F4Sale ( type: esriFieldTypeString, alias: House for Sale?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Owner_name ( type: esriFieldTypeString, alias: Owner Name, length: 50 )
• Owner_cont ( type: esriFieldTypeString, alias: Owner Contact Number, length: 50 )
• Owner_add ( type: esriFieldTypeString, alias: Owner Address, length: 50 )
• Sump ( type: esriFieldTypeString, alias: Sump Present, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• pump1 ( type: esriFieldTypeString, alias: Sump Pump 1 Type, length: 50 , Coded Values: [sp: Submersible Pump] , [pp: Pedestal Pump] )
• rating1 ( type: esriFieldTypeString, alias: Rating for Pump 1, length: 50 )
• pump2 ( type: esriFieldTypeString, alias: Sump Pump 2 Type, length: 50 , Coded Values: [sp: Submersible Pump] , [pp: Pedestal Pump] )
• rating2 ( type: esriFieldTypeString, alias: Rating for Pump 2, length: 50 )
• pump3 ( type: esriFieldTypeString, alias: Sump Pump 3 Type, length: 50 , Coded Values: [sp: Submersible Pump] , [pp: Pedestal Pump] )
• rating3 ( type: esriFieldTypeString, alias: Rating for Pump 3, length: 50 )
• base_type ( type: esriFieldTypeString, alias: base_type, length: 50 , Coded Values: [fbase: Full Basement] , [pbase: Partial Basement] , [crawl: Crawl Space] , ...2 more... )
• sump_loc ( type: esriFieldTypeString, alias: Sump Pump Location, length: 50 )
• Direct_san ( type: esriFieldTypeString, alias: Direct Sanitary Sewer Connection, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Direct_sw ( type: esriFieldTypeString, alias: Direct Storm Water Connection, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Discharge ( type: esriFieldTypeString, alias: Discharge Location, length: 50 )
• More_inv ( type: esriFieldTypeString, alias: More Investigation Needed?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Invest_reas ( type: esriFieldTypeString, alias: Reason For More Investigation, length: 100 )
• San_backup ( type: esriFieldTypeString, alias: Resident Experienced Sanitary Backup?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Backup_dry ( type: esriFieldTypeString, alias: Backup During Dry Weather, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Backup_wet ( type: esriFieldTypeString, alias: Backup During Wet Weather, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Frequency ( type: esriFieldTypeSmallInteger, alias: Frequency )
• Basement_h ( type: esriFieldTypeSmallInteger, alias: Basement Height in Feet (Floor to Ceiling) )
• Add_com ( type: esriFieldTypeString, alias: Additional Comments, length: 200 )
• Inspection_complete ( type: esriFieldTypeString, alias: Inspection_complete, length: 50 , Coded Values: [yes: Inspection Complete] , [no: Inspection Not Started] , [other: More Investigation Needed] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Sewer_Basin ( type: esriFieldTypeString, alias: Sewer Basin, length: 36 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata