{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 49, "name": "GIS_", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GIS_.GIS_.Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GIS_.OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "GIS_.ID", "type": "esriFieldTypeString", "alias": "ID", "length": 255, "domain": null }, { "name": "GIS_.Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "GIS_.County", "type": "esriFieldTypeString", "alias": "County", "length": 255, "domain": null }, { "name": "GIS_.Note", "type": "esriFieldTypeString", "alias": "Note", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID_1", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.County_Name", "type": "esriFieldTypeString", "alias": "County_Name", "length": 50, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Acreage", "type": "esriFieldTypeDouble", "alias": "Acreage", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.OwnerName", "type": "esriFieldTypeString", "alias": "OwnerName", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.OwnerType", "type": "esriFieldTypeString", "alias": "OwnerType", "length": 30, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.StreetAddress", "type": "esriFieldTypeString", "alias": "StreetAddress", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.State", "type": "esriFieldTypeString", "alias": "State", "length": 20, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 20, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.isActive", "type": "esriFieldTypeSmallInteger", "alias": "isActive", "domain": { "type": "codedValue", "name": "WS2_NPPD_IsActive", "description": "Active", "codedValues": [ { "name": "Inactive", "code": 0 }, { "name": "Active", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.ROE_Status", "type": "esriFieldTypeSmallInteger", "alias": "ROE_Status", "domain": { "type": "codedValue", "name": "WS2_NPPD_ROE_Status", "description": "OPPD_ROE_Status", "codedValues": [ { "name": "No Access", "code": 4 }, { "name": "No Activity", "code": 0 }, { "name": "ROE In Progress", "code": 1 }, { "name": "ROE Obtained", "code": 2 }, { "name": "Existing Easement, Notification Made", "code": 3 }, { "name": "ROE with Conditions", "code": 5 }, { "name": "ROE Not Needed", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.ParcelStatus", "type": "esriFieldTypeSmallInteger", "alias": "ParcelStatus", "domain": { "type": "codedValue", "name": "WS2_NPPD_Parcel_Status", "description": "OPPD_Parcel_Status", "codedValues": [ { "name": "No Activity", "code": 0 }, { "name": "Title received", "code": 1 }, { "name": "Survey received", "code": 2 }, { "name": "Appraisal received", "code": 3 }, { "name": "Easement signed", "code": 5 }, { "name": "Easement recorded", "code": 7 }, { "name": "Cert of Comp recorded", "code": 8 }, { "name": "Final mailing", "code": 9 }, { "name": "OPPD Property", "code": 20 }, { "name": "Prepare Final Offer Letter", "code": 12 }, { "name": "Easement package posted", "code": 4 }, { "name": "Easement paid", "code": 6 }, { "name": "Easement rejected", "code": 10 }, { "name": "Easement package presented to owner", "code": 11 }, { "name": "Double Circuit - No Easement", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.ROE_Condition", "type": "esriFieldTypeString", "alias": "ROE_Condition", "length": 250, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Documents", "type": "esriFieldTypeString", "alias": "Documents", "length": 800, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Tracking_Number", "type": "esriFieldTypeString", "alias": "Tracking_Number", "length": 50, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Assessor_Parcel_Number", "type": "esriFieldTypeString", "alias": "Assessor_Parcel_Number", "length": 50, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.County_FIPS", "type": "esriFieldTypeString", "alias": "County_FIPS", "length": 50, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SitusAddress", "type": "esriFieldTypeString", "alias": "SitusAddress", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.HOA", "type": "esriFieldTypeString", "alias": "HOA", "length": 80, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.ROW_Agent", "type": "esriFieldTypeString", "alias": "ROW_Agent", "length": 50, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.CADASTRAL", "type": "esriFieldTypeString", "alias": "CADASTRAL", "length": 30, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.PARCEL", "type": "esriFieldTypeString", "alias": "PARCEL", "length": 200, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 30, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.ownername1", "type": "esriFieldTypeString", "alias": "ownername1", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.ownername2", "type": "esriFieldTypeString", "alias": "ownername2", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.owneraddre", "type": "esriFieldTypeString", "alias": "owneraddre", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.owneradd_1", "type": "esriFieldTypeString", "alias": "owneradd_1", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.mailcity", "type": "esriFieldTypeString", "alias": "mailcity", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.mailstate", "type": "esriFieldTypeString", "alias": "mailstate", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.mailzip", "type": "esriFieldTypeString", "alias": "mailzip", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SitusAddre", "type": "esriFieldTypeString", "alias": "SitusAddre", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.BuildingVa", "type": "esriFieldTypeDouble", "alias": "BuildingVa", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Improvemen", "type": "esriFieldTypeDouble", "alias": "Improvemen", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.LandValue", "type": "esriFieldTypeDouble", "alias": "LandValue", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.LegalSecti", "type": "esriFieldTypeDouble", "alias": "LegalSecti", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.LegalTowns", "type": "esriFieldTypeDouble", "alias": "LegalTowns", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.LegalRange", "type": "esriFieldTypeDouble", "alias": "LegalRange", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.LegalAcres", "type": "esriFieldTypeDouble", "alias": "LegalAcres", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SaleBook", "type": "esriFieldTypeString", "alias": "SaleBook", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SalePage", "type": "esriFieldTypeString", "alias": "SalePage", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SaleDate", "type": "esriFieldTypeDouble", "alias": "SaleDate", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SaleAmount", "type": "esriFieldTypeDouble", "alias": "SaleAmount", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.LegalDescr", "type": "esriFieldTypeString", "alias": "LegalDescr", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Township", "type": "esriFieldTypeString", "alias": "Township", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Subdivisio", "type": "esriFieldTypeString", "alias": "Subdivisio", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.District", "type": "esriFieldTypeDouble", "alias": "District", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Neighborho", "type": "esriFieldTypeDouble", "alias": "Neighborho", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.AssessorLo", "type": "esriFieldTypeDouble", "alias": "AssessorLo", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.SchoolCode", "type": "esriFieldTypeString", "alias": "SchoolCode", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.YearBuilt", "type": "esriFieldTypeDouble", "alias": "YearBuilt", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.CadastralP", "type": "esriFieldTypeString", "alias": "CadastralP", "length": 254, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Email", "type": "esriFieldTypeString", "alias": "Email", "length": 10, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.PublicMeeting", "type": "esriFieldTypeString", "alias": "PublicMeeting", "length": 10, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Adjacent", "type": "esriFieldTypeString", "alias": "Adjecent", "length": 15, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Acres", "type": "esriFieldTypeDouble", "alias": "Acres", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.OCity", "type": "esriFieldTypeString", "alias": "OCity", "length": 30, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Owner_Address", "type": "esriFieldTypeString", "alias": "Owner_Address", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.AgentContact", "type": "esriFieldTypeString", "alias": "AgentContact", "length": 50, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.FieldNotes", "type": "esriFieldTypeString", "alias": "FieldNotes", "length": 1000, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.Relo_Status", "type": "esriFieldTypeSmallInteger", "alias": "Relo_Status", "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "NPPD_ROW.DBO.NPPD_Parcels.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "GIS_.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R15_pk", "fields": "NPPD_ROW.DBO.NPPD_Parcels.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_15", "fields": "NPPD_ROW.DBO.NPPD_Parcels.GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }