Name: Permits

Display Field: Type

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspector )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Type , Coded Values: [AB: Accessory Building] , [ABC: ABC] , [AD: Addition] , ...70 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status , Coded Values: [C: Canceled] , [CL: Closed] , [CLOI: Closed - Incomplete Submittal] , ...23 more... )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 3000, defaultValue: null, modelName: Description )
• EnteredBy ( type: esriFieldTypeString, alias: EnteredBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EnteredBy )
• RecordID ( type: esriFieldTypeInteger, alias: RecordID, editable: true, nullable: true, defaultValue: null, modelName: RecordID )
• OccupancyCode ( type: esriFieldTypeString, alias: OccupancyCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OccupancyCode , 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, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkClass )
• TotalValuation ( type: esriFieldTypeDouble, alias: TotalValuation, editable: true, nullable: true, defaultValue: null, modelName: TotalValuation )
• ZoneFire ( type: esriFieldTypeString, alias: ZoneFire, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ZoneFire )
• ZoneLand ( type: esriFieldTypeString, alias: ZoneLand, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ZoneLand )
• ConstructionType ( type: esriFieldTypeString, alias: ConstructionType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ConstructionType , Coded Values: [00: Demolition] , [001: New] , [002: Addition] , ...20 more... )
• flagStopWork ( type: esriFieldTypeSmallInteger, alias: flagStopWork, editable: true, nullable: true, defaultValue: null, modelName: flagStopWork )
• PermitNumber ( type: esriFieldTypeString, alias: PermitNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PermitNumber )
• flagManualValuation ( type: esriFieldTypeSmallInteger, alias: flagManualValuation, editable: true, nullable: true, defaultValue: null, modelName: flagManualValuation )
• GNCommonID ( type: esriFieldTypeInteger, alias: GNCommonID, editable: true, nullable: true, defaultValue: null, modelName: GNCommonID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LegacyID )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Jurisdiction )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Department )
• BuildingUse ( type: esriFieldTypeString, alias: BuildingUse, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingUse , Coded Values: [AGR: Agricultural] , [COM: Commercial] , [DUP: Duplex] , ...6 more... )
• CurrentSubmittalNumber ( type: esriFieldTypeInteger, alias: CurrentSubmittalNumber, editable: true, nullable: true, defaultValue: null, modelName: CurrentSubmittalNumber )
• TotalImpactAdjustedValuation ( type: esriFieldTypeDouble, alias: TotalImpactAdjustedValuation, editable: true, nullable: true, defaultValue: null, modelName: TotalImpactAdjustedValuation )
• attMPACOccupancyDate ( type: esriFieldTypeString, alias: attMPACOccupancyDate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attMPACOccupancyDate )
• attMPACCancelledDate ( type: esriFieldTypeString, alias: attMPACCancelledDate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attMPACCancelledDate )
• CVDateLastModified ( type: esriFieldTypeString, alias: CVDateLastModified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CVDateLastModified )
• attNumberStories ( type: esriFieldTypeDouble, alias: attNumberStories, editable: true, nullable: true, defaultValue: null, modelName: attNumberStories )
• flagOccupancyInspectionRequired ( type: esriFieldTypeSmallInteger, alias: flagOccupancyInspectionRequired, editable: true, nullable: true, defaultValue: null, modelName: flagOccupancyInspectionRequired )
• attDateLastInspection ( type: esriFieldTypeString, alias: attDateLastInspection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attDateLastInspection )
• InternalNotes ( type: esriFieldTypeString, alias: InternalNotes, editable: true, nullable: true, length: 3000, defaultValue: null, modelName: InternalNotes )
• attFlagOwnerBuilder ( type: esriFieldTypeSmallInteger, alias: attFlagOwnerBuilder, editable: true, nullable: true, defaultValue: null, modelName: attFlagOwnerBuilder )
• attFlagPermitDisclaimer ( type: esriFieldTypeSmallInteger, alias: attFlagPermitDisclaimer, editable: true, nullable: true, defaultValue: null, modelName: attFlagPermitDisclaimer )
• attTotalImprovedSQFT ( type: esriFieldTypeDouble, alias: attTotalImprovedSQFT, editable: true, nullable: true, defaultValue: null, modelName: attTotalImprovedSQFT )
• attWaterService ( type: esriFieldTypeString, alias: attWaterService, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attWaterService )
• attSewerService ( type: esriFieldTypeString, alias: attSewerService, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attSewerService )
• attFlagPropertyHold ( type: esriFieldTypeSmallInteger, alias: attFlagPropertyHold, editable: true, nullable: true, defaultValue: null, modelName: attFlagPropertyHold )
• attProjectOrBusinessName ( type: esriFieldTypeString, alias: attProjectOrBusinessName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attProjectOrBusinessName )
• attEnvironmentalDevelopmentPerm ( type: esriFieldTypeString, alias: attEnvironmentalDevelopmentPerm, editable: true, nullable: true, length: 255, defaultValue: null, modelName: attEnvironmentalDevelopmentPerm )
• NWParcelID ( type: esriFieldTypeInteger, alias: NWParcelID, editable: true, nullable: true, defaultValue: null, modelName: NWParcelID )
• DTSID ( type: esriFieldTypeInteger, alias: DTSID, editable: true, nullable: true, defaultValue: null, modelName: DTSID )
• ParcelNo ( type: esriFieldTypeString, alias: ParcelNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ParcelNo )
• dateIssued ( type: esriFieldTypeDate, alias: dateIssued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateIssued )
• dateExpiration ( type: esriFieldTypeDate, alias: dateExpiration, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateExpiration )
• dateEntered ( type: esriFieldTypeDate, alias: dateEntered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateEntered )
• dateFinalled ( type: esriFieldTypeDate, alias: dateFinalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateFinalled )
• PIN_NUM ( type: esriFieldTypeString, alias: PIN_NUM, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PIN_NUM )

Templates:

• Name: PRPermit_Parcels
  Description:
  Prototype:
  dateFinalled: null
  Inspector: null
  Type: null
  Status: null
  Description: null
  EnteredBy: null
  RecordID: null
  OccupancyCode: null
  WorkClass: null
  TotalValuation: null
  ZoneFire: null
  ZoneLand: null
  ConstructionType: null
  flagStopWork: null
  PermitNumber: null
  flagManualValuation: null
  GNCommonID: null
  LegacyID: null
  Jurisdiction: null
  Department: null
  BuildingUse: null
  CurrentSubmittalNumber: null
  TotalImpactAdjustedValuation: null
  attMPACOccupancyDate: null
  attMPACCancelledDate: null
  CVDateLastModified: null
  attNumberStories: null
  flagOccupancyInspectionRequired: null
  attDateLastInspection: null
  InternalNotes: null
  attFlagOwnerBuilder: null
  attFlagPermitDisclaimer: null
  attTotalImprovedSQFT: null
  attWaterService: null
  attSewerService: null
  attFlagPropertyHold: null
  attProjectOrBusinessName: null
  attEnvironmentalDevelopmentPerm: null
  NWParcelID: null
  DTSID: null
  ParcelNo: null
  dateIssued: null
  dateExpiration: null
  dateEntered: null
  PIN_NUM: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata