View In:   ArcGIS Online map viewer

Name: Sump Pump Inspections

Display Field: Resident_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 757f1265501b42ae9e4fdc64676f626a

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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: Inspection_complete

Fields:

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

Types:

ID: yes
Name: Inspection Complete
Domains:
• Inspector:
  Inherited
• Prop_type:
  Inherited
• F4Sale:
  Inherited
• Sump:
  Inherited
• pump1:
  Inherited
• pump2:
  Inherited
• pump3:
  Inherited
• base_type:
  Inherited
• Direct_san:
  Inherited
• Direct_sw:
  Inherited
• More_inv:
  Inherited
• San_backup:
  Inherited
• Backup_dry:
  Inherited
• Backup_wet:
  Inherited
• Inspection_complete:
  Inherited
Templates:
• Name: Inspection Complete
  Description:
  Prototype:
  Add_com: null
  Sewer_Basin: null
  X: null
  Y: null
  ADDRESS: null
  Inspection_num: null
  Inspector: null
  Inspection_Date: null
  Inspection_time: null
  Resident_Name: null
  Resident_cont: null
  Prop_type: null
  F4Sale: null
  Owner_name: null
  Owner_cont: null
  Owner_add: null
  Sump: null
  pump1: null
  rating1: null
  pump2: null
  rating2: null
  pump3: null
  rating3: null
  base_type: null
  sump_loc: null
  Direct_san: null
  Direct_sw: null
  Discharge: null
  More_inv: null
  Invest_reas: null
  San_backup: null
  Backup_dry: null
  Backup_wet: null
  Frequency: null
  Basement_h: null
  Inspection_complete: yes
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: no
Name: Inspection Not Started
Domains:
• Inspector:
  Inherited
• Prop_type:
  Inherited
• F4Sale:
  Inherited
• Sump:
  Inherited
• pump1:
  Inherited
• pump2:
  Inherited
• pump3:
  Inherited
• base_type:
  Inherited
• Direct_san:
  Inherited
• Direct_sw:
  Inherited
• More_inv:
  Inherited
• San_backup:
  Inherited
• Backup_dry:
  Inherited
• Backup_wet:
  Inherited
• Inspection_complete:
  Inherited
Templates:
• Name: Inspection Not Started
  Description:
  Prototype:
  Add_com: null
  Sewer_Basin: null
  X: null
  Y: null
  ADDRESS: null
  Inspection_num: null
  Inspector: null
  Inspection_Date: null
  Inspection_time: null
  Resident_Name: null
  Resident_cont: null
  Prop_type: null
  F4Sale: null
  Owner_name: null
  Owner_cont: null
  Owner_add: null
  Sump: null
  pump1: null
  rating1: null
  pump2: null
  rating2: null
  pump3: null
  rating3: null
  base_type: null
  sump_loc: null
  Direct_san: null
  Direct_sw: null
  Discharge: null
  More_inv: null
  Invest_reas: null
  San_backup: null
  Backup_dry: null
  Backup_wet: null
  Frequency: null
  Basement_h: null
  Inspection_complete: no
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: other
Name: More Investigation Needed
Domains:
• Inspector:
  Inherited
• Prop_type:
  Inherited
• F4Sale:
  Inherited
• Sump:
  Inherited
• pump1:
  Inherited
• pump2:
  Inherited
• pump3:
  Inherited
• base_type:
  Inherited
• Direct_san:
  Inherited
• Direct_sw:
  Inherited
• More_inv:
  Inherited
• San_backup:
  Inherited
• Backup_dry:
  Inherited
• Backup_wet:
  Inherited
• Inspection_complete:
  Inherited
Templates:
• Name: More Investigation Needed
  Description:
  Prototype:
  Add_com: null
  Sewer_Basin: null
  X: null
  Y: null
  ADDRESS: null
  Inspection_num: null
  Inspector: null
  Inspection_Date: null
  Inspection_time: null
  Resident_Name: null
  Resident_cont: null
  Prop_type: null
  F4Sale: null
  Owner_name: null
  Owner_cont: null
  Owner_add: null
  Sump: null
  pump1: null
  rating1: null
  pump2: null
  rating2: null
  pump3: null
  rating3: null
  base_type: null
  sump_loc: null
  Direct_san: null
  Direct_sw: null
  Discharge: null
  More_inv: null
  Invest_reas: null
  San_backup: null
  Backup_dry: null
  Backup_wet: null
  Frequency: null
  Basement_h: null
  Inspection_complete: other
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Update,Uploads,Editing,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata