Name: Variance_Submittal_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: 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)
• 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)
• Signature (type: esriFieldTypeString, alias: Signature, 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)
• 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)
• VarianceType (type: esriFieldTypeString, alias: Variance Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Use Variance: Use Variance], [Area Variance: Area Variance])
• 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 ...)
• Narrative (type: esriFieldTypeString, alias: Provide Narrative that Includes the Following, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number1 (type: esriFieldTypeString, alias: (1) The variance is not contrary to the public interest and that such a variance will be in general harmony with the purposes and intent of this chapter., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number2 (type: esriFieldTypeString, alias: (2) The variance will not permit the establishment of a use which is not permitted or permissible in the district., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number3 (type: esriFieldTypeString, alias: (3) Special conditions and circumstances exist which are peculiar to the land, structure, or building involved and which are not applicable to other lands, structures, or buildings in the same district., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number4 (type: esriFieldTypeString, alias: (4) The literal interpretation of the provisions of this chapter would deprive the applicant of rights commonly enjoyed by other properties in the same district., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number5 (type: esriFieldTypeString, alias: (5) The hardship is not shared generally by other land or buildings in the area., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number6 (type: esriFieldTypeString, alias: (6) The hardship results from the strict application of this chapter and is not the result of self-created or self-imposed circumstances.", SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UniqueID (type: esriFieldTypeString, alias: Permit ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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/13/2023 8:06:52 PM

Data Last Edit Date: 3/13/2023 8:06:52 PM

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