{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 62, "name": "pwSignFeatures", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "Created_Date", "creatorField": "Created_User", "editDateField": "Edited_Date", "editorField": "Edited_User" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 15, "name": "GIS_Projects.GISSERVICE.PW_Signs", "relatedTableId": 44, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID_Main", "composite": false, "catalogID": "{EDF2648D-A284-48D4-B59F-FBE86FFDFB30}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "STREET_BLADE_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "domain": { "type": "codedValue", "name": "snSIGN_FEATURE", "description": "Sign Features", "codedValues": [ { "name": "Sign", "code": "Sign" }, { "name": "Street Blade", "code": "Street Blade" }, { "name": "Pole", "code": "Pole" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TYPE" }, { "name": "FEATURE", "type": "esriFieldTypeString", "alias": "FEATURE DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FEATURE" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "domain": { "type": "codedValue", "name": "snCONDITION", "description": "Condition", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Poor", "code": "Poor" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Replace", "code": "Replace" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONDITION" }, { "name": "SIGN_COMMENTS", "type": "esriFieldTypeString", "alias": "SIGN COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_COMMENTS" }, { "name": "SIGN_GROUP", "type": "esriFieldTypeString", "alias": "SIGN GROUP", "domain": { "type": "codedValue", "name": "snSIGN_GROUP", "description": "Sign Group", "codedValues": [ { "name": "Regulatory", "code": "Regulatory" }, { "name": "Warning", "code": "Warning" }, { "name": "Property", "code": "Property" }, { "name": "Parking Signs", "code": "ParkingSigns" }, { "name": "Railroad", "code": "Railroad" }, { "name": "School Zone", "code": "SchoolZone" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_GROUP" }, { "name": "SHEET_TYPE", "type": "esriFieldTypeString", "alias": "SHEET TYPE", "domain": { "type": "codedValue", "name": "snSIGN_SHEET_TYPE", "description": "Sign Sheet Type", "codedValues": [ { "name": "Type I (Engineer Grade)", "code": "Type I (Engineer Grade)" }, { "name": "Type II (Super Engineer Grade)", "code": "Type II (Super Engineer Grade)" }, { "name": "Type III (High Intensity)", "code": "Type III (High Intensity)" }, { "name": "Type IV (Multi-Layer Sheeting)", "code": "Type IV (Multi-Layer Sheeting)" }, { "name": "Type V (Metallized Microprismatic)", "code": "Type V (Metallized Microprismatic)" }, { "name": "Type VI (Vinyl Backed Microprismatic)", "code": "Type VI (Vinyl Backed Microprismatic)" }, { "name": "Type VII (Microprismatic)", "code": "Type VII (Microprismatic)" }, { "name": "Type VIII (Microprismatic- Distinguishing)", "code": "Type VIII (Microprismatic- Distinguishing)" }, { "name": "Type IX (Fine Grain Microprisms)", "code": "Type IX (Fine Grain Microprisms)" }, { "name": "Type X (Microprismatic - Similar to Types VII-IX)", "code": "Type X (Microprismatic - Similar to Types VII-IX)" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SHEET_TYPE" }, { "name": "SIGN_HEIGHT", "type": "esriFieldTypeInteger", "alias": "SIGN HEIGHT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SIGN_HEIGHT" }, { "name": "SIGN_WIDTH", "type": "esriFieldTypeInteger", "alias": "SIGN WIDTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SIGN_WIDTH" }, { "name": "SPEED_LIMIT", "type": "esriFieldTypeString", "alias": "SPEED LIMIT", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SPEED_LIMIT" }, { "name": "GUID_Main", "type": "esriFieldTypeGUID", "alias": "GUID Main", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID_Main" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "TYPE_OF_SIGN", "type": "esriFieldTypeString", "alias": "SIGN TYPE", "domain": { "type": "codedValue", "name": "snSIGN_TYPE", "description": "Sign Type", "codedValues": [ { "name": "4 WAY", "code": "4 WAY" }, { "name": "Adopt a Street", "code": "Adopt a Street" }, { "name": "AHEAD", "code": "AHEAD" }, { "name": "ALCOHOL PROHIBITED", "code": "ALCOHOL PROHIBITED" }, { "name": "ALL WAY", "code": "ALL WAY" }, { "name": "ANIMALS NOT ALLOWED", "code": "ANIMALS NOT ALLOWED" }, { "name": "AUTHORIZED VEHICLES", "code": "AUTHORIZED VEHICLES" }, { "name": "BEWARE OF SNAKES", "code": "BEWARE OF SNAKES" }, { "name": "BICYCLE SIGNS", "code": "BICYCLE SIGNS" }, { "name": "CALL 911 FOR EMERGENCY", "code": "CALL 911 FOR EMERGENCY" }, { "name": "CHEVRON", "code": "CHEVRON" }, { "name": "CHURCH", "code": "CHURCH" }, { "name": "CITY LIMITS", "code": "CITY LIMITS" }, { "name": "CITY PARK HOURS", "code": "CITY PARK HOURS" }, { "name": "CRIME WATCH ZONE", "code": "CRIME WATCH ZONE" }, { "name": "CURVE LEFT", "code": "CURVE LEFT" }, { "name": "DEAD END", "code": "DEAD END" }, { "name": "DIAGONAL ARROW", "code": "DIAGONAL ARROW" }, { "name": "DIP AHEAD", "code": "DIP AHEAD" }, { "name": "DO NOT BLOCK DRIVEWAY", "code": "DO DO NOT BLOCK DRIVEWAY" }, { "name": "DO NOT DRIVE ON TRACKS", "code": "DO NOT DRIVE ON TRACKS" }, { "name": "DO NOT ENTER", "code": "DO NOT ENTER" }, { "name": "DO NOT PASS", "code": "DO NOT PASS" }, { "name": "DO NOT STOP ON TRACKS", "code": "DO NOT STOP ON TRACKS" }, { "name": "DOWNWARD DIAGONAL ARROW", "code": "DOWNWARD DIAGONAL ARROW" }, { "name": "DUCK CROSSING", "code": "DUCK CROSSING" }, { "name": "EMPLOYEE PARKING ONLY", "code": "EMPLOYEE PARKING ONLY" }, { "name": "END SCHOOL ZONE", "code": "END SCHOOL ZONE" }, { "name": "ENTER", "code": "ENTER" }, { "name": "EXIT", "code": "EXIT" }, { "name": "FASTEN SEATBELT", "code": "FASTEN SEATBELT" }, { "name": "FIRE DEPARTMENT", "code": "FIRE DEPARTMENT" }, { "name": "FISHING LIMIT", "code": "FISHING LIMIT" }, { "name": "GOLF CROSSING", "code": "GOLF CROSSING" }, { "name": "GRADE CROSSING (CROSSBUCK)", "code": "GRADE CROSSING (CROSSBUCK)" }, { "name": "GRADE CROSSING ADVANCE CROSSING", "code": "GRADE CROSSING ADVANCE CROSSING" }, { "name": "HANDICAPPED PARKING", "code": "HANDICAPPED PARKING" }, { "name": "HIDE LOCK TAKE", "code": "HIDE LOCK TAKE" }, { "name": "HIGH WATER", "code": "HIGH WATER" }, { "name": "HOSPITAL", "code": "HOSPITAL" }, { "name": "KEEP CORINTH BEAUTIFUL", "code": "KEEP CORINTH BEAUTIFUL" }, { "name": "KEEP LEFT", "code": "KEEP LEFT" }, { "name": "KEEP RIGHT", "code": "KEEP RIGHT" }, { "name": "LANE ENDS LEFT", "code": "LANE ENDS LEFT" }, { "name": "LANE ENDS MERGE RIGHT", "code": "LANE ENDS MERGE RIGHT" }, { "name": "LEFT LANE MUST TURN LEFT", "code": "LEFT LANE MUST TURN LEFT" }, { "name": "LIFT STATION SIGN", "code": "LIFT STATION SIGN" }, { "name": "MEN'S RESTROOM", "code": "MEN'S RESTROOM" }, { "name": "NEIGHBORHOOD WATCH", "code": "NEIGHBORHOOD WATCH" }, { "name": "NO DUMPING", "code": "NO DUMPING" }, { "name": "NO LEFT TURN", "code": "NO LEFT TURN" }, { "name": "NO OUTLET", "code": "NO OUTLET" }, { "name": "NO PARKING", "code": "NO PARKING" }, { "name": "No Pets / Animals not Allowed", "code": "No Pets / Animals not Allowed" }, { "name": "NO PETS ALLOWED", "code": "NO PETS ALLOWED" }, { "name": "NO RIGHT TURN", "code": "NO RIGHT TURN" }, { "name": "NO SMOKING", "code": "NO SMOKING" }, { "name": "NO SWIMMING OR WATERCRAFT", "code": "NO SWIMMING OR WATERCRAFT" }, { "name": "NO TRAIN HORN", "code": "NO TRAIN HORN" }, { "name": "NO TRUCKS", "code": "NO TRUCKS" }, { "name": "NO U TURN", "code": "NO U TURN" }, { "name": "OBJECT MARKER LEFT", "code": "OBJECT MARKER LEFT" }, { "name": "OBJECT MARKER RIGHT", "code": "OBJECT MARKER RIGHT" }, { "name": "ONE WAY", "code": "ONE WAY" }, { "name": "OTHER", "code": "OTHER" }, { "name": "PEDESTRIAN CROSSING", "code": "PEDESTRIAN CROSSING" }, { "name": "PET WASTE", "code": "PET WASTE" }, { "name": "RAILROAD WARNING", "code": "RAILROAD WARNING" }, { "name": "REDUCED SCHOOL SPEED LIMIT AHEAD", "code": "REDUCED SCHOOL SPEED LIMIT AHEAD" }, { "name": "REVERSE TURN LEFT(RIGHT)", "code": "REVERSE TURN LEFT(RIGHT)" }, { "name": "ROAD MAY FLOOD", "code": "ROAD MAY FLOOD" }, { "name": "S CURVE", "code": "S CURVE" }, { "name": "SCHOOL BUS STOP AHEAD", "code": "SCHOOL BUS STOP AHEAD" }, { "name": "SCHOOL CROSSING", "code": "SCHOOL CROSSING" }, { "name": "SCHOOL SPEED LIMIT WITH TIMES OF DAY", "code": "SCHOOL SPEED LIMIT WITH TIMES OF DAY" }, { "name": "SCHOOL ZONE AHEAD", "code": "SCHOOL ZONE AHEAD" }, { "name": "SIDE ROAD", "code": "SIDE ROAD" }, { "name": "SLOW", "code": "SLOW" }, { "name": "SLOW CHILDREN AT PLAY", "code": "SLOW CHILDREN AT PLAY" }, { "name": "SPEED HUMP", "code": "SPEED HUMP" }, { "name": "SPEED LIMIT", "code": "SPEED LIMIT" }, { "name": "STOP AHEAD", "code": "STOP AHEAD" }, { "name": "STOP HERE WHEN FLASHING", "code": "STOP HERE WHEN FLASHING" }, { "name": "STOP SIGN", "code": "STOP SIGN" }, { "name": "STREET NAME BLADE", "code": "STREET NAME BLADE" }, { "name": "SUPERIOR WATER", "code": "SUPERIOR WATER" }, { "name": "SUPPLEMENTAL LEFT", "code": "SUPPLEMENTAL LEFT" }, { "name": "THREE STAR COMMUNITY", "code": "THREE STAR COMMUNITY" }, { "name": "TOBACCO FREE FACILITY", "code": "TOBACCO FREE FACILITY" }, { "name": "TOW AWAY ZONE", "code": "TOW AWAY ZONE" }, { "name": "TREE CITY", "code": "TREE CITY" }, { "name": "TURN LEFT", "code": "TURN LEFT" }, { "name": "VISITOR PARKING", "code": "VISITOR PARKING" }, { "name": "WATCH FOR", "code": "WATCH FOR" }, { "name": "WATERSHED", "code": "WATERSHED" }, { "name": "WOMEN RESTROOM", "code": "WOMEN RESTROOM" }, { "name": "WRONG WAY", "code": "WRONG WAY" }, { "name": "XXX FEET", "code": "XXX FEET" }, { "name": "YIELD", "code": "YIELD" }, { "name": "RIGHT TURN ONLY", "code": "RIGHT TURN ONLY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TYPE_OF_SIGN" }, { "name": "STREET_BLADE_NAME", "type": "esriFieldTypeString", "alias": "STREET BLADE NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STREET_BLADE_NAME" }, { "name": "Created_User", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Created_User" }, { "name": "Created_Date", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Created_Date" }, { "name": "Edited_User", "type": "esriFieldTypeString", "alias": "Edited User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Edited_User" }, { "name": "Edited_Date", "type": "esriFieldTypeDate", "alias": "Edited Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Edited_Date" } ], "indexes": [ { "name": "R92_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_92", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G145GUID_Main", "fields": "GUID_Main", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_92", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "pwSignFeatures", "description": "", "prototype": { "attributes": { "TYPE_OF_SIGN": null, "STREET_BLADE_NAME": null, "TYPE": null, "FEATURE": null, "CONDITION": null, "SIGN_COMMENTS": null, "SIGN_GROUP": null, "SHEET_TYPE": null, "SIGN_HEIGHT": null, "SIGN_WIDTH": null, "SPEED_LIMIT": null, "GUID_Main": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 7000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 7000, "maxRecordCountFactor": 1, "serviceItemId": "ac96d47704f94db0b89dff1b6483136e" }