Name: Building Permits 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: true, defaultValue: null, modelName: ID )
• SBL ( type: esriFieldTypeString, alias: SBL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SBL )
• 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: 50, defaultValue: null, modelName: StreetName )
• FullAddress ( type: esriFieldTypeString, alias: FullAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FullAddress )
• LegalOwner ( type: esriFieldTypeString, alias: LegalOwner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LegalOwner )
• PermitNumber ( type: esriFieldTypeString, alias: PermitNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitNumber )
• PermitType ( type: esriFieldTypeString, alias: PermitType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitType )
• BuildingPermitWorkTypes ( type: esriFieldTypeString, alias: BuildingPermitWorkTypes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: BuildingPermitWorkTypes )
• ApplicationDate ( type: esriFieldTypeDate, alias: ApplicationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ApplicationDate )
• IssuedDate ( type: esriFieldTypeDate, alias: IssuedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IssuedDate )
• DeclaredValuation ( type: esriFieldTypeDouble, alias: DeclaredValuation, editable: true, nullable: true, defaultValue: null, modelName: DeclaredValuation )
• PermitFee ( type: esriFieldTypeDouble, alias: PermitFee, editable: true, nullable: true, defaultValue: null, modelName: PermitFee )
• CensusCode ( type: esriFieldTypeString, alias: CensusCode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CensusCode )
• CensusCodeDesc ( type: esriFieldTypeString, alias: CensusCodeDesc, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CensusCodeDesc )
• PermitDesc ( type: esriFieldTypeString, alias: PermitDesc, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: PermitDesc )
• PermitMilestone ( type: esriFieldTypeString, alias: PermitMilestone, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: PermitMilestone )
• PermitStatus ( type: esriFieldTypeString, alias: PermitStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitStatus )
• LegacyContractorName ( type: esriFieldTypeString, alias: LegacyContractorName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LegacyContractorName )
• ContractorName ( type: esriFieldTypeString, alias: ContractorName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ContractorName )
• CofORequired ( type: esriFieldTypeString, alias: CofORequired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CofORequired )
• ConstructionType ( type: esriFieldTypeString, alias: ConstructionType, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ConstructionType )
• ProposedUseLegacy ( type: esriFieldTypeString, alias: ProposedUseLegacy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ProposedUseLegacy )
• LegalUse ( type: esriFieldTypeString, alias: LegalUse, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LegalUse )
• DescriptionofLegalUse ( type: esriFieldTypeString, alias: DescriptionofLegalUse, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DescriptionofLegalUse )
• LegalUseBasis ( type: esriFieldTypeString, alias: LegalUseBasis, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegalUseBasis )
• UnitNum ( type: esriFieldTypeString, alias: UnitNum, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UnitNum )
• ExportDate ( type: esriFieldTypeString, alias: ExportDate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExportDate )
• ExportTime ( type: esriFieldTypeString, alias: ExportTime, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExportTime )
• ImportDateTime ( type: esriFieldTypeDate, alias: ImportDateTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ImportDateTime )
• GIS_Import_Date ( type: esriFieldTypeDate, alias: GIS_Import_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GIS_Import_Date )

Templates:

• Name: Building Permits Table
  Description:
  Prototype:
  ImportDateTime: null
  GIS_Import_Date: null
  ID: null
  SBL: null
  StreetNumber: null
  StreetName: null
  FullAddress: null
  LegalOwner: null
  PermitNumber: null
  PermitType: null
  BuildingPermitWorkTypes: null
  ApplicationDate: null
  IssuedDate: null
  DeclaredValuation: null
  PermitFee: null
  CensusCode: null
  CensusCodeDesc: null
  PermitDesc: null
  PermitMilestone: null
  PermitStatus: null
  LegacyContractorName: null
  ContractorName: null
  CofORequired: null
  ConstructionType: null
  ProposedUseLegacy: null
  LegalUse: null
  DescriptionofLegalUse: null
  LegalUseBasis: null
  UnitNum: null
  ExportDate: null
  ExportTime: 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