Name: Address_and_OpenGOV_Permit_Join
Display Field: editorname
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: 5000
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13706305.4330559
YMin: 5654934.94850755
XMax: -13683606.1215188
YMax: 5673911.55314447
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.stnum + \" \" + DomainName($feature, 'stprefix') + \" \" + DomainName($feature, 'stname') + \" \" + DomainName($feature, 'sttype') + \" \" + $feature.unitnum","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":2000,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: ObjectId
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- parcel (type: esriFieldTypeString, alias: parcel, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- lastupdate (type: esriFieldTypeDate, alias: lastupdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- editorname (type: esriFieldTypeString, alias: editorname, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- stnum (type: esriFieldTypeInteger, alias: stnum, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stprefix (type: esriFieldTypeString, alias: stprefix, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [E: E], [N: N], [NE: NE], ... 5 more ...)
- sttype (type: esriFieldTypeString, alias: sttype, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [ALY: ALLEY], [ANX: ANNEX], [ARC: ARCADE], ... 181 more ...)
- stname (type: esriFieldTypeString, alias: stname, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [10TH: 10TH], [11TH: 11TH], [12TH: 12TH], ... 677 more ...)
- tempadd (type: esriFieldTypeString, alias: tempadd, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- unittype (type: esriFieldTypeString, alias: unittype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [apt: apartment - residence], [building: building number - business], [business: business], ... 7 more ...)
- unitnum (type: esriFieldTypeString, alias: unitnum, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- incity (type: esriFieldTypeString, alias: incity, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: yes], [no: no])
- city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Dayton: Dayton], [Dundee: Dundee], [Hillsboro: Hillsboro], ... 4 more ...)
- fulladd (type: esriFieldTypeString, alias: fulladd, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- TaxlotJoin (type: esriFieldTypeString, alias: TaxlotJoin, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- stsuffix (type: esriFieldTypeString, alias: stsuffix, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- InUGB (type: esriFieldTypeString, alias: InUGB, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- InURA (type: esriFieldTypeString, alias: InURA, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Add_ID (type: esriFieldTypeString, alias: Add_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- AutoNum (type: esriFieldTypeSmallInteger, alias: AutoNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Zip (type: esriFieldTypeInteger, alias: Zip Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Record_Number (type: esriFieldTypeString, alias: Record #, SQL Type: sqlTypeOther, length: 256, nullable: false, editable: true)
- Record_Type (type: esriFieldTypeString, alias: Record Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- Applicant_Name (type: esriFieldTypeString, alias: Applicant, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- Date_Submitted (type: esriFieldTypeDate, alias: Date Submitted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- Record_Status (type: esriFieldTypeString, alias: Record Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- Detailed_Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- MAT_ID (type: esriFieldTypeString, alias: MAT_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- Location_ID (type: esriFieldTypeString, alias: Location_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- CurrentStatus (type: esriFieldTypeString, alias: Current Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
Templates:
Name: Newberg Addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/1/2026 7:50:39 PM
Schema Last Edit Date: 6/8/2026 4:29:43 PM
Data Last Edit Date: 6/8/2026 4:29:43 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat