Name: SmartGovHistoricalPermits

Display Field: PermitNum

Type: Table

Geometry Type: N/A

Description: This layer contains a data of 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 has three (3) relationship classes associated with it (Permits to Contractors, Permits to Inspections, and Parcels to Permits). 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: ObjectID, type: esriFieldTypeOID )
• PermitNum ( nullable: true, length: 255, alias: Permit Number, type: esriFieldTypeString )
• DateSub ( nullable: true, length: 8, alias: Date Submitted, type: esriFieldTypeDate )
• DateIssue ( nullable: true, length: 8, alias: Date Issued, type: esriFieldTypeDate )
• DateFinish ( nullable: true, length: 8, alias: Date Finished, type: esriFieldTypeDate )
• DateClose ( nullable: true, length: 8, alias: Date Closed, type: esriFieldTypeDate )
• DateExp ( nullable: true, length: 8, alias: Date Expiration, type: esriFieldTypeDate )
• DateLstInsp ( nullable: true, length: 8, alias: Date Last Inspected, type: esriFieldTypeDate )
• ParcelNum ( nullable: true, alias: Parcel Num, type: esriFieldTypeDouble )
• Siteaddress ( nullable: true, length: 255, alias: Site Address, type: esriFieldTypeString )
• ProjectName ( nullable: true, length: 255, alias: Project Name, type: esriFieldTypeString )
• PrimCont ( nullable: true, length: 255, alias: Primary Contact, type: esriFieldTypeString )
• PrimContAdd ( nullable: true, length: 255, alias: Primary Contact Address, type: esriFieldTypeString )
• PrimContCity ( nullable: true, length: 255, alias: Primary Contact City, type: esriFieldTypeString )
• Applicant ( nullable: true, length: 255, alias: Applicant, type: esriFieldTypeString )
• ApplicantAdd ( nullable: true, length: 255, alias: Applicant Address, type: esriFieldTypeString )
• PermitStatus ( nullable: true, length: 255, alias: Permit Status, type: esriFieldTypeString )
• PermitType ( nullable: true, length: 255, alias: Permit Type, type: esriFieldTypeString )
• PermitDesc ( nullable: true, length: 255, alias: Permit Description, type: esriFieldTypeString )
• WorkClass ( nullable: true, length: 255, alias: WorkClass, type: esriFieldTypeString )
• SUBDIVISION ( nullable: true, length: 255, alias: Subdivision, type: esriFieldTypeString )
• LotNum ( nullable: true, alias: Lot Number, type: esriFieldTypeDouble )
• SqFt ( nullable: true, alias: Square Fee, type: esriFieldTypeDouble )
• ConstTotalCst ( nullable: true, alias: Construction Total Cost, type: esriFieldTypeDouble )
• ElectTotalCst ( nullable: true, alias: Electrical Total Cost, type: esriFieldTypeDouble )
• MechTotalCst ( nullable: true, alias: Mechanical Total Cost, type: esriFieldTypeDouble )
• PlumTotalCst ( nullable: true, alias: Plumbing Total Cost, type: esriFieldTypeDouble )
• ParcelNumb ( nullable: true, length: 255, alias: Parcel Number, type: esriFieldTypeString )

Relationships:

• SDE.SmartGovHistoricalContractors (5) -- Related To: SmartGovHistoricalContractors (6)
• SDE.SmartGovHistoricalInspections (6) -- Related To: SmartGovHistoricalInspections (7)
• SDE.TaxParcel (2) -- Related To: Tax Parcels (1)

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

  Iteminfo   Thumbnail   Metadata