{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "SDE.GISADMIN.Forsyth_MasterStreets", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PRE", "type": "esriFieldTypeString", "alias": "Directional Prefix", "length": 2, "domain": { "type": "codedValue", "name": "WS2_Street_Dir", "description": "Street Direction", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Road Name", "length": 30, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 2, "domain": { "type": "codedValue", "name": "WS2_Short_Road_Type_1_1_1", "description": "", "codedValues": [ { "name": "Unassigned", "code": "NA" }, { "name": "Alley", "code": "AL" }, { "name": "Avenue", "code": "AV" }, { "name": "Boulevard", "code": "BV" }, { "name": "Commons", "code": "CM" }, { "name": "Court", "code": "CT" }, { "name": "Cove", "code": "CV" }, { "name": "Drive", "code": "DR" }, { "name": "Expressway", "code": "EX" }, { "name": "Highway", "code": "HI" }, { "name": "Landing", "code": "LD" }, { "name": "Lane", "code": "LN" }, { "name": "Loop", "code": "LP" }, { "name": "Manor", "code": "MR" }, { "name": "Park", "code": "PA" }, { "name": "Path", "code": "PH" }, { "name": "Place", "code": "PL" }, { "name": "Plaza", "code": "PZ" }, { "name": "Ramp", "code": "RA" }, { "name": "Ridge", "code": "RG" }, { "name": "Road", "code": "RD" }, { "name": "Run", "code": "RN" }, { "name": "Square", "code": "SQ" }, { "name": "Street", "code": "ST" }, { "name": "Trail", "code": "TL" }, { "name": "Way", "code": "WY" }, { "name": "Circle", "code": "CR" }, { "name": "Crossing", "code": "CG" }, { "name": "Parkway", "code": "PW" }, { "name": "Row", "code": "RW" }, { "name": "Terrace", "code": "TR" }, { "name": "Trace", "code": "TC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POSTTYPE", "type": "esriFieldTypeString", "alias": "POSTTYPE", "length": 4, "domain": { "type": "codedValue", "name": "WS2_Road_Type_1", "description": "", "codedValues": [ { "name": "Unassigned", "code": "NA" }, { "name": "Alley", "code": "ALY" }, { "name": "Avenue", "code": "AVE" }, { "name": "Boulevard", "code": "BLVD" }, { "name": "Commons", "code": "CMNS" }, { "name": "Crossing", "code": "XING" }, { "name": "Circle", "code": "CIR" }, { "name": "Court", "code": "CT" }, { "name": "Cove", "code": "CV" }, { "name": "Drive", "code": "DR" }, { "name": "Expressway", "code": "EXPY" }, { "name": "Highway", "code": "HWY" }, { "name": "Landing", "code": "LNDG" }, { "name": "Lane", "code": "LN" }, { "name": "Loop", "code": "LOOP" }, { "name": "Manor", "code": "MNR" }, { "name": "Park", "code": "PARK" }, { "name": "Parkway", "code": "PKWY" }, { "name": "Path", "code": "PATH" }, { "name": "Place", "code": "PL" }, { "name": "Plaza", "code": "PLZ" }, { "name": "Ramp", "code": "RAMP" }, { "name": "Ridge", "code": "RDG" }, { "name": "Road", "code": "RD" }, { "name": "Row", "code": "ROW" }, { "name": "Run", "code": "RUN" }, { "name": "Square", "code": "SQ" }, { "name": "Street", "code": "ST" }, { "name": "Trace", "code": "TRCE" }, { "name": "Trail", "code": "TRL" }, { "name": "Terrace", "code": "TER" }, { "name": "Way", "code": "WAY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STNAME", "type": "esriFieldTypeString", "alias": "Complete Road Name", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeSmallInteger", "alias": "STATUS", "domain": { "type": "codedValue", "name": "WS2_Road_Status", "description": "", "codedValues": [ { "name": "Unassigned", "code": 0 }, { "name": "Platted", "code": 1 }, { "name": "Unbuilt", "code": 2 }, { "name": "Existing", "code": 3 }, { "name": "Abandoned", "code": 4 }, { "name": "Closed", "code": 5 }, { "name": "Trail", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DELETEFLAG", "type": "esriFieldTypeString", "alias": "Delete Flag", "length": 1, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Description", "length": 1000, "domain": null }, { "name": "EOB", "type": "esriFieldTypeString", "alias": "EOB", "length": 2, "domain": null }, { "name": "MAPGRID", "type": "esriFieldTypeString", "alias": "Map Grid", "length": 6, "domain": null }, { "name": "DEVELOPNAME", "type": "esriFieldTypeString", "alias": "Development Name", "length": 50, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 1000, "domain": null }, { "name": "STDELFLAG", "type": "esriFieldTypeString", "alias": "Delete Flag", "length": 1, "domain": null }, { "name": "REJECTNOTES", "type": "esriFieldTypeString", "alias": "Reject Notes", "length": 1000, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "STATUS_MAD", "type": "esriFieldTypeString", "alias": "Status From MAD", "length": 2, "domain": null }, { "name": "MAD_CONVERTED", "type": "esriFieldTypeSmallInteger", "alias": "MAD_CONVERTED", "domain": null }, { "name": "Plan_Review_Nbr", "type": "esriFieldTypeString", "alias": "Plan_Review_Nbr", "length": 7, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R5801_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_5801", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_5801", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }