Name: Permits

Display Field: Type

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

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

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 255 )
• Type ( type: esriFieldTypeString, alias: Type, length: 255 , Coded Values: [AB: Accessory Building] , [ABC: ABC] , [AD: Addition] , ...70 more... )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 , Coded Values: [C: Canceled] , [CL: Closed] , [CLOI: Closed - Incomplete Submittal] , ...23 more... )
• Description ( type: esriFieldTypeString, alias: Description, length: 3000 )
• EnteredBy ( type: esriFieldTypeString, alias: EnteredBy, length: 255 )
• RecordID ( type: esriFieldTypeInteger, alias: RecordID )
• OccupancyCode ( type: esriFieldTypeString, alias: OccupancyCode, length: 255 , Coded Values: [A-1a: Assembly, theaters, with stage] , [A-1b: Assembly, theaters, without stage] , [A-2a: Assembly, nightclubs] , ...39 more... )
• WorkClass ( type: esriFieldTypeString, alias: WorkClass, length: 255 )
• TotalValuation ( type: esriFieldTypeDouble, alias: TotalValuation )
• ZoneFire ( type: esriFieldTypeString, alias: ZoneFire, length: 255 )
• ZoneLand ( type: esriFieldTypeString, alias: ZoneLand, length: 255 )
• ConstructionType ( type: esriFieldTypeString, alias: ConstructionType, length: 255 , Coded Values: [00: Demolition] , [001: New] , [002: Addition] , ...20 more... )
• flagStopWork ( type: esriFieldTypeSmallInteger, alias: flagStopWork )
• PermitNumber ( type: esriFieldTypeString, alias: PermitNumber, length: 255 )
• flagManualValuation ( type: esriFieldTypeSmallInteger, alias: flagManualValuation )
• GNCommonID ( type: esriFieldTypeInteger, alias: GNCommonID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 255 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 255 )
• Department ( type: esriFieldTypeString, alias: Department, length: 255 )
• BuildingUse ( type: esriFieldTypeString, alias: BuildingUse, length: 255 , Coded Values: [AGR: Agricultural] , [COM: Commercial] , [DUP: Duplex] , ...6 more... )
• CurrentSubmittalNumber ( type: esriFieldTypeInteger, alias: CurrentSubmittalNumber )
• TotalImpactAdjustedValuation ( type: esriFieldTypeDouble, alias: TotalImpactAdjustedValuation )
• attMPACOccupancyDate ( type: esriFieldTypeString, alias: attMPACOccupancyDate, length: 255 )
• attMPACCancelledDate ( type: esriFieldTypeString, alias: attMPACCancelledDate, length: 255 )
• CVDateLastModified ( type: esriFieldTypeString, alias: CVDateLastModified, length: 255 )
• attNumberStories ( type: esriFieldTypeDouble, alias: attNumberStories )
• flagOccupancyInspectionRequired ( type: esriFieldTypeSmallInteger, alias: flagOccupancyInspectionRequired )
• attDateLastInspection ( type: esriFieldTypeString, alias: attDateLastInspection, length: 255 )
• InternalNotes ( type: esriFieldTypeString, alias: InternalNotes, length: 3000 )
• attFlagOwnerBuilder ( type: esriFieldTypeSmallInteger, alias: attFlagOwnerBuilder )
• attFlagPermitDisclaimer ( type: esriFieldTypeSmallInteger, alias: attFlagPermitDisclaimer )
• attTotalImprovedSQFT ( type: esriFieldTypeDouble, alias: attTotalImprovedSQFT )
• attWaterService ( type: esriFieldTypeString, alias: attWaterService, length: 255 )
• attSewerService ( type: esriFieldTypeString, alias: attSewerService, length: 255 )
• attFlagPropertyHold ( type: esriFieldTypeSmallInteger, alias: attFlagPropertyHold )
• attProjectOrBusinessName ( type: esriFieldTypeString, alias: attProjectOrBusinessName, length: 255 )
• attEnvironmentalDevelopmentPerm ( type: esriFieldTypeString, alias: attEnvironmentalDevelopmentPerm, length: 255 )
• NWParcelID ( type: esriFieldTypeInteger, alias: NWParcelID )
• DTSID ( type: esriFieldTypeInteger, alias: DTSID )
• ParcelNo ( type: esriFieldTypeString, alias: ParcelNo, length: 255 )
• dateIssued ( type: esriFieldTypeDate, alias: dateIssued, length: 8 )
• dateExpiration ( type: esriFieldTypeDate, alias: dateExpiration, length: 8 )
• dateEntered ( type: esriFieldTypeDate, alias: dateEntered, length: 8 )
• dateFinalled ( type: esriFieldTypeDate, alias: dateFinalled, length: 8 )
• PIN_NUM ( type: esriFieldTypeString, alias: PIN_NUM, length: 100 )

Relationships:

• Parcels (1) -- Related To: Parcels (0)

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

  Iteminfo   Thumbnail   Metadata