{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 114, "name": "Street Signs", "type": "Table", "description": "The street signs are related to the street post. This table is used for creating work orders in Cityworks.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "post", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RelateID", "composite": false, "catalogID": "{B9A77B82-B726-4947-8BC3-7867E5CF1BD8}" } ], "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Project", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": { "type": "codedValue", "name": "Sign_type", "description": "Sign Type", "codedValues": [ { "name": "2 Way Traffic", "code": "2 Way Traffic" }, { "name": "20 Minute Limit", "code": "20 Minute Limit" }, { "name": "2hr Consecutive Parking", "code": "2hr Consecutive Parking" }, { "name": "2hr Parking", "code": "2hr Parking" }, { "name": "3- Way Stop", "code": "3- Way" }, { "name": "30 Minute Parking", "code": "30 Minute Parking" }, { "name": "Adopt a Street", "code": "Adopt a Street" }, { "name": "Advisory Speed", "code": "Advisory Speed" }, { "name": "Ahead", "code": "Ahead" }, { "name": "Arrow", "code": "Arrow" }, { "name": "Austic Child Area", "code": "Austic Child Area" }, { "name": "Authorized Vehicles Only", "code": "Authorized Vehicles Only" }, { "name": "Begin", "code": "Begin" }, { "name": "Begin Center Lane", "code": "Begin Center Lane" }, { "name": "Bike Route", "code": "Bike Route" }, { "name": "Bike Route Arrow", "code": "Bike Route Arrow" }, { "name": "Blind Child Area", "code": "Blind Child Area" }, { "name": "Boat Ramp", "code": "Boat Ramp" }, { "name": "Center Lane Tun Only", "code": "Center Lane Tun Only" }, { "name": "Chevron", "code": "Chevron" }, { "name": "Children at Play", "code": "Children at Play" }, { "name": "Circular Intersection", "code": "Circular Intersection" }, { "name": "City Limits", "code": "City Limits" }, { "name": "Clean up Pets", "code": "Clean up Pets" }, { "name": "Complementary Parking", "code": "Complementary Parking" }, { "name": "Crime Watch", "code": "Crime Watch" }, { "name": "Cross Street Symbol", "code": "Cross Street Symbol" }, { "name": "Cross Traffic Does Not Stop", "code": "Cross Traffic Does Not Stop" }, { "name": "Cross Walk", "code": "Cross Walk" }, { "name": "CSO", "code": "CSO" }, { "name": "Curve Arrow", "code": "Curve Arrow" }, { "name": "Dare", "code": "Dare" }, { "name": "Dead End", "code": "Dead End" }, { "name": "Deaf Child Area", "code": "Deaf Child Area" }, { "name": "Decorative 2hr Parking", "code": "Decorative 2hr Parking" }, { "name": "Deer Xing Symbol", "code": "Deer Xing Symbol" }, { "name": "Dileneator- Left", "code": "Dileneator- Left" }, { "name": "Dileneator- Right", "code": "Dileneator- Right" }, { "name": "Direction Arrows", "code": "Direction Arrows" }, { "name": "Divided Highway", "code": "Divided Highway" }, { "name": "Do Not Enter", "code": "Do Not Enter" }, { "name": "Do not Mow or Spray", "code": "Do not Mow or Spray" }, { "name": "Do Not Pass", "code": "Do Not Pass" }, { "name": "Double Arrow", "code": "Double Arrow" }, { "name": "Dual Turn Lane Arrow", "code": "Dual Turn Lane Arrow" }, { "name": "End", "code": "End" }, { "name": "End Center Lane", "code": "End Center Lane" }, { "name": "End Road Markers", "code": "End Road Markers" }, { "name": "End School Zone", "code": "End School Zone" }, { "name": "Fire Truck Symbol", "code": "Fire Truck Symbol" }, { "name": "Gateway", "code": "Gateway" }, { "name": "Golf Cart", "code": "Golf Cart" }, { "name": "Handicap Parking", "code": "Handicap Parking" }, { "name": "Hidden Drive", "code": "Hidden Drive" }, { "name": "High Water", "code": "High Water" }, { "name": "Historic Downtown", "code": "Historic Downtown" }, { "name": "Horse Xing", "code": "Horse Xing" }, { "name": "I69 Shield", "code": "I69 Shield" }, { "name": "Information", "code": "Information" }, { "name": "Keep Right", "code": "Keep Right" }, { "name": "Keep Right Arrow", "code": "Keep Right Arrow" }, { "name": "Kiosk", "code": "Kiosk" }, { "name": "Lane Control", "code": "Lane Control" }, { "name": "Left Lane Must Turn Left", "code": "Left Lane Must Turn Left" }, { "name": "Ln Ends Mrg Left", "code": "Ln Ends Mrg Left" }, { "name": "Ln Ends Mrg Right", "code": "Ln Ends Mrg Right" }, { "name": "Merging & Passing", "code": "Merging & Passing" }, { "name": "Narrow Bridge", "code": "Narrow Bridge" }, { "name": "Neighborhood Watch", "code": "Neighborhood Watch" }, { "name": "No Construction Parking", "code": "No Construction Parking" }, { "name": "No Handicap Access", "code": "No Handicap Access" }, { "name": "No Left Turn", "code": "No Left Turn" }, { "name": "No Motor Vehicles", "code": "No Motor Vehicles" }, { "name": "No Outlet", "code": "No Outlet" }, { "name": "No Parking", "code": "No Parking" }, { "name": "No Parking Between Signs", "code": "No Parking Between Signs" }, { "name": "No Parking Here to Corner", "code": "No Parking Here to Corner" }, { "name": "No Parking this side", "code": "No Parking this side" }, { "name": "No Passing Zone", "code": "No Passing Zone" }, { "name": "No Right Turn", "code": "No Right Turn" }, { "name": "No Soliciting", "code": "No Soliciting" }, { "name": "No Through Street", "code": "No Through Street" }, { "name": "No Trucks Symbol", "code": "No Trucks Symbol" }, { "name": "Object Markers", "code": "Object Markers" }, { "name": "One Way", "code": "One Way" }, { "name": "One Way Arrow- Lrg", "code": "One Way Arrow- Lrg" }, { "name": "One Way Arrow- Small", "code": "One Way Arrow- Small" }, { "name": "Parking w/ Arrow", "code": "Parking w/ Arrow" }, { "name": "Ped Xing Sign", "code": "Ped Xing Sign" }, { "name": "Ped Xing Symbol", "code": "Ped Xing Symbol" }, { "name": "Permit Parking", "code": "Permit Parking" }, { "name": "Preserve America", "code": "Preserve America" }, { "name": "Public Parking", "code": "Public Parking" }, { "name": "Railroad Xing", "code": "Railroad Xing" }, { "name": "Railroad Xing Rnd", "code": "Railroad Xing Rnd" }, { "name": "Reverse Curve", "code": "Reverse Curve" }, { "name": "Reverse Turn", "code": "Reverse Turn" }, { "name": "Right Lane Ends", "code": "Right Lane Ends" }, { "name": "Road Narrows", "code": "Road Narrows" }, { "name": "Rough Pavement Ahead", "code": "Rough Pavement Ahead" }, { "name": "Round-a-bout", "code": "Round-a-bout" }, { "name": "Round-a-bout Directional", "code": "Round-a-bout Directional" }, { "name": "Rt Lane Must Turn Right", "code": "Rt Lane Must Turn Right" }, { "name": "Rt Turn Only Arrow", "code": "Rt Turn Only Arrow" }, { "name": "Schl Bus Stop Ahead", "code": "Schl Bus Stop Ahead" }, { "name": "School Zone Arrow", "code": "School Zone Arrow" }, { "name": "School Zone Flasher", "code": "School Zone Flasher" }, { "name": "School Zone Sign", "code": "School Zone Sign" }, { "name": "Shared Street", "code": "Shared Street" }, { "name": "Sharp Curve", "code": "Sharp Curve" }, { "name": "Signal Ahead", "code": "Signal Ahead" }, { "name": "Signal Ahead Symbol", "code": "Signal Ahead Symbol" }, { "name": "Signs of significance", "code": "Signs of significance" }, { "name": "Slow Down Kids Playing", "code": "Slow Down" }, { "name": "Speed Cushion", "code": "Speed Cushion" }, { "name": "Speed Limit", "code": "Speed Limit" }, { "name": "Steve Wariner", "code": "Steve Wariner" }, { "name": "Stop", "code": "Stop" }, { "name": "Stop- All Way", "code": "Stop- All Way" }, { "name": "Stop- Four Way", "code": "Stop- Four Way" }, { "name": "Stop Ahead", "code": "Stop Ahead" }, { "name": "Stop Ahead Symbol", "code": "Stop Ahead Symbol" }, { "name": "Street ID", "code": "Street ID" }, { "name": "T- Street Symbol", "code": "T- Street Symbol" }, { "name": "To", "code": "To" }, { "name": "Warning Deep Water", "code": "Warning Deep Water" }, { "name": "Watch Ice Bridge", "code": "Watch Ice Bridge" }, { "name": "Waterway ID", "code": "Waterway ID" }, { "name": "Way Finder", "code": "Way Finder" }, { "name": "Weight Limit", "code": "Weight Limit" }, { "name": "Wrong Way", "code": "Wrong Way" }, { "name": "Yield", "code": "Yield" }, { "name": "Push Button", "code": "Push Button" }, { "name": "Trail Stop", "code": "Trail Stop" }, { "name": "Trail Mile Marker", "code": "Trail Mile Marker" }, { "name": "Trail Map", "code": "Trail Map" }, { "name": "Trail Rules", "code": "Trail Rules" }, { "name": "No U-Turn", "code": "No U-Turn" }, { "name": "Trail T", "code": "Trail T" }, { "name": "No Parking Both Sides", "code": "No Parking Both Sides" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Description" }, { "name": "MUTCD_TYPE", "type": "esriFieldTypeString", "alias": "MUTCD_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MUTCD_TYPE" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": { "type": "codedValue", "name": "Sign_Source", "description": "Source", "codedValues": [ { "name": "GPS", "code": "GPS" }, { "name": "Electronic Asbuilts", "code": "Electronic Asbuilts" }, { "name": "Cyvl AI", "code": "Cyvl AI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Source" }, { "name": "Install_Date", "type": "esriFieldTypeDate", "alias": "Install_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Install_Date" }, { "name": "Sign_size", "type": "esriFieldTypeString", "alias": "Sign_size", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Sign_size" }, { "name": "Sign_shape", "type": "esriFieldTypeString", "alias": "Sign_shape", "domain": { "type": "codedValue", "name": "Shape", "description": "Shape", "codedValues": [ { "name": "Rectangular", "code": "Rectangular" }, { "name": "Diamond", "code": "Diamond" }, { "name": "Circular", "code": "Circular" }, { "name": "Pennant", "code": "Pennant" }, { "name": "Square", "code": "Square" }, { "name": "Other", "code": "Other" }, { "name": "Octagon", "code": "Octagon" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Sign_shape" }, { "name": "Sign_condition", "type": "esriFieldTypeString", "alias": "Sign_condition", "domain": { "type": "codedValue", "name": "Condition", "description": "Condition", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Sign_condition" }, { "name": "Legend_Color", "type": "esriFieldTypeString", "alias": "Legend_Color", "domain": { "type": "codedValue", "name": "Legend Color", "description": "Legend Color", "codedValues": [ { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Green", "code": "Green" }, { "name": "Brown", "code": "Brown" }, { "name": "Purple", "code": "Purple" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Legend_Color" }, { "name": "Background", "type": "esriFieldTypeString", "alias": "Background", "domain": { "type": "codedValue", "name": "Background", "description": "Background Color", "codedValues": [ { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "FYG", "code": "FYG" }, { "name": "Green", "code": "Green" }, { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Yellow", "code": "Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Background" }, { "name": "Post_style", "type": "esriFieldTypeString", "alias": "Post_style", "domain": { "type": "codedValue", "name": "Post Style", "description": "Post Style", "codedValues": [ { "name": "Green Square", "code": "Green Square" }, { "name": "Round", "code": "Round" }, { "name": "Square", "code": "Square" }, { "name": "U-Channel", "code": "U-Channel" }, { "name": "Street Light", "code": "Street Light" }, { "name": "Traffic Signal", "code": "Traffic Signal" }, { "name": "2 Fluted Black Post", "code": "2 Fluted Black Post" }, { "name": "Black Square", "code": "Black Square" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Post_style" }, { "name": "Post_Condition", "type": "esriFieldTypeString", "alias": "Post_Condition", "domain": { "type": "codedValue", "name": "Condition", "description": "Condition", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Post_Condition" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "AssetID" }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LocationID" }, { "name": "Series", "type": "esriFieldTypeString", "alias": "Series", "domain": { "type": "codedValue", "name": "Series", "description": "Series", "codedValues": [ { "name": "Regulatory", "code": "Regulatory" }, { "name": "Warning", "code": "Warning" }, { "name": "Construction", "code": "Construction" }, { "name": "GUIDE", "code": "GUIDE" }, { "name": "School", "code": "School" }, { "name": "Street", "code": "Street" }, { "name": "Fire Safety", "code": "Fire Safety" }, { "name": "Industrial", "code": "Industrial" }, { "name": "ID", "code": "ID" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Railroad", "code": "Railroad" }, { "name": "OSHA", "code": "OSHA" }, { "name": "Traffic Prohibition", "code": "Traffic Prohibition" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Series" }, { "name": "Speed", "type": "esriFieldTypeSmallInteger", "alias": "Speed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed" }, { "name": "Date_Mapped", "type": "esriFieldTypeDate", "alias": "Date_Mapped", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Mapped" }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Route" }, { "name": "Dir_Travel", "type": "esriFieldTypeString", "alias": "Dir_Travel", "domain": { "type": "codedValue", "name": "Dir_Travel", "description": "Dir_Travel", "codedValues": [ { "name": "NB", "code": "NB" }, { "name": "SB", "code": "SB" }, { "name": "WB", "code": "WB" }, { "name": "EB", "code": "EB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Dir_Travel" }, { "name": "Side_Rd", "type": "esriFieldTypeString", "alias": "Side_Rd", "domain": { "type": "codedValue", "name": "Side", "description": "Side of Road", "codedValues": [ { "name": "Left", "code": "Left" }, { "name": "Right", "code": "Right" }, { "name": "Center", "code": "Center" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Side_Rd" }, { "name": "Lat_Offset", "type": "esriFieldTypeSmallInteger", "alias": "Lat_Offset", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lat_Offset" }, { "name": "Height", "type": "esriFieldTypeSmallInteger", "alias": "Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Height" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Comments" }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Hyperlink" }, { "name": "RelateID", "type": "esriFieldTypeString", "alias": "RelateID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RelateID" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "Field_ID", "type": "esriFieldTypeSmallInteger", "alias": "Field_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Field_ID" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Owner" } ], "indexes": [ { "name": "R129_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "GDB_190_RelateID", "isAscending": true, "isUnique": false, "description": "", "fields": "RelateID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Street Signs", "description": "", "prototype": { "attributes": { "Field_ID": null, "Owner": null, "Project": null, "Description": null, "MUTCD_TYPE": null, "Source": null, "Install_Date": null, "Sign_size": null, "Sign_shape": null, "Sign_condition": null, "Legend_Color": null, "Background": null, "Post_style": null, "Post_Condition": null, "AssetID": null, "LocationID": null, "Series": null, "Speed": null, "Date_Mapped": null, "Route": null, "Dir_Travel": null, "Side_Rd": null, "Lat_Offset": null, "Height": null, "Comments": null, "Hyperlink": null, "RelateID": null, "WarrantyDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d206e06458574946b1801aa370dbee58" }