Name: ComDev_SpecialException_Submission_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: 255, 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)
• ProjectName (type: esriFieldTypeString, alias: Variance Request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RequestVariance (type: esriFieldTypeString, alias: What Chapter Would You Like a Variance From?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ProjectDescription (type: esriFieldTypeString, alias: Description of the Variance Request, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PropertyInfo (type: esriFieldTypeString, alias: Property Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParcelNumber (type: esriFieldTypeString, alias: Parcel Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zoning (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 ...)
• 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)
• ApplicantProperty (type: esriFieldTypeString, alias: Petitioner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerName (type: esriFieldTypeString, alias: Petitioner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerStreetAddress (type: esriFieldTypeString, alias: Petitioner Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerCity (type: esriFieldTypeString, alias: Petitioner City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerState (type: esriFieldTypeString, alias: Petitioner State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerZip (type: esriFieldTypeString, alias: Petitioner Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerPhone (type: esriFieldTypeString, alias: Petitioner Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PetitionerEmail (type: esriFieldTypeString, alias: Petitioner 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])
• Applicant_or_Property (type: esriFieldTypeString, alias: Property Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• SubmissionDate (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AdditionalNotes (type: esriFieldTypeString, alias: Additional Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Signature (type: esriFieldTypeString, alias: Signature, 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)
• 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)
• 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)
• UniqueID (type: esriFieldTypeString, alias: Permit ID, 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 ...)
• 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: 5/2/2023 6:13:40 PM

Schema Last Edit Date: 3/21/2023 6:22:59 PM

Data Last Edit Date: 3/21/2023 6:22:59 PM

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