Name: Scheduled Audits

Display Field: AUDITORNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• AUDIT_ID ( type: esriFieldTypeDouble, alias: Audit ID, editable: true, nullable: true, defaultValue: null, modelName: AUDIT_ID )
• SITE_ID ( type: esriFieldTypeDouble, alias: Related Site ID, editable: true, nullable: true, defaultValue: null, modelName: SITE_ID )
• JOBDATE ( type: esriFieldTypeDate, alias: Date of Audit Job, editable: true, nullable: true, length: 8, defaultValue: null, modelName: JOBDATE )
• JOBTYPE ( type: esriFieldTypeString, alias: Job Type, editable: true, nullable: true, length: 200, defaultValue: null, modelName: JOBTYPE )
• WARD ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 200, defaultValue: null, modelName: WARD )
• AUDITNUMBER ( type: esriFieldTypeString, alias: Audit Number, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AUDITNUMBER )
• RELATEDACCOUNT ( type: esriFieldTypeDouble, alias: Related Account ID, editable: true, nullable: true, defaultValue: null, modelName: RELATEDACCOUNT )
• AUDITORNAME ( type: esriFieldTypeString, alias: Auditor Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AUDITORNAME , Coded Values: [ANDREW OETMAN: ANDREW OETMAN] , [ALEX SANTOS: ALEX SANTOS] , [LAUREN LINVILLE: LAUREN LINVILLE] , ...4 more... )
• DOWNSPOUTSHAPE ( type: esriFieldTypeString, alias: Downspout Shape, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DOWNSPOUTSHAPE , Coded Values: [Rectangular Large: Rectangular Large] , [Rectangular small: Rectangular Small] , [Round: Round] , ...2 more... )
• DOWNSPOUTCOLOR ( type: esriFieldTypeString, alias: Downspout Color, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DOWNSPOUTCOLOR , Coded Values: [White: White] , [Brown: Brown] , [Tan: Tan] , ...5 more... )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 200, defaultValue: null, modelName: WATERSHED )
• SUBWATERSHED ( type: esriFieldTypeString, alias: Sub-watershed, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SUBWATERSHED )
• CASESTARTDATE ( type: esriFieldTypeDate, alias: Date Case Started, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CASESTARTDATE )
• NUMBEROFDOWNSPOUTSONHOUSE ( type: esriFieldTypeDouble, alias: Number of Downspouts on House, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFDOWNSPOUTSONHOUSE )
• NUMBEROFADDITIONALDOWNSPOUTS ( type: esriFieldTypeDouble, alias: Number of Added Downspouts, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFADDITIONALDOWNSPOUTS )
• DOWNPOUTDRAINCONDITION ( type: esriFieldTypeString, alias: Downspout Drain Condition, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DOWNPOUTDRAINCONDITION , Coded Values: [Ready for Install: Ready for Install] , [Needs Repair: Needs Repair] )
• STORMWATERMANAGEMENTPRACTICE ( type: esriFieldTypeString, alias: Stormwater Management Practice, editable: true, nullable: true, length: 200, defaultValue: null, modelName: STORMWATERMANAGEMENTPRACTICE , Coded Values: [Yes: Yes] , [No: No] )
• STORMWATERMANAGEMENTNOTES ( type: esriFieldTypeString, alias: Stormwater Management Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: STORMWATERMANAGEMENTNOTES )
• SLOPE ( type: esriFieldTypeString, alias: Slope, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SLOPE , Coded Values: [Yes: Yes] , [No: No] )
• SLOPENOTES ( type: esriFieldTypeString, alias: Slope Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SLOPENOTES )
• RETAININGWALL ( type: esriFieldTypeString, alias: Retaining Wall, editable: true, nullable: true, length: 200, defaultValue: null, modelName: RETAININGWALL , Coded Values: [Yes: Yes] , [No: No] )
• RETAININGWALLNOTES ( type: esriFieldTypeString, alias: Retaining Wall Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: RETAININGWALLNOTES )
• SUMPPUMP ( type: esriFieldTypeString, alias: Sump Pump, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SUMPPUMP , Coded Values: [Yes: Yes] , [No: No] )
• SUMPPUMPNOTES ( type: esriFieldTypeString, alias: Sump Pump Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SUMPPUMPNOTES )
• ROOFAREA ( type: esriFieldTypeDouble, alias: Roof Area (ft), editable: true, nullable: true, defaultValue: null, modelName: ROOFAREA )
• IMPERVIOUSSURFACEAREA ( type: esriFieldTypeDouble, alias: Impervious Surface Area (ft), editable: true, nullable: true, defaultValue: null, modelName: IMPERVIOUSSURFACEAREA )
• DRIVEWAYSURFACETYPE ( type: esriFieldTypeString, alias: Driveway Surface Type, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DRIVEWAYSURFACETYPE , Coded Values: [Concrete: Concrete] , [Asphalt: Asphalt] , [Gravel: Gravel] , ...4 more... )
• DRIVEWAYSURFACENOTES ( type: esriFieldTypeString, alias: Driveway Surface Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DRIVEWAYSURFACENOTES )
• BUILDINGTYPE ( type: esriFieldTypeString, alias: Building Type, editable: true, nullable: true, length: 200, defaultValue: null, modelName: BUILDINGTYPE , Coded Values: [Single Family: Single Family] , [Row House: Row House] , [Duplex: Duplex] , ...5 more... )
• SEWERSHED ( type: esriFieldTypeString, alias: Sewershed, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SEWERSHED )
• DOWNSPOUTDRAINAGENOTES ( type: esriFieldTypeString, alias: Downspout Drainage Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DOWNSPOUTDRAINAGENOTES )
• CONNECTDDOWNSPOUTNUMBER ( type: esriFieldTypeDouble, alias: Number Connected Downspouts, editable: true, nullable: true, defaultValue: null, modelName: CONNECTDDOWNSPOUTNUMBER )
• ISDOWNSPOUTDISCONNTOGARDEN ( type: esriFieldTypeString, alias: Downspout Garden Disconnected , editable: true, nullable: true, length: 200, defaultValue: null, modelName: ISDOWNSPOUTDISCONNTOGARDEN , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: General Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NOTES )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• UPDATE_FLAG ( type: esriFieldTypeString, alias: UPDATE_FLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: UPDATE_FLAG )
• REQUESTED_BMPS ( type: esriFieldTypeString, alias: REQUESTED_BMPS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: REQUESTED_BMPS )

Templates:

• Name: Scheduled Audits
  Description:
  Prototype:
  UPDATE_FLAG: null
  AUDIT_ID: null
  SITE_ID: null
  JOBDATE: null
  JOBTYPE: null
  WARD: null
  AUDITNUMBER: null
  RELATEDACCOUNT: null
  AUDITORNAME: null
  DOWNSPOUTSHAPE: null
  DOWNSPOUTCOLOR: null
  WATERSHED: null
  SUBWATERSHED: null
  CASESTARTDATE: null
  NUMBEROFDOWNSPOUTSONHOUSE: null
  NUMBEROFADDITIONALDOWNSPOUTS: null
  DOWNPOUTDRAINCONDITION: null
  STORMWATERMANAGEMENTPRACTICE: null
  STORMWATERMANAGEMENTNOTES: null
  SLOPE: null
  SLOPENOTES: null
  RETAININGWALL: null
  RETAININGWALLNOTES: null
  SUMPPUMP: null
  SUMPPUMPNOTES: null
  ROOFAREA: null
  IMPERVIOUSSURFACEAREA: null
  DRIVEWAYSURFACETYPE: null
  DRIVEWAYSURFACENOTES: null
  BUILDINGTYPE: null
  SEWERSHED: null
  DOWNSPOUTDRAINAGENOTES: null
  CONNECTDDOWNSPOUTNUMBER: null
  ISDOWNSPOUTDISCONNTOGARDEN: null
  NOTES: null
  REQUESTED_BMPS: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• RS_BMPS (5) -- Related To: BMP (1)
• RS_SITES (4) -- Related To: RiverSmart Homes (0)

Capabilities: Query,Create,Update,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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