Name: ComDev_SpecialException_Payment_JOIN

Display Field: COUNTY

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 740225.179703917
YMin: 543001.79777725
XMax: 883908.566549167
YMax: 682123.58285334
Spatial Reference: 103444 (103444)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[135,0,135,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId_1

Unique ID Field:

Name : ObjectId_1

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ADDRESS_NU (type: esriFieldTypeString, alias: ADDRESS_NU, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• STREET_NAM (type: esriFieldTypeString, alias: STREET_NAM, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• SUFFIX (type: esriFieldTypeString, alias: SUFFIX, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• UNIT (type: esriFieldTypeString, alias: UNIT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MUNICIPALI (type: esriFieldTypeString, alias: MUNICIPALI, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SUBDIVISIO (type: esriFieldTypeString, alias: SUBDIVISIO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CSM_NUM (type: esriFieldTypeString, alias: CSM_NUM, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• LOTNUM (type: esriFieldTypeString, alias: LOTNUM, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• PARCEL_ID (type: esriFieldTypeString, alias: PARCEL_ID, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 252, nullable: true, editable: true)
• MA_CITY (type: esriFieldTypeString, alias: MA_CITY, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• MA_STATE (type: esriFieldTypeString, alias: MA_STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• MA_ZIP (type: esriFieldTypeString, alias: MA_ZIP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_us (type: esriFieldTypeString, alias: created_us, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• created_da (type: esriFieldTypeDate, alias: created_da, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edite (type: esriFieldTypeString, alias: last_edite, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• last_edi_1 (type: esriFieldTypeDate, alias: last_edi_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 51, nullable: true, editable: true)
• ADDRESS2 (type: esriFieldTypeString, alias: ADDRESS2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDR_MUNI (type: esriFieldTypeString, alias: ADDR_MUNI, SQL Type: sqlTypeOther, length: 51, nullable: true, editable: true)
• GlobalID_2 (type: esriFieldTypeGUID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FileNumber (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PaidDate (type: esriFieldTypeDate, alias: Paid Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PaidAmmount (type: esriFieldTypeString, alias: Paid Amount, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PaidBy (type: esriFieldTypeString, alias: Paid By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ReceiptNumber (type: esriFieldTypeString, alias: Receipt Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubmissionCode (type: esriFieldTypeString, alias: Submission Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParcelNumberSubmission (type: esriFieldTypeString, alias: SubmissionParcel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerName (type: esriFieldTypeString, alias: Applicant Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerStreetAddress (type: esriFieldTypeString, alias: Applicant Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerCity (type: esriFieldTypeString, alias: Applicant City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerState (type: esriFieldTypeString, alias: Applicant State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerZip (type: esriFieldTypeString, alias: Applicant Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerPhone (type: esriFieldTypeString, alias: Applicant Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerEmail (type: esriFieldTypeString, alias: Applicant Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Applicant_is_Property (type: esriFieldTypeString, alias: Is Applicant Property Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• OwnerName (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerStreetAddress (type: esriFieldTypeString, alias: Owner Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerCity (type: esriFieldTypeString, alias: Owner City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerState (type: esriFieldTypeString, alias: Owner State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerZip (type: esriFieldTypeString, alias: Owner Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerPhone (type: esriFieldTypeString, alias: Owner Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OwnerEmail (type: esriFieldTypeString, alias: Owner Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ProjectName (type: esriFieldTypeString, alias: Special Exception Request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ProjectDescription (type: esriFieldTypeString, alias: Description of the Special Exception Request, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• NumberParcels (type: esriFieldTypeString, alias: Number of Parcels, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• ParcelNumber1 (type: esriFieldTypeString, alias: Parcel Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address1 (type: esriFieldTypeString, alias: Site Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zoning1 (type: esriFieldTypeString, alias: Current Zoning, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AGD - General Agriculture: AGD - General Agriculture], [RSF - Single Family Residential: RSF - Single Family Residential], [RTF - Two Family Residential: RTF - Two Family Residential], ... 12 more ...)
• ParcelNumber2 (type: esriFieldTypeString, alias: Parcel Number (2), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zoning2 (type: esriFieldTypeString, alias: Current Zoning (2), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AGD - General Agriculture: AGD - General Agriculture], [RSF - Single Family Residential: RSF - Single Family Residential], [RTF - Two Family Residential: RTF - Two Family Residential], ... 12 more ...)
• ParcelNumber3 (type: esriFieldTypeString, alias: Parcel Number (3), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address3 (type: esriFieldTypeString, alias: Site Address (3), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zoning3 (type: esriFieldTypeString, alias: Current Zoning (3), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AGD - General Agriculture: AGD - General Agriculture], [RSF - Single Family Residential: RSF - Single Family Residential], [RTF - Two Family Residential: RTF - Two Family Residential], ... 12 more ...)
• ParcelNumber4 (type: esriFieldTypeString, alias: Parcel Number (4), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address4 (type: esriFieldTypeString, alias: Site Address (4), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zoning4 (type: esriFieldTypeString, alias: Current Zoning (4), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AGD - General Agriculture: AGD - General Agriculture], [RSF - Single Family Residential: RSF - Single Family Residential], [RTF - Two Family Residential: RTF - Two Family Residential], ... 12 more ...)
• ParcelNumber5 (type: esriFieldTypeString, alias: Parcel Number (5), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address5 (type: esriFieldTypeString, alias: Site Address (5), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zoning5 (type: esriFieldTypeString, alias: Current Zoning (5), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AGD - General Agriculture: AGD - General Agriculture], [RSF - Single Family Residential: RSF - Single Family Residential], [RTF - Two Family Residential: RTF - Two Family Residential], ... 12 more ...)
• CurrentUse (type: esriFieldTypeString, alias: Current Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ProposedUse (type: esriFieldTypeString, alias: Proposed Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note1 (type: esriFieldTypeString, alias: (1) The establishment, maintenance or operation of the proposed special exception use or structure at the proposed location will not be detrimental or injurious to the use and enjoyment of existing uses on adjacent properties or properties in the vicinity., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note2 (type: esriFieldTypeString, alias: (2) The establishment, maintenance or operation of the proposed special exception use or structure alone or in combination with other existing special exception uses and structures in the vicinity will not cause traffic hazards., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note3 (type: esriFieldTypeString, alias: (3) Adequate provision is made for surface water drainage, ingress and egress to the property, and off-street parking., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note4 (type: esriFieldTypeString, alias: (4) Adequate public facilities and services are available for the proposed special exception use or structure., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AdditionalNotes (type: esriFieldTypeString, alias: Additional Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• SubmissionDate (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UniqueID (type: esriFieldTypeString, alias: Permit ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId_1 (type: esriFieldTypeOID, alias: ObjectId_1, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: Address
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/19/2023 4:20:48 PM

Schema Last Edit Date: 3/21/2023 6:54:50 PM

Data Last Edit Date: 3/21/2023 6:54:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat