View In:   ArcGIS Online Map Viewer

Name: KCsde.DBO.appraiser_parcels

Display Field: LOWPARCELID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This report, or feature class, is rebuilt nightly from a C# console application called KITT.GIS.Console.Maintenance.COMPAS (which is also the namespace on Apps-tfs-01). The scheduled task runs on GIS-STAGING at 4:00am and needs to coordinate with the T2 export of T2Query in order to get the current previous day's info from TerraScan, THEN the published parcel layer is generated, THEN this report is generated.

Copyright Text: Jason Eklund - GIS Coordinator Kittias County Information Technology

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -1.35186587545E7
YMin: 5899273.3116
XMax: -1.33493012918E7
YMax: 6039244.906199999
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CompletionStatus
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 0
  Label: Not Complete
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [0, 0, 0, 0]
  Outline:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 3
• Value: 1
  Label: Fielded
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 3
• Value: 2
  Label: Pending
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [255, 127, 127, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 3
• Value: 3
  Label: Complete
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [170, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [152, 230, 0, 255]
  Width: 3
Transparency: 0
Labeling Info:

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

Type ID Field: CompletionStatus

Fields:

• PARCELID ( type: esriFieldTypeString, alias: Map Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PARCELID )
• t2_ParcelNumber ( type: esriFieldTypeString, alias: ParcelNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tsilo_atrfile_PARCEL_N )
• t2_Situs ( type: esriFieldTypeString, alias: Situs, editable: true, nullable: true, length: 400, defaultValue: null, modelName: tsilo_atrfile_SITUS )
• t2_Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 102, defaultValue: null, modelName: tsilo_master_TAXPAYER_NAME )
• t2_Address1 ( type: esriFieldTypeString, alias: Address1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tsilo_master_MAIL_ADD_1 )
• t2_Address2 ( type: esriFieldTypeString, alias: Mail Addr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tsilo_master_MAIL_ADD_2 )
• t2_City ( type: esriFieldTypeString, alias: Mail City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tsilo_master_MAIL_ADD_3 )
• t2_State ( type: esriFieldTypeString, alias: Mail State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: t2_State )
• t2_Zip ( type: esriFieldTypeString, alias: Mail Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tsilo_master_ZIP_CODE )
• t2_SitusCity ( type: esriFieldTypeString, alias: t2_SitusCity, editable: true, nullable: true, length: 30, defaultValue: null, modelName: t2_SitusCity )
• t2_SitusZip ( type: esriFieldTypeString, alias: t2_SitusZip, editable: true, nullable: true, length: 15, defaultValue: null, modelName: t2_SitusZip )
• Appraiser ( type: esriFieldTypeString, alias: Appraiser, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Appraiser )
• AreaName ( type: esriFieldTypeString, alias: Area Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AreaName )
• CompletionStatus ( type: esriFieldTypeSmallInteger, alias: Completion Status, editable: true, nullable: true, defaultValue: 0, modelName: CompletionStatus , Coded Values: [0: Not Complete] , [3: Complete] , [1: Fielded] , ...1 more... )
• FieldSheetPath ( type: esriFieldTypeString, alias: FieldSheetPath, editable: true, nullable: true, length: 500, defaultValue: null, modelName: FieldSheetPath )
• DateFielded ( type: esriFieldTypeDate, alias: Date Fielded, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateFielded )
• LastUpdtDate ( type: esriFieldTypeDate, alias: LastUpdtDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdtDate )
• LastUpdtUserID ( type: esriFieldTypeString, alias: LastUpdtUserID, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdtUserID )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• CreatedUserID ( type: esriFieldTypeString, alias: CreatedUserID, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatedUserID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 0
Name: 0
Domains:
• CompletionStatus:
  Inherited
Templates:
• Name: 0
  Description:
  Prototype:
  notes: null
  PARCELID: null
  t2_ParcelNumber: null
  t2_Situs: null
  t2_Owner: null
  t2_Address1: null
  t2_Address2: null
  t2_City: null
  t2_State: null
  t2_Zip: null
  t2_SitusCity: null
  t2_SitusZip: null
  Appraiser: null
  AreaName: null
  CompletionStatus: 0
  FieldSheetPath: null
  DateFielded: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 1
Name: 1
Domains:
• CompletionStatus:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  notes: null
  PARCELID: null
  t2_ParcelNumber: null
  t2_Situs: null
  t2_Owner: null
  t2_Address1: null
  t2_Address2: null
  t2_City: null
  t2_State: null
  t2_Zip: null
  t2_SitusCity: null
  t2_SitusZip: null
  Appraiser: null
  AreaName: null
  CompletionStatus: 1
  FieldSheetPath: null
  DateFielded: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 2
Name: 2
Domains:
• CompletionStatus:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  notes: null
  PARCELID: null
  t2_ParcelNumber: null
  t2_Situs: null
  t2_Owner: null
  t2_Address1: null
  t2_Address2: null
  t2_City: null
  t2_State: null
  t2_Zip: null
  t2_SitusCity: null
  t2_SitusZip: null
  Appraiser: null
  AreaName: null
  CompletionStatus: 2
  FieldSheetPath: null
  DateFielded: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 3
Name: 3
Domains:
• CompletionStatus:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  notes: null
  PARCELID: null
  t2_ParcelNumber: null
  t2_Situs: null
  t2_Owner: null
  t2_Address1: null
  t2_Address2: null
  t2_City: null
  t2_State: null
  t2_Zip: null
  t2_SitusCity: null
  t2_SitusZip: null
  Appraiser: null
  AreaName: null
  CompletionStatus: 3
  FieldSheetPath: null
  DateFielded: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Relationships:

• amFileAttachments (1) -- Related To: KCsde.DBO.amFileAttachments (2)
• amPermitHistory (2) -- Related To: KCsde.DBO.amPermitHistory (4)
• amParcelComments (3) -- Related To: KCsde.DBO.amParcelComments (3)
• amSalesInfo (4) -- Related To: KCsde.DBO.amSalesInfo (6)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract

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: DateCreated
• Creator Field: CreatedUserID
• Edit Date Field: LastUpdtDate
• Editor Field: LastUpdtUserID

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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