{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "KCsde.DBO.appraiser_parcels", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "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.", "copyrightText": "Jason Eklund - GIS Coordinator Kittias County Information Technology", "editFieldsInfo": { "creationDateField": "DateCreated", "creatorField": "CreatedUserID", "editDateField": "LastUpdtDate", "editorField": "LastUpdtUserID" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "amFileAttachments", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "t2_ParcelNumber", "composite": false }, { "id": 2, "name": "amPermitHistory", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "t2_ParcelNumber", "composite": false }, { "id": 3, "name": "amParcelComments", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "t2_ParcelNumber", "composite": false }, { "id": 4, "name": "amSalesInfo", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "t2_ParcelNumber", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1566853956000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": -1.35186587545E7, "ymin": 5899273.3116, "xmax": -1.33493012918E7, "ymax": 6039244.906199999, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "CompletionStatus", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 3 } }, "value": "0", "label": "Not Complete", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 3 } }, "value": "1", "label": "Fielded", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 127, 127, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 3 } }, "value": "2", "label": "Pending", "description": "" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 170, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 152, 230, 0, 255 ], "width": 3 } }, "value": "3", "label": "Complete", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LOWPARCELID", "typeIdField": "CompletionStatus", "subtypeField": "", "fields": [ { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "Map Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PARCELID" }, { "name": "t2_ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tsilo_atrfile_PARCEL_N" }, { "name": "t2_Situs", "type": "esriFieldTypeString", "alias": "Situs", "domain": null, "editable": true, "nullable": true, "length": 400, "defaultValue": null, "modelName": "tsilo_atrfile_SITUS" }, { "name": "t2_Owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": null, "editable": true, "nullable": true, "length": 102, "defaultValue": null, "modelName": "tsilo_master_TAXPAYER_NAME" }, { "name": "t2_Address1", "type": "esriFieldTypeString", "alias": "Address1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tsilo_master_MAIL_ADD_1" }, { "name": "t2_Address2", "type": "esriFieldTypeString", "alias": "Mail Addr", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tsilo_master_MAIL_ADD_2" }, { "name": "t2_City", "type": "esriFieldTypeString", "alias": "Mail City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tsilo_master_MAIL_ADD_3" }, { "name": "t2_State", "type": "esriFieldTypeString", "alias": "Mail State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "t2_State" }, { "name": "t2_Zip", "type": "esriFieldTypeString", "alias": "Mail Zip", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tsilo_master_ZIP_CODE" }, { "name": "t2_SitusCity", "type": "esriFieldTypeString", "alias": "t2_SitusCity", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "t2_SitusCity" }, { "name": "t2_SitusZip", "type": "esriFieldTypeString", "alias": "t2_SitusZip", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "t2_SitusZip" }, { "name": "Appraiser", "type": "esriFieldTypeString", "alias": "Appraiser", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Appraiser" }, { "name": "AreaName", "type": "esriFieldTypeString", "alias": "Area Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "AreaName" }, { "name": "CompletionStatus", "type": "esriFieldTypeSmallInteger", "alias": "Completion Status", "domain": { "type": "codedValue", "name": "AppraisalCompletionStatus", "description": "completion status for Appraiser Mobile", "codedValues": [ { "name": "Not Complete", "code": 0 }, { "name": "Complete", "code": 3 }, { "name": "Fielded", "code": 1 }, { "name": "Pending", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "CompletionStatus" }, { "name": "FieldSheetPath", "type": "esriFieldTypeString", "alias": "FieldSheetPath", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "FieldSheetPath" }, { "name": "DateFielded", "type": "esriFieldTypeDate", "alias": "Date Fielded", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateFielded" }, { "name": "LastUpdtDate", "type": "esriFieldTypeDate", "alias": "LastUpdtDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastUpdtDate" }, { "name": "LastUpdtUserID", "type": "esriFieldTypeString", "alias": "LastUpdtUserID", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LastUpdtUserID" }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateCreated" }, { "name": "CreatedUserID", "type": "esriFieldTypeString", "alias": "CreatedUserID", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CreatedUserID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "notes", "type": "esriFieldTypeString", "alias": "notes", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "notes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "I235734PARCELID3", "fields": "PARCELID,t2_ParcelNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_4348", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Appraiser", "fields": "Appraiser", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S3770_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [ { "id": 0, "name": "0", "domains": { "CompletionStatus": {"type": "inherited"} }, "templates": [ { "name": "0", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": 1, "name": "1", "domains": { "CompletionStatus": {"type": "inherited"} }, "templates": [ { "name": "1", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": 2, "name": "2", "domains": { "CompletionStatus": {"type": "inherited"} }, "templates": [ { "name": "2", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPolygon" } ] }, { "id": 3, "name": "3", "domains": { "CompletionStatus": {"type": "inherited"} }, "templates": [ { "name": "3", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPolygon" } ] } ], "templates": [], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.91, "id": 2, "name": "KCsde.DBO.amFileAttachments", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "appraiser_parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParcelNumber", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1554750852000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ParcelNumber", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParcelNumber" }, { "name": "FileID", "type": "esriFieldTypeInteger", "alias": "FileID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FileID" }, { "name": "Extension", "type": "esriFieldTypeString", "alias": "Extension", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Extension" }, { "name": "Form", "type": "esriFieldTypeInteger", "alias": "Form", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Form" }, { "name": "KeyID", "type": "esriFieldTypeInteger", "alias": "KeyID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "KeyID" }, { "name": "FileTypeID", "type": "esriFieldTypeSmallInteger", "alias": "FileTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FileTypeID" }, { "name": "AURL", "type": "esriFieldTypeString", "alias": "AURL", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "AURL" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "IsPrimary", "type": "esriFieldTypeString", "alias": "IsPrimary", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IsPrimary" }, { "name": "IsDeleted", "type": "esriFieldTypeString", "alias": "IsDeleted", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IsDeleted" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Description" } ], "indexes": [ { "name": "UUID_4352", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_4352", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "parcelNbr", "fields": "ParcelNumber", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "KCsde.DBO.amFileAttachments", "description": "", "prototype": { "attributes": { "IsDeleted": null, "ParcelNumber": null, "FileID": null, "Extension": null, "Form": null, "KeyID": null, "FileTypeID": null, "AURL": null, "Description": null, "IsPrimary": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "id": 3, "name": "KCsde.DBO.amParcelComments", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "appraiser_parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParcelNumber", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1565373655000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "UserName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ParcelID", "type": "esriFieldTypeInteger", "alias": "ParcelID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ParcelID" }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParcelNumber" }, { "name": "RollYear", "type": "esriFieldTypeSmallInteger", "alias": "RollYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RollYear" }, { "name": "ParcelType", "type": "esriFieldTypeString", "alias": "ParcelType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParcelType" }, { "name": "CommentDate", "type": "esriFieldTypeDate", "alias": "CommentDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CommentDate" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comment" }, { "name": "UserName", "type": "esriFieldTypeString", "alias": "UserName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UserName" }, { "name": "CommentPriority", "type": "esriFieldTypeString", "alias": "CommentPriority", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CommentPriority" }, { "name": "IsPublic", "type": "esriFieldTypeString", "alias": "IsPublic", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IsPublic" }, { "name": "WillPrint", "type": "esriFieldTypeString", "alias": "WillPrint", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "WillPrint" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "GDB_239575_Parce", "fields": "ParcelNumber", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_4357", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_4357", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "KCsde.DBO.amParcelComments", "description": "", "prototype": { "attributes": { "WillPrint": null, "ParcelID": null, "ParcelNumber": null, "RollYear": null, "ParcelType": null, "CommentDate": null, "Comment": null, "UserName": null, "CommentPriority": null, "IsPublic": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "id": 4, "name": "KCsde.DBO.amPermitHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "appraiser_parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParcelNumber", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1552694019000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ParcelNumber", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "t2_ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "tsilo_atrfile_PARCEL_N" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "PermitNumber", "type": "esriFieldTypeString", "alias": "PermitNumber\n2009-00250\n2012-00602\n2014-00133\n2014-00681", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PermitNumber" }, { "name": "DateOpened", "type": "esriFieldTypeDate", "alias": "DateOpened", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateOpened" }, { "name": "DateClosed", "type": "esriFieldTypeDate", "alias": "DateClosed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateClosed" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Description" }, { "name": "Amount", "type": "esriFieldTypeDouble", "alias": "Amount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Amount" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RollYear", "type": "esriFieldTypeSmallInteger", "alias": "RollYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RollYear" }, { "name": "ParcelType", "type": "esriFieldTypeString", "alias": "ParcelType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParcelType" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Status" } ], "indexes": [ { "name": "UUID_4346", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_4346", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "parcelNbr", "fields": "ParcelNumber", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "KCsde.DBO.amPermitHistory", "description": "", "prototype": { "attributes": { "ParcelType": null, "ParcelNumber": null, "Status": null, "PermitNumber": null, "DateOpened": null, "DateClosed": null, "Description": null, "Amount": null, "RollYear": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "id": 5, "name": "KCsde.DBO.amAreaUpload", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1566853964000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "AreaName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "AreaName", "type": "esriFieldTypeString", "alias": "AreaName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "AreaName" }, { "name": "Appraiser", "type": "esriFieldTypeString", "alias": "Appraiser", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Appraiser" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "UUID_4362", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_4362", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "KCsde.DBO.amAreaUpload", "description": "", "prototype": { "attributes": { "Appraiser": null, "AreaName": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "id": 6, "name": "KCsde.DBO.amSalesInfo", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "appraiser_parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParcelNumber", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1571693862000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ParcelNumber", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ParcelID", "type": "esriFieldTypeInteger", "alias": "ParcelID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ParcelID" }, { "name": "ParcelNumber", "type": "esriFieldTypeString", "alias": "ParcelNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ParcelNumber" }, { "name": "RollYear", "type": "esriFieldTypeSmallInteger", "alias": "RollYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RollYear" }, { "name": "SaleDate", "type": "esriFieldTypeDate", "alias": "SaleDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SaleDate" }, { "name": "StateQual", "type": "esriFieldTypeString", "alias": "StateQual", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "StateQual" }, { "name": "FilingDate", "type": "esriFieldTypeDate", "alias": "FilingDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FilingDate" }, { "name": "SaleNote", "type": "esriFieldTypeString", "alias": "SaleNote", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "SaleNote" }, { "name": "LandOnlySale", "type": "esriFieldTypeString", "alias": "LandOnlySale", "domain": null, "editable": true, "nullable": false, "length": 3, "defaultValue": null, "modelName": "LandOnlySale" }, { "name": "Grantor", "type": "esriFieldTypeString", "alias": "Grantor", "domain": null, "editable": true, "nullable": true, "length": 102, "defaultValue": null, "modelName": "Grantor" }, { "name": "Grantee", "type": "esriFieldTypeString", "alias": "Grantee", "domain": null, "editable": true, "nullable": true, "length": 102, "defaultValue": null, "modelName": "Grantee" }, { "name": "OriginalSaleprice", "type": "esriFieldTypeDouble", "alias": "OriginalSaleprice", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OriginalSaleprice" }, { "name": "LocalQual", "type": "esriFieldTypeString", "alias": "LocalQual", "domain": null, "editable": true, "nullable": false, "length": 7, "defaultValue": null, "modelName": "LocalQual" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ExciseNumber", "type": "esriFieldTypeString", "alias": "ExciseNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ExciseNumber" } ], "indexes": [ { "name": "UUID_4364", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_4364", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "parcelNbr", "fields": "ParcelNumber", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "KCsde.DBO.amSalesInfo", "description": "", "prototype": { "attributes": { "ExciseNumber": null, "ParcelID": 0, "ParcelNumber": null, "RollYear": null, "SaleDate": null, "StateQual": null, "FilingDate": null, "SaleNote": null, "LandOnlySale": " ", "Grantor": null, "Grantee": null, "OriginalSaleprice": null, "LocalQual": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.91, "id": 7, "name": "KCsde.DBO.amErrorLog", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1576717400000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "username", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "username", "type": "esriFieldTypeString", "alias": "username", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "username" }, { "name": "time", "type": "esriFieldTypeDate", "alias": "time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "time" }, { "name": "exception", "type": "esriFieldTypeString", "alias": "exception", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "exception" }, { "name": "message", "type": "esriFieldTypeString", "alias": "message", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "message" }, { "name": "module", "type": "esriFieldTypeString", "alias": "module", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "module" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "gdb_ct3_4371", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_4371", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "KCsde.DBO.amErrorLog", "description": "", "prototype": { "attributes": { "module": null, "username": null, "time": null, "exception": null, "message": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }