{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "ROWAcqParcelsTable", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OWNER_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCEL_NUMBER", "type": "esriFieldTypeString", "alias": "PARCEL#", "length": 255, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 255, "domain": null }, { "name": "Property_Address", "type": "esriFieldTypeString", "alias": "Property Address", "length": 255, "domain": null }, { "name": "OWNER_NAME", "type": "esriFieldTypeString", "alias": "Owner's Name", "length": 255, "domain": null }, { "name": "MAILING_ADDRESS", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 255, "domain": null }, { "name": "ALL_INTEREST_HOLDERS", "type": "esriFieldTypeString", "alias": "Interest Holders", "length": 255, "domain": null }, { "name": "INTEREST_HOLDER_ADDRESS", "type": "esriFieldTypeString", "alias": "Interest Holder Address", "length": 255, "domain": null }, { "name": "EASEMENT_RECORDED", "type": "esriFieldTypeString", "alias": "Easement Recorded", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PE", "type": "esriFieldTypeString", "alias": "Permanent Easement", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TE", "type": "esriFieldTypeString", "alias": "Temporary Easement", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EXISTING__HIGHWAY__R_W___ACRES_", "type": "esriFieldTypeDouble", "alias": "Existing Hwy ROW (acres)", "domain": null }, { "name": "ADDITIONAL__HIGHWAY__R_W___ACRE", "type": "esriFieldTypeDouble", "alias": "Additional Hwy ROW (acres)", "domain": null }, { "name": "TOTAL__HIGHWAY__R_W___ACRES_", "type": "esriFieldTypeDouble", "alias": "Total Hwy ROW (acres)", "domain": null }, { "name": "TOTAL_TE_ACRES_NEEDED", "type": "esriFieldTypeDouble", "alias": "Total Temp Easement Needed (acres)", "domain": null }, { "name": "TITLE_WORK_RECEIVED", "type": "esriFieldTypeString", "alias": "Title Work Recieved", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EARLY_NOTIFICATION_LETTER_SENT", "type": "esriFieldTypeString", "alias": "EARLY NOTIFICATION LETTER SENT", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Permanent_Easement_Offer_Value", "type": "esriFieldTypeDouble", "alias": "Permanen_Easement_Offer_Value", "domain": null }, { "name": "Permanent_Easement_Damages", "type": "esriFieldTypeDouble", "alias": "Permanent_Easement_Damages", "domain": null }, { "name": "Temporary_Easement_Offer_Value", "type": "esriFieldTypeDouble", "alias": "Temporary_Easement_Offer_Value", "domain": null }, { "name": "Temporary_Easement_Damages", "type": "esriFieldTypeDouble", "alias": "Temporary_Easement_Damages", "domain": null }, { "name": "Total_PE_TE_Cost", "type": "esriFieldTypeDouble", "alias": "Total PE and TE Cost", "domain": null }, { "name": "APPRAISAL_RECEIVED", "type": "esriFieldTypeString", "alias": "APPRAISAL_RECEIVED", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REVIEW_APPR_DATE", "type": "esriFieldTypeDate", "alias": "Review Appraisal Date", "length": 8, "domain": null }, { "name": "OFFER_LETTER_ACCEPTED", "type": "esriFieldTypeString", "alias": "OFFER_LETTER_ACCEPTED", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDEMNATION", "type": "esriFieldTypeString", "alias": "CONDEMNATION", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HEARING_ON_PETITION", "type": "esriFieldTypeString", "alias": "Hearing on Petition", "length": 255, "domain": null }, { "name": "Escrow_Deposit_Amount", "type": "esriFieldTypeDouble", "alias": "Excrow Deposit Amount", "domain": null }, { "name": "ESCROW_DEPOSIT_DATE", "type": "esriFieldTypeDate", "alias": "Escrow Deposit Date", "length": 8, "domain": null }, { "name": "TITLE_AND_POSESSION", "type": "esriFieldTypeString", "alias": "Title and Possesion", "length": 255, "domain": null }, { "name": "COURT_FILE_NAME", "type": "esriFieldTypeString", "alias": "Court File Name", "length": 255, "domain": null }, { "name": "COURT_FILE_NUMBER", "type": "esriFieldTypeString", "alias": "Court File Number", "length": 255, "domain": null }, { "name": "PETITION_DATE", "type": "esriFieldTypeDate", "alias": "Petition Date", "length": 8, "domain": null }, { "name": "NOTICE_OF_INTENT_MAILED", "type": "esriFieldTypeString", "alias": "Notice of Intent Mailed", "length": 255, "domain": null }, { "name": "CERT__MAIL_CARD_RECVD_", "type": "esriFieldTypeString", "alias": "Cert Mail Card Recieved", "length": 255, "domain": null }, { "name": "NOTICE_TO_RESP_SERVED_BY", "type": "esriFieldTypeString", "alias": "Notice to Respond Served By", "length": 255, "domain": null }, { "name": "ACKNOWLEDGEMENT_RECVD_", "type": "esriFieldTypeString", "alias": "Acknowledgement Recvd", "length": 255, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "DocumentPath", "type": "esriFieldTypeString", "alias": "DocumentPath", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R2623_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "TitleWork", "fields": "TITLE_WORK_RECEIVED", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ROWAcqParcels", "fields": "PIN", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2623", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ROWAcqParcels", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PIN", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "727df47fe3f5403d967a5ece15b79aba" }