Name: Permits

Display Field: OwnerName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 5426c299bcce4ec08b4557bbad34c13f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PermitNumber ( type: esriFieldTypeString, alias: Permit number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitNumber )
• AppType ( type: esriFieldTypeString, alias: Application Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AppType )
• PermitType ( type: esriFieldTypeString, alias: Permit Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitType , Coded Values: [Land Use: Land Use] )
• PermitStatus ( type: esriFieldTypeString, alias: Permit status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitStatus , Coded Values: [Administrative Review: Administrative Review] , [Approved for Inspection: Approved for Inspection] , [Approved for Issuance: Approved for Issuance] , ...5 more... )
• AppDate ( type: esriFieldTypeDate, alias: Application Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AppDate )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• InspectionDate2 ( type: esriFieldTypeDate, alias: Second Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate2 )
• DateInspected ( type: esriFieldTypeDate, alias: Date of the Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInspected )
• DateInspected2 ( type: esriFieldTypeDate, alias: Second Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInspected2 )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy , Coded Values: [Robert Schierman: Robert Schierman] , [Jennifer Croonborg-Murphy: Jennifer Croonborg-Murphy] , [Josh Rowley: Josh Rowley] , ...5 more... )
• DateApproved ( type: esriFieldTypeDate, alias: Date Approved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateApproved )
• DateApproved2 ( type: esriFieldTypeDate, alias: Second Date Approved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateApproved2 )
• ApprovedBy ( type: esriFieldTypeString, alias: Approved By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ApprovedBy , Coded Values: [Robert Schierman: Robert Schierman] , [Jennifer Croonborg-Murphy: Jennifer Croonborg-Murphy] , [Josh Rowley: Josh Rowley] , ...5 more... )
• DateDenied ( type: esriFieldTypeDate, alias: Date Denied, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateDenied )
• IssuanceDate ( type: esriFieldTypeDate, alias: Date the permit was issued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IssuanceDate )
• RefundDate ( type: esriFieldTypeDate, alias: Permit Refund Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RefundDate )
• DeadlineDate ( type: esriFieldTypeDate, alias: Deadline Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DeadlineDate )
• DeadlineDate2 ( type: esriFieldTypeDate, alias: Second Deadline Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DeadlineDate2 )
• Citation ( type: esriFieldTypeString, alias: Citation, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Citation )
• CitationDate ( type: esriFieldTypeDate, alias: Date of cititation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CitationDate )
• TownInputDate ( type: esriFieldTypeDate, alias: Town input date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TownInputDate )
• StatePermit ( type: esriFieldTypeString, alias: State permit number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: StatePermit )
• Conditions ( type: esriFieldTypeString, alias: Conditions, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Conditions )
• ForDescription ( type: esriFieldTypeString, alias: ForDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ForDescription )
• UserId ( type: esriFieldTypeString, alias: User ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UserId )
• ParcelID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ParcelID )
• OwnerName ( type: esriFieldTypeString, alias: Owners Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerName )
• OwnerFirstName ( type: esriFieldTypeString, alias: OwnerFirstName, editable: true, nullable: true, length: 40, defaultValue: null, modelName: OwnerFirstName )
• OwnerLastName ( type: esriFieldTypeString, alias: OwnerLastName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: OwnerLastName )
• PropertyAddress ( type: esriFieldTypeString, alias: Property Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PropertyAddress )
• RelGUID ( type: esriFieldTypeGUID, alias: RelGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelGUID )
• agentId ( type: esriFieldTypeGUID, alias: agentId, editable: true, nullable: true, length: 38, defaultValue: null, modelName: agentId )
• ownerId ( type: esriFieldTypeGUID, alias: ownerId, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ownerId )
• contractorId ( type: esriFieldTypeGUID, alias: contractorId, editable: true, nullable: true, length: 38, defaultValue: null, modelName: contractorId )
• ConnectID ( type: esriFieldTypeInteger, alias: Temp Connect ID, editable: true, nullable: true, defaultValue: null, modelName: ConnectID )
• AdditionalLegal ( type: esriFieldTypeString, alias: Additional Legal Description, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: AdditionalLegal )
• conversion ( type: esriFieldTypeString, alias: Conversion of of non-residential to residential, editable: true, nullable: true, length: 5, defaultValue: null, modelName: conversion )
• CSM ( type: esriFieldTypeString, alias: CSM Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CSM )
• SiteCityState ( type: esriFieldTypeString, alias: Site City State Zip, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SiteCityStateZip )
• Zip ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Zip )
• DeededAcres ( type: esriFieldTypeInteger, alias: Deeded Acres, editable: true, nullable: true, defaultValue: null, modelName: DeededAcres )
• STR ( type: esriFieldTypeString, alias: Section Townhip Range, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STR )
• Section ( type: esriFieldTypeString, alias: Section, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Section )
• Township ( type: esriFieldTypeString, alias: Township, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Township )
• Range ( type: esriFieldTypeString, alias: Range, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Range )
• SanitaryPermitNumber ( type: esriFieldTypeString, alias: Sanitary Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SanitaryPermitNumber )
• SignPermitNumber ( type: esriFieldTypeString, alias: Sign Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignPermitNumber )
• SpecialPermitNumber ( type: esriFieldTypeString, alias: Special Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SpecialPermitNumber )
• ConditionalPermitNumber ( type: esriFieldTypeString, alias: Conditional Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ConditionalPermitNumber )
• BOAPermitNumber ( type: esriFieldTypeString, alias: BOA Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BOAPermitNumber )
• VarianceBOA ( type: esriFieldTypeString, alias: Granted by Variance (BOA), editable: true, nullable: true, length: 5, defaultValue: null, modelName: VarianceBOA )
• PreviousBOA ( type: esriFieldTypeString, alias: Previously Granted by Variance (BOA), editable: true, nullable: true, length: 5, defaultValue: null, modelName: PreviousBOA )
• RevokeReason ( type: esriFieldTypeString, alias: Reason for revocation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RevokeReason )
• Pin ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Pin )
• Volume ( type: esriFieldTypeString, alias: Volume, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Volume )
• Page ( type: esriFieldTypeString, alias: Page(s), editable: true, nullable: true, length: 50, defaultValue: null, modelName: Page )
• govLots ( type: esriFieldTypeString, alias: Govt. Lots, editable: true, nullable: true, length: 100, defaultValue: null, modelName: govLots )
• Lot ( type: esriFieldTypeString, alias: Lot(s), editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lot )
• Block ( type: esriFieldTypeString, alias: Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Block )
• SubdCondo ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SubdCondo )
• quarterQuarter ( type: esriFieldTypeString, alias: 1/4, 1/4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: quarterQuarter )
• SanitaryDate ( type: esriFieldTypeDate, alias: Sanitary Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SanitaryDate )
• MitigationRequired ( type: esriFieldTypeString, alias: Mitigation Required, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MitigationRequired )
• MitigationAttached ( type: esriFieldTypeString, alias: Mitigation Attached, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MitigationAttached )
• SubStandard ( type: esriFieldTypeString, alias: Sub-Standard Lot, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SubStandard )
• CommonOwner ( type: esriFieldTypeString, alias: Common Ownership, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CommonOwner )
• NonConform ( type: esriFieldTypeString, alias: Non-Conforming, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NonConform )
• AffidavitRequired ( type: esriFieldTypeString, alias: Affidavit Required, editable: true, nullable: true, length: 5, defaultValue: null, modelName: AffidavitRequired )
• AffidavitAttached ( type: esriFieldTypeString, alias: Affidavit Attached, editable: true, nullable: true, length: 5, defaultValue: null, modelName: AffidavitAttached )
• LegallyCreated ( type: esriFieldTypeString, alias: Parcel Legally Created, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LegallyCreated )
• Surveyed ( type: esriFieldTypeString, alias: Property Surveyed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Surveyed )
• ConditionsAttached ( type: esriFieldTypeString, alias: Conditions Attached, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ConditionsAttached )
• Bedrooms ( type: esriFieldTypeString, alias: Bedrooms, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Bedrooms )
• DeedOfRecord ( type: esriFieldTypeString, alias: Deed of Record, editable: true, nullable: true, length: 500, defaultValue: null, modelName: DeedOfRecord )
• Zoning ( type: esriFieldTypeString, alias: Zoning District, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Zoning )
• PreviousBOAPermitNumber ( type: esriFieldTypeString, alias: Previous BOA Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PreviousBOAPermitNumber )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• LakesClass ( type: esriFieldTypeString, alias: Lakes Classification, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LakesClass )
• ConstructionCost ( type: esriFieldTypeDouble, alias: ConstructionCost, editable: true, nullable: true, defaultValue: null, modelName: ConstructionCost )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: Comments )
• ConstCost ( type: esriFieldTypeDouble, alias: Construction Cost, editable: true, nullable: true, defaultValue: null, modelName: ConstCost )
• CommonOwnerComments ( type: esriFieldTypeString, alias: Common Ownership Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CommonOwnerComments )
• SurveyComments ( type: esriFieldTypeString, alias: Survey Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SurveyComments )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: State )
• SanitaryRequired ( type: esriFieldTypeString, alias: SanitaryRequired, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SanitaryRequired , Coded Values: [Yes: Yes] , [No: No] )
• NoSanitaryReqReason ( type: esriFieldTypeString, alias: NoSanitaryReqReason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NoSanitaryReqReason , Coded Values: [No System on Property: No System on Property] , [No Record on File: No Record on File] )
• NoSanitaryReqExplain ( type: esriFieldTypeString, alias: NoSanitaryReqExplain, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NoSanitaryReqExplain )
• IsFloodplainZone ( type: esriFieldTypeString, alias: IsFloodplainZone, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IsFloodplainZone , Coded Values: [Yes: Yes] , [No: No] )
• FloodplainZoneName ( type: esriFieldTypeString, alias: FloodplainZoneName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FloodplainZoneName )
• WetlandsOnProperty ( type: esriFieldTypeString, alias: WetlandsOnProperty, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WetlandsOnProperty , Coded Values: [Yes: Yes] , [No: No] )
• WetlandsGreaterThanTwoAcres ( type: esriFieldTypeString, alias: WetlandsGreaterThanTwoAcres, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WetlandsGreaterThanTwoAcres , Coded Values: [Yes: Yes] , [No: No] )
• SanitaryReqHistory ( type: esriFieldTypeString, alias: SanitaryReqHistory, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SanitaryReqHistory )

Templates:

• Name: Permits
  Description:
  Prototype:
  WetlandsGreaterThanTwoAcres: null
  SanitaryReqHistory: null
  PermitNumber: null
  AppType: null
  PermitType: null
  PermitStatus: null
  AppDate: null
  InspectionDate: null
  InspectionDate2: null
  DateInspected: null
  DateInspected2: null
  InspectedBy: null
  DateApproved: null
  DateApproved2: null
  ApprovedBy: null
  DateDenied: null
  IssuanceDate: null
  RefundDate: null
  DeadlineDate: null
  DeadlineDate2: null
  Citation: null
  CitationDate: null
  TownInputDate: null
  StatePermit: null
  Conditions: null
  ForDescription: null
  UserId: null
  ParcelID: null
  OwnerName: null
  OwnerFirstName: null
  OwnerLastName: null
  PropertyAddress: null
  RelGUID: null
  agentId: null
  ownerId: null
  contractorId: null
  ConnectID: null
  AdditionalLegal: null
  conversion: null
  CSM: null
  SiteCityState: null
  Zip: null
  DeededAcres: null
  STR: null
  Section: null
  Township: null
  Range: null
  SanitaryPermitNumber: null
  SignPermitNumber: null
  SpecialPermitNumber: null
  ConditionalPermitNumber: null
  BOAPermitNumber: null
  VarianceBOA: null
  PreviousBOA: null
  RevokeReason: null
  Pin: null
  Volume: null
  Page: null
  govLots: null
  Lot: null
  Block: null
  SubdCondo: null
  quarterQuarter: null
  SanitaryDate: null
  MitigationRequired: null
  MitigationAttached: null
  SubStandard: null
  CommonOwner: null
  NonConform: null
  AffidavitRequired: null
  AffidavitAttached: null
  LegallyCreated: null
  Surveyed: null
  ConditionsAttached: null
  Bedrooms: null
  DeedOfRecord: null
  Zoning: null
  PreviousBOAPermitNumber: null
  WetlandsOnProperty: null
  FloodplainZoneName: null
  IsFloodplainZone: null
  NoSanitaryReqExplain: null
  LakesClass: null
  ConstructionCost: null
  Comments: null
  ConstCost: null
  CommonOwnerComments: null
  SurveyComments: null
  City: null
  State: null
  SanitaryRequired: null
  NoSanitaryReqReason: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Fees (4) -- Related To: Fees (2)
• zoning.WEBUSER.permitPoints (3) -- Related To: Permit Points (8)
• Permits (7) -- Related To: Contractors (6)
• Agents (5) -- Related To: Agents (5)
• Owners (6) -- Related To: Owners (7)
• Structures (1) -- Related To: Structures (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata