Name: WaterburyGIS.GISEDITOR.sedaParcelHistory

Display Field: contractorname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• permittype ( type: esriFieldTypeString, alias: permittype, length: 30 , Coded Values: [Connection: Connection] , [Disconnection: Disconnection] , [Repair: Repair] )
• permitnum ( type: esriFieldTypeString, alias: permitnum, length: 20 )
• bldgtype ( type: esriFieldTypeString, alias: bldgtype, length: 30 , Coded Values: [Commercial: Commercial] , [Industrial: Industrial] , [School: School] , ...10 more... )
• numberunits ( type: esriFieldTypeSmallInteger, alias: numberunits )
• jobtype ( type: esriFieldTypeString, alias: jobtype, length: 30 , Coded Values: [New Construction: New Construction] , [Addition: Addition] , [Repairs Only: Repairs Only] , ...3 more... )
• address ( type: esriFieldTypeString, alias: address, length: 150 )
• hub_used ( type: esriFieldTypeString, alias: hub_used, length: 50 )
• sewermap ( type: esriFieldTypeDouble, alias: sewermap )
• contractorname ( type: esriFieldTypeString, alias: contractorname, length: 100 )
• contractoraddr ( type: esriFieldTypeString, alias: contractoraddr, length: 150 )
• contractorphone ( type: esriFieldTypeString, alias: contractorphone, length: 20 )
• installer ( type: esriFieldTypeString, alias: installer, length: 100 )
• feepaid ( type: esriFieldTypeString, alias: feepaid, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sketchadded ( type: esriFieldTypeString, alias: sketchadded, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• connectfeepaid ( type: esriFieldTypeString, alias: connectfeepaid, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• connected ( type: esriFieldTypeDate, alias: connected, length: 8 )
• asbuiltrecvd ( type: esriFieldTypeDate, alias: asbuiltrecvd, length: 8 )
• occ_cert ( type: esriFieldTypeDate, alias: occ_cert, length: 8 )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 30 , Coded Values: [Corrective Maintenance: Corrective Maintenance] , [Preventative Maintenance: Preventative Maintenance] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3 )
• Work_Origin ( type: esriFieldTypeString, alias: Work_Origin, length: 50 , Coded Values: [Emergency: Emergency] , [Long-Term Maintenance Plan: Long-Term Maintenance Plan] )
• Inspection_Type ( type: esriFieldTypeString, alias: Inspection_Type`, length: 50 , Coded Values: [Internal: Internal] , [External: External] )
• Street_Name ( type: esriFieldTypeString, alias: Street_Name, length: 50 )
• Street_No ( type: esriFieldTypeString, alias: Street_No, length: 50 )
• Building_Type ( type: esriFieldTypeString, alias: Building_Type, length: 50 , Coded Values: [Single Family: Single Family] , [Multi Family: Multi Family] , [Apartment: Apartment] , ...2 more... )
• Sewer_SubArea ( type: esriFieldTypeString, alias: Sewer_SubArea, length: 50 )
• Map_No ( type: esriFieldTypeString, alias: Map_No, length: 50 )
• Line_Segment ( type: esriFieldTypeString, alias: Line_Segment, length: 50 )
• Upstream_MH ( type: esriFieldTypeString, alias: Upstream_MH, length: 50 )
• Downstream_MH ( type: esriFieldTypeString, alias: Downstream_MH, length: 50 )
• Owner_Contact_Name ( type: esriFieldTypeString, alias: Owner_Contact_Name, length: 50 )
• Owner_Contact_Number ( type: esriFieldTypeString, alias: Owner_Contact_Number, length: 50 )
• Inspection_Attempt ( type: esriFieldTypeString, alias: Inspection_Attempt, length: 50 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• Date_Historical_Flooding ( type: esriFieldTypeString, alias: Date_Historical_Flooding, length: 50 )
• Source_Historical_Flooding ( type: esriFieldTypeString, alias: Source_Historical_Flooding, length: 50 )
• Actions_Take_After_Flooding ( type: esriFieldTypeString, alias: Actions_Take_After_Flooding, length: 50 )
• Foundation_Type ( type: esriFieldTypeString, alias: Foundation_Typep, length: 50 , Coded Values: [Slab: Slab] , [Crawl Space: Crawl Space] , [Unfinished Basement: Unfinished Basement] , ...3 more... )
• RoofDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: RoofDrain_Discharge_to_SS, length: 50 )
• FoundationDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: FoundationDrain_Discharge_to_SS, length: 50 )
• Curb_Box_Present ( type: esriFieldTypeString, alias: Curb_Box_Present, length: 50 , Coded Values: [1: Yes] , [2: No] )
• PatioDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: PatioDrain_Discharges_to_SS, length: 50 )
• DrivewayDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: DrivewayDrain_Discharges_to_SS, length: 50 )
• WindowWellDrain_to_SS ( type: esriFieldTypeString, alias: WindowWellDrain_Discharges_to_SS, length: 50 )
• StairwellSidewalkDrain_to_SS ( type: esriFieldTypeString, alias: StairwellSidewalkDrain_Discharges_to_SS, length: 50 )
• Diverter_Valve_On_Storm_Water ( type: esriFieldTypeString, alias: Diverter_Valve_On_Storm_Water, length: 50 )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 1000 )
• Picture1 ( type: esriFieldTypeInteger, alias: Picture1 )
• Picture2 ( type: esriFieldTypeInteger, alias: Picture2 )
• Combination_Pump ( type: esriFieldTypeString, alias: Combination_Pump, length: 50 )
• YardDrain_Discharges_SS ( type: esriFieldTypeString, alias: YardDrain_Discharges_SS, length: 50 )
• SuspectConnection ( type: esriFieldTypeString, alias: SuspectConnection, length: 50 )
• PermissionGranted ( type: esriFieldTypeString, alias: PermissionGranted, length: 50 )
• Dye_Test_Results ( type: esriFieldTypeString, alias: Dye_Test_Results, length: 50 )
• Dye_test_comments ( type: esriFieldTypeString, alias: Dye_test_comments, length: 1000 )
• Inspectedby ( type: esriFieldTypeString, alias: Inspectedby, length: 50 )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata