Name: SmartGovHistoricalContractors

Display Field: Contractor

Type: Table

Geometry Type: N/A

Description: This layer contains a data of Contractors as they relate to Permits, exported from the SmartGov permitting and licensing software. The permit pull is filtered by "Status IS NOT Cancelled" and by "Date Range". The intention is to pull annual closed permit data in January for the previous year. This layer is related to Permits by Permit Number. The purpose of this layer is for staff to be able to easily search parcels to find any related permits and then from the permit number - find the associated archived permit folder.

Copyright Text: City of Liberty - GIS Division

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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: false
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: true
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: N/A

Fields:

• OBJECTID ( nullable: false, alias: Object ID, type: esriFieldTypeOID )
• PermitNumber ( nullable: true, length: 255, alias: Permit Number, type: esriFieldTypeString )
• Contractor ( nullable: true, length: 255, alias: Contractor, type: esriFieldTypeString )
• Address ( nullable: true, length: 255, alias: Address, type: esriFieldTypeString )
• ContractorCity ( nullable: true, length: 255, alias: Contractor City, type: esriFieldTypeString )
• PhoneNum ( nullable: true, length: 255, alias: Phone Number, type: esriFieldTypeString )
• EmailAdd ( nullable: true, length: 255, alias: Email Address, type: esriFieldTypeString )
• LicType ( nullable: true, length: 255, alias: License Type, type: esriFieldTypeString )
• LicNumber ( nullable: true, length: 255, alias: License Number, type: esriFieldTypeString )
• ProjectName ( nullable: true, length: 255, alias: Project Name, type: esriFieldTypeString )

Relationships:

• SDE.SmartGovHistoricalPermits (5) -- Related To: SmartGovHistoricalPermits (5)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata