View In:   ArcGIS Online Map Viewer

Name: hpgdb.PLANNING.AccelaCodeViolationsV2

Display Field: Server_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: updated from SQL Stored Proc Nightly

Service Item Id: 43a814977e6d4900b87d4efaeae8ecc7

Copyright Text: HPITS

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 1684551.9918774664
YMin: 791709.3911823928
XMax: 1722997.7880172133
YMax: 842478.4517175555
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [137, 30, 98, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Record_ID ( type: esriFieldTypeString, alias: Record_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Record_ID )
• Record_Type ( type: esriFieldTypeString, alias: Record_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Record_Type )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Address )
• Case_Topic ( type: esriFieldTypeString, alias: Case_Topic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Case_Topic )
• Case_Desc ( type: esriFieldTypeString, alias: Case_Desc, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Case_Desc )
• Open_Date ( type: esriFieldTypeDate, alias: Open_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Open_Date )
• Closed_Date ( type: esriFieldTypeDate, alias: Closed_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Closed_Date )
• Workflow_Id ( type: esriFieldTypeString, alias: Workflow_Id, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Workflow_Id )
• Active_Task_Details ( type: esriFieldTypeString, alias: Active_Task_Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Active_Task_Details )
• Case_Mgr ( type: esriFieldTypeString, alias: Case_Mgr, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Case_Mgr )
• Tax_Owner ( type: esriFieldTypeString, alias: Tax_Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Tax_Owner )
• Tax_Addr ( type: esriFieldTypeString, alias: Tax_Addr, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Tax_Addr )
• Party_Cited ( type: esriFieldTypeString, alias: Party_Cited, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Party_Cited )
• Notice_Sent ( type: esriFieldTypeDate, alias: Notice_Sent, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Notice_Sent )
• Hearing_Date ( type: esriFieldTypeDate, alias: Hearing_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Hearing_Date )
• Compliance_Due ( type: esriFieldTypeDate, alias: Compliance_Due, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Compliance_Due )
• Council_Meet_Date ( type: esriFieldTypeDate, alias: Council_Meet_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Council_Meet_Date )
• Council_Order ( type: esriFieldTypeDate, alias: Council_Order, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Council_Order )
• Council_Comply_Date ( type: esriFieldTypeDate, alias: Council_Comply_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Council_Comply_Date )
• Passed_Insp ( type: esriFieldTypeInteger, alias: Passed_Insp, editable: true, nullable: true, defaultValue: null, modelName: Passed_Insp )
• Failed_Insp ( type: esriFieldTypeInteger, alias: Failed_Insp, editable: true, nullable: true, defaultValue: null, modelName: Failed_Insp )
• Total_Insp ( type: esriFieldTypeInteger, alias: Total_Insp, editable: true, nullable: true, defaultValue: null, modelName: Total_Insp )
• Parcel_Number ( type: esriFieldTypeString, alias: Parcel_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parcel_Number )
• Acreage ( type: esriFieldTypeString, alias: Acreage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Acreage )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 255, defaultValue: null, modelName: County )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Jurisdiction )
• Wards ( type: esriFieldTypeString, alias: Wards, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Wards )
• Local_Dist ( type: esriFieldTypeString, alias: Local_Dist, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Local_Dist )
• Zoning ( type: esriFieldTypeString, alias: Zoning, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Zoning )
• RTA ( type: esriFieldTypeString, alias: RTA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RTA )
• Total_Cost ( type: esriFieldTypeString, alias: Total_Cost, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Total_Cost )
• Abate_Cost ( type: esriFieldTypeString, alias: Abate_Cost, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Abate_Cost )
• Admin_Fee ( type: esriFieldTypeString, alias: Admin_Fee, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Admin_Fee )
• Lien_Record ( type: esriFieldTypeString, alias: Lien_Record, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lien_Record )
• Asbestos_Test ( type: esriFieldTypeString, alias: Asbestos_Test, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asbestos_Test )
• Asbestos_Abate ( type: esriFieldTypeString, alias: Asbestos_Abate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asbestos_Abate )
• Asbestos_Subtotal ( type: esriFieldTypeString, alias: Asbestos_Subtotal, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asbestos_Subtotal )
• Other_Cost ( type: esriFieldTypeString, alias: Other_Cost, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Other_Cost )
• Other_Cost_Desc ( type: esriFieldTypeString, alias: Other_Cost_Desc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Other_Cost_Desc )
• Inv_Num ( type: esriFieldTypeString, alias: Inv_Num, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inv_Num )
• Inv_Date ( type: esriFieldTypeDate, alias: Inv_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inv_Date )
• Inv_Paid ( type: esriFieldTypeDate, alias: Inv_Paid, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inv_Paid )
• Cust_No ( type: esriFieldTypeString, alias: Cust_No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Cust_No )
• Fees_Collected ( type: esriFieldTypeDouble, alias: Fees_Collected, editable: true, nullable: true, defaultValue: null, modelName: Fees_Collected )
• Inv_Fee_Bal ( type: esriFieldTypeDouble, alias: Inv_Fee_Bal, editable: true, nullable: true, defaultValue: null, modelName: Inv_Fee_Bal )
• Lien_Num ( type: esriFieldTypeString, alias: Lien_Num, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lien_Num )
• Lien_Filed ( type: esriFieldTypeDate, alias: Lien_Filed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Lien_Filed )
• Lien_Release ( type: esriFieldTypeDate, alias: Lien_Release, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Lien_Release )
• Mun_Lien_Yr ( type: esriFieldTypeString, alias: Mun_Lien_Yr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Mun_Lien_Yr )
• Abate_Action ( type: esriFieldTypeString, alias: Abate_Action, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Abate_Action )
• Abate_Work_Comp ( type: esriFieldTypeDate, alias: Abate_Work_Comp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Abate_Work_Comp )
• Abate_Contr ( type: esriFieldTypeString, alias: Abate_Contr, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Abate_Contr )
• Related_Gl_record ( type: esriFieldTypeString, alias: Related_Gl_record, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Related_Gl_record )
• Violation ( type: esriFieldTypeString, alias: Violation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Violation )
• Info_Src ( type: esriFieldTypeString, alias: Info_Src, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Info_Src )
• IS2 ( type: esriFieldTypeString, alias: IS2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IS2 )
• Created_By ( type: esriFieldTypeString, alias: Created_By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Created_By )
• Corr_Status ( type: esriFieldTypeString, alias: Corr_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Corr_Status )
• Corr_Date ( type: esriFieldTypeDate, alias: Corr_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Corr_Date )
• Rec_Status ( type: esriFieldTypeString, alias: Rec_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Rec_Status )
• Rec_Status_Date ( type: esriFieldTypeDate, alias: Rec_Status_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Rec_Status_Date )
• Rec_Status_Comment ( type: esriFieldTypeString, alias: Rec_Status_Comment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Rec_Status_Comment )
• Rec_Status_Comment_By ( type: esriFieldTypeString, alias: Rec_Status_Comment_By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Rec_Status_Comment_By )
• Prior_Rec_Status ( type: esriFieldTypeString, alias: Prior_Rec_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Prior_Rec_Status )
• Prior_Rec_Status_Date ( type: esriFieldTypeDate, alias: Prior_Rec_Status_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Prior_Rec_Status_Date )
• Prior_Rec_Comment ( type: esriFieldTypeString, alias: Prior_Rec_Comment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Prior_Rec_Comment )
• Prior_Status_Comment_By ( type: esriFieldTypeString, alias: Prior_Status_Comment_By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Prior_Status_Comment_By )
• FQ ( type: esriFieldTypeString, alias: FQ, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FQ )
• FM ( type: esriFieldTypeString, alias: FM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FM )
• FY_Open ( type: esriFieldTypeString, alias: FY_Open, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FY_Open )
• FY_Corr_Date ( type: esriFieldTypeString, alias: FY_Corr_Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FY_Corr_Date )
• FY_Open_Date ( type: esriFieldTypeString, alias: FY_Open_Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FY_Open_Date )
• FY ( type: esriFieldTypeString, alias: FY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FY )
• Server_Name ( type: esriFieldTypeString, alias: Server_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Server_Name )
• WardNo ( type: esriFieldTypeString, alias: WardNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WardNo )

Templates:

• Name: hpgdb.PLANNING.AccelaCodeViolationsV2
  Description:
  Prototype:
  Server_Name: null
  WardNo: null
  Record_ID: null
  Record_Type: null
  Address: null
  Case_Topic: null
  Case_Desc: null
  Open_Date: null
  Closed_Date: null
  Workflow_Id: null
  Active_Task_Details: null
  Case_Mgr: null
  Tax_Owner: null
  Tax_Addr: null
  Party_Cited: null
  Notice_Sent: null
  Hearing_Date: null
  Compliance_Due: null
  Council_Meet_Date: null
  Council_Order: null
  Council_Comply_Date: null
  Passed_Insp: null
  Failed_Insp: null
  Total_Insp: null
  Parcel_Number: null
  Acreage: null
  County: null
  Jurisdiction: null
  Wards: null
  Local_Dist: null
  Zoning: null
  RTA: null
  Total_Cost: null
  Abate_Cost: null
  Admin_Fee: null
  Lien_Record: null
  Asbestos_Test: null
  Asbestos_Abate: null
  Asbestos_Subtotal: null
  Other_Cost: null
  Other_Cost_Desc: null
  Inv_Num: null
  Inv_Date: null
  Inv_Paid: null
  Cust_No: null
  Fees_Collected: null
  Inv_Fee_Bal: null
  Lien_Num: null
  Lien_Filed: null
  Lien_Release: null
  Mun_Lien_Yr: null
  Abate_Action: null
  Abate_Work_Comp: null
  Abate_Contr: null
  Related_Gl_record: null
  Violation: null
  Info_Src: null
  IS2: null
  Created_By: null
  Corr_Status: null
  Corr_Date: null
  Rec_Status: null
  Rec_Status_Date: null
  Rec_Status_Comment: null
  Rec_Status_Comment_By: null
  Prior_Rec_Status: null
  Prior_Rec_Status_Date: null
  Prior_Rec_Comment: null
  Prior_Status_Comment_By: null
  FQ: null
  FM: null
  FY_Open: null
  FY_Corr_Date: null
  FY_Open_Date: null
  FY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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