Name: Code Violations Table

Display Field: STREETNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ID ( type: esriFieldTypeInteger, alias: ID, editable: true, nullable: false, defaultValue: null, modelName: ID )
• CaseNumber ( type: esriFieldTypeString, alias: CaseNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CaseNumber )
• SiteAddress ( type: esriFieldTypeString, alias: SiteAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SiteAddress )
• StreetNumber ( type: esriFieldTypeString, alias: StreetNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetNumber )
• StreetName ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 128, defaultValue: null, modelName: StreetName )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 128, defaultValue: null, modelName: City )
• Zip ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Zip )
• SBL ( type: esriFieldTypeString, alias: SBL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SBL )
• LegalOwner ( type: esriFieldTypeString, alias: LegalOwner, editable: true, nullable: true, length: 128, defaultValue: null, modelName: LegalOwner )
• OwnerAddress ( type: esriFieldTypeString, alias: OwnerAddress, editable: true, nullable: true, length: 256, defaultValue: null, modelName: OwnerAddress )
• CaseStatus ( type: esriFieldTypeString, alias: CaseStatus, editable: true, nullable: true, length: 128, defaultValue: null, modelName: CaseStatus )
• CaseClosed ( type: esriFieldTypeDate, alias: CaseClosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CaseClosed )
• NumUnits ( type: esriFieldTypeString, alias: NumUnits, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NumUnits )
• ViolationLocation ( type: esriFieldTypeString, alias: ViolationLocation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ViolationLocation )
• ViolationUnit ( type: esriFieldTypeString, alias: ViolationUnit, editable: true, nullable: true, length: 128, defaultValue: null, modelName: ViolationUnit )
• ViolationRoom ( type: esriFieldTypeString, alias: ViolationRoom, editable: true, nullable: true, length: 128, defaultValue: null, modelName: ViolationRoom )
• ViolationCitedDate ( type: esriFieldTypeDate, alias: ViolationCitedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ViolationCitedDate )
• CodeViolation ( type: esriFieldTypeString, alias: CodeViolation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CodeViolation )
• ViolationDescription ( type: esriFieldTypeString, alias: ViolationDescription, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: ViolationDescription )
• ViolationStatus ( type: esriFieldTypeString, alias: ViolationStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ViolationStatus )
• ViolationAbatedDate ( type: esriFieldTypeDate, alias: ViolationAbatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ViolationAbatedDate )
• ViolationCategory ( type: esriFieldTypeString, alias: ViolationCategory, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ViolationCategory )
• HealthAndSafety ( type: esriFieldTypeString, alias: HealthAndSafety, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HealthAndSafety )
• ViolationKey ( type: esriFieldTypeString, alias: ViolationKey, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ViolationKey )
• ImportDate ( type: esriFieldTypeString, alias: ImportDate, editable: true, nullable: true, length: 11, defaultValue: null, modelName: ImportDate )

Templates:

• Name: Code Violations Table
  Description:
  Prototype:
  ViolationKey: null
  ID: 0
  CaseNumber: null
  SiteAddress: null
  StreetNumber: null
  StreetName: null
  City: null
  Zip: null
  SBL: null
  LegalOwner: null
  OwnerAddress: null
  CaseStatus: null
  CaseClosed: null
  NumUnits: null
  ViolationLocation: null
  ViolationUnit: null
  ViolationRoom: null
  ViolationCitedDate: null
  CodeViolation: null
  ViolationDescription: null
  ViolationStatus: null
  ViolationAbatedDate: null
  ViolationCategory: null
  HealthAndSafety: null
  ImportDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

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