Name: Misc Permit Table

Display Field: name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0643109d4ceb4500ad00acc52cd7182a

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• PermitType ( type: esriFieldTypeString, alias: Permit Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PermitType , Coded Values: [Copy Charges: Copy Charges] , [Voided / Receipt Correction: Voided / Receipt Correction] , [Other: Other] , ...2 more... )
• permitnum_frompoint ( type: esriFieldTypeString, alias: Permit Number From Point, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PermitNum )
• 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 )
• createdbyname ( type: esriFieldTypeString, alias: Created By Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: createdbyname )
• createdon ( type: esriFieldTypeDate, alias: Created On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: createdon )
• modifiedby ( type: esriFieldTypeString, alias: Modified By, editable: true, nullable: true, length: 200, defaultValue: null, modelName: modifiedby )
• modifiedon ( type: esriFieldTypeDate, alias: Modified On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: modifiedon )
• modifiedonbehalfby ( type: esriFieldTypeString, alias: Modified On Behalf By, editable: true, nullable: true, length: 200, defaultValue: null, modelName: modifiedonbehalfby )
• actionby ( type: esriFieldTypeString, alias: Action By, editable: true, nullable: true, length: 100, defaultValue: null, modelName: actionby , Coded Values: [Carrie Winter: Carrie Winter] , [Cheryl Martineau: Cheryl Martineau] , [Other: Other] , ...2 more... )
• activity1notes ( type: esriFieldTypeString, alias: Activity Notes 1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: activity1notes )
• applicationdate ( type: esriFieldTypeDate, alias: Application Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: applicationdate )
• commentsrestrictions ( type: esriFieldTypeString, alias: Comments & Restrictions, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: commentsrestrictions )
• datepaid ( type: esriFieldTypeDate, alias: Date Paid, editable: true, nullable: true, length: 8, defaultValue: null, modelName: datepaid )
• documentno ( type: esriFieldTypeString, alias: Document Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: documentno )
• escroworrecordingfees ( type: esriFieldTypeDouble, alias: Fees (Escrow or Recording), editable: true, nullable: true, defaultValue: null, modelName: escroworrecordingfees )
• explainationofrequest ( type: esriFieldTypeString, alias: Request, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: explainationofrequest )
• feenotes ( type: esriFieldTypeString, alias: Fees (Notes), editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: feenotes )
• feescalculation ( type: esriFieldTypeDouble, alias: Fees (Calculation), editable: true, nullable: true, defaultValue: null, modelName: feescalculation )
• feescalculation_date ( type: esriFieldTypeDate, alias: Fees (Calculation Date), editable: true, nullable: true, length: 8, defaultValue: null, modelName: feescalculation_date )
• fixedapplicationfee ( type: esriFieldTypeDouble, alias: Fees (Fixed Application), editable: true, nullable: true, defaultValue: null, modelName: fixedapplicationfee )
• name ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: name )
• onbasedocpop ( type: esriFieldTypeString, alias: On Base Link, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: onbasedocpop )
• otherparcels ( type: esriFieldTypeString, alias: Other Parcels, editable: true, nullable: true, length: 100, defaultValue: null, modelName: otherparcels )
• parcelname ( type: esriFieldTypeString, alias: Parcel Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: parcelname )
• parcelownername ( type: esriFieldTypeString, alias: Parcel Owner, editable: true, nullable: true, length: 160, defaultValue: null, modelName: parcelownername )
• parentpermit ( type: esriFieldTypeString, alias: Additional Permit (Parent Permit), editable: true, nullable: true, length: 100, defaultValue: null, modelName: parentpermit )
• permitid ( type: esriFieldTypeString, alias: Permit ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: permitid )
• permitreceipt ( type: esriFieldTypeInteger, alias: Permit Receipt, editable: true, nullable: true, defaultValue: null, modelName: permitreceipt )
• permitstatusdate ( type: esriFieldTypeDate, alias: Permit Status Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: permitstatusdate )
• physicaladdress1 ( type: esriFieldTypeString, alias: Parcel Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: physicaladdress1 )
• physicaladdress2 ( type: esriFieldTypeString, alias: Parcel City, editable: true, nullable: true, length: 100, defaultValue: null, modelName: physicaladdress2 )
• physicaladdresszipcode ( type: esriFieldTypeString, alias: Parcel Zip, editable: true, nullable: true, length: 100, defaultValue: null, modelName: physicaladdresszipcode )
• planreviewfee ( type: esriFieldTypeDouble, alias: Fees (Plan Review), editable: true, nullable: true, defaultValue: null, modelName: planreviewfee )
• projectvaluationfee ( type: esriFieldTypeDouble, alias: Fees (Project Valuation), editable: true, nullable: true, defaultValue: null, modelName: projectvaluationfee )
• statesurcharge ( type: esriFieldTypeDouble, alias: Fees (State Surcharge), editable: true, nullable: true, defaultValue: null, modelName: statesurcharge )
• valuebasedfee ( type: esriFieldTypeDouble, alias: Fees (Value Based), editable: true, nullable: true, defaultValue: null, modelName: valuebasedfee )
• ApplicantFullName ( type: esriFieldTypeString, alias: Applicant Full Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantFullName )
• ApplicantAddress1 ( type: esriFieldTypeString, alias: Applicant Address 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantAddress1 )
• ApplicantAddress2 ( type: esriFieldTypeString, alias: Applicant Address 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantAddress2 )
• ApplicantAddress3 ( type: esriFieldTypeString, alias: Applicant Address 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantAddress3 )
• ApplicantCity ( type: esriFieldTypeString, alias: Applicant City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantCity )
• ApplicantStateProvince ( type: esriFieldTypeString, alias: Applicant State or Province, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantStateProvince )
• ApplicantPostalCode ( type: esriFieldTypeString, alias: Applicant Postal Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantPostalCode )
• ApplicantAddressComposite ( type: esriFieldTypeString, alias: Applicant Address Composite, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantAddressComposite )
• ApplicantTelephone ( type: esriFieldTypeString, alias: Applicant Telephone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantTelephone )
• ApplicantTelephone2 ( type: esriFieldTypeString, alias: Applicant Telephone 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantTelephone2 )
• ApplicantMobilePhone ( type: esriFieldTypeString, alias: Applicant Mobile Phone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantMobilePhone )
• ApplicantEmailAddress ( type: esriFieldTypeString, alias: Applicant Email Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantEmailAddress )
• ApplicantFax ( type: esriFieldTypeString, alias: Applicant Fax, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantFax )
• ApplicantBusinessName ( type: esriFieldTypeString, alias: Applicant Business Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantBusinessName )
• ApplicantLicenseNumber ( type: esriFieldTypeString, alias: Applicant License Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantLicenseNumber )
• ContractorFullName ( type: esriFieldTypeString, alias: Contractor Full Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorFullName )
• ContractorAddress1 ( type: esriFieldTypeString, alias: Contractor Address 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorAddress1 )
• ContractorAddress2 ( type: esriFieldTypeString, alias: Contractor Address 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorAddress2 )
• ContractorAddress3 ( type: esriFieldTypeString, alias: Contractor Address 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorAddress3 )
• ContractorCity ( type: esriFieldTypeString, alias: Contractor City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorCity )
• ContractorStateProvince ( type: esriFieldTypeString, alias: Contractor State or Province, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorStateProvince )
• ContractorPostalCode ( type: esriFieldTypeString, alias: Contractor Postal Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorPostalCode )
• ContractorAddressComposite ( type: esriFieldTypeString, alias: Contractor Address Composite, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorAddressComposite )
• ContractorTelephone ( type: esriFieldTypeString, alias: Contractor Telephone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorTelephone )
• ContractorTelephone2 ( type: esriFieldTypeString, alias: Contractor Telephone 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorTelephone2 )
• ContractorMobilePhone ( type: esriFieldTypeString, alias: Contractor Mobile Phone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorMobilePhone )
• ContractorEmailAddress ( type: esriFieldTypeString, alias: Contractor Email Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorEmailAddress )
• ContractorFax ( type: esriFieldTypeString, alias: Contractor Fax, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorFax )
• ContractorBusinessName ( type: esriFieldTypeString, alias: Contractor Business Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorBusinessName )
• ContractorLicenseNumber ( type: esriFieldTypeString, alias: Contractor License Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractorLicenseNumber )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: Submitted, modelName: Status , Coded Values: [Submitted: Submitted] , [In Progress: In Progress] , [Invoiced: Invoiced] , ...2 more... )
• ProofPropertyOwnership ( type: esriFieldTypeString, alias: Proof of Property Ownership, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ProofPropertyOwnership )
• ProofofOwnership ( type: esriFieldTypeString, alias: Proof Of Ownership, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProofofOwnership , Coded Values: [Yes: Yes] , [No: No] , [NA: Not Applicable] , ...1 more... )
• PermitCategory ( type: esriFieldTypeString, alias: PermitCategory, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PermitCategory , Coded Values: [Building: Building] , [Land Use: Land Use] , [Environmental: Environmental] , ...2 more... )
• PermitActivity ( type: esriFieldTypeString, alias: PermitActivity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PermitActivity , Coded Values: [Accessory Structure: Accessory Structure] , [Deck: Deck] , [Fireplace: Fireplace] , ...59 more... )
• PullTownships ( type: esriFieldTypeString, alias: PullTownships, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: PullTownships )
• Cities ( type: esriFieldTypeString, alias: Cities, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Cities )
• Townships ( type: esriFieldTypeString, alias: Townships, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Townships )
• ResponseJSON ( type: esriFieldTypeString, alias: ResponseJSON, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: ResponseJSON )
• Acknowledgement ( type: esriFieldTypeString, alias: Acknowledgement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Acknowledgement , Coded Values: [This building cannot be used as a habitable structure: This building cannot be used as a habitable structure] )
• email_recipient ( type: esriFieldTypeString, alias: email_recipient, editable: true, nullable: true, length: 255, defaultValue: null, modelName: email_recipient )
• ApplicantType ( type: esriFieldTypeString, alias: ApplicantType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApplicantType , Coded Values: [Property Owner (Unlicensed Self Contractor): Property Owner (Unlicensed Self Contractor)] , [Contractor/Builder (Also Owns the Property): Contractor/Builder (Also Owns the Property)] , [Contractor/Builder (Hired By Property Owner): Contractor/Builder (Hired By Property Owner)] , ...3 more... )
• PropertyOwnerEmail ( type: esriFieldTypeString, alias: PropertyOwnerEmail, editable: true, nullable: true, length: 500, defaultValue: null, modelName: PropertyOwnerEmail )
• PropertyOwnerPhone ( type: esriFieldTypeString, alias: PropertyOwnerPhone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PropertyOwnerPhone )
• PullBuildingNumber ( type: esriFieldTypeString, alias: PullBuildingNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PullBuildingNumber )
• PullStreetName ( type: esriFieldTypeString, alias: PullStreetName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PullStreetName )
• PullStreetType ( type: esriFieldTypeString, alias: PullStreetType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PullStreetType )
• DatePermitClosed ( type: esriFieldTypeDate, alias: DatePermitClosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DatePermitClosed )
• Receipt ( type: esriFieldTypeString, alias: Receipt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Receipt )
• SearchByPropertyAddress ( type: esriFieldTypeString, alias: SearchByPropertyAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SearchByPropertyAddress )
• SearchByParcelNumber ( type: esriFieldTypeString, alias: SearchByParcelNumber, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SearchByParcelNumber )
• PullSearchByParcelNumber ( type: esriFieldTypeString, alias: PullSearchByParcelNumber, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PullSearchByParcelNumber )
• parcelid ( type: esriFieldTypeString, alias: parcelid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parcelid )
• PaymentInitiatedDate ( type: esriFieldTypeDate, alias: PaymentInitiatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PaymentInitiatedDate )
• EscrowFee ( type: esriFieldTypeDouble, alias: EscrowFee, editable: true, nullable: true, defaultValue: null, modelName: EscrowFee )
• DataAccess ( type: esriFieldTypeString, alias: DataAccess, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DataAccess , Coded Values: [Copies: Copies] , [Inspection: Inspection] , [Both: Both] )
• ProofIdentity ( type: esriFieldTypeString, alias: ProofIdentity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProofIdentity , Coded Values: [Yes: Yes] , [No: No] , [NA: Not Applicable] , ...1 more... )
• RelatedPermitNumber ( type: esriFieldTypeString, alias: RelatedPermitNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RelatedPermitNumber )
• PullTownships2 ( type: esriFieldTypeString, alias: PullTownships2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PullTownships2 )
• ResponseJSON_1 ( type: esriFieldTypeString, alias: ResponseJSON_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ResponseJSON_1 )
• ResponseJSON2_1 ( type: esriFieldTypeString, alias: ResponseJSON2_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ResponseJSON2_1 )
• ResponseJSON3_1 ( type: esriFieldTypeString, alias: ResponseJSON3_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ResponseJSON3_1 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Misc Permit Table
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: false

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